Session Summary
Instance Name: o9i
Node Name: vmt1
Oracle Release: 9.2.0.6.0
Session ID: 55.55555
Total SQL Statements: 1,002 (1,001 user statements, 1 internal statements)
Total Transactions: 2 (1 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
unaccounted-for time 60.4% 2.6356s        
PARSE calls [CPU] 21.8% 0.9508s 1,001 0.0009s 0.0000s 0.0170s
SQL*Net message from client [idle] 14.5% 0.6333s 1,002 0.0006s 0.0000s 0.0057s
EXEC calls [CPU] 3.1% 0.1340s 1,002 0.0001s 0.0000s 0.0070s
SQL*Net message to client 0.1% 0.0041s 1,002 0.0000s 0.0000s 0.0007s
log file sync 0.1% 0.0038s 1 0.0038s 0.0038s 0.0038s
FETCH calls [CPU] 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%4.3616s 
Top 5 Statements per Event
PARSE calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4113959642 99.3% 0.9438s 1,000 0.0009s 0.0000s 0.0170s
3073477137 0.7% 0.0070s 1 0.0070s 0.0070s 0.0070s
Total 100.0% 0.9508s 1,001 0.0009s 0.0000s 0.0170s
SQL*Net message from client [idle]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
956402276 0.9% 0.0057s 1 0.0057s 0.0057s 0.0057s
4152074177 0.7% 0.0047s 1 0.0047s 0.0047s 0.0047s
3283270477 0.7% 0.0043s 1 0.0043s 0.0043s 0.0043s
1540134688 0.4% 0.0027s 1 0.0027s 0.0027s 0.0027s
3367400412 0.4% 0.0027s 1 0.0027s 0.0027s 0.0027s
996 others 96.8% 0.6132s 997 0.0006s 0.0000s 0.0025s
Total 100.0% 0.6333s 1,002 0.0006s 0.0000s 0.0057s
EXEC calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
4113959642 98.5% 0.1320s 1,000 0.0001s 0.0000s 0.0070s
3073477137 1.5% 0.0020s 1 0.0020s 0.0020s 0.0020s
2075329282 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total 100.0% 0.1340s 1,002 0.0001s 0.0000s 0.0070s
SQL*Net message to client
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
3940776872 17.1% 0.0007s 1 0.0007s 0.0007s 0.0007s
1449829681 16.8% 0.0007s 1 0.0007s 0.0007s 0.0007s
2407929119 10.9% 0.0004s 1 0.0004s 0.0004s 0.0004s
2209036566 2.3% 0.0001s 1 0.0001s 0.0001s 0.0001s
1589956638 0.9% 0.0000s 1 0.0000s 0.0000s 0.0000s
996 others 52.0% 0.0022s 997 0.0000s 0.0000s 0.0000s
Total 100.0% 0.0041s 1,002 0.0000s 0.0000s 0.0007s
log file sync
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
Cursor #0 100.0% 0.0038s 1 0.0038s 0.0038s 0.0038s
Total 100.0% 0.0038s 1 0.0038s 0.0038s 0.0038s
FETCH calls [CPU]
SQL Hash Value % Time Seconds Calls - Time per Call -
Avg Min Max
3073477137 n/a % 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
4113959642
3073477137		99.3%
0.7%		100.0%
0.7%		3.2406s
0.0224s		3.2630s
0.0224s		2,000
3		999
0		INSERT
SELECT
2075329282n/a %0.0%0.0000s0.0000s10ALTER SESSION
Events Histograms
PARSE calls [CPU]
value - Distribution - count
0.000000s   518
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   237
0.001024s   120
0.002048s   108
0.004096s   17
0.008192s   0
0.016384s   1
0.032768s   0
SQL*Net message from client [idle]
value - Distribution - count
0.000000s   2
0.000001s   0
0.000002s   0
0.000004s   0
0.000008s   0
0.000016s   0
0.000032s   0
0.000064s   0
0.000128s   238
0.000256s   314
0.000512s   267
0.001024s   149
0.002048s   29
0.004096s   3
0.008192s   0
EXEC calls [CPU]
value - Distribution - count
0.000000s   880
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   115
0.001024s   6
0.002048s   0
0.004096s   1
0.008192s   0
SQL*Net message to client
value - Distribution - count
0.000000s   469
0.000001s   0
0.000002s   120
0.000004s   401
0.000008s   7
0.000016s   0
0.000032s   1
0.000064s   1
0.000128s   0
0.000256s   1
0.000512s   2
0.001024s   0
log file sync
value - Distribution - count
0.001024s   0
0.002048s   1
0.004096s   0
FETCH calls [CPU]
value - Distribution - count
0.000000s   1
SQL Statements
SQL Hash Value: 4113959642     uid: 42    depth: 0    optimizer mode: CHOOSE    similar statements: 999
Statement Text
insert into t3 values(0,lpad('0',20,'0'))
Statement Cumulative Statistics
CallCache
Misses		Count - Seconds -Physical
Reads		 - Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1,000 1,000 0.9528s 3.1088s 0 1 0 0
Exec 0 1,000 0.1320s 0.1541s 0 1,004 3,054 1,000
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1,000 2,000 1.0848s 3.2630s 0 1,005 3,054 1,000
Per Exe 1.0 2.0 0.0011s 0.0033s 0.0 1.0 3.1 1.0
Per Row 1.0 2.0 0.0011s 0.0033s 0.0 1.0 3.1 1.0
Statement Self Statistics
CallCache
Misses		Count - Seconds -Physical
Reads		 - Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1,000 1,000 0.9438s 3.0865s 0 0 0 0
Exec 0 1,000 0.1320s 0.1541s 0 1,004 3,054 1,000
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1,000 2,000 1.0758s 3.2406s 0 1,004 3,054 1,000
Per Exe 1.0 2.0 0.0011s 0.0032s 0.0 1.0 3.1 1.0
Per Row 1.0 2.0 0.0011s 0.0032s 0.0 1.0 3.1 1.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
PARSE calls [CPU] 87.5% 0.9438s 1,000 0.0009s 0.0000s 0.0170s
EXEC calls [CPU] 12.2% 0.1320s 1,000 0.0001s 0.0000s 0.0070s
SQL*Net message from client [idle] 0.2% 0.0023s 2 0.0011s 0.0009s 0.0014s
SQL*Net message to client 0.0% 0.0000s 2 0.0000s 0.0000s 0.0000s
Total100.0%1.0781s 


SQL Hash Value: 3073477137     uid: 0    depth: 1    optimizer mode: CHOOSE
Statement Text
select u.name,o.name, t.update$, t.insert$, t.delete$, t.enabled  
from obj$ o,user$ u,trigger$ t  
where t.baseobject=:1 and t.obj#=o.obj# and o.owner#=u.user#  
order by o.obj#
Statement Cumulative Statistics
CallCache
Misses		Count - Seconds -Physical
Reads		 - Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 1 1 0.0070s 0.0205s 0 0 0 0
Exec 0 1 0.0020s 0.0017s 0 0 0 0
Fetch   1 0.0000s 0.0002s 0 1 0 0
Total 1 3 0.0090s 0.0224s 0 1 0 0
Per Fch 1.0 3.0 0.0090s 0.0224s 0.0 1.0 0.0 0.0
Per Row 1.0 3.0 0.0090s 0.0224s 0.0 1.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
PARSE calls [CPU] 77.8% 0.0070s 1 0.0070s 0.0070s 0.0070s
EXEC calls [CPU] 22.2% 0.0020s 1 0.0020s 0.0020s 0.0020s
FETCH calls [CPU] 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0090s 

Statement Plan
met 1 time
Rows Row Source Operation Object Id
0
0
0
0
0
0
0
0
0		SORT ORDER BY
NESTED LOOPS
NESTED LOOPS
TABLE ACCESS BY INDEX ROWID TRIGGER$
INDEX RANGE SCAN I_TRIGGER1
TABLE ACCESS BY INDEX ROWID OBJ$
INDEX UNIQUE SCAN I_OBJ1
TABLE ACCESS CLUSTER USER$
INDEX UNIQUE SCAN I_USER# 		 
 
 
82
130
18
36
22
11


SQL Hash Value: 2075329282     uid: 42    depth: 0    optimizer mode: CHOOSE
Statement Text
alter session set events '10046 trace name context forever,level 8'
Statement Cumulative Statistics
CallCache
Misses		Count - Seconds -Physical
Reads		 - Logical Reads -Rows
CPUElapsedConsistentCurrent
Parse 0 0 0.0000s 0.0000s 0 0 0 0
Exec 1 1 0.0000s 0.0000s 0 0 0 0
Fetch   0 0.0000s 0.0000s 0 0 0 0
Total 1 1 0.0000s 0.0000s 0 0 0 0
Per Exe 1.0 1.0 0.0000s 0.0000s 0.0 0.0 0.0 0.0
Per Row 1.0 1.0 0.0000s 0.0000s 0.0 0.0 0.0 0.0
Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
EXEC calls [CPU] n/a % 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0000s 


SQL Hash Value: Cursor #0    uid: n/a
Statement Text
  No statement text found in trace file
Statement Cumulative Statistics
  No cumulative stat found in trace file

Statement Flat Profile
Event Name % Time Seconds Calls - Time per Call -
Avg Min Max
log file sync 86.1% 0.0038s 1 0.0038s 0.0038s 0.0038s
SQL*Net message from client [idle] 13.9% 0.0006s 1 0.0006s 0.0006s 0.0006s
SQL*Net message to client 0.0% 0.0000s 1 0.0000s 0.0000s 0.0000s
Total100.0%0.0044s 



Generated by OraSRP v4.1.0 beta