orcl899_ora_788.trc / Oracle Session Profiler

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 -
Event Name	% Time	Seconds	Calls	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
Total	100.0%	46.2651s

Top 5 Statements per Event

SQL*Net message from client [idle]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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 -
SQL Hash Value	% Time	Seconds	Calls	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
2217940283	100.0%	0.0%	0.0003s	0.0003s	2	0	ALTER 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 -
Blocks Read per Call	% Time	Seconds	Calls	Avg	Min	Max
64	97.3%	14.7068s	91	0.1616s	0.0000s	1.2024s
55	1.4%	0.2060s	2	0.1030s	0.0770s	0.1289s
49	1.0%	0.1508s	1	0.1508s	0.1508s	0.1508s
14	0.3%	0.0446s	1	0.0446s	0.0446s	0.0446s
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%	15.1083s	97	0.1558s	0.0000s	1.2024s

Session Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	15.1083s	97	0.1558s	0.0000s	1.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

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.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

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.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 -
Event Name	% Time	Seconds	Calls	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
Total	100.0%	28.6953s

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.3%	14.7068s	91	0.1616s	0.0000s	1.2024s
55	1.4%	0.2060s	2	0.1030s	0.0770s	0.1289s
49	1.0%	0.1508s	1	0.1508s	0.1508s	0.1508s
14	0.3%	0.0446s	1	0.0446s	0.0446s	0.0446s
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%	15.1083s	97	0.1558s	0.0000s	1.2024s

Statement Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	15.1083s	97	0.1558s	0.0000s	1.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

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.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 -
Event Name	% Time	Seconds	Calls	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
Total	100.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

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.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

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.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 -
Event Name	% Time	Seconds	Calls	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
Total	100.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

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
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
Total	100.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 -
Event Name	% Time	Seconds	Calls	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
Total	100.0%	14.6251s

Generated by OraSRP v3.1.3 beta