DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
DB11G | 279886783 | DB11G | 1 | 07-Oct-13 20:10 | 11.2.0.3.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
ol6-112.localdomain | Linux x86 64-bit | 2 | 2 | 1 | 2.95 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 79 | 07-Oct-13 20:53:32 | 72 | 3.3 |
End Snap: | 80 | 07-Oct-13 21:10:32 | 71 | 3.2 |
Elapsed: | 16.99 (mins) | |||
DB Time: | 84.04 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 380M | 372M | Std Block Size: | 8K |
Shared Pool Size: | 196M | 204M | Log Buffer: | 7,356K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 5.0 | 0.1 | 0.02 | 0.08 |
DB CPU(s): | 1.2 | 0.0 | 0.01 | 0.02 |
Redo size: | 48,397.4 | 1,268.4 | ||
Logical reads: | 1,834.5 | 48.1 | ||
Block changes: | 410.5 | 10.8 | ||
Physical reads: | 42.7 | 1.1 | ||
Physical writes: | 26.5 | 0.7 | ||
User calls: | 58.4 | 1.5 | ||
Parses: | 12.3 | 0.3 | ||
Hard parses: | 1.0 | 0.0 | ||
W/A MB processed: | 7.5 | 0.2 | ||
Logons: | 0.1 | 0.0 | ||
Executes: | 216.0 | 5.7 | ||
Rollbacks: | 7.8 | 0.2 | ||
Transactions: | 38.2 |
Buffer Nowait %: | 99.98 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 97.82 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.00 | Soft Parse %: | 91.80 |
Execute to Parse %: | 94.31 | Latch Hit %: | 99.85 |
Parse CPU to Parse Elapsd %: | 23.78 | % Non-Parse CPU: | 96.98 |
Begin | End | |
---|---|---|
Memory Usage %: | 82.49 | 88.47 |
% SQL with executions>1: | 76.23 | 77.56 |
% Memory for SQL w/exec>1: | 68.96 | 59.59 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DB CPU | 1,201 | 23.82 | |||
db file sequential read | 39,575 | 114 | 3 | 2.26 | User I/O |
library cache: mutex X | 2,392 | 47 | 20 | 0.93 | Concurrency |
log file sync | 4,423 | 37 | 8 | 0.74 | Commit |
latch free | 2,800 | 32 | 11 | 0.63 | Other |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
9.19 | 8.78 | 56.5 | 29.1 | 0.2 | 10.6 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
66.9 | 74.8 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 3,016.8 | 3,016.8 |
SGA use (MB): | 600.0 | 600.0 |
PGA use (MB): | 188.5 | 183.9 |
% Host Mem used for SGA+PGA: | 26.14 | 25.99 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 4,438.60 | 88.03 |
DB CPU | 1,200.91 | 23.82 |
PL/SQL execution elapsed time | 1,134.42 | 22.50 |
parse time elapsed | 274.43 | 5.44 |
hard parse elapsed time | 159.65 | 3.17 |
PL/SQL compilation elapsed time | 7.05 | 0.14 |
hard parse (sharing criteria) elapsed time | 6.69 | 0.13 |
connection management call elapsed time | 5.95 | 0.12 |
repeated bind elapsed time | 4.52 | 0.09 |
hard parse (bind mismatch) elapsed time | 2.69 | 0.05 |
sequence load elapsed time | 0.17 | 0.00 |
DB time | 5,042.30 | |
background elapsed time | 381.68 | |
background cpu time | 96.19 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 173,390 | |
IDLE_TIME | 20,551 | |
IOWAIT_TIME | 401 | |
NICE_TIME | 846 | |
SYS_TIME | 56,512 | |
USER_TIME | 109,541 | |
LOAD | 9 | 9 |
PHYSICAL_MEMORY_BYTES | 3,163,295,744 | |
NUM_CPUS | 2 | |
NUM_CPU_CORES | 2 | |
NUM_CPU_SOCKETS | 1 | |
GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 3,102,176 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 3,102,176 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
07-Oct 20:53:32 | 9.19 | |||||
07-Oct 21:10:32 | 8.78 | 89.40 | 56.48 | 29.14 | 10.60 | 0.21 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
DB CPU | 1,201 | 23.82 | |||
User I/O | 40,650 | 0 | 119 | 3 | 2.36 |
Concurrency | 4,221 | 0 | 71 | 17 | 1.41 |
Other | 3,775 | 1 | 43 | 11 | 0.85 |
Commit | 4,423 | 0 | 37 | 8 | 0.74 |
Network | 31,409 | 0 | 14 | 0 | 0.27 |
Configuration | 47 | 0 | 7 | 149 | 0.14 |
System I/O | 2,630 | 0 | 2 | 1 | 0.03 |
Application | 152 | 0 | 1 | 3 | 0.01 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
db file sequential read | 39,575 | 0 | 114 | 3 | 1.02 | 2.26 |
library cache: mutex X | 2,392 | 0 | 47 | 20 | 0.06 | 0.93 |
log file sync | 4,423 | 0 | 37 | 8 | 0.11 | 0.74 |
latch free | 2,800 | 0 | 32 | 11 | 0.07 | 0.63 |
SQL*Net message to client | 31,228 | 0 | 13 | 0 | 0.80 | 0.26 |
enq: HW - contention | 44 | 0 | 7 | 157 | 0.00 | 0.14 |
latch: In memory undo latch | 553 | 0 | 6 | 11 | 0.01 | 0.12 |
latch: row cache objects | 349 | 0 | 5 | 15 | 0.01 | 0.11 |
buffer busy waits | 386 | 0 | 5 | 13 | 0.01 | 0.10 |
cursor: pin S | 275 | 0 | 5 | 16 | 0.01 | 0.09 |
latch: enqueue hash chains | 354 | 0 | 4 | 13 | 0.01 | 0.09 |
latch: object queue header operation | 232 | 0 | 3 | 13 | 0.01 | 0.06 |
latch: cache buffers chains | 238 | 0 | 3 | 11 | 0.01 | 0.05 |
Disk file operations I/O | 304 | 0 | 2 | 5 | 0.01 | 0.03 |
rdbms ipc reply | 58 | 0 | 2 | 27 | 0.00 | 0.03 |
db file parallel read | 391 | 0 | 1 | 4 | 0.01 | 0.03 |
control file parallel write | 195 | 0 | 1 | 7 | 0.01 | 0.03 |
Data file init write | 195 | 0 | 1 | 7 | 0.01 | 0.03 |
db file single write | 65 | 0 | 1 | 10 | 0.00 | 0.01 |
SQL*Net break/reset to client | 152 | 0 | 1 | 3 | 0.00 | 0.01 |
reliable message | 131 | 0 | 0 | 4 | 0.00 | 0.01 |
control file sequential read | 2,435 | 0 | 0 | 0 | 0.06 | 0.01 |
latch: cache buffers lru chain | 37 | 0 | 0 | 11 | 0.00 | 0.01 |
latch: shared pool | 25 | 0 | 0 | 15 | 0.00 | 0.01 |
latch: messages | 21 | 0 | 0 | 17 | 0.00 | 0.01 |
latch: undo global data | 32 | 0 | 0 | 8 | 0.00 | 0.00 |
db file scattered read | 65 | 0 | 0 | 4 | 0.00 | 0.00 |
SQL*Net more data to client | 141 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: redo allocation | 4 | 0 | 0 | 42 | 0.00 | 0.00 |
ADR block file read | 44 | 0 | 0 | 4 | 0.00 | 0.00 |
direct path read | 48 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: session allocation | 16 | 0 | 0 | 6 | 0.00 | 0.00 |
enq: US - contention | 8 | 0 | 0 | 10 | 0.00 | 0.00 |
log file switch (private strand flush incomplete) | 3 | 0 | 0 | 22 | 0.00 | 0.00 |
SQL*Net more data from client | 40 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TX - index contention | 3 | 0 | 0 | 13 | 0.00 | 0.00 |
latch: call allocation | 1 | 0 | 0 | 23 | 0.00 | 0.00 |
read by other session | 1 | 0 | 0 | 7 | 0.00 | 0.00 |
buffer deadlock | 2 | 100 | 0 | 3 | 0.00 | 0.00 |
direct path write | 6 | 0 | 0 | 1 | 0.00 | 0.00 |
PL/SQL lock timer | 107,542 | 100 | 16,468 | 153 | 2.76 | |
SQL*Net message from client | 31,226 | 0 | 15,317 | 491 | 0.80 | |
jobq slave wait | 2,106 | 100 | 1,059 | 503 | 0.05 | |
Streams AQ: waiting for messages in the queue | 203 | 100 | 1,011 | 4978 | 0.01 | |
wait for unread message on broadcast channel | 1,015 | 98 | 1,007 | 992 | 0.03 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 36,652 | 0 | 105 | 3 | 0.94 | 27.45 |
db file async I/O submit | 3,658 | 0 | 43 | 12 | 0.09 | 11.36 |
os thread startup | 37 | 0 | 41 | 1107 | 0.00 | 10.73 |
LGWR wait for redo copy | 1,016 | 0 | 8 | 8 | 0.03 | 2.05 |
control file parallel write | 490 | 0 | 7 | 14 | 0.01 | 1.82 |
latch free | 361 | 0 | 6 | 18 | 0.01 | 1.68 |
latch: redo allocation | 284 | 0 | 3 | 10 | 0.01 | 0.77 |
control file sequential read | 1,237 | 0 | 1 | 1 | 0.03 | 0.18 |
latch: cache buffers lru chain | 30 | 0 | 0 | 9 | 0.00 | 0.07 |
latch: object queue header operation | 38 | 0 | 0 | 7 | 0.00 | 0.07 |
db file sequential read | 253 | 0 | 0 | 1 | 0.01 | 0.05 |
latch: cache buffers chains | 5 | 0 | 0 | 33 | 0.00 | 0.04 |
latch: checkpoint queue latch | 5 | 0 | 0 | 33 | 0.00 | 0.04 |
buffer busy waits | 5 | 0 | 0 | 25 | 0.00 | 0.03 |
latch: messages | 16 | 0 | 0 | 5 | 0.00 | 0.02 |
latch: enqueue hash chains | 6 | 0 | 0 | 12 | 0.00 | 0.02 |
asynch descriptor resize | 67 | 100 | 0 | 1 | 0.00 | 0.02 |
Disk file operations I/O | 32 | 0 | 0 | 2 | 0.00 | 0.02 |
Parameter File I/O | 16 | 0 | 0 | 2 | 0.00 | 0.01 |
library cache: mutex X | 1 | 0 | 0 | 30 | 0.00 | 0.01 |
db file single write | 12 | 0 | 0 | 2 | 0.00 | 0.00 |
SQL*Net message to client | 79 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: In memory undo latch | 1 | 0 | 0 | 10 | 0.00 | 0.00 |
latch: shared pool | 2 | 0 | 0 | 4 | 0.00 | 0.00 |
latch: row cache objects | 2 | 0 | 0 | 3 | 0.00 | 0.00 |
latch: session allocation | 1 | 0 | 0 | 5 | 0.00 | 0.00 |
log file single write | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
db file scattered read | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: redo writing | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc message | 41,066 | 12 | 10,838 | 264 | 1.06 | |
Space Manager: slave idle wait | 2,640 | 57 | 9,405 | 3562 | 0.07 | |
DIAG idle wait | 2,014 | 100 | 2,020 | 1003 | 0.05 | |
shared server idle wait | 34 | 100 | 1,020 | 30012 | 0.00 | |
dispatcher timer | 17 | 100 | 1,020 | 60013 | 0.00 | |
smon timer | 80 | 0 | 1,014 | 12673 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 69 | 52 | 1,009 | 14616 | 0.00 | |
Streams AQ: qmn slave idle wait | 37 | 0 | 1,008 | 27251 | 0.00 | |
pmon timer | 337 | 99 | 1,008 | 2992 | 0.01 | |
SGA: MMAN sleep for component shrink | 155 | 99 | 2 | 12 | 0.00 | |
SQL*Net message from client | 105 | 0 | 1 | 11 | 0.00 | |
class slave wait | 4 | 0 | 0 | 5 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 44 | 56.8 | 15.9 | 11.4 | 6.8 | 2.3 | 4.5 | 2.3 | |
Data file init write | 195 | 64.6 | 4.1 | 9.2 | 8.2 | 3.6 | 4.6 | 5.6 | |
Disk file operations I/O | 333 | 52.6 | 14.1 | 12.6 | 7.2 | 6.0 | 4.2 | 3.3 | |
LGWR wait for redo copy | 1015 | 35.4 | 10.5 | 12.3 | 13.5 | 14.6 | 8.4 | 5.3 | |
Parameter File I/O | 16 | 43.8 | 31.3 | 6.3 | 6.3 | 12.5 | |||
SQL*Net break/reset to client | 154 | 63.6 | 6.5 | 9.7 | 7.8 | 8.4 | 1.9 | 1.9 | |
SQL*Net message to client | 31.3K | 97.2 | .6 | .5 | .5 | .6 | .4 | .2 | |
SQL*Net more data from client | 41 | 87.8 | 7.3 | 4.9 | |||||
SQL*Net more data to client | 137 | 92.0 | .7 | 2.9 | 2.9 | 1.5 | |||
asynch descriptor resize | 101 | 96.0 | 1.0 | 2.0 | 1.0 | ||||
buffer busy waits | 395 | 16.7 | 7.3 | 13.2 | 17.5 | 21.3 | 15.2 | 8.9 | |
buffer deadlock | 2 | 50.0 | 50.0 | ||||||
control file parallel write | 685 | 6.0 | 22.0 | 20.9 | 16.5 | 15.8 | 10.1 | 8.8 | |
control file sequential read | 3668 | 98.1 | .7 | .1 | .5 | .3 | .1 | .2 | |
cursor: pin S | 278 | 12.6 | 3.6 | 12.2 | 8.3 | 27.3 | 21.9 | 14.0 | |
db file async I/O submit | 3704 | 42.5 | 18.8 | 10.4 | 8.0 | 6.8 | 4.9 | 8.6 | |
db file parallel read | 356 | 73.0 | 5.6 | 3.9 | 4.5 | 7.6 | 3.7 | 1.7 | |
db file scattered read | 67 | 59.7 | 4.5 | 14.9 | 10.4 | 3.0 | 6.0 | 1.5 | |
db file sequential read | 39.4K | 68.1 | 10.1 | 6.9 | 5.9 | 4.7 | 2.8 | 1.5 | |
db file single write | 77 | 40.3 | 16.9 | 11.7 | 13.0 | 7.8 | 2.6 | 7.8 | |
direct path read | 48 | 64.6 | 8.3 | 16.7 | 6.3 | 4.2 | |||
direct path write | 6 | 66.7 | 16.7 | 16.7 | |||||
enq: HW - contention | 44 | 2.3 | 4.5 | 4.5 | 2.3 | 4.5 | 9.1 | 72.7 | |
enq: TX - index contention | 3 | 33.3 | 33.3 | 33.3 | |||||
enq: US - contention | 8 | 12.5 | 50.0 | 12.5 | 25.0 | ||||
latch free | 3176 | 10.2 | 7.0 | 13.5 | 20.5 | 24.8 | 16.6 | 7.4 | |
latch: In memory undo latch | 549 | 17.7 | 8.2 | 15.1 | 16.9 | 20.4 | 14.2 | 7.5 | |
latch: cache buffers chains | 241 | 16.6 | 9.1 | 14.1 | 18.3 | 14.5 | 19.5 | 7.9 | |
latch: cache buffers lru chain | 64 | 18.8 | 4.7 | 4.7 | 21.9 | 26.6 | 21.9 | 1.6 | |
latch: call allocation | 1 | 100.0 | |||||||
latch: checkpoint queue latch | 5 | 20.0 | 40.0 | 40.0 | |||||
latch: enqueue hash chains | 360 | 10.6 | 6.7 | 15.0 | 18.1 | 21.7 | 18.9 | 9.2 | |
latch: messages | 34 | 8.8 | 17.6 | 17.6 | 20.6 | 26.5 | 5.9 | 2.9 | |
latch: object queue header operation | 269 | 13.4 | 6.3 | 16.0 | 16.4 | 25.7 | 13.0 | 9.3 | |
latch: redo allocation | 285 | 19.6 | 13.7 | 12.3 | 21.1 | 13.3 | 12.6 | 7.4 | |
latch: redo writing | 2 | 100.0 | |||||||
latch: row cache objects | 353 | 8.2 | 5.7 | 11.0 | 20.1 | 20.4 | 23.5 | 11.0 | |
latch: session allocation | 17 | 5.9 | 23.5 | 52.9 | 17.6 | ||||
latch: shared pool | 23 | 34.8 | 8.7 | 21.7 | 13.0 | 13.0 | 4.3 | 4.3 | |
latch: undo global data | 34 | 17.6 | 14.7 | 17.6 | 20.6 | 11.8 | 5.9 | 11.8 | |
library cache: mutex X | 2407 | 7.9 | 3.2 | 7.2 | 11.5 | 26.6 | 26.0 | 17.4 | |
log file parallel write | 36.6K | 35.3 | 34.8 | 15.0 | 8.5 | 4.2 | 1.7 | .6 | |
log file sequential read | 2 | 100.0 | |||||||
log file single write | 2 | 100.0 | |||||||
log file switch (private strand flush incomplete) | 3 | 33.3 | 66.7 | ||||||
log file sync | 4439 | 24.2 | 16.1 | 15.8 | 15.7 | 13.8 | 9.1 | 5.3 | |
os thread startup | 36 | 61.1 | 38.9 | ||||||
rdbms ipc reply | 58 | 10.3 | 1.7 | 20.7 | 19.0 | 17.2 | 13.8 | 17.2 | |
read by other session | 1 | 100.0 | |||||||
reliable message | 131 | 22.9 | 22.9 | 30.5 | 13.0 | 7.6 | 3.1 | ||
DIAG idle wait | 2014 | 100.0 | |||||||
PL/SQL lock timer | 107.5K | 100.0 | |||||||
SGA: MMAN sleep for component shrink | 155 | .6 | 92.9 | 5.8 | .6 | ||||
SQL*Net message from client | 31.3K | 3.5 | 1.7 | 1.5 | 1.5 | 1.2 | .8 | 88.3 | 1.3 |
Space Manager: slave idle wait | 2638 | .4 | .5 | 1.4 | 2.1 | 2.1 | 2.4 | 11.0 | 80.1 |
Streams AQ: qmn coordinator idle wait | 71 | 5.6 | 8.5 | 18.3 | 4.2 | 5.6 | 4.2 | 1.4 | 52.1 |
Streams AQ: qmn slave idle wait | 38 | 2.6 | 97.4 | ||||||
Streams AQ: waiting for messages in the queue | 202 | .5 | 99.5 | ||||||
class slave wait | 4 | 25.0 | 50.0 | 25.0 | |||||
dispatcher timer | 17 | 100.0 | |||||||
jobq slave wait | 2116 | .0 | 100.0 | ||||||
pmon timer | 337 | 100.0 | |||||||
rdbms ipc message | 41K | 10.7 | 4.3 | 6.7 | 10.5 | 14.7 | 18.1 | 28.7 | 6.3 |
shared server idle wait | 34 | 100.0 | |||||||
smon timer | 80 | 1.3 | 1.3 | 10.0 | 87.5 | ||||
wait for unread message on broadcast channel | 1017 | 99.8 | .2 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file read | 1 | 97.7 | 2.3 | ||||||
Data file init write | 11 | 94.4 | 3.6 | 1.5 | .5 | ||||
Disk file operations I/O | 11 | 96.7 | 1.8 | 1.5 | |||||
LGWR wait for redo copy | 54 | 94.7 | 4.4 | .9 | |||||
SQL*Net break/reset to client | 3 | 98.1 | 1.9 | ||||||
SQL*Net message to client | 73 | 99.8 | .2 | .0 | |||||
SQL*Net more data to client | 2 | 98.5 | 1.5 | ||||||
buffer busy waits | 35 | 91.1 | 5.8 | 2.5 | .5 | ||||
control file parallel write | 60 | 91.2 | 5.4 | 2.8 | .6 | ||||
control file sequential read | 7 | 99.8 | .1 | .1 | |||||
cursor: pin S | 39 | 86.0 | 11.9 | 2.2 | |||||
db file async I/O submit | 317 | 91.4 | 4.4 | 2.5 | 1.3 | .4 | .1 | ||
db file parallel read | 6 | 98.3 | 1.4 | .3 | |||||
db file scattered read | 1 | 98.5 | 1.5 | ||||||
db file sequential read | 582 | 98.5 | 1.2 | .2 | .0 | ||||
db file single write | 6 | 92.2 | 3.9 | 3.9 | |||||
enq: HW - contention | 32 | 27.3 | 18.2 | 20.5 | 11.4 | 18.2 | 4.5 | ||
latch free | 236 | 92.6 | 6.5 | .9 | .0 | ||||
latch: In memory undo latch | 41 | 92.5 | 6.6 | .9 | |||||
latch: cache buffers chains | 19 | 92.1 | 6.2 | 1.7 | |||||
latch: cache buffers lru chain | 1 | 98.4 | 1.6 | ||||||
latch: checkpoint queue latch | 2 | 60.0 | 20.0 | 20.0 | |||||
latch: enqueue hash chains | 33 | 90.8 | 8.6 | .6 | |||||
latch: messages | 1 | 97.1 | 2.9 | ||||||
latch: object queue header operation | 25 | 90.7 | 7.8 | 1.5 | |||||
latch: redo allocation | 21 | 92.6 | 6.0 | 1.4 | |||||
latch: row cache objects | 39 | 89.0 | 9.6 | .8 | .6 | ||||
latch: shared pool | 1 | 95.7 | 4.3 | ||||||
latch: undo global data | 4 | 88.2 | 11.8 | ||||||
library cache: mutex X | 419 | 82.6 | 13.8 | 3.6 | |||||
log file parallel write | 228 | 99.4 | .5 | .1 | .0 | ||||
log file sync | 236 | 94.7 | 3.9 | 1.2 | .1 | ||||
os thread startup | 35 | 16.7 | 44.4 | 36.1 | 2.8 | ||||
rdbms ipc reply | 10 | 82.8 | 5.2 | 6.9 | 5.2 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
os thread startup | 1 | 97.2 | 2.8 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
DB11G.WORLD | 4,817 | 1,117 | 39 | 1,678 |
SYS$USERS | 280 | 91 | 5 | 188 |
DB11GXDB | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 0 | 0 | 0 | 9 |
Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
DB11G.WORLD | 38838 | 118 | 4174 | 71 | 0 | 0 | 29699 | 13 |
SYS$USERS | 1874 | 2 | 53 | 1 | 0 | 0 | 1735 | 0 |
SYS$BACKGROUND | 315 | 0 | 53 | 42 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
2,076.23 | 8,022 | 0.26 | 41.18 | 22.12 | 1.09 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
1,281.50 | 9,707 | 0.13 | 25.41 | 25.01 | 0.14 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
843.30 | 23,982 | 0.04 | 16.72 | 17.59 | 0.75 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
485.58 | 4,905 | 0.10 | 9.63 | 17.18 | 17.47 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
339.08 | 3,318 | 0.10 | 6.72 | 17.38 | 1.73 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
334.20 | 8,022 | 0.04 | 6.63 | 18.55 | 4.68 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
329.45 | 29,278 | 0.01 | 6.53 | 18.89 | 0.18 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
173.57 | 22,690 | 0.01 | 3.44 | 16.75 | 1.38 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
158.91 | 4,904 | 0.03 | 3.15 | 13.47 | 44.54 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
129.17 | 4,905 | 0.03 | 2.56 | 16.82 | 10.86 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
127.45 | 1,641 | 0.08 | 2.53 | 21.69 | 0.15 | apgb2g9q2zjh1 | BEGIN :1 := orderentry.browsea... | |
85.05 | 3,318 | 0.03 | 1.69 | 15.39 | 6.39 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
78.35 | 22,689 | 0.00 | 1.55 | 17.67 | 0.00 | 8dq0v1mjngj7t | New Order | SELECT CUSTOMER_ID, CUST_FIRST... |
65.87 | 22,691 | 0.00 | 1.31 | 21.32 | 0.00 | c749bc43qqfz3 | Browse Products | SELECT SYSDATE FROM DUAL |
63.60 | 1 | 63.60 | 1.26 | 34.89 | 0.42 | gg8fha483ayww | Admin Connection | select output from table(dbms_... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
459.30 | 8,022 | 0.06 | 38.25 | 2,076.23 | 22.12 | 1.09 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
320.51 | 9,707 | 0.03 | 26.69 | 1,281.50 | 25.01 | 0.14 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
148.35 | 23,982 | 0.01 | 12.35 | 843.30 | 17.59 | 0.75 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
83.44 | 4,905 | 0.02 | 6.95 | 485.58 | 17.18 | 17.47 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
62.22 | 29,278 | 0.00 | 5.18 | 329.45 | 18.89 | 0.18 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
61.98 | 8,022 | 0.01 | 5.16 | 334.20 | 18.55 | 4.68 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
58.92 | 3,318 | 0.02 | 4.91 | 339.08 | 17.38 | 1.73 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
29.07 | 22,690 | 0.00 | 2.42 | 173.57 | 16.75 | 1.38 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
27.64 | 1,641 | 0.02 | 2.30 | 127.45 | 21.69 | 0.15 | apgb2g9q2zjh1 | BEGIN :1 := orderentry.browsea... | |
22.19 | 1 | 22.19 | 1.85 | 63.60 | 34.89 | 0.42 | gg8fha483ayww | Admin Connection | select output from table(dbms_... |
21.73 | 4,905 | 0.00 | 1.81 | 129.17 | 16.82 | 10.86 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
21.41 | 4,904 | 0.00 | 1.78 | 158.91 | 13.47 | 44.54 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
14.04 | 22,691 | 0.00 | 1.17 | 65.87 | 21.32 | 0.00 | c749bc43qqfz3 | Browse Products | SELECT SYSDATE FROM DUAL |
13.84 | 22,689 | 0.00 | 1.15 | 78.35 | 17.67 | 0.00 | 8dq0v1mjngj7t | New Order | SELECT CUSTOMER_ID, CUST_FIRST... |
13.09 | 3,318 | 0.00 | 1.09 | 85.05 | 15.39 | 6.39 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
84.84 | 4,905 | 0.02 | 71.09 | 485.58 | 17.18 | 17.47 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
70.78 | 4,904 | 0.01 | 59.31 | 158.91 | 13.47 | 44.54 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
22.54 | 8,022 | 0.00 | 18.89 | 2,076.23 | 22.12 | 1.09 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
15.65 | 8,022 | 0.00 | 13.12 | 334.20 | 18.55 | 4.68 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
14.03 | 4,905 | 0.00 | 11.76 | 129.17 | 16.82 | 10.86 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
6.33 | 23,982 | 0.00 | 5.30 | 843.30 | 17.59 | 0.75 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
5.87 | 3,318 | 0.00 | 4.92 | 339.08 | 17.38 | 1.73 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
5.43 | 3,318 | 0.00 | 4.55 | 85.05 | 15.39 | 6.39 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
2.40 | 22,690 | 0.00 | 2.01 | 173.57 | 16.75 | 1.38 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
1.84 | 9,707 | 0.00 | 1.54 | 1,281.50 | 25.01 | 0.14 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
1.48 | 1 | 1.48 | 1.24 | 26.25 | 21.81 | 5.62 | 7dwup5bn902rg | sqlplus@ol6-112.localdomain (TNS V1-V3) | BEGIN DBMS_WORKLOAD_REPOSITORY... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
1,034,752 | 8,022 | 128.99 | 55.32 | 2,076.23 | 22.1 | 1.1 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
649,938 | 23,982 | 27.10 | 34.75 | 843.30 | 17.6 | .8 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
339,216 | 9,707 | 34.95 | 18.13 | 1,281.50 | 25 | .1 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
309,323 | 8,022 | 38.56 | 16.54 | 334.20 | 18.5 | 4.7 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
266,660 | 29,278 | 9.11 | 14.26 | 329.45 | 18.9 | .2 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
149,114 | 4,905 | 30.40 | 7.97 | 485.58 | 17.2 | 17.5 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
96,185 | 3,318 | 28.99 | 5.14 | 339.08 | 17.4 | 1.7 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
79,312 | 22,690 | 3.50 | 4.24 | 173.57 | 16.7 | 1.4 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
78,492 | 4,904 | 16.01 | 4.20 | 158.91 | 13.5 | 44.5 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
72,242 | 1 | 72,242.00 | 3.86 | 63.60 | 34.9 | .4 | gg8fha483ayww | Admin Connection | select output from table(dbms_... |
71,484 | 22,689 | 3.15 | 3.82 | 78.35 | 17.7 | 0 | 8dq0v1mjngj7t | New Order | SELECT CUSTOMER_ID, CUST_FIRST... |
65,701 | 4,905 | 13.39 | 3.51 | 129.17 | 16.8 | 10.9 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
64,507 | 3,318 | 19.44 | 3.45 | 85.05 | 15.4 | 6.4 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
58,975 | 16 | 3,685.94 | 3.15 | 37.53 | 30.7 | .4 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
40,115 | 8,023 | 5.00 | 2.14 | 27.58 | 20.3 | 0 | dwwbq1j9kw64f | select o.name, c.name from con... | |
26,987 | 363 | 74.34 | 1.44 | 8.27 | 34.8 | .2 | f7nhbjdn5rx9a | INSERT INTO MGMT_VIOLATIONS (T... | |
25,443 | 1 | 25,443.00 | 1.36 | 26.25 | 21.8 | 5.6 | 7dwup5bn902rg | sqlplus@ol6-112.localdomain (TNS V1-V3) | BEGIN DBMS_WORKLOAD_REPOSITORY... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
20,926 | 4,905 | 4.27 | 48.02 | 485.58 | 17.18 | 17.47 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
18,122 | 4,904 | 3.70 | 41.58 | 158.91 | 13.47 | 44.54 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
13,930 | 8,022 | 1.74 | 31.96 | 2,076.23 | 22.12 | 1.09 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
7,984 | 8,022 | 1.00 | 18.32 | 334.20 | 18.55 | 4.68 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
5,919 | 23,982 | 0.25 | 13.58 | 843.30 | 17.59 | 0.75 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
2,978 | 1 | 2,978.00 | 6.83 | 0.89 | 33.86 | 15.58 | ab7ktcdksu27j | emagent_SQL_oracle_database | /* OracleOEM */ SELECT /*+ IND... |
2,813 | 3,318 | 0.85 | 6.45 | 339.08 | 17.38 | 1.73 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
2,807 | 3,318 | 0.85 | 6.44 | 85.05 | 15.39 | 6.39 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
2,799 | 4,905 | 0.57 | 6.42 | 129.17 | 16.82 | 10.86 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
804 | 1 | 804.00 | 1.84 | 26.25 | 21.81 | 5.62 | 7dwup5bn902rg | sqlplus@ol6-112.localdomain (TNS V1-V3) | BEGIN DBMS_WORKLOAD_REPOSITORY... |
597 | 197 | 3.03 | 1.37 | 0.86 | 25.56 | 27.02 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_id... | |
445 | 1 | 445.00 | 1.02 | 63.60 | 34.89 | 0.42 | gg8fha483ayww | Admin Connection | select output from table(dbms_... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
21,124 | 21,124 | 4,905 | 4.31 | 0.00 | 52.24 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
18,122 | 18,122 | 4,904 | 3.70 | 0.00 | 44.82 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
14,480 | 14,480 | 8,022 | 1.81 | 0.00 | 35.81 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
8,314 | 8,314 | 8,022 | 1.04 | 0.00 | 20.56 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
5,919 | 5,919 | 23,982 | 0.25 | 0.00 | 14.64 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
3,077 | 3,077 | 3,318 | 0.93 | 0.00 | 7.61 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
2,997 | 2,997 | 4,905 | 0.61 | 0.00 | 7.41 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
2,917 | 2,917 | 3,318 | 0.88 | 0.00 | 7.21 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
936 | 936 | 1 | 936.00 | 0.00 | 2.31 | 7dwup5bn902rg | sqlplus@ol6-112.localdomain (TNS V1-V3) | BEGIN DBMS_WORKLOAD_REPOSITORY... |
892 | 892 | 1 | 892.00 | 0.00 | 2.21 | gg8fha483ayww | Admin Connection | select output from table(dbms_... |
883 | 883 | 22,690 | 0.04 | 0.00 | 2.18 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
612 | 612 | 9,707 | 0.06 | 0.00 | 1.51 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
597 | 597 | 197 | 3.03 | 0.00 | 1.48 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_id... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
29,278 | 409,892 | 14.00 | 329.45 | 18.9 | .2 | 0y1prvxqc2ra9 | Browse Products | SELECT PRODUCTS.PRODUCT_ID, PR... |
23,982 | 108,591 | 4.53 | 843.30 | 17.6 | .8 | c13sma6rkr27c | New Order | SELECT PRODUCTS.PRODUCT_ID, PR... |
22,691 | 22,691 | 1.00 | 65.87 | 21.3 | 0 | c749bc43qqfz3 | Browse Products | SELECT SYSDATE FROM DUAL |
22,690 | 22,690 | 1.00 | 173.57 | 16.7 | 1.4 | 5raw2bzx227wp | Browse Products | INSERT INTO LOGON VALUES (:B2 ... |
22,689 | 3,318 | 0.15 | 78.35 | 17.7 | 0 | 8dq0v1mjngj7t | New Order | SELECT CUSTOMER_ID, CUST_FIRST... |
9,707 | 9,707 | 1.00 | 1,281.50 | 25 | .1 | 147a57cxq3w5y | JDBC Thin Client | BEGIN :1 := orderentry.browsep... |
8,023 | 8,023 | 1.00 | 27.58 | 20.3 | 0 | dwwbq1j9kw64f | select o.name, c.name from con... | |
8,022 | 8,022 | 1.00 | 2,076.23 | 22.1 | 1.1 | 0w2qpuc6u2zsp | JDBC Thin Client | BEGIN :1 := orderentry.neworde... |
8,022 | 0 | 0.00 | 334.20 | 18.5 | 4.7 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
4,905 | 4,905 | 1.00 | 485.58 | 17.2 | 17.5 | a9gvfh5hx9u98 | JDBC Thin Client | BEGIN :1 := orderentry.process... |
4,905 | 4,905 | 1.00 | 129.17 | 16.8 | 10.9 | f9u2k84v884y7 | Process Orders | UPDATE /*+ index(orders, order... |
4,904 | 4,904 | 1.00 | 158.91 | 13.5 | 44.5 | 7hk2m2702ua0g | Process Orders | WITH NEED_TO_PROCESS AS (SELEC... |
3,319 | 3,319 | 1.00 | 7.62 | 17.1 | 0 | 4z3ktqk9zq1j9 | New Customer | SELECT CUSTOMER_SEQ.NEXTVAL FR... |
3,318 | 3,318 | 1.00 | 85.05 | 15.4 | 6.4 | 0bzhqhhj9mpaa | New Customer | INSERT INTO CUSTOMERS(CUSTOMER... |
3,318 | 3,318 | 1.00 | 339.08 | 17.4 | 1.7 | dcq9a12vtcnuw | JDBC Thin Client | BEGIN :1 := orderentry.newcust... |
3,088 | 2,114 | 0.68 | 2.33 | 18.5 | 1.9 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
8,022 | 8,022 | 64.01 | bymb3ujkr3ubk | New Order | INSERT INTO ORDERS(ORDER_ID, O... |
398 | 398 | 3.18 | b2gnxm5z6r51n | lock table sys.col_usage$ in e... | |
369 | 372 | 2.94 | a1j6tn192jgfq | SELECT KEY_PART1_VALUE, KEY_PA... | |
125 | 125 | 1.00 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
42 | 42 | 0.34 | 0k8522rmdzg4k | select privilege# from sysauth... | |
42 | 962 | 0.34 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
31 | 62 | 0.25 | 08bqjmf8490s2 | sqlplus@ol6-112.localdomain (TNS V1-V3) | SELECT PARAMETER_VALUE FROM MG... |
31 | 306 | 0.25 | 3ktacv9r56b51 | select owner#, name, namespace... | |
31 | 306 | 0.25 | 8swypbbr0m372 | select order#, columns, types ... | |
29 | 831 | 0.23 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
1,399,116 | 1 | 0.65 | 53pkuyc2acm21 | emagent_SQL_oracle_database | /* OracleOEM */ SELECT * FROM ... |
1,336,327 | 1 | 0.62 | ab7ktcdksu27j | emagent_SQL_oracle_database | /* OracleOEM */ SELECT /*+ IND... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 11 | 0.01 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 1,416 | 1.39 | 0.04 |
Batched IO buffer defrag count | 2 | 0.00 | 0.00 |
Batched IO double miss count | 681 | 0.67 | 0.02 |
Batched IO same unit count | 26 | 0.03 | 0.00 |
Batched IO single block count | 324 | 0.32 | 0.01 |
Batched IO vector block count | 1,065 | 1.04 | 0.03 |
Batched IO vector read count | 368 | 0.36 | 0.01 |
Block Cleanout Optim referenced | 38 | 0.04 | 0.00 |
CCursor + sql area evicted | 21 | 0.02 | 0.00 |
CPU used by this session | 113,225 | 111.05 | 2.91 |
CPU used when call started | 110,031 | 107.91 | 2.83 |
CR blocks created | 335 | 0.33 | 0.01 |
Cached Commit SCN referenced | 0 | 0.00 | 0.00 |
Commit SCN cached | 61 | 0.06 | 0.00 |
DB time | 2,439,176 | 2,392.22 | 62.70 |
DBWR checkpoint buffers written | 5,667 | 5.56 | 0.15 |
DBWR checkpoints | 1 | 0.00 | 0.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 41 | 0.04 | 0.00 |
DBWR undo block writes | 7,077 | 6.94 | 0.18 |
HSC Compressed Segment Block Changes | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 47,362 | 46.45 | 1.22 |
HSC OLTP Compressed Blocks | 0 | 0.00 | 0.00 |
HSC OLTP Non Compressible Blocks | 0 | 0.00 | 0.00 |
HSC OLTP Space Saving | 0 | 0.00 | 0.00 |
HSC OLTP inline compression | 0 | 0.00 | 0.00 |
HSC OLTP positive compression | 0 | 0.00 | 0.00 |
HSC OLTP recursive compression | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 155 | 0.15 | 0.00 |
Heap Segment Array Updates | 82 | 0.08 | 0.00 |
IMU CR rollbacks | 121 | 0.12 | 0.00 |
IMU Flushes | 9,656 | 9.47 | 0.25 |
IMU Redo allocation size | 22,900,772 | 22,459.93 | 588.65 |
IMU commits | 29,409 | 28.84 | 0.76 |
IMU contention | 2,007 | 1.97 | 0.05 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 133 | 0.13 | 0.00 |
IMU recursive-transaction flush | 1 | 0.00 | 0.00 |
IMU undo allocation size | 51,577,368 | 50,584.50 | 1,325.76 |
IMU- failed to get a private strand | 133 | 0.13 | 0.00 |
Number of read IOs issued | 48 | 0.05 | 0.00 |
Requests to/from client | 31,142 | 30.54 | 0.80 |
RowCR - row contention | 80 | 0.08 | 0.00 |
RowCR attempts | 671 | 0.66 | 0.02 |
RowCR hits | 1,322 | 1.30 | 0.03 |
SQL*Net roundtrips to/from client | 31,143 | 30.54 | 0.80 |
TBS Extension: tasks created | 65 | 0.06 | 0.00 |
active txn count during cleanout | 563 | 0.55 | 0.01 |
application wait time | 51 | 0.05 | 0.00 |
auto extends on undo tablespace | 65 | 0.06 | 0.00 |
background checkpoints completed | 2 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 4,853 | 4.76 | 0.12 |
branch node splits | 17 | 0.02 | 0.00 |
buffer is not pinned count | 882,537 | 865.55 | 22.68 |
buffer is pinned count | 1,088,286 | 1,067.34 | 27.97 |
bytes received via SQL*Net from client | 6,248,733 | 6,128.44 | 160.62 |
bytes sent via SQL*Net to client | 3,371,457 | 3,306.56 | 86.66 |
calls to get snapshot scn: kcmgss | 231,481 | 227.02 | 5.95 |
calls to kcmgas | 42,719 | 41.90 | 1.10 |
calls to kcmgcs | 14,106 | 13.83 | 0.36 |
cell physical IO interconnect bytes | 795,680,256 | 780,363.29 | 20,452.40 |
change write time | 16,458 | 16.14 | 0.42 |
cleanout - number of ktugct calls | 676 | 0.66 | 0.02 |
cleanouts and rollbacks - consistent read gets | 197 | 0.19 | 0.01 |
cleanouts only - consistent read gets | 113 | 0.11 | 0.00 |
cluster key scan block gets | 17,144 | 16.81 | 0.44 |
cluster key scans | 16,099 | 15.79 | 0.41 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 7,953 | 7.80 | 0.20 |
commit batch/immediate requested | 7,953 | 7.80 | 0.20 |
commit cleanout failures: block lost | 1 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 25 | 0.02 | 0.00 |
commit cleanout failures: cannot pin | 155 | 0.15 | 0.00 |
commit cleanouts | 59,936 | 58.78 | 1.54 |
commit cleanouts successfully completed | 59,755 | 58.60 | 1.54 |
commit immediate performed | 7,953 | 7.80 | 0.20 |
commit immediate requested | 7,953 | 7.80 | 0.20 |
commit txn count during cleanout | 525 | 0.51 | 0.01 |
concurrency wait time | 10,731 | 10.52 | 0.28 |
consistent changes | 20,442 | 20.05 | 0.53 |
consistent gets | 1,299,649 | 1,274.63 | 33.41 |
consistent gets - examination | 838,967 | 822.82 | 21.57 |
consistent gets direct | 2,857 | 2.80 | 0.07 |
consistent gets from cache | 1,296,792 | 1,271.83 | 33.33 |
consistent gets from cache (fastpath) | 439,589 | 431.13 | 11.30 |
cursor authentications | 275 | 0.27 | 0.01 |
data blocks consistent reads - undo records applied | 259 | 0.25 | 0.01 |
db block changes | 418,524 | 410.47 | 10.76 |
db block gets | 570,878 | 559.89 | 14.67 |
db block gets direct | 26 | 0.03 | 0.00 |
db block gets from cache | 570,852 | 559.86 | 14.67 |
db block gets from cache (fastpath) | 138,240 | 135.58 | 3.55 |
deferred (CURRENT) block cleanout applications | 14,739 | 14.46 | 0.38 |
dirty buffers inspected | 4,925 | 4.83 | 0.13 |
enqueue conversions | 3,673 | 3.60 | 0.09 |
enqueue releases | 121,791 | 119.45 | 3.13 |
enqueue requests | 121,788 | 119.44 | 3.13 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 55 | 0.05 | 0.00 |
exchange deadlocks | 2 | 0.00 | 0.00 |
execute count | 220,230 | 215.99 | 5.66 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 186 | 0.18 | 0.00 |
file io wait time | 154,018,413 | 151,053.53 | 3,958.94 |
free buffer inspected | 55,743 | 54.67 | 1.43 |
free buffer requested | 55,068 | 54.01 | 1.42 |
heap block compress | 145 | 0.14 | 0.00 |
hot buffers moved to head of LRU | 36,606 | 35.90 | 0.94 |
immediate (CR) block cleanout applications | 310 | 0.30 | 0.01 |
immediate (CURRENT) block cleanout applications | 5,742 | 5.63 | 0.15 |
in call idle wait time | 4,562,418 | 4,474.59 | 117.27 |
index crx upgrade (positioned) | 1,535 | 1.51 | 0.04 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 1 | 0.00 | 0.00 |
index fetch by key | 255,186 | 250.27 | 6.56 |
index scans kdiixs1 | 101,180 | 99.23 | 2.60 |
leaf node 90-10 splits | 14 | 0.01 | 0.00 |
leaf node splits | 153 | 0.15 | 0.00 |
lob reads | 5,252 | 5.15 | 0.13 |
lob writes | 5,121 | 5.02 | 0.13 |
lob writes unaligned | 5,121 | 5.02 | 0.13 |
logical read bytes from cache | 15,299,731,456 | 15,005,209.21 | 393,268.85 |
logons cumulative | 80 | 0.08 | 0.00 |
max cf enq hold time | 1,500 | 1.47 | 0.04 |
messages received | 40,544 | 39.76 | 1.04 |
messages sent | 40,544 | 39.76 | 1.04 |
min active SCN optimization applied on CR | 7,966 | 7.81 | 0.20 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 433,810 | 425.46 | 11.15 |
non-idle wait count | 139,680 | 136.99 | 3.59 |
non-idle wait time | 50,035 | 49.07 | 1.29 |
opened cursors cumulative | 255,412 | 250.50 | 6.57 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 1,028 | 1.01 | 0.03 |
parse count (total) | 12,532 | 12.29 | 0.32 |
parse time cpu | 3,630 | 3.56 | 0.09 |
parse time elapsed | 15,263 | 14.97 | 0.39 |
physical read IO requests | 40,433 | 39.65 | 1.04 |
physical read bytes | 357,015,552 | 350,142.95 | 9,176.83 |
physical read total IO requests | 44,263 | 43.41 | 1.14 |
physical read total bytes | 418,335,744 | 410,282.71 | 10,753.03 |
physical read total multi block requests | 27 | 0.03 | 0.00 |
physical reads | 43,581 | 42.74 | 1.12 |
physical reads cache | 40,724 | 39.94 | 1.05 |
physical reads cache prefetch | 1,037 | 1.02 | 0.03 |
physical reads direct | 2,857 | 2.80 | 0.07 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 8,144 | 7.99 | 0.21 |
physical write bytes | 221,708,288 | 217,440.37 | 5,698.86 |
physical write total IO requests | 46,784 | 45.88 | 1.20 |
physical write total bytes | 377,344,512 | 370,080.57 | 9,699.38 |
physical write total multi block requests | 732 | 0.72 | 0.02 |
physical writes | 27,064 | 26.54 | 0.70 |
physical writes direct | 26 | 0.03 | 0.00 |
physical writes direct (lob) | 4 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 27,038 | 26.52 | 0.69 |
physical writes non checkpoint | 23,608 | 23.15 | 0.61 |
pinned buffers inspected | 2 | 0.00 | 0.00 |
prefetch clients - default | 4 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
process last non-idle time | 339 | 0.33 | 0.01 |
recursive calls | 474,814 | 465.67 | 12.20 |
recursive cpu usage | 56,428 | 55.34 | 1.45 |
redo blocks checksummed by FG (exclusive) | 26,000 | 25.50 | 0.67 |
redo blocks written | 125,889 | 123.47 | 3.24 |
redo buffer allocation retries | 3 | 0.00 | 0.00 |
redo entries | 121,123 | 118.79 | 3.11 |
redo log space requests | 3 | 0.00 | 0.00 |
redo log space wait time | 6 | 0.01 | 0.00 |
redo ordering marks | 1,924 | 1.89 | 0.05 |
redo size | 49,347,332 | 48,397.39 | 1,268.44 |
redo size for direct writes | 356 | 0.35 | 0.01 |
redo subscn max counts | 4,069 | 3.99 | 0.10 |
redo synch long waits | 574 | 0.56 | 0.01 |
redo synch time | 4,515 | 4.43 | 0.12 |
redo synch time (usec) | 45,121,574 | 44,252.98 | 1,159.82 |
redo synch writes | 27,556 | 27.03 | 0.71 |
redo wastage | 13,045,352 | 12,794.23 | 335.32 |
redo write time | 11,164 | 10.95 | 0.29 |
redo writes | 36,521 | 35.82 | 0.94 |
rollback changes - undo records applied | 39,769 | 39.00 | 1.02 |
rollbacks only - consistent read gets | 27 | 0.03 | 0.00 |
rows fetched via callback | 166,700 | 163.49 | 4.28 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 244,320 | 239.62 | 6.28 |
session logical reads | 1,870,525 | 1,834.52 | 48.08 |
shared hash latch upgrades - no wait | 27,503 | 26.97 | 0.71 |
shared hash latch upgrades - wait | 3 | 0.00 | 0.00 |
sorts (memory) | 10,221 | 10.02 | 0.26 |
sorts (rows) | 77,094 | 75.61 | 1.98 |
sql area evicted | 884 | 0.87 | 0.02 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 6,887 | 6.75 | 0.18 |
switch current to new buffer | 149 | 0.15 | 0.00 |
table fetch by rowid | 801,308 | 785.88 | 20.60 |
table fetch continued row | 693 | 0.68 | 0.02 |
table scan blocks gotten | 15,747 | 15.44 | 0.40 |
table scan rows gotten | 273,546 | 268.28 | 7.03 |
table scans (direct read) | 2 | 0.00 | 0.00 |
table scans (long tables) | 1 | 0.00 | 0.00 |
table scans (short tables) | 2,859 | 2.80 | 0.07 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 4,730 | 4.64 | 0.12 |
total number of cf enq holders | 311 | 0.31 | 0.01 |
total number of times SMON posted | 80 | 0.08 | 0.00 |
transaction rollbacks | 7,950 | 7.80 | 0.20 |
undo change vector size | 13,920,424 | 13,652.45 | 357.81 |
user I/O wait time | 11,748 | 11.52 | 0.30 |
user calls | 59,546 | 58.40 | 1.53 |
user commits | 30,955 | 30.36 | 0.80 |
user rollbacks | 7,949 | 7.80 | 0.20 |
workarea executions - optimal | 15,808 | 15.50 | 0.41 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 13 | 0.01 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 500,954,688 | 656,198,896 |
session cursor cache count | 4,989 | 5,953 |
session uga memory | 116,054,432,240 | 193,368,268,080 |
opened cursors current | 239 | 230 |
logons current | 72 | 71 |
session uga memory max | 455,386,664 | 538,780,248 |
session pga memory | 259,731,040 | 314,918,832 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 1 | 3.53 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 317M | 39.44 | .310897 | 0M | 0.00 | 0M | 39.9K | 3.43 |
DBWR | 5M | 0.32 | .004903 | 214M | 8.05 | .209880 | 4044 | 10.11 |
Others | 53M | 3.41 | .051979 | 87M | 1.53 | .085325 | 5034 | 3.98 |
LGWR | 0M | 0.02 | 0M | 61M | 36.46 | .059825 | 73.3K | 2.32 |
Direct Reads | 22M | 0.05 | .021576 | 0M | 0.00 | 0M | 48 | 2.04 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 6 | 0.50 |
TOTAL: | 397M | 43.24 | .389357 | 362M | 46.05 | .355031 | 122.3K | 3.01 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 340M | 39.64 | .333454 | 214M | 8.13 | .209880 | 3.38 | 3.41 |
Control File | 57M | 3.59 | .055902 | 22M | 1.33 | .021576 | 0.51 | |
Log File | 0M | 0.00 | 0M | 61M | 36.45 | .059825 | 0.00 | |
Temp File | 0M | 0.00 | 0M | 1M | 0.00 | .000980 | ||
Other | 0M | 0.01 | 0M | 0M | 0.01 | 0M | 0.00 | |
TOTAL: | 397M | 43.24 | .389357 | 298M | 45.93 | .292263 | 3.14 | 3.41 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 317M | 39.46 | .310897 | 0M | 0.00 | 0M | 39.2K | 3.45 |
Buffer Cache Reads (Data File) | 317M | 39.46 | .310897 | 0M | 0.00 | 0M | 39.2K | 3.45 |
DBWR | 5M | 0.32 | .004903 | 214M | 8.05 | .209880 | 325 | 0.45 |
DBWR (Data File) | 0M | 0.00 | 0M | 214M | 8.05 | .209880 | 0 | |
DBWR (Control File) | 5M | 0.32 | .004903 | 0M | 0.00 | 0M | 325 | 0.45 |
Others | 53M | 3.40 | .051979 | 87M | 1.52 | .085325 | 3542 | 0.71 |
Others (Control File) | 52M | 3.25 | .050998 | 21M | 1.32 | .020595 | 3314 | 0.51 |
Others (Data File) | 1M | 0.15 | .000980 | 66M | 0.20 | .064729 | 228 | 3.56 |
LGWR | 0M | 0.02 | 0M | 61M | 36.49 | .059825 | 24 | 0.54 |
LGWR (Log File) | 0M | 0.00 | 0M | 61M | 36.47 | .059825 | 4 | 1.00 |
LGWR (Control File) | 0M | 0.02 | 0M | 0M | 0.02 | 0M | 20 | 0.45 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 0 | |
TOTAL: | 375M | 43.20 | .367781 | 362M | 46.07 | .355031 | 43.1K | 3.20 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SOE | 38,855 | 38 | 2.90 | 1.00 | 7,191 | 7 | 307 | 13.00 |
SYSTEM | 1,328 | 1 | 0.77 | 3.35 | 67 | 0 | 2 | 40.00 |
SYSAUX | 847 | 1 | 0.89 | 1.02 | 467 | 0 | 0 | 0.00 |
UNDOTBS1 | 0 | 0 | 0.00 | 0.00 | 514 | 1 | 95 | 12.53 |
EXAMPLE | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
EXAMPLE | /u01/app/oracle/oradata/DB11G/example01.dbf | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SOE | /u01/app/oracle/product/11.2.0/db_1/dbs/soe.dbf | 38,855 | 38 | 2.90 | 1.00 | 7,191 | 7 | 307 | 13.00 |
SYSAUX | /u01/app/oracle/oradata/DB11G/sysaux01.dbf | 847 | 1 | 0.89 | 1.02 | 467 | 0 | 0 | 0.00 |
SYSTEM | /u01/app/oracle/oradata/DB11G/system01.dbf | 1,328 | 1 | 0.77 | 3.35 | 67 | 0 | 2 | 40.00 |
UNDOTBS1 | /u01/app/oracle/oradata/DB11G/undotbs01.dbf | 0 | 0 | 514 | 1 | 95 | 12.53 | ||
USERS | /u01/app/oracle/oradata/DB11G/users01.dbf | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 45,663 | 98 | 1,868,955 | 40,850 | 26,949 | 0 | 0 | 401 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 5,667 | 0 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
---|---|---|---|---|---|---|---|---|---|---|
B | 0 | 14 | 1906 | 14283 | 165888 | 165888 | 407090 | |||
E | 0 | 17 | 5768 | 36993 | 165883 | 165888 | 165883 |
P | Size for Est (M) | Size Factor | Buffers (thousands) | Est Phys Read Factor | Estimated Phys Reads (thousands) | Est Phys Read Time | Est %DBtime for Rds |
---|---|---|---|---|---|---|---|
D | 36 | 0.10 | 4 | 2.76 | 382 | 1 | 744.00 |
D | 72 | 0.19 | 9 | 2.12 | 292 | 1 | 541.00 |
D | 108 | 0.29 | 13 | 1.72 | 238 | 1 | 417.00 |
D | 144 | 0.39 | 18 | 1.49 | 205 | 1 | 342.00 |
D | 180 | 0.48 | 22 | 1.33 | 184 | 1 | 294.00 |
D | 216 | 0.58 | 27 | 1.23 | 170 | 1 | 263.00 |
D | 252 | 0.68 | 31 | 1.16 | 160 | 1 | 240.00 |
D | 288 | 0.77 | 35 | 1.09 | 150 | 1 | 218.00 |
D | 324 | 0.87 | 40 | 1.04 | 144 | 1 | 203.00 |
D | 360 | 0.97 | 44 | 1.01 | 139 | 1 | 193.00 |
D | 372 | 1.00 | 46 | 1.00 | 138 | 1 | 190.00 |
D | 396 | 1.06 | 49 | 0.98 | 135 | 1 | 184.00 |
D | 432 | 1.16 | 53 | 0.97 | 134 | 1 | 180.00 |
D | 468 | 1.26 | 57 | 0.96 | 133 | 1 | 178.00 |
D | 504 | 1.35 | 62 | 0.95 | 132 | 1 | 175.00 |
D | 540 | 1.45 | 66 | 0.95 | 131 | 1 | 174.00 |
D | 576 | 1.55 | 71 | 0.94 | 130 | 1 | 173.00 |
D | 612 | 1.65 | 75 | 0.94 | 130 | 1 | 172.00 |
D | 648 | 1.74 | 80 | 0.94 | 130 | 1 | 172.00 |
D | 684 | 1.84 | 84 | 0.94 | 130 | 1 | 172.00 |
D | 720 | 1.94 | 88 | 0.94 | 130 | 1 | 172.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 7,653 | 0 |
PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
---|---|---|---|---|---|---|---|---|
B | 200 | 63 | 188.50 | 0.00 | 0.00 | 0.00 | 0.00 | 40,960 |
E | 200 | 57 | 183.94 | 0.83 | 0.45 | 100.00 | 0.00 | 40,960 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 5,021 | 5,021 | 0 | 0 |
64K | 128K | 14 | 14 | 0 | 0 |
128K | 256K | 38 | 38 | 0 | 0 |
256K | 512K | 4 | 4 | 0 | 0 |
512K | 1024K | 10,740 | 10,740 | 0 | 0 |
1M | 2M | 6 | 6 | 0 | 0 |
4M | 8M | 2 | 2 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time |
---|---|---|---|---|---|---|
25 | 0.13 | 9,757.59 | 633.61 | 94.00 | 176 | 1,649,241 |
50 | 0.25 | 9,757.59 | 628.22 | 94.00 | 146 | 1,648,385 |
100 | 0.50 | 9,757.59 | 566.49 | 95.00 | 134 | 1,638,588 |
150 | 0.75 | 9,757.59 | 22.63 | 100.00 | 8 | 1,552,269 |
200 | 1.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
240 | 1.20 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
280 | 1.40 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
320 | 1.60 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
360 | 1.80 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
400 | 2.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
600 | 3.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
800 | 4.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
1,200 | 6.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
1,600 | 8.00 | 9,757.59 | 0.00 | 100.00 | 0 | 1,548,677 |
Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits (K) |
---|---|---|---|---|---|---|---|---|
156 | 0.76 | 2 | 518 | 61,488 | 0.48 | 67,081 | 101.79 | 1,751 |
164 | 0.80 | 10 | 948 | 73,375 | 0.57 | 55,194 | 83.75 | 1,905 |
168 | 0.82 | 13 | 1,150 | 79,107 | 0.62 | 49,462 | 75.06 | 1,962 |
172 | 0.84 | 16 | 1,295 | 84,805 | 0.66 | 43,764 | 66.41 | 1,990 |
176 | 0.86 | 20 | 1,460 | 90,353 | 0.71 | 38,216 | 57.99 | 2,017 |
180 | 0.88 | 24 | 1,596 | 96,021 | 0.75 | 32,548 | 49.39 | 2,037 |
184 | 0.90 | 28 | 1,624 | 101,365 | 0.79 | 27,204 | 41.28 | 2,054 |
188 | 0.92 | 32 | 1,647 | 106,994 | 0.84 | 21,575 | 32.74 | 2,072 |
192 | 0.94 | 36 | 1,665 | 112,422 | 0.88 | 16,147 | 24.50 | 2,088 |
196 | 0.96 | 39 | 1,781 | 117,951 | 0.92 | 10,618 | 16.11 | 2,105 |
200 | 0.98 | 43 | 1,941 | 122,857 | 0.96 | 5,712 | 8.67 | 2,119 |
204 | 1.00 | 47 | 2,115 | 127,910 | 1.00 | 659 | 1.00 | 2,134 |
208 | 1.02 | 51 | 2,302 | 127,925 | 1.00 | 644 | 0.98 | 2,135 |
212 | 1.04 | 54 | 2,545 | 127,929 | 1.00 | 640 | 0.97 | 2,135 |
216 | 1.06 | 57 | 2,760 | 127,930 | 1.00 | 639 | 0.97 | 2,135 |
220 | 1.08 | 61 | 2,859 | 127,930 | 1.00 | 639 | 0.97 | 2,136 |
224 | 1.10 | 65 | 2,988 | 127,931 | 1.00 | 638 | 0.97 | 2,136 |
228 | 1.12 | 68 | 3,294 | 127,933 | 1.00 | 636 | 0.97 | 2,136 |
232 | 1.14 | 72 | 3,531 | 127,942 | 1.00 | 627 | 0.95 | 2,137 |
236 | 1.16 | 73 | 3,635 | 127,943 | 1.00 | 626 | 0.95 | 2,137 |
240 | 1.18 | 78 | 3,921 | 127,943 | 1.00 | 626 | 0.95 | 2,137 |
252 | 1.24 | 89 | 4,621 | 127,945 | 1.00 | 624 | 0.95 | 2,137 |
276 | 1.35 | 113 | 5,558 | 127,948 | 1.00 | 621 | 0.94 | 2,138 |
300 | 1.47 | 137 | 6,702 | 127,950 | 1.00 | 619 | 0.94 | 2,139 |
324 | 1.59 | 161 | 7,781 | 127,951 | 1.00 | 618 | 0.94 | 2,139 |
348 | 1.71 | 185 | 8,963 | 127,952 | 1.00 | 617 | 0.94 | 2,139 |
372 | 1.82 | 209 | 10,198 | 127,952 | 1.00 | 617 | 0.94 | 2,139 |
396 | 1.94 | 233 | 11,562 | 127,952 | 1.00 | 617 | 0.94 | 2,139 |
420 | 2.06 | 257 | 13,469 | 127,952 | 1.00 | 617 | 0.94 | 2,140 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
300 | 0.50 | 7,643 | 289,991 |
450 | 0.75 | 7,360 | 168,817 |
600 | 1.00 | 7,273 | 138,137 |
750 | 1.25 | 7,259 | 131,410 |
900 | 1.50 | 7,251 | 129,241 |
1,050 | 1.75 | 7,265 | 128,923 |
1,200 | 2.00 | 7,271 | 128,827 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
4 | 1.00 | 0 | 0 | 0 | 0 |
8 | 2.00 | 0 | 0 | 0 | 0 |
12 | 3.00 | 0 | 0 | 0 | 0 |
16 | 4.00 | 0 | 0 | 0 | 0 |
20 | 5.00 | 0 | 0 | 0 | 0 |
24 | 6.00 | 0 | 0 | 0 | 0 |
28 | 7.00 | 0 | 0 | 0 | 0 |
32 | 8.00 | 0 | 0 | 0 | 0 |
36 | 9.00 | 0 | 0 | 0 | 0 |
40 | 10.00 | 0 | 0 | 0 | 0 |
44 | 11.00 | 0 | 0 | 0 | 0 |
48 | 12.00 | 0 | 0 | 0 | 0 |
52 | 13.00 | 0 | 0 | 0 | 0 |
56 | 14.00 | 0 | 0 | 0 | 0 |
60 | 15.00 | 0 | 0 | 0 | 0 |
64 | 16.00 | 0 | 0 | 0 | 0 |
68 | 17.00 | 0 | 0 | 0 | 0 |
72 | 18.00 | 0 | 0 | 0 | 0 |
76 | 19.00 | 0 | 0 | 0 | 0 |
80 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 307 | 4 | 13 |
undo header | 74 | 1 | 11 |
file header block | 8 | 0 | 45 |
undo block | 13 | 0 | 3 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
HW-Segment High Water Mark | 5,710 | 5,710 | 0 | 44 | 7 | 160.45 |
US-Undo Segment | 2,428 | 2,428 | 0 | 8 | 0 | 13.75 |
TX-Transaction (index contention) | 45 | 45 | 0 | 3 | 0 | 20.00 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
2 | 8.39 | 41,108 | 2,761 | 9 | 49.9/60.1 | 0/0 | 0/0/0/636/72704/0 |
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
07-Oct 21:08 | 5,206 | 25,003 | 2,761 | 9 | 60 | 0/0 | 0/0/0/256/27136/0 |
07-Oct 20:58 | 3,186 | 16,105 | 2,155 | 8 | 50 | 0/0 | 0/0/0/380/45568/0 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 876 | 0.00 | 0 | 0 | ||
ASM db client latch | 929 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1 | 0.00 | 0 | 0 | ||
ASM network state latch | 19 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 8,025 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 334 | 0.00 | 0 | 0 | ||
Consistent RBA | 36,599 | 0.00 | 0 | 0 | ||
DML lock allocation | 122,875 | 0.02 | 0.68 | 0 | 0 | |
Event Group Locks | 145 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 146 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 333 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
I/O Staticstics latch | 1 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 1 | 0.00 | 0 | 0 | ||
In memory undo latch | 250,163 | 0.23 | 0.96 | 6 | 39,500 | 0.01 |
JS Sh mem access | 3 | 33.33 | 1.00 | 0 | 0 | |
JS mem alloc latch | 2 | 0.00 | 0 | 0 | ||
JS queue access latch | 3 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 7,036 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 66 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 1 | 0.00 | 0 | 0 | ||
KJC message pool free list | 1 | 0.00 | 0 | 0 | ||
KJCT flow control latch | 1 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 493 | 0.00 | 0 | 0 | ||
KMG resize request state object freelist | 2 | 0.00 | 0 | 0 | ||
KTF sga latch | 7 | 0.00 | 0 | 341 | 0.00 | |
KWQMN job cache list latch | 1 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 4 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 35 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
Lsod array latch | 1 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 21 | 0.00 | ||
Memory Management Latch | 179 | 0.00 | 0 | 493 | 0.00 | |
Memory Queue | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 1 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 12 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 435 | 0.00 | 0 | 0 | ||
OS process allocation | 2,266 | 0.00 | 0 | 0 | ||
OS process: request allocation | 126 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 28,121 | 0.00 | 0 | 0 | ||
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 157 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 3 | 0.00 | 0 | 3 | 0.00 | |
SGA blob parent | 1 | 0.00 | 0 | 0 | ||
SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
SGA heap locks | 1 | 0.00 | 0 | 0 | ||
SGA pool locks | 1 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 1 | 0.00 | 0 | 333 | 0.00 | |
SQL memory manager workarea list latch | 72,615 | 0.00 | 0 | 0 | ||
Shared B-Tree | 134 | 0.00 | 0 | 0 | ||
Streams Generic | 1 | 0.00 | 0 | 0 | ||
Testing | 1 | 0.00 | 0 | 0 | ||
Token Manager | 1 | 0.00 | 0 | 0 | ||
Undo Hint Latch | 0 | 0 | 405 | 0.00 | ||
WCR: sync | 1 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
XDB used session pool | 1 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 3,991 | 0.00 | 0 | 0 | ||
active service list | 10,170 | 0.00 | 0 | 5,127 | 0.00 | |
archive control | 62 | 0.00 | 0 | 0 | ||
begin backup scn array | 6 | 0.00 | 0 | 0 | ||
buffer pool | 4 | 0.00 | 0 | 0 | ||
business card | 1 | 0.00 | 0 | 0 | ||
cache buffer handles | 932 | 0.00 | 0 | 0 | ||
cache buffers chains | 4,212,079 | 0.15 | 0.04 | 3 | 77,609 | 0.02 |
cache buffers lru chain | 29,468 | 0.26 | 0.86 | 1 | 94,165 | 1.55 |
cache table scan latch | 67 | 0.00 | 0 | 67 | 0.00 | |
call allocation | 2,704 | 0.04 | 1.00 | 0 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 134 | 0.00 | 0 | 0 | ||
channel operations parent latch | 9,304 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 64,105 | 0.02 | 0.50 | 0 | 29,500 | 0.08 |
client/application info | 254,613 | 1.29 | 0.84 | 31 | 0 | |
compile environment latch | 81 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 127,625 | 0.01 | 0.27 | 0 | 0 | |
cp cmon/server latch | 1 | 0.00 | 0 | 0 | ||
cp pool latch | 1 | 0.00 | 0 | 0 | ||
cp server hash latch | 1 | 0.00 | 0 | 0 | ||
cp sga latch | 19 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 19 | 0.00 | 0 | 0 | ||
dml lock allocation | 79 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 163 | 0.00 | 0 | 0 | ||
enqueue freelist latch | 1 | 0.00 | 0 | 39,899 | 0.01 | |
enqueue hash chains | 247,783 | 0.18 | 0.81 | 5 | 4 | 0.00 |
enqueues | 31 | 0.00 | 0 | 0 | ||
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 953 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
gc element | 1 | 0.00 | 0 | 0 | ||
gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 1 | 0.00 | 0 | 0 | ||
gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
gcs resource freelist | 1 | 0.00 | 0 | 0 | ||
gcs resource hash | 1 | 0.00 | 0 | 0 | ||
gcs resource scan list | 1 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1 | 0.00 | 0 | 0 | ||
ges domain table | 1 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 1 | 0.00 | 0 | 0 | ||
ges group table | 1 | 0.00 | 0 | 0 | ||
ges process hash list | 1 | 0.00 | 0 | 0 | ||
ges process parent latch | 1 | 0.00 | 0 | 0 | ||
ges resource hash list | 1 | 0.00 | 0 | 0 | ||
ges resource scan list | 1 | 0.00 | 0 | 0 | ||
ges resource table freelist | 1 | 0.00 | 0 | 0 | ||
ges value block free list | 1 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 23 | 0.00 | 0 | 0 | ||
global ctx hash table latch | 5 | 0.00 | 0 | 0 | ||
global tx hash mapping | 1 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 622 | 0.00 | 0 | 797,201 | 0.00 | |
hash table modification latch | 74 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latch | 5 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
job workq parent latch | 19 | 0.00 | 0 | 18 | 0.00 | |
job_queue_processes free list latch | 40 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 228 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 1 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 338 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksim group membership cache | 1 | 0.00 | 0 | 0 | ||
kss move lock | 9 | 0.00 | 0 | 0 | ||
ksuosstats global area | 107 | 0.00 | 0 | 0 | ||
ksv allocation latch | 36 | 0.00 | 0 | 0 | ||
ksv class latch | 19 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 126 | 0.00 | 0 | 0 | ||
ktm global data | 325 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 52 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 36,629 | 0.00 | 0 | 0 | ||
list of block allocation | 149 | 0.00 | 0 | 0 | ||
loader state object freelist | 54 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 5 | 0.00 | 0 | 0 | ||
lob segment query latch | 1 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
logical standby cache | 1 | 0.00 | 0 | 0 | ||
logminer context allocation | 2 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 1 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 829 | 0.00 | 0 | 0 | ||
messages | 130,346 | 0.04 | 0.70 | 0 | 0 | |
mostly latch-free SCN | 36,653 | 0.00 | 0 | 0 | ||
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 956 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 1 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 19 | 0.00 | 0 | 0 | ||
object queue header heap | 8,376 | 0.00 | 0 | 1,833 | 0.00 | |
object queue header operation | 203,553 | 0.18 | 0.76 | 3 | 880 | 0.00 |
object stats modification | 660 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 137 | 0.00 | 0 | 0 | ||
parallel query stats | 1 | 0.00 | 0 | 0 | ||
parameter list | 85 | 0.00 | 0 | 0 | ||
parameter table management | 460 | 0.00 | 0 | 0 | ||
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 9,210 | 0.27 | 0.76 | 0 | 7,413 | 0.19 |
process allocation | 162 | 0.00 | 0 | 63 | 0.00 | |
process group creation | 126 | 0.00 | 0 | 0 | ||
process queue | 1 | 0.00 | 0 | 0 | ||
process queue reference | 1 | 0.00 | 0 | 0 | ||
qmn task queue latch | 148 | 7.43 | 0.91 | 0 | 0 | |
query server freelists | 1 | 0.00 | 0 | 0 | ||
queued dump request | 3 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 189,954 | 0.20 | 0.76 | 3 | 120,907 | 0.79 |
redo copy | 1 | 0.00 | 0 | 121,309 | 1.88 | |
redo writing | 115,087 | 0.00 | 0.67 | 0 | 0 | |
resmgr group change latch | 64 | 0.00 | 0 | 0 | ||
resmgr:active threads | 164 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 49 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 162 | 0.00 | 0 | 0 | ||
resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 1,453,889 | 0.05 | 0.47 | 5 | 1,788 | 0.06 |
rules engine rule set statistics | 100 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 33,980 | 0.06 | 0.79 | 0 | 0 | |
session allocation | 75,970 | 0.03 | 0.86 | 0 | 75,809 | 0.05 |
session idle bit | 195,015 | 0.01 | 0.75 | 0 | 0 | |
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 145 | 0.00 | 0 | 0 | ||
session switching | 83 | 0.00 | 0 | 0 | ||
session timer | 337 | 0.00 | 0 | 0 | ||
shared pool | 125,867 | 0.03 | 0.66 | 0 | 0 | |
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 6,062 | 0.00 | 0 | 0 | ||
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 84,582 | 0.01 | 0.90 | 0 | 0 | |
simulator lru latch | 17,167 | 0.17 | 0.67 | 0 | 62,699 | 1.54 |
sort extent pool | 117 | 0.00 | 0 | 0 | ||
space background state object latch | 1 | 0.00 | 0 | 0 | ||
space background task latch | 6,295 | 5.05 | 0.98 | 6 | 687 | 0.15 |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 560 | 0.00 | 0 | 0 | ||
tablespace key chain | 1 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 1 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 1 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
third spare latch | 1 | 0.00 | 0 | 0 | ||
threshold alerts latch | 44 | 0.00 | 0 | 0 | ||
trace latch | 1 | 0.00 | 0 | 0 | ||
transaction allocation | 2,227 | 0.00 | 0 | 0 | ||
undo global data | 241,486 | 0.02 | 0.76 | 0 | 0 | |
virtual circuit buffers | 1 | 0.00 | 0 | 0 | ||
virtual circuit holder | 1 | 0.00 | 0 | 0 | ||
virtual circuit queues | 1 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 4,212,079 | 6,285 | 244 | 6,045 |
client/application info | 254,613 | 3,287 | 2,763 | 540 |
row cache objects | 1,453,889 | 757 | 355 | 406 |
In memory undo latch | 250,163 | 585 | 563 | 33 |
enqueue hash chains | 247,783 | 452 | 365 | 92 |
redo allocation | 189,954 | 374 | 286 | 88 |
object queue header operation | 203,553 | 363 | 277 | 94 |
space background task latch | 6,295 | 318 | 311 | 8 |
cache buffers lru chain | 29,468 | 78 | 67 | 11 |
messages | 130,346 | 53 | 37 | 16 |
shared pool | 125,867 | 44 | 29 | 20 |
undo global data | 241,486 | 42 | 32 | 10 |
simulator lru latch | 17,167 | 30 | 20 | 11 |
post/wait queue | 9,210 | 25 | 19 | 6 |
session allocation | 75,970 | 21 | 18 | 4 |
DML lock allocation | 122,875 | 19 | 13 | 6 |
sequence cache | 33,980 | 19 | 15 | 4 |
session idle bit | 195,015 | 16 | 12 | 4 |
corrupted undo seg latch | 127,625 | 11 | 3 | 8 |
qmn task queue latch | 148 | 11 | 10 | 1 |
checkpoint queue latch | 64,105 | 10 | 5 | 5 |
simulator hash latch | 84,582 | 10 | 9 | 1 |
redo writing | 115,087 | 3 | 2 | 1 |
JS Sh mem access | 3 | 1 | 1 | 0 |
call allocation | 2,704 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
DML lock allocation | ktaiam | 0 | 7 | 9 |
DML lock allocation | ktaidm | 0 | 6 | 5 |
In memory undo latch | ktiFlush: child | 0 | 293 | 336 |
In memory undo latch | kticmt: child | 0 | 113 | 18 |
In memory undo latch | ktiFlushMe | 0 | 86 | 79 |
In memory undo latch | ktichg: child | 0 | 73 | 121 |
In memory undo latch | ktiTxnPoolFree | 0 | 1 | 0 |
In memory undo latch | kturbk | 0 | 1 | 14 |
JS Sh mem access | jsksGetShMemLatch | 0 | 1 | 1 |
PC and Classifier lists for WLM | No latch | 0 | 1 | 0 |
cache buffers chains | kcbget: fast exchange | 0 | 81 | 59 |
cache buffers chains | kcbgtcr: fast path | 0 | 37 | 18 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 37 | 16 |
cache buffers chains | kcbgcur_2 | 0 | 36 | 45 |
cache buffers chains | kcbget: fast path | 0 | 12 | 1 |
cache buffers chains | kcbgcur_4 | 0 | 8 | 9 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 6 | 3 |
cache buffers chains | kcbnew: new latch again | 0 | 6 | 0 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 5 | 0 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 3 | 0 |
cache buffers chains | kcbrls: fast release | 0 | 3 | 11 |
cache buffers chains | kcb_post_apply: kcbhq62 | 0 | 2 | 4 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 2 | 1 |
cache buffers chains | kcbzhngcbk1_1 | 0 | 2 | 0 |
cache buffers chains | kcb_commit | 0 | 1 | 11 |
cache buffers chains | kcb_trim_hash_chain | 0 | 1 | 0 |
cache buffers chains | kcbchg1: clear MS bit | 0 | 1 | 3 |
cache buffers chains | kcbesc: escalate | 0 | 1 | 1 |
cache buffers chains | kcbget: pin buffer | 0 | 1 | 0 |
cache buffers chains | kcbgtcr_1 | 0 | 1 | 0 |
cache buffers chains | kcbgtcr_2 | 0 | 1 | 3 |
cache buffers chains | kcbzib: exchange rls | 0 | 1 | 12 |
cache buffers lru chain | kcbzgws | 0 | 63 | 34 |
cache buffers lru chain | kcbbxsv: move to being written | 0 | 1 | 0 |
cache buffers lru chain | kcbzswcu | 0 | 1 | 0 |
call allocation | ksuprc | 0 | 1 | 1 |
checkpoint queue latch | kcbklbc_cql | 0 | 5 | 0 |
client/application info | ksuinfos_modact | 0 | 2,789 | 2,793 |
client/application info | kskirefrattrmap | 0 | 3 | 0 |
client/application info | ksuinfos_cinfo | 0 | 1 | 0 |
corrupted undo seg latch | ktudiscorrupted | 0 | 3 | 3 |
enqueue hash chains | ksqgtl3 | 0 | 196 | 228 |
enqueue hash chains | ksqrcl | 0 | 165 | 135 |
enqueue hash chains | ksqcnl | 0 | 3 | 2 |
enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 1 | 0 |
messages | ksaamb: after wakeup | 0 | 17 | 25 |
messages | ksarcv | 0 | 11 | 8 |
messages | ksarcv: after wait | 0 | 9 | 6 |
object queue header operation | kcbo_unlink_q | 0 | 95 | 85 |
object queue header operation | kcbo_switch_cq | 0 | 81 | 153 |
object queue header operation | kcbo_switch_q_bg | 0 | 48 | 7 |
object queue header operation | kcbo_link_q | 0 | 47 | 4 |
object queue header operation | kcbo_switch_mq_bg | 0 | 11 | 18 |
post/wait queue | ksliwat:remove | 0 | 11 | 19 |
post/wait queue | ksliwat:add:nowait | 0 | 8 | 0 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 10 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 269 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 11 | 4 |
redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 2 | 0 |
redo allocation | kcrfw_redo_write: before write | 0 | 2 | 234 |
redo allocation | kcsra1 | 0 | 1 | 1 |
redo writing | kcrfwcr | 0 | 2 | 2 |
row cache objects | kqreqd: reget | 0 | 262 | 0 |
row cache objects | kqrpre: find obj | 0 | 82 | 339 |
row cache objects | kqreqd | 0 | 7 | 11 |
sequence cache | kdnssd | 0 | 11 | 0 |
sequence cache | kdnnxt: cached seq | 0 | 3 | 0 |
sequence cache | kdnss | 0 | 1 | 15 |
session allocation | ksuxds | 0 | 10 | 18 |
session allocation | ksucri_int : SSO | 0 | 8 | 0 |
session idle bit | ksuxds | 0 | 7 | 2 |
session idle bit | ksupuc: set busy | 0 | 4 | 4 |
session idle bit | ksupuc: clear busy | 0 | 1 | 6 |
shared pool | kghalo | 0 | 24 | 3 |
shared pool | kghupr1 | 0 | 3 | 22 |
shared pool | kghalp | 0 | 2 | 4 |
shared pool | kghfrunp: clatch: nowait | 0 | 1 | 0 |
simulator hash latch | kcbsacc: lookup dba | 0 | 5 | 8 |
simulator hash latch | kcbs_lookup_setid: lookup dba | 0 | 3 | 0 |
simulator hash latch | kcbsacc: insert dba | 0 | 1 | 0 |
simulator lru latch | kcbs_simulate: simulate set | 0 | 20 | 0 |
space background task latch | ktsj_grab_task | 0 | 277 | 311 |
space background task latch | ktsjCreateTask | 0 | 33 | 0 |
undo global data | ktudnx:child | 0 | 19 | 9 |
undo global data | ktubnd_4 | 0 | 9 | 0 |
undo global data | ktusm_stealext_2 | 0 | 3 | 0 |
undo global data | ktusmupst: KSLBEGIN | 0 | 1 | 1 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Library Cache | kglpin1 4 | 2,295 | 0 |
Library Cache | kglpndl1 95 | 1,813 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 443 | 0 |
Library Cache | kglobpn1 71 | 94 | 0 |
Library Cache | kgllkc1 57 | 41 | 0 |
Library Cache | kglpnal1 90 | 34 | 0 |
Library Cache | kgllkdl1 85 | 30 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 22 | 0 |
Cursor Pin | kksxsccmp [KKSCHLPIN5] | 18 | 0 |
Cursor Pin | kkslce [KKSCHLPIN2] | 11 | 0 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 5 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | INVENTORY_PK | INDEX | 286,224 | 15.30 | |
SOE | SOE | PRD_DESC_PK | INDEX | 154,384 | 8.25 | |
SOE | SOE | INVENTORIES | TABLE | 138,976 | 7.43 | |
SOE | SOE | PRODUCT_INFORMATION | TABLE | 137,376 | 7.34 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 115,856 | 6.19 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ORDER_PK | INDEX | 9,923 | 22.77 | |
SOE | SOE | INVENTORIES | TABLE | 6,663 | 15.29 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 6,084 | 13.96 | |
SOE | SOE | CUSTOMERS | TABLE | 4,709 | 10.81 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 4,351 | 9.98 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ORDER_PK | INDEX | 9,923 | 24.54 | |
SOE | SOE | INVENTORIES | TABLE | 6,663 | 16.48 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 6,084 | 15.05 | |
SOE | SOE | CUSTOMERS | TABLE | 4,709 | 11.65 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 4,351 | 10.76 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ORDER_PK | INDEX | 9,923 | 24.54 | |
SOE | SOE | INVENTORIES | TABLE | 6,663 | 16.48 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 6,084 | 15.05 | |
SOE | SOE | CUSTOMERS | TABLE | 4,709 | 11.65 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 4,351 | 10.76 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | COL$ | TABLE | 2,854 | 99.89 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ORDER_PK | INDEX | 7,161 | 26.46 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 5,679 | 20.98 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 2,638 | 9.75 | |
SOE | SOE | ORDERS | TABLE | 1,782 | 6.58 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 706 | 2.61 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 3,995 | 49.05 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 691 | 8.48 | |
SOE | SOE | ORDER_PK | INDEX | 636 | 7.81 | |
SOE | SOE | ORDERS | TABLE | 598 | 7.34 | |
SOE | SOE | CUST_UPPER_NAME_IX | INDEX | 484 | 5.94 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_279886783_80 | TABLE PARTITION | 22 | 84.62 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | COL$ | TABLE | 1 | 50.00 | |
SYS | SYSTEM | I_OBJ1 | INDEX | 1 | 50.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
SYSMAN | TEMP | MGMT_TARGET_TEMP_LIST | TABLE | 20,032 | 25.48 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 14,224 | 18.09 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 9,120 | 11.60 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 8,592 | 10.93 | |
SOE | SOE | ORDER_PK | INDEX | 8,400 | 10.68 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | CUST_EMAIL_IX | INDEX | 16 | 32.65 | |
SOE | SOE | CUST_UPPER_NAME_IX | INDEX | 15 | 30.61 | |
SOE | SOE | CUST_ACCOUNT_MANAGER_IX | INDEX | 5 | 10.20 | |
SOE | SOE | CUST_LNAME_IX | INDEX | 5 | 10.20 | |
SYS | SYSAUX | WRH$_SEG_STAT_OBJ_INDEX | INDEX | 2 | 4.08 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
SYSMAN | SYSAUX | MGMT_LAST_VIOLATION_IDX01 | INDEX | 1 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 109 | 35.50 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 86 | 28.01 | |
SOE | SOE | CUSTOMERS | TABLE | 56 | 18.24 | |
SOE | SOE | LOGON | TABLE | 40 | 13.03 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 10 | 3.26 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 21 | 0.00 | 0 | 2 | 1 | |
dc_files | 24 | 25.00 | 0 | 0 | 6 | |
dc_global_oids | 1,662 | 1.56 | 0 | 0 | 44 | |
dc_histogram_data | 30,003 | 2.46 | 0 | 0 | 1,154 | |
dc_histogram_defs | 97,371 | 3.26 | 0 | 0 | 2,151 | |
dc_object_grants | 243 | 0.82 | 0 | 0 | 12 | |
dc_objects | 37,544 | 2.51 | 0 | 1 | 1,493 | |
dc_profiles | 64 | 1.56 | 0 | 0 | 2 | |
dc_rollback_segments | 10,033 | 0.00 | 0 | 0 | 22 | |
dc_segments | 7,216 | 6.49 | 0 | 103 | 510 | |
dc_sequences | 4 | 100.00 | 0 | 4 | 0 | |
dc_tablespaces | 175,530 | 0.00 | 0 | 0 | 7 | |
dc_users | 143,447 | 0.00 | 0 | 0 | 82 | |
global database name | 712 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 10 | 100.00 | 0 | 0 | 5 | |
sch_lj_oids | 2 | 100.00 | 0 | 0 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 46 | 4.35 | 0 | 0 | 0 | |
APP CONTEXT | 3 | 0.00 | 525 | 0.00 | 0 | 0 |
BODY | 398 | 8.29 | 122,306 | 0.05 | 24 | 0 |
CLUSTER | 181 | 1.66 | 181 | 1.66 | 0 | 0 |
DBLINK | 52 | 1.92 | 0 | 0 | 0 | |
EDITION | 48 | 2.08 | 89 | 2.25 | 0 | 0 |
INDEX | 84 | 45.24 | 84 | 45.24 | 0 | 0 |
QUEUE | 19 | 0.00 | 2,971 | 0.00 | 0 | 0 |
SCHEMA | 1,160 | 0.26 | 0 | 0 | 0 | |
SQL AREA | 5,410 | 43.55 | 265,598 | 0.90 | 444 | 20 |
SQL AREA BUILD | 934 | 88.76 | 0 | 0 | 0 | |
SQL AREA STATS | 814 | 75.06 | 814 | 75.06 | 0 | 0 |
SUBSCRIPTION | 2 | 0.00 | 2 | 100.00 | 2 | 0 |
TABLE/PROCEDURE | 8,370 | 10.87 | 158,878 | 1.51 | 875 | 0 |
TRIGGER | 26 | 0.00 | 873 | 0.92 | 5 | 0 |
Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod |
---|---|---|---|---|---|---|
ASM Buffer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 16K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 2K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 32K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 4K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT 8K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
DEFAULT buffer cache | 380.00 | 372.00 | 372.00 | 408.00 | 1 | SHR/DEF |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 200.00 | 200.00 | 200.00 | 200.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 600.00 | 600.00 | 600.00 | 600.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
large pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
shared pool | 196.00 | 204.00 | 168.00 | 204.00 | 1 | GRO/DEF |
streams pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
Component | Min Size (Mb) | Max Size (Mb) | Avg Size (Mb) | Re- Sizes | Grows | Shrinks |
---|---|---|---|---|---|---|
DEFAULT buffer cache | 372.00 | 372.00 | 372.00 | 1 | 0 | 1 |
shared pool | 204.00 | 204.00 | 204.00 | 1 | 1 | 0 |
Start | Ela (s) | Component | Oper Typ/Mod | Init Size (M) | Delta | Target Delta | Final (M) | Sta |
---|---|---|---|---|---|---|---|---|
10/07 20:54:22 | 3 | bufcache | SHR/DEF | 380 | -8 | 372 | COM | |
10/07 20:54:22 | 3 | shared | GRO/DEF | 196 | 8 | 204 | COM |
Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
---|---|---|---|---|---|---|---|---|---|
B | Other | 134.32 | 1.82 | 1.75 | 12 | 17 | 74 | 74 | |
B | Freeable | 23.94 | 0.00 | 0.70 | 0.44 | 2 | 34 | 34 | |
B | PL/SQL | 16.51 | 14.34 | 0.23 | 0.51 | 3 | 3 | 72 | 72 |
B | SQL | 5.45 | 1.54 | 0.09 | 0.10 | 1 | 20 | 61 | 56 |
E | Other | 133.82 | 1.83 | 1.78 | 12 | 19 | 73 | 73 | |
E | Freeable | 27.94 | 0.00 | 0.72 | 0.37 | 1 | 39 | 39 | |
E | PL/SQL | 17.67 | 13.72 | 0.25 | 0.48 | 2 | 4 | 71 | 71 |
E | SQL | 4.80 | 1.56 | 0.08 | 0.10 | 1 | 20 | 60 | 53 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 398,458,880 | 390,070,272 |
Fixed Size | 2,230,952 | |
Redo Buffers | 7,532,544 | |
Variable Size | 218,105,176 | 226,493,784 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 4.00 | 4.00 | 0.00 |
large | PX msg pool | 0.47 | 0.47 | 0.00 |
large | free memory | 3.53 | 3.53 | 0.00 |
shared | ASH buffers | 4.00 | 4.00 | 0.00 |
shared | KCB Table Scan Buffer | 3.80 | 3.80 | 0.00 |
shared | KGLH0 | 20.18 | 21.63 | 7.16 |
shared | KGLHD | 4.44 | 5.77 | 29.92 |
shared | KGLS | 5.08 | 5.22 | 2.79 |
shared | KGLSG | 5.02 | 5.02 | 0.00 |
shared | KKSSP | 4.26 | 4.30 | 0.71 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PLMCD | 4.12 | 6.75 | 63.84 |
shared | SQLA | 18.39 | 31.13 | 69.31 |
shared | XDBSC | 9.62 | 9.62 | 0.00 |
shared | db_block_hash_buckets | 2.79 | 2.79 | 0.00 |
shared | dbktb: trace buffer | 2.34 | 2.34 | 0.00 |
shared | dbwriter coalesce buffer | 3.79 | 3.79 | 0.00 |
shared | event statistics per sess | 3.10 | 3.10 | 0.00 |
shared | free memory | 34.31 | 23.52 | -31.45 |
shared | kglsim hash table bkts | 4.00 | 4.00 | 0.00 |
shared | kglsim object batch | 2.10 | 2.10 | 0.00 |
shared | ksunfy : SSO free list | 2.89 | 2.89 | 0.00 |
shared | obj stats allocation chun | 2.46 | 2.46 | 0.00 |
shared | private strands | 3.51 | 3.51 | 0.00 |
shared | row cache | 7.24 | 7.24 | 0.00 |
shared | write state object | 2.16 | 2.16 | 0.00 |
streams | KTG hash buckets | 1.26 | 1.26 | 0.00 |
streams | free memory | 2.74 | 2.74 | 0.00 |
buffer_cache | 380.00 | 372.00 | -2.11 | |
fixed_sga | 2.13 | 2.13 | 0.00 | |
log_buffer | 7.18 | 7.18 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Slaves | 1007 20:18:50 | 0.60 | 0.00 | 0.00 |
QMON Coordinator | 1007 20:18:40 | 0.46 | 0.00 | 0.00 |
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE(12733) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_NOTIFY_Q(77762) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(77432) | 22 | 22 | 0.00 | 0.00 | 0.24 | 0.82 | 0.00 | 0.00 |
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
SYS.ALERT_QUE(12733) | 0.00 | 0.00 | ||
SYSMAN.MGMT_NOTIFY_Q(77762) | 0.00 | 0.00 | ||
SYSMAN.MGMT_TASK_Q(77432) | 0.02 | 0.02 | 0.01 | 0.04 |
Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
---|---|---|---|---|---|---|
HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 | |||
OL6_112_LOCAL_3938_DB11G(41)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
1,017 | 0.00 | 100.00 | 0.00 | 0.00 |
Name | Avg Conns | Total Disp Time (s) | %Busy | %Idle | Total Queued | Total Queue Wait (s) | Avg Queue Wait (ms) |
---|---|---|---|---|---|---|---|
D000 | 0.00 | 1,017 | 0.00 | 100.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /u01/app/oracle/admin/DB11G/adump | |
audit_trail | DB | |
compatible | 11.2.0.0.0 | |
control_files | /u01/app/oracle/oradata/DB11G/control01.ctl, /u01/app/oracle/fast_recovery_area/DB11G/control02.ctl | |
db_block_size | 8192 | |
db_domain | WORLD | |
db_name | DB11G | |
db_recovery_file_dest | /u01/app/oracle/fast_recovery_area | |
db_recovery_file_dest_size | 10485760000 | |
diagnostic_dest | /u01/app/oracle | |
dispatchers | (PROTOCOL=TCP) (SERVICE=DB11GXDB) | |
job_queue_processes | 1000 | |
open_cursors | 300 | |
pga_aggregate_target | 209715200 | |
processes | 150 | |
remote_login_passwordfile | EXCLUSIVE | |
sga_target | 629145600 | |
undo_tablespace | UNDOTBS1 | |
use_large_pages | ONLY |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | /u01/app/oracle/fast_recovery_area/DB11G/control02.ctl | |
control_files | /u01/app/oracle/oradata/DB11G/control01.ctl |