| 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 |