SELECT ORIGIN AS ORIGIN, DESTINATION, VA_PRODUCT_CODE, AWB_TYPE, DOW.PROS_DOW AS DOW, TIME_WINDOW, ALLOTMENT_ID, TRUNC (BKG_DEPARTURE_DATE) AS SERVICE_DATE, BKG_TRANSACTION_DATE AS TRANSACTION_DATE_TIME, BKG_DCP AS DAYS_PRIOR, BKG_DCP AS DCP, BKG_TRANSACTION_TYPE AS TRANSACTION_TYPE, BKG_TRANSACTION_KEY AS TRANSACTION_KEY, SUM (BKG_WEIGHT_COUNT) AS WEIGHT_COUNT, SUM (BKG_VOLUME_COUNT) AS VOLUME_COUNT, 0 AS COUNTED_FLAG, TO_DATE ('27-JUL-2008') AS PROCESS_DATE FROM BOOKING_TRANS_RAW T, DAY_OF_WEEK DOW WHERE DOW.DOW = T.DOW AND ORIGIN <> DESTINATION AND BKG_DEPARTURE_DATE >= '02-OCT-2007' GROUP BY ORIGIN, DESTINATION, VA_PRODUCT_CODE, AWB_TYPE, DOW.PROS_DOW, TIME_WINDOW, ALLOTMENT_ID, TRUNC (BKG_DEPARTURE_DATE), BKG_TRANSACTION_DATE, BKG_DCP, BKG_TRANSACTION_TYPE, BKG_TRANSACTION_KEY call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.03 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 98 1.52 1.48 3196 3213 0 97462 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 100 1.55 1.52 3196 3213 0 97462 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 101 (CNOSDP) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 0 HASH (GROUP BY) 0 HASH JOIN 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'DAY_OF_WEEK' (TABLE) 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'BOOKING_TRANS_RAW' (TABLE) ******************************************************************************** select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 0 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID SYN$ (cr=3 pr=0 pw=0 time=130 us) 1 INDEX UNIQUE SCAN I_SYN1 (cr=2 pr=0 pw=0 time=83 us)(object id 101) ******************************************************************************** INSERT INTO PR_TX_CG_T (ORGN, DSTN, VAP_TYPE, AWB_TYPE, DOW, TIME_WINDOW, ALLOTMENT_ID, SERVICE_DATE, TRANSACTION_DATE_TIME, DAYS_PRIOR, DCP, TRANSACTION_TYPE, TRANSACTION_KEY, WEIGHT_COUNT, VOLUME_COUNT, COUNTED_FLAG, PROCESS_DATE ) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 98 2.28 2.32 64 6954 208852 97462 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 99 2.28 2.32 64 6954 208852 97462 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 101 (CNOSDP) (recursive depth: 1) Rows Execution Plan ------- --------------------------------------------------- 0 INSERT STATEMENT MODE: ALL_ROWS ******************************************************************************** select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# and bitand(property,16)=0 and bitand(property,8)=0 order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=2 pr=0 pw=0 time=115 us) 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=85 us) 0 NESTED LOOPS (cr=2 pr=0 pw=0 time=80 us) 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=2 pr=0 pw=0 time=35 us) 0 INDEX RANGE SCAN I_TRIGGER1 (cr=2 pr=0 pw=0 time=10 us)(object id 125) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 pr=0 pw=0 time=0 us)(object id 36) 0 TABLE ACCESS CLUSTER USER$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_USER# (cr=0 pr=0 pw=0 time=0 us)(object id 11) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0), NVL(scanhint,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 2 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 2 4 2 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ (cr=4 pr=2 pw=0 time=262 us) 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=1 pw=0 time=167 us)(object id 9) ******************************************************************************** select file# from file$ where ts#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 100 0.00 0.00 0 0 0 0 Execute 100 0.00 0.00 0 0 0 0 Fetch 200 0.00 0.00 2 300 0 100 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 400 0.02 0.01 2 300 0 100 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FILE$ (cr=3 pr=0 pw=0 time=24 us) 1 INDEX RANGE SCAN I_FILE2 (cr=2 pr=0 pw=0 time=19 us)(object id 42) ******************************************************************************** update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 where ts#=:1 and user#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 90 0.01 0.01 0 0 0 0 Execute 90 0.03 0.03 0 312 90 90 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 180 0.05 0.04 0 312 90 90 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE TSQ$ (cr=3 pr=0 pw=0 time=956 us) 1 TABLE ACCESS CLUSTER TSQ$ (cr=3 pr=0 pw=0 time=74 us) 1 INDEX UNIQUE SCAN I_USER# (cr=1 pr=0 pw=0 time=42 us)(object id 11) ******************************************************************************** update seg$ set type#=:4,blocks=:5,extents=:6,minexts=:7,maxexts=:8,extsize= :9,extpct=:10,user#=:11,iniexts=:12,lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1= DECODE(:17,0,NULL,:17),scanhint=:18 where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 90 0.01 0.01 0 0 0 0 Execute 90 0.02 0.02 3 540 90 90 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 180 0.03 0.03 3 540 90 90 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE SEG$ (cr=6 pr=2 pw=0 time=614 us) 1 TABLE ACCESS CLUSTER SEG$ (cr=6 pr=2 pw=0 time=354 us) 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=3 pr=1 pw=0 time=96 us)(object id 9) ******************************************************************************** COMMIT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 1 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 1 0 Misses in library cache during parse: 0 Parsing user id: 101 (CNOSDP) (recursive depth: 1) ******************************************************************************** ALTER SESSION SET SQL_TRACE=FALSE