10046的部分內容如下﹕
INSERT INTO BD_SA@ABCDE.COM.CN(ARTIC_CODE,
BOM_VER,ITEM_NO,VER_YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,SAME_MK,INPUT_CD,
SEMI_CD,POLICY,IS_PROCESS,IS_PACK,UP_PROCESS,MK_KNIFE,IS_WORK,IS_REQ,
REPAIR_MK,COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,RATE_SORT,TG_MK,
PROC_PART,VSM_FLG,PRICE,MOD_PLAN,PMOD_DATE,MOD_CUS,CMOD_DATE,MOD_MAT,
MMOD_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,SUP_CODE,CUT_CODE,
PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO) WITH RS1 AS(SELECT
/*+index(a2 PK_DV_BOMS) */ ARTIC_CODE,TO_NUMBER(BOM_VER) BOM_VER,
TO_NUMBER(ITEM_NO) ITEM_NO,SUBSTR(YYMM,1,6) YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,
SAME_MK,INPUT_CD,NVL(SEMI_CD,' ') SEMI_CD, POLICY,IS_PROCESS,IS_PACK,
NVL(UP_PROCESS,'N') UP_PROCESS,NVL(MK_KNIFE,'N') MK_KNIFE,IS_WORK,IS_REQ,
REPAIR_MK,NVL(COMPUT_TYPE,1) COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,
RATE_SORT,TG_MK,PROC_PART,VSM_PHASE,PRICE,PLAN_BY,PLAN_DATE,CUSTOMS_BY,
CUSTOMS_DATE,MAT_BY,MAT_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,
SUPPLE_CODE,CUT_CODE,PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO
FROM SY_BOMS A2 WHERE ARTIC_CODE=:B3 AND BOM_VER=:B2 AND ITEM_NO=:B1 )
SELECT ARTIC_CODE,BOM_VER,ITEM_NO,YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,SAME_MK,
INPUT_CD,SEMI_CD, POLICY,IS_PROCESS,IS_PACK,UP_PROCESS,MK_KNIFE,IS_WORK,
IS_REQ,REPAIR_MK,COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,RATE_SORT,TG_MK,
PROC_PART,VSM_PHASE,PRICE,PLAN_BY,PLAN_DATE,CUSTOMS_BY,CUSTOMS_DATE,MAT_BY,
MAT_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,SUPPLE_CODE,CUT_CODE,
PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO FROM RS1
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 553 440.98 506.43 13062 6953986 0 553
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 554 440.98 506.43 13062 6953986 0 553
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 112 (recursive depth: 1)
SELECT /*+ OPAQUE_TRANSFORM INDEX ("A2" "PK_DV_BOMS") */ "ARTIC_CODE",
"BOM_VER","ITEM_NO","SUPPLE_CODE","ITEM_ORDER","PART_NO","MAT_NO",
"CUT_CODE","SAME_MK","INPUT_CD","SEMI_CD","POLICY","IS_PACK","IS_PROCESS",
"PROCESS_CODE","MK_KNIFE","IS_WORK","IS_REQ","REPAIR_MK","COMPUT_TYPE",
"CREATED_BY","CREATED_DATE","MOD_BY","MOD_DATE","D_WEIT","STANDARD_QTY",
"WASTE_PC","RATE_SORT","TG_MK","PROC_PART","PRICE","PLAN_BY","PLAN_DATE",
"MAT_BY","MAT_DATE","CUSTOMS_BY","CUSTOMS_DATE","ITEM_NO_PA","VER_MEMO",
"UP_PROCESS","VSM_PHASE","YYMM","SAMPLE_ORDER","CFM_NO"
FROM
SY_BOMS "A2" WHERE "ARTIC_CODE"=:1 AND "ITEM_NO"=:2 AND "BOM_VER"=:3
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 553 0.22 0.23 0 0 0 0
Fetch 1105 439.29 500.82 13062 6944194 0 553
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1659 439.51 501.06 13062 6944194 0 553
以下是sqlplus單筆執行如下﹕
INSERT INTO BD_SA@ABCDE.COM.CN(ARTIC_CODE,
BOM_VER,ITEM_NO,VER_YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,SAME_MK,INPUT_CD,
SEMI_CD,POLICY,IS_PROCESS,IS_PACK,UP_PROCESS,MK_KNIFE,IS_WORK,IS_REQ,
REPAIR_MK,COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,RATE_SORT,TG_MK,
PROC_PART,VSM_FLG,PRICE,MOD_PLAN,PMOD_DATE,MOD_CUS,CMOD_DATE,MOD_MAT,
MMOD_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,SUP_CODE,CUT_CODE,
PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO) WITH RS1 AS(SELECT
/*+index(a2 PK_DV_BOMS) */ ARTIC_CODE,TO_NUMBER(BOM_VER) BOM_VER,
TO_NUMBER(ITEM_NO) ITEM_NO,SUBSTR(YYMM,1,6) YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,
SAME_MK,INPUT_CD,NVL(SEMI_CD,' ') SEMI_CD, POLICY,IS_PROCESS,IS_PACK,
NVL(UP_PROCESS,'N') UP_PROCESS,NVL(MK_KNIFE,'N') MK_KNIFE,IS_WORK,IS_REQ,
REPAIR_MK,NVL(COMPUT_TYPE,1) COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,
RATE_SORT,TG_MK,PROC_PART,VSM_PHASE,PRICE,PLAN_BY,PLAN_DATE,CUSTOMS_BY,
CUSTOMS_DATE,MAT_BY,MAT_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,
SUPPLE_CODE,CUT_CODE,PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO
FROM SY_BOMS A2 WHERE ARTIC_CODE='abcdefg' AND BOM_VER=1 AND ITEM_NO=100 )
SELECT ARTIC_CODE,BOM_VER,ITEM_NO,YYMM,VER_MEMO,ITEM_ORDER,MAT_NO,SAME_MK,
INPUT_CD,SEMI_CD, POLICY,IS_PROCESS,IS_PACK,UP_PROCESS,MK_KNIFE,IS_WORK,
IS_REQ,REPAIR_MK,COMPUT_TYPE,D_WEIT,STANDARD_QTY,WASTE_PC,RATE_SORT,TG_MK,
PROC_PART,VSM_PHASE,PRICE,PLAN_BY,PLAN_DATE,CUSTOMS_BY,CUSTOMS_DATE,MAT_BY,
MAT_DATE,CREATED_BY,CREATED_DATE,MOD_BY,MOD_DATE,SUPPLE_CODE,CUT_CODE,
PROCESS_CODE,PART_NO,ITEM_NO_PA,SAMPLE_ORDER,CFM_NO FROM RS1
執行計畫
----------------------------------------------------------
Plan hash value: 1788691278 -------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Inst IN-OUT| -------------------------------------------------------------------------------------------------- | INSERT STATEMENT REMOTE| | 1 | 159 | 3 (0)| 00:00:01 | | |
| 1 | REMOTE | SY_BOMS | 1 | 159 | 3 (0)| 00:00:01 | ! | R->S | --------------------------------------------------------------------------------------------------
Remote SQL Information (identified by operation id): ---------------------------------------------------- 1 - SELECT /*+ OPAQUE_TRANSFORM INDEX ("A2" "PK_SY_BOMS") */ "ARTIC_CODE","BOM_VER","ITEM_NO","SUPPLE_CODE","ITEM_ORDER","PART_NO","MAT_NO","CUT_CODE", "SAME_MK","INPUT_CD","SEMI_CD","POLICY","IS_PACK","IS_PROCESS","PROCESS_CODE","MK_KNIFE"," IS_WORK","IS_REQ","REPAIR_MK","COMPUT_TYPE","CREATED_BY","CREATED_DATE","MOD_BY","MOD_DATE ","D_WEIT","STANDARD_QTY","WASTE_PC","RATE_SORT","TG_MK","PROC_PART","PRICE","PLAN_BY","PLAN_DATE","MAT_BY","MAT_DATE","CUSTOMS_BY","CUSTOMS_DATE","ITEM_NO_PA","VER_MEMO","UP_PROCE
SS","VSM_PHASE","YYMM","SAMPLE_ORDER","CFM_NO" FROM SY_BOMS "A2" WHERE
"ARTIC_CODE"='483247-001-00' AND "ITEM_NO"=160 AND "BOM_VER"=1 (accessing '!' ) Note
-----
- 'PLAN_TABLE' is old version
- fully remote statement
統計值
----------------------------------------------------------
223 recursive calls
1 db block gets
40 consistent gets
5 physical reads
304 redo size
551 bytes sent via SQL*Net to client
2193 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
1 sorts (memory) 0 sorts (disk) 1 rows processed
[本帖最后由 hgcwen_wen 于 2011-5-10 16:04 编辑]