orcl899_ora_1700.trc / Oracle Session Profiler

Session Summary

Instance Name: orcl899
Session ID: 125.51
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	44.5%	22.8594s	194	0.1178s	0.0000s	0.7989s
SQL*Net message from client	39.8%	20.4624s	37	0.5530s	0.0004s	20.2977s
SQL*Net message from client [idle]	13.0%	6.6539s	1	6.6539s	6.6539s	6.6539s
FETCH calls [CPU]	2.1%	1.0781s	37	0.0291s	0.0000s	0.6406s
unaccounted-for time	0.6%	0.3019s
PARSE calls [CPU]	0.0%	0.0156s	2	0.0078s	0.0000s	0.0156s
reliable message	0.0%	0.0004s	2	0.0002s	0.0001s	0.0002s
enq: KO - fast object checkpoint	0.0%	0.0002s	2	0.0001s	0.0001s	0.0001s
SQL*Net message to client	0.0%	0.0002s	38	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
Total	100.0%	51.3722s

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
3614152629	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s
Total	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s

SQL*Net message from client

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2217940283	99.2%	20.2977s	1	20.2977s	20.2977s	20.2977s
3614152629	0.8%	0.1647s	36	0.0045s	0.0004s	0.0055s
Total	100.0%	20.4624s	37	0.5530s	0.0004s	20.2977s

SQL*Net message from client [idle]

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

FETCH calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
3614152629	100.0%	1.0781s	37	0.0291s	0.0000s	0.6406s
Total	100.0%	1.0781s	37	0.0291s	0.0000s	0.6406s

PARSE calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
3614152629	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
3614152629	100.0%	0.0004s	2	0.0002s	0.0001s	0.0002s
Total	100.0%	0.0004s	2	0.0002s	0.0001s	0.0002s

enq: KO - fast object checkpoint

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
3614152629	100.0%	0.0002s	2	0.0001s	0.0001s	0.0001s
Total	100.0%	0.0002s	2	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
3614152629	96.3%	0.0002s	37	0.0000s	0.0000s	0.0000s
2217940283	3.7%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0002s	38	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
3614152629	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
3614152629	100.0%	100.0%	24.2476s	24.2476s	39	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		23
0.000008s		0
0.000016s		12
0.000032s		0
0.000064s		0
0.000128s		1
0.000256s		0
0.000512s		1
0.001024s		1
0.002048s		0
0.004096s		4
0.008192s		33
0.016384s		17
0.032768s		15
0.065536s		18
0.131072s		33
0.262144s		34
0.524288s		2
1.048576s		0

SQL*Net message from client

value	- Distribution -	count
0.000128s		0
0.000256s		1
0.000512s		0
0.001024s		0
0.002048s		4
0.004096s		31
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		0
4.194304s		0
8.388608s		0
16.777216s		1
33.554432s		0

SQL*Net message from client [idle]

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

FETCH calls [CPU]

value	- Distribution -	count
0.000000s		24
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		6
0.016384s		2
0.032768s		3
0.065536s		1
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		1
0.000512s		0

enq: KO - fast object checkpoint

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

SQL*Net message to client

value	- Distribution -	count
0.000002s		0
0.000004s		35
0.000008s		3
0.000016s		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.7%	22.3243s	182	0.1227s	0.0000s	0.7989s
55	1.1%	0.2475s	4	0.0618s	0.0087s	0.1290s
49	0.9%	0.2099s	2	0.1049s	0.1037s	0.1062s
14	0.3%	0.0777s	2	0.0388s	0.0108s	0.0669s
19	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
9	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
Total	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s

Session Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s
Total	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s

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.0002s	2	0.0001s	0.0001s	0.0001s
Total	100.0%	0.0002s	2	0.0001s	0.0001s	0.0001s

SQL Statements

SQL Hash Value: 3614152629 SQL Id: 933vtp3bqr5xp uid: 5 depth: 0 optimizer mode: ALL_ROWS

Statement Text

select object_name, object_type
  from all_my_objects o
 
where last_ddl_time = ( 
select max(last_ddl_time) 
from all_my_objects o2 
where o2.owner = 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.0218s	0	0	0	0
Exec	0	1	0.0000s	0.0001s	0	0	0	0
Fetch		37	1.0781s	24.2255s	12,050	12,094	0	528
Total	1	39	1.0938s	24.2476s	12,050	12,094	0	528

Per Fch	0.0	1.1	0.0295s	0.6553s	325.7	326.9	0.0	14.3
Per Row	0.0	0.0	0.0020s	0.0459s	22.8	22.9	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	74.3%	22.8594s	194	0.1178s	0.0000s	0.7989s
SQL*Net message from client [idle]	21.6%	6.6539s	1	6.6539s	6.6539s	6.6539s
FETCH calls [CPU]	3.5%	1.0781s	37	0.0291s	0.0000s	0.6406s
SQL*Net message from client	0.5%	0.1647s	36	0.0045s	0.0004s	0.0055s
PARSE calls [CPU]	0.0%	0.0156s	1	0.0156s	0.0156s	0.0156s
reliable message	0.0%	0.0004s	2	0.0002s	0.0001s	0.0002s
enq: KO - fast object checkpoint	0.0%	0.0002s	2	0.0001s	0.0001s	0.0001s
SQL*Net message to client	0.0%	0.0002s	37	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	30.7726s

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.7%	22.3243s	182	0.1227s	0.0000s	0.7989s
55	1.1%	0.2475s	4	0.0618s	0.0087s	0.1290s
49	0.9%	0.2099s	2	0.1049s	0.1037s	0.1062s
14	0.3%	0.0777s	2	0.0388s	0.0108s	0.0669s
19	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
9	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
Total	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s

Statement Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s
Total	100.0%	22.8594s	194	0.1178s	0.0000s	0.7989s

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.0002s	2	0.0001s	0.0001s	0.0001s
Total	100.0%	0.0002s	2	0.0001s	0.0001s	0.0001s

Statement Plan

met 1 time

Rows	Row Source Operation	Object Id
528 30 30 411,120 411,120	HASH JOIN (cr=12,094 pr=12,050 pw=12,050 time=0.0000s cost=3,302 size=164,354 card=2,221) VIEW VW_SQ_1 (cr=6,029 pr=6,025 pw=6,025 time=0.0001s cost=1,658 size=780 card=30) HASH GROUP BY (cr=6,029 pr=6,025 pw=6,025 time=0.0001s cost=1,658 size=600 card=30) TABLE ACCESS FULL ALL_MY_OBJECTS (cr=6,029 pr=6,025 pw=6,025 time=0.5404s cost=1,641 size=8,222,400 card=411,120) TABLE ACCESS FULL ALL_MY_OBJECTS (cr=6,065 pr=6,025 pw=6,025 time=0.3820s cost=1,641 size=19,733,760 card=411,120)	71632 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%	20.2977s	1	20.2977s	20.2977s	20.2977s
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%	20.2977s

Generated by OraSRP v3.1.3 beta