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 -
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
Total100.0%51.3722s 
Top 5 Statements per Event
direct path read
SQL Hash Value % Time Seconds Calls - Time per Call -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
3614152629100.0%100.0%24.2476s24.2476s390SELECT
2217940283100.0%0.0%0.0003s0.0003s20ALTER 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 -
Avg Min Max
6497.7%22.3243s1820.1227s0.0000s0.7989s
551.1%0.2475s40.0618s0.0087s0.1290s
490.9%0.2099s20.1049s0.1037s0.1062s
140.3%0.0777s20.0388s0.0108s0.0669s
190.0%0.0000s20.0000s0.0000s0.0000s
90.0%0.0000s20.0000s0.0000s0.0000s
Total 100.0% 22.8594s 194 0.1178s 0.0000s 0.7989s
Session Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%22.8594s1940.1178s0.0000s0.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 -
Avg Min Max
KO,6100.0%0.0002s20.0001s0.0001s0.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
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
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 -
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
Total100.0%30.7726s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6497.7%22.3243s1820.1227s0.0000s0.7989s
551.1%0.2475s40.0618s0.0087s0.1290s
490.9%0.2099s20.1049s0.1037s0.1062s
140.3%0.0777s20.0388s0.0108s0.0669s
190.0%0.0000s20.0000s0.0000s0.0000s
90.0%0.0000s20.0000s0.0000s0.0000s
Total 100.0% 22.8594s 194 0.1178s 0.0000s 0.7989s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%22.8594s1940.1178s0.0000s0.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 -
Avg Min Max
KO,6100.0%0.0002s20.0001s0.0001s0.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
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
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 -
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
Total100.0%20.2977s