orcl899_ora_2552.trc / Oracle Session Profiler

Session Summary

Instance Name: orcl899
Session ID: 125.80
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 -
Event Name	% Time	Seconds	Calls	Avg	Min	Max
SQL*Net message from client [idle]	51.2%	5.5000s	1	5.5000s	5.5000s	5.5000s
SQL*Net message from client	43.6%	4.6811s	2	2.3405s	0.0003s	4.6807s
direct path read	3.3%	0.3513s	26	0.0135s	0.0000s	0.0971s
FETCH calls [CPU]	1.0%	0.1094s	2	0.0546s	0.0000s	0.1094s
unaccounted-for time	0.9%	0.0991s
reliable message	0.0%	0.0002s	1	0.0002s	0.0002s	0.0002s
enq: KO - fast object checkpoint	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
SQL*Net message to client	0.0%	0.0000s	3	0.0000s	0.0000s	0.0000s
EXEC calls [CPU]	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
PARSE calls [CPU]	0.0%	0.0000s	2	0.0000s	0.0000s	0.0000s
Total	100.0%	10.7411s

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
2266843291	100.0%	5.5000s	1	5.5000s	5.5000s	5.5000s
Total	100.0%	5.5000s	1	5.5000s	5.5000s	5.5000s

SQL*Net message from client

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2217940283	100.0%	4.6807s	1	4.6807s	4.6807s	4.6807s
2266843291	0.0%	0.0003s	1	0.0003s	0.0003s	0.0003s
Total	100.0%	4.6811s	2	2.3405s	0.0003s	4.6807s

direct path read

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s
Total	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s

FETCH calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	100.0%	0.1094s	2	0.0546s	0.0000s	0.1094s
Total	100.0%	0.1094s	2	0.0546s	0.0000s	0.1094s

reliable message

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	100.0%	0.0002s	1	0.0002s	0.0002s	0.0002s
Total	100.0%	0.0002s	1	0.0002s	0.0002s	0.0002s

enq: KO - fast object checkpoint

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	1	0.0000s	0.0000s	0.0000s

SQL*Net message to client

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	72.7%	0.0000s	2	0.0000s	0.0000s	0.0000s
2217940283	27.3%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.0000s	3	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
2266843291	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

PARSE calls [CPU]

SQL Hash Value	% Time	Seconds	Calls	- Time per Call -
SQL Hash Value	% Time	Seconds	Calls	Avg	Min	Max
2266843291	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
2266843291	100.0%	99.9%	0.5582s	0.5582s	4	0	SELECT
2217940283	100.0%	0.0%	0.0003s	0.0003s	2	0	ALTER SESSION

Events Histograms

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		0
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		1
8.388608s		0

direct path read

value	- Distribution -	count
0.000002s		0
0.000004s		1
0.000008s		0
0.000016s		3
0.000032s		0
0.000064s		0
0.000128s		0
0.000256s		0
0.000512s		0
0.001024s		1
0.002048s		2
0.004096s		1
0.008192s		15
0.016384s		1
0.032768s		1
0.065536s		1
0.131072s		0

FETCH 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		0
0.016384s		0
0.032768s		0
0.065536s		1
0.131072s		0

reliable message

value	- Distribution -	count
0.000064s		0
0.000128s		1
0.000256s		0

enq: KO - fast object checkpoint

value	- Distribution -	count
0.000032s		0
0.000064s		1
0.000128s		0

SQL*Net message to client

value	- Distribution -	count
0.000002s		0
0.000004s		2
0.000008s		1
0.000016s		0

EXEC calls [CPU]

value	- Distribution -	count
0.000000s		2

PARSE calls [CPU]

value	- Distribution -	count
0.000000s		2

Session Read Statistics

Blocks Read per Call	% Time	Seconds	Calls	- Time per Call -
Blocks Read per Call	% Time	Seconds	Calls	Avg	Min	Max
64	55.6%	0.1953s	22	0.0088s	0.0000s	0.0190s
62	27.7%	0.0971s	1	0.0971s	0.0971s	0.0971s
56	12.2%	0.0427s	1	0.0427s	0.0427s	0.0427s
55	4.6%	0.0160s	1	0.0160s	0.0160s	0.0160s
9	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s

Session Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s
Total	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s

Session Enqueue Statistics

Enqueue Type Mode	% Time	Seconds	Calls	- Time per Call -
Enqueue Type Mode	% Time	Seconds	Calls	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 Statements

SQL Hash Value: 2266843291 SQL Id: 0jsn2363juk4v uid: 5 depth: 0 optimizer mode: ALL_ROWS

Statement Text

SELECT distinct owner, table_name
FROM all_my_tab_col_stats
     		  WHERE
     		        owner not in
     		          ('SYS','SYSMAN','SYSTEM','OUTLN','TSMSYS','DBSNMP','WMSYS','EXFSYS','CTXSYS','DMSYS','XDB','MDSYS','ORDSYS','OLAPSYS')
     		  GROUP BY owner, table_name
       		  HAVING SUM(case WHEN histogram = 'FREQUENCY' THEN 1 ELSE 0
       		    END) > 0 AND
       		         SUM(case WHEN NUM_NULLS > 0 THEN  1 ELSE 0 END) > 0 AND
       		         SUM(case WHEN avg_col_len > 25 THEN 1 ELSE 0 END) > 0

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.0034s	0	0	0	0
Exec	0	1	0.0000s	0.0001s	0	0	0	0
Fetch		2	0.1094s	0.5546s	1,590	1,593	0	1
Total	1	4	0.1094s	0.5582s	1,590	1,593	0	1

Per Fch	0.5	2.0	0.0546s	0.2791s	795.0	796.5	0.0	0.5
Per Row	1.0	4.0	0.1094s	0.5582s	1,590.0	1,593.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 [idle]	92.3%	5.5000s	1	5.5000s	5.5000s	5.5000s
direct path read	5.9%	0.3513s	26	0.0135s	0.0000s	0.0971s
FETCH calls [CPU]	1.8%	0.1094s	2	0.0546s	0.0000s	0.1094s
SQL*Net message from client	0.0%	0.0003s	1	0.0003s	0.0003s	0.0003s
reliable message	0.0%	0.0002s	1	0.0002s	0.0002s	0.0002s
enq: KO - fast object checkpoint	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
SQL*Net message to client	0.0%	0.0000s	2	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%	5.9613s

Statement Read Statistics

Blocks Read per Call	% Time	Seconds	Calls	- Time per Call -
Blocks Read per Call	% Time	Seconds	Calls	Avg	Min	Max
64	55.6%	0.1953s	22	0.0088s	0.0000s	0.0190s
62	27.7%	0.0971s	1	0.0971s	0.0971s	0.0971s
56	12.2%	0.0427s	1	0.0427s	0.0427s	0.0427s
55	4.6%	0.0160s	1	0.0160s	0.0160s	0.0160s
9	0.0%	0.0000s	1	0.0000s	0.0000s	0.0000s
Total	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s

Statement Read Datafiles Statistics

Datafile #	% Time	Seconds	Calls	- Time per Call -
Datafile #	% Time	Seconds	Calls	Avg	Min	Max
1	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s
Total	100.0%	0.3513s	26	0.0135s	0.0000s	0.0971s

Statement Enqueue Statistics

Enqueue Type Mode	% Time	Seconds	Calls	- Time per Call -
Enqueue Type Mode	% Time	Seconds	Calls	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
1 378 32,022	FILTER (cr=1,593 pr=1,590 pw=1,590 time=0.0000s) HASH GROUP BY (cr=1,593 pr=1,590 pw=1,590 time=0.0000s cost=439 size=195 card=5) TABLE ACCESS FULL ALL_MY_TAB_COL_STATS (cr=1,593 pr=1,590 pw=1,590 time=0.0013s cost=436 size=2,276,625 card=58,375)	71633

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
SQL*Net message from client	100.0%	4.6807s	1	4.6807s	4.6807s	4.6807s
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%	4.6807s

Generated by OraSRP v3.1.3 beta