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)
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 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 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 |
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 |
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 |
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 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 |
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 |
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 |
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
|
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 |
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 - |
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 - |
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 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
|
---|
CPU | Elapsed | Consistent | Current
|
---|
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
Statement Read Statistics
Blocks Read per Call | % Time | Seconds | Calls | - Time per Call - |
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 - |
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 - |
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
|
---|
CPU | Elapsed | Consistent | Current
|
---|
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
Generated by OraSRP v3.1.3 beta