Session Summary
Instance Name: orcl899
Session ID: 121.142
Total SQL Statements: 4 (4 user statements, 0 internal statements)
Total Transactions: 1 (0 rollback(s), 1 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
SQL*Net message from client [idle] 58.3% 26.9872s 2 13.4936s 12.3623s 14.6249s
direct path read 32.7% 15.1083s 97 0.1558s 0.0000s 1.2024s
SQL*Net message from client 6.0% 2.7851s 37 0.0752s 0.0003s 2.6858s
FETCH calls [CPU] 2.4% 1.1250s 37 0.0304s 0.0000s 0.5469s
unaccounted-for time 0.6% 0.2589s        
reliable message 0.0% 0.0002s 1 0.0002s 0.0002s 0.0002s
SQL*Net break/reset to client 0.0% 0.0002s 2 0.0001s 0.0000s 0.0001s
SQL*Net message to client 0.0% 0.0001s 39 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] 0.0% 0.0000s 4 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] 0.0% 0.0000s 4 0.0000s 0.0000s 0.0000s
Total100.0%46.2651s 
Top 5 Statements per Event
SQL*Net message from client [idle]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
pe/000000 54.2% 14.6249s 1 14.6249s 14.6249s 14.6249s
4231189193 45.8% 12.3623s 1 12.3623s 12.3623s 12.3623s
Total 100.0% 26.9872s 2 13.4936s 12.3623s 14.6249s
direct path read
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4231189193 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
Total 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
SQL*Net message from client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
337957580 96.4% 2.6858s 1 2.6858s 2.6858s 2.6858s
4231189193 3.6% 0.0992s 36 0.0027s 0.0003s 0.0053s
Total 100.0% 2.7851s 37 0.0752s 0.0003s 2.6858s
FETCH calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4231189193 100.0% 1.1250s 37 0.0304s 0.0000s 0.5469s
Total 100.0% 1.1250s 37 0.0304s 0.0000s 0.5469s
reliable message
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4231189193 100.0% 0.0002s 1 0.0002s 0.0002s 0.0002s
Total 100.0% 0.0002s 1 0.0002s 0.0002s 0.0002s
SQL*Net break/reset to client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
pe/000000 100.0% 0.0002s 2 0.0001s 0.0000s 0.0001s
Total 100.0% 0.0002s 2 0.0001s 0.0000s 0.0001s
SQL*Net message to client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4231189193 93.1% 0.0001s 37 0.0000s 0.0000s 0.0000s
337957580 3.8% 0.0000s 1 0.0000s 0.0000s 0.0000s
pe/000000 3.1% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0001s 39 0.0000s 0.0000s 0.0000s
EXEC calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
337957580 n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
1949913731 n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
4231189193 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 4 0.0000s 0.0000s 0.0000s
PARSE calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
337957580 n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
1949913731 n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
4231189193 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 4 0.0000s 0.0000s 0.0000s
Session Call Graph
SQL Hash Value Branch % Total % Self
Seconds
Cumulative
Seconds
Calls Similar Command Type
4231189193
337957580
1949913731
100.0%
0.0%
0.0%
100.0%
0.0%
0.0%
16.4764s
0.0007s
0.0015s
16.4787s
0.0022s
0.0015s
39
2
2
0
0
0
SELECT
PL/SQL EXECUTE
DELETE
2217940283100.0%0.0%0.0003s0.0003s20ALTER SESSION
Events Histograms
SQL*Net message from client [idle]
value - Distribution - count
4.194304s   0
8.388608s   2
16.777216s   0
direct path read
value - Distribution - count
0.000002s   0
0.000004s   22
0.000008s   5
0.000016s   5
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   14
0.016384s   3
0.032768s   4
0.065536s   11
0.131072s   8
0.262144s   16
0.524288s   8
1.048576s   1
2.097152s   0
SQL*Net message from client
value - Distribution - count
0.000128s   0
0.000256s   1
0.000512s   0
0.001024s   13
0.002048s   14
0.004096s   8
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   23
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   8
0.016384s   1
0.032768s   1
0.065536s   2
0.131072s   1
0.262144s   0
0.524288s   1
1.048576s   0
reliable message
value - Distribution - count
0.000064s   0
0.000128s   1
0.000256s   0
SQL*Net break/reset to client
value - Distribution - count
0.000004s   0
0.000008s   1
0.000016s   0
0.000032s   0
0.000064s   0
0.000128s   1
0.000256s   0
SQL*Net message to client
value - Distribution - count
0.000001s   0
0.000002s   21
0.000004s   17
0.000008s   1
0.000016s   0
EXEC calls [CPU]
value - Distribution - count
0.000000s   4
PARSE calls [CPU]
value - Distribution - count
0.000000s   4
Session Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6497.3%14.7068s910.1616s0.0000s1.2024s
551.4%0.2060s20.1030s0.0770s0.1289s
491.0%0.1508s10.1508s0.1508s0.1508s
140.3%0.0446s10.0446s0.0446s0.0446s
190.0%0.0000s10.0000s0.0000s0.0000s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
Session Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%15.1083s970.1558s0.0000s1.2024s
Total 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
SQL Statements
SQL Hash Value: 4231189193     SQL Id: 6k87967y35nq9     uid: 5    depth: 0    optimizer mode: ALL_ROWS
Statement Text
select object_name, object_type
  
from ( 
select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time
           from all_my_objects o
       )
 where last_ddl_time = last_modified_time

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0025s 0 0 0 0
Exec 0 1 0.0000s 0.0001s 0 0 0 0
Fetch   37 1.1250s 16.4761s 6,025 6,029 0 528
Total 1 39 1.1250s 16.4787s 6,025 6,029 0 528
Per Fch 0.0 1.1 0.0304s 0.4454s 162.8 162.9 0.0 14.3
Per Row 0.0 0.0 0.0021s 0.0312s 11.4 11.4 0.0 1.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0002s 0 0 0 0
Exec 0 1 0.0000s 0.0001s 0 0 0 0
Fetch   37 1.1250s 16.4761s 6,025 6,029 0 528
Total 1 39 1.1250s 16.4764s 6,025 6,029 0 528
Per Fch 0.0 1.1 0.0304s 0.4453s 162.8 162.9 0.0 14.3
Per Row 0.0 0.0 0.0021s 0.0312s 11.4 11.4 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
direct path read 52.7% 15.1083s 97 0.1558s 0.0000s 1.2024s
SQL*Net message from client [idle] 43.1% 12.3623s 1 12.3623s 12.3623s 12.3623s
FETCH calls [CPU] 3.9% 1.1250s 37 0.0304s 0.0000s 0.5469s
SQL*Net message from client 0.3% 0.0992s 36 0.0027s 0.0003s 0.0053s
reliable message 0.0% 0.0002s 1 0.0002s 0.0002s 0.0002s
SQL*Net message to client 0.0% 0.0001s 37 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] 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
Total100.0%28.6953s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6497.3%14.7068s910.1616s0.0000s1.2024s
551.4%0.2060s20.1030s0.0770s0.1289s
491.0%0.1508s10.1508s0.1508s0.1508s
140.3%0.0446s10.0446s0.0446s0.0446s
190.0%0.0000s10.0000s0.0000s0.0000s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%15.1083s970.1558s0.0000s1.2024s
Total 100.0% 15.1083s 97 0.1558s 0.0000s 1.2024s
Statement Plan
met 1 time
Rows Row Source Operation Object Id
528
411,120
411,120
VIEW (cr=6,029 pr=6,025 pw=6,025 time=0.0004s cost=6,555 size=18,911,520 card=411,120)
WINDOW SORT (cr=6,029 pr=6,025 pw=6,025 time=0.0807s cost=6,555 size=19,733,760 card=411,120)
TABLE ACCESS FULL ALL_MY_OBJECTS (cr=6,029 pr=6,025 pw=6,025 time=1.3080s cost=1,644 size=19,733,760 card=411,120)
 
 
71632


SQL Hash Value: 1949913731     SQL Id: 3972rvxu3knn3     uid: 52    depth: 2    optimizer mode: ALL_ROWS
Statement Text
delete from sdo_geor_ddl__table$$

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0014s 0 0 0 0
Exec 0 1 0.0000s 0.0001s 0 0 0 0
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1 2 0.0000s 0.0015s 0 0 0 0
Per Exe 1.0 2.0 0.0000s 0.0015s 0.0 0.0 0.0 0.0
Per Row 1.0 2.0 0.0000s 0.0015s 0.0 0.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
PARSE calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
0
0
DELETE SDO_GEOR_DDL__TABLE$$ (cr=0 pr=0 pw=0 time=0.0000s)
TABLE ACCESS FULL SDO_GEOR_DDL__TABLE$$ (cr=0 pr=0 pw=0 time=0.0000s cost=2 size=0 card=1)
 
62986


SQL Hash Value: 337957580     SQL Id: a6u3yjca29nqc     uid: 52    depth: 1    optimizer mode: ALL_ROWS
Statement Text
declare
  m_stmt  varchar2(512);
begin
   m_stmt:='delete from sdo_geor_ddl__table$$';
   EXECUTE IMMEDIATE m_stmt;
   EXCEPTION
     WHEN OTHERS THEN
       NULL;
end;

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 0 1 0.0000s 0.0001s 0 0 0 0
Exec 0 1 0.0000s 0.0021s 0 0 0 1
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 0 2 0.0000s 0.0022s 0 0 0 1
Per Exe 0.0 2.0 0.0000s 0.0022s 0.0 0.0 0.0 1.0
Per Row 0.0 2.0 0.0000s 0.0022s 0.0 0.0 0.0 1.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 0 1 0.0000s 0.0001s 0 0 0 0
Exec 0 1 0.0000s 0.0005s 0 0 0 1
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 0 2 0.0000s 0.0007s 0 0 0 1
Per Exe 0.0 2.0 0.0000s 0.0007s 0.0 0.0 0.0 1.0
Per Row 0.0 2.0 0.0000s 0.0007s 0.0 0.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
SQL*Net message from client 100.0% 2.6858s 1 2.6858s 2.6858s 2.6858s
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%2.6858s 


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
PARSE calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 


Erroneous SQL PseudoHash Value: pe/000000    uid: 5    depth: 0
Erroneous Statement Text
select object_name, object_type
  
from ( 
select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time
           from all_my_objects o
       )
 where last_ddl_time = last_modified_time;select object_name, object_type
  
from ( 
select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time
           from all_my_objects o
       )
 where last_ddl_time = last_modified_time;select object_name, object_type
  
from ( 
select o.*, max(last_ddl_time) over ( partition by owner ) last_modified_time
           from all_my_objects o
       )
 where last_ddl_time = last_modified_time

This statement failed to parse with error: ORA-911
Statement Cumulative Statistics
  No cumulative stat found in trace file

Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
SQL*Net message from client [idle] 100.0% 14.6249s 1 14.6249s 14.6249s 14.6249s
SQL*Net break/reset to client 0.0% 0.0002s 2 0.0001s 0.0000s 0.0001s
SQL*Net message to client 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%14.6251s