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 -
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
Total100.0%23.2196s 
Top 5 Statements per Event
direct path read
SQL Hash Value % Time Seconds Calls - Time per Call -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
292258425100.0%100.0%11.8211s11.8211s250SELECT
2217940283100.0%0.0%0.0003s0.0003s20ALTER 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 -
Avg Min Max
6497.5%10.5751s910.1162s0.0000s0.7369s
551.0%0.1128s20.0564s0.0086s0.1042s
491.0%0.1051s10.1051s0.1051s0.1051s
140.5%0.0577s10.0577s0.0577s0.0577s
190.0%0.0000s10.0000s0.0000s0.0000s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 10.8508s 97 0.1119s 0.0000s 0.7369s
Session Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%10.8508s970.1119s0.0000s0.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 -
Avg Min Max
KO,6100.0%0.0000s10.0000s0.0000s0.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
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
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 -
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
Total100.0%19.4205s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6497.5%10.5751s910.1162s0.0000s0.7369s
551.0%0.1128s20.0564s0.0086s0.1042s
491.0%0.1051s10.1051s0.1051s0.1051s
140.5%0.0577s10.0577s0.0577s0.0577s
190.0%0.0000s10.0000s0.0000s0.0000s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 10.8508s 97 0.1119s 0.0000s 0.7369s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%10.8508s970.1119s0.0000s0.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 -
Avg Min Max
KO,6100.0%0.0000s10.0000s0.0000s0.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
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% 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
Total100.0%3.7929s