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 |
Total | 100.0% | 4.3616s |
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 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 |
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 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 |
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 |
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 |
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 |
2075329282 | n/a % | 0.0% | 0.0000s | 0.0000s | 1 | 0 | ALTER SESSION |
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 |
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 |
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 |
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 |
value | - Distribution - | count |
---|---|---|
0.001024s | 0 | |
0.002048s | 1 | |
0.004096s | 0 |
value | - Distribution - | count |
---|---|---|
0.000000s | 1 |
insert into t3 values(0,lpad('0',20,'0'))
Call | Cache Misses | Count | - Seconds - | Physical Reads | - Logical Reads - | Rows | ||
---|---|---|---|---|---|---|---|---|
CPU | Elapsed | Consistent | Current | |||||
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 |
Call | Cache Misses | Count | - Seconds - | Physical Reads | - Logical Reads - | Rows | ||
---|---|---|---|---|---|---|---|---|
CPU | Elapsed | Consistent | Current | |||||
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 |
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 |
Total | 100.0% | 1.0781s |
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#
Call | Cache Misses | Count | - Seconds - | Physical Reads | - Logical Reads - | Rows | ||
---|---|---|---|---|---|---|---|---|
CPU | Elapsed | Consistent | Current | |||||
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 |
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 |
Total | 100.0% | 0.0090s |
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 |
alter session set events '10046 trace name context forever,level 8'
Call | Cache Misses | Count | - Seconds - | Physical Reads | - Logical Reads - | Rows | ||
---|---|---|---|---|---|---|---|---|
CPU | Elapsed | Consistent | Current | |||||
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 |
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 |
Total | 100.0% | 0.0000s |
No statement text found in trace file
No cumulative stat found in trace file
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 |
Total | 100.0% | 0.0044s |