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: | 1822 | 23-Apr-14 18:30:05 | 58 | 1.5 |
End Snap: | 1823 | 23-Apr-14 18:45:06 | 59 | 1.5 |
Elapsed: | 15.03 (mins) | |||
DB Time: | 106.74 (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): | 7.1 | 0.0 | 0.01 | 0.00 |
DB CPU(s): | 1.9 | 0.0 | 0.00 | 0.00 |
Redo size: | 393,267.0 | 1,931.8 | ||
Logical reads: | 406,407.8 | 1,996.3 | ||
Block changes: | 2,827.7 | 13.9 | ||
Physical reads: | 580.0 | 2.9 | ||
Physical writes: | 377.6 | 1.9 | ||
User calls: | 2,896.4 | 14.2 | ||
Parses: | 0.6 | 0.0 | ||
Hard parses: | 0.0 | 0.0 | ||
W/A MB processed: | 0.1 | 0.0 | ||
Logons: | 0.0 | 0.0 | ||
Executes: | 1,364.7 | 6.7 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 203.6 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 99.97 |
Buffer Hit %: | 99.86 | In-memory Sort %: | 100.00 |
Library Hit %: | 100.02 | Soft Parse %: | 98.98 |
Execute to Parse %: | 99.96 | Latch Hit %: | 99.96 |
Parse CPU to Parse Elapsd %: | 104.26 | % Non-Parse CPU: | 98.89 |
Begin | End | |
---|---|---|
Memory Usage %: | 66.48 | 66.54 |
% SQL with executions>1: | 76.23 | 75.09 |
% Memory for SQL w/exec>1: | 60.16 | 60.10 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
db file sequential read | 520,207 | 4,568 | 9 | 71.32 | User I/O |
DB CPU | 1,701 | 26.57 | |||
log file sync | 182,738 | 94 | 1 | 1.47 | Commit |
read by other session | 2,753 | 27 | 10 | 0.42 | User I/O |
SQL*Net message to client | 1,418,459 | 2 | 0 | 0.04 | Network |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
6.93 | 7.23 | 23.8 | 0.9 | 21.8 | 74.8 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
24.8 | 98.4 | 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): | 178.2 | 181.2 |
% Host Mem used for SGA+PGA: | 15.08 | 15.11 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 6,114.42 | 95.47 |
DB CPU | 1,701.44 | 26.57 |
parse time elapsed | 26.87 | 0.42 |
sequence load elapsed time | 0.09 | 0.00 |
PL/SQL execution elapsed time | 0.00 | 0.00 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 6,404.55 | |
background elapsed time | 107.51 | |
background cpu time | 38.73 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 176,851 | |
IDLE_TIME | 524,631 | |
IOWAIT_TIME | 152,976 | |
NICE_TIME | 35 | |
SYS_TIME | 6,268 | |
USER_TIME | 166,878 | |
LOAD | 7 | 7 |
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 18:30:05 | 6.93 | |||||
23-Apr 18:45:06 | 7.23 | 25.21 | 23.79 | 0.89 | 74.79 | 21.81 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
User I/O | 523,015 | 0 | 4,595 | 9 | 71.75 |
DB CPU | 1,701 | 26.57 | |||
Commit | 182,738 | 0 | 94 | 1 | 1.47 |
Configuration | 173 | 0 | 5 | 28 | 0.08 |
Network | 1,418,459 | 0 | 2 | 0 | 0.04 |
Application | 684 | 0 | 1 | 1 | 0.01 |
Concurrency | 1,038 | 0 | 0 | 0 | 0.01 |
System I/O | 356 | 0 | 0 | 0 | 0.00 |
Other | 102 | 3 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
db file sequential read | 520,207 | 0 | 4,568 | 9 | 2.83 | 71.32 |
log file sync | 182,738 | 0 | 94 | 1 | 1.00 | 1.47 |
read by other session | 2,753 | 0 | 27 | 10 | 0.01 | 0.42 |
SQL*Net message to client | 1,418,459 | 0 | 2 | 0 | 7.73 | 0.04 |
log file switch (checkpoint incomplete) | 73 | 0 | 2 | 34 | 0.00 | 0.04 |
log file switch (private strand flush incomplete) | 100 | 0 | 2 | 24 | 0.00 | 0.04 |
enq: TX - row lock contention | 684 | 0 | 1 | 1 | 0.00 | 0.01 |
db file parallel read | 41 | 0 | 0 | 10 | 0.00 | 0.01 |
buffer busy waits | 369 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TX - index contention | 7 | 0 | 0 | 16 | 0.00 | 0.00 |
control file sequential read | 356 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers chains | 448 | 0 | 0 | 0 | 0.00 | 0.00 |
cursor: pin S | 27 | 0 | 0 | 2 | 0.00 | 0.00 |
latch free | 71 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: In memory undo latch | 155 | 0 | 0 | 0 | 0.00 | 0.00 |
db file scattered read | 2 | 0 | 0 | 7 | 0.00 | 0.00 |
library cache: mutex X | 32 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: enqueue hash chains | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: object queue header operation | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 1,418,463 | 0 | 16,141 | 11 | 7.73 | |
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 | 178,859 | 0 | 39 | 0 | 0.97 | 36.11 |
db file parallel write | 25,152 | 0 | 14 | 1 | 0.14 | 13.37 |
db file sequential read | 1,159 | 0 | 7 | 6 | 0.01 | 6.85 |
control file sequential read | 2,324 | 0 | 5 | 2 | 0.01 | 4.81 |
db file scattered read | 119 | 0 | 1 | 12 | 0.00 | 1.38 |
os thread startup | 12 | 0 | 0 | 35 | 0.00 | 0.39 |
direct path read | 18 | 0 | 0 | 19 | 0.00 | 0.32 |
log file sequential read | 44 | 0 | 0 | 5 | 0.00 | 0.22 |
ASM file metadata operation | 541 | 0 | 0 | 0 | 0.00 | 0.20 |
control file parallel write | 616 | 0 | 0 | 0 | 0.00 | 0.10 |
ADR block file read | 16 | 0 | 0 | 5 | 0.00 | 0.08 |
LGWR wait for redo copy | 826 | 0 | 0 | 0 | 0.00 | 0.05 |
enq: JS - queue lock | 1 | 0 | 0 | 51 | 0.00 | 0.05 |
reliable message | 87 | 0 | 0 | 0 | 0.00 | 0.01 |
Disk file operations I/O | 66 | 0 | 0 | 0 | 0.00 | 0.00 |
CSS initialization | 1 | 0 | 0 | 5 | 0.00 | 0.00 |
db file async I/O submit | 1,555 | 0 | 0 | 0 | 0.01 | 0.00 |
latch free | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
log file single write | 44 | 0 | 0 | 0 | 0.00 | 0.00 |
ADR block file write | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
read by other session | 1 | 0 | 0 | 3 | 0.00 | 0.00 |
latch: redo allocation | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
direct path write | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
CSS operation: action | 1 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc message | 184,586 | 2 | 12,525 | 68 | 1.01 | |
class slave wait | 235 | 0 | 3,606 | 15344 | 0.00 | |
Space Manager: slave idle wait | 607 | 94 | 2,935 | 4836 | 0.00 | |
DIAG idle wait | 1,800 | 100 | 1,802 | 1001 | 0.01 | |
Streams AQ: qmn coordinator idle wait | 301 | 43 | 903 | 3001 | 0.00 | |
Streams AQ: qmn slave idle wait | 129 | 0 | 903 | 7001 | 0.00 | |
wait for unread message on broadcast channel | 900 | 100 | 901 | 1001 | 0.00 | |
ASM background timer | 180 | 0 | 900 | 5000 | 0.00 | |
pmon timer | 314 | 91 | 900 | 2865 | 0.00 | |
smon timer | 30 | 3 | 899 | 29983 | 0.00 | |
KSV master wait | 75 | 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 | 6.3 | 6.3 | ||||
ADR block file write | 5 | 80.0 | 20.0 | ||||||
ADR file lock | 6 | 100.0 | |||||||
ASM file metadata operation | 545 | 96.1 | 2.4 | .7 | .4 | .2 | .2 | ||
CSS initialization | 1 | 100.0 | |||||||
CSS operation: action | 1 | 100.0 | |||||||
CSS operation: query | 6 | 100.0 | |||||||
Disk file operations I/O | 78 | 100.0 | |||||||
LGWR wait for redo copy | 824 | 99.8 | .1 | .1 | |||||
SQL*Net message to client | 1419K | 100.0 | .0 | ||||||
asynch descriptor resize | 25 | 100.0 | |||||||
buffer busy waits | 373 | 97.9 | .8 | .3 | .5 | .5 | |||
control file parallel write | 616 | 99.5 | .5 | ||||||
control file sequential read | 2680 | 91.2 | .1 | 1.2 | 3.6 | 2.6 | .4 | .9 | |
cursor: pin S | 26 | 80.8 | 3.8 | 15.4 | |||||
db file async I/O submit | 1557 | 100.0 | |||||||
db file parallel read | 41 | 7.3 | 48.8 | 36.6 | 4.9 | 2.4 | |||
db file parallel write | 25.2K | 95.4 | .4 | .3 | .4 | 3.4 | .0 | .0 | |
db file scattered read | 121 | 15.7 | 4.1 | 9.1 | 37.2 | 19.0 | 6.6 | 8.3 | |
db file sequential read | 521.6K | 2.1 | 2.9 | 19.8 | 49.1 | 18.3 | 4.4 | 3.4 | |
direct path read | 18 | 11.1 | 5.6 | 50.0 | 27.8 | 5.6 | |||
direct path write | 12 | 100.0 | |||||||
enq: JS - queue lock | 1 | 100.0 | |||||||
enq: TX - index contention | 7 | 14.3 | 42.9 | 14.3 | 14.3 | 14.3 | |||
enq: TX - row lock contention | 679 | 94.0 | 1.8 | 1.2 | 1.0 | .9 | .4 | .7 | |
latch free | 74 | 93.2 | 5.4 | 1.4 | |||||
latch: In memory undo latch | 157 | 97.5 | 1.9 | .6 | |||||
latch: cache buffers chains | 448 | 96.7 | 2.0 | 1.3 | |||||
latch: cache buffers lru chain | 9 | 100.0 | |||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 14 | 100.0 | |||||||
latch: messages | 2 | 100.0 | |||||||
latch: object queue header operation | 14 | 92.9 | 7.1 | ||||||
latch: redo allocation | 11 | 100.0 | |||||||
latch: undo global data | 3 | 100.0 | |||||||
library cache: mutex X | 32 | 96.9 | 3.1 | ||||||
log file parallel write | 178.9K | 98.7 | .3 | .3 | .2 | .3 | .2 | .0 | |
log file sequential read | 44 | 36.4 | 9.1 | 4.5 | 25.0 | 20.5 | 4.5 | ||
log file single write | 44 | 100.0 | |||||||
log file switch (checkpoint incomplete) | 73 | 1.4 | 1.4 | 2.7 | 11.0 | 21.9 | 61.6 | ||
log file switch (private strand flush incomplete) | 100 | 1.0 | 2.0 | 8.0 | 14.0 | 48.0 | 27.0 | ||
log file sync | 182.8K | 96.3 | 1.2 | .8 | .4 | .8 | .3 | .0 | |
os thread startup | 12 | 100.0 | |||||||
read by other session | 2744 | 4.9 | 6.1 | 19.7 | 39.9 | 16.5 | 7.5 | 5.2 | |
reliable message | 87 | 100.0 | |||||||
ASM background timer | 181 | 100.0 | |||||||
DIAG idle wait | 1802 | 100.0 | |||||||
KSV master wait | 75 | 100.0 | |||||||
SQL*Net message from client | 1419K | 26.8 | .1 | .1 | .0 | 47.1 | 25.2 | .6 | |
Space Manager: slave idle wait | 608 | .2 | .2 | .5 | .7 | 98.5 | |||
Streams AQ: qmn coordinator idle wait | 301 | 57.1 | 42.9 | ||||||
Streams AQ: qmn slave idle wait | 129 | 100.0 | |||||||
class slave wait | 235 | 36.2 | .4 | 4.7 | 4.7 | 11.1 | 11.1 | 31.9 | |
jobq slave wait | 120 | 100.0 | |||||||
pmon timer | 315 | .3 | 3.2 | 96.5 | |||||
rdbms ipc message | 184.7K | 21.6 | 14.4 | 20.9 | 22.8 | 14.7 | 2.6 | 1.8 | 1.3 |
smon timer | 30 | 13.3 | 86.7 | ||||||
wait for unread message on broadcast channel | 901 | 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 | 1 | 93.8 | 6.3 | ||||||
ASM file metadata operation | 1 | 99.8 | .2 | ||||||
buffer busy waits | 2 | 99.5 | .5 | ||||||
control file sequential read | 24 | 99.1 | .2 | .3 | .3 | .0 | |||
db file parallel read | 1 | 97.6 | 2.4 | ||||||
db file parallel write | 5 | 100.0 | .0 | .0 | |||||
db file scattered read | 10 | 91.7 | 5.0 | 2.5 | .8 | ||||
db file sequential read | 17.6K | 96.6 | 2.1 | 1.1 | .2 | .0 | |||
direct path read | 1 | 94.4 | 5.6 | ||||||
enq: JS - queue lock | 1 | 100.0 | |||||||
enq: TX - index contention | 1 | 85.7 | 14.3 | ||||||
enq: TX - row lock contention | 5 | 99.3 | .4 | .1 | .1 | ||||
log file parallel write | 13 | 100.0 | .0 | .0 | .0 | ||||
log file switch (checkpoint incomplete) | 45 | 38.4 | 61.6 | ||||||
log file switch (private strand flush incomplete) | 27 | 73.0 | 27.0 | ||||||
log file sync | 70 | 100.0 | .0 | .0 | .0 | ||||
os thread startup | 12 | 100.0 | |||||||
read by other session | 143 | 94.8 | 3.5 | 1.6 | .1 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
DBM11203.antognini.ch | 6,397 | 1,702 | 520 | 366,686 |
SYS$USERS | 6 | 1 | 1 | 4 |
SYS$BACKGROUND | 0 | 0 | 2 | 12 |
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 | 522509 | 4592 | 1038 | 0 | 0 | 0 | 1418453 | 2 |
SYS$USERS | 491 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 1370 | 9 | 22 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
1,863.02 | 124,882 | 0.01 | 29.09 | 1.72 | 98.57 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
1,350.70 | 7,086 | 0.19 | 21.09 | 91.78 | 6.66 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
651.82 | 36,852 | 0.02 | 10.18 | 3.17 | 96.94 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
587.08 | 105,252 | 0.01 | 9.17 | 5.17 | 94.63 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
527.89 | 36,752 | 0.01 | 8.24 | 2.42 | 97.82 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
433.79 | 105,254 | 0.00 | 6.77 | 3.46 | 96.72 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
399.52 | 14,671 | 0.03 | 6.24 | 2.64 | 97.53 | 9bz9sa0abpc48 | Swingbench User Thread | insert into customers (custome... |
104.40 | 36,853 | 0.00 | 1.63 | 10.37 | 89.35 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
52.38 | 220,441 | 0.00 | 0.82 | 89.31 | 0.00 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
44.43 | 36,854 | 0.00 | 0.69 | 18.13 | 81.06 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
1,239.61 | 7,086 | 0.17 | 72.86 | 1,350.70 | 91.78 | 6.66 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
46.78 | 220,441 | 0.00 | 2.75 | 52.38 | 89.31 | 0.00 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
32.12 | 124,882 | 0.00 | 1.89 | 1,863.02 | 1.72 | 98.57 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
30.35 | 105,252 | 0.00 | 1.78 | 587.08 | 5.17 | 94.63 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
20.63 | 36,852 | 0.00 | 1.21 | 651.82 | 3.17 | 96.94 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
17.01 | 124,883 | 0.00 | 1.00 | 23.29 | 73.04 | 12.30 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
15.00 | 105,254 | 0.00 | 0.88 | 433.79 | 3.46 | 96.72 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
12.75 | 36,752 | 0.00 | 0.75 | 527.89 | 2.42 | 97.82 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
11.95 | 109,862 | 0.00 | 0.70 | 12.90 | 92.66 | 0.00 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
10.83 | 105,252 | 0.00 | 0.64 | 11.75 | 92.12 | 1.10 | dt8dtzvsq5kj5 | 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 |
---|---|---|---|---|---|---|---|---|---|
1,836.46 | 124,882 | 0.01 | 39.89 | 1,863.02 | 1.72 | 98.57 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
631.88 | 36,852 | 0.02 | 13.72 | 651.82 | 3.17 | 96.94 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
555.57 | 105,252 | 0.01 | 12.07 | 587.08 | 5.17 | 94.63 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
516.36 | 36,752 | 0.01 | 11.21 | 527.89 | 2.42 | 97.82 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
419.55 | 105,254 | 0.00 | 9.11 | 433.79 | 3.46 | 96.72 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
389.65 | 14,671 | 0.03 | 8.46 | 399.52 | 2.64 | 97.53 | 9bz9sa0abpc48 | Swingbench User Thread | insert into customers (custome... |
93.29 | 36,853 | 0.00 | 2.03 | 104.40 | 10.37 | 89.35 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
89.97 | 7,086 | 0.01 | 1.95 | 1,350.70 | 91.78 | 6.66 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
36.02 | 36,854 | 0.00 | 0.78 | 44.43 | 18.13 | 81.06 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
20.40 | 7,082 | 0.00 | 0.44 | 24.02 | 10.10 | 84.89 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
351,654,856 | 7,086 | 49,626.71 | 95.98 | 1,350.70 | 91.8 | 6.7 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
6,619,177 | 220,441 | 30.03 | 1.81 | 52.38 | 89.3 | 0 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
1,398,081 | 105,252 | 13.28 | 0.38 | 587.08 | 5.2 | 94.6 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
775,085 | 109,862 | 7.06 | 0.21 | 12.90 | 92.7 | 0 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
747,326 | 124,883 | 5.98 | 0.20 | 23.29 | 73 | 12.3 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
743,176 | 105,252 | 7.06 | 0.20 | 11.75 | 92.1 | 1.1 | dt8dtzvsq5kj5 | Swingbench User Thread | select p.product_id, product_n... |
699,930 | 36,852 | 18.99 | 0.19 | 651.82 | 3.2 | 96.9 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
500,271 | 124,882 | 4.01 | 0.14 | 1,863.02 | 1.7 | 98.6 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
487,652 | 36,854 | 13.23 | 0.13 | 44.43 | 18.1 | 81.1 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
412,977 | 105,254 | 3.92 | 0.11 | 433.79 | 3.5 | 96.7 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
194,859 | 124,882 | 1.56 | 37.27 | 1,863.02 | 1.72 | 98.57 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
70,671 | 36,852 | 1.92 | 13.52 | 651.82 | 3.17 | 96.94 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
68,008 | 105,252 | 0.65 | 13.01 | 587.08 | 5.17 | 94.63 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
65,599 | 36,752 | 1.78 | 12.55 | 527.89 | 2.42 | 97.82 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
48,065 | 105,254 | 0.46 | 9.19 | 433.79 | 3.46 | 96.72 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
47,096 | 14,671 | 3.21 | 9.01 | 399.52 | 2.64 | 97.53 | 9bz9sa0abpc48 | Swingbench User Thread | insert into customers (custome... |
11,197 | 36,853 | 0.30 | 2.14 | 104.40 | 10.37 | 89.35 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
7,773 | 7,086 | 1.10 | 1.49 | 1,350.70 | 91.78 | 6.66 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
4,354 | 36,854 | 0.12 | 0.83 | 44.43 | 18.13 | 81.06 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
1,942 | 7,082 | 0.27 | 0.37 | 24.02 | 10.10 | 84.89 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
194,866 | 194,866 | 124,882 | 1.56 | 0.00 | 37.35 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
70,673 | 70,673 | 36,852 | 1.92 | 0.00 | 13.55 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
68,010 | 68,010 | 105,252 | 0.65 | 0.00 | 13.03 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
65,598 | 65,598 | 36,752 | 1.78 | 0.00 | 12.57 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
48,066 | 48,066 | 105,254 | 0.46 | 0.00 | 9.21 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
11,197 | 11,197 | 36,853 | 0.30 | 0.00 | 2.15 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
7,777 | 7,777 | 7,086 | 1.10 | 0.00 | 1.49 | g8rhybcumtwd6 | Swingbench User Thread | SELECT /*+ first_rows index(cu... |
5,680 | 5,680 | 14,671 | 0.39 | 0.00 | 1.09 | 9bz9sa0abpc48 | Swingbench User Thread | insert into customers (custome... |
4,354 | 4,354 | 36,854 | 0.12 | 0.00 | 0.83 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
1,942 | 1,942 | 7,082 | 0.27 | 0.00 | 0.37 | 6k3uuf3g8pwh6 | Swingbench User Thread | update /*+ index(orders, order... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
220,441 | 1,109,622 | 5.03 | 52.38 | 89.3 | 0 | gyk686gnaygs2 | Swingbench User Thread | select product_id, product_nam... |
124,883 | 124,881 | 1.00 | 23.29 | 73 | 12.3 | gshgncvvtv0c6 | Swingbench User Thread | insert into logon values(:1 , ... |
124,882 | 124,877 | 1.00 | 1,863.02 | 1.7 | 98.6 | 82ud5h0qcg0bf | Swingbench User Thread | select customer_id, cust_first... |
109,862 | 1,098,610 | 10.00 | 12.90 | 92.7 | 0 | 7v0pya6f6qc6s | Swingbench User Thread | select p.product_id, product_n... |
105,254 | 94,702 | 0.90 | 433.79 | 3.5 | 96.7 | 5g00dq4fxwnsw | Swingbench User Thread | update inventories set quantit... |
105,252 | 105,252 | 1.00 | 587.08 | 5.2 | 94.6 | 8vvvyuun2urt6 | Swingbench User Thread | insert into order_items(ORDER_... |
105,252 | 1,052,500 | 10.00 | 11.75 | 92.1 | 1.1 | dt8dtzvsq5kj5 | Swingbench User Thread | select p.product_id, product_n... |
105,251 | 105,250 | 1.00 | 7.71 | 93.2 | 0 | 982zxphp8ht6c | Swingbench User Thread | select product_id, product_nam... |
36,854 | 105,235 | 2.86 | 44.43 | 18.1 | 81.1 | gfqas5ahy1x56 | Swingbench User Thread | SELECT o.order_id, line_item_i... |
36,853 | 36,853 | 1.00 | 104.40 | 10.4 | 89.4 | 2yp5w5a36s5xv | Swingbench User Thread | update orders set order_mode =... |
36,852 | 36,852 | 1.00 | 651.82 | 3.2 | 96.9 | 9zd49du11u7cf | Swingbench User Thread | insert into orders(ORDER_ID, O... |
36,848 | 36,848 | 1.00 | 3.37 | 88.3 | 2.8 | 8uk8bquk453q8 | Swingbench User Thread | select orders_seq.nextval from... |
36,752 | 34,058 | 0.93 | 527.89 | 2.4 | 97.8 | d5j6fbqmu3gjp | Swingbench User Thread | SELECT /*+ use_nl */ o.order_i... |
14,671 | 14,671 | 1.00 | 1.33 | 89.8 | 0 | 5d8b4p888x97a | Swingbench User Thread | select customer_seq.nextval fr... |
14,671 | 14,671 | 1.00 | 399.52 | 2.6 | 97.5 | 9bz9sa0abpc48 | Swingbench User Thread | insert into customers (custome... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
134 | 134 | 27.24 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
7 | 88 | 1.42 | bsa0wjtftg3uw | select file# from file$ where ... | |
5 | 10 | 1.02 | 0kkhhb2w93cx0 | update seg$ set type#=:4, bloc... | |
4 | 4 | 0.81 | b2gnxm5z6r51n | lock table sys.col_usage$ in e... | |
2 | 2 | 0.41 | 1gfaj4z5hn1kf | delete from dependency$ where ... | |
2 | 2 | 0.41 | 20vv6ttajyjzq | delete from access$ where d_ob... | |
2 | 2 | 0.41 | 2pff93c8c626v | select name, address, protocol... | |
2 | 10 | 0.41 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
2 | 2 | 0.41 | 6abthk1u14yb7 | SELECT VERSION FROM V$INSTANCE | |
2 | 12 | 0.41 | 6xvp6nxs4a9n4 | select nvl(sum(space), 0) from... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 451 | 0.50 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 643 | 0.71 | 0.00 |
Batched IO buffer defrag count | 7 | 0.01 | 0.00 |
Batched IO double miss count | 90 | 0.10 | 0.00 |
Batched IO same unit count | 223 | 0.25 | 0.00 |
Batched IO single block count | 481 | 0.53 | 0.00 |
Batched IO vector block count | 123 | 0.14 | 0.00 |
Batched IO vector read count | 60 | 0.07 | 0.00 |
Block Cleanout Optim referenced | 3,558 | 3.95 | 0.02 |
CCursor + sql area evicted | 0 | 0.00 | 0.00 |
CPU used by this session | 162,156 | 179.86 | 0.88 |
CPU used when call started | 162,045 | 179.74 | 0.88 |
CR blocks created | 43,727 | 48.50 | 0.24 |
Cached Commit SCN referenced | 34,730 | 38.52 | 0.19 |
Commit SCN cached | 6,504 | 7.21 | 0.04 |
DB time | 641,440 | 711.49 | 3.49 |
DBWR checkpoint buffers written | 49,337 | 54.72 | 0.27 |
DBWR checkpoints | 11 | 0.01 | 0.00 |
DBWR thread checkpoint buffers written | 49,337 | 54.72 | 0.27 |
DBWR transaction table writes | 218 | 0.24 | 0.00 |
DBWR undo block writes | 16,336 | 18.12 | 0.09 |
HSC Heap Segment Block Changes | 421,099 | 467.08 | 2.29 |
Heap Segment Array Inserts | 169 | 0.19 | 0.00 |
Heap Segment Array Updates | 15 | 0.02 | 0.00 |
IMU CR rollbacks | 13,396 | 14.86 | 0.07 |
IMU Flushes | 23,259 | 25.80 | 0.13 |
IMU Redo allocation size | 116,746,320 | 129,495.11 | 636.09 |
IMU commits | 154,026 | 170.85 | 0.84 |
IMU contention | 19,872 | 22.04 | 0.11 |
IMU pool not allocated | 6,258 | 6.94 | 0.03 |
IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
IMU undo allocation size | 373,604,528 | 414,402.45 | 2,035.59 |
IMU- failed to get a private strand | 6,258 | 6.94 | 0.03 |
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,418,864 | 1,573.81 | 7.73 |
RowCR - row contention | 231 | 0.26 | 0.00 |
RowCR attempts | 112,607 | 124.90 | 0.61 |
RowCR hits | 111,471 | 123.64 | 0.61 |
SMON posted for undo segment shrink | 24 | 0.03 | 0.00 |
SQL*Net roundtrips to/from client | 1,418,872 | 1,573.81 | 7.73 |
active txn count during cleanout | 55,655 | 61.73 | 0.30 |
application wait time | 80 | 0.09 | 0.00 |
background checkpoints completed | 11 | 0.01 | 0.00 |
background checkpoints started | 11 | 0.01 | 0.00 |
background timeouts | 4,682 | 5.19 | 0.03 |
branch node splits | 3 | 0.00 | 0.00 |
buffer is not pinned count | 177,662,097 | 197,062.94 | 968.00 |
buffer is pinned count | 179,300,974 | 198,880.79 | 976.93 |
bytes received via SQL*Net from client | 346,648,249 | 384,502.52 | 1,888.72 |
bytes sent via SQL*Net to client | 767,717,895 | 851,553.32 | 4,182.93 |
calls to get snapshot scn: kcmgss | 1,133,782 | 1,257.59 | 6.18 |
calls to kcmgas | 235,694 | 261.43 | 1.28 |
calls to kcmgcs | 726,676 | 806.03 | 3.96 |
cell physical IO interconnect bytes | 7,982,754,816 | 8,854,478.19 | 43,494.22 |
change write time | 1,300 | 1.44 | 0.01 |
cleanout - number of ktugct calls | 32,874 | 36.46 | 0.18 |
cleanouts and rollbacks - consistent read gets | 23,363 | 25.91 | 0.13 |
cleanouts only - consistent read gets | 1,731 | 1.92 | 0.01 |
cluster key scan block gets | 60 | 0.07 | 0.00 |
cluster key scans | 60 | 0.07 | 0.00 |
commit batch/immediate performed | 18 | 0.02 | 0.00 |
commit batch/immediate requested | 18 | 0.02 | 0.00 |
commit cleanout failures: buffer being written | 9 | 0.01 | 0.00 |
commit cleanout failures: callback failure | 94 | 0.10 | 0.00 |
commit cleanout failures: cannot pin | 4,927 | 5.47 | 0.03 |
commit cleanouts | 757,256 | 839.95 | 4.13 |
commit cleanouts successfully completed | 752,226 | 834.37 | 4.10 |
commit immediate performed | 18 | 0.02 | 0.00 |
commit immediate requested | 18 | 0.02 | 0.00 |
commit txn count during cleanout | 47,753 | 52.97 | 0.26 |
concurrency wait time | 86 | 0.10 | 0.00 |
consistent changes | 100,357 | 111.32 | 0.55 |
consistent gets | 362,913,878 | 402,544.37 | 1,977.34 |
consistent gets - examination | 236,188,959 | 261,980.99 | 1,286.88 |
consistent gets direct | 0 | 0.00 | 0.00 |
consistent gets from cache | 362,913,875 | 402,544.37 | 1,977.34 |
consistent gets from cache (fastpath) | 126,504,818 | 140,319.25 | 689.26 |
cursor authentications | 5 | 0.01 | 0.00 |
data blocks consistent reads - undo records applied | 90,673 | 100.57 | 0.49 |
db block changes | 2,549,313 | 2,827.70 | 13.89 |
db block gets | 3,483,003 | 3,863.35 | 18.98 |
db block gets direct | 27 | 0.03 | 0.00 |
db block gets from cache | 3,482,976 | 3,863.32 | 18.98 |
db block gets from cache (fastpath) | 1,190,104 | 1,320.06 | 6.48 |
deferred (CURRENT) block cleanout applications | 265,326 | 294.30 | 1.45 |
dirty buffers inspected | 209,279 | 232.13 | 1.14 |
enqueue conversions | 579 | 0.64 | 0.00 |
enqueue releases | 443,391 | 491.81 | 2.42 |
enqueue requests | 443,403 | 491.82 | 2.42 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 691 | 0.77 | 0.00 |
execute count | 1,230,380 | 1,364.74 | 6.70 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 8,599,511,451 | 9,538,585.16 | 46,854.63 |
free buffer inspected | 568,832 | 630.95 | 3.10 |
free buffer requested | 584,574 | 648.41 | 3.19 |
heap block compress | 576 | 0.64 | 0.00 |
hot buffers moved to head of LRU | 267,499 | 296.71 | 1.46 |
immediate (CR) block cleanout applications | 25,094 | 27.83 | 0.14 |
immediate (CURRENT) block cleanout applications | 29,435 | 32.65 | 0.16 |
in call idle wait time | 2,633,490 | 2,921.07 | 14.35 |
index crx upgrade (positioned) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 2 | 0.00 | 0.00 |
index fetch by key | 58,944,680 | 65,381.49 | 321.16 |
index scans kdiixs1 | 58,760,496 | 65,177.19 | 320.16 |
leaf node 90-10 splits | 20 | 0.02 | 0.00 |
leaf node splits | 1,611 | 1.79 | 0.01 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 80 | 0.09 | 0.00 |
lob writes unaligned | 80 | 0.09 | 0.00 |
logical read bytes from cache | 3,001,522,946,048 | 3,329,291,715.43 | 16,353,864.89 |
logons cumulative | 13 | 0.01 | 0.00 |
max cf enq hold time | 10 | 0.01 | 0.00 |
messages received | 207,981 | 230.69 | 1.13 |
messages sent | 207,981 | 230.69 | 1.13 |
min active SCN optimization applied on CR | 159,883 | 177.34 | 0.87 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 125,842,864 | 139,585.01 | 685.66 |
non-idle wait count | 2,527,015 | 2,802.97 | 13.77 |
non-idle wait time | 476,964 | 529.05 | 2.60 |
opened cursors cumulative | 1,230,072 | 1,364.40 | 6.70 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 5 | 0.01 | 0.00 |
parse count (total) | 492 | 0.55 | 0.00 |
parse time cpu | 1,883 | 2.09 | 0.01 |
parse time elapsed | 1,806 | 2.00 | 0.01 |
physical read IO requests | 521,753 | 578.73 | 2.84 |
physical read bytes | 4,283,432,960 | 4,751,187.36 | 23,338.38 |
physical read total IO requests | 524,482 | 581.76 | 2.86 |
physical read total bytes | 4,327,405,568 | 4,799,961.81 | 23,577.97 |
physical read total multi block requests | 5 | 0.01 | 0.00 |
physical reads | 522,880 | 579.98 | 2.85 |
physical reads cache | 522,825 | 579.92 | 2.85 |
physical reads cache prefetch | 1,170 | 1.30 | 0.01 |
physical reads direct | 55 | 0.06 | 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 | 236,463 | 262.28 | 1.29 |
physical write bytes | 2,788,556,800 | 3,093,069.49 | 15,193.51 |
physical write total IO requests | 597,121 | 662.33 | 3.25 |
physical write total bytes | 3,655,349,248 | 4,054,516.39 | 19,916.25 |
physical write total multi block requests | 1,099 | 1.22 | 0.01 |
physical writes | 340,400 | 377.57 | 1.85 |
physical writes direct | 82 | 0.09 | 0.00 |
physical writes direct (lob) | 0 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 340,318 | 377.48 | 1.85 |
physical writes non checkpoint | 268,955 | 298.33 | 1.47 |
pinned buffers inspected | 39 | 0.04 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1 | 0.00 | 0.00 |
process last non-idle time | 0 | 0.00 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 193,830 | 215.00 | 1.06 |
recursive cpu usage | 1,536 | 1.70 | 0.01 |
redo KB read | 0 | 0.00 | 0.00 |
redo blocks checksummed by FG (exclusive) | 292,518 | 324.46 | 1.59 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 826,743 | 917.02 | 4.50 |
redo buffer allocation retries | 174 | 0.19 | 0.00 |
redo entries | 649,827 | 720.79 | 3.54 |
redo k-bytes read for recovery | 0 | 0.00 | 0.00 |
redo log space requests | 176 | 0.20 | 0.00 |
redo log space wait time | 497 | 0.55 | 0.00 |
redo ordering marks | 6,115 | 6.78 | 0.03 |
redo size | 354,549,884 | 393,267.02 | 1,931.77 |
redo size for direct writes | 208 | 0.23 | 0.00 |
redo subscn max counts | 16,125 | 17.89 | 0.09 |
redo synch long waits | 187 | 0.21 | 0.00 |
redo synch time | 9,601 | 10.65 | 0.05 |
redo synch time (usec) | 96,015,263 | 106,500.21 | 523.14 |
redo synch writes | 183,545 | 203.59 | 1.00 |
redo wastage | 55,374,424 | 61,421.36 | 301.71 |
redo write time | 5,260 | 5.83 | 0.03 |
redo writes | 178,894 | 198.43 | 0.97 |
rollback changes - undo records applied | 48 | 0.05 | 0.00 |
rollbacks only - consistent read gets | 19,770 | 21.93 | 0.11 |
rows fetched via callback | 58,794,764 | 65,215.20 | 320.34 |
session connect time | 0 | 0.00 | 0.00 |
session logical reads | 366,396,963 | 406,407.81 | 1,996.32 |
shared hash latch upgrades - no wait | 309,676 | 343.49 | 1.69 |
shared hash latch upgrades - wait | 30 | 0.03 | 0.00 |
sorts (memory) | 445 | 0.49 | 0.00 |
sorts (rows) | 16,322 | 18.10 | 0.09 |
sql area evicted | 0 | 0.00 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 1,935,798 | 2,147.19 | 10.55 |
switch current to new buffer | 342 | 0.38 | 0.00 |
table fetch by rowid | 119,629,777 | 132,693.45 | 651.81 |
table fetch continued row | 0 | 0.00 | 0.00 |
table scan blocks gotten | 6,180,629 | 6,855.56 | 33.68 |
table scan rows gotten | 220,747,132 | 244,852.90 | 1,202.75 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 220,455 | 244.53 | 1.20 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 3,250 | 3.60 | 0.02 |
total number of cf enq holders | 79 | 0.09 | 0.00 |
total number of times SMON posted | 28 | 0.03 | 0.00 |
transaction rollbacks | 15 | 0.02 | 0.00 |
undo change vector size | 119,248,856 | 132,270.93 | 649.73 |
user I/O wait time | 460,683 | 510.99 | 2.51 |
user calls | 2,611,214 | 2,896.36 | 14.23 |
user commits | 183,536 | 203.58 | 1.00 |
workarea executions - optimal | 274 | 0.30 | 0.00 |
write clones created in foreground | 123 | 0.14 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
logons current | 58 | 59 |
session uga memory max | 276,205,016 | 302,141,872 |
session pga memory | 173,079,824 | 178,701,104 |
session pga memory max | 315,033,488 | 327,256,848 |
session cursor cache count | 2,445 | 2,661 |
session uga memory | 30,094,017,224 | 34,389,911,968 |
opened cursors current | 89 | 90 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 11 | 43.92 |
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 | 4G | 578.79 | 4.53108 | 0M | 0.00 | 0M | 521.8K | 8.33 |
DBWR | 0M | 0.00 | 0M | 2.6G | 262.24 | 2.94936 | 0 | |
LGWR | 5M | 0.36 | .005546 | 811M | 399.03 | .899561 | 179.4K | 0.10 |
Others | 38M | 2.67 | .042149 | 16M | 1.10 | .017747 | 2900 | 1.50 |
Direct Reads | 1M | 0.06 | .001109 | 0M | 0.02 | 0M | 0 | |
Streams AQ | 1M | 0.01 | .001109 | 0M | 0.00 | 0M | 8 | 5.75 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.04 | 0M | 0 | |
TOTAL: | 4G | 581.89 | 4.58099 | 3.4G | 662.44 | 3.86667 | 704.1K | 6.20 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 4G | 578.86 | 4.53219 | 2.6G | 262.30 | 2.95047 | 8.33 | 20.20 |
Log File | 0M | 0.05 | 0M | 808M | 398.78 | .896234 | 4.93 | |
Control File | 42M | 2.97 | .046586 | 19M | 1.37 | .021074 | 1.82 | |
Temp File | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 11.00 | |
TOTAL: | 4G | 581.88 | 4.57878 | 3.4G | 662.45 | 3.86778 | 8.29 | 20.20 |
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 | 4G | 578.73 | 4.52997 | 0M | 0.00 | 0M | 521.7K | 8.33 |
Buffer Cache Reads (Data File) | 4G | 578.73 | 4.52997 | 0M | 0.00 | 0M | 521.7K | 8.33 |
DBWR | 0M | 0.00 | 0M | 2.6G | 262.24 | 2.94936 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 2.6G | 262.24 | 2.94936 | 0 | |
LGWR | 5M | 0.36 | .005546 | 811M | 399.01 | .899561 | 368 | 2.08 |
LGWR (Log File) | 0M | 0.05 | 0M | 808M | 398.74 | .896234 | 88 | 2.47 |
LGWR (Control File) | 5M | 0.31 | .005546 | 3M | 0.27 | .003327 | 280 | 1.96 |
Others | 37M | 2.67 | .041040 | 16M | 1.10 | .017747 | 2405 | 1.81 |
Others (Control File) | 37M | 2.66 | .041040 | 16M | 1.10 | .017747 | 2400 | 1.80 |
Others (Data File) | 0M | 0.01 | 0M | 0M | 0.00 | 0M | 5 | 4.40 |
Direct Reads | 1M | 0.06 | .001109 | 0M | 0.02 | 0M | 0 | |
Direct Reads (Data File) | 1M | 0.06 | .001109 | 0M | 0.02 | 0M | 0 | |
Streams AQ | 1M | 0.01 | .001109 | 0M | 0.00 | 0M | 8 | 5.75 |
Streams AQ (Data File) | 1M | 0.01 | .001109 | 0M | 0.00 | 0M | 8 | 5.75 |
Direct Writes | 0M | 0.00 | 0M | 0M | 0.04 | 0M | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.04 | 0M | 0 | |
TOTAL: | 4G | 581.82 | 4.57878 | 3.4G | 662.41 | 3.86667 | 524.4K | 8.29 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SOE | 519,831 | 577 | 8.78 | 1.00 | 234,576 | 260 | 3,270 | 8.39 |
SYSAUX | 1,475 | 2 | 6.39 | 1.40 | 502 | 1 | 0 | 0.00 |
UNDOTBS1 | 83 | 0 | 6.02 | 1.00 | 1,363 | 2 | 52 | 0.19 |
SYSTEM | 230 | 0 | 10.48 | 3.35 | 26 | 0 | 1 | 0.00 |
USERS | 11 | 0 | 0.00 | 1.00 | 11 | 0 | 0 | 0.00 |
TEMP | 2 | 0 | 10.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) |
---|---|---|---|---|---|---|---|---|---|
SOE | +DATA/dbm11203/datafile/soe.486.836957131 | 519,831 | 577 | 8.78 | 1.00 | 234,576 | 260 | 3,270 | 8.39 |
SYSAUX | +DATA/dbm11203/datafile/sysaux.460.772715927 | 1,475 | 2 | 6.39 | 1.40 | 502 | 1 | 0 | 0.00 |
SYSTEM | +DATA/dbm11203/datafile/system.459.772715923 | 230 | 0 | 10.48 | 3.35 | 26 | 0 | 1 | 0.00 |
TEMP | +DATA/dbm11203/tempfile/temp.462.772715931 | 2 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | |
UNDOTBS1 | +DATA/dbm11203/datafile/undotbs1.461.772715929 | 83 | 0 | 6.02 | 1.00 | 1,363 | 2 | 52 | 0.19 |
USERS | +DATA/dbm11203/datafile/users.463.772715939 | 11 | 0 | 0.00 | 1.00 | 11 | 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 | 365,315,273 | 522,788 | 340,346 | 0 | 0 | 3,322 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 40,910 | 0 | 0 | 0 | 8,366 |
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 | 19 | 20987 | 167937 | 165888 | 165888 | 445422 | |||
E | 0 | 19 | 21454 | 167685 | 165888 | 165888 | 384637 |
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 | 347.39 | 1,573,046 | 1 | 14509263.00 |
D | 144 | 0.20 | 18 | 261.43 | 1,183,804 | 1 | 10918910.00 |
D | 216 | 0.30 | 27 | 121.53 | 550,327 | 1 | 5075738.00 |
D | 288 | 0.40 | 35 | 1.70 | 7,684 | 1 | 70425.00 |
D | 360 | 0.49 | 44 | 1.39 | 6,293 | 1 | 57590.00 |
D | 432 | 0.59 | 53 | 1.25 | 5,643 | 1 | 51592.00 |
D | 504 | 0.69 | 62 | 1.16 | 5,231 | 1 | 47798.00 |
D | 576 | 0.79 | 71 | 1.09 | 4,945 | 1 | 45155.00 |
D | 648 | 0.89 | 80 | 1.04 | 4,716 | 1 | 43048.00 |
D | 720 | 0.99 | 88 | 1.00 | 4,545 | 1 | 41465.00 |
D | 728 | 1.00 | 89 | 1.00 | 4,528 | 1 | 41313.00 |
D | 792 | 1.09 | 97 | 0.97 | 4,400 | 1 | 40130.00 |
D | 864 | 1.19 | 106 | 0.94 | 4,276 | 1 | 38988.00 |
D | 936 | 1.29 | 115 | 0.92 | 4,167 | 1 | 37977.00 |
D | 1,008 | 1.38 | 124 | 0.90 | 4,064 | 1 | 37032.00 |
D | 1,080 | 1.48 | 133 | 0.88 | 3,968 | 1 | 36146.00 |
D | 1,152 | 1.58 | 141 | 0.86 | 3,886 | 1 | 35385.00 |
D | 1,224 | 1.68 | 150 | 0.84 | 3,810 | 1 | 34684.00 |
D | 1,296 | 1.78 | 159 | 0.81 | 3,682 | 1 | 33512.00 |
D | 1,368 | 1.88 | 168 | 0.69 | 3,110 | 1 | 28235.00 |
D | 1,440 | 1.98 | 177 | 0.63 | 2,840 | 1 | 25740.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 71 | 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 | 178.24 | 0.00 | 0.00 | 0.00 | 0.00 | 26,214 |
E | 128 | 8 | 181.23 | 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 | 199 | 199 | 0 | 0 |
64K | 128K | 9 | 9 | 0 | 0 |
128K | 256K | 1 | 1 | 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 | 692.42 | 13.57 | 98.00 | 6 | 1,160,917 |
32 | 0.25 | 692.42 | 13.57 | 98.00 | 6 | 1,160,917 |
64 | 0.50 | 692.42 | 13.57 | 98.00 | 6 | 1,160,917 |
96 | 0.75 | 692.42 | 13.57 | 98.00 | 6 | 1,160,917 |
128 | 1.00 | 692.42 | 0.00 | 100.00 | 6 | 1,138,602 |
154 | 1.20 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
179 | 1.40 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
205 | 1.60 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
230 | 1.80 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
256 | 2.00 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
384 | 3.00 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
512 | 4.00 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
768 | 6.00 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
1,024 | 8.00 | 692.42 | 0.00 | 100.00 | 0 | 1,138,602 |
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 | 12 | 783 | 10,050 | 0.98 | 433 | 1.75 | 3,925 |
236 | 0.91 | 15 | 898 | 10,081 | 0.98 | 402 | 1.63 | 3,927 |
240 | 0.92 | 17 | 997 | 10,129 | 0.99 | 354 | 1.43 | 3,928 |
244 | 0.94 | 21 | 1,249 | 10,142 | 0.99 | 341 | 1.38 | 3,928 |
248 | 0.95 | 25 | 1,465 | 10,160 | 0.99 | 323 | 1.31 | 3,929 |
252 | 0.97 | 29 | 1,681 | 10,178 | 0.99 | 305 | 1.23 | 3,929 |
256 | 0.98 | 33 | 1,897 | 10,209 | 1.00 | 274 | 1.11 | 3,930 |
260 | 1.00 | 37 | 2,113 | 10,236 | 1.00 | 247 | 1.00 | 3,932 |
264 | 1.02 | 40 | 2,407 | 10,239 | 1.00 | 244 | 0.99 | 3,932 |
268 | 1.03 | 44 | 2,621 | 10,239 | 1.00 | 244 | 0.99 | 3,932 |
272 | 1.05 | 48 | 2,831 | 10,239 | 1.00 | 244 | 0.99 | 3,932 |
276 | 1.06 | 52 | 3,057 | 10,239 | 1.00 | 244 | 0.99 | 3,932 |
280 | 1.08 | 56 | 3,319 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
284 | 1.09 | 59 | 3,645 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
288 | 1.11 | 63 | 3,941 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
292 | 1.12 | 67 | 4,176 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
296 | 1.14 | 71 | 4,335 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
316 | 1.22 | 91 | 4,820 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
344 | 1.32 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
372 | 1.43 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
400 | 1.54 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
428 | 1.65 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
456 | 1.75 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
484 | 1.86 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
512 | 1.97 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
540 | 2.08 | 95 | 5,044 | 10,240 | 1.00 | 243 | 0.98 | 3,933 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
512 | 0.50 | 5,164,978 | 563,502,939 |
768 | 0.75 | 63,953 | 5,367,615 |
1,024 | 1.00 | 56,257 | 4,514,774 |
1,280 | 1.25 | 53,012 | 4,169,845 |
1,536 | 1.50 | 49,428 | 3,778,414 |
1,792 | 1.75 | 41,530 | 2,913,835 |
2,048 | 2.00 | 41,530 | 2,913,835 |
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 | 3,275 | 27 | 8 |
undo block | 24 | 0 | 0 |
undo header | 28 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 686 | 686 | 0 | 684 | 1 | 1.17 |
TX-Transaction (index contention) | 520 | 520 | 0 | 7 | 0 | 14.29 |
JS-Job Scheduler (queue lock) | 2,752 | 2,752 | 0 | 1 | 0 | 50.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 | 21.26 | 247,075 | 939 | 20 | 19.6/29.7 | 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 18:43 | 10,617 | 123,638 | 338 | 20 | 20 | 0/0 | 0/0/0/0/0/0 |
23-Apr 18:33 | 10,647 | 123,437 | 939 | 20 | 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 | 23 | 0.00 | 0 | 0 | ||
ASM allocation | 150 | 0.00 | 0 | 0 | ||
ASM db client latch | 693 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 36 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 2,245,333 | 0.00 | 0.00 | 0 | 0 | |
ASM network background latch | 440 | 0.00 | 0 | 0 | ||
ASM network state latch | 192 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 6,805 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 301 | 0.00 | 0 | 0 | ||
Consistent RBA | 178,907 | 0.00 | 0 | 0 | ||
DML lock allocation | 498,223 | 0.01 | 0.09 | 0 | 0 | |
Event Group Locks | 27 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 148 | 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,305,440 | 0.02 | 0.57 | 0 | 183,774 | 0.00 |
JS Sh mem access | 6 | 0.00 | 0 | 0 | ||
JS broadcast autostart latch | 1 | 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,504 | 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 | 210 | 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 | 301 | 0.00 | 0 | 0 | ||
KTF sga latch | 5 | 0.00 | 0 | 302 | 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 | 187 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 18 | 0.00 | ||
Memory Management Latch | 2 | 0.00 | 0 | 301 | 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 | 107 | 0.00 | 0 | 0 | ||
OS process allocation | 1,865 | 0.00 | 0 | 0 | ||
OS process: request allocation | 23 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 44 | 0.00 | 0 | 0 | ||
PX hash array latch | 2 | 0.00 | 0 | 0 | ||
QMT | 2 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 436 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 11 | 0.00 | 0 | 11 | 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 | 300 | 0.00 | |
SQL memory manager workarea list latch | 20,466 | 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 | 28,428 | 0.00 | 0 | 0 | ||
active service list | 1,760 | 0.00 | 0 | 2,133 | 0.00 | |
begin backup scn array | 4 | 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 | 10,226 | 0.10 | 0.00 | 0 | 0 | |
cache buffers chains | 505,924,400 | 0.05 | 0.00 | 0 | 586,323 | 0.01 |
cache buffers lru chain | 451,916 | 0.04 | 0.06 | 0 | 954,973 | 0.06 |
cache table scan latch | 121 | 0.00 | 0 | 121 | 0.00 | |
call allocation | 114 | 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 | 27 | 0.00 | 0 | 0 | ||
channel operations parent latch | 6,962 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 1,348,925 | 0.00 | 0.02 | 0 | 333,552 | 0.00 |
client/application info | 18 | 0.00 | 0 | 0 | ||
compile environment latch | 13 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 159 | 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 | 34 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 2 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 34 | 0.00 | 0 | 0 | ||
dml lock allocation | 34 | 0.00 | 0 | 0 | ||
done queue latch | 2 | 0.00 | 0 | 0 | ||
dummy allocation | 27 | 0.00 | 0 | 0 | ||
enqueue freelist latch | 2 | 0.00 | 0 | 17,622 | 0.01 | |
enqueue hash chains | 888,071 | 0.03 | 0.06 | 0 | 0 | |
enqueues | 21 | 0.00 | 0 | 0 | ||
fifth spare latch | 2 | 0.00 | 0 | 0 | ||
file cache latch | 220 | 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 tx hash mapping | 2 | 0.00 | 0 | 0 | ||
granule operation | 2 | 0.00 | 0 | 0 | ||
hash table column usage latch | 8 | 0.00 | 0 | 35 | 0.00 | |
hash table modification latch | 2 | 0.00 | 0 | 0 | ||
heartbeat check | 2 | 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 | 11 | 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 | 4 | 0.00 | 0 | 0 | ||
ksfv messages | 2 | 0.00 | 0 | 0 | ||
ksim group membership cache | 2 | 0.00 | 0 | 0 | ||
kss move lock | 22 | 0.00 | 0 | 0 | ||
ksuosstats global area | 96 | 0.00 | 0 | 0 | ||
ksv allocation latch | 73 | 0.00 | 0 | 0 | ||
ksv class latch | 719 | 0.14 | 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 | 23 | 0.00 | 0 | 0 | ||
ktm global data | 123 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 561 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 179,870 | 0.00 | 0.00 | 0 | 0 | |
list of block allocation | 54 | 0.00 | 0 | 0 | ||
loader state object freelist | 134 | 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 | 265 | 0.00 | 0 | 0 | ||
messages | 616,540 | 0.02 | 0.02 | 0 | 0 | |
mostly latch-free SCN | 182,081 | 0.35 | 0.02 | 0 | 0 | |
msg queue latch | 2 | 0.00 | 0 | 0 | ||
multiblock read objects | 366 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 2 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 34 | 0.00 | 0 | 0 | ||
object queue header heap | 228,355 | 0.00 | 0 | 1,325 | 0.00 | |
object queue header operation | 2,330,854 | 0.02 | 0.03 | 0 | 0 | |
object stats modification | 195 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 122 | 0.00 | 0 | 0 | ||
parallel query stats | 2 | 0.00 | 0 | 0 | ||
parameter list | 2 | 0.00 | 0 | 0 | ||
parameter table management | 42 | 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 | 271,590 | 0.01 | 0.00 | 0 | 184,450 | 0.04 |
process allocation | 35 | 0.00 | 0 | 12 | 0.00 | |
process group creation | 23 | 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 | 900,547 | 0.04 | 0.03 | 0 | 649,397 | 0.19 |
redo copy | 2 | 0.00 | 0 | 649,885 | 0.16 | |
redo writing | 566,775 | 0.00 | 0.00 | 0 | 0 | |
resmgr group change latch | 2 | 0.00 | 0 | 0 | ||
resmgr:active threads | 27 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 13 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 2 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 25 | 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 | 8,350 | 0.02 | 0.00 | 0 | 39 | 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 | 154,907 | 0.01 | 0.00 | 0 | 0 | |
session allocation | 183,644 | 0.01 | 0.00 | 0 | 183,637 | 0.00 |
session idle bit | 5,405,487 | 0.01 | 0.07 | 0 | 0 | |
session queue latch | 2 | 0.00 | 0 | 0 | ||
session state list latch | 38 | 0.00 | 0 | 0 | ||
session switching | 47 | 0.00 | 0 | 0 | ||
session timer | 314 | 0.00 | 0 | 0 | ||
shared pool | 2,350 | 0.13 | 0.00 | 0 | 0 | |
shared pool sim alloc | 2 | 0.00 | 0 | 0 | ||
shared pool simulator | 38 | 0.00 | 0 | 0 | ||
sim partition latch | 2 | 0.00 | 0 | 0 | ||
simulator hash latch | 21,646,930 | 0.01 | 0.01 | 0 | 0 | |
simulator lru latch | 20,843 | 0.71 | 0.02 | 0 | 21,589,467 | 0.70 |
sort extent pool | 76 | 0.00 | 0 | 0 | ||
space background state object latch | 5 | 0.00 | 0 | 0 | ||
space background task latch | 1,843 | 0.22 | 0.00 | 0 | 607 | 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 | ||
transaction allocation | 45 | 0.00 | 0 | 0 | ||
undo global data | 1,065,491 | 0.01 | 0.04 | 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 | 505,924,400 | 239,995 | 450 | 239,545 |
simulator hash latch | 21,646,930 | 1,507 | 22 | 1,485 |
mostly latch-free SCN | 182,081 | 635 | 13 | 622 |
object queue header operation | 2,330,854 | 450 | 14 | 436 |
session idle bit | 5,405,487 | 438 | 32 | 406 |
redo allocation | 900,547 | 316 | 11 | 305 |
In memory undo latch | 1,305,440 | 277 | 158 | 120 |
enqueue hash chains | 888,071 | 227 | 14 | 213 |
cache buffers lru chain | 451,916 | 181 | 10 | 171 |
simulator lru latch | 20,843 | 148 | 3 | 145 |
messages | 616,540 | 115 | 2 | 113 |
undo global data | 1,065,491 | 73 | 3 | 70 |
DML lock allocation | 498,223 | 43 | 4 | 39 |
checkpoint queue latch | 1,348,925 | 41 | 1 | 40 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
DML lock allocation | ktaiam | 0 | 3 | 1 |
DML lock allocation | ktaidm | 0 | 1 | 3 |
In memory undo latch | ktiFlush: child | 0 | 123 | 50 |
In memory undo latch | kticmt: child | 0 | 38 | 8 |
In memory undo latch | ktichg: child | 0 | 11 | 104 |
In memory undo latch | kticflush_2 | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 128 | 194 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 119 | 39 |
cache buffers chains | kcbget: fast exchange | 0 | 87 | 2 |
cache buffers chains | kcbgtcr: fast path | 0 | 68 | 195 |
cache buffers chains | kcbchg1: mod cr pin | 0 | 65 | 22 |
cache buffers chains | kcbgtcr_2 | 0 | 62 | 36 |
cache buffers chains | kcbgcur_2 | 0 | 22 | 5 |
cache buffers chains | kcbgcur_4 | 0 | 17 | 3 |
cache buffers chains | kcbgtcr_1 | 0 | 15 | 0 |
cache buffers chains | kcbnew: new latch again | 0 | 10 | 0 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 6 | 0 |
cache buffers chains | kcbzwb | 0 | 5 | 5 |
cache buffers chains | kcbget: fast path | 0 | 4 | 1 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 4 | 8 |
cache buffers chains | kcbnlc | 0 | 4 | 4 |
cache buffers chains | kcbrls: fast release | 0 | 4 | 74 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 3 | 3 |
cache buffers chains | kcbbic2 | 0 | 2 | 0 |
cache buffers chains | kcbbxsv | 0 | 2 | 0 |
cache buffers chains | kcb_pre_apply: kcbhq61 | 0 | 1 | 5 |
cache buffers chains | kcbchg1: clear MS bit | 0 | 1 | 3 |
cache buffers chains | kcbget: pin buffer | 0 | 1 | 0 |
cache buffers chains | kcbrls_2 | 0 | 1 | 9 |
cache buffers chains | kcbzib: exchange rls | 0 | 1 | 3 |
cache buffers lru chain | kcbzgws | 0 | 9 | 0 |
cache buffers lru chain | kcbo_link_q | 0 | 1 | 0 |
checkpoint queue latch | kcbklbc_cql | 0 | 1 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 11 | 4 |
enqueue hash chains | ksqrcl | 0 | 2 | 10 |
enqueue hash chains | ksqcmi: get hash chain latch after wait | 0 | 1 | 0 |
lgwr LWN SCN | kcs023 | 0 | 8 | 0 |
messages | ksaamb: after wakeup | 0 | 1 | 1 |
messages | ksarcv | 0 | 1 | 1 |
mostly latch-free SCN | kcslcu3 | 0 | 5 | 13 |
object queue header operation | kcbo_switch_cq | 0 | 4 | 6 |
object queue header operation | kcbo_link_q | 0 | 3 | 0 |
object queue header operation | kcbo_unlink_q | 0 | 3 | 4 |
object queue header operation | kcbo_check_flist | 0 | 1 | 3 |
object queue header operation | kcbo_link_q:reget | 0 | 1 | 0 |
object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 1 |
object queue header operation | kcbo_switch_q_bg | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 11 | 0 |
session idle bit | ksupuc: set busy | 0 | 20 | 16 |
session idle bit | ksupuc: clear busy | 0 | 11 | 14 |
session idle bit | ksuxds | 0 | 3 | 4 |
simulator hash latch | kcbsacc: lookup dba | 0 | 22 | 21 |
simulator lru latch | kcbs_simulate: simulate set | 0 | 3 | 0 |
undo global data | ktubnd_4 | 0 | 2 | 0 |
undo global data | ktudnx:child | 0 | 1 | 1 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kksfbc [KKSCHLPIN1] | 24 | 0 |
Library Cache | kglpin1 4 | 15 | 0 |
Library Cache | kglpndl1 95 | 11 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 10 | 0 |
Library Cache | kglpnal1 90 | 8 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | ITEM_ORDER_IX | INDEX | 117,716,448 | 32.13 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 117,354,960 | 32.03 | |
SOE | SOE | ORDERS | TABLE | 58,667,760 | 16.01 | |
SOE | SOE | CUSTOMERS | TABLE | 58,425,952 | 15.95 | |
SOE | SOE | PRODUCT_INFORMATION | TABLE | 6,935,312 | 1.89 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 107,285 | 20.52 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 103,490 | 19.79 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 65,816 | 12.59 | |
SOE | SOE | INVENTORIES | TABLE | 47,667 | 9.12 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 46,285 | 8.85 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 107,283 | 20.56 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 103,490 | 19.84 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 65,816 | 12.61 | |
SOE | SOE | INVENTORIES | TABLE | 47,667 | 9.14 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 46,285 | 8.87 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SOE | SOE | CUSTOMERS | TABLE | 107,283 | 20.56 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 103,490 | 19.84 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 65,816 | 12.61 | |
SOE | SOE | INVENTORIES | TABLE | 47,667 | 9.14 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 46,285 | 8.87 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SOE | SOE | INVENTORIES | TABLE | 68,342 | 20.08 | |
SOE | SOE | ORDER_PK | INDEX | 36,810 | 10.81 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 35,321 | 10.38 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 32,622 | 9.58 | |
SOE | SOE | ORDER_ITEMS_PK | INDEX | 32,536 | 9.56 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SOE | SOE | INVENTORIES | TABLE | 36,889 | 15.60 | |
SOE | SOE | ORDER_PK | INDEX | 34,555 | 14.61 | |
SOE | SOE | ORD_CUSTOMER_IX | INDEX | 32,424 | 13.71 | |
SOE | SOE | ORDER_ITEMS_PK | INDEX | 30,019 | 12.70 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 29,477 | 12.47 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2532911053_1819 | TABLE PARTITION | 27 | 32.93 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDER_ITEMS | TABLE | 91,216 | 17.68 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 79,824 | 15.47 | |
SOE | SOE | ORDERS | TABLE | 70,528 | 13.67 | |
SOE | SOE | INVENTORIES | TABLE | 64,816 | 12.56 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 63,184 | 12.24 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 685 | 56.94 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 292 | 24.27 | |
SOE | SOE | ITEM_PRODUCT_IX | INDEX | 96 | 7.98 | |
SOE | SOE | ORD_WAREHOUSE_IX | INDEX | 35 | 2.91 | |
SOE | SOE | CUST_LNAME_IX | INDEX | 24 | 2.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SOE | SOE | ORDERS | TABLE | 334 | 96.53 | |
SOE | SOE | CUSTOMERS_PK | INDEX | 4 | 1.16 | |
SOE | SOE | ORD_ORDER_DATE_IX | INDEX | 3 | 0.87 | |
SOE | SOE | ITEM_ORDER_IX | INDEX | 2 | 0.58 | |
SOE | SOE | ORDER_PK | INDEX | 2 | 0.58 |
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 | 7 | 0.00 | 0 | 0 | 24 | |
dc_histogram_data | 78 | 44.87 | 0 | 0 | 2,000 | |
dc_histogram_defs | 41 | 12.20 | 0 | 0 | 2,024 | |
dc_objects | 229 | 0.44 | 0 | 1 | 1,501 | |
dc_profiles | 2 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 963 | 0.00 | 0 | 0 | 78 | |
dc_segments | 121 | 0.00 | 0 | 10 | 614 | |
dc_sequences | 10 | 0.00 | 0 | 10 | 5 | |
dc_tablespaces | 506 | 0.00 | 0 | 0 | 7 | |
dc_users | 234 | 0.00 | 0 | 0 | 46 | |
global database name | 612 | 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 |
---|---|---|---|---|---|---|
BODY | 15 | 0.00 | 44 | 0.00 | 0 | 0 |
CLUSTER | 2 | 0.00 | 2 | 0.00 | 0 | 0 |
DBLINK | 1 | 0.00 | 0 | 0 | 0 | |
EDITION | 8 | 0.00 | 8 | 0.00 | 0 | 0 |
QUEUE | 262 | 0.00 | 262 | 0.00 | 0 | 0 |
SCHEMA | 1 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 372 | 1.08 | 1,230,463 | -0.02 | 1 | 0 |
SQL AREA BUILD | 5 | 100.00 | 0 | 0 | 0 | |
SQL AREA STATS | 5 | 80.00 | 5 | 80.00 | 0 | 0 |
TABLE/PROCEDURE | 27 | 0.00 | 103,351 | 0.00 | 1 | 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 | 151.47 | 2.61 | 2.42 | 14 | 25 | 58 | 58 | |
B | Freeable | 23.56 | 0.00 | 0.81 | 0.46 | 2 | 29 | 29 | |
B | PL/SQL | 2.41 | 2.09 | 0.04 | 0.18 | 1 | 2 | 58 | 58 |
B | SQL | 0.82 | 0.09 | 0.02 | 0.03 | 0 | 9 | 40 | 36 |
E | Other | 153.90 | 2.61 | 2.40 | 14 | 25 | 59 | 59 | |
E | Freeable | 24.13 | 0.00 | 0.78 | 0.42 | 1 | 31 | 31 | |
E | PL/SQL | 2.41 | 2.09 | 0.04 | 0.18 | 1 | 2 | 59 | 59 |
E | SQL | 0.81 | 0.09 | 0.02 | 0.03 | 0 | 9 | 41 | 36 |
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.44 | 18.43 | -0.04 |
shared | KGLHD | 3.81 | 3.82 | 0.20 |
shared | KGLS | 4.36 | 4.37 | 0.09 |
shared | KGLSG | 5.02 | 5.02 | 0.00 |
shared | KKSSP | 2.72 | 2.76 | 1.41 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PLMCD | 3.20 | 3.20 | 0.00 |
shared | SQLA | 22.26 | 22.32 | 0.30 |
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 | 87.14 | 86.99 | -0.17 |
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.05 | 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 |