orcl899_ora_2260.trc / Oracle Session Profiler

Session Summary

Instance Name: orcl899
Session ID: 125.46
Total SQL Statements: 2 (2 user statements, 0 internal statements)
Total Transactions: 0 (0 rollback(s), 0 read-only)

Report Shortcuts

Session Flat Profile
Top 5 Statements per Event
Session Call Graph
Events Histograms
Statements

Session Flat Profile

Event Name	% Time	Seconds	Calls	- Time per Call -
Event Name	% Time	Seconds	Calls	Avg	Min	Max
direct path read	46.7%	10.8508s	97	0.1119s	0.0000s	0.7369s
SQL*Net message from client [idle]	32.3%	7.4982s	1	7.4982s	7.4982s	7.4982s
SQL*Net message from client	16.8%	3.8953s	23	0.1694s	0.0004s	3.7929s
FETCH calls [CPU]	4.1%	0.9531s	23	0.0414s	0.0000s	0.9375s
PARSE calls [CPU]	0.0%	0.0156s	2	0.0078s	0.0000s	0.0156s
unaccounted-for time	0.0%	0.0062s
reliable message	0.0%	0.0001s	1	0.0001s	0.0001s	0.0001s
SQL*Net message to client	0.0%	0.0001s	24	0.0000s	0.0000s	0.0000s
enq: KO - fast object checkpoint	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
Total	100.0%	23.2196s

Top 5 Statements per Event

direct path read

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s
Total	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s

SQL*Net message from client [idle]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	7.4982s	1	7.4982s	7.4982s	7.4982s
Total	100.0%	7.4982s	1	7.4982s	7.4982s	7.4982s

SQL*Net message from client

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2217940283	97.4%	3.7929s	1	3.7929s	3.7929s	3.7929s
292258425	2.6%	0.1024s	22	0.0046s	0.0004s	0.0053s
Total	100.0%	3.8953s	23	0.1694s	0.0004s	3.7929s

FETCH calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	0.9531s	23	0.0414s	0.0000s	0.9375s
Total	100.0%	0.9531s	23	0.0414s	0.0000s	0.9375s

PARSE calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	0.0156s	1	0.0156s	0.0156s	0.0156s
2217940283	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0156s	2	0.0078s	0.0000s	0.0156s

reliable message

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	0.0001s	1	0.0001s	0.0001s	0.0001s
Total	100.0%	0.0001s	1	0.0001s	0.0001s	0.0001s

SQL*Net message to client

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	93.3%	0.0001s	23	0.0000s	0.0000s	0.0000s
2217940283	6.7%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0001s	24	0.0000s	0.0000s	0.0000s

enq: KO - fast object checkpoint

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s

EXEC calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
292258425	n/a %	0.0000s	1	0.0000s	0.0000s	0.0000s
2217940283	n/a %	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	2	0.0000s	0.0000s	0.0000s

Session Call Graph

SQL Hash Value	Branch %	Total %	Self Seconds	Cumulative Seconds	Calls	Similar	Command Type
292258425	100.0%	100.0%	11.8211s	11.8211s	25	0	SELECT
2217940283	100.0%	0.0%	0.0003s	0.0003s	2	0	ALTER SESSION

Events Histograms

direct path read

value	- Distribution -	count
0.000002s		0
0.000004s		10
0.000008s		0
0.000016s		7
0.000032s		0
0.000064s		0
0.000128s		0
0.000256s		0
0.000512s		0
0.001024s		0
0.002048s		1
0.004096s		7
0.008192s		13
0.016384s		7
0.032768s		8
0.065536s		14
0.131072s		14
0.262144s		14
0.524288s		2
1.048576s		0

SQL*Net message from client [idle]

value	- Distribution -	count
2.097152s		0
4.194304s		1
8.388608s		0

SQL*Net message from client

value	- Distribution -	count
0.000128s		0
0.000256s		1
0.000512s		0
0.001024s		0
0.002048s		0
0.004096s		21
0.008192s		0
0.016384s		0
0.032768s		0
0.065536s		0
0.131072s		0
0.262144s		0
0.524288s		0
1.048576s		0
2.097152s		1
4.194304s		0

FETCH calls [CPU]

value	- Distribution -	count
0.000000s		21
0.000001s		0
0.000002s		0
0.000004s		0
0.000008s		0
0.000016s		0
0.000032s		0
0.000064s		0
0.000128s		0
0.000256s		0
0.000512s		0
0.001024s		0
0.002048s		0
0.004096s		0
0.008192s		1
0.016384s		0
0.032768s		0
0.065536s		0
0.131072s		0
0.262144s		0
0.524288s		1
1.048576s		0

PARSE calls [CPU]

value	- Distribution -	count
0.000000s		1
0.000001s		0
0.000002s		0
0.000004s		0
0.000008s		0
0.000016s		0
0.000032s		0
0.000064s		0
0.000128s		0
0.000256s		0
0.000512s		0
0.001024s		0
0.002048s		0
0.004096s		0
0.008192s		1
0.016384s		0

reliable message

value	- Distribution -	count
0.000064s		0
0.000128s		1
0.000256s		0

SQL*Net message to client

value	- Distribution -	count
0.000002s		0
0.000004s		22
0.000008s		2
0.000016s		0

enq: KO - fast object checkpoint

value	- Distribution -	count
0.000016s		0
0.000032s		1
0.000064s		0

EXEC calls [CPU]

value	- Distribution -	count
0.000000s		2

Session Read Statistics

Blocks Read per Call	% Time	Seconds	Calls	- Time per Call -
Blocks Read per Call	% Time	Seconds	Calls	Avg	Min	Max
64	97.5%	10.5751s	91	0.1162s	0.0000s	0.7369s
55	1.0%	0.1128s	2	0.0564s	0.0086s	0.1042s
49	1.0%	0.1051s	1	0.1051s	0.1051s	0.1051s
14	0.5%	0.0577s	1	0.0577s	0.0577s	0.0577s
19	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
9	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s

Session Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s
Total	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s

Session Enqueue Statistics

Enqueue Type Mode	% Time	Seconds	Calls	- Time per Call -
Enqueue Type Mode	% Time	Seconds	Calls	Avg	Min	Max
KO,6	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s

SQL Statements

SQL Hash Value: 292258425 SQL Id: bfn7d448qr0mt uid: 5 depth: 0 optimizer mode: ALL_ROWS

Statement Text

SELECT o.owner, o.object_type, COUNT(*)
FROM all_my_objects o
GROUP BY CUBE (o.object_type, o.owner)

Statement Cumulative Statistics

Call	Cache Misses	Count	- Seconds -		Physical Reads	- Logical Reads -		Rows
Call	Cache Misses	Count	CPU	Elapsed	Physical Reads	Consistent	Current	Rows
Parse	1	1	0.0156s	0.0020s	0	0	0	0
Exec	0	1	0.0000s	0.0001s	0	0	0	0
Fetch		23	0.9531s	11.8188s	6,025	6,029	0	327
Total	1	25	0.9688s	11.8211s	6,025	6,029	0	327

Per Fch	0.0	1.1	0.0421s	0.5140s	262.0	262.1	0.0	14.2
Per Row	0.0	0.0	0.0029s	0.0361s	18.4	18.4	0.0	1.0

Statement Flat Profile

Event Name	% Time	Seconds	Calls	- Time per Call -
Event Name	% Time	Seconds	Calls	Avg	Min	Max
direct path read	55.9%	10.8508s	97	0.1119s	0.0000s	0.7369s
SQL*Net message from client [idle]	38.6%	7.4982s	1	7.4982s	7.4982s	7.4982s
FETCH calls [CPU]	4.9%	0.9531s	23	0.0414s	0.0000s	0.9375s
SQL*Net message from client	0.5%	0.1024s	22	0.0046s	0.0004s	0.0053s
PARSE calls [CPU]	0.0%	0.0156s	1	0.0156s	0.0156s	0.0156s
reliable message	0.0%	0.0001s	1	0.0001s	0.0001s	0.0001s
SQL*Net message to client	0.0%	0.0001s	23	0.0000s	0.0000s	0.0000s
enq: KO - fast object checkpoint	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	19.4205s

Statement Read Statistics

Blocks Read per Call	% Time	Seconds	Calls	- Time per Call -
Blocks Read per Call	% Time	Seconds	Calls	Avg	Min	Max
64	97.5%	10.5751s	91	0.1162s	0.0000s	0.7369s
55	1.0%	0.1128s	2	0.0564s	0.0086s	0.1042s
49	1.0%	0.1051s	1	0.1051s	0.1051s	0.1051s
14	0.5%	0.0577s	1	0.0577s	0.0577s	0.0577s
19	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
9	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s

Statement Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s
Total	100.0%	10.8508s	97	0.1119s	0.0000s	0.7369s

Statement Enqueue Statistics

Enqueue Type Mode	% Time	Seconds	Calls	- Time per Call -
Enqueue Type Mode	% Time	Seconds	Calls	Avg	Min	Max
KO,6	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s

Statement Plan

met 1 time

Rows	Row Source Operation	Object Id
327 1,032 258 411,120	SORT GROUP BY (cr=6,029 pr=6,025 pw=6,025 time=0.0000s cost=1,657 size=12,105 card=807) GENERATE CUBE (cr=6,029 pr=6,025 pw=6,025 time=0.0000s cost=1,657 size=12,105 card=807) SORT GROUP BY (cr=6,029 pr=6,025 pw=6,025 time=0.0000s cost=1,657 size=12,105 card=807) TABLE ACCESS FULL ALL_MY_OBJECTS (cr=6,029 pr=6,025 pw=6,025 time=0.2145s cost=1,641 size=6,166,800 card=411,120)	71632

SQL Hash Value: 2217940283 SQL Id: 06nvwn223659v uid: 5 depth: 0 optimizer mode:

Statement Text

alter session set events '10046 trace name context off'

Statement Cumulative Statistics

Call	Cache Misses	Count	- Seconds -		Physical Reads	- Logical Reads -		Rows
Call	Cache Misses	Count	CPU	Elapsed	Physical Reads	Consistent	Current	Rows
Parse	0	1	0.0000s	0.0000s	0	0	0	0
Exec	0	1	0.0000s	0.0003s	0	0	0	0
Fetch		0	0.0000s	0.0000s	0	0	0	0
Total	0	2	0.0000s	0.0003s	0	0	0	0

Per Exe	0.0	2.0	0.0000s	0.0003s	0.0	0.0	0.0	0.0
Per Row	0.0	2.0	0.0000s	0.0003s	0.0	0.0	0.0	0.0

Statement Flat Profile

Event Name	% Time	Seconds	Calls	- Time per Call -
Event Name	% Time	Seconds	Calls	Avg	Min	Max
SQL*Net message from client	100.0%	3.7929s	1	3.7929s	3.7929s	3.7929s
SQL*Net message to client	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
PARSE calls [CPU]	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	3.7929s

Generated by OraSRP v3.1.3 beta