Line | SQL | Total Time | CPU Time | Elapsed Time | Avg Parse + Exec + Fetch Time | Avg Exec + Fetch Time | Disk Access/Row (bytes) | Total Disk Access (bytes) | Total IO (bytes) | # of Prases | # of Execs | # of Fetches |
---|---|---|---|---|---|---|---|---|---|---|---|---|
557 | select table_name from user_tables call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.10 0.11 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.11 0.60 903 8207 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.22 0.71 903 8207 0 5 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 5 HASH JOIN OUTER (cr=8207 pr=903 pw=0 time=603880 us) 5 NESTED LOOPS OUTER (cr=8200 pr=902 pw=0 time=560003 us) 5 NESTED LOOPS OUTER (cr=8189 pr=902 pw=0 time=559923 us) 5 NESTED LOOPS (cr=8182 pr=902 pw=0 time=559868 us) 1559 NESTED LOOPS OUTER (cr=5062 pr=840 pw=0 time=78079 us) 1559 HASH JOIN (cr=827 pr=754 pw=0 time=15170 us) 8 MERGE JOIN CARTESIAN (cr=15 pr=0 pw=0 time=1093 us) 1 NESTED LOOPS (cr=0 pr=0 pw=0 time=817 us) 1 FIXED TABLE FULL X$KSPPI (cr=0 pr=0 pw=0 time=771 us) 1 FIXED TABLE FIXED INDEX X$KSPPCV (ind:2) (cr=0 pr=0 pw=0 time=40 us) 8 BUFFER SORT (cr=15 pr=0 pw=0 time=400 us) 8 TABLE ACCESS FULL TS$ (cr=15 pr=0 pw=0 time=258 us) 1559 TABLE ACCESS FULL TAB$ (cr=812 pr=754 pw=0 time=6370 us) 1337 TABLE ACCESS CLUSTER SEG$ (cr=4235 pr=86 pw=0 time=210185 us) 1337 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=1561 pr=4 pw=0 time=26500 us)(object id 9) 5 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3120 pr=62 pw=0 time=299997 us) 1559 INDEX UNIQUE SCAN I_OBJ1 (cr=1561 pr=12 pw=0 time=65713 us)(object id 36) 0 INDEX UNIQUE SCAN I_OBJ1 (cr=7 pr=0 pw=0 time=38 us)(object id 36) 4 TABLE ACCESS BY INDEX ROWID OBJ$ (cr=11 pr=0 pw=0 time=56 us) 4 INDEX UNIQUE SCAN I_OBJ1 (cr=7 pr=0 pw=0 time=29 us)(object id 36) 67 TABLE ACCESS FULL USER$ (cr=7 pr=1 pw=0 time=7871 us) error during execute of EXPLAIN PLAN statement ORA-01039: insufficient privileges on underlying objects of the view parse error offset: 86 | 0.71 | 0.11 | 0.60 | 0.71 | 0.60 | 180 | 903 | 9110 | 1 | 1 | 2 |
252 | 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 3 0.00 0.00 0 0 0 0 Execute 68 0.00 0.00 0 0 0 0 Fetch 68 0.01 0.07 26 204 0 1075 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 139 0.02 0.07 26 204 0 1075 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 1) | 0.07 | 0.01 | 0.07 | 0.00 | 0.00 | 0 | 26 | 230 | 3 | 68 | 68 |
36 | select * from emp where ename like 'T%' call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.02 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.05 2 3 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID EMP (cr=3 pr=2 pw=0 time=26529 us) 1 INDEX RANGE SCAN EMP_N1 (cr=2 pr=1 pw=0 time=11627 us)(object id 59237) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'EMP' (TABLE) 1 INDEX MODE: ANALYZED (RANGE SCAN) OF 'EMP_N1' (INDEX) | 0.05 | 0.00 | 0.00 | 0.04 | 0.02 | 2 | 2 | 5 | 1 | 1 | 2 |
724 | select count(1) from bonus call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.02 0.04 6 68 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 1 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.02 0.05 7 71 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=3 pr=1 pw=0 time=12505 us) 0 TABLE ACCESS FULL BONUS (cr=3 pr=1 pw=0 time=12449 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 0 TABLE ACCESS MODE: ANALYZED (FULL) OF 'BONUS' (TABLE) | 0.05 | 0.00 | 0.00 | 0.05 | 0.01 | 7 | 7 | 78 | 1 | 1 | 2 |
231 | 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 4 0.00 0.00 0 0 0 0 Execute 159 0.01 0.00 0 0 0 0 Fetch 159 0.00 0.02 5 471 0 153 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 322 0.01 0.03 5 471 0 153 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: RULE Parsing user id: SYS (recursive depth: 1) | 0.03 | 0.01 | 0.00 | 0.00 | 0.00 | 0 | 5 | 476 | 4 | 159 | 159 |
786 | select dname,ename,sal,avg_sal from emp,(select deptno,avg(sal) avg_sal from emp group by deptno) avgsal,dept where emp.deptno = avgsal.deptno and emp.sal > avgsal.avg_sal and emp.deptno = dept.deptno call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.02 0 4 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 5 23 0 6 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.03 5 27 0 6 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 6 NESTED LOOPS (cr=23 pr=5 pw=0 time=8640 us) 6 HASH JOIN (cr=15 pr=5 pw=0 time=8765 us) 3 VIEW (cr=7 pr=5 pw=0 time=7856 us) 3 SORT GROUP BY (cr=7 pr=5 pw=0 time=7841 us) 14 TABLE ACCESS FULL EMP (cr=7 pr=5 pw=0 time=7510 us) 14 TABLE ACCESS FULL EMP (cr=8 pr=0 pw=0 time=79 us) 6 TABLE ACCESS BY INDEX ROWID DEPT (cr=8 pr=0 pw=0 time=145 us) 6 INDEX UNIQUE SCAN PK_DEPT (cr=2 pr=0 pw=0 time=74 us)(object id 49058) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 6 NESTED LOOPS 6 HASH JOIN 3 VIEW 3 SORT (GROUP BY) 14 TABLE ACCESS MODE: ANALYZED (FULL) OF 'EMP' (TABLE) 14 TABLE ACCESS MODE: ANALYZED (FULL) OF 'EMP' (TABLE) 6 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'DEPT' (TABLE) 6 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'PK_DEPT' (INDEX (UNIQUE)) | 0.03 | 0.00 | 0.00 | 0.02 | 0.00 | 0 | 5 | 32 | 1 | 1 | 2 |
201 | select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_obj#, nvl(property,0),subname,d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# 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 10 0.00 0.01 2 23 0 8 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.01 0.02 2 23 0 8 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=6 pr=2 pw=0 time=12197 us) 1 NESTED LOOPS OUTER (cr=6 pr=2 pw=0 time=12126 us) 1 TABLE ACCESS BY INDEX ROWID DEPENDENCY$ (cr=3 pr=2 pw=0 time=12063 us) 1 INDEX RANGE SCAN I_DEPENDENCY1 (cr=2 pr=1 pw=0 time=9351 us)(object id 125) 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=31 us)(object id 36) | 0.02 | 0.00 | 0.00 | 0.01 | 0.01 | 0 | 2 | 25 | 2 | 2 | 10 |
271 | select order#,columns,types from access$ where d_obj#=: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 9 0.00 0.01 2 18 0 7 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.02 2 18 0 7 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 BY INDEX ROWID ACCESS$ (cr=2 pr=1 pw=0 time=6507 us) 0 INDEX RANGE SCAN I_ACCESS1 (cr=2 pr=1 pw=0 time=6497 us)(object id 127) | 0.02 | 0.00 | 0.00 | 0.01 | 0.01 | 0 | 2 | 20 | 2 | 2 | 9 |
704 | 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 2 0.00 0.00 0 0 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 2 4 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.02 2 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: 1) | 0.02 | 0.00 | 0.00 | 0.01 | 0.01 | 0 | 2 | 6 | 2 | 2 | 2 |
755 | select count(1) from salgrade call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 23 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.01 6 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.02 6 30 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 1 SORT AGGREGATE (cr=7 pr=6 pw=0 time=19877 us) 5 TABLE ACCESS FULL SALGRADE (cr=7 pr=6 pw=0 time=19831 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 SORT (AGGREGATE) 5 TABLE ACCESS MODE: ANALYZED (FULL) OF 'SALGRADE' (TABLE) | 0.02 | 0.00 | 0.00 | 0.01 | 0.01 | 6 | 6 | 36 | 1 | 1 | 2 |
87 | select * from dept 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 6 8 0 5 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.01 6 8 0 5 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 5 TABLE ACCESS FULL DEPT (cr=8 pr=6 pw=0 time=8264 us) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 5 TABLE ACCESS MODE: ANALYZED (FULL) OF 'DEPT' (TABLE) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 6 | 14 | 1 | 1 | 2 |
149 | 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 3 0.00 0.00 0 0 0 0 Execute 5 0.00 0.00 0 0 0 0 Fetch 5 0.00 0.00 1 14 0 4 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13 0.00 0.01 1 14 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: 1) Rows Row Source Operation ------- --------------------------------------------------- 2 TABLE ACCESS BY INDEX ROWID OBJ#(18) (cr=8 pr=1 pw=0 time=7032 us) 2 INDEX RANGE SCAN OBJ#(37) (cr=6 pr=1 pw=0 time=6926 us)(object id 37) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 15 | 3 | 5 | 5 |
321 | 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 57 0.00 0.00 2 9 0 54 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 63 0.00 0.01 2 9 0 54 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 ------- --------------------------------------------------- 47 SORT ORDER BY (cr=3 pr=2 pw=0 time=6728 us) 47 TABLE ACCESS CLUSTER OBJ#(21) (cr=3 pr=2 pw=0 time=6642 us) 1 INDEX UNIQUE SCAN OBJ#(3) (cr=2 pr=1 pw=0 time=6407 us)(object id 3) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 2 | 11 | 3 | 3 | 57 |
435 | 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 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 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) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 2 | 1 | 1 | 1 |
454 | 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 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 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) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 2 | 1 | 1 | 1 |
500 | 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 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.01 1 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) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 2 | 1 | 1 | 1 |
604 | 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 0 0 Execute 2 0.00 0.00 0 0 0 0 Fetch 2 0.00 0.00 0 8 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.01 0 8 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: 1) | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 8 | 2 | 2 | 2 |
629 | 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 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2 0.00 0.00 0 0 0 0 Execute 2 0.01 0.01 0 0 0 0 Fetch 2 0.00 0.00 0 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.01 0.01 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) | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0 | 0 | 6 | 2 | 2 | 2 |
19 | alter session set sql_trace=TRUE 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 mode: ALL_ROWS Parsing user id: 57 (SCOTT) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 1 | 0 |
67 | 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 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: 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 12 | 4 | 4 | 4 |
116 | select * from dept where deptno < 40 and dname like 'A%' 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 1 4 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.00 0.00 1 4 0 1 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) Rows Row Source Operation ------- --------------------------------------------------- 1 TABLE ACCESS BY INDEX ROWID DEPT (cr=4 pr=1 pw=0 time=278 us) 3 INDEX RANGE SCAN PK_DEPT (cr=2 pr=1 pw=0 time=272 us)(object id 49058) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT MODE: ALL_ROWS 1 TABLE ACCESS MODE: ANALYZED (BY INDEX ROWID) OF 'DEPT' (TABLE) 3 INDEX MODE: ANALYZED (RANGE SCAN) OF 'PK_DEPT' (INDEX (UNIQUE)) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 5 | 1 | 1 | 2 |
176 | select node,owner,name from syn$ where obj#=:1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 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 OBJ#(61) (cr=3 pr=2 pw=0 time=457 us) 1 INDEX UNIQUE SCAN OBJ#(105) (cr=2 pr=1 pw=0 time=319 us)(object id 105) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 2 | 5 | 1 | 1 | 1 |
296 | select cols,audit$,textlength,intcols,property,flags,rowid from view$ 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 2 3 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 2 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 OBJ#(62) (cr=3 pr=2 pw=0 time=519 us) 1 INDEX UNIQUE SCAN OBJ#(103) (cr=2 pr=1 pw=0 time=182 us)(object id 103) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2 | 2 | 5 | 1 | 1 | 1 |
351 | select text from view$ where rowid=: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 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS BY USER ROWID VIEW$ (cr=0 pr=0 pw=0 time=0 us) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 2 | 1 | 1 | 1 |
375 | 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 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 6 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9 0.00 0.00 1 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) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 7 | 3 | 3 | 3 |
395 | 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 3 0.00 0.00 0 0 0 0 Execute 3 0.00 0.00 0 0 0 0 Fetch 4 0.00 0.00 1 7 0 1 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10 0.00 0.00 1 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) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 1 | 1 | 8 | 3 | 3 | 4 |
415 | 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.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) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 3 | 1 | 1 | 1 |
473 | 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.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 ORDER BY (cr=3 pr=0 pw=0 time=175 us) 0 TABLE ACCESS CLUSTER LOB$ (cr=3 pr=0 pw=0 time=113 us) 1 INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=56 us)(object id 3) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 3 | 1 | 1 | 1 |
519 | 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 48 0.00 0.00 0 3 0 47 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 50 0.00 0.00 0 3 0 47 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 3 | 1 | 1 | 48 |
538 | 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.00 0.00 0 0 0 0 Fetch 1 0.00 0.00 1 1 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 3 0.00 0.00 1 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) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 1 | 2 | 1 | 1 | 1 |
658 | 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 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: CHOOSE Parsing user id: SYS (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 0 TABLE ACCESS CLUSTER SEG$ (cr=0 pr=0 pw=0 time=0 us) 0 INDEX UNIQUE SCAN I_FILE#_BLOCK# (cr=0 pr=0 pw=0 time=0 us)(object id 9) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 6 | 2 | 2 | 2 |
685 | select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=: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 0 2 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6 0.00 0.00 0 2 0 0 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: CHOOSE Parsing user id: SYS (recursive depth: 1) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 2 | 2 | 2 | 2 |
833 | alter session set sql_trace=FALSE 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 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2 0.00 0.00 0 0 0 0 Misses in library cache during parse: 1 Optimizer mode: ALL_ROWS Parsing user id: 57 (SCOTT) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 1 | 1 | 0 |
Related Books |