TKPROF: Release 9.2.0.4.0 - Production on Tue Oct 19 17:12:00 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Trace file: primary_ora_13730.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 ******************************************************************************** alter session set events '10046 trace name context forever,level 12' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.00 0 0 0 0 Misses in library cache during parse: 0 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: SYS 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 1.99 1.99 ******************************************************************************** alter database character set INTERNAL_USE ZHS16CGB231280 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 4.88 6.04 910 16825 18099 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 4.88 6.04 910 16825 18099 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ control file sequential read 4 0.00 0.00 control file parallel write 2 0.05 0.08 log file sync 2 0.08 0.08 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 18.06 18.06 ******************************************************************************** select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 17 0.00 0.00 0 0 0 0 Fetch 17 0.00 0.00 0 17 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 44 0.00 0.00 0 17 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID OBJ#(31) (cr=3 r=0 w=0 time=162 us) 0 INDEX RANGE SCAN OBJ#(52) (cr=3 r=0 w=0 time=146 us)(object id 52) ******************************************************************************** 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 10 0.01 0.00 0 0 0 0 Execute 17 0.00 0.00 0 0 0 0 Fetch 98 0.00 0.00 0 114 0 81 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 125 0.01 0.01 0 114 0 81 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 25 TABLE ACCESS CLUSTER OBJ#(31) (cr=31 r=0 w=0 time=885 us) 3 INDEX UNIQUE SCAN OBJ#(30) (cr=3 r=0 w=0 time=83 us)(object id 30) ******************************************************************************** select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 0.00 0 0 0 0 Execute 81 0.03 0.01 0 0 0 0 Fetch 162 0.01 0.00 1 324 0 81 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 252 0.04 0.02 1 324 0 81 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 25 TABLE ACCESS BY INDEX ROWID OBJ#(32) (cr=100 r=1 w=0 time=2320 us) 25 INDEX RANGE SCAN OBJ#(55) (cr=75 r=1 w=0 time=1696 us)(object id 55) 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 col$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 2.42 2.40 3 362 11505 11015 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 2.42 2.41 3 362 11505 11015 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=404 r=5 w=0 time=2409223 us) 11015 TABLE ACCESS FULL COL$ (cr=349 r=0 w=0 time=93841 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.00 0.00 ******************************************************************************** select file# from file$ where ts#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 16 0.00 0.00 0 0 0 0 Execute 16 0.02 0.00 0 0 0 0 Fetch 32 0.01 0.00 2 48 0 16 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 64 0.03 0.01 2 48 0 16 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID FILE$ (cr=3 r=2 w=0 time=428 us) 1 INDEX RANGE SCAN I_FILE2 (cr=2 r=1 w=0 time=273 us)(object id 42) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** 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 10 0.00 0.00 0 0 0 0 Execute 12 0.01 0.00 0 0 0 0 Fetch 12 0.02 0.03 9 111 0 12 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 34 0.03 0.04 9 111 0 12 Misses in library cache during parse: 1 Misses in library cache during execute: 2 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID OBJ#(18) (cr=3 r=0 w=0 time=95 us) 1 INDEX RANGE SCAN OBJ#(37) (cr=2 r=0 w=0 time=59 us)(object id 37) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 9 0.00 0.00 ******************************************************************************** select ts#,file#,block#,nvl(bobj#,0),nvl(tab#,0),intcols,nvl(clucols,0), audit$,flags,pctfree$,pctused$,initrans,maxtrans,rowcnt,blkcnt,empcnt, avgspc,chncnt,avgrln,analyzetime, samplesize,cols,property,nvl(degree,1), nvl(instances,1),avgspc_flb,flbcnt,kernelcols,nvl(trigflag, 0),nvl(spare1,0) ,nvl(spare2,0),spare4,spare6 from tab$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.01 0.00 0 0 0 0 Execute 14 0.01 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 43 0 14 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.02 0.00 0 43 0 14 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER OBJ#(4) (cr=3 r=0 w=0 time=104 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=36 us)(object id 3) ******************************************************************************** select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts, NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, NVL(spare1,0) from seg$ where ts#=:1 and file#=:2 and block#=:3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 21 0.00 0.00 0 0 0 0 Execute 21 0.01 0.00 0 0 0 0 Fetch 21 0.00 0.00 2 63 0 21 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 63 0.01 0.01 2 63 0 21 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER SEG$ (cr=3 r=0 w=0 time=102 us) 1 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=2 r=0 w=0 time=37 us)(object id 9) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 21 0.01 0.04 log file switch completion 3 0.15 0.30 ******************************************************************************** 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,spare2,spare6, decode(i.pctthres$,null, null, mod(trunc(i.pctthres$/256),256)) from ind$ i, (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.bo#= :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 33 0.02 0.00 0 70 0 18 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 58 0.02 0.01 0 70 0 18 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 MERGE JOIN OUTER (cr=5 r=0 w=0 time=452 us) 2 SORT JOIN (cr=3 r=0 w=0 time=276 us) 2 TABLE ACCESS CLUSTER OBJ#(19) (cr=3 r=0 w=0 time=113 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=38 us)(object id 3) 0 SORT JOIN (cr=2 r=0 w=0 time=95 us) 0 VIEW (cr=2 r=0 w=0 time=80 us) 0 SORT GROUP BY (cr=2 r=0 w=0 time=76 us) 0 TABLE ACCESS CLUSTER OBJ#(31) (cr=2 r=0 w=0 time=59 us) 1 INDEX UNIQUE SCAN OBJ#(30) (cr=1 r=0 w=0 time=14 us)(object id 30) ******************************************************************************** select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 18 0.01 0.00 0 0 0 0 Fetch 50 0.00 0.00 0 100 0 32 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 78 0.01 0.01 0 100 0 32 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 7 TABLE ACCESS BY INDEX ROWID OBJ#(20) (cr=18 r=0 w=0 time=350 us) 7 INDEX RANGE SCAN OBJ#(40) (cr=11 r=0 w=0 time=225 us)(object id 40) ******************************************************************************** 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 9 0.00 0.00 0 0 0 0 Execute 15 0.00 0.00 0 0 0 0 Fetch 154 0.01 0.00 0 49 0 139 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 178 0.01 0.01 0 49 0 139 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 44 SORT ORDER BY (cr=9 r=0 w=0 time=1296 us) 44 TABLE ACCESS CLUSTER OBJ#(21) (cr=9 r=0 w=0 time=492 us) 3 INDEX UNIQUE SCAN OBJ#(3) (cr=6 r=0 w=0 time=100 us)(object id 3) 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 ******************************************************************************** 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 5 0.00 0.00 0 0 0 0 Execute 39 0.00 0.01 0 0 0 0 Fetch 39 0.01 0.00 0 117 0 39 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 83 0.01 0.01 0 117 0 39 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 28 TABLE ACCESS BY INDEX ROWID OBJ#(18) (cr=84 r=0 w=0 time=1562 us) 28 INDEX UNIQUE SCAN OBJ#(36) (cr=56 r=0 w=0 time=849 us)(object id 36) 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 ******************************************************************************** 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 10 0.00 0.00 0 0 0 0 Execute 14 0.00 0.00 0 0 0 0 Fetch 14 0.01 0.00 0 28 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.01 0.00 0 28 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=2 r=0 w=0 time=145 us) 0 TABLE ACCESS BY INDEX ROWID OBJ#(90) (cr=2 r=0 w=0 time=66 us) 0 INDEX RANGE SCAN OBJ#(108) (cr=2 r=0 w=0 time=61 us)(object id 108) ******************************************************************************** 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 10 0.00 0.00 0 0 0 0 Execute 14 0.01 0.00 0 0 0 0 Fetch 14 0.00 0.00 0 28 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 38 0.01 0.00 0 28 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT GROUP BY (cr=2 r=0 w=0 time=119 us) 0 TABLE ACCESS BY INDEX ROWID OBJ#(90) (cr=2 r=0 w=0 time=65 us) 0 INDEX RANGE SCAN OBJ#(108) (cr=2 r=0 w=0 time=59 us)(object id 108) ******************************************************************************** update argument$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.02 1 1 0 0 Execute 1 2.19 2.48 305 447 12979 12675 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 2.22 2.50 306 448 12979 12675 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=447 r=305 w=0 time=2481439 us) 12675 TABLE ACCESS FULL ARGUMENT$ (cr=309 r=305 w=0 time=403811 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 28 0.03 0.30 db file sequential read 1 0.00 0.00 ******************************************************************************** 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) from clu$ 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 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 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER OBJ#(5) (cr=3 r=0 w=0 time=101 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=36 us)(object id 3) ******************************************************************************** update collection$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 1 80 0 0 Execute 1 0.05 0.12 488 492 15 5 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.06 0.14 489 572 15 5 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=492 r=488 w=0 time=125335 us) 5 TABLE ACCESS FULL COLLECTION$ (cr=492 r=488 w=0 time=122866 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 39 0.00 0.10 ******************************************************************************** update attribute$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 44 0 0 Execute 1 0.09 0.09 0 492 1025 627 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.10 0.10 0 536 1025 627 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=492 r=0 w=0 time=96922 us) 627 TABLE ACCESS FULL ATTRIBUTE$ (cr=492 r=0 w=0 time=11679 us) ******************************************************************************** update parameter$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 90 0 0 Execute 1 0.07 0.06 0 492 287 273 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.08 0.07 0 582 287 273 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=492 r=0 w=0 time=59854 us) 273 TABLE ACCESS FULL PARAMETER$ (cr=492 r=0 w=0 time=6068 us) ******************************************************************************** update result$ set charsetid = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 0 73 0 0 Execute 1 0.03 0.02 0 492 102 98 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.05 0.03 0 565 102 98 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=492 r=0 w=0 time=23032 us) 98 TABLE ACCESS FULL RESULT$ (cr=492 r=0 w=0 time=4642 us) 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 partcol$ set spare1 = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 1 62 0 0 Execute 1 0.00 0.00 1 3 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 2 65 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=3 r=1 w=0 time=332 us) 0 TABLE ACCESS FULL PARTCOL$ (cr=3 r=1 w=0 time=324 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** update subpartcol$ set spare1 = :1 where charsetform = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.03 0.01 1 62 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.03 0.01 1 65 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=3 r=0 w=0 time=90 us) 0 TABLE ACCESS FULL SUBPARTCOL$ (cr=3 r=0 w=0 time=84 us) ******************************************************************************** update props$ set value$ = :1 where name = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 12 0 0 Execute 1 0.01 0.00 0 3 1 1 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.01 0.00 0 15 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=3 r=0 w=0 time=448 us) 1 TABLE ACCESS FULL OBJ#(101) (cr=3 r=0 w=0 time=135 us) ******************************************************************************** select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, d_owner#, nvl(property,0),subname from dependency$,obj$ where d_obj#=:1 and p_obj#=obj#(+) order by order# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 4 0.01 0.00 0 0 0 0 Fetch 4 0.00 0.00 0 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 8 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=2 r=0 w=0 time=124 us) 0 NESTED LOOPS OUTER (cr=2 r=0 w=0 time=70 us) 0 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=2 r=0 w=0 time=67 us) 0 INDEX RANGE SCAN I_DEPENDENCY1 (cr=2 r=0 w=0 time=61 us)(object id 127) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36) ******************************************************************************** select order#,columns,types from access$ where d_obj#=:1 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 8 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 8 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ACCESS$ (cr=2 r=0 w=0 time=65 us) 0 INDEX RANGE SCAN I_ACCESS1 (cr=2 r=0 w=0 time=59 us)(object id 129) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 4 0.00 0.00 ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.00 0.00 0 9 0 3 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY (cr=3 r=0 w=0 time=208 us) 1 TABLE ACCESS CLUSTER OBJ#(283) (cr=3 r=0 w=0 time=103 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=40 us)(object id 3) ******************************************************************************** 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 9 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=3 r=0 w=0 time=143 us) 0 TABLE ACCESS CLUSTER OBJ#(286) (cr=3 r=0 w=0 time=90 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=38 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 9 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=3 r=0 w=0 time=140 us) 0 TABLE ACCESS CLUSTER OBJ#(352) (cr=3 r=0 w=0 time=90 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=37 us)(object id 3) ******************************************************************************** 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 3 0.01 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 6 0.00 0.00 0 9 0 3 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 12 0.01 0.00 0 9 0 3 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT ORDER BY (cr=3 r=0 w=0 time=197 us) 1 TABLE ACCESS CLUSTER LOB$ (cr=3 r=0 w=0 time=101 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 r=0 w=0 time=36 us)(object id 3) ******************************************************************************** select col#,intcol#,reftyp,stabid,expctoid from refcon$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.01 0.00 0 9 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=3 r=0 w=0 time=142 us) 0 TABLE ACCESS CLUSTER OBJ#(362) (cr=3 r=0 w=0 time=91 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=39 us)(object id 3) ******************************************************************************** select col#,intcol#,charsetid,charsetform from col$ where obj#=:1 order by intcol# asc call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.01 0.00 0 0 0 0 Fetch 9 0.00 0.00 0 9 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15 0.01 0.00 0 9 0 6 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 2 SORT ORDER BY (cr=3 r=0 w=0 time=209 us) 2 TABLE ACCESS CLUSTER OBJ#(21) (cr=3 r=0 w=0 time=107 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=37 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 0 9 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 0 9 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=3 r=0 w=0 time=142 us) 0 TABLE ACCESS CLUSTER OBJ#(365) (cr=3 r=0 w=0 time=89 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 r=0 w=0 time=39 us)(object id 3) ******************************************************************************** select SYS_NC_OID$ from kotad$ call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.02 1 1 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 3625 0.21 0.46 84 3717 0 3624 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3627 0.23 0.48 85 3718 0 3624 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 3624 TABLE ACCESS FULL KOTAD$ (cr=3717 r=84 w=0 time=408072 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file scattered read 11 0.17 0.26 ******************************************************************************** select obj# from oid$ where user#=:1 and oid$=:2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.02 0.00 1 1 0 0 Execute 7 0.00 0.00 0 0 0 0 Fetch 7 0.00 0.00 3 18 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16 0.02 0.01 4 19 0 4 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ#(293) (cr=10 r=3 w=0 time=659 us) 2 INDEX UNIQUE SCAN OBJ#(294) (cr=8 r=2 w=0 time=413 us)(object id 294) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 3 0.00 0.00 ******************************************************************************** select name,password,datats#,tempts#,type#,defrole,resource$, ptime, exptime, ltime, astatus, lcount, decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP', defschclass) from user$ where user#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER USER$ (cr=2 r=0 w=0 time=92 us) 1 INDEX UNIQUE SCAN I_USER# (cr=1 r=0 w=0 time=29 us)(object id 11) ******************************************************************************** select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled from obj$ o,user$ u,trigger$ t where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user# order by o.obj# call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 1 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 1 3 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 SORT ORDER BY (cr=1 r=1 w=0 time=313 us) 0 NESTED LOOPS (cr=1 r=1 w=0 time=259 us) 0 NESTED LOOPS (cr=1 r=1 w=0 time=256 us) 0 TABLE ACCESS BY INDEX ROWID TRIGGER$ (cr=1 r=1 w=0 time=254 us) 0 INDEX RANGE SCAN I_TRIGGER1 (cr=1 r=1 w=0 time=244 us)(object id 130) 0 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=0 r=0 w=0 time=0 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36) 0 TABLE ACCESS CLUSTER USER$ (cr=0 r=0 w=0 time=0 us) 0 INDEX UNIQUE SCAN I_USER# (cr=0 r=0 w=0 time=0 us)(object id 11) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 2 0.00 0.00 ******************************************************************************** select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags from partobj$ where obj# = :1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 3 0.02 0.00 1 43 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 3 0.00 0.00 1 3 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.02 0.00 2 46 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID PARTOBJ$ (cr=1 r=0 w=0 time=27 us) 0 INDEX UNIQUE SCAN I_PARTOBJ$ (cr=1 r=0 w=0 time=22 us)(object id 227) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 5 0.00 0.00 ******************************************************************************** select metadata from kopm$ where name='DB_FDO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.01 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 1 6 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.00 1 6 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS FULL KOPM$ (cr=3 r=1 w=0 time=4714 us) 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 "SYS"."KOTAD$" set SYS_NC_ROWINFO$ = :1 where SYS_NC_OID$ = :2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 0 0 0 0 Execute 1 3.49 3.43 0 3611 7425 3606 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 3.49 3.45 0 3611 7425 3606 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) ******************************************************************************** select audit$,properties from type_misc$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.00 0 1 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.01 0.00 0 3 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS CLUSTER TYPE_MISC$ (cr=2 r=0 w=0 time=35 us) 0 INDEX UNIQUE SCAN I_OBJ# (cr=2 r=0 w=0 time=29 us)(object id 3) ******************************************************************************** select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$, flags from seq$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 0 2 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 0 2 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) ******************************************************************************** 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 5 0.01 0.01 0 38 0 0 Execute 5 0.01 0.01 1 5 13 5 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.02 0.02 1 43 13 5 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 2) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE (cr=1 r=0 w=0 time=444 us) 1 INDEX UNIQUE SCAN I_SEQ1 (cr=1 r=0 w=0 time=33 us)(object id 107) 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 kopm$ set metadata = :1, length = :2 where name='DB_FDO' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 13 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 16 1 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 UPDATE (cr=3 r=0 w=0 time=434 us) 1 TABLE ACCESS FULL KOPM$ (cr=3 r=0 w=0 time=125 us) ******************************************************************************** select value$ from props$ where name like '%SET%' 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 5 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 0 5 0 2 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS FULL PROPS$ (cr=5 r=0 w=0 time=440 us) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net message from client 2 69.95 69.95 ******************************************************************************** ALTER DATABASE CLOSE NORMAL call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.17 0.42 10 191 28 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.17 0.42 10 191 28 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ control file sequential read 5 0.00 0.00 direct path read 4 0.00 0.00 checkpoint completed 1 0.08 0.08 rdbms ipc reply 3 0.17 0.17 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** delete from sys.mon_mods$ m where not exists (select 1 from sys.obj$ o where o.obj# = m.obj# ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.01 1 1 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.02 0.01 1 4 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE (cr=3 r=0 w=0 time=87 us) 0 FILTER (cr=3 r=0 w=0 time=82 us) 0 TABLE ACCESS FULL MON_MODS$ (cr=3 r=0 w=0 time=79 us) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=0 r=0 w=0 time=0 us)(object id 36) 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 ******************************************************************************** delete from sys.col_usage$ c where not exists (select 1 from sys.obj$ o where o.obj# = c.obj# ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.01 1 34 0 0 Execute 1 0.00 0.00 1 39 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.01 2 73 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 DELETE (cr=39 r=1 w=0 time=905 us) 0 FILTER (cr=39 r=1 w=0 time=900 us) 41 TABLE ACCESS FULL COL_USAGE$ (cr=3 r=1 w=0 time=382 us) 18 INDEX UNIQUE SCAN I_OBJ1 (cr=36 r=0 w=0 time=256 us)(object id 36) 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 undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7, xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 10 0.00 0.00 0 0 0 0 Execute 10 0.03 0.01 0 10 11 10 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 20 0.03 0.01 0 10 11 10 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 UPDATE (cr=1 r=0 w=0 time=372 us) 1 INDEX UNIQUE SCAN I_UNDO1 (cr=1 r=0 w=0 time=28 us)(object id 34) ******************************************************************************** select name,online$,contents$,undofile#,undoblock#,blocksize,dflmaxext, dflinit,dflincr,dflextpct,dflminext, dflminlen, owner#,scnwrp,scnbas, NVL(pitrscnwrp, 0), NVL(pitrscnbas, 0), dflogging, bitmapped, inc#, flags, plugged, NVL(spare1,0), NVL(spare2,0) from ts$ where ts#=:1 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 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 1 3 0 1 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS CLUSTER TS$ (cr=2 r=1 w=0 time=257 us) 1 INDEX UNIQUE SCAN I_TS# (cr=1 r=0 w=0 time=28 us)(object id 7) 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 ******************************************************************************** ALTER DATABASE DISMOUNT call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 2.56 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 2.56 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: SYS Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ rdbms ipc reply 4 0.03 0.03 reliable message 3 0.99 2.52 SQL*Net message to client 1 0.00 0.00 SQL*Net message from client 1 0.00 0.00 ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 5 5.05 9.03 920 17016 18127 0 Fetch 2 0.00 0.00 0 5 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11 5.05 9.03 920 17021 18127 2 Misses in library cache during parse: 4 Misses in library cache during execute: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7 0.00 0.00 SQL*Net message from client 7 69.95 90.01 control file sequential read 14 0.00 0.00 control file parallel write 2 0.05 0.08 log file sync 2 0.08 0.08 checkpoint completed 5 4.99 15.65 direct path read 8 0.00 0.00 rdbms ipc reply 8 0.17 0.20 reliable message 3 0.99 2.52 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 214 0.26 0.26 9 556 0 0 Execute 372 8.52 8.78 799 6457 33364 28316 Fetch 4347 0.30 0.55 105 4950 0 4099 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4933 9.08 9.60 913 11963 33364 32415 Misses in library cache during parse: 47 Misses in library cache during execute: 3 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ db file sequential read 62 0.01 0.06 db file scattered read 78 0.17 0.67 log file switch completion 3 0.15 0.30 5 user SQL statements in session. 214 internal SQL statements in session. 219 SQL statements in session. ******************************************************************************** Trace file: primary_ora_13730.trc Trace file compatibility: 9.00.01 Sort options: default 1 session in tracefile. 5 user SQL statements in trace file. 214 internal SQL statements in trace file. 219 SQL statements in trace file. 52 unique SQL statements in trace file. 69152 lines in trace file.