Trace Analyzer Report: 832 1

Trace Identification
Trace Header
SQL Statements Count
Time Summary
User Non-Recursive Totals
User Recursive Totals
Internal Totals
Top 20 SQL Statements
List of 18 Unique SQL Statements
Gaps of no Trace Activity (2)
Non-Default Initialization Parameters
SQL Statements Details

Trace Identification

Trace Filename:	xe_ora_832.trc
UDUMP Directory:	C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
Instance Name:	xe
Host Name:	Unknown
RDBMS Version:	10.2.0.1.0
Trace Size (bytes):	97506
Trace Lines:	1921
Trace Start Time:	16-JUL-06 14:41:40
Trace End Time:	16-JUL-06 14:42:35
Trace Duration (tot secs):	54.972
2 Gaps (tot secs):	54.558
Analyzed on Same Instance?:	Y
Trace Truncated?:	N
Report Generated by User:	HR

Trace Header

Dump file c:\oraclexe\app\oracle\admin\xe\udump\xe_ora_832.trc
Sun Jul 16 14:41:40 2006
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Windows XP Version V5.1 Service Pack 2
CPU                 : 2 - type 586
Process Affinity    : 0x00000000
Memory (Avail/Total): Ph:1330M/2038M, Ph+PgF:2754M/3931M, VA:1313M/2047M
Instance name: xe
 
Redo thread mounted by this instance: 1
 
Oracle process number: 21
 
Windows thread id: 832, image: ORACLE.EXE (SHAD)
 
 
*** 2006-07-16 14:41:40.243
*** ACTION NAME:() 2006-07-16 14:41:40.228
*** MODULE NAME:(SQL*Plus) 2006-07-16 14:41:40.228
*** SERVICE NAME:(SYS$USERS) 2006-07-16 14:41:40.228
*** SESSION ID:(31.70) 2006-07-16 14:41:40.228

SQL Statements Count

	Statements	Unique
User:	3	3
Internal:	88	15
Total:	91	18

Time Summary (secs)

	User (Non-Recursive)	Internal
CPU Time (secs):	0.219	0.252
Elapsed Time (secs):	0.417	0.497
Wait Time (non-idle):	0.007	0.163
Wait Time (idle):	0.001	54.525

User Non-Recursive Totals (user>0 and depth:0)

hide

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	2	0.219	0.408	11	311	0	2
Execute:	3	0.000	0.001	0	0	0	1
Fetch:	2	0.000	0.008	1	1	1	0
Total:	7	0.219	0.417	12	312	1	3

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	1	0.007	0.007
Total non-idle:	1	0.007	0.007

Idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
SQL*Net message from client:	4	0.001	0.001
SQL*Net message to client:	4	0.000	0.000
Total idle:	8	0.001	0.001

User Recursive Totals (user>0 and depth>0)

hide

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Current (blocks)	Rows Returned	Cache Misses

Internal Totals (user:0)

hide

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	20	0.016	0.018	0	0	0	14
Execute:	87	0.220	0.296	7	146	0	14
Fetch:	134	0.016	0.183	11	311	560	0
Total:	241	0.252	0.497	18	457	560	28

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	11	0.043	0.163
Total non-idle:	11	0.043	0.163

Idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
SQL*Net message from client:	2	36.718	54.525
SQL*Net message to client:	3	0.000	0.000
Total idle:	5	36.718	54.525

Top 20 SQL Statements (according to CPU, Elapsed and Wait Times)

#	CPU Time (secs)	Elapsed Time (secs)	Non-idle Wait (secs)	Idle Wait (secs)	Executions	Logical Reads (blocks)	Physical Reads (blocks)	Rows Returned	Parsed by	Recursive Depth	Comand Type	SQL Ranking
1	0.219	0.415	0.007	0.001	1	312	12	1	33	0	select	1
2	0.000	0.000	0.000	54.525	0	0	0	0	0	0	unknown	2
3	0.094	0.087	0.000	0.000	6	98	3	7	0	1	select	3
4	0.032	0.101	0.081	0.000	29	87	7	478	0	2	select	4
5	0.016	0.041	0.000	0.000	20	59	0	19	0	2	select	5
6	0.016	0.038	0.031	0.000	10	49	1	10	0	1	select	6
7	0.000	0.033	0.000	0.000	1	45	1	10	0	1	select	7
8	0.031	0.055	0.000	0.000	1	43	2	3	0	1	select	8
9	0.000	0.005	0.000	0.000	7	21	0	7	0	1	select	9
10	0.000	0.003	0.000	0.000	7	21	0	7	0	1	select	10
11	0.016	0.069	0.044	0.000	1	14	2	6	0	1	select	11
12	0.000	0.022	0.007	0.000	1	8	2	0	0	1	select	12
13	0.016	0.013	0.000	0.000	1	4	0	1	0	1	select	13
14	0.031	0.023	0.000	0.000	1	3	0	1	0	1	select	14
15	0.000	0.004	0.000	0.000	1	3	0	11	0	1	select	15
16	0.000	0.003	0.000	0.000	1	2	0	0	0	1	select	16
17	0.000	0.002	0.000	0.000	1	0	0	0	33	0	alter session	17
18	0.000	0.000	0.000	0.000	1	0	0	0	33	0	alter session	18

List of 18 Unique SQL Statements

hide

#	CPU Time (secs)	Elapsed Time (secs)	Non-idle Wait (secs)	Idle Wait (secs)	Executions	Logical Reads (blocks)	Physical Reads (blocks)	Rows Returned	Parsed by	Recursive Depth	Comand Type	SQL Ranking
1	0.000	0.000	0.000	0.000	1	0	0	0	33	0	alter session	18
2	0.000	0.000	0.000	54.525	0	0	0	0	0	0	unknown	2
3	0.031	0.023	0.000	0.000	1	3	0	1	0	1	select	14
4	0.016	0.013	0.000	0.000	1	4	0	1	0	1	select	13
5	0.016	0.069	0.044	0.000	1	14	2	6	0	1	select	11
6	0.094	0.087	0.000	0.000	6	98	3	7	0	1	select	3
7	0.016	0.041	0.000	0.000	20	59	0	19	0	2	select	5
8	0.032	0.101	0.081	0.000	29	87	7	478	0	2	select	4
9	0.000	0.004	0.000	0.000	1	3	0	11	0	1	select	15
10	0.000	0.005	0.000	0.000	7	21	0	7	0	1	select	9
11	0.000	0.003	0.000	0.000	7	21	0	7	0	1	select	10
12	0.000	0.022	0.007	0.000	1	8	2	0	0	1	select	12
13	0.000	0.003	0.000	0.000	1	2	0	0	0	1	select	16
14	0.031	0.055	0.000	0.000	1	43	2	3	0	1	select	8
15	0.000	0.033	0.000	0.000	1	45	1	10	0	1	select	7
16	0.016	0.038	0.031	0.000	10	49	1	10	0	1	select	6
17	0.219	0.415	0.007	0.001	1	312	12	1	33	0	select	1
18	0.000	0.002	0.000	0.000	1	0	0	0	33	0	alter session	17

Gaps of no Trace Activity (2)

hide

Line	End Time	Gap Duration (secs)	Cursor Before	Cursor After
32:	16-JUL-06 14:42:16	36.749	2	14
1910:	16-JUL-06 14:42:35	17.809	2	17

Non-Default Initialization Parameters

hide

Parameter	Value
audit_file_dest:	C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
background_dump_dest:	C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
compatible:	10.2.0.1.0
control_files:	C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
core_dump_dest:	C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
db_name:	XE
db_recovery_file_dest:	C:\oraclexe\app\oracle\flash_recovery_area
db_recovery_file_dest_size:	10737418240
dispatchers:	(PROTOCOL=TCP) (SERVICE=XEXDB)
job_queue_processes:	4
open_cursors:	300
os_authent_prefix:
pga_aggregate_target:	199229440
remote_login_passwordfile:	EXCLUSIVE
sessions:	49
sga_target:	599785472
shared_servers:	4
spfile:	C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
undo_management:	AUTO
undo_tablespace:	UNDO
user_dump_dest:	C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP

SQL Statements Details

hash:1576194328 length:69 depth:0(non-recursive) user:33(user) line:25 rank:18 prior top

ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'

Call Summary

Call Type	Call Count	Cache Misses
Parse:	0	0
Execute:	1	1
Fetch:	0	0
Total:	1	1

Idle Wait Events

Idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
SQL*Net message from client:	1	0.000	0.000
SQL*Net message to client:	1	0.000	0.000
Total idle:	2	0.000	0.000

hash:0 length:17 depth:0(non-recursive) user:0(internal) line:31 rank:2 next prior top

Unknown CURSOR #0

Idle Wait Events

Idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
SQL*Net message from client:	2	36.718	54.525
SQL*Net message to client:	3	0.000	0.000
Total idle:	5	36.718	54.525

hash:4125641360 length:198 depth:1(recursive) user:0(internal) line:35 rank:14 next prior top

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 Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.002	0	0	1
Execute:	1	0.031	0.021	0	0	1
Fetch:	1	0.000	0.000	3	1	0
Total:	3	0.031	0.023	3	1	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	3 Values (according to position within SQL)
56:	1	33	"EMPLOYEES"	1

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
1	2	`TABLE ACCESS BY INDEX ROWID OBJ$`	18	3	0	0	0.000
1	1	`INDEX RANGE SCAN I_OBJ2`	37	2	0	0	0.000

hash:2584065658 length:493 depth:1(recursive) user:0(internal) line:61 rank:13 next prior top

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 Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.002	0	0	1
Execute:	1	0.016	0.011	0	0	1
Fetch:	1	0.000	0.000	4	1	0
Total:	3	0.016	0.013	4	1	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
72:	1	12100

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)
1	5	`NESTED LOOPS OUTER`	0	4
1	2	`TABLE ACCESS CLUSTER TAB$`	4	3
1	1	`INDEX UNIQUE SCAN I_OBJ#`	3	2
0	4	`TABLE ACCESS BY INDEX ROWID TAB_STATS$`	708	1
0	3	`INDEX UNIQUE SCAN I_TAB_STATS$_OBJ#`	709	1

hash:3159716790 length:789 depth:1(recursive) user:0(internal) line:80 rank:11 next prior top

select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.003	0	0	0	1
Execute:	1	0.016	0.016	0	0	0	1
Fetch:	7	0.000	0.050	2	14	6	0
Total:	9	0.016	0.069	2	14	6	2

Non-idle Wait Events

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	2	0.031	0.044
Total non-idle:	2	0.031	0.044

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	2 Values (according to position within SQL)
93:	1	12100

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)
6	11	`SORT ORDER BY`	0	14	2
6	10	`HASH JOIN OUTER`	0	14	2
6	5	`NESTED LOOPS OUTER`	0	11	0
6	2	`TABLE ACCESS CLUSTER IND$`	19	9	0
1	1	`INDEX UNIQUE SCAN I_OBJ#`	3	2	0
0	4	`TABLE ACCESS BY INDEX ROWID IND_STATS$`	710	2	0
0	3	`INDEX UNIQUE SCAN I_IND_STATS$_OBJ#`	711	2	0
2	9	`VIEW`	0	3	2
2	8	`SORT GROUP BY`	0	3	2
2	7	`TABLE ACCESS BY INDEX ROWID CDEF$`	31	3	2
10	6	`INDEX RANGE SCAN I_CDEF2`	51	2	1

hash:2280069326 length:67 depth:1(recursive) user:0(internal) line:98 rank:3 next prior top

select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where obj#=:1

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.016	0.001	0	0	0	1
Execute:	6	0.078	0.086	3	72	0	1
Fetch:	13	0.000	0.000	0	26	7	0
Total:	20	0.094	0.087	3	98	7	2

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
696:	4	0.078	0.087	3	76	1	2	1
713:	3	0.000	0.000	0	4	1	0	3
728:	3	0.000	0.000	0	4	1	0	4
743:	3	0.000	0.000	0	4	1	0	5
758:	3	0.000	0.000	0	4	1	0	6
773:	4	0.016	0.000	0	6	2	0	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
696:	1	12101
713:	3	12102
728:	4	12107
743:	5
758:	6
773:	2

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
1	2	`TABLE ACCESS BY INDEX ROWID ICOL$`	20	4	0	0	0.000
1	1	`INDEX RANGE SCAN I_ICOL1`	40	3	0	0	0.000

hash:864012087 length:210 depth:2(recursive) user:0(internal) line:103 rank:5 next prior top

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 Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.001	0	0	1
Execute:	20	0.016	0.039	0	0	1
Fetch:	20	0.000	0.001	59	19	0
Total:	41	0.016	0.041	59	19	2

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	CPU Time (secs)	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
119:	3	0.016	0.015	3	1	2	1
139:	2	0.000	0.021	3	1	0	2
499:	2	0.000	0.000	3	1	0	3
546:	2	0.000	0.000	3	1	0	4
566:	2	0.000	0.000	3	1	0	5
665:	2	0.000	0.000	3	1	0	6
685:	2	0.000	0.000	3	1	0	7
1101:	2	0.000	0.000	3	1	0	8
1183:	2	0.000	0.000	3	1	0	9
1334:	2	0.000	0.000	3	1	0	10

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	2 Values (according to position within SQL)
119:	1	20	1
139:	2	20	2
499:	3	20	10
546:	4	20	4
566:	5	20	8
665:	6	20	3
685:	7	20	9
1101:	8
1183:	9	31	5
1334:	10	31	6

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
204	2	`TABLE ACCESS BY INDEX ROWID HIST_HEAD$`	255	624	0	0	0.000
204	1	`INDEX RANGE SCAN I_HH_OBJ#_INTCOL#`	257	420	0	0	0.000

hash:3150898423 length:121 depth:2(recursive) user:0(internal) line:144 rank:4 next prior top

select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.001	0	0	0	1
Execute:	29	0.016	0.011	0	0	0	1
Fetch:	29	0.016	0.089	7	87	478	0
Total:	59	0.032	0.101	7	87	478	2

Non-idle Wait Events

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	7	0.043	0.081
Total non-idle:	7	0.043	0.081

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	CPU Time (secs)	Elapsed Time (secs)	Non-idle Wait (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
165:	3	0.016	0.011	0.008	1	3	20	2	2
192:	2	0.000	0.001	0.000	0	3	20	0	9
218:	2	0.000	0.001	0.000	0	3	20	0	10
322:	2	0.016	0.001	0.000	0	3	20	0	8
524:	2	0.000	0.001	0.000	1	3	1	0	5
591:	2	0.000	0.001	0.000	1	3	20	0	6
1126:	2	0.000	0.007	0.006	1	3	1	0	4
1208:	2	0.000	0.044	0.043	1	3	20	0	1
1359:	2	0.000	0.001	0.000	1	3	20	0	7
1549:	2	0.000	0.024	0.024	1	3	9	0	3

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	3 Values (according to position within SQL)
165:	2	20	2	0
192:	9	20	2	1
218:	10	20	2	2
322:	8	20	2	6
524:	5	20	10	0
591:	6	20	8	0
1126:	4	57	7	0
1208:	1	31	5	0
1359:	7	31	6	0
1549:	3	31	13	0

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Elapsed Time (secs)
7674	3	`SORT ORDER BY`	0	1305	90	1.000
7674	2	`TABLE ACCESS CLUSTER HISTGRM$`	253	1305	90	1.000
435	1	`INDEX UNIQUE SCAN I_OBJ#_INTCOL#`	252	870	0	0.000

hash:2512561537 length:348 depth:1(recursive) user:0(internal) line:790 rank:15 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.001	0	0	1
Execute:	1	0.003	0	0	1
Fetch:	12	0.000	3	11	0
Total:	14	0.004	3	11	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
801:	1	12100

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)
11	3	`SORT ORDER BY`	0	3
11	2	`TABLE ACCESS CLUSTER COL$`	21	3
1	1	`INDEX UNIQUE SCAN I_OBJ#`	3	2

hash:2888850659 length:206 depth:1(recursive) user:0(internal) line:818 rank:9 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	7	0.001	0	0	1
Execute:	7	0.004	0	0	1
Fetch:	7	0.000	21	7	0
Total:	21	0.005	21	7	2

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
839:	3	0.004	3	1	2	1
881:	3	0.000	3	1	0	2
920:	3	0.000	3	1	0	3
959:	3	0.000	3	1	0	4
998:	3	0.000	3	1	0	5
1037:	3	0.000	3	1	0	6
1076:	3	0.000	3	1	0	7

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	3 Values (according to position within SQL)
839:	1	4	4	83
881:	2	4	4	147
920:	3	4	4	139
959:	4	4	4	131
998:	5	4	4	123
1037:	6	4	4	99
1076:	7	4	4	91

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
7	2	`TABLE ACCESS CLUSTER SEG$`	14	21	0	0	0.000
7	1	`INDEX UNIQUE SCAN I_FILE#_BLOCK#`	9	14	0	0	0.000

hash:854877822 length:116 depth:1(recursive) user:0(internal) line:844 rank:10 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.001	0	0	1
Execute:	7	0.002	0	0	1
Fetch:	7	0.000	21	7	0
Total:	15	0.003	21	7	2

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	Elapsed Time (secs)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
855:	3	0.002	3	1	2	1
896:	2	0.000	3	1	0	2
935:	2	0.000	3	1	0	3
974:	2	0.000	3	1	0	4
1013:	2	0.000	3	1	0	5
1052:	2	0.000	3	1	0	6
1891:	2	0.000	3	1	0	7

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
855:	1	12110
896:	2	12109
935:	3	12108
974:	4	12107
1013:	5	12102
1052:	6	12101
1891:	7

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
1	2	`TABLE ACCESS BY INDEX ROWID OBJ$`	18	3	0	0	0.000
1	1	`INDEX UNIQUE SCAN I_OBJ1`	36	2	0	0	0.000

hash:1173719687 length:169 depth:1(recursive) user:0(internal) line:1081 rank:12 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Cache Misses
Parse:	1	0.001	0	0	1
Execute:	1	0.010	1	6	1
Fetch:	1	0.011	1	2	0
Total:	3	0.022	2	8	2

Non-idle Wait Events

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	1	0.007	0.007
Total non-idle:	1	0.007	0.007

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
1139:	1	12100

Row Source Plan (Real Execution Path)

Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)
3	`SORT GROUP BY`	0	2	1
2	`TABLE ACCESS BY INDEX ROWID OBJAUTH$`	57	2	1
1	`INDEX RANGE SCAN I_OBJAUTH1`	103	2	1

hash:4139184264 length:151 depth:1(recursive) user:0(internal) line:1146 rank:16 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Query (blocks)	Cache Misses
Parse:	1	0.001	0	1
Execute:	1	0.002	0	1
Fetch:	1	0.000	2	0
Total:	3	0.003	2	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
1157:	1	12100

Row Source Plan (Real Execution Path)

Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)
3	`SORT GROUP BY`	0	2
2	`TABLE ACCESS BY INDEX ROWID OBJAUTH$`	57	2
1	`INDEX RANGE SCAN I_OBJAUTH1`	103	2

hash:1471956217 length:69 depth:1(recursive) user:0(internal) line:1163 rank:8 next prior top

select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.001	0	0	0	1
Execute:	1	0.031	0.054	2	36	0	1
Fetch:	4	0.000	0.000	0	7	3	0
Total:	6	0.031	0.055	2	43	3	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
1476:	1	12100

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
3	2	`TABLE ACCESS BY INDEX ROWID CDEF$`	31	7	0	0	0.000
3	1	`INDEX RANGE SCAN I_CDEF3`	52	4	0	0	0.000

hash:2107929772 length:146 depth:1(recursive) user:0(internal) line:1484 rank:7 next prior top

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 Summary

Call Type	Call Count	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.001	0	0	0	1
Execute:	1	0.032	1	23	0	1
Fetch:	11	0.000	0	22	10	0
Total:	13	0.033	1	45	10	2

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
1662:	1	12100

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
10	2	`TABLE ACCESS BY INDEX ROWID CDEF$`	31	22	0	0	0.000
10	1	`INDEX RANGE SCAN I_CDEF2`	51	12	0	0	0.000

hash:3849548163 length:70 depth:1(recursive) user:0(internal) line:1665 rank:6 next prior top

select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.000	0.001	0	0	0	1
Execute:	10	0.016	0.005	0	9	0	1
Fetch:	20	0.000	0.032	1	40	10	0
Total:	31	0.016	0.038	1	49	10	2

Non-idle Wait Events

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	1	0.031	0.031
Total non-idle:	1	0.031	0.031

Execution/Fetch Performance: First and Top 10 (according to CPU, Elapsed and Wait Times)

Exec Line	Call Count	CPU Time (secs)	Elapsed Time (secs)	Non-idle Wait (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses	Exec Ranking
1736:	4	0.000	0.036	0.031	1	13	1	2	1
1754:	3	0.000	0.000	0.000	0	4	1	0	3
1769:	3	0.000	0.000	0.000	0	4	1	0	4
1784:	3	0.016	0.000	0.000	0	4	1	0	2
1799:	3	0.000	0.000	0.000	0	4	1	0	5
1814:	3	0.000	0.000	0.000	0	4	1	0	6
1829:	3	0.000	0.000	0.000	0	4	1	0	7
1844:	3	0.000	0.000	0.000	0	4	1	0	8
1859:	3	0.000	0.000	0.000	0	4	1	0	9
1874:	3	0.000	0.000	0.000	0	4	1	0	10

Bind Variables Values: First and Top 10 Executions (according to CPU, Elapsed and Wait Times)

Exec Line	Exec Ranking	1 Values (according to position within SQL)
1736:	1	3088
1754:	3	3089
1769:	4	3090
1784:	2
1799:	5
1814:	6
1829:	7
1844:	8
1859:	9
1874:	10

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
1	2	`TABLE ACCESS BY INDEX ROWID CCOL$`	32	4	1	0	0.000
1	1	`INDEX RANGE SCAN I_CCOL1`	54	3	1	0	0.000

hash:282764354 length:30 depth:0(non-recursive) user:33(user) line:1894 rank:1 next top

select count(*) from employees

Call Summary

Call Type	Call Count	CPU Time (secs)	Elapsed Time (secs)	Disk (blocks)	Query (blocks)	Rows Returned	Cache Misses
Parse:	1	0.219	0.407	11	311	0	1
Execute:	1	0.000	0.000	0	0	0	0
Fetch:	2	0.000	0.008	1	1	1	0
Total:	4	0.219	0.415	12	312	1	1

Non-idle Wait Events

Non-idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
db file sequential read:	1	0.007	0.007
Total non-idle:	1	0.007	0.007

Idle Wait Events

Idle Wait Event	Times Waited	Max Wait (secs)	Total Time Waited (secs)
SQL*Net message from client:	2	0.001	0.001
SQL*Net message to client:	2	0.000	0.000
Total idle:	4	0.001	0.001

Row Source Plan (Real Execution Path)

Rows Returned	Exec Order	Row Source Operation	Object Id	Logical Reads (blocks)	Physical Reads (blocks)	Physical Writes (blocks)	Elapsed Time (secs)
1	2	`SORT AGGREGATE`	0	1	1	0	0.000
107	1	`INDEX FULL SCAN EMP_EMAIL_UK`	12101	1	1	0	0.000

Explain Plan (Generated by Trace Analyzer)

Id	Exec Order	Explain Plan Operation
0:	3	`SELECT STATEMENT`
1:	2	`SORT AGGREGATE`
2:	1	`INDEX FULL SCAN HR.EMP_EMAIL_UK`

Id	Object Type	Parent Id	Pos	Estim Card	Cost	CPU Cost	IO Cost
0:			1	1	1	28521	1
1:		0	1	1
2:	INDEX (UNIQUE)	1	1	107	1	28521	1

Tables Referenced by Explain Plan

Owner.Table Name	Current COUNT(*)	Num^* Rows	Sample^* Size	Last^* Analyzed	Avg^* Row Len	Chain^* Cnt	Blocks^*	Empty^* Blocks	Avg^* Space	Global^* Stats
HR.EMPLOYEES	107	107	107	20-JUN-06 21:55:35	71	0	5	3	6506	NO

(*) Columns marked with an asterisk are refreshed only when collecting CBO statistics

Owner.Table Name	Temporary	Partitioned	Logging	Degree	Cache	IOT Type	Ini Trans	Max Trans	Freelist Groups	Freelists
HR.EMPLOYEES	N	NO	YES	1	N		1	255

Indexes on Tables Referenced by Explain Plan

Table Owner.Table Name	Index Owner.Index Name	Index Type	Uniqueness	Indexed Columns
HR.EMPLOYEES	HR.EMP_DEPARTMENT_IX	NORMAL	NONUNIQUE	DEPARTMENT_ID
HR.EMPLOYEES	HR.EMP_EMAIL_UK	NORMAL	UNIQUE	EMAIL
HR.EMPLOYEES	HR.EMP_EMP_ID_PK	NORMAL	UNIQUE	EMPLOYEE_ID
HR.EMPLOYEES	HR.EMP_JOB_IX	NORMAL	NONUNIQUE	JOB_ID
HR.EMPLOYEES	HR.EMP_MANAGER_IX	NORMAL	NONUNIQUE	MANAGER_ID
HR.EMPLOYEES	HR.EMP_NAME_IX	NORMAL	NONUNIQUE	LAST_NAME FIRST_NAME

Table Owner.Table Name	Index Owner.Index Name	Num^* Rows	Sample^* Size	Last^* Analyzed	Distinct^* Keys	Leaf^* Blocks	Avg^* Leaf Blocks per Key	Avg^* Data Blocks per Key	Clustering^* Factor	Global^* Stats
HR.EMPLOYEES	HR.EMP_DEPARTMENT_IX	106	106	20-JUN-06 21:55:35	11	1	1	1	9	YES
HR.EMPLOYEES	HR.EMP_EMAIL_UK	107	107	20-JUN-06 21:55:35	107	1	1	1	19	YES
HR.EMPLOYEES	HR.EMP_EMP_ID_PK	107	107	20-JUN-06 21:55:35	107	1	1	1	2	YES
HR.EMPLOYEES	HR.EMP_JOB_IX	107	107	20-JUN-06 21:55:35	19	1	1	1	8	YES
HR.EMPLOYEES	HR.EMP_MANAGER_IX	106	106	20-JUN-06 21:55:35	18	1	1	1	8	YES
HR.EMPLOYEES	HR.EMP_NAME_IX	107	107	20-JUN-06 21:55:35	107	1	1	1	15	YES

(*) Columns marked with an asterisk are refreshed only when collecting CBO statistics

Table Owner.Table Name	Index Owner.Index Name	Temporary	Partitioned	Logging	Degree	Ini Trans	Max Trans	Status
HR.EMPLOYEES	HR.EMP_DEPARTMENT_IX	N	NO	YES	1	2	255	VALID
HR.EMPLOYEES	HR.EMP_EMAIL_UK	N	NO	YES	1	2	255	VALID
HR.EMPLOYEES	HR.EMP_EMP_ID_PK	N	NO	YES	1	2	255	VALID
HR.EMPLOYEES	HR.EMP_JOB_IX	N	NO	YES	1	2	255	VALID
HR.EMPLOYEES	HR.EMP_MANAGER_IX	N	NO	YES	1	2	255	VALID
HR.EMPLOYEES	HR.EMP_NAME_IX	N	NO	YES	1	2	255	VALID

hash:1972754632 length:36 depth:0(non-recursive) user:33(user) line:1913 rank:17 next prior top

 ALTER SESSION SET sql_trace = FALSE

Call Summary

Call Type	Call Count	Elapsed Time (secs)	Cache Misses
Parse:	1	0.001	1
Execute:	1	0.001	0
Fetch:	0	0.000	0
Total:	2	0.002	1

Idle Wait Events

Idle