| 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
|
Related Sponsored Links SWOOT - One Day, One Software Deal Contact advertise@dirisala.net for pricing. Only relevant advertisements please. The visitors to this page are very highly targeted, typically DBAs and Developers from large corporations who are troubleshooting Oracle database SQL performance problems. |