DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
DBM11203 | 2532911053 | DBM11203 | 1 | 23-Apr-14 16:04 | 11.2.0.3.0 | NO |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
helicon | Linux x86 64-bit | 8 | 8 | 2 | 7.79 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 1826 | 23-Apr-14 19:30:10 | 59 | 1.7 |
End Snap: | 1827 | 23-Apr-14 19:45:13 | 74 | 1.8 |
Elapsed: | 15.05 (mins) | |||
DB Time: | 210.21 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 728M | 728M | Std Block Size: | 8K |
Shared Pool Size: | 260M | 260M | Log Buffer: | 9,508K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 14.0 | 0.1 | 0.01 | 0.00 |
DB CPU(s): | 3.2 | 0.0 | 0.00 | 0.00 |
Redo size: | 552,173.5 | 1,933.1 | ||
Logical reads: | 649,091.1 | 2,272.4 | ||
Block changes: | 3,948.6 | 13.8 | ||
Physical reads: | 857.4 | 3.0 | ||
Physical writes: | 578.1 | 2.0 | ||
User calls: | 4,051.3 | 14.2 | ||
Parses: | 1.6 | 0.0 | ||
Hard parses: | 0.4 | 0.0 | ||
W/A MB processed: | 0.1 | 0.0 | ||
Logons: | 0.0 | 0.0 | ||
Executes: | 1,914.2 | 6.7 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 285.6 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 99.96 |
Buffer Hit %: | 99.87 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.92 | Soft Parse %: | 76.90 |
Execute to Parse %: | 99.92 | Latch Hit %: | 99.83 |
Parse CPU to Parse Elapsd %: | 71.98 | % Non-Parse CPU: | 98.91 |
Begin | End | |
---|---|---|
Memory Usage %: | 74.66 | 65.25 |
% SQL with executions>1: | 79.00 | 70.05 |
% Memory for SQL w/exec>1: | 68.33 | 61.00 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
db file sequential read | 770,898 | 9,336 | 12 | 74.02 | User I/O |
DB CPU | 2,877 | 22.81 | |||
log file sync | 256,683 | 267 | 1 | 2.12 | Commit |
read by other session | 4,219 | 51 | 12 | 0.41 | User I/O |
log file switch (private strand flush incomplete) | 266 | 12 | 45 | 0.10 | Configuration |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
8.37 | 14.07 | 39.6 | 1.4 | 30.5 | 58.1 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
41.4 | 98.9 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 7,974.6 | 7,974.6 |
SGA use (MB): | 1,024.0 | 1,024.0 |
PGA use (MB): | 184.9 | 217.0 |
% Host Mem used for SGA+PGA: | 15.16 | 15.56 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 12,024.64 | 95.34 |
DB CPU | 2,876.51 | 22.81 |
parse time elapsed | 57.06 | 0.45 |
connection management call elapsed time | 7.39 | 0.06 |
hard parse elapsed time | 3.63 | 0.03 |
hard parse (sharing criteria) elapsed time | 0.47 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.46 | 0.00 |
PL/SQL compilation elapsed time | 0.26 | 0.00 |
PL/SQL execution elapsed time | 0.01 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 |
sequence load elapsed time | 0.00 | 0.00 |
DB time | 12,612.51 | |
background elapsed time | 221.86 | |
background cpu time | 62.12 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 297,133 | |
IDLE_TIME | 412,759 | |
IOWAIT_TIME | 216,362 | |
NICE_TIME | 99 | |
SYS_TIME | 10,170 | |
USER_TIME | 281,270 | |
LOAD | 8 | 14 |
PHYSICAL_MEMORY_BYTES | 8,361,992,192 | |
NUM_CPUS | 8 | |
NUM_CPU_CORES | 8 | |
NUM_CPU_SOCKETS | 2 | |
GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 174,760 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 131,072 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
23-Apr 19:30:10 | 8.37 | |||||
23-Apr 19:45:13 | 14.07 | 41.86 | 39.62 | 1.43 | 58.14 | 30.48 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
User I/O | 775,292 | 0 | 9,388 | 12 | 74.44 |
DB CPU | 2,877 | 22.81 | |||
Commit | 256,683 | 0 | 267 | 1 | 2.12 |
Configuration | 418 | 0 | 19 | 46 | 0.15 |
Concurrency | 2,706 | 0 | 11 | 4 | 0.09 |
Network | 1,986,310 | 0 | 4 | 0 | 0.03 |
Application | 1,230 | 0 | 2 | 2 | 0.02 |
Other | 291 | 3 | 1 | 2 | 0.00 |
System I/O | 364 | 0 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
db file sequential read | 770,898 | 0 | 9,336 | 12 | 2.99 | 74.02 |
log file sync | 256,683 | 0 | 267 | 1 | 1.00 | 2.12 |
read by other session | 4,219 | 0 | 51 | 12 | 0.02 | 0.41 |
log file switch (private strand flush incomplete) | 266 | 0 | 12 | 45 | 0.00 | 0.10 |
cursor: pin S wait on X | 74 | 0 | 8 | 104 | 0.00 | 0.06 |
log file switch (checkpoint incomplete) | 148 | 0 | 7 | 47 | 0.00 | 0.06 |
SQL*Net message to client | 1,986,310 | 0 | 4 | 0 | 7.70 | 0.03 |
enq: TX - row lock contention | 1,230 | 0 | 2 | 2 | 0.00 | 0.02 |
library cache lock | 50 | 0 | 1 | 21 | 0.00 | 0.01 |
library cache load lock | 27 | 0 | 1 | 19 | 0.00 | 0.00 |
enq: TX - index contention | 32 | 0 | 1 | 16 | 0.00 | 0.00 |
library cache: mutex X | 217 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: cache buffers chains | 1,325 | 0 | 0 | 0 | 0.01 | 0.00 |
kksfbc child completion | 6 | 100 | 0 | 51 | 0.00 | 0.00 |
db file parallel read | 28 | 0 | 0 | 11 | 0.00 | 0.00 |
cursor: pin S | 64 | 0 | 0 | 4 | 0.00 | 0.00 |
buffer busy waits | 635 | 0 | 0 | 0 | 0.00 | 0.00 |
control file sequential read | 364 | 0 | 0 | 0 | 0.00 | 0.00 |
latch free | 193 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: HW - contention | 4 | 0 | 0 | 28 | 0.00 | 0.00 |
enq: TX - contention | 1 | 0 | 0 | 69 | 0.00 | 0.00 |
latch: In memory undo latch | 254 | 0 | 0 | 0 | 0.00 | 0.00 |
row cache lock | 11 | 0 | 0 | 3 | 0.00 | 0.00 |
latch: shared pool | 9 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: object queue header operation | 46 | 0 | 0 | 0 | 0.00 | 0.00 |
db file scattered read | 2 | 0 | 0 | 7 | 0.00 | 0.00 |
Disk file operations I/O | 145 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: enqueue hash chains | 28 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: CU - contention | 1 | 0 | 0 | 4 | 0.00 | 0.00 |
latch: row cache objects | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: redo allocation | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: undo global data | 6 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 1,986,307 | 0 | 22,827 | 11 | 7.70 | |
jobq slave wait | 120 | 100 | 60 | 501 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 242,545 | 0 | 105 | 0 | 0.94 | 47.32 |
db file parallel write | 39,266 | 0 | 23 | 1 | 0.15 | 10.33 |
control file sequential read | 2,471 | 0 | 14 | 6 | 0.01 | 6.41 |
db file sequential read | 1,658 | 0 | 14 | 9 | 0.01 | 6.40 |
db file scattered read | 86 | 0 | 1 | 11 | 0.00 | 0.43 |
log file sequential read | 56 | 0 | 1 | 10 | 0.00 | 0.26 |
direct path read | 32 | 0 | 0 | 15 | 0.00 | 0.21 |
os thread startup | 11 | 0 | 0 | 38 | 0.00 | 0.19 |
control file parallel write | 663 | 0 | 0 | 1 | 0.00 | 0.16 |
ASM file metadata operation | 542 | 0 | 0 | 1 | 0.00 | 0.14 |
LGWR wait for redo copy | 2,634 | 0 | 0 | 0 | 0.01 | 0.10 |
ADR block file read | 16 | 0 | 0 | 7 | 0.00 | 0.05 |
latch: cache buffers chains | 18 | 0 | 0 | 1 | 0.00 | 0.01 |
latch: redo allocation | 39 | 0 | 0 | 0 | 0.00 | 0.00 |
reliable message | 58 | 0 | 0 | 0 | 0.00 | 0.00 |
latch free | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
db file async I/O submit | 2,564 | 0 | 0 | 0 | 0.01 | 0.00 |
CSS initialization | 1 | 0 | 0 | 7 | 0.00 | 0.00 |
direct path write | 27 | 0 | 0 | 0 | 0.00 | 0.00 |
log file single write | 56 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers lru chain | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
Disk file operations I/O | 51 | 0 | 0 | 0 | 0.00 | 0.00 |
ADR block file write | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
CSS operation: action | 1 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: object queue header operation | 7 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 246,243 | 2 | 12,462 | 51 | 0.95 | |
class slave wait | 267 | 0 | 3,621 | 13561 | 0.00 | |
Space Manager: slave idle wait | 454 | 91 | 2,158 | 4754 | 0.00 | |
DIAG idle wait | 1,807 | 100 | 1,810 | 1001 | 0.01 | |
smon timer | 41 | 0 | 906 | 22092 | 0.00 | |
ASM background timer | 181 | 0 | 906 | 5003 | 0.00 | |
wait for unread message on broadcast channel | 904 | 100 | 905 | 1002 | 0.00 | |
pmon timer | 363 | 69 | 904 | 2490 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 290 | 44 | 902 | 3111 | 0.00 | |
Streams AQ: qmn slave idle wait | 129 | 0 | 902 | 6993 | 0.00 | |
SQL*Net message from client | 45 | 0 | 0 | 5 | 0.00 | |
KSV master wait | 86 | 0 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 16 | 75.0 | 12.5 | 12.5 | |||||
ADR block file write | 5 | 100.0 | |||||||
ADR file lock | 6 | 100.0 | |||||||
ASM file metadata operation | 545 | 91.7 | 4.0 | 3.3 | .4 | .2 | .2 | .2 | |
CSS initialization | 1 | 100.0 | |||||||
CSS operation: action | 1 | 100.0 | |||||||
CSS operation: query | 6 | 100.0 | |||||||
Disk file operations I/O | 196 | 100.0 | |||||||
LGWR wait for redo copy | 2638 | 99.6 | .2 | .2 | .1 | ||||
SQL*Net message to client | 1991.1K | 100.0 | .0 | .0 | .0 | ||||
asynch descriptor resize | 61 | 100.0 | |||||||
buffer busy waits | 639 | 98.0 | .6 | .8 | .2 | .2 | .3 | ||
control file parallel write | 663 | 91.3 | 3.9 | 2.7 | 1.2 | .6 | .2 | .2 | |
control file sequential read | 2835 | 72.2 | .6 | 2.8 | 9.5 | 7.8 | 3.9 | 3.2 | |
cursor: pin S | 64 | 56.3 | 6.3 | 4.7 | 31.3 | 1.6 | |||
cursor: pin S wait on X | 74 | 2.7 | 1.4 | 1.4 | 17.6 | 13.5 | 63.5 | ||
db file async I/O submit | 2565 | 100.0 | |||||||
db file parallel read | 28 | 7.1 | 35.7 | 46.4 | 7.1 | 3.6 | |||
db file parallel write | 39.3K | 95.0 | .4 | .3 | .5 | 3.8 | .0 | .0 | |
db file scattered read | 88 | 13.6 | 11.4 | 9.1 | 23.9 | 25.0 | 11.4 | 5.7 | |
db file sequential read | 774.4K | 2.1 | 2.0 | 14.1 | 39.4 | 25.7 | 10.1 | 6.7 | |
direct path read | 32 | 6.3 | 6.3 | 21.9 | 15.6 | 18.8 | 25.0 | 6.3 | |
direct path write | 27 | 96.3 | 3.7 | ||||||
enq: CU - contention | 1 | 100.0 | |||||||
enq: HW - contention | 4 | 25.0 | 50.0 | 25.0 | |||||
enq: TX - contention | 1 | 100.0 | |||||||
enq: TX - index contention | 32 | 25.0 | 3.1 | 9.4 | 15.6 | 18.8 | 12.5 | 15.6 | |
enq: TX - row lock contention | 1236 | 84.7 | 4.1 | 3.1 | 3.7 | 1.7 | 1.9 | .8 | |
kksfbc child completion | 6 | 100.0 | |||||||
latch free | 204 | 93.6 | 2.9 | .5 | 2.0 | 1.0 | |||
latch: In memory undo latch | 253 | 97.2 | 1.6 | 1.2 | |||||
latch: cache buffers chains | 1349 | 94.5 | 2.9 | 2.1 | .2 | .2 | .1 | ||
latch: cache buffers lru chain | 22 | 100.0 | |||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 28 | 96.4 | 3.6 | ||||||
latch: messages | 3 | 100.0 | |||||||
latch: object queue header operation | 54 | 96.3 | 1.9 | 1.9 | |||||
latch: redo allocation | 45 | 97.8 | 2.2 | ||||||
latch: redo writing | 2 | 100.0 | |||||||
latch: row cache objects | 8 | 100.0 | |||||||
latch: session allocation | 2 | 100.0 | |||||||
latch: shared pool | 9 | 44.4 | 11.1 | 22.2 | 22.2 | ||||
latch: undo global data | 6 | 100.0 | |||||||
library cache load lock | 27 | 11.1 | 3.7 | 22.2 | 55.6 | 7.4 | |||
library cache lock | 50 | 58.0 | 2.0 | 2.0 | 16.0 | 2.0 | 20.0 | ||
library cache: mutex X | 217 | 82.9 | 2.3 | .5 | 11.5 | 1.8 | .9 | ||
log file parallel write | 243.1K | 92.7 | 3.2 | 2.2 | 1.0 | .6 | .2 | .0 | |
log file sequential read | 56 | 26.8 | 7.1 | 14.3 | 16.1 | 23.2 | 5.4 | 7.1 | |
log file single write | 56 | 100.0 | |||||||
log file switch (checkpoint incomplete) | 148 | 2.0 | 2.7 | 11.5 | 16.2 | 67.6 | |||
log file switch (private strand flush incomplete) | 265 | 1.5 | 1.1 | 1.9 | 4.2 | 7.2 | 21.5 | 62.6 | |
log file sync | 257.3K | 85.4 | 5.7 | 3.9 | 2.2 | 2.1 | .7 | .1 | |
os thread startup | 11 | 100.0 | |||||||
read by other session | 4227 | 3.9 | 5.2 | 15.5 | 33.7 | 22.0 | 11.8 | 7.7 | |
reliable message | 58 | 100.0 | |||||||
row cache lock | 11 | 9.1 | 90.9 | ||||||
ASM background timer | 181 | 100.0 | |||||||
DIAG idle wait | 1811 | 99.9 | .1 | ||||||
KSV master wait | 86 | 98.8 | 1.2 | ||||||
SQL*Net message from client | 1991.1K | 26.6 | .2 | .2 | .1 | 46.2 | 26.1 | .7 | |
Space Manager: slave idle wait | 457 | 3.1 | 96.9 | ||||||
Streams AQ: qmn coordinator idle wait | 292 | 55.1 | .3 | 44.5 | |||||
Streams AQ: qmn slave idle wait | 130 | 100.0 | |||||||
class slave wait | 267 | 35.6 | .4 | .7 | 3.4 | 5.6 | 22.1 | 32.2 | |
jobq slave wait | 120 | 100.0 | |||||||
pmon timer | 364 | .3 | .5 | 1.1 | 11.0 | 87.1 | |||
rdbms ipc message | 246.8K | 31.4 | 17.5 | 21.8 | 18.4 | 7.6 | .7 | 1.5 | .9 |
smon timer | 42 | 14.3 | 7.1 | 78.6 | |||||
wait for unread message on broadcast channel | 905 | 100.0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file read | 2 | 87.5 | 12.5 | ||||||
ASM file metadata operation | 1 | 99.8 | .2 | ||||||
buffer busy waits | 2 | 99.7 | .3 | ||||||
control file parallel write | 1 | 99.8 | .2 | ||||||
control file sequential read | 92 | 96.8 | 1.8 | 1.0 | .5 | ||||
cursor: pin S wait on X | 47 | 36.5 | 28.4 | 28.4 | 6.8 | ||||
db file parallel read | 1 | 96.4 | 3.6 | ||||||
db file parallel write | 7 | 100.0 | .0 | .0 | .0 | ||||
db file scattered read | 5 | 94.3 | 4.5 | 1.1 | |||||
db file sequential read | 51.5K | 93.3 | 4.4 | 2.1 | .2 | .0 | |||
direct path read | 2 | 93.8 | 3.1 | 3.1 | |||||
enq: HW - contention | 1 | 75.0 | 25.0 | ||||||
enq: TX - contention | 1 | 100.0 | |||||||
enq: TX - index contention | 5 | 84.4 | 9.4 | 6.3 | |||||
enq: TX - row lock contention | 10 | 99.2 | .6 | .2 | |||||
kksfbc child completion | 6 | 100.0 | |||||||
latch: cache buffers chains | 1 | 99.9 | .1 | ||||||
library cache load lock | 2 | 92.6 | 7.4 | ||||||
library cache lock | 10 | 80.0 | 16.0 | 4.0 | |||||
library cache: mutex X | 2 | 99.1 | .9 | ||||||
log file parallel write | 18 | 100.0 | .0 | .0 | |||||
log file sequential read | 4 | 92.9 | 3.6 | 3.6 | |||||
log file switch (checkpoint incomplete) | 100 | 32.4 | 44.6 | 23.0 | |||||
log file switch (private strand flush incomplete) | 166 | 37.4 | 42.3 | 20.4 | |||||
log file sync | 236 | 99.9 | .1 | .0 | .0 | ||||
os thread startup | 11 | 100.0 | |||||||
read by other session | 327 | 92.3 | 5.7 | 1.9 | .1 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
DBM11203.antognini.ch | 12,579 | 2,870 | 770 | 585,661 |
SYS$USERS | 10 | 1 | 1 | 16 |
SYS$BACKGROUND | 0 | 0 | 2 | 31 |
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 |
---|---|---|---|---|---|---|---|---|
DBM11203.antognini.ch | 774230 | 9380 | 2706 | 11 | 0 | 0 | 1985735 | 4 |
SYS$USERS | 824 | 6 | 0 | 0 | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 1837 | 15 | 33 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
3,625.67 | 176,182 | 0.02 | 28.75 | 1.44 | 98.77 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
2,314.65 | 10,442 | 0.22 | 18.35 | 92.64 | 5.10 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
1,327.33 | 147,058 | 0.01 | 10.52 | 3.90 | 95.72 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
1,290.25 | 51,948 | 0.02 | 10.23 | 2.67 | 97.15 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
1,038.30 | 51,887 | 0.02 | 8.23 | 2.04 | 98.11 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
1,010.98 | 147,054 | 0.01 | 8.02 | 2.62 | 97.28 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
323.41 | 51,945 | 0.01 | 2.56 | 5.96 | 93.62 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
84.91 | 51,947 | 0.00 | 0.67 | 14.25 | 85.02 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
84.57 | 311,130 | 0.00 | 0.67 | 87.05 | 0.00 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
42.65 | 176,186 | 0.00 | 0.34 | 65.94 | 15.17 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
2,144.37 | 10,442 | 0.21 | 74.55 | 2,314.65 | 92.64 | 5.10 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
73.62 | 311,130 | 0.00 | 2.56 | 84.57 | 87.05 | 0.00 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
52.16 | 176,182 | 0.00 | 1.81 | 3,625.67 | 1.44 | 98.77 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
51.74 | 147,058 | 0.00 | 1.80 | 1,327.33 | 3.90 | 95.72 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
34.48 | 51,948 | 0.00 | 1.20 | 1,290.25 | 2.67 | 97.15 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
28.12 | 176,186 | 0.00 | 0.98 | 42.65 | 65.94 | 15.17 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
26.44 | 147,054 | 0.00 | 0.92 | 1,010.98 | 2.62 | 97.28 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
21.20 | 51,887 | 0.00 | 0.74 | 1,038.30 | 2.04 | 98.11 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
19.27 | 51,945 | 0.00 | 0.67 | 323.41 | 5.96 | 93.62 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
18.68 | 155,252 | 0.00 | 0.65 | 20.68 | 90.34 | 0.00 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
3,580.90 | 176,182 | 0.02 | 38.08 | 3,625.67 | 1.44 | 98.77 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
1,270.53 | 147,058 | 0.01 | 13.51 | 1,327.33 | 3.90 | 95.72 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
1,253.45 | 51,948 | 0.02 | 13.33 | 1,290.25 | 2.67 | 97.15 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
1,018.70 | 51,887 | 0.02 | 10.83 | 1,038.30 | 2.04 | 98.11 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
983.44 | 147,054 | 0.01 | 10.46 | 1,010.98 | 2.62 | 97.28 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
302.77 | 51,945 | 0.01 | 3.22 | 323.41 | 5.96 | 93.62 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
118.06 | 10,442 | 0.01 | 1.26 | 2,314.65 | 92.64 | 5.10 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
72.19 | 51,947 | 0.00 | 0.77 | 84.91 | 14.25 | 85.02 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
31.81 | 10,442 | 0.00 | 0.34 | 38.60 | 10.12 | 82.41 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
6.47 | 176,186 | 0.00 | 0.07 | 42.65 | 65.94 | 15.17 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
9,341,219 | 311,130 | 30.02 | 1.59 | 84.57 | 87 | 0 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
1,952,469 | 147,058 | 13.28 | 0.33 | 1,327.33 | 3.9 | 95.7 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
1,095,476 | 155,252 | 7.06 | 0.19 | 20.68 | 90.3 | 0 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
1,038,463 | 147,059 | 7.06 | 0.18 | 18.39 | 91.9 | 1 | dt8dtzvsq5kj5 | Swingbench User Thread | select p.product_id, product_n... |
1,021,987 | 176,186 | 5.80 | 0.17 | 42.65 | 65.9 | 15.2 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
975,049 | 51,948 | 18.77 | 0.17 | 1,290.25 | 2.7 | 97.1 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
705,177 | 176,182 | 4.00 | 0.12 | 3,625.67 | 1.4 | 98.8 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
649,927 | 51,947 | 12.51 | 0.11 | 84.91 | 14.3 | 85 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
577,327 | 147,054 | 3.93 | 0.10 | 1,010.98 | 2.6 | 97.3 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
534,761 | 51,945 | 10.29 | 0.09 | 323.41 | 6 | 93.6 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
271,995 | 176,182 | 1.54 | 35.14 | 3,625.67 | 1.44 | 98.77 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
112,200 | 147,058 | 0.76 | 14.49 | 1,327.33 | 3.90 | 95.72 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
100,191 | 51,948 | 1.93 | 12.94 | 1,290.25 | 2.67 | 97.15 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
94,162 | 51,887 | 1.81 | 12.16 | 1,038.30 | 2.04 | 98.11 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
82,827 | 147,054 | 0.56 | 10.70 | 1,010.98 | 2.62 | 97.28 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
25,831 | 51,945 | 0.50 | 3.34 | 323.41 | 5.96 | 93.62 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
6,602 | 51,947 | 0.13 | 0.85 | 84.91 | 14.25 | 85.02 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
6,537 | 10,442 | 0.63 | 0.84 | 2,314.65 | 92.64 | 5.10 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
2,130 | 10,442 | 0.20 | 0.28 | 38.60 | 10.12 | 82.41 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
793 | 1 | 793.00 | 0.10 | 6.47 | 19.76 | 76.48 | 9zus1m3s2675b | DBMS_SCHEDULER | DECLARE job BINARY_INTEGER := ... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
271,994 | 271,994 | 176,182 | 1.54 | 0.00 | 35.17 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
112,210 | 112,210 | 147,058 | 0.76 | 0.00 | 14.51 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
100,193 | 100,193 | 51,948 | 1.93 | 0.00 | 12.95 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
94,166 | 94,166 | 51,887 | 1.81 | 0.00 | 12.18 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
82,831 | 82,831 | 147,054 | 0.56 | 0.00 | 10.71 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
25,832 | 25,832 | 51,945 | 0.50 | 0.00 | 3.34 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
6,602 | 6,602 | 51,947 | 0.13 | 0.00 | 0.85 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
6,546 | 6,546 | 10,442 | 0.63 | 0.00 | 0.85 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
2,130 | 2,130 | 10,442 | 0.20 | 0.00 | 0.28 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
1,126 | 1,126 | 1 | 1,126.00 | 0.00 | 0.15 | 9zus1m3s2675b | DBMS_SCHEDULER | DECLARE job BINARY_INTEGER := ... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
311,130 | 1,565,811 | 5.03 | 84.57 | 87 | 0 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
176,186 | 176,180 | 1.00 | 42.65 | 65.9 | 15.2 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
176,182 | 176,167 | 1.00 | 3,625.67 | 1.4 | 98.8 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
155,252 | 1,552,490 | 10.00 | 20.68 | 90.3 | 0 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
147,059 | 1,470,490 | 10.00 | 18.39 | 91.9 | 1 | dt8dtzvsq5kj5 | Swingbench User Thread | select p.product_id, product_n... |
147,058 | 147,055 | 1.00 | 1,327.33 | 3.9 | 95.7 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
147,057 | 147,059 | 1.00 | 12.15 | 92.2 | 0 | 982zxphp8ht6c | Swingbench User Thread | select product_id, product_nam... |
147,054 | 132,584 | 0.90 | 1,010.98 | 2.6 | 97.3 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
51,948 | 51,947 | 1.00 | 1,290.25 | 2.7 | 97.1 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
51,947 | 51,947 | 1.00 | 5.40 | 89.3 | 0 | 8uk8bquk453q8 | Swingbench User Thread | select orders_seq.nextval from... |
51,947 | 147,038 | 2.83 | 84.91 | 14.3 | 85 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
51,945 | 51,945 | 1.00 | 323.41 | 6 | 93.6 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
51,887 | 49,896 | 0.96 | 1,038.30 | 2 | 98.1 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
20,502 | 20,502 | 1.00 | 2.10 | 90.5 | 0 | 5d8b4p888x97a | Swingbench User Thread | select customer_seq.nextval fr... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
151 | 151 | 10.51 | b2gnxm5z6r51n | lock table sys.col_usage$ in e... | |
137 | 137 | 9.53 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
23 | 96 | 1.60 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
19 | 111 | 1.32 | bsa0wjtftg3uw | select file# from file$ where ... | |
17 | 30 | 1.18 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
15 | 15 | 1.04 | 0k8522rmdzg4k | select privilege# from sysauth... | |
15 | 15 | 1.04 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
15 | 51,945 | 1.04 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
15 | 15 | 1.04 | 459f3z9u4fb3u | select value$ from props$ wher... | |
15 | 20,502 | 1.04 | 5d8b4p888x97a | Swingbench User Thread | select customer_seq.nextval fr... |
15 | 147,054 | 1.04 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
15 | 15 | 1.04 | 5ur69atw3vfhj | select decode(failover_method,... | |
15 | 10,442 | 1.04 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
15 | 155,252 | 1.04 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
15 | 176,182 | 1.04 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
15 | 51,947 | 1.04 | 8uk8bquk453q8 | Swingbench User Thread | select orders_seq.nextval from... |
15 | 147,058 | 1.04 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
15 | 147,057 | 1.04 | 982zxphp8ht6c | Swingbench User Thread | select product_id, product_nam... |
15 | 51,948 | 1.04 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
15 | 51,887 | 1.04 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
15 | 147,059 | 1.04 | dt8dtzvsq5kj5 | Swingbench User Thread | select p.product_id, product_n... |
15 | 15 | 1.04 | g4rkmp4240p84 | Swingbench User Thread | BEGIN dbms_application_info.se... |
15 | 10,442 | 1.04 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
15 | 51,947 | 1.04 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
15 | 176,186 | 1.04 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
15 | 311,130 | 1.04 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 433 | 0.48 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 768 | 0.85 | 0.00 |
Batched IO buffer defrag count | 3 | 0.00 | 0.00 |
Batched IO double miss count | 123 | 0.14 | 0.00 |
Batched IO same unit count | 263 | 0.29 | 0.00 |
Batched IO single block count | 494 | 0.55 | 0.00 |
Batched IO vector block count | 126 | 0.14 | 0.00 |
Batched IO vector read count | 62 | 0.07 | 0.00 |
Block Cleanout Optim referenced | 6,675 | 7.39 | 0.03 |
CCursor + sql area evicted | 17 | 0.02 | 0.00 |
CPU used by this session | 274,380 | 303.90 | 1.06 |
CPU used when call started | 274,171 | 303.67 | 1.06 |
CR blocks created | 76,368 | 84.59 | 0.30 |
Cached Commit SCN referenced | 41,731 | 46.22 | 0.16 |
Commit SCN cached | 8,609 | 9.54 | 0.03 |
DB time | 1,258,062 | 1,393.43 | 4.88 |
DBWR checkpoint buffers written | 31,900 | 35.33 | 0.12 |
DBWR checkpoints | 14 | 0.02 | 0.00 |
DBWR thread checkpoint buffers written | 31,900 | 35.33 | 0.12 |
DBWR transaction table writes | 285 | 0.32 | 0.00 |
DBWR undo block writes | 24,068 | 26.66 | 0.09 |
HSC Heap Segment Block Changes | 589,972 | 653.45 | 2.29 |
Heap Segment Array Inserts | 173 | 0.19 | 0.00 |
Heap Segment Array Updates | 21 | 0.02 | 0.00 |
IMU CR rollbacks | 18,373 | 20.35 | 0.07 |
IMU Flushes | 29,871 | 33.09 | 0.12 |
IMU Redo allocation size | 143,624,724 | 159,078.92 | 556.93 |
IMU commits | 168,153 | 186.25 | 0.65 |
IMU contention | 26,336 | 29.17 | 0.10 |
IMU ktichg flush | 0 | 0.00 | 0.00 |
IMU pool not allocated | 59,912 | 66.36 | 0.23 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 376,000,264 | 416,458.36 | 1,458.00 |
IMU- failed to get a private strand | 59,912 | 66.36 | 0.23 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Requests to/from client | 1,988,093 | 2,202.01 | 7.71 |
RowCR - row contention | 276 | 0.31 | 0.00 |
RowCR attempts | 159,698 | 176.88 | 0.62 |
RowCR hits | 156,900 | 173.78 | 0.61 |
SMON posted for undo segment shrink | 26 | 0.03 | 0.00 |
SQL*Net roundtrips to/from client | 1,988,112 | 2,202.04 | 7.71 |
active txn count during cleanout | 60,690 | 67.22 | 0.24 |
application wait time | 220 | 0.24 | 0.00 |
background checkpoints completed | 14 | 0.02 | 0.00 |
background checkpoints started | 14 | 0.02 | 0.00 |
background timeouts | 4,699 | 5.20 | 0.02 |
branch node splits | 4 | 0.00 | 0.00 |
buffer is not pinned count | 285,236,508 | 315,928.31 | 1,106.05 |
buffer is pinned count | 287,542,236 | 318,482.14 | 1,114.99 |
bytes received via SQL*Net from client | 485,538,094 | 537,782.60 | 1,882.75 |
bytes sent via SQL*Net to client | 1,076,635,526 | 1,192,482.85 | 4,174.82 |
calls to get snapshot scn: kcmgss | 1,594,652 | 1,766.24 | 6.18 |
calls to kcmgas | 349,201 | 386.78 | 1.35 |
calls to kcmgcs | 1,018,866 | 1,128.50 | 3.95 |
cell physical IO interconnect bytes | 11,859,735,552 | 13,135,857.87 | 45,987.93 |
change write time | 2,200 | 2.44 | 0.01 |
cleanout - number of ktugct calls | 46,800 | 51.84 | 0.18 |
cleanouts and rollbacks - consistent read gets | 33,596 | 37.21 | 0.13 |
cleanouts only - consistent read gets | 987 | 1.09 | 0.00 |
cluster key scan block gets | 3,867 | 4.28 | 0.01 |
cluster key scans | 3,164 | 3.50 | 0.01 |
commit batch/immediate performed | 33 | 0.04 | 0.00 |
commit batch/immediate requested | 33 | 0.04 | 0.00 |
commit cleanout failures: block lost | 10 | 0.01 | 0.00 |
commit cleanout failures: buffer being written | 39 | 0.04 | 0.00 |
commit cleanout failures: callback failure | 227 | 0.25 | 0.00 |
commit cleanout failures: cannot pin | 7,538 | 8.35 | 0.03 |
commit cleanouts | 1,058,902 | 1,172.84 | 4.11 |
commit cleanouts successfully completed | 1,051,088 | 1,164.19 | 4.08 |
commit immediate performed | 33 | 0.04 | 0.00 |
commit immediate requested | 33 | 0.04 | 0.00 |
commit txn count during cleanout | 72,206 | 79.98 | 0.28 |
concurrency wait time | 1,154 | 1.28 | 0.00 |
consistent changes | 173,518 | 192.19 | 0.67 |
consistent gets | 581,211,846 | 643,750.96 | 2,253.74 |
consistent gets - examination | 379,363,286 | 420,183.25 | 1,471.04 |
consistent gets direct | 12 | 0.01 | 0.00 |
consistent gets from cache | 581,211,847 | 643,750.97 | 2,253.74 |
consistent gets from cache (fastpath) | 201,512,179 | 223,195.14 | 781.39 |
cursor authentications | 47 | 0.05 | 0.00 |
data blocks consistent reads - undo records applied | 160,463 | 177.73 | 0.62 |
db block changes | 3,564,963 | 3,948.56 | 13.82 |
db block gets | 4,822,132 | 5,341.00 | 18.70 |
db block gets direct | 60 | 0.07 | 0.00 |
db block gets from cache | 4,822,072 | 5,340.93 | 18.70 |
db block gets from cache (fastpath) | 1,653,627 | 1,831.56 | 6.41 |
deferred (CURRENT) block cleanout applications | 371,815 | 411.82 | 1.44 |
dirty buffers inspected | 363,770 | 402.91 | 1.41 |
enqueue conversions | 563 | 0.62 | 0.00 |
enqueue releases | 619,926 | 686.63 | 2.40 |
enqueue requests | 619,934 | 686.64 | 2.40 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 1,266 | 1.40 | 0.00 |
execute count | 1,728,268 | 1,914.23 | 6.70 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 15,397,986,732 | 17,054,829.29 | 59,708.04 |
free buffer inspected | 865,517 | 958.65 | 3.36 |
free buffer requested | 878,713 | 973.26 | 3.41 |
heap block compress | 865 | 0.96 | 0.00 |
hot buffers moved to head of LRU | 478,074 | 529.52 | 1.85 |
immediate (CR) block cleanout applications | 34,583 | 38.30 | 0.13 |
immediate (CURRENT) block cleanout applications | 40,597 | 44.97 | 0.16 |
in call idle wait time | 2,555,428 | 2,830.40 | 9.91 |
index crx upgrade (positioned) | 24 | 0.03 | 0.00 |
index fast full scans (full) | 2 | 0.00 | 0.00 |
index fetch by key | 94,692,078 | 104,881.06 | 367.18 |
index scans kdiixs1 | 94,436,438 | 104,597.92 | 366.19 |
leaf node 90-10 splits | 18 | 0.02 | 0.00 |
leaf node splits | 1,958 | 2.17 | 0.01 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 110 | 0.12 | 0.00 |
lob writes unaligned | 110 | 0.12 | 0.00 |
logical read bytes from cache | 4,800,790,085,632 | 5,317,361,079.81 | 18,615,794.79 |
logons cumulative | 27 | 0.03 | 0.00 |
max cf enq hold time | 30 | 0.03 | 0.00 |
messages received | 288,184 | 319.19 | 1.12 |
messages sent | 288,184 | 319.19 | 1.12 |
min active SCN optimization applied on CR | 225,820 | 250.12 | 0.88 |
no buffer to keep pinned count | 3 | 0.00 | 0.00 |
no work - consistent read gets | 200,598,432 | 222,183.07 | 777.85 |
non-idle wait count | 3,587,074 | 3,973.05 | 13.91 |
non-idle wait time | 986,124 | 1,092.23 | 3.82 |
opened cursors cumulative | 1,727,506 | 1,913.39 | 6.70 |
parse count (describe) | 7 | 0.01 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 332 | 0.37 | 0.00 |
parse count (total) | 1,437 | 1.59 | 0.01 |
parse time cpu | 3,139 | 3.48 | 0.01 |
parse time elapsed | 4,361 | 4.83 | 0.02 |
physical read IO requests | 773,429 | 856.65 | 3.00 |
physical read bytes | 6,341,222,400 | 7,023,545.83 | 24,589.06 |
physical read total IO requests | 776,320 | 859.85 | 3.01 |
physical read total bytes | 6,387,666,944 | 7,074,987.87 | 24,769.15 |
physical read total multi block requests | 2 | 0.00 | 0.00 |
physical reads | 774,075 | 857.37 | 3.00 |
physical reads cache | 773,993 | 857.28 | 3.00 |
physical reads cache prefetch | 676 | 0.75 | 0.00 |
physical reads direct | 82 | 0.09 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 383,680 | 424.96 | 1.49 |
physical write bytes | 4,275,765,248 | 4,735,842.92 | 16,579.93 |
physical write total IO requests | 876,098 | 970.37 | 3.40 |
physical write total bytes | 5,472,060,416 | 6,060,860.93 | 21,218.75 |
physical write total multi block requests | 362 | 0.40 | 0.00 |
physical writes | 521,944 | 578.11 | 2.02 |
physical writes direct | 130 | 0.14 | 0.00 |
physical writes direct (lob) | 13 | 0.01 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 521,814 | 577.96 | 2.02 |
physical writes non checkpoint | 426,917 | 472.85 | 1.66 |
pinned buffers inspected | 95 | 0.11 | 0.00 |
pinned cursors current | 5 | 0.01 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 2 | 0.00 | 0.00 |
process last non-idle time | 520 | 0.58 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 289,598 | 320.76 | 1.12 |
recursive cpu usage | 2,360 | 2.61 | 0.01 |
redo KB read | 0 | 0.00 | 0.00 |
redo blocks checksummed by FG (exclusive) | 296,116 | 327.98 | 1.15 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 1,147,045 | 1,270.47 | 4.45 |
redo buffer allocation retries | 443 | 0.49 | 0.00 |
redo entries | 1,192,536 | 1,320.85 | 4.62 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo log space requests | 471 | 0.52 | 0.00 |
redo log space wait time | 1,869 | 2.07 | 0.01 |
redo ordering marks | 11,159 | 12.36 | 0.04 |
redo size | 498,530,952 | 552,173.50 | 1,933.13 |
redo size for direct writes | 780 | 0.86 | 0.00 |
redo subscn max counts | 28,537 | 31.61 | 0.11 |
redo synch long waits | 847 | 0.94 | 0.00 |
redo synch time | 26,962 | 29.86 | 0.10 |
redo synch time (usec) | 269,626,508 | 298,638.66 | 1,045.52 |
redo synch writes | 257,926 | 285.68 | 1.00 |
redo wastage | 70,121,084 | 77,666.20 | 271.91 |
redo write time | 12,621 | 13.98 | 0.05 |
redo writes | 242,728 | 268.85 | 0.94 |
rollback changes - undo records applied | 125 | 0.14 | 0.00 |
rollbacks only - consistent read gets | 41,584 | 46.06 | 0.16 |
rows fetched via callback | 94,478,496 | 104,644.50 | 366.35 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 90,015 | 99.70 | 0.35 |
session logical reads | 586,033,175 | 649,091.07 | 2,272.43 |
shared hash latch upgrades - no wait | 428,124 | 474.19 | 1.66 |
shared hash latch upgrades - wait | 54 | 0.06 | 0.00 |
sorts (memory) | 2,106 | 2.33 | 0.01 |
sorts (rows) | 27,417 | 30.37 | 0.11 |
sql area evicted | 310 | 0.34 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 3,184,848 | 3,527.54 | 12.35 |
switch current to new buffer | 712 | 0.79 | 0.00 |
table fetch by rowid | 191,823,399 | 212,463.84 | 743.82 |
table fetch continued row | 165 | 0.18 | 0.00 |
table scan blocks gotten | 8,684,649 | 9,619.13 | 33.68 |
table scan rows gotten | 310,139,845 | 343,511.28 | 1,202.61 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 309,789 | 343.12 | 1.20 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 4,930 | 5.46 | 0.02 |
total number of cf enq holders | 90 | 0.10 | 0.00 |
total number of times SMON posted | 41 | 0.05 | 0.00 |
transaction rollbacks | 32 | 0.04 | 0.00 |
undo change vector size | 164,305,732 | 181,985.23 | 637.12 |
user I/O wait time | 941,289 | 1,042.57 | 3.65 |
user calls | 3,657,716 | 4,051.29 | 14.18 |
user commits | 257,888 | 285.64 | 1.00 |
workarea executions - optimal | 1,032 | 1.14 | 0.00 |
write clones created in foreground | 670 | 0.74 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
logons current | 59 | 74 |
session uga memory max | 389,241,744 | 438,292,728 |
session pga memory | 189,926,704 | 226,155,536 |
session pga memory max | 346,674,448 | 406,137,136 |
session cursor cache count | 3,445 | 4,082 |
session uga memory | 47,278,308,064 | 51,580,682,632 |
opened cursors current | 101 | 132 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 14 | 55.82 |
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 | 5.9G | 858.17 | 6.70984 | 0M | 0.00 | 0M | 774.8K | 11.67 |
DBWR | 0M | 0.00 | 0M | 4G | 425.92 | 4.52565 | 0 | |
LGWR | 6M | 0.46 | .006645 | 1.1G | 545.40 | 1.24715 | 243.9K | 0.27 |
Others | 38M | 2.76 | .042088 | 16M | 1.14 | .017721 | 3004 | 4.22 |
Direct Writes | 0M | 0.00 | 0M | 1M | 0.05 | .001107 | 0 | |
Streams AQ | 1M | 0.01 | .001107 | 0M | 0.00 | 0M | 8 | 17.13 |
Direct Reads | 0M | 0.08 | 0M | 0M | 0.03 | 0M | 0 | |
TOTAL: | 6G | 861.48 | 6.75969 | 5.1G | 972.54 | 5.79164 | 1021.6K | 8.93 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 5.9G | 858.27 | 6.70984 | 4G | 425.76 | 4.52344 | 11.67 | 10.50 |
Log File | 0M | 0.06 | 0M | 1.1G | 545.06 | 1.24272 | 9.79 | |
Control File | 44M | 3.14 | .048734 | 21M | 1.47 | .023259 | 4.86 | |
Temp File | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 12.00 | |
TOTAL: | 6G | 861.47 | 6.75858 | 5.1G | 972.30 | 5.78943 | 11.64 | 10.50 |
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 | 5.9G | 858.70 | 6.71427 | 0M | 0.00 | 0M | 775.2K | 11.67 |
Buffer Cache Reads (Data File) | 5.9G | 858.70 | 6.71427 | 0M | 0.00 | 0M | 775.2K | 11.67 |
DBWR | 0M | 0.00 | 0M | 4G | 426.16 | 4.52898 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 4G | 426.16 | 4.52898 | 0 | |
LGWR | 6M | 0.46 | .006645 | 1.1G | 545.69 | 1.24715 | 469 | 4.24 |
LGWR (Log File) | 0M | 0.06 | 0M | 1.1G | 545.35 | 1.24272 | 112 | 4.89 |
LGWR (Control File) | 6M | 0.40 | .006645 | 4M | 0.34 | .004430 | 357 | 4.04 |
Others | 39M | 2.76 | .043196 | 16M | 1.14 | .017721 | 2495 | 4.98 |
Others (Control File) | 39M | 2.74 | .043196 | 16M | 1.13 | .017721 | 2478 | 4.98 |
Others (Data File) | 0M | 0.02 | 0M | 0M | 0.01 | 0M | 17 | 6.06 |
Direct Writes | 0M | 0.00 | 0M | 1M | 0.05 | .001107 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 1M | 0.05 | .001107 | 0 | |
Streams AQ | 1M | 0.01 | .001107 | 0M | 0.00 | 0M | 8 | 17.13 |
Streams AQ (Data File) | 1M | 0.01 | .001107 | 0M | 0.00 | 0M | 8 | 17.13 |
Direct Reads | 0M | 0.08 | 0M | 0M | 0.03 | 0M | 0 | |
Direct Reads (Data File) | 0M | 0.08 | 0M | 0M | 0.03 | 0M | 0 | |
TOTAL: | 6G | 862.01 | 6.76522 | 5.1G | 973.07 | 5.79496 | 778.2K | 11.64 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SOE | 769,580 | 852 | 12.11 | 1.00 | 379,976 | 421 | 5,012 | 10.30 |
UNDOTBS1 | 89 | 0 | 10.67 | 1.00 | 2,817 | 3 | 113 | 0.27 |
SYSAUX | 1,333 | 1 | 6.88 | 1.24 | 609 | 1 | 0 | 0.00 |
SYSTEM | 1,214 | 1 | 9.32 | 1.27 | 32 | 0 | 63 | 2.38 |
USERS | 14 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
TEMP | 2 | 0 | 15.00 | 1.00 | 4 | 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) |
---|---|---|---|---|---|---|---|---|---|
SOE | +DATA/dbm11203/datafile/soe.486.836957131 | 769,580 | 852 | 12.11 | 1.00 | 379,976 | 421 | 5,012 | 10.30 |
SYSAUX | +DATA/dbm11203/datafile/sysaux.460.772715927 | 1,333 | 1 | 6.88 | 1.24 | 609 | 1 | 0 | 0.00 |
SYSTEM | +DATA/dbm11203/datafile/system.459.772715923 | 1,214 | 1 | 9.32 | 1.27 | 32 | 0 | 63 | 2.38 |
TEMP | +DATA/dbm11203/tempfile/temp.462.772715931 | 2 | 0 | 15.00 | 1.00 | 4 | 0 | 0 | |
UNDOTBS1 | +DATA/dbm11203/datafile/undotbs1.461.772715929 | 89 | 0 | 10.67 | 1.00 | 2,817 | 3 | 113 | 0.27 |
USERS | +DATA/dbm11203/datafile/users.463.772715939 | 14 | 0 | 0.00 | 1.00 | 14 | 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 | 89,362 | 100 | 582,128,444 | 773,555 | 521,818 | 0 | 0 | 5,181 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 28,544 | 0 | 0 | 0 | 3,356 |
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 | 18 | 16165 | 167866 | 165888 | 165888 | 417367 | |||
E | 0 | 18 | 16018 | 169373 | 165888 | 165888 | 413717 |
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 | 72 | 0.10 | 9 | 364.24 | 2,505,397 | 1 | 23766393.00 |
D | 144 | 0.20 | 18 | 276.05 | 1,898,816 | 1 | 18012189.00 |
D | 216 | 0.30 | 27 | 152.99 | 1,052,319 | 1 | 9982087.00 |
D | 288 | 0.40 | 35 | 9.94 | 68,368 | 1 | 648053.00 |
D | 360 | 0.49 | 44 | 1.42 | 9,753 | 1 | 92020.00 |
D | 432 | 0.59 | 53 | 1.26 | 8,678 | 1 | 81821.00 |
D | 504 | 0.69 | 62 | 1.16 | 8,011 | 1 | 75497.00 |
D | 576 | 0.79 | 71 | 1.10 | 7,550 | 1 | 71123.00 |
D | 648 | 0.89 | 80 | 1.04 | 7,186 | 1 | 67671.00 |
D | 720 | 0.99 | 88 | 1.00 | 6,906 | 1 | 65006.00 |
D | 728 | 1.00 | 89 | 1.00 | 6,878 | 1 | 64749.00 |
D | 792 | 1.09 | 97 | 0.97 | 6,672 | 1 | 62794.00 |
D | 864 | 1.19 | 106 | 0.94 | 6,474 | 1 | 60909.00 |
D | 936 | 1.29 | 115 | 0.92 | 6,297 | 1 | 59230.00 |
D | 1,008 | 1.38 | 124 | 0.89 | 6,133 | 1 | 57681.00 |
D | 1,080 | 1.48 | 133 | 0.87 | 5,980 | 1 | 56222.00 |
D | 1,152 | 1.58 | 141 | 0.85 | 5,848 | 1 | 54977.00 |
D | 1,224 | 1.68 | 150 | 0.83 | 5,729 | 1 | 53845.00 |
D | 1,296 | 1.78 | 159 | 0.81 | 5,559 | 1 | 52232.00 |
D | 1,368 | 1.88 | 168 | 0.71 | 4,879 | 1 | 45778.00 |
D | 1,440 | 1.98 | 177 | 0.62 | 4,241 | 1 | 39734.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 73 | 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 | 128 | 8 | 184.92 | 0.00 | 0.00 | 0.00 | 0.00 | 26,214 |
E | 128 | 8 | 217.02 | 0.00 | 0.00 | 0.00 | 0.00 | 26,214 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 947 | 947 | 0 | 0 |
64K | 128K | 9 | 9 | 0 | 0 |
128K | 256K | 3 | 3 | 0 | 0 |
512K | 1024K | 55 | 55 | 0 | 0 |
1M | 2M | 6 | 6 | 0 | 0 |
4M | 8M | 4 | 4 | 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 |
---|---|---|---|---|---|---|
16 | 0.13 | 1,680.06 | 31.69 | 98.00 | 11 | 2,814,750 |
32 | 0.25 | 1,680.06 | 31.69 | 98.00 | 11 | 2,814,750 |
64 | 0.50 | 1,680.06 | 31.69 | 98.00 | 11 | 2,814,750 |
96 | 0.75 | 1,680.06 | 31.69 | 98.00 | 11 | 2,814,750 |
128 | 1.00 | 1,680.06 | 0.00 | 100.00 | 11 | 2,762,644 |
154 | 1.20 | 1,680.06 | 0.00 | 100.00 | 1 | 2,762,644 |
179 | 1.40 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
205 | 1.60 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
230 | 1.80 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
256 | 2.00 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
384 | 3.00 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
512 | 4.00 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
768 | 6.00 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
1,024 | 8.00 | 1,680.06 | 0.00 | 100.00 | 0 | 2,762,644 |
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) |
---|---|---|---|---|---|---|---|---|
232 | 0.89 | 22 | 1,535 | 15,516 | 0.97 | 845 | 2.13 | 5,793 |
236 | 0.91 | 25 | 1,690 | 15,588 | 0.98 | 773 | 1.95 | 5,795 |
240 | 0.92 | 28 | 1,864 | 15,693 | 0.98 | 668 | 1.68 | 5,797 |
244 | 0.94 | 31 | 1,997 | 15,733 | 0.99 | 628 | 1.58 | 5,797 |
248 | 0.95 | 35 | 2,156 | 15,783 | 0.99 | 578 | 1.46 | 5,798 |
252 | 0.97 | 39 | 2,270 | 15,833 | 0.99 | 528 | 1.33 | 5,799 |
256 | 0.98 | 42 | 2,301 | 15,897 | 1.00 | 464 | 1.17 | 5,800 |
260 | 1.00 | 45 | 2,501 | 15,964 | 1.00 | 397 | 1.00 | 5,804 |
264 | 1.02 | 49 | 2,660 | 15,967 | 1.00 | 394 | 0.99 | 5,804 |
268 | 1.03 | 53 | 2,851 | 15,967 | 1.00 | 394 | 0.99 | 5,804 |
272 | 1.05 | 56 | 2,959 | 15,969 | 1.00 | 392 | 0.99 | 5,804 |
276 | 1.06 | 60 | 3,188 | 15,969 | 1.00 | 392 | 0.99 | 5,804 |
280 | 1.08 | 64 | 3,394 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
284 | 1.09 | 68 | 3,600 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
288 | 1.11 | 72 | 3,806 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
292 | 1.12 | 76 | 4,012 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
296 | 1.14 | 80 | 4,271 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
316 | 1.22 | 99 | 5,445 | 15,970 | 1.00 | 391 | 0.98 | 5,804 |
344 | 1.32 | 126 | 6,320 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
372 | 1.43 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
400 | 1.54 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
428 | 1.65 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
456 | 1.75 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
484 | 1.86 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
512 | 1.97 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
540 | 2.08 | 126 | 6,329 | 15,971 | 1.00 | 390 | 0.98 | 5,805 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
512 | 0.50 | 10,148,365 | 1,079,936,247 |
768 | 0.75 | 101,251 | 8,232,006 |
1,024 | 1.00 | 88,590 | 6,856,577 |
1,280 | 1.25 | 83,170 | 6,303,251 |
1,536 | 1.50 | 77,634 | 5,712,900 |
1,792 | 1.75 | 64,931 | 4,358,040 |
2,048 | 2.00 | 64,931 | 4,358,040 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
4 | 0.50 | 0 | 0 | 0 | 0 |
8 | 1.00 | 0 | 0 | 0 | 0 |
12 | 1.50 | 0 | 0 | 0 | 0 |
16 | 2.00 | 0 | 0 | 0 | 0 |
20 | 2.50 | 0 | 0 | 0 | 0 |
24 | 3.00 | 0 | 0 | 0 | 0 |
28 | 3.50 | 0 | 0 | 0 | 0 |
32 | 4.00 | 0 | 0 | 0 | 0 |
36 | 4.50 | 0 | 0 | 0 | 0 |
40 | 5.00 | 0 | 0 | 0 | 0 |
44 | 5.50 | 0 | 0 | 0 | 0 |
48 | 6.00 | 0 | 0 | 0 | 0 |
52 | 6.50 | 0 | 0 | 0 | 0 |
56 | 7.00 | 0 | 0 | 0 | 0 |
60 | 7.50 | 0 | 0 | 0 | 0 |
64 | 8.00 | 0 | 0 | 0 | 0 |
68 | 8.50 | 0 | 0 | 0 | 0 |
72 | 9.00 | 0 | 0 | 0 | 0 |
76 | 9.50 | 0 | 0 | 0 | 0 |
80 | 10.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 5,028 | 52 | 10 |
segment header | 22 | 0 | 4 |
3rd level bmb | 11 | 0 | 4 |
2nd level bmb | 9 | 0 | 3 |
undo header | 44 | 0 | 0 |
undo block | 69 | 0 | 0 |
1st level bmb | 2 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 1,236 | 1,236 | 0 | 1,230 | 2 | 1.80 |
TX-Transaction (index contention) | 415 | 415 | 0 | 32 | 0 | 15.00 |
HW-Segment High Water Mark | 346 | 346 | 0 | 4 | 0 | 27.50 |
TX-Transaction | 260,161 | 260,162 | 0 | 1 | 0 | 70.00 |
CU-Cursor | 349 | 349 | 0 | 1 | 0 | 10.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 | 26.58 | 313,610 | 938 | 31 | 19.6/29.6 | 0/0 | 0/0/0/0/0/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 |
---|---|---|---|---|---|---|---|
23-Apr 19:43 | 14,853 | 175,772 | 336 | 31 | 20 | 0/0 | 0/0/0/0/0/0 |
23-Apr 19:33 | 11,722 | 137,838 | 938 | 27 | 30 | 0/0 | 0/0/0/0/0/0 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ deq hash table latch | 2 | 0.00 | 0 | 0 | ||
ASM Keyed state latch | 37 | 0.00 | 0 | 0 | ||
ASM allocation | 172 | 0.00 | 0 | 0 | ||
ASM db client latch | 698 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 70 | 1.43 | 0.00 | 0 | 0 | |
ASM map operation hash table | 3,306,049 | 0.00 | 0.07 | 0 | 0 | |
ASM network background latch | 453 | 0.00 | 0 | 0 | ||
ASM network state latch | 293 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 6,989 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 302 | 0.00 | 0 | 0 | ||
Consistent RBA | 242,581 | 0.00 | 0.67 | 0 | 0 | |
DML lock allocation | 698,726 | 0.01 | 0.08 | 0 | 0 | |
Event Group Locks | 55 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 270 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
I/O Staticstics latch | 2 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 2 | 0.00 | 0 | 0 | ||
In memory undo latch | 1,391,681 | 0.03 | 0.65 | 0 | 257,954 | 0.00 |
JS Sh mem access | 4 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 2 | 0.00 | 0 | 0 | ||
JS queue access latch | 4 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 5,502 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 6 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 2 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 2 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 2 | 0.00 | 0 | 0 | ||
KFK SGA Libload latch | 217 | 0.00 | 0 | 0 | ||
KFMD SGA | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 2 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 2 | 0.00 | 0 | 0 | ||
KJC message pool free list | 2 | 0.00 | 0 | 0 | ||
KJCT flow control latch | 2 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 302 | 0.00 | 0 | 0 | ||
KTF sga latch | 5 | 0.00 | 0 | 303 | 0.00 | |
KWQMN job cache list latch | 1 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 117 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 2 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 2 | 0.00 | 0 | 0 | ||
Lsod array latch | 266 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 18 | 0.00 | ||
Memory Management Latch | 2 | 0.00 | 0 | 302 | 0.00 | |
Memory Queue | 120 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 2 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 2 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 10 | 0.00 | 0 | 0 | ||
Mutex | 2 | 0.00 | 0 | 0 | ||
Mutex Stats | 2 | 0.00 | 0 | 0 | ||
OS process | 116 | 0.00 | 0 | 0 | ||
OS process allocation | 1,881 | 0.00 | 0 | 0 | ||
OS process: request allocation | 37 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 81 | 0.00 | 0 | 0 | ||
PX hash array latch | 2 | 0.00 | 0 | 0 | ||
QMT | 2 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 496 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 13 | 0.00 | 0 | 13 | 0.00 | |
SGA blob parent | 2 | 0.00 | 0 | 0 | ||
SGA bucket locks | 2 | 0.00 | 0 | 0 | ||
SGA heap locks | 2 | 0.00 | 0 | 0 | ||
SGA pool locks | 2 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 2 | 0.00 | 0 | 298 | 0.00 | |
SQL memory manager workarea list latch | 20,358 | 0.00 | 0 | 0 | ||
Shared B-Tree | 722 | 0.00 | 0 | 0 | ||
Streams Generic | 2 | 0.00 | 0 | 0 | ||
Testing | 2 | 0.00 | 0 | 0 | ||
Token Manager | 2 | 0.00 | 0 | 0 | ||
WCR: sync | 2 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 2 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 2 | 0.00 | 0 | 0 | ||
XDB unused session pool | 2 | 0.00 | 0 | 0 | ||
XDB used session pool | 2 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 44,120 | 0.00 | 0 | 0 | ||
active service list | 1,837 | 0.05 | 0.00 | 0 | 2,231 | 0.00 |
begin backup scn array | 15 | 0.00 | 0 | 0 | ||
bq:time manger info latch | 32 | 0.00 | 0 | 0 | ||
buffer pool | 2 | 0.00 | 0 | 0 | ||
bufq statistics | 118 | 0.00 | 0 | 0 | ||
business card | 2 | 0.00 | 0 | 0 | ||
cache buffer handles | 19,007 | 0.11 | 0.00 | 0 | 0 | |
cache buffers chains | 804,374,724 | 0.19 | 0.00 | 0 | 879,973 | 0.02 |
cache buffers lru chain | 703,390 | 0.06 | 0.05 | 0 | 1,452,909 | 0.11 |
cache table scan latch | 88 | 0.00 | 0 | 88 | 0.00 | |
call allocation | 1,019 | 0.00 | 0 | 0 | ||
cas latch | 2 | 0.00 | 0 | 0 | ||
change notification client cache latch | 2 | 0.00 | 0 | 0 | ||
channel handle pool latch | 39 | 0.00 | 0 | 0 | ||
channel operations parent latch | 6,981 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 2,062,780 | 0.01 | 0.01 | 0 | 515,051 | 0.01 |
client/application info | 152 | 0.00 | 0 | 0 | ||
compile environment latch | 27 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 407 | 0.00 | 0 | 0 | ||
cp cmon/server latch | 2 | 0.00 | 0 | 0 | ||
cp pool latch | 2 | 0.00 | 0 | 0 | ||
cp server hash latch | 2 | 0.00 | 0 | 0 | ||
cp sga latch | 113 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 2 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 113 | 0.00 | 0 | 0 | ||
dml lock allocation | 113 | 0.00 | 0 | 0 | ||
done queue latch | 2 | 0.00 | 0 | 0 | ||
dummy allocation | 41 | 0.00 | 0 | 0 | ||
enqueue freelist latch | 2 | 0.00 | 0 | 19,901 | 0.00 | |
enqueue hash chains | 1,240,957 | 0.04 | 0.06 | 0 | 2 | 0.00 |
enqueues | 41 | 0.00 | 0 | 0 | ||
fifth spare latch | 2 | 0.00 | 0 | 0 | ||
file cache latch | 235 | 0.00 | 0 | 0 | ||
flashback copy | 2 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
gc element | 2 | 0.00 | 0 | 0 | ||
gcs commit scn state | 2 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 2 | 0.00 | 0 | 0 | ||
gcs pcm hashed value bucket hash | 2 | 0.00 | 0 | 0 | ||
gcs resource freelist | 2 | 0.00 | 0 | 0 | ||
gcs resource hash | 2 | 0.00 | 0 | 0 | ||
gcs resource scan list | 2 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 2 | 0.00 | 0 | 0 | ||
ges domain table | 2 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 2 | 0.00 | 0 | 0 | ||
ges group table | 2 | 0.00 | 0 | 0 | ||
ges process hash list | 2 | 0.00 | 0 | 0 | ||
ges process parent latch | 2 | 0.00 | 0 | 0 | ||
ges resource hash list | 2 | 0.00 | 0 | 0 | ||
ges resource scan list | 2 | 0.00 | 0 | 0 | ||
ges resource table freelist | 2 | 0.00 | 0 | 0 | ||
ges value block free list | 2 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 15 | 0.00 | 0 | 0 | ||
global tx hash mapping | 2 | 0.00 | 0 | 0 | ||
granule operation | 2 | 0.00 | 0 | 0 | ||
hash table column usage latch | 292 | 0.00 | 0 | 12,291 | 0.00 | |
hash table modification latch | 2 | 0.00 | 0 | 0 | ||
heartbeat check | 2 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latch | 3 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 2 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 2 | 0.00 | 0 | 0 | ||
job workq parent latch | 3 | 0.00 | 0 | 1 | 0.00 | |
job_queue_processes free list latch | 4 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 198 | 0.00 | 0 | 0 | ||
k2q lock allocation | 2 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 14 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 2 | 0.00 | 0 | 0 | ||
kgb parent | 2 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 2 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 8 | 0.00 | 0 | 0 | ||
ksfv messages | 2 | 0.00 | 0 | 0 | ||
ksim group membership cache | 2 | 0.00 | 0 | 0 | ||
kss move lock | 20 | 0.00 | 0 | 0 | ||
ksuosstats global area | 97 | 0.00 | 0 | 0 | ||
ksv allocation latch | 149 | 0.00 | 0 | 0 | ||
ksv class latch | 816 | 0.37 | 0.00 | 0 | 0 | |
ksv instance latch | 4 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 2 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 37 | 0.00 | 0 | 0 | ||
ktm global data | 157 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 561 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 244,261 | 0.00 | 0.00 | 0 | 0 | |
list of block allocation | 99 | 0.00 | 0 | 0 | ||
loader state object freelist | 238 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 2 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 4 | 0.00 | 0 | 0 | ||
lob segment query latch | 2 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 2 | 0.00 | 0 | 0 | ||
logical standby cache | 2 | 0.00 | 0 | 0 | ||
logminer context allocation | 3 | 0.00 | 0 | 0 | ||
logminer work area | 2 | 0.00 | 0 | 0 | ||
longop free list parent | 2 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 2 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 245 | 0.00 | 0 | 0 | ||
messages | 852,994 | 0.03 | 0.01 | 0 | 0 | |
mostly latch-free SCN | 247,788 | 0.39 | 0.03 | 0 | 0 | |
msg queue latch | 2 | 0.00 | 0 | 0 | ||
multiblock read objects | 306 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 2 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 113 | 0.00 | 0 | 0 | ||
object queue header heap | 353,981 | 0.00 | 0 | 1,847 | 0.00 | |
object queue header operation | 3,523,023 | 0.03 | 0.05 | 0 | 0 | |
object stats modification | 337 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 122 | 0.00 | 0 | 0 | ||
parallel query stats | 2 | 0.00 | 0 | 0 | ||
parameter list | 140 | 2.14 | 0.00 | 0 | 0 | |
parameter table management | 86 | 0.00 | 0 | 0 | ||
peshm | 2 | 0.00 | 0 | 0 | ||
pesom_free_list | 2 | 0.00 | 0 | 0 | ||
pesom_hash_node | 2 | 0.00 | 0 | 0 | ||
post/wait queue | 373,240 | 0.01 | 0.02 | 0 | 258,758 | 0.08 |
process allocation | 48 | 0.00 | 0 | 26 | 0.00 | |
process group creation | 37 | 0.00 | 0 | 0 | ||
process queue | 2 | 0.00 | 0 | 0 | ||
process queue reference | 2 | 0.00 | 0 | 0 | ||
qmn task queue latch | 845 | 0.00 | 0 | 0 | ||
query server freelists | 2 | 0.00 | 0 | 0 | ||
queued dump request | 3 | 0.00 | 0 | 0 | ||
queuing load statistics | 2 | 0.00 | 0 | 0 | ||
recovery domain hash list | 2 | 0.00 | 0 | 0 | ||
redo allocation | 1,141,712 | 0.09 | 0.04 | 0 | 1,190,515 | 0.39 |
redo copy | 2 | 0.00 | 0 | 1,192,298 | 0.31 | |
redo writing | 775,992 | 0.01 | 0.04 | 0 | 0 | |
resmgr group change latch | 17 | 5.88 | 0.00 | 0 | 0 | |
resmgr:active threads | 41 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 27 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 2 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 39 | 0.00 | 0 | 0 | ||
resmgr:plan CPU method | 2 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 2 | 0.00 | 0 | 0 | ||
resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 2 | 0.00 | 0 | 0 | ||
rm cas latch | 2 | 0.00 | 0 | 0 | ||
row cache objects | 55,238 | 0.11 | 0.13 | 0 | 688 | 0.00 |
rules engine rule set statistics | 200 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 2 | 0.00 | 0 | 0 | ||
second spare latch | 2 | 0.00 | 0 | 0 | ||
sequence cache | 216,625 | 0.04 | 0.02 | 0 | 0 | |
session allocation | 257,900 | 0.02 | 0.04 | 0 | 257,892 | 0.00 |
session idle bit | 7,568,121 | 0.02 | 0.04 | 0 | 0 | |
session queue latch | 2 | 0.00 | 0 | 0 | ||
session state list latch | 66 | 0.00 | 0 | 0 | ||
session switching | 126 | 0.00 | 0 | 0 | ||
session timer | 363 | 0.00 | 0 | 0 | ||
shared pool | 32,027 | 0.17 | 0.25 | 0 | 0 | |
shared pool sim alloc | 15 | 0.00 | 0 | 0 | ||
shared pool simulator | 2,248 | 0.00 | 0 | 0 | ||
sim partition latch | 2 | 0.00 | 0 | 0 | ||
simulator hash latch | 34,366,849 | 0.01 | 0.02 | 0 | 0 | |
simulator lru latch | 32,455 | 1.27 | 0.02 | 0 | 34,281,500 | 1.38 |
sort extent pool | 169 | 0.00 | 0 | 0 | ||
space background state object latch | 4 | 0.00 | 0 | 0 | ||
space background task latch | 1,531 | 0.46 | 0.00 | 0 | 611 | 0.00 |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 336 | 0.00 | 0 | 0 | ||
tablespace key chain | 2 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 2 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 2 | 0.00 | 0 | 0 | ||
third spare latch | 2 | 0.00 | 0 | 0 | ||
threshold alerts latch | 38 | 0.00 | 0 | 0 | ||
trace latch | 11 | 0.00 | 0 | 0 | ||
transaction allocation | 108 | 0.00 | 0 | 0 | ||
undo global data | 1,411,978 | 0.02 | 0.02 | 0 | 0 | |
virtual circuit buffers | 2 | 0.00 | 0 | 0 | ||
virtual circuit holder | 2 | 0.00 | 0 | 0 | ||
virtual circuit queues | 2 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 804,374,724 | 1,488,116 | 1,355 | 1,486,761 |
simulator hash latch | 34,366,849 | 4,316 | 100 | 4,217 |
session idle bit | 7,568,121 | 1,281 | 54 | 1,227 |
object queue header operation | 3,523,023 | 1,146 | 54 | 1,093 |
redo allocation | 1,141,712 | 1,022 | 44 | 978 |
mostly latch-free SCN | 247,788 | 958 | 29 | 929 |
enqueue hash chains | 1,240,957 | 459 | 28 | 431 |
cache buffers lru chain | 703,390 | 432 | 23 | 410 |
simulator lru latch | 32,455 | 413 | 9 | 404 |
In memory undo latch | 1,391,681 | 395 | 257 | 140 |
undo global data | 1,411,978 | 266 | 6 | 260 |
messages | 852,994 | 253 | 3 | 250 |
checkpoint queue latch | 2,062,780 | 124 | 1 | 123 |
sequence cache | 216,625 | 95 | 2 | 93 |
DML lock allocation | 698,726 | 84 | 7 | 77 |
row cache objects | 55,238 | 60 | 8 | 52 |
session allocation | 257,900 | 57 | 2 | 55 |
shared pool | 32,027 | 56 | 14 | 50 |
post/wait queue | 373,240 | 49 | 1 | 48 |
redo writing | 775,992 | 49 | 2 | 47 |
ASM map operation hash table | 3,306,049 | 14 | 1 | 13 |
Consistent RBA | 242,581 | 3 | 2 | 1 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
ASM map operation hash table | kffmDoDone_1 | 0 | 1 | 0 |
DML lock allocation | ktaiam | 0 | 7 | 6 |
In memory undo latch | ktiFlush: child | 0 | 185 | 77 |
In memory undo latch | kticmt: child | 0 | 82 | 35 |
In memory undo latch | ktichg: child | 0 | 11 | 134 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 334 | 146 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 287 | 443 |
cache buffers chains | kcbget: fast exchange | 0 | 267 | 16 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 242 | 65 |
cache buffers chains | kcbgtcr: fast path | 0 | 178 | 556 |
cache buffers chains | kcbgtcr_2 | 0 | 163 | 89 |
cache buffers chains | kcbgtcr_1 | 0 | 65 | 0 |
cache buffers chains | kcbgcur_4 | 0 | 59 | 4 |
cache buffers chains | kcbgcur_2 | 0 | 45 | 13 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 30 | 0 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 28 | 35 |
cache buffers chains | kcbrls: fast release | 0 | 25 | 255 |
cache buffers chains | kcbzwb | 0 | 25 | 21 |
cache buffers chains | kcbnew: new latch again | 0 | 19 | 2 |
cache buffers chains | kcbget: fast path | 0 | 9 | 1 |
cache buffers chains | kcbnlc | 0 | 8 | 8 |
cache buffers chains | kcbchg1: aux pin | 0 | 7 | 6 |
cache buffers chains | kcbzib: finish processing buffer | 0 | 7 | 4 |
cache buffers chains | kcbbic2 | 0 | 6 | 1 |
cache buffers chains | kcb_pre_apply: kcbhq61 | 0 | 5 | 9 |
cache buffers chains | kcb_post_apply: kcbhq62 | 0 | 4 | 1 |
cache buffers chains | kcbchg1: clear MS bit | 0 | 3 | 13 |
cache buffers chains | kcbzib: exchange rls | 0 | 3 | 8 |
cache buffers chains | kcbzpbuf | 0 | 3 | 9 |
cache buffers chains | kcbbic1 | 0 | 2 | 4 |
cache buffers chains | kcbget: release shr | 0 | 2 | 6 |
cache buffers chains | kcbnew_1 | 0 | 2 | 0 |
cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 2 | 0 |
cache buffers chains | kcbget: pin buffer | 0 | 1 | 0 |
cache buffers chains | kcbrls_2 | 0 | 1 | 28 |
cache buffers lru chain | kcbzgws | 0 | 22 | 0 |
cache buffers lru chain | kcbzgb | 0 | 1 | 0 |
checkpoint queue latch | kcbklbc_cql | 0 | 1 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 19 | 12 |
enqueue hash chains | ksqrcl | 0 | 8 | 15 |
enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 1 | 1 |
lgwr LWN SCN | kcs023 | 0 | 15 | 0 |
messages | ksaamb: after wakeup | 0 | 3 | 1 |
mostly latch-free SCN | kcslcu3 | 0 | 14 | 29 |
mostly latch-free SCN | kcsnew_scn_rba | 0 | 2 | 0 |
object queue header operation | kcbo_switch_cq | 0 | 14 | 30 |
object queue header operation | kcbo_switch_mq_bg | 0 | 13 | 2 |
object queue header operation | kcbo_unlink_q | 0 | 13 | 17 |
object queue header operation | kcbo_link_q | 0 | 11 | 2 |
object queue header operation | kcbo_check_flist | 0 | 3 | 3 |
object queue header operation | kcbo_switch_q_bg | 0 | 2 | 2 |
post/wait queue | ksliwat:add:nowait | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 39 | 0 |
redo allocation | kcrf_pvt_strand_bind | 0 | 3 | 4 |
redo allocation | kcrf_pvt_strand_unbind | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 1 | 0 |
redo writing | kcrfw_cal_target_rba | 0 | 1 | 0 |
redo writing | kcrfwcr | 0 | 1 | 1 |
row cache objects | kqreqd | 0 | 3 | 1 |
row cache objects | kqreqd: reget | 0 | 3 | 0 |
row cache objects | kqrpre: find obj | 0 | 1 | 2 |
row cache objects | kqrso | 0 | 1 | 0 |
sequence cache | kdnssd | 0 | 2 | 0 |
session allocation | ksucri_int : SSO | 0 | 1 | 0 |
session allocation | ksuxds | 0 | 1 | 2 |
session idle bit | ksupuc: set busy | 0 | 35 | 22 |
session idle bit | ksupuc: clear busy | 0 | 16 | 30 |
session idle bit | ksuxds | 0 | 3 | 2 |
shared pool | kghalo | 0 | 12 | 6 |
shared pool | kghupr1 | 0 | 2 | 13 |
simulator hash latch | kcbsacc: lookup dba | 0 | 100 | 100 |
simulator lru latch | kcbs_simulate: simulate set | 0 | 9 | 0 |
undo global data | ktubnd_4 | 0 | 2 | 0 |
undo global data | ktudba: KSLBEGIN | 0 | 2 | 1 |
undo global data | ktudnx:child | 0 | 2 | 2 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kkslce [KKSCHLPIN2] | 5,901 | 0 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 82 | 0 |
Library Cache | kglpin1 4 | 76 | 0 |
Library Cache | kglpndl1 95 | 65 | 0 |
Library Cache | kglhdgn2 106 | 51 | 0 |
Library Cache | kgllkc1 57 | 33 | 0 |
Library Cache | kglllal3 111 | 32 | 0 |
Library Cache | kglpnal1 90 | 31 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 20 | 0 |
Library Cache | kgllkdl1 85 | 8 | 0 |
Library Cache | kglhdgn1 62 | 7 | 0 |
Library Cache | kgllkal3 82 | 7 | 0 |
Library Cache | kglget2 2 | 6 | 0 |
Library Cache | kglUpgradeLock 119 | 4 | 0 |
Library Cache | kglini1 32 | 3 | 0 |
Library Cache | kgllldl2 112 | 3 | 0 |
Library Cache | kglobld1 75 | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ITEM_ORDER_IX | INDEX | 188,119,184 | 32.10 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 187,892,784 | 32.06 | |
SOE | SOE | CUSTOMERS | TABLE | 94,131,216 | 16.06 | |
SOE | SOE | ORDERS | TABLE | 93,754,880 | 16.00 | |
SOE | SOE | PRODUCT_INFORMATION | TABLE | 9,718,816 | 1.66 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 148,566 | 19.19 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 140,248 | 18.12 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 92,874 | 12.00 | |
SOE | SOE | INVENTORIES | TABLE | 81,655 | 10.55 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 64,684 | 8.36 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 148,563 | 19.21 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 140,249 | 18.13 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 92,874 | 12.01 | |
SOE | SOE | INVENTORIES | TABLE | 81,655 | 10.56 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 64,682 | 8.36 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 148,563 | 19.21 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 140,249 | 18.13 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 92,874 | 12.01 | |
SOE | SOE | INVENTORIES | TABLE | 81,655 | 10.56 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 64,682 | 8.36 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SOE | SOE | INVENTORIES | TABLE | 104,693 | 20.06 | |
SOE | SOE | ITEM_PRODUCT_IX | INDEX | 63,064 | 12.08 | |
SOE | SOE | ORDER_PK | INDEX | 51,587 | 9.88 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 50,087 | 9.60 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 46,483 | 8.91 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | INVENTORIES | TABLE | 68,215 | 17.78 | |
SOE | SOE | ORDER_PK | INDEX | 50,136 | 13.07 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 47,348 | 12.34 | |
SOE | SOE | ORDER_ITEMS_PK | INDEX | 44,184 | 11.52 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 42,964 | 11.20 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2532911053_1819 | TABLE PARTITION | 47 | 36.15 |
SYS | SYSAUX | SYS_LOB0000006339C00038$$ | LOB | 12 | 9.23 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 158,800 | 15.44 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 158,336 | 15.39 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 129,296 | 12.57 | |
SOE | SOE | ORDER_ITEMS | TABLE | 128,960 | 12.54 | |
SOE | SOE | INVENTORIES | TABLE | 106,592 | 10.36 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 1,227 | 74.68 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 144 | 8.76 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 104 | 6.33 | |
SOE | SOE | ITEM_PRODUCT_IX | INDEX | 79 | 4.81 | |
SOE | SOE | CUST_ACCOUNT_MANAGER_IX | INDEX | 22 | 1.34 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 522 | 92.72 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 13 | 2.31 | |
SYS | SYSTEM | AUD$ | TABLE | 6 | 1.07 | |
SOE | SOE | ORDER_ITEMS | TABLE | 5 | 0.89 | |
SOE | SOE | ORDER_PK | INDEX | 5 | 0.89 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 19 | 0.00 | 0 | 2 | 1 | |
dc_global_oids | 53 | 5.66 | 0 | 0 | 24 | |
dc_histogram_data | 2,769 | 15.31 | 0 | 0 | 2,149 | |
dc_histogram_defs | 5,387 | 29.03 | 0 | 0 | 2,942 | |
dc_object_grants | 2 | 50.00 | 0 | 0 | 10 | |
dc_objects | 2,759 | 7.29 | 0 | 1 | 1,264 | |
dc_profiles | 17 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 1,068 | 0.00 | 0 | 0 | 78 | |
dc_segments | 1,253 | 8.70 | 0 | 15 | 463 | |
dc_sequences | 14 | 42.86 | 0 | 14 | 7 | |
dc_tablespaces | 2,769 | 0.00 | 0 | 0 | 7 | |
dc_users | 2,960 | 0.71 | 0 | 0 | 22 | |
global database name | 629 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 8 | 0.00 | 0 | 0 | 4 | |
sch_lj_oids | 2 | 0.00 | 0 | 0 | 1 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 30 | 3.33 | 0 | 0 | 0 | |
BODY | 30 | 6.67 | 59 | 5.08 | 1 | 0 |
CLUSTER | 36 | 2.78 | 36 | 2.78 | 0 | 0 |
DBLINK | 31 | 3.23 | 0 | 0 | 0 | |
EDITION | 23 | 0.00 | 38 | 7.89 | 0 | 0 |
INDEX | 15 | 6.67 | 15 | 6.67 | 0 | 0 |
QUEUE | 266 | 0.00 | 266 | 0.00 | 0 | 0 |
SCHEMA | 160 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 1,470 | 8.91 | 1,728,755 | 0.02 | 211 | 0 |
SQL AREA BUILD | 350 | 83.71 | 0 | 0 | 0 | |
SQL AREA STATS | 300 | 54.00 | 300 | 54.00 | 0 | 0 |
TABLE/PROCEDURE | 1,405 | 8.83 | 147,455 | 0.67 | 468 | 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 | 728.00 | 728.00 | 728.00 | 740.00 | 0 | SHR/IMM |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 128.00 | 128.00 | 128.00 | 128.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 1,024.00 | 1,024.00 | 1,024.00 | 1,024.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 | 8.00 | 8.00 | 0.00 | 8.00 | 0 | GRO/IMM |
shared pool | 260.00 | 260.00 | 260.00 | 260.00 | 0 | STA/ |
streams pool | 8.00 | 8.00 | 0.00 | 8.00 | 0 | GRO/IMM |
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 | 154.45 | 2.62 | 2.41 | 14 | 25 | 59 | 59 | |
B | Freeable | 25.38 | 0.00 | 0.79 | 0.42 | 1 | 32 | 32 | |
B | PL/SQL | 4.07 | 2.41 | 0.07 | 0.37 | 3 | 4 | 59 | 59 |
B | SQL | 1.05 | 0.13 | 0.03 | 0.03 | 0 | 5 | 41 | 37 |
E | Other | 184.86 | 2.50 | 2.17 | 14 | 25 | 74 | 74 | |
E | Freeable | 26.19 | 0.00 | 0.79 | 0.43 | 1 | 33 | 33 | |
E | PL/SQL | 4.43 | 2.68 | 0.06 | 0.33 | 3 | 4 | 74 | 74 |
E | SQL | 1.57 | 0.11 | 0.03 | 0.03 | 0 | 5 | 55 | 51 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 763,363,328 | |
Fixed Size | 2,235,208 | |
Redo Buffers | 9,736,192 | |
Variable Size | 293,602,488 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 4.00 | 4.00 | 0.00 |
large | ASM map operations hashta | 0.38 | 0.38 | 0.00 |
large | PX msg pool | 3.71 | 3.71 | 0.00 |
large | free memory | 3.91 | 3.91 | 0.00 |
shared | ASH buffers | 16.00 | 16.00 | 0.00 |
shared | KCB Table Scan Buffer | 3.80 | 3.80 | 0.00 |
shared | KGLH0 | 18.41 | 16.66 | -9.53 |
shared | KGLHD | 3.85 | 3.21 | -16.71 |
shared | KGLS | 4.88 | 4.89 | 0.37 |
shared | KGLSG | 5.02 | 5.02 | 0.00 |
shared | KKSSP | 2.78 | 3.57 | 28.19 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PLMCD | 4.06 | -100.00 | |
shared | SQLA | 43.70 | 21.74 | -50.25 |
shared | db_block_hash_buckets | 5.57 | 5.57 | 0.00 |
shared | dbwriter coalesce buffer | 3.79 | 3.79 | 0.00 |
shared | dirty object counts array | 4.00 | 4.00 | 0.00 |
shared | event statistics per sess | 3.10 | 3.10 | 0.00 |
shared | free memory | 65.88 | 90.35 | 37.13 |
shared | kglsim hash table bkts | 4.00 | 4.00 | 0.00 |
shared | ksunfy : SSO free list | 2.89 | 2.89 | 0.00 |
shared | private strands | 3.51 | 3.51 | 0.00 |
shared | row cache | 7.24 | 7.24 | 0.00 |
shared | write state object | 3.68 | 3.68 | 0.00 |
streams | free memory | 7.99 | 7.99 | 0.00 |
buffer_cache | 728.00 | 728.00 | 0.00 | |
fixed_sga | 2.13 | 2.13 | 0.00 | |
log_buffer | 9.29 | 9.29 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Slaves | 0423 16:34:10 | 0.02 | 0.14 | 0.00 |
QMON Coordinator | 0423 16:34:00 | 0.00 | 0.00 | 0.00 |
Queue Name | Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs |
---|---|---|---|---|---|---|---|
SYS.SCHEDULER$_EVENT_QUEUE(12613) | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 0 | 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 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /u00/app/oracle/admin/DBM11203/adump | |
audit_trail | DB | |
control_files | +DATA/dbm11203/controlfile/current.455.772715921, +FRA/dbm11203/controlfile/current.332.772715921 | |
core_dump_dest | /u00/app/oracle/diag/rdbms/dbm11203/DBM11203/cdump | |
cursor_sharing | EXACT | |
db_block_size | 8192 | |
db_create_file_dest | +DATA | |
db_domain | antognini.ch | |
db_name | DBM11203 | |
db_recovery_file_dest | +FRA | |
db_recovery_file_dest_size | 2147483648 | |
diagnostic_dest | /u00/app/oracle | |
local_listener | (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.101)(PORT=1521))) | |
log_buffer | 8183808 | |
open_cursors | 30 | |
optimizer_dynamic_sampling | 2 | |
optimizer_mode | ALL_ROWS | |
pga_aggregate_target | 134217728 | |
plsql_warnings | DISABLE:ALL | |
processes | 150 | |
query_rewrite_enabled | TRUE | |
remote_login_passwordfile | EXCLUSIVE | |
result_cache_max_size | 2031616 | |
sga_target | 1073741824 | |
skip_unusable_indexes | TRUE | |
undo_tablespace | UNDOTBS1 | |
user_dump_dest | /u00/app/oracle/diag/rdbms/dbm11203/DBM11203/trace |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | +DATA/dbm11203/controlfile/current.455.772715921 | |
control_files | +FRA/dbm11203/controlfile/current.332.772715921 |