Session Summary
Instance Name: orcl899
Session ID: 125.82
Total SQL Statements: 13 (2 user statements, 11 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] 71.7% 7.8789s 1 7.8789s 7.8789s 7.8789s
SQL*Net message from client 19.8% 2.1745s 2 1.0873s 0.0003s 2.1741s
direct path read 3.9% 0.4338s 26 0.0166s 0.0000s 0.0986s
EXEC calls [CPU] 1.6% 0.1719s 27 0.0063s 0.0000s 0.1406s
unaccounted-for time 1.4% 0.1534s        
FETCH calls [CPU] 0.6% 0.0625s 37 0.0016s 0.0000s 0.0625s
control file sequential read 0.3% 0.0353s 5 0.0070s 0.0003s 0.0113s
db file sequential read 0.3% 0.0352s 2 0.0176s 0.0139s 0.0212s
db file scattered read 0.2% 0.0197s 5 0.0039s 0.0010s 0.0048s
PARSE calls [CPU] 0.1% 0.0156s 13 0.0012s 0.0000s 0.0156s
direct path write temp 0.0% 0.0009s 2 0.0004s 0.0000s 0.0008s
reliable message 0.0% 0.0001s 1 0.0001s 0.0001s 0.0001s
SQL*Net message to client 0.0% 0.0000s 3 0.0000s 0.0000s 0.0000s
enq: KO - fast object checkpoint 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%10.9822s 
Top 5 Statements per Event
SQL*Net message from client [idle]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 7.8789s 1 7.8789s 7.8789s 7.8789s
Total 100.0% 7.8789s 1 7.8789s 7.8789s 7.8789s
SQL*Net message from client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
791757000 100.0% 2.1741s 1 2.1741s 2.1741s 2.1741s
2107851660 0.0% 0.0003s 1 0.0003s 0.0003s 0.0003s
Total 100.0% 2.1745s 2 1.0873s 0.0003s 2.1741s
direct path read
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.4338s 26 0.0166s 0.0000s 0.0986s
Total 100.0% 0.4338s 26 0.0166s 0.0000s 0.0986s
EXEC calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 81.8% 0.1406s 1 0.1406s 0.1406s 0.1406s
864012087 9.1% 0.0156s 8 0.0019s 0.0000s 0.0156s
2584065658 9.1% 0.0156s 2 0.0078s 0.0000s 0.0156s
1714826286 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
2217940283 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
8 others 0.0% 0.0000s 14 0.0000s 0.0000s 0.0000s
Total 100.0% 0.1719s 27 0.0063s 0.0000s 0.1406s
FETCH calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0625s 2 0.0312s 0.0000s 0.0625s
791757000 0.0% 0.0000s 2 0.0000s 0.0000s 0.0000s
864012087 0.0% 0.0000s 8 0.0000s 0.0000s 0.0000s
4125641360 0.0% 0.0000s 4 0.0000s 0.0000s 0.0000s
440799922 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
6 others 0.0% 0.0000s 20 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0625s 37 0.0016s 0.0000s 0.0625s
control file sequential read
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0353s 5 0.0070s 0.0003s 0.0113s
Total 100.0% 0.0353s 5 0.0070s 0.0003s 0.0113s
db file sequential read
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2584065658 60.4% 0.0212s 1 0.0212s 0.0212s 0.0212s
864012087 39.6% 0.0139s 1 0.0139s 0.0139s 0.0139s
Total 100.0% 0.0352s 2 0.0176s 0.0139s 0.0212s
db file scattered read
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0197s 5 0.0039s 0.0010s 0.0048s
Total 100.0% 0.0197s 5 0.0039s 0.0010s 0.0048s
PARSE calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
440799922 100.0% 0.0156s 1 0.0156s 0.0156s 0.0156s
3309402135 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
2217940283 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
864012087 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
4125641360 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
8 others 0.0% 0.0000s 8 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0156s 13 0.0012s 0.0000s 0.0156s
direct path write temp
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0009s 2 0.0004s 0.0000s 0.0008s
Total 100.0% 0.0009s 2 0.0004s 0.0000s 0.0008s
reliable message
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0001s 1 0.0001s 0.0001s 0.0001s
Total 100.0% 0.0001s 1 0.0001s 0.0001s 0.0001s
SQL*Net message to client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 61.9% 0.0000s 2 0.0000s 0.0000s 0.0000s
791757000 38.1% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0000s 3 0.0000s 0.0000s 0.0000s
enq: KO - fast object checkpoint
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
2107851660 100.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Session Call Graph
SQL Hash Value Branch % Total % Self
Seconds
Cumulative
Seconds
Calls Similar Command Type
2107851660
1714826286
3988833529
2584065658
864012087
3309402135
3159716790
4125641360
2512561537
791757000
440799922
3159716790
2584065658
2512561537
3598296092
4125641360
4125641360
791757000
864012087
88.6%
0.3%
0.8%
2.4%
1.9%
1.8%
0.1%
0.1%
0.0%
0.0%
0.5%
1.0%
0.6%
0.5%
0.3%
0.0%
0.4%
0.3%
0.2%
99.9%
10.4%
7.2%
2.4%
1.9%
1.8%
0.1%
0.1%
0.0%
0.0%
2.5%
1.0%
0.6%
0.5%
0.3%
0.0%
0.4%
0.3%
0.2%
0.8015s
0.0031s
0.0069s
0.0217s
0.0169s
0.0163s
0.0013s
0.0009s
0.0004s
0.0002s
0.0040s
0.0090s
0.0056s
0.0041s
0.0029s
0.0005s
0.0036s
0.0029s
0.0018s
0.9045s
0.0945s
0.0649s
0.0217s
0.0169s
0.0163s
0.0013s
0.0009s
0.0004s
0.0002s
0.0229s
0.0090s
0.0056s
0.0041s
0.0029s
0.0005s
0.0036s
0.0029s
0.0018s
4
2
3
2
5
5
3
4
9
2
3
3
3
4
3
2
3
3
12
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
SELECT
CREATE TABLE
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
SELECT
2217940283100.0%0.0%0.0004s0.0004s20ALTER 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   1
4.194304s   0
direct path read
value - Distribution - count
0.000002s   0
0.000004s   5
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   1
0.004096s   2
0.008192s   14
0.016384s   1
0.032768s   2
0.065536s   1
0.131072s   0
EXEC calls [CPU]
value - Distribution - count
0.000000s   24
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   2
0.016384s   0
0.032768s   0
0.065536s   0
0.131072s   1
0.262144s   0
FETCH calls [CPU]
value - Distribution - count
0.000000s   36
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   1
0.065536s   0
control file sequential read
value - Distribution - count
0.000128s   0
0.000256s   1
0.000512s   0
0.001024s   0
0.002048s   0
0.004096s   1
0.008192s   3
0.016384s   0
db file sequential read
value - Distribution - count
0.004096s   0
0.008192s   1
0.016384s   1
0.032768s   0
db file scattered read
value - Distribution - count
0.000512s   0
0.001024s   1
0.002048s   0
0.004096s   4
0.008192s   0
PARSE calls [CPU]
value - Distribution - count
0.000000s   12
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
direct path write temp
value - Distribution - count
0.000008s   0
0.000016s   1
0.000032s   0
0.000064s   0
0.000128s   0
0.000256s   0
0.000512s   1
0.001024s   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   2
0.000008s   1
0.000016s   0
enq: KO - fast object checkpoint
value - Distribution - count
0.000004s   0
0.000008s   1
0.000016s   0
Session Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6455.0%0.2686s250.0107s0.0000s0.0648s
6220.2%0.0986s10.0986s0.0986s0.0986s
5613.3%0.0649s10.0649s0.0649s0.0649s
17.2%0.0352s20.0176s0.0139s0.0212s
553.2%0.0157s10.0157s0.0157s0.0157s
630.9%0.0046s10.0046s0.0046s0.0046s
130.2%0.0010s10.0010s0.0010s0.0010s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 0.4888s 33 0.0148s 0.0000s 0.0986s
Session Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
196.0%0.4690s280.0167s0.0000s0.0986s
2014.0%0.0197s50.0039s0.0010s0.0048s
Total 100.0% 0.4888s 33 0.0148s 0.0000s 0.0986s
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: 2107851660     SQL Id: dmtcxttyu6hwc     uid: 5    depth: 0    optimizer mode: ALL_ROWS
Statement Text
WITH c1 as (
SELECT owner, table_name, column_name, histogram, num_nulls, avg_col_len 
FROM all_my_tab_col_stats 
WHERE owner not in
  ('SYS','SYSMAN','SYSTEM','OUTLN','TSMSYS','DBSNMP','WMSYS','EXFSYS','CTXSYS','DMSYS','XDB','MDSYS','ORDSYS','OLAPSYS'))
SELECT distinct owner, table_name FROM  (
SELECT owner, table_name FROM c1 WHERE HISTOGRAM = 'FREQUENCY'
INTERSECT
SELECT owner, table_name FROM c1 WHERE NUM_NULLS > 1
INTERSECT
SELECT owner, table_name FROM c1 WHERE avg_col_len > 25
)

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0468s 0.1305s 2 73 2 0
Exec 0 1 0.1406s 0.6798s 1,590 1,593 278 0
Fetch   2 0.0625s 0.0941s 268 815 1 1
Total 1 4 0.2500s 0.9045s 1,860 2,481 281 1
Per Fch 0.5 2.0 0.1250s 0.4522s 930.0 1,240.5 140.5 0.5
Per Row 1.0 4.0 0.2500s 0.9045s 1,860.0 2,481.0 281.0 1.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0274s 0 0 1 0
Exec 0 1 0.1406s 0.6798s 1,590 1,593 278 0
Fetch   2 0.0625s 0.0941s 268 815 1 1
Total 1 4 0.2031s 0.8015s 1,858 2,408 280 1
Per Fch 0.5 2.0 0.1016s 0.4007s 929.0 1,204.0 140.0 0.5
Per Row 1.0 4.0 0.2031s 0.8015s 1,858.0 2,408.0 280.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
SQL*Net message from client [idle] 91.9% 7.8789s 1 7.8789s 7.8789s 7.8789s
direct path read 5.1% 0.4338s 26 0.0166s 0.0000s 0.0986s
EXEC calls [CPU] 1.6% 0.1406s 1 0.1406s 0.1406s 0.1406s
FETCH calls [CPU] 0.7% 0.0625s 2 0.0312s 0.0000s 0.0625s
control file sequential read 0.4% 0.0353s 5 0.0070s 0.0003s 0.0113s
db file scattered read 0.2% 0.0197s 5 0.0039s 0.0010s 0.0048s
direct path write temp 0.0% 0.0009s 2 0.0004s 0.0000s 0.0008s
SQL*Net message from client 0.0% 0.0003s 1 0.0003s 0.0003s 0.0003s
reliable message 0.0% 0.0001s 1 0.0001s 0.0001s 0.0001s
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
PARSE calls [CPU] 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%8.5725s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
6459.2%0.2686s250.0107s0.0000s0.0648s
6221.7%0.0986s10.0986s0.0986s0.0986s
5614.3%0.0649s10.0649s0.0649s0.0649s
553.5%0.0157s10.0157s0.0157s0.0157s
631.0%0.0046s10.0046s0.0046s0.0046s
130.2%0.0010s10.0010s0.0010s0.0010s
90.0%0.0000s10.0000s0.0000s0.0000s
Total 100.0% 0.4536s 31 0.0146s 0.0000s 0.0986s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
195.6%0.4338s260.0166s0.0000s0.0986s
2014.4%0.0197s50.0039s0.0010s0.0048s
Total 100.0% 0.4536s 31 0.0146s 0.0000s 0.0986s
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
1
32,022
1
1
5
9
102
32,022
74
5,568
32,022
60
990
32,022
TEMP TABLE TRANSFORMATION (cr=2,408 pr=1,858 pw=1,858 time=0.0000s)
LOAD AS SELECT (cr=1,593 pr=1,590 pw=1,590 time=0.0000s)
TABLE ACCESS FULL ALL_MY_TAB_COL_STATS (cr=1,593 pr=1,590 pw=1,590 time=0.0012s cost=436 size=2,977,125 card=58,375)
VIEW (cr=815 pr=268 pw=268 time=0.0000s cost=2,358 size=1,984,750 card=58,375)
INTERSECTION (cr=815 pr=268 pw=268 time=0.0000s)
INTERSECTION (cr=544 pr=268 pw=268 time=0.0000s)
SORT UNIQUE (cr=273 pr=268 pw=268 time=0.0000s cost=756 size=2,510,125 card=58,375)
VIEW (cr=273 pr=268 pw=268 time=0.0000s cost=112 size=2,510,125 card=58,375)
TABLE ACCESS FULL SYS_TEMP_0FD9D6611_141762 (cr=273 pr=268 pw=268 time=0.0007s cost=112 size=2,977,125 card=58,375)
SORT UNIQUE (cr=271 pr=0 pw=0 time=0.0000s cost=801 size=2,743,625 card=58,375)
VIEW (cr=271 pr=0 pw=0 time=0.0009s cost=112 size=2,743,625 card=58,375)
TABLE ACCESS FULL SYS_TEMP_0FD9D6611_141762 (cr=271 pr=0 pw=0 time=0.0007s cost=112 size=2,977,125 card=58,375)
SORT UNIQUE (cr=271 pr=0 pw=0 time=0.0000s cost=801 size=2,743,625 card=58,375)
VIEW (cr=271 pr=0 pw=0 time=0.0003s cost=112 size=2,743,625 card=58,375)
TABLE ACCESS FULL SYS_TEMP_0FD9D6611_141762 (cr=271 pr=0 pw=0 time=0.0008s cost=112 size=2,977,125 card=58,375)
 
 
71633
 
 
 
 
 
-40016367
 
 
-40016367
 
 
-40016367


SQL Hash Value: 2584065658     SQL Id: 1gu8t96d0bdmu     uid: 0    depth: 3    optimizer mode: CHOOSE
Statement Text
select
  t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.clucols,0),t.audit$,t.flags,t.pctfree$,t.pctused$,t.initrans,t.maxtrans,t.rowcnt,t.blkcnt,t.empcnt,t.avgspc,t.chncnt,t.avgrln,t.analyzetime,t.samplesize,t.cols,t.property,nvl(t.degree,1),nvl(t.instances,1),t.avgspc_flb,t.flbcnt,t.kernelcols,nvl(t.trigflag,
  0),nvl(t.spare1,0),nvl(t.spare2,0),t.spare4,t.spare6,ts.cachedblk,ts.cachehit,ts.logicalread
from tab$ t, tab_stats$ ts 
where t.obj#= :1 and t.obj# = ts.obj# (+)

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 1 2 0.0156s 0.0041s 0 0 0 0
Fetch   2 0.0000s 0.0217s 1 8 0 2
Total 2 5 0.0156s 0.0273s 1 8 0 2
Per Fch 1.0 2.5 0.0078s 0.0136s 0.5 4.0 0.0 1.0
Per Row 1.0 2.5 0.0078s 0.0136s 0.5 4.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
db file sequential read 57.6% 0.0212s 1 0.0212s 0.0212s 0.0212s
EXEC calls [CPU] 42.4% 0.0156s 2 0.0078s 0.0000s 0.0156s
FETCH calls [CPU] 0.0% 0.0000s 2 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0368s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.0212s10.0212s0.0212s0.0212s
Total 100.0% 0.0212s 1 0.0212s 0.0212s 0.0212s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.0212s10.0212s0.0212s0.0212s
Total 100.0% 0.0212s 1 0.0212s 0.0212s 0.0212s
Statement Plan
met 1 time
Rows Row Source Operation Object Id
1
1
1
0
0
0
MERGE JOIN OUTER (cr=4 pr=0 pw=0 time=0.0000s cost=2 size=189 card=1)
TABLE ACCESS CLUSTER TAB$ (cr=3 pr=0 pw=0 time=0.0000s cost=2 size=137 card=1)
INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0.0000s cost=1 size=0 card=1)
BUFFER SORT (cr=1 pr=0 pw=0 time=0.0000s cost=0 size=52 card=1)
TABLE ACCESS BY INDEX ROWID TAB_STATS$ (cr=1 pr=0 pw=0 time=0.0000s cost=0 size=52 card=1)
INDEX UNIQUE SCAN I_TAB_STATS$_OBJ# (cr=1 pr=0 pw=0 time=0.0000s cost=0 size=0 card=1)
 
4
3
 
416
417

Statement Binds Statistics
total binds sets: 2    unique binds sets: 2
Sample Bind Set
met 1 time; elapsed time spent: 0.0217s
NameData TypeValue
1 NUMBER 696

SQL Hash Value: 864012087     SQL Id: 96g93hntrzjtr     uid: 0    depth: 1,3    optimizer mode: RULE
Statement Text
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#,
  sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1,
  spare2, avgcln
from hist_head$ 
where obj#=:1 and intcol#=:2

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0008s 0 0 0 0
Exec 1 8 0.0156s 0.0036s 0 0 0 0
Fetch   8 0.0000s 0.0143s 1 18 0 2
Total 2 17 0.0156s 0.0188s 1 18 0 2
Per Fch 0.3 2.1 0.0019s 0.0023s 0.1 2.3 0.0 0.3
Per Row 1.0 8.5 0.0078s 0.0094s 0.5 9.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
EXEC calls [CPU] 52.9% 0.0156s 8 0.0019s 0.0000s 0.0156s
db file sequential read 47.1% 0.0139s 1 0.0139s 0.0139s 0.0139s
FETCH calls [CPU] 0.0% 0.0000s 8 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0295s 

Statement Read Statistics
Blocks Read per Call % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.0139s10.0139s0.0139s0.0139s
Total 100.0% 0.0139s 1 0.0139s 0.0139s 0.0139s
Statement Read Datafiles Statistics
Datafile # % Time Seconds Calls - Time per Call -
Avg Min Max
1100.0%0.0139s10.0139s0.0139s0.0139s
Total 100.0% 0.0139s 1 0.0139s 0.0139s 0.0139s
Statement Plan
met 1 time
Rows Row Source Operation Object Id
1
1
TABLE ACCESS BY INDEX ROWID HIST_HEAD$ (cr=3 pr=1 pw=1 time=0.0000s)
INDEX RANGE SCAN I_HH_OBJ#_INTCOL# (cr=2 pr=0 pw=0 time=0.0000s)
411
413

Statement Binds Statistics
total binds sets: 5    unique binds sets: 4
Sample Bind Set
met 2 times; elapsed time spent: 0.0174s
NameData TypeValue
1 NUMBER 4254950929
2 NUMBER 1

SQL Hash Value: 3309402135     SQL Id: 5n1fs4m2n2y0r     uid: 0    depth: 3    optimizer mode: CHOOSE
Statement Text
select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0008s 0 0 0 0
Exec 1 1 0.0000s 0.0154s 0 0 0 0
Fetch   3 0.0000s 0.0001s 0 6 0 2
Total 2 5 0.0000s 0.0163s 0 6 0 2
Per Fch 0.7 1.7 0.0000s 0.0054s 0.0 2.0 0.0 0.7
Per Row 1.0 2.5 0.0000s 0.0081s 0.0 3.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 3 0.0000s 0.0000s 0.0000s
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
2
2
TABLE ACCESS BY INDEX ROWID ICOL$ (cr=6 pr=0 pw=0 time=0.0000s cost=2 size=54 card=2)
INDEX RANGE SCAN I_ICOL1 (cr=4 pr=0 pw=0 time=0.0000s cost=1 size=0 card=2)
20
42

Statement Binds Statistics
total binds sets: 2    unique binds sets: 2
Sample Bind Set
met 1 time; elapsed time spent: 0.0163s
NameData TypeValue
1 NUMBER 697

SQL Hash Value: 3159716790     SQL Id: 7ng34ruy5awxq     uid: 0    depth: 3    optimizer mode: CHOOSE
Statement Text
select
  i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread
from ind$ i, ind_stats$ ist, (
select enabled, min(cols) unicols,min(to_number(bitand(defer,1)))
  deferrable#,min(to_number(bitand(defer,4))) valid#
from cdef$ 
where obj#=:1 and enabled > 1 
group by enabled) c 
where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 
order by i.obj#

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0020s 0 0 0 0
Exec 1 2 0.0000s 0.0068s 0 0 0 0
Fetch   3 0.0000s 0.0015s 0 11 0 1
Total 2 6 0.0000s 0.0104s 0 11 0 1
Per Fch 0.7 2.0 0.0000s 0.0034s 0.0 3.7 0.0 0.3
Per Row 2.0 6.0 0.0000s 0.0104s 0.0 11.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 3 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] n/a % 0.0000s 2 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
0
0
0
0
1
0
0
0
0
0
0
SORT ORDER BY (cr=3 pr=0 pw=0 time=0.0000s cost=7 size=372 card=2)
HASH JOIN OUTER (cr=3 pr=0 pw=0 time=0.0000s cost=6 size=372 card=2)
NESTED LOOPS OUTER (cr=3 pr=0 pw=0 time=0.0000s cost=2 size=286 card=2)
TABLE ACCESS CLUSTER IND$ (cr=3 pr=0 pw=0 time=0.0000s cost=2 size=182 card=2)
INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0.0000s cost=1 size=0 card=1)
TABLE ACCESS BY INDEX ROWID IND_STATS$ (cr=0 pr=0 pw=0 time=0.0000s cost=0 size=52 card=1)
INDEX UNIQUE SCAN I_IND_STATS$_OBJ# (cr=0 pr=0 pw=0 time=0.0000s cost=0 size=0 card=1)
VIEW (cr=0 pr=0 pw=0 time=0.0000s cost=3 size=43 card=1)
SORT GROUP BY (cr=0 pr=0 pw=0 time=0.0000s cost=3 size=15 card=1)
TABLE ACCESS CLUSTER CDEF$ (cr=0 pr=0 pw=0 time=0.0000s cost=2 size=15 card=1)
INDEX UNIQUE SCAN I_COBJ# (cr=0 pr=0 pw=0 time=0.0000s cost=1 size=0 card=1)
 
 
 
19
3
418
419
 
 
31
30

Statement Binds Statistics
total binds sets: 2    unique binds sets: 2
Sample Bind Set
met 1 time; elapsed time spent: 0.0090s
NameData TypeValue
1 NUMBER 696

SQL Hash Value: 3988833529     SQL Id: 14fy467qw1j7t     uid: 0    depth: 2    optimizer mode: CHOOSE
Statement Text
select 1 
from sys.streams$_prepare_ddl p  
where ((p.global_flag = 1 and :1 is null) or (p.global_flag = 0 and p.usrid =
  :2)) and rownum = 1

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0004s 0 0 0 0
Exec 1 1 0.0000s 0.0644s 2 38 0 0
Fetch   1 0.0000s 0.0000s 0 1 0 0
Total 2 3 0.0000s 0.0649s 2 39 0 0
Per Fch 2.0 3.0 0.0000s 0.0649s 2.0 39.0 0.0 0.0
Per Row 2.0 3.0 0.0000s 0.0649s 2.0 39.0 0.0 0.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0004s 0 0 0 0
Exec 1 1 0.0000s 0.0064s 0 0 0 0
Fetch   1 0.0000s 0.0000s 0 1 0 0
Total 2 3 0.0000s 0.0069s 0 1 0 0
Per Fch 2.0 3.0 0.0000s 0.0069s 0.0 1.0 0.0 0.0
Per Row 2.0 3.0 0.0000s 0.0069s 0.0 1.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
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
COUNT STOPKEY (cr=1 pr=0 pw=0 time=0.0000s)
INDEX FULL SCAN I_STREAMS_PREPARE_DDL (cr=1 pr=0 pw=0 time=0.0000s cost=0 size=26 card=1)
 
697

Statement Binds Statistics
total binds sets: 2    unique binds sets: 2
Sample Bind Set
met 1 time; elapsed time spent: 0.0069s
NameData TypeValue
1 NUMBER 0
2 NUMBER 0

SQL Hash Value: 4125641360     SQL Id: 04xtrk7uyhknh     uid: 0    depth: 1,2,3    optimizer mode: CHOOSE
Statement Text
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 
from obj$ 
where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and
  linkname is null and subname is null

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0007s 0 0 0 0
Exec 1 4 0.0000s 0.0040s 0 0 0 0
Fetch   4 0.0000s 0.0002s 0 14 0 2
Total 2 9 0.0000s 0.0051s 0 14 0 2
Per Fch 0.5 2.3 0.0000s 0.0012s 0.0 3.5 0.0 0.5
Per Row 1.0 4.5 0.0000s 0.0025s 0.0 7.0 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 4 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] n/a % 0.0000s 4 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
0
0
TABLE ACCESS BY INDEX ROWID OBJ$ (cr=3 pr=0 pw=0 time=0.0000s cost=4 size=82 card=1)
INDEX RANGE SCAN I_OBJ2 (cr=3 pr=0 pw=0 time=0.0000s cost=3 size=0 card=1)
18
37

Statement Binds Statistics
total binds sets: 3    unique binds sets: 3
Sample Bind Set
met 1 time; elapsed time spent: 0.0036s
NameData TypeValue
1 NUMBER 0
2 VARCHAR2 "STREAMS$_PREPARE_DDL"
3 NUMBER 1

SQL Hash Value: 2512561537     SQL Id: 83taa7kaw59c1     uid: 0    depth: 3    optimizer mode: CHOOSE
Statement Text
select
  name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(scale,-127/*MAXSB1MINAL*/),178,scale,179,scale,180,scale,181,scale,182,scale,183,scale,231,scale,0),null$,fixedstorage,nvl(deflength,0),default$,rowid,col#,property,
  nvl(charsetid,0),nvl(charsetform,0),spare1,spare2,nvl(spare3,0)
from col$ 
where obj#=:1 
order by intcol#

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0011s 0 0 0 0
Exec 1 2 0.0000s 0.0030s 0 0 0 0
Fetch   10 0.0000s 0.0004s 0 6 0 8
Total 2 13 0.0000s 0.0046s 0 6 0 8
Per Fch 0.2 1.3 0.0000s 0.0004s 0.0 0.6 0.0 0.8
Per Row 0.3 1.6 0.0000s 0.0005s 0.0 0.8 0.0 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 10 0.0000s 0.0000s 0.0000s
PARSE calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
EXEC calls [CPU] n/a % 0.0000s 2 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
1
1
1
SORT ORDER BY (cr=3 pr=0 pw=0 time=0.0000s cost=3 size=649 card=11)
TABLE ACCESS CLUSTER COL$ (cr=3 pr=0 pw=0 time=0.0000s cost=2 size=649 card=11)
INDEX UNIQUE SCAN I_OBJ# (cr=2 pr=0 pw=0 time=0.0000s cost=1 size=0 card=1)
 
21
3

Statement Binds Statistics
total binds sets: 2    unique binds sets: 2
Sample Bind Set
met 1 time; elapsed time spent: 0.0041s
NameData TypeValue
1 NUMBER 60

SQL Hash Value: 440799922     SQL Id: 77mtwmnd4c4pk     uid: 0    depth: 2    optimizer mode: CHOOSE
Statement Text
select obj# from objerror$

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0312s 0.0228s 0 10 0 0
Exec 0 1 0.0000s 0.0000s 0 0 0 0
Fetch   1 0.0000s 0.0000s 0 3 0 0
Total 1 3 0.0312s 0.0229s 0 13 0 0
Per Fch 1.0 3.0 0.0312s 0.0229s 0.0 13.0 0.0 0.0
Per Row 1.0 3.0 0.0312s 0.0229s 0.0 13.0 0.0 0.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0156s 0.0039s 0 0 0 0
Exec 0 1 0.0000s 0.0000s 0 0 0 0
Fetch   1 0.0000s 0.0000s 0 3 0 0
Total 1 3 0.0156s 0.0040s 0 3 0 0
Per Fch 1.0 3.0 0.0156s 0.0040s 0.0 3.0 0.0 0.0
Per Row 1.0 3.0 0.0156s 0.0040s 0.0 3.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
PARSE calls [CPU] 100.0% 0.0156s 1 0.0156s 0.0156s 0.0156s
FETCH 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%0.0156s 

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


SQL Hash Value: 791757000     SQL Id: 87gaftwrm2h68     uid: 0    depth: 1,3    optimizer mode: CHOOSE
Statement Text
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname 
from obj$ o 
where o.obj#=:1

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0006s 0 0 0 0
Exec 1 2 0.0000s 0.0023s 0 0 0 0
Fetch   2 0.0000s 0.0001s 0 5 0 1
Total 2 5 0.0000s 0.0032s 0 5 0 1
Per Fch 1.0 2.5 0.0000s 0.0016s 0.0 2.5 0.0 0.5
Per Row 2.0 5.0 0.0000s 0.0032s 0.0 5.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.1741s 1 2.1741s 2.1741s 2.1741s
SQL*Net message to client 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
FETCH calls [CPU] 0.0% 0.0000s 2 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 2 0.0000s 0.0000s 0.0000s
Total100.0%2.1742s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
0
0
TABLE ACCESS BY INDEX ROWID OBJ$ (cr=2 pr=0 pw=0 time=0.0000s cost=3 size=82 card=1)
INDEX RANGE SCAN I_OBJ1 (cr=2 pr=0 pw=0 time=0.0000s cost=2 size=0 card=1)
18
36

Statement Binds Statistics
total binds sets: 1    unique binds sets: 1
Sample Bind Set
met 1 time; elapsed time spent: 0.0029s
NameData TypeValue
1 NUMBER 4254950929

SQL Hash Value: 1714826286     SQL Id: gj2b57dm3cb1f     uid: 0    depth: 1    optimizer mode: CHOOSE
Statement Text
CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FD9D6611_141762" ("C0"
  VARCHAR2(30),"C1" VARCHAR2(30),"C2" VARCHAR2(30),"C3" VARCHAR2(15),"C4"
  NUMBER,"C5" NUMBER ) IN_MEMORY_METADATA CURSOR_SPECIFIC_SEGMENT STORAGE (OBJNO
  4254950929 ) NOPARALLEL

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0007s 0 0 0 0
Exec 0 1 0.0312s 0.0937s 2 56 1 0
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1 2 0.0312s 0.0945s 2 56 1 0
Per Exe 1.0 2.0 0.0312s 0.0945s 2.0 56.0 1.0 0.0
Per Row 1.0 2.0 0.0312s 0.0945s 2.0 56.0 1.0 0.0
Statement Self Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0007s 0 0 0 0
Exec 0 1 0.0000s 0.0023s 0 0 1 0
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1 2 0.0000s 0.0031s 0 0 1 0
Per Exe 1.0 2.0 0.0000s 0.0031s 0.0 0.0 1.0 0.0
Per Row 1.0 2.0 0.0000s 0.0031s 0.0 0.0 1.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 


SQL Hash Value: 3598296092     SQL Id: 1a8n1zgb7m90w     uid: 0    depth: 2    optimizer mode: CHOOSE
Statement Text
select user#,password,datats#,tempts#,type#,defrole,resource$, ptime,exptime,
  ltime, astatus, lcount,
  decode(defschclass,NULL,'DEFAULT_CONSUMER_GROUP',defschclass),spare1,spare4,ext_username,spare2
from user$ 
where name=:1

Statement Cumulative Statistics
CallCache
Misses
Count - Seconds -Physical
Reads
- Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0000s 0.0008s 0 0 0 0
Exec 1 1 0.0000s 0.0020s 0 0 0 0
Fetch   1 0.0000s 0.0000s 0 1 0 0
Total 2 3 0.0000s 0.0029s 0 1 0 0
Per Fch 2.0 3.0 0.0000s 0.0029s 0.0 1.0 0.0 0.0
Per Row 2.0 3.0 0.0000s 0.0029s 0.0 1.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
FETCH calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
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
TABLE ACCESS BY INDEX ROWID USER$ (cr=1 pr=0 pw=0 time=0.0000s cost=1 size=115 card=1)
INDEX UNIQUE SCAN I_USER1 (cr=1 pr=0 pw=0 time=0.0000s cost=0 size=0 card=1)
22
46

Statement Binds Statistics
total binds sets: 1    unique binds sets: 1
Sample Bind Set
met 1 time; elapsed time spent: 0.0029s
NameData TypeValue
1 VARCHAR2 "SYS_TEMP_0FD9D6611_141762"

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.0004s 0 0 0 0
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 0 2 0.0000s 0.0004s 0 0 0 0
Per Exe 0.0 2.0 0.0000s 0.0004s 0.0 0.0 0.0 0.0
Per Row 0.0 2.0 0.0000s 0.0004s 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