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 -
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
Total100.0%10.7411s 
Top 5 Statements per Event
SQL*Net message from client [idle]
SQL Hash Value % Time Seconds Calls - Time per Call -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
2266843291100.0%99.9%0.5582s0.5582s40SELECT
2217940283100.0%0.0%0.0003s0.0003s20ALTER 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 -
Avg Min Max
6455.6%0.1953s220.0088s0.0000s0.0190s
6227.7%0.0971s10.0971s0.0971s0.0971s
5612.2%0.0427s10.0427s0.0427s0.0427s
554.6%0.0160s10.0160s0.0160s0.0160s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 0.3513s 26 0.0135s 0.0000s 0.0971s
Session Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.3513s260.0135s0.0000s0.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 -
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: 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
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
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 -
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
Total100.0%5.9613s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6455.6%0.1953s220.0088s0.0000s0.0190s
6227.7%0.0971s10.0971s0.0971s0.0971s
5612.2%0.0427s10.0427s0.0427s0.0427s
554.6%0.0160s10.0160s0.0160s0.0160s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 0.3513s 26 0.0135s 0.0000s 0.0971s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.3513s260.0135s0.0000s0.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 -
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
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
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% 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
Total100.0%4.6807s