TKPROF: Release 10.2.0.3.0 - Production on Fri Jun 20 14:41:20 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Trace file: oq01_ora_5039.trc Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** The following statements encountered a error during parse: SELECT t.rowid trowid, ta.rowid tarowid, cdi.rowid cdirowid, p.rowid prowid, fso.rowid fsorowid, a.rowid arowid, a.owner_cid, t.tx_id, t.tx_typ_cd, t.cre_dt, t.tx_vlu, t.cpgn_cd, t.cre_user_id tcre_user_id, t.TX_AUDIT_LOC_CD, t.TX_AUDIT_LYTY_PRG_CD, ta.chrg_cid, ta.tx_apmt_id, ta.dlv_itm_id, ta.tx_apmt_typ_cd, ta.tx_apmt_reasn_cd, ta.apmt_txt, ta.ccy_cd, ta.tx_apmt_vlu, ta.RULE_ID, cdi.prod_id, cdi.tm_pd_qty, cdi.itm_qty, cdi.cust_ord_id, cdi.curr_sts_cd, cdi.line_no, cdi.cid, cdi.Retro_ind, cdi.ON_HOLD_IND, cdi.PARTNER_REF_Cd, cdi.SRC_ORG_CD, cdi.SRC_ORG_CD_TYP_CD, cdi.curr_sts_dt, cdi.cre_dt cdi_cre_dt, cdi.cre_user_id cdi_cre_user_id, p.src_prod_id, p.prod_typ_cd, fso.mkg_aln_cx_cd, fso.flt_no, fso.opg_aln_cx_cd, fso.slg_cls_cd, fso.cpt_cd, fso.trip_typ_cd, fso.stn_from_cd, fso.stn_to_cd, fso.uplift_dt FROM accounts a, transactions t, transaction_apportionments ta, customer_delivery_items cdi, products p, flight_segment_operations fso WHERE a.acc_id = t.acc_id AND t.tx_id = ta.tx_id AND ta.dlv_itm_id = cdi.dlv_itm_id (+) AND cdi.prod_id = p.prod_id (+) AND p.prod_id = fso.prod_id (+) Error encountered: ORA-10980 -------------------------------------------------------------------------------- SELECT t.rowid trowid, ta.rowid tarowid, cdi.rowid cdirowid, p.rowid prowid, fso.rowid fsorowid, a.rowid arowid, a.owner_cid, t.tx_id, t.tx_typ_cd, t.cre_dt, t.tx_vlu, t.cpgn_cd, t.cre_user_id tcre_user_id, t.TX_AUDIT_LOC_CD, t.TX_AUDIT_LYTY_PRG_CD, ta.chrg_cid, ta.tx_apmt_id, ta.dlv_itm_id, ta.tx_apmt_typ_cd, ta.tx_apmt_reasn_cd, ta.apmt_txt, ta.ccy_cd, ta.tx_apmt_vlu, ta.RULE_ID, cdi.prod_id, cdi.tm_pd_qty, cdi.itm_qty, cdi.cust_ord_id, cdi.curr_sts_cd, cdi.line_no, cdi.cid, cdi.Retro_ind, cdi.ON_HOLD_IND, cdi.PARTNER_REF_Cd, cdi.SRC_ORG_CD, cdi.SRC_ORG_CD_TYP_CD, cdi.curr_sts_dt, cdi.cre_dt cdi_cre_dt, cdi.cre_user_id cdi_cre_user_id, p.src_prod_id, p.prod_typ_cd, fso.mkg_aln_cx_cd, fso.flt_no, fso.opg_aln_cx_cd, fso.slg_cls_cd, fso.cpt_cd, fso.trip_typ_cd, fso.stn_from_cd, fso.stn_to_cd, fso.uplift_dt FROM accounts a, transactions t, transaction_apportionments ta, customer_delivery_items cdi, products p, flight_segment_operations fso WHERE a.acc_id = t.acc_id AND t.tx_id = ta.tx_id AND ta.dlv_itm_id = cdi.dlv_itm_id (+) AND cdi.prod_id = p.prod_id (+) AND p.prod_id = fso.prod_id (+) /* 1 */ Error encountered: ORA-10980 ******************************************************************************** UPDATE transaction_apportionments SET tx_apmt_vlu='2900' WHERE tx_apmt_id='1074008472' 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 3 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 3 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 718 Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE TRANSACTION_APPORTIONMENTS (cr=4 pr=0 pw=0 time=3373 us) 1 PARTITION HASH SINGLE PARTITION: 10 10 (cr=3 pr=0 pw=0 time=46 us) 1 INDEX UNIQUE SCAN PK_TRANSACTION_APPORTIONMENTS PARTITION: 10 10 (cr=3 pr=0 pw=0 time=39 us)(object id 23986) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 4.87 4.87 ******************************************************************************** INSERT /*+ IDX(0) */ INTO "OCEAN"."MLOG$_TRANSACTION_APPORTIO" (dmltype$$, old_new$$,snaptime$$,change_vector$$,sequence$$,m_row$$) VALUES (:d,:o,to_date('4000-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'),:c, sys.cdc_rsid_seq$.nextval,:m) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 1 3 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 SEQUENCE CDC_RSID_SEQ$ (cr=0 pr=0 pw=0 time=27 us) ******************************************************************************** commit call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.13 0.09 4921598 4932184 13 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.13 0.09 4921598 4932184 13 0 Misses in library cache during parse: 0 Parsing user id: 718 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ log file sync 1 0.00 0.00 SQL*Net message to client 1 0.00 0.00 ******************************************************************************** select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname, o.dataobj#,o.flags from obj$ o where o.obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 30 0.00 0.00 0 0 0 0 Fetch 30 0.00 0.00 0 90 0 30 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 61 0.00 0.00 0 90 0 30 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=51 us) 1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=28 us)(object id 33) ******************************************************************************** select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property, i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey, i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#, nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256), i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0), nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null, null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 2 0 Execute 17 0.02 0.01 0 0 0 0 Fetch 40 0.00 0.01 0 144 0 23 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 59 0.02 0.03 0 144 2 23 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 ------- --------------------------------------------------- 4 SORT ORDER BY (cr=13 pr=0 pw=0 time=3828 us) 4 HASH JOIN OUTER (cr=13 pr=0 pw=0 time=3723 us) 4 NESTED LOOPS OUTER (cr=10 pr=0 pw=0 time=133 us) 4 TABLE ACCESS CLUSTER IND$ (cr=8 pr=0 pw=0 time=88 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=25 us)(object id 3) 0 TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=2 pr=0 pw=0 time=29 us) 0 INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=2 pr=0 pw=0 time=19 us)(object id 17965026) 0 VIEW (cr=3 pr=0 pw=0 time=180 us) 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=177 us) 0 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=3 pr=0 pw=0 time=44 us) 4 INDEX RANGE SCAN I_CDEF2 (cr=2 pr=0 pw=0 time=22 us)(object id 48) ******************************************************************************** select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 23 0.00 0.00 0 0 0 0 Fetch 66 0.00 0.00 0 132 0 43 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 91 0.00 0.00 0 132 0 43 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 3 TABLE ACCESS BY INDEX ROWID ICOL$ (cr=8 pr=0 pw=0 time=24 us) 3 INDEX RANGE SCAN I_ICOL1 (cr=5 pr=0 pw=0 time=27 us)(object id 37) ******************************************************************************** select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2, nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182, scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$, rowid,col#,property, nvl(charsetid,0),nvl(charsetform,0),spare1,spare2, nvl(spare3,0) from col$ where obj#=:1 order by intcol# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 4 0 Execute 17 0.01 0.00 0 0 0 0 Fetch 236 0.00 0.00 0 66 0 219 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 255 0.01 0.00 0 66 4 219 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 ------- --------------------------------------------------- 50 SORT ORDER BY (cr=4 pr=0 pw=0 time=329 us) 50 TABLE ACCESS CLUSTER COL$ (cr=4 pr=0 pw=0 time=139 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=22 us)(object id 3) ******************************************************************************** select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 20 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 20 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 GROUP BY (cr=2 pr=0 pw=0 time=63 us) 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=36 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=31 us)(object id 100) ******************************************************************************** select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2)) from objauth$ where obj#=:1 group by grantee#,privilege#,nvl(col#,0) order by grantee# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 20 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 20 0 0 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=2 pr=0 pw=0 time=40 us) 0 TABLE ACCESS BY INDEX ROWID OBJAUTH$ (cr=2 pr=0 pw=0 time=15 us) 0 INDEX RANGE SCAN I_OBJAUTH1 (cr=2 pr=0 pw=0 time=13 us)(object id 100) ******************************************************************************** select col#,intcol#,toid,version#,packed,intcols,intcol#s,flags, synobj#, nvl(typidcol#, 0) from coltype$ where obj#=:1 order by intcol# desc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 4 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=4 pr=0 pw=0 time=56 us) 0 TABLE ACCESS CLUSTER COLTYPE$ (cr=4 pr=0 pw=0 time=36 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=17 us)(object id 3) ******************************************************************************** select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 204 0.09 0.03 0 0 0 0 Fetch 204 0.00 0.00 0 608 0 200 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 409 0.09 0.04 0 608 0 200 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=0 pw=0 time=44 us) 1 INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=29 us)(object id 194) ******************************************************************************** select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 11 0.01 0.00 0 0 0 0 Fetch 11 0.00 0.14 8 33 0 20 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 24 0.01 0.14 8 33 0 20 Misses in library cache during parse: 0 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 3) Rows Row Source Operation ------- --------------------------------------------------- 3 SORT ORDER BY (cr=3 pr=1 pw=0 time=13275 us) 3 TABLE ACCESS CLUSTER HISTGRM$ (cr=3 pr=1 pw=0 time=13129 us) 1 INDEX UNIQUE SCAN I_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=18 us)(object id 189) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 8 0.06 0.14 ******************************************************************************** select intcol#, toid, version#, intcols, intcol#s, flags, synobj# from subcoltype$ where obj#=:1 order by intcol# asc 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 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 4 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=4 pr=0 pw=0 time=46 us) 0 TABLE ACCESS CLUSTER SUBCOLTYPE$ (cr=4 pr=0 pw=0 time=29 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=13 us)(object id 3) ******************************************************************************** select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intcol# asc 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 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 TABLE ACCESS BY INDEX ROWID NTAB$ (cr=1 pr=0 pw=0 time=21 us) 0 INDEX RANGE SCAN I_NTAB2 (cr=1 pr=0 pw=0 time=16 us)(object id 290) ******************************************************************************** select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 5 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5 0.01 0.00 0 5 0 2 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 ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID LOB$ (cr=5 pr=0 pw=0 time=27 us) 2 INDEX RANGE SCAN I_LOB1 (cr=3 pr=0 pw=0 time=21 us)(object id 252) ******************************************************************************** select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc 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 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 1 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 TABLE ACCESS BY INDEX ROWID REFCON$ (cr=1 pr=0 pw=0 time=17 us) 0 INDEX RANGE SCAN I_REFCON2 (cr=1 pr=0 pw=0 time=14 us)(object id 298) ******************************************************************************** select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc 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 51 0.00 0.00 0 4 0 50 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 53 0.00 0.00 0 4 0 50 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 ------- --------------------------------------------------- 50 SORT ORDER BY (cr=4 pr=0 pw=0 time=167 us) 50 TABLE ACCESS CLUSTER COL$ (cr=4 pr=0 pw=0 time=83 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=18 us)(object id 3) ******************************************************************************** select intcol#,type,flags,lobcol,objcol,extracol,schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 1 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 TABLE ACCESS BY INDEX ROWID OPQTYPE$ (cr=1 pr=0 pw=0 time=21 us) 0 INDEX RANGE SCAN I_OPQTYPE1 (cr=1 pr=0 pw=0 time=16 us)(object id 167418) ******************************************************************************** select s.sowner, s.vname from snap$ s, (select distinct sowner, vname from snap_reftime$ where instsite=0 start with masobj# in (20602) connect by prior sowner = mowner and prior vname = master) v where s.sowner=v.sowner and s.vname=v.vname and bitand(s.flag,32768)!=0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 10 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.02 0 10 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 HASH JOIN (cr=10 pr=0 pw=0 time=1257 us) 1 VIEW (cr=6 pr=0 pw=0 time=774 us) 1 SORT UNIQUE (cr=6 pr=0 pw=0 time=768 us) 2 FILTER (cr=6 pr=0 pw=0 time=733 us) 2 CONNECT BY WITH FILTERING (cr=6 pr=0 pw=0 time=728 us) 2 FILTER (cr=3 pr=0 pw=0 time=87 us) 23 TABLE ACCESS FULL SNAP_REFTIME$ (cr=3 pr=0 pw=0 time=114 us) 0 HASH JOIN (cr=3 pr=0 pw=0 time=562 us) 2 CONNECT BY PUMP (cr=0 pr=0 pw=0 time=6 us) 23 TABLE ACCESS FULL SNAP_REFTIME$ (cr=3 pr=0 pw=0 time=31 us) 0 TABLE ACCESS FULL SNAP_REFTIME$ (cr=0 pr=0 pw=0 time=0 us) 1 TABLE ACCESS FULL SNAP$ (cr=4 pr=0 pw=0 time=37 us) ******************************************************************************** update tab$ set spare3 = :1, spare5 = :3 where obj# = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 16 8 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 16 8 2 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 ------- --------------------------------------------------- 0 UPDATE TAB$ (cr=8 pr=0 pw=0 time=757 us) 1 TABLE ACCESS CLUSTER TAB$ (cr=8 pr=0 pw=0 time=265 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=18 us)(object id 3) ******************************************************************************** select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# 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 4 0.00 0.00 0 18 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 18 0 3 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 ------- --------------------------------------------------- 3 SORT ORDER BY (cr=18 pr=0 pw=0 time=251 us) 3 NESTED LOOPS (cr=18 pr=0 pw=0 time=219 us) 3 NESTED LOOPS (cr=13 pr=0 pw=0 time=152 us) 3 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=5 pr=0 pw=0 time=65 us) 3 INDEX RANGE SCAN I_DEPENDENCY2 (cr=2 pr=0 pw=0 time=37 us)(object id 117) 3 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=8 pr=0 pw=0 time=73 us) 3 INDEX UNIQUE SCAN I_OBJ1 (cr=5 pr=0 pw=0 time=37 us)(object id 33) 3 TABLE ACCESS CLUSTER USER$ (cr=5 pr=0 pw=0 time=57 us) 3 INDEX UNIQUE SCAN I_USER# (cr=2 pr=0 pw=0 time=19 us)(object id 11) ******************************************************************************** SELECT DISTINCT s.sowner, s.vname, s.auto_fast, o.obj# FROM snap_reftime$ r, snap$ s, obj$ o, user$ u WHERE r.vname=s.vname AND r.sowner= s.sowner and o.type#=42 AND o.name=s.vname AND o.owner#= u.user# AND s.sowner=u.name AND bitand(s.flag,32768)!=0 AND r.masobj# IN (20602) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 15 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.00 0 15 0 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT UNIQUE (cr=15 pr=0 pw=0 time=846 us) 2 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=15 pr=0 pw=0 time=761 us) 7 NESTED LOOPS (cr=14 pr=0 pw=0 time=3831 us) 2 NESTED LOOPS (cr=10 pr=0 pw=0 time=639 us) 2 HASH JOIN (cr=6 pr=0 pw=0 time=593 us) 2 TABLE ACCESS FULL SNAP_REFTIME$ (cr=3 pr=0 pw=0 time=66 us) 1 TABLE ACCESS FULL SNAP$ (cr=3 pr=0 pw=0 time=38 us) 2 TABLE ACCESS BY INDEX ROWID USER$ (cr=4 pr=0 pw=0 time=43 us) 2 INDEX UNIQUE SCAN I_USER1 (cr=2 pr=0 pw=0 time=20 us)(object id 41) 4 INDEX RANGE SCAN I_OBJ2 (cr=4 pr=0 pw=0 time=33 us)(object id 34) ******************************************************************************** SELECT DISTINCT s.sowner, s.vname, s.auto_fast, do.obj# FROM dependency$ d, snap$ s, obj$ po, obj$ do, user$ u WHERE d.p_obj#= po.obj# AND d.d_obj#=do.obj# AND do.type#=42 AND do.name=s.vname AND do.owner#= u.user# AND s.sowner=u.name AND bitand(s.flag,32768)!=0 AND d.p_obj# IN (18150082) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 4 0 0 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT UNIQUE (cr=4 pr=0 pw=0 time=327 us) 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=301 us) 0 HASH JOIN (cr=4 pr=0 pw=0 time=300 us) 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=62 us) 0 NESTED LOOPS (cr=4 pr=0 pw=0 time=61 us) 1 INDEX UNIQUE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=23 us)(object id 33) 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=2 pr=0 pw=0 time=32 us) 0 INDEX RANGE SCAN I_DEPENDENCY2 (cr=2 pr=0 pw=0 time=30 us)(object id 117) 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 33) 0 TABLE ACCESS FULL SNAP$ (cr=0 pr=0 pw=0 time=0 us) 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 tname, snapid, flag, flag2, status, master_version, tables, lobmaskvec, query_len, mas_roll_seg, mlink, snapshot, auto_fun, uslog, NVL(rscn, 0), refhnt, objflag, auto_fast, sna_type_oid, sna_type_hashcode, sna_type_owner, sna_type_name, mas_type_oid, mas_type_hashcode, mas_type_owner, mas_type_name, syn_count FROM sys.snap$ WHERE sowner = :1 and vname = :2 and instsite = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.01 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 0 2 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 SNAP$ (cr=2 pr=0 pw=0 time=29 us) 1 INDEX UNIQUE SCAN I_SNAP1 (cr=1 pr=0 pw=0 time=12 us)(object id 157) ******************************************************************************** SELECT masobj#, masflag, mowner, master, lastsuccess, snaptime, sysdate, loadertime, sysdate, NVL(refscn, 0), fcmaskvec, ejmaskvec, sub_handle, change_view FROM sys.snap_reftime$ WHERE sowner = :1 AND vname = :2 AND instsite = :3 ORDER BY tablenum 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 12 0.00 0.00 0 24 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.00 0 24 0 12 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 ------- --------------------------------------------------- 12 TABLE ACCESS BY INDEX ROWID SNAP_REFTIME$ (cr=24 pr=0 pw=0 time=35 us) 12 INDEX RANGE SCAN I_SNAP_REFTIME1 (cr=12 pr=0 pw=0 time=98 us)(object id 160) ******************************************************************************** SELECT query_txt FROM sys.snap$ WHERE sowner = :1 and vname = :2 AND instsite = :3 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 SNAP$ (cr=2 pr=0 pw=0 time=19 us) 1 INDEX UNIQUE SCAN I_SNAP1 (cr=1 pr=0 pw=0 time=8 us)(object id 157) ******************************************************************************** update sys.sumpartlog$ s set s.timestamp = :1, s.scn = :2 where s.bo# = :3 and s.timestamp >= to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.00 0 0 0 0 Execute 7 0.01 0.01 0 7 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.01 0.01 0 7 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE SUMPARTLOG$ (cr=1 pr=0 pw=0 time=23 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=1 pr=0 pw=0 time=17 us) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=15 us)(object id 167486) ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 10 0.00 0.00 0 10 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 21 0.00 0.00 0 10 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 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=1 pr=0 pw=0 time=30 us) 0 INDEX RANGE SCAN I_CDEF3 (cr=1 pr=0 pw=0 time=25 us)(object id 49) ******************************************************************************** select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0), rowid,cols,nvl(defer,0),mtime,nvl(spare1,0) from cdef$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 10 0.00 0.00 0 0 0 0 Fetch 49 0.00 0.00 0 98 0 39 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 60 0.00 0.00 0 98 0 39 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 5 TABLE ACCESS BY INDEX ROWID CDEF$ (cr=12 pr=0 pw=0 time=33 us) 5 INDEX RANGE SCAN I_CDEF2 (cr=7 pr=0 pw=0 time=58 us)(object id 48) ******************************************************************************** select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 39 0.00 0.00 0 0 0 0 Fetch 78 0.00 0.00 0 160 0 39 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 119 0.00 0.00 0 160 0 39 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 CCOL$ (cr=4 pr=0 pw=0 time=38 us) 1 INDEX RANGE SCAN I_CCOL1 (cr=3 pr=0 pw=0 time=35 us)(object id 51) ******************************************************************************** select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 30 0.01 0.00 0 0 0 0 Execute 30 0.01 0.01 0 0 0 0 Fetch 30 0.00 0.00 0 90 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 90 0.02 0.01 0 90 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS FULL CDC_CHANGE_TABLES$ (cr=3 pr=0 pw=0 time=51 us) ******************************************************************************** select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 8 0.00 0.00 0 0 0 0 Fetch 8 0.00 0.00 0 24 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 24 0 8 Misses in library cache during parse: 0 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=31 us) 1 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=22 us)(object id 34) ******************************************************************************** select log, oldest, oldest_pk, oldest_oid, oldest_new, youngest+1/86400, flag, yscn, oldest_seq from sys.mlog$ where mowner = :1 and master = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 18 0.00 0.00 0 0 0 0 Execute 18 0.01 0.01 0 0 0 0 Fetch 18 0.00 0.00 0 36 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 54 0.01 0.01 0 36 0 18 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 CLUSTER MLOG$ (cr=2 pr=0 pw=0 time=29 us) 1 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=11 us)(object id 152) ******************************************************************************** select log, oldest, oldest_pk, oldest_oid, oldest_new, youngest+1/86400, flag, yscn, oldest_seq from sys.mlog$ where mowner = :1 and master = :2 for update call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 12 0.00 0.00 0 0 0 0 Execute 12 0.00 0.00 1 42 15 0 Fetch 12 0.00 0.00 0 36 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 36 0.00 0.00 1 78 15 12 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 FOR UPDATE (cr=7 pr=0 pw=0 time=261 us) 2 TABLE ACCESS CLUSTER MLOG$ (cr=7 pr=0 pw=0 time=126 us) 2 INDEX UNIQUE SCAN I_MLOG# (cr=2 pr=0 pw=0 time=18 us)(object id 152) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.00 0.00 ******************************************************************************** update "OCEAN"."MLOG$_TRANSACTIONS" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE MLOG$_TRANSACTIONS (cr=3 pr=0 pw=0 time=53 us) 0 TABLE ACCESS FULL MLOG$_TRANSACTIONS (cr=3 pr=0 pw=0 time=48 us) ******************************************************************************** update sys.mlog$ set youngest = :1, yscn = :2 where mowner = :3 and master = :4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 18 6 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 18 6 6 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 ------- --------------------------------------------------- 0 UPDATE MLOG$ (cr=3 pr=0 pw=0 time=159 us) 1 TABLE ACCESS CLUSTER MLOG$ (cr=3 pr=0 pw=0 time=63 us) 1 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=12 us)(object id 152) ******************************************************************************** SELECT oldest, youngest+1/86400 FROM sys.snap_loadertime$ WHERE tableobj# = :1 FOR UPDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 12 6 0 Fetch 6 0.00 0.00 0 0 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 6 6 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 FOR UPDATE (cr=2 pr=0 pw=0 time=143 us) 1 TABLE ACCESS BY INDEX ROWID SNAP_LOADERTIME$ (cr=2 pr=0 pw=0 time=19 us) 1 INDEX UNIQUE SCAN I_SNAP_LOADERTIME1 (cr=1 pr=0 pw=0 time=9 us)(object id 150) ******************************************************************************** select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols, nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans, t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln, t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1), nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag, 0), nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 4 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 3 0.01 0.00 0 13 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8 0.02 0.00 0 13 4 3 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 NESTED LOOPS OUTER (cr=4 pr=0 pw=0 time=55 us) 1 TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=40 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=16 us)(object id 3) 0 TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=1 pr=0 pw=0 time=9 us) 0 INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=0 pw=0 time=6 us)(object id 17965024) ******************************************************************************** UPDATE sys.snap_loadertime$ SET youngest = :1 WHERE tableobj# = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 6 6 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 6 6 6 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 UPDATE SNAP_LOADERTIME$ (cr=1 pr=0 pw=0 time=87 us) 1 INDEX UNIQUE SCAN I_SNAP_LOADERTIME1 (cr=1 pr=0 pw=0 time=10 us)(object id 150) ******************************************************************************** update sys.sumdelta$ s set s.timestamp = :1, s.scn = :2 where s.tableobj# = :3 and s.timestamp >= to_date('4000-01-01:00:00:00', 'YYYY-MM-DD:HH24:MI:SS') call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 6 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE SUMDELTA$ (cr=1 pr=0 pw=0 time=20 us) 0 INDEX RANGE SCAN I_SUMDELTA$ (cr=1 pr=0 pw=0 time=17 us)(object id 146) ******************************************************************************** update "OCEAN"."MLOG$_TRANSACTION_APPORTIO" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 1 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 ------- --------------------------------------------------- 0 UPDATE MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=160 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=68 us) ******************************************************************************** update "OCEAN"."MLOG$_CUSTOMER_DELIVERY_IT" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE MLOG$_CUSTOMER_DELIVERY_IT (cr=3 pr=0 pw=0 time=49 us) 0 TABLE ACCESS FULL MLOG$_CUSTOMER_DELIVERY_IT (cr=3 pr=0 pw=0 time=47 us) ******************************************************************************** update "OCEAN"."MLOG$_ACCOUNTS" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE MLOG$_ACCOUNTS (cr=3 pr=0 pw=0 time=49 us) 0 TABLE ACCESS FULL MLOG$_ACCOUNTS (cr=3 pr=0 pw=0 time=47 us) ******************************************************************************** update "OCEAN"."MLOG$_PRODUCTS" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE MLOG$_PRODUCTS (cr=3 pr=0 pw=0 time=46 us) 0 TABLE ACCESS FULL MLOG$_PRODUCTS (cr=3 pr=0 pw=0 time=43 us) ******************************************************************************** update "OCEAN"."MLOG$_FLIGHT_SEGMENT_OPERA" set snaptime$$ = :1 where snaptime$$ > to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS') 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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE MLOG$_FLIGHT_SEGMENT_OPERA (cr=3 pr=0 pw=0 time=45 us) 0 TABLE ACCESS FULL MLOG$_FLIGHT_SEGMENT_OPERA (cr=3 pr=0 pw=0 time=42 us) ******************************************************************************** select NVL(max(s.scn), 0) from sumdelta$ s where s.tableobj# = :1 and NVL(s.scn,0) <= :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 6 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.01 0.00 0 6 0 6 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 SORT AGGREGATE (cr=1 pr=0 pw=0 time=47 us) 0 TABLE ACCESS BY INDEX ROWID SUMDELTA$ (cr=1 pr=0 pw=0 time=18 us) 0 INDEX RANGE SCAN I_SUMDELTA$ (cr=1 pr=0 pw=0 time=16 us)(object id 146) ******************************************************************************** select decode(bitand(s.flags,1),0,0,1), NVL(max(s.scn), 0) from sumpartlog$ s where s.bo# = :1 and nvl(s.scn,0) <= :2 group by decode(bitand(s.flags,1),0,0,1) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.01 0.00 0 6 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=1 pr=0 pw=0 time=54 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=1 pr=0 pw=0 time=20 us) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=16 us)(object id 167486) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_FLIGHT_SEGMENT_OPERA" where snaptime$$ <= :1 group by dmltype$$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=77 us) 0 TABLE ACCESS FULL MLOG$_FLIGHT_SEGMENT_OPERA (cr=3 pr=0 pw=0 time=50 us) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_PRODUCTS" where snaptime$$ <= :1 group by dmltype$$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=65 us) 0 TABLE ACCESS FULL MLOG$_PRODUCTS (cr=3 pr=0 pw=0 time=38 us) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_CUSTOMER_DELIVERY_IT" where snaptime$$ <= :1 group by dmltype$$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=70 us) 0 TABLE ACCESS FULL MLOG$_CUSTOMER_DELIVERY_IT (cr=3 pr=0 pw=0 time=45 us) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_TRANSACTION_APPORTIO" where snaptime$$ <= :1 group by dmltype$$ 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 2 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 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 SORT GROUP BY (cr=3 pr=0 pw=0 time=94 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=56 us) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_TRANSACTIONS" where snaptime$$ <= :1 group by dmltype$$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=71 us) 0 TABLE ACCESS FULL MLOG$_TRANSACTIONS (cr=3 pr=0 pw=0 time=45 us) ******************************************************************************** select dmltype$$, max(snaptime$$) from "OCEAN"."MLOG$_ACCOUNTS" where snaptime$$ <= :1 group by dmltype$$ 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 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=68 us) 0 TABLE ACCESS FULL MLOG$_ACCOUNTS (cr=3 pr=0 pw=0 time=44 us) ******************************************************************************** SELECT o.obj# FROM sys.obj$ o WHERE o.owner# = :1 AND o.name = :2 AND o.type# = 2 AND o.namespace = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 22 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 22 0 6 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 OBJ$ (cr=3 pr=0 pw=0 time=49 us) 1 INDEX RANGE SCAN I_OBJ2 (cr=2 pr=0 pw=0 time=33 us)(object id 34) ******************************************************************************** SELECT oldest FROM sys.snap_loadertime$ WHERE tableobj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 6 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 SNAP_LOADERTIME$ (cr=2 pr=0 pw=0 time=23 us) 1 INDEX UNIQUE SCAN I_SNAP_LOADERTIME1 (cr=1 pr=0 pw=0 time=12 us)(object id 150) ******************************************************************************** UPDATE sys.snap$ set status = :1 WHERE vname = :2 AND sowner = :3 AND instsite = :4 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 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SNAP$ (cr=1 pr=0 pw=0 time=212 us) 1 INDEX UNIQUE SCAN I_SNAP1 (cr=1 pr=0 pw=0 time=14 us)(object id 157) ******************************************************************************** update sys.snap$ set snapshot = :1, snaptime = :2, auto_date = :3, snapid = :4, error# = 0 where vname = :6 and sowner = :5 and instsite = :7 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 1 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SNAP$ (cr=1 pr=0 pw=0 time=103 us) 1 INDEX UNIQUE SCAN I_SNAP1 (cr=1 pr=0 pw=0 time=9 us)(object id 157) ******************************************************************************** select 1 from sumpartlog$ a where a.bo# = :1 and bitand(a.flags,5) != 5 and rownum = 1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 1 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 COUNT STOPKEY (cr=1 pr=0 pw=0 time=43 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=1 pr=0 pw=0 time=38 us) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=32 us)(object id 167486) ******************************************************************************** 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 4 0.00 0.00 0 0 0 0 Execute 4 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 12 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 12 0 4 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=3 pr=0 pw=0 time=48 us) 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 pr=0 pw=0 time=20 us)(object id 9) ******************************************************************************** update sum$ set containerobj#=:2,containertype=:3,containernam=:4, fullrefreshtim=:5,increfreshtim=:6,lastrefreshscn=:7,lastrefreshdate=:8, refreshmode=:9,pflags=:10,mflags=:11,numdetailtab=:12,numaggregates=:13, numkeycolumns=:14,numjoins=:15,numinlines=:16,sumtextlen=:17,sumtext=:18, fromoffset=:19,fromlen=:20,objcount=:21,metaversion=:22, xpflags=:23, numwhrnodes=:24, numhavnodes=:25, numqbnodes=:26, qbcmarker=:27, markerdty= :28, rw_mode=:29, rw_name=:30, dest_stmt=NULL, src_stmt=NULL, spare1=:31 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 68 0 0 Execute 2 0.02 0.01 0 2 4 2 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.02 0 70 4 2 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 UPDATE SUM$ (cr=1 pr=0 pw=0 time=252 us) 1 INDEX UNIQUE SCAN I_SUM$_1 (cr=1 pr=0 pw=0 time=13 us)(object id 319) ******************************************************************************** DELETE FROM "WR15657"."MV_STATEMENT" SNA$ WHERE "TAROWID" IN (SELECT /*+ NO_MERGE HASH_SJ */ * FROM (SELECT CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "OCEAN"."MLOG$_TRANSACTION_APPORTIO" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 ) MAS$) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.15 220.34 0 70 36 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.15 220.34 0 70 36 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 718 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MV_STATEMENT (cr=8 pr=0 pw=0 time=220325407 us) 1 PX COORDINATOR (cr=8 pr=0 pw=0 time=220324588 us) 0 PX SEND QC (RANDOM) :TQ10001 (cr=0 pr=0 pw=0 time=0 us) 0 HASH JOIN RIGHT SEMI (cr=0 pr=0 pw=0 time=0 us) 0 BUFFER SORT (cr=0 pr=0 pw=0 time=0 us) 0 PX RECEIVE (cr=0 pr=0 pw=0 time=0 us) 0 PX SEND BROADCAST :TQ10000 (cr=0 pr=0 pw=0 time=0 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=96 us) 0 PX BLOCK ITERATOR (cr=0 pr=0 pw=0 time=0 us) 0 MAT_VIEW ACCESS FULL MV_STATEMENT (cr=0 pr=0 pw=0 time=0 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ os thread startup 11 0.08 0.91 PX Deq: Join ACK 14 0.00 0.00 PX Deq Credit: send blkd 16 0.00 0.00 PX Deq: Parse Reply 10 0.00 0.00 PX Deq: Execute Reply 514 1.96 219.28 PX Deq: Table Q Normal 1 0.00 0.00 PX Deq: Signal ACK 9 0.00 0.01 enq: PS - contention 2 0.00 0.00 latch: session allocation 1 0.00 0.00 ******************************************************************************** SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ NO_PARALLEL("MAS$") FULL("MAS$") NO_PARALLEL_INDEX("MAS$") */ :"SYS_B_2" AS C1, :"SYS_B_3" AS C2 FROM "OCEAN"."MLOG$_TRANSACTION_APPORTIO" "MAS$") SAMPLESUB call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 6 0 2 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 718 (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=3 pr=0 pw=0 time=91 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=63 us) ******************************************************************************** SELECT ORA_TQ_BASE$.NEXTVAL FROM DUAL 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 0 1 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 0 1 1 Misses in library cache during parse: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SEQUENCE ORA_TQ_BASE$ (cr=55 pr=0 pw=0 time=8884 us) 1 FAST DUAL (cr=0 pr=0 pw=0 time=3 us) ******************************************************************************** update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6, cache=:7,highwater=:8,audit$=:9,flags=:10 where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 1 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: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SEQ$ (cr=1 pr=0 pw=0 time=317 us) 1 INDEX UNIQUE SCAN I_SEQ1 (cr=1 pr=0 pw=0 time=21 us)(object id 99) ******************************************************************************** INSERT INTO "WR15657"."MV_STATEMENT" SELECT /*+ NO_MERGE("JV$") */ /*+ */ "MAS$4".ROWID,"JV$"."RID$","MAS$2".ROWID,"MAS$1".ROWID,"MAS$0".ROWID, "MAS$5".ROWID,"MAS$5"."OWNER_CID","MAS$4"."TX_ID","MAS$4"."TX_TYP_CD", "MAS$4"."CRE_DT","MAS$4"."TX_VLU","MAS$4"."CPGN_CD","MAS$4"."CRE_USER_ID", "MAS$4"."TX_AUDIT_LOC_CD","MAS$4"."TX_AUDIT_LYTY_PRG_CD","JV$"."CHRG_CID", "JV$"."TX_APMT_ID","JV$"."DLV_ITM_ID","JV$"."TX_APMT_TYP_CD", "JV$"."TX_APMT_REASN_CD","JV$"."APMT_TXT","JV$"."CCY_CD", "JV$"."TX_APMT_VLU","JV$"."RULE_ID","MAS$2"."PROD_ID","MAS$2"."TM_PD_QTY", "MAS$2"."ITM_QTY","MAS$2"."CUST_ORD_ID","MAS$2"."CURR_STS_CD", "MAS$2"."LINE_NO","MAS$2"."CID","MAS$2"."RETRO_IND","MAS$2"."ON_HOLD_IND", "MAS$2"."PARTNER_REF_CD","MAS$2"."SRC_ORG_CD","MAS$2"."SRC_ORG_CD_TYP_CD", "MAS$2"."CURR_STS_DT","MAS$2"."CRE_DT","MAS$2"."CRE_USER_ID", "MAS$1"."SRC_PROD_ID","MAS$1"."PROD_TYP_CD","MAS$0"."MKG_ALN_CX_CD", "MAS$0"."FLT_NO","MAS$0"."OPG_ALN_CX_CD","MAS$0"."SLG_CLS_CD", "MAS$0"."CPT_CD","MAS$0"."TRIP_TYP_CD","MAS$0"."STN_FROM_CD", "MAS$0"."STN_TO_CD","MAS$0"."UPLIFT_DT" FROM ( SELECT "MAS$"."ROWID" "RID$" , "MAS$".* FROM "OCEAN"."TRANSACTION_APPORTIONMENTS" "MAS$" WHERE ROWID IN (SELECT /*+ HASH_SJ */ CHARTOROWID("MAS$"."M_ROW$$") RID$ FROM "OCEAN"."MLOG$_TRANSACTION_APPORTIO" "MAS$" WHERE "MAS$".SNAPTIME$$ > :1 ) ) "JV$", "OCEAN"."FLIGHT_SEGMENT_OPERATIONS" AS OF SNAPSHOT (:2) "MAS$0", "OCEAN"."PRODUCTS" AS OF SNAPSHOT (:2) "MAS$1", "OCEAN"."CUSTOMER_DELIVERY_ITEMS" AS OF SNAPSHOT (:2) "MAS$2", "OCEAN"."TRANSACTIONS" AS OF SNAPSHOT (:2) "MAS$4", "OCEAN"."ACCOUNTS" AS OF SNAPSHOT (:2) "MAS$5" WHERE "MAS$5"."ACC_ID"="MAS$4"."ACC_ID" AND "MAS$4"."TX_ID"="JV$"."TX_ID" AND "JV$"."DLV_ITM_ID"="MAS$2"."DLV_ITM_ID"(+) AND "MAS$2"."PROD_ID"="MAS$1"."PROD_ID"(+) AND "MAS$1"."PROD_ID"= "MAS$0"."PROD_ID"(+) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 585.43 1091.11 3380781 3408847 33 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 585.43 1091.11 3380781 3408847 33 1 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 718 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 NESTED LOOPS OUTER (cr=3408842 pr=3380781 pw=0 time=1091095957 us) 1 NESTED LOOPS OUTER (cr=3408838 pr=3380781 pw=0 time=1091095910 us) 1 NESTED LOOPS OUTER (cr=3408834 pr=3380781 pw=0 time=1091095865 us) 1 NESTED LOOPS (cr=3408830 pr=3380781 pw=0 time=1091095794 us) 1 NESTED LOOPS (cr=3408826 pr=3380781 pw=0 time=1091095750 us) 1 VIEW (cr=3408390 pr=3380780 pw=0 time=1091055194 us) 1 HASH JOIN RIGHT SEMI (cr=3408390 pr=3380780 pw=0 time=1091055179 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=85 us) 160781139 PARTITION HASH ALL PARTITION: 1 16 (cr=3408387 pr=3380780 pw=0 time=964686885 us) 160781139 TABLE ACCESS FULL TRANSACTION_APPORTIONMENTS PARTITION: 1 16 (cr=3408387 pr=3380780 pw=0 time=804082375 us) 1 PARTITION HASH ITERATOR PARTITION: KEY KEY (cr=436 pr=1 pw=0 time=40549 us) 1 TABLE ACCESS BY LOCAL INDEX ROWID TRANSACTIONS PARTITION: KEY KEY (cr=436 pr=1 pw=0 time=40530 us) 1 INDEX UNIQUE SCAN PK_TRANSACTIONS PARTITION: KEY KEY (cr=3 pr=0 pw=0 time=35 us)(object id 22742) 1 TABLE ACCESS BY INDEX ROWID ACCOUNTS (cr=4 pr=0 pw=0 time=36 us) 1 INDEX UNIQUE SCAN PK_ACCOUNTS (cr=3 pr=0 pw=0 time=23 us)(object id 22375) 1 PARTITION HASH ITERATOR PARTITION: KEY KEY (cr=4 pr=0 pw=0 time=61 us) 1 TABLE ACCESS BY LOCAL INDEX ROWID CUSTOMER_DELIVERY_ITEMS PARTITION: KEY KEY (cr=4 pr=0 pw=0 time=46 us) 1 INDEX UNIQUE SCAN PK_CUSTOMER_DELIVERY_ITEMS PARTITION: KEY KEY (cr=3 pr=0 pw=0 time=31 us)(object id 22727) 1 TABLE ACCESS BY INDEX ROWID PRODUCTS (cr=4 pr=0 pw=0 time=37 us) 1 INDEX UNIQUE SCAN PK_PRODUCTS (cr=3 pr=0 pw=0 time=25 us)(object id 22267) 1 TABLE ACCESS BY INDEX ROWID FLIGHT_SEGMENT_OPERATIONS (cr=4 pr=0 pw=0 time=36 us) 1 INDEX UNIQUE SCAN PK_FLIGHT_SEGMENT_OPERATIONS (cr=3 pr=0 pw=0 time=23 us)(object id 22271) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 20 0.01 0.08 db file scattered read 211345 0.97 700.02 ******************************************************************************** select time_mp, scn, num_mappings, tim_scn_map, orig_thread from smon_scn_time where scn = (select max(scn) from smon_scn_time where thread=0 and scn <= :1) and thread=0 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 327 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 327 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: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SMON_SCN_TIME (cr=327 pr=0 pw=0 time=4044 us) 1 INDEX UNIQUE SCAN SMON_SCN_TO_TIME_IDX (cr=1 pr=0 pw=0 time=18 us)(object id 167552) 1 SORT AGGREGATE (cr=325 pr=0 pw=0 time=3995 us) 2101 TABLE ACCESS CLUSTER SMON_SCN_TIME (cr=325 pr=0 pw=0 time=2113 us) 1 INDEX UNIQUE SCAN SMON_SCN_TO_TIME_IDX (cr=1 pr=0 pw=0 time=6 us)(object id 167552) ******************************************************************************** select ts#,file#,block#,cols,nvl(size$,-1),pctfree$,pctused$,initrans, maxtrans,hashkeys,func,extind,avgchn,nvl(degree,1),nvl(instances,1), nvl(flags,0),nvl(spare1,0) from clu$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 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: 3) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER CLU$ (cr=3 pr=0 pw=0 time=31 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=14 us)(object id 3) ******************************************************************************** UPDATE sys.snap$ SET status = :1, rscn = :2, refhnt = :3, flag = :4 WHERE vname = :5 AND sowner = :6 AND instsite = :7 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 1 2 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE SNAP$ (cr=1 pr=0 pw=0 time=166 us) 1 INDEX UNIQUE SCAN I_SNAP1 (cr=1 pr=0 pw=0 time=22 us)(object id 157) ******************************************************************************** UPDATE sys.snap_reftime$ SET snaptime = :1, loadertime = :2, refscn = :3, fcmaskvec = :4, ejmaskvec = :5, masobj# = :6, sub_handle = :7, change_view = :8, mowner = :9, master = :10 WHERE sowner = :11 AND vname = :12 AND tablenum = :13 AND instsite = :14 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 4 0 0 Execute 12 0.01 0.02 1 12 15 12 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.01 0.02 1 16 15 12 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 ------- --------------------------------------------------- 12 UPDATE SNAP_REFTIME$ (cr=12 pr=1 pw=0 time=12419 us) 12 INDEX UNIQUE SCAN I_SNAP_REFTIME1 (cr=12 pr=0 pw=0 time=118 us)(object id 160) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 1 0.01 0.01 ******************************************************************************** select count(*), max(scn) from sumdelta$, sumdep$ where sumobj# = :1 and p_obj# = tableobj# and scn > :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 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 SORT AGGREGATE (cr=3 pr=0 pw=0 time=105 us) 0 TABLE ACCESS BY INDEX ROWID SUMDEP$ (cr=3 pr=0 pw=0 time=74 us) 1 NESTED LOOPS (cr=3 pr=0 pw=0 time=63 us) 0 TABLE ACCESS FULL SUMDELTA$ (cr=3 pr=0 pw=0 time=56 us) 0 INDEX RANGE SCAN I_SUMDEP$_1 (cr=0 pr=0 pw=0 time=0 us)(object id 330) ******************************************************************************** select count(*), max(scn) from (select sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags from sumpartlog$ sp, sumdep$ sd where sd.sumobj# = :1 and sd.p_obj# = sp.bo# group by sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags minus select sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags from sumpartlog$ sp where sp.bo# not in (select sk.DETAILOBJ# from sumkey$ sk where sk.sumobj# = :1 and sk.DETAILCOLFUNCTION in (2,3) ) and bitand(sp.flags, 2) != 2 and sp.PMOPTYPE in (2,3,5,7) group by sp.BO#, sp.PMOPTYPE, sp.scn, sp.flags) where scn > : 2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.01 0 7 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 SORT AGGREGATE (cr=7 pr=0 pw=0 time=279 us) 0 VIEW (cr=7 pr=0 pw=0 time=256 us) 0 MINUS (cr=7 pr=0 pw=0 time=255 us) 0 SORT UNIQUE NOSORT (cr=4 pr=0 pw=0 time=156 us) 0 SORT GROUP BY (cr=4 pr=0 pw=0 time=149 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=4 pr=0 pw=0 time=118 us) 13 NESTED LOOPS (cr=4 pr=0 pw=0 time=426 us) 12 TABLE ACCESS BY INDEX ROWID SUMDEP$ (cr=2 pr=0 pw=0 time=60 us) 12 INDEX RANGE SCAN I_SUMDEP$_1 (cr=1 pr=0 pw=0 time=28 us)(object id 330) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=2 pr=0 pw=0 time=41 us)(object id 167486) 0 SORT UNIQUE NOSORT (cr=3 pr=0 pw=0 time=94 us) 0 SORT GROUP BY (cr=3 pr=0 pw=0 time=87 us) 0 NESTED LOOPS ANTI (cr=3 pr=0 pw=0 time=69 us) 0 TABLE ACCESS FULL SUMPARTLOG$ (cr=3 pr=0 pw=0 time=44 us) 0 TABLE ACCESS BY INDEX ROWID SUMKEY$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX RANGE SCAN I_SUMKEY$_1 (cr=0 pr=0 pw=0 time=0 us)(object id 17965004) ******************************************************************************** select min(s1.lastrefreshscn) from sum$ s1, sumdetail$ s2 where s1.obj#= s2.sumobj# and s2.detailobj# = :1 and s1.obj#!= :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.01 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 6 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=6 pr=0 pw=0 time=2861 us) 0 HASH JOIN (cr=6 pr=0 pw=0 time=2842 us) 6 TABLE ACCESS FULL SUM$ (cr=3 pr=0 pw=0 time=52 us) 0 TABLE ACCESS FULL SUMDETAIL$ (cr=3 pr=0 pw=0 time=43 us) ******************************************************************************** delete from sumpartlog$ where bo#=:1 and scn<:2 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 1 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 1 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SUMPARTLOG$ (cr=1 pr=0 pw=0 time=35 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=1 pr=0 pw=0 time=31 us) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=26 us)(object id 167486) ******************************************************************************** select OLDEST, flag from sys.mlog$ where mowner = :1 and master = :2 for update call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 18 6 0 Fetch 6 0.00 0.00 0 18 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 36 6 6 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 FOR UPDATE (cr=6 pr=0 pw=0 time=90 us) 2 TABLE ACCESS CLUSTER MLOG$ (cr=6 pr=0 pw=0 time=63 us) 2 INDEX UNIQUE SCAN I_MLOG# (cr=2 pr=0 pw=0 time=19 us)(object id 152) ******************************************************************************** update sys.slog$ set snaptime = :1 where snapid = :2 and mowner = :3 and master = :4 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.01 0 24 30 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.01 0 24 30 6 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 ------- --------------------------------------------------- 0 UPDATE SLOG$ (cr=4 pr=0 pw=0 time=507 us) 1 TABLE ACCESS CLUSTER SLOG$ (cr=4 pr=0 pw=0 time=171 us) 1 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=10 us)(object id 152) ******************************************************************************** SELECT oldest FROM sys.snap_loadertime$ WHERE tableobj# = :1 FOR UPDATE call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 12 6 0 Fetch 6 0.00 0.00 0 0 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 6 6 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 FOR UPDATE (cr=2 pr=0 pw=0 time=44 us) 1 TABLE ACCESS BY INDEX ROWID SNAP_LOADERTIME$ (cr=2 pr=0 pw=0 time=32 us) 1 INDEX UNIQUE SCAN I_SNAP_LOADERTIME1 (cr=1 pr=0 pw=0 time=12 us)(object id 150) ******************************************************************************** UPDATE sys.snap_logdep$ SET snaptime = :1 WHERE snapid = :2 AND tableobj# = :3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.02 0.00 0 6 6 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.02 0.00 0 6 6 6 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 UPDATE SNAP_LOGDEP$ (cr=1 pr=0 pw=0 time=132 us) 1 INDEX UNIQUE SCAN I_SNAP_LOGDEP1 (cr=1 pr=0 pw=0 time=8 us)(object id 148) ******************************************************************************** select log, sysdate, youngest, youngest+1/86400, oldest, oldest_pk, oldest_oid, oldest_new, oldest_seq from sys.mlog$ where master = :2 and mowner = :1 for update call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 18 6 0 Fetch 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 30 6 6 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 FOR UPDATE (cr=5 pr=0 pw=0 time=79 us) 2 TABLE ACCESS CLUSTER MLOG$ (cr=5 pr=0 pw=0 time=58 us) 2 INDEX UNIQUE SCAN I_MLOG# (cr=2 pr=0 pw=0 time=17 us)(object id 152) ******************************************************************************** select snaptime from sys.slog$ where master = :2 and mowner = :1 order by snaptime call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.01 0.00 0 0 0 0 Execute 6 0.01 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.02 0.00 0 12 0 6 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 SORT ORDER BY (cr=2 pr=0 pw=0 time=54 us) 1 TABLE ACCESS CLUSTER SLOG$ (cr=2 pr=0 pw=0 time=29 us) 1 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=12 us)(object id 152) ******************************************************************************** delete from "OCEAN"."MLOG$_FLIGHT_SEGMENT_OPERA" where snaptime$$ <= :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MLOG$_FLIGHT_SEGMENT_OPERA (cr=3 pr=0 pw=0 time=51 us) 0 TABLE ACCESS FULL MLOG$_FLIGHT_SEGMENT_OPERA (cr=3 pr=0 pw=0 time=48 us) ******************************************************************************** update sys.mlog$ set oldest = :1, oldest_pk = :2, oldest_oid = :3, oldest_new = :4, youngest = :5, oldest_seq = :6 where master = :7 and mowner = :8 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 24 6 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 24 6 6 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 ------- --------------------------------------------------- 0 UPDATE MLOG$ (cr=4 pr=0 pw=0 time=192 us) 1 TABLE ACCESS CLUSTER MLOG$ (cr=4 pr=0 pw=0 time=100 us) 1 INDEX UNIQUE SCAN I_MLOG# (cr=1 pr=0 pw=0 time=13 us)(object id 152) ******************************************************************************** SELECT MIN(snaptime) FROM sys.snap_logdep$ WHERE tableobj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 12 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 18 0.00 0.00 0 12 0 6 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 SORT AGGREGATE (cr=2 pr=0 pw=0 time=63 us) 1 TABLE ACCESS BY INDEX ROWID SNAP_LOGDEP$ (cr=2 pr=0 pw=0 time=39 us) 1 INDEX RANGE SCAN I_SNAP_LOGDEP1 (cr=1 pr=0 pw=0 time=26 us)(object id 148) ******************************************************************************** DELETE FROM sys.sumdelta$ sd WHERE sd.tableobj# = :1 AND sd.timestamp <= :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 6 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SUMDELTA$ (cr=1 pr=0 pw=0 time=22 us) 0 INDEX RANGE SCAN I_SUMDELTA$ (cr=1 pr=0 pw=0 time=19 us)(object id 146) ******************************************************************************** DELETE FROM sys.sumpartlog$ sp WHERE sp.bo# = :1 AND sp.timestamp <= :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.00 0.00 0 6 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 6 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE SUMPARTLOG$ (cr=1 pr=0 pw=0 time=23 us) 0 TABLE ACCESS BY INDEX ROWID SUMPARTLOG$ (cr=1 pr=0 pw=0 time=22 us) 0 INDEX RANGE SCAN I_SUMPARTLOG$ (cr=1 pr=0 pw=0 time=18 us)(object id 167486) ******************************************************************************** delete from "OCEAN"."MLOG$_PRODUCTS" where snaptime$$ <= :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MLOG$_PRODUCTS (cr=3 pr=0 pw=0 time=38 us) 0 TABLE ACCESS FULL MLOG$_PRODUCTS (cr=3 pr=0 pw=0 time=35 us) ******************************************************************************** delete from "OCEAN"."MLOG$_CUSTOMER_DELIVERY_IT" where snaptime$$ <= :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MLOG$_CUSTOMER_DELIVERY_IT (cr=3 pr=0 pw=0 time=45 us) 0 TABLE ACCESS FULL MLOG$_CUSTOMER_DELIVERY_IT (cr=3 pr=0 pw=0 time=41 us) ******************************************************************************** delete from "OCEAN"."MLOG$_TRANSACTION_APPORTIO" where snaptime$$ <= :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 3 3 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 3 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 ------- --------------------------------------------------- 0 DELETE MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=223 us) 1 TABLE ACCESS FULL MLOG$_TRANSACTION_APPORTIO (cr=3 pr=0 pw=0 time=49 us) ******************************************************************************** delete from "OCEAN"."MLOG$_TRANSACTIONS" where snaptime$$ <= :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MLOG$_TRANSACTIONS (cr=3 pr=0 pw=0 time=43 us) 0 TABLE ACCESS FULL MLOG$_TRANSACTIONS (cr=3 pr=0 pw=0 time=41 us) ******************************************************************************** delete from "OCEAN"."MLOG$_ACCOUNTS" where snaptime$$ <= :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 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 3 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE MLOG$_ACCOUNTS (cr=3 pr=0 pw=0 time=49 us) 0 TABLE ACCESS FULL MLOG$_ACCOUNTS (cr=3 pr=0 pw=0 time=47 us) ******************************************************************************** update sumdetail$ set detailobjtype=:3, refreshscn=:5, detaileut=:6, spare4= :7, inline# =:8, dataless =:10, qbcid = :11 where sumobj#=:1 and detailobj#=:2 and detailalias=:4 and instance# =:9 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 6 0.00 0.00 0 0 0 0 Execute 6 0.01 0.00 0 18 6 6 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.01 0 18 6 6 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 ------- --------------------------------------------------- 0 UPDATE SUMDETAIL$ (cr=3 pr=0 pw=0 time=209 us) 1 TABLE ACCESS FULL SUMDETAIL$ (cr=3 pr=0 pw=0 time=52 us) ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.13 0.09 4921598 4932187 16 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.13 0.09 4921598 4932187 16 1 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message from client 2 433.59 438.46 SQL*Net message to client 2 0.00 0.00 log file sync 1 0.00 0.00 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 259 0.08 0.10 0 72 10 0 Execute 642 585.97 1311.81 3380783 3409212 210 61 Fetch 977 0.01 0.18 8 2159 1 791 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1878 586.06 1312.11 3380791 3411443 221 852 Misses in library cache during parse: 81 Misses in library cache during execute: 77 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 30 0.06 0.23 os thread startup 11 0.08 0.91 PX Deq: Join ACK 14 0.00 0.00 PX Deq Credit: send blkd 16 0.00 0.00 PX Deq: Parse Reply 10 0.00 0.00 PX Deq: Execute Reply 514 1.96 219.28 PX Deq: Table Q Normal 1 0.00 0.00 PX Deq: Signal ACK 9 0.00 0.01 enq: PS - contention 2 0.00 0.00 latch: session allocation 1 0.00 0.00 db file scattered read 211345 0.97 700.02 6 user SQL statements in session. 627 internal SQL statements in session. 633 SQL statements in session. ******************************************************************************** Trace file: oq01_ora_5039.trc Trace file compatibility: 10.01.00 Sort options: default 1 session in tracefile. 6 user SQL statements in trace file. 627 internal SQL statements in trace file. 633 SQL statements in trace file. 90 unique SQL statements in trace file. 226859 lines in trace file. 1317 elapsed seconds in trace file.