DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
coredb | 87227165 | coredb2 | 2 | 17-5月 -13 04:05 | 11.2.0.2.0 | YES |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
core-db2 | AIX-Based Systems (64-bit) | 24 | 12 | 45.25 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 25476 | 07-8月 -13 22:00:05 | 501 | 7.3 |
End Snap: | 25477 | 07-8月 -13 23:00:14 | 838 | 7.8 |
Elapsed: | 60.15 (mins) | |||
DB Time: | 4,155.71 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 14,784M | 14,784M | Std Block Size: | 8K |
Shared Pool Size: | 9,472M | 9,472M | Log Buffer: | 16,536K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 69.1 | 1.5 | 0.14 | 0.04 |
DB CPU(s): | 1.7 | 0.0 | 0.00 | 0.00 |
Redo size: | 63,544.3 | 1,376.9 | ||
Logical reads: | 103,991.1 | 2,253.3 | ||
Block changes: | 359.4 | 7.8 | ||
Physical reads: | 8,967.0 | 194.3 | ||
Physical writes: | 18.9 | 0.4 | ||
User calls: | 1,580.4 | 34.3 | ||
Parses: | 401.5 | 8.7 | ||
Hard parses: | 51.0 | 1.1 | ||
W/A MB processed: | 11.1 | 0.2 | ||
Logons: | 0.7 | 0.0 | ||
Executes: | 481.7 | 10.4 | ||
Rollbacks: | 31.3 | 0.7 | ||
Transactions: | 46.2 |
Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.92 | In-memory Sort %: | 100.00 |
Library Hit %: | 83.20 | Soft Parse %: | 87.31 |
Execute to Parse %: | 16.65 | Latch Hit %: | 99.81 |
Parse CPU to Parse Elapsd %: | 0.23 | % Non-Parse CPU: | 92.76 |
Begin | End | |
---|---|---|
Memory Usage %: | 55.50 | 55.56 |
% SQL with executions>1: | 79.15 | 78.39 |
% Memory for SQL w/exec>1: | 74.28 | 75.64 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
library cache lock | 7,515 | 185,641 | 24703 | 74.45 | Concurrency |
cursor: pin S wait on X | 218 | 30,134 | 138229 | 12.09 | Concurrency |
DB CPU | 6,146 | 2.47 | |||
library cache load lock | 2,204 | 3,273 | 1485 | 1.31 | Concurrency |
library cache pin | 9,288 | 2,771 | 298 | 1.11 | Concurrency |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
4.71 | 5.09 | 9.6 | 4.1 | 3.6 | 86.3 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
20.9 | 152.3 | 1.1 |
Begin | End | |
---|---|---|
Host Mem (MB): | 46,335.9 | 46,335.9 |
SGA use (MB): | 24,576.0 | 24,576.0 |
PGA use (MB): | 2,756.7 | 4,113.9 |
% Host Mem used for SGA+PGA: | 58.99 | 61.92 |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 103.82 | 2.25 |
Global Cache blocks served: | 176.52 | 3.82 |
GCS/GES messages received: | 769.63 | 16.68 |
GCS/GES messages sent: | 461.25 | 9.99 |
DBWR Fusion writes: | 5.01 | 0.11 |
Estd Interconnect traffic (KB) | 2,483.14 |
Buffer access - local cache %: | 99.81 |
Buffer access - remote cache %: | 0.11 |
Buffer access - disk %: | 0.08 |
Avg global enqueue get time (ms): | 92.5 |
Avg global cache cr block receive time (ms): | 3.9 |
Avg global cache current block receive time (ms): | 2.9 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.0 |
Global cache log flushes for cr blocks served %: | 12.2 |
Avg global cache cr block flush time (ms): | 27.4 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.0 |
Global cache log flushes for current blocks served %: | 0.3 |
Avg global cache current block flush time (ms): | 159.9 |
Avg message sent queue time (ms): | 6.4 |
Avg message sent queue time on ksxp (ms): | 19.1 |
Avg message received queue time (ms): | 0.4 |
Avg GCS message process time (ms): | 0.0 |
Avg GES message process time (ms): | 0.1 |
% of direct sent messages: | 65.42 |
% of indirect sent messages: | 34.22 |
% of flow controlled messages: | 0.36 |
Begin | End | |||||
---|---|---|---|---|---|---|
Interface | IP Address | Pub | Source | IP | Pub | Src |
en9 | 169.254.224.51 | N |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
parse time elapsed | 223,529.38 | 89.65 |
hard parse elapsed time | 169,891.77 | 68.14 |
sql execute elapsed time | 54,294.80 | 21.78 |
PL/SQL compilation elapsed time | 33,016.38 | 13.24 |
DB CPU | 6,146.41 | 2.47 |
failed parse elapsed time | 3,119.54 | 1.25 |
hard parse (sharing criteria) elapsed time | 1,638.85 | 0.66 |
hard parse (bind mismatch) elapsed time | 728.70 | 0.29 |
connection management call elapsed time | 76.95 | 0.03 |
PL/SQL execution elapsed time | 59.10 | 0.02 |
sequence load elapsed time | 21.45 | 0.01 |
repeated bind elapsed time | 0.12 | 0.00 |
DB time | 249,342.34 | |
background elapsed time | 14,892.75 | |
background cpu time | 12,295.86 |
Statistic | Value | End Value |
---|---|---|
NUM_LCPUS | 0 | |
NUM_VCPUS | 0 | |
AVG_BUSY_TIME | 50,318 | |
AVG_IDLE_TIME | 317,930 | |
AVG_IOWAIT_TIME | 13,231 | |
AVG_SYS_TIME | 14,886 | |
AVG_USER_TIME | 35,318 | |
BUSY_TIME | 1,210,533 | |
IDLE_TIME | 7,633,105 | |
IOWAIT_TIME | 320,353 | |
SYS_TIME | 360,066 | |
USER_TIME | 850,467 | |
LOAD | 5 | 5 |
OS_CPU_WAIT_TIME | 2,114,800 | |
RSRC_MGR_CPU_WAIT_TIME | 266,817 | |
VM_IN_BYTES | 1,049,960,448 | |
VM_OUT_BYTES | 3,864,756,216 | |
PHYSICAL_MEMORY_BYTES | 48,586,686,464 | |
NUM_CPUS | 24 | |
NUM_CPU_CORES | 12 | |
GLOBAL_RECEIVE_SIZE_MAX | 1,310,720 | |
GLOBAL_SEND_SIZE_MAX | 1,310,720 | |
TCP_RECEIVE_SIZE_DEFAULT | 16,384 | |
TCP_RECEIVE_SIZE_MAX | 9,223,372,036,854,775,807 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 9,223,372,036,854,775,807 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
07-8月 22:00:05 | 4.71 | |||||
07-8月 23:00:14 | 5.09 | 13.69 | 9.62 | 4.07 | 86.31 | 3.62 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Concurrency | 52,121 | 0 | 222,624 | 4271 | 89.28 |
DB CPU | 6,146 | 2.47 | |||
User I/O | 257,796 | 0 | 3,460 | 13 | 1.39 |
Other | 50,128 | 73 | 3,427 | 68 | 1.37 |
Scheduler | 64,324 | 0 | 2,735 | 43 | 1.10 |
Cluster | 468,758 | 0 | 2,451 | 5 | 0.98 |
Application | 40,714 | 0 | 1,277 | 31 | 0.51 |
Commit | 68,293 | 0 | 1,214 | 18 | 0.49 |
Network | 5,204,849 | 0 | 438 | 0 | 0.18 |
System I/O | 9,007 | 0 | 18 | 2 | 0.01 |
Configuration | 178 | 8 | 13 | 71 | 0.01 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
library cache lock | 7,515 | 0 | 185,641 | 24703 | 0.05 | 74.45 |
cursor: pin S wait on X | 218 | 0 | 30,134 | 138229 | 0.00 | 12.09 |
library cache load lock | 2,204 | 0 | 3,273 | 1485 | 0.01 | 1.31 |
library cache pin | 9,288 | 0 | 2,771 | 298 | 0.06 | 1.11 |
resmgr:cpu quantum | 64,324 | 0 | 2,735 | 43 | 0.39 | 1.10 |
KJC: Wait for msg sends to complete | 3,881 | 0 | 2,475 | 638 | 0.02 | 0.99 |
direct path read | 79,731 | 0 | 2,004 | 25 | 0.48 | 0.80 |
db file sequential read | 143,250 | 0 | 1,347 | 9 | 0.86 | 0.54 |
enq: TX - row lock contention | 387 | 0 | 1,256 | 3245 | 0.00 | 0.50 |
log file sync | 68,293 | 0 | 1,214 | 18 | 0.41 | 0.49 |
latch: ges resource hash list | 943 | 0 | 603 | 640 | 0.01 | 0.24 |
gc current block 2-way | 206,581 | 0 | 520 | 3 | 1.24 | 0.21 |
gc buffer busy acquire | 19,965 | 0 | 414 | 21 | 0.12 | 0.17 |
gc cr block 2-way | 121,108 | 0 | 388 | 3 | 0.73 | 0.16 |
buffer busy waits | 1,361 | 0 | 348 | 256 | 0.01 | 0.14 |
gc buffer busy release | 1,152 | 0 | 319 | 277 | 0.01 | 0.13 |
SQL*Net more data from client | 6,548 | 0 | 299 | 46 | 0.04 | 0.12 |
library cache: mutex X | 13,630 | 0 | 277 | 20 | 0.08 | 0.11 |
gc current grant busy | 42,801 | 0 | 195 | 5 | 0.26 | 0.08 |
gc cr grant congested | 55 | 0 | 152 | 2769 | 0.00 | 0.06 |
gc cr grant 2-way | 36,930 | 0 | 145 | 4 | 0.22 | 0.06 |
SQL*Net message to client | 5,194,009 | 0 | 139 | 0 | 31.18 | 0.06 |
name-service call wait | 251 | 92 | 123 | 492 | 0.00 | 0.05 |
gc current block busy | 2,176 | 0 | 122 | 56 | 0.01 | 0.05 |
gc cr block busy | 19,291 | 0 | 99 | 5 | 0.12 | 0.04 |
DFS lock handle | 235 | 23 | 97 | 413 | 0.00 | 0.04 |
enq: US - contention | 41 | 0 | 90 | 2188 | 0.00 | 0.04 |
enq: TX - index contention | 464 | 0 | 67 | 145 | 0.00 | 0.03 |
db file scattered read | 18,978 | 0 | 56 | 3 | 0.11 | 0.02 |
latch: row cache objects | 712 | 0 | 54 | 76 | 0.00 | 0.02 |
row cache lock | 11,051 | 0 | 48 | 4 | 0.07 | 0.02 |
gc current grant congested | 24 | 0 | 32 | 1352 | 0.00 | 0.01 |
gc current grant 2-way | 9,338 | 0 | 31 | 3 | 0.06 | 0.01 |
db file parallel read | 1,288 | 0 | 29 | 22 | 0.01 | 0.01 |
gc current retry | 12 | 0 | 19 | 1590 | 0.00 | 0.01 |
control file sequential read | 9,007 | 0 | 18 | 2 | 0.05 | 0.01 |
SQL*Net break/reset to client | 39,856 | 0 | 18 | 0 | 0.24 | 0.01 |
read by other session | 1,134 | 0 | 13 | 11 | 0.01 | 0.01 |
enq: SQ - contention | 140 | 0 | 12 | 86 | 0.00 | 0.00 |
latch free | 2,118 | 0 | 9 | 4 | 0.01 | 0.00 |
gc cr multi block request | 8,745 | 0 | 9 | 1 | 0.05 | 0.00 |
external table open | 13 | 0 | 8 | 621 | 0.00 | 0.00 |
enq: PS - contention | 878 | 2 | 8 | 9 | 0.01 | 0.00 |
latch: shared pool | 1,796 | 0 | 7 | 4 | 0.01 | 0.00 |
gc cr block congested | 157 | 0 | 5 | 30 | 0.00 | 0.00 |
enq: KO - fast object checkpoint | 467 | 0 | 4 | 8 | 0.00 | 0.00 |
reliable message | 291 | 0 | 3 | 11 | 0.00 | 0.00 |
enq: TX - contention | 93 | 100 | 3 | 35 | 0.00 | 0.00 |
buffer exterminate | 318 | 99 | 3 | 10 | 0.00 | 0.00 |
latch: cache buffers chains | 3,863 | 0 | 3 | 1 | 0.02 | 0.00 |
Disk file operations I/O | 11,394 | 0 | 3 | 0 | 0.07 | 0.00 |
latch: gc element | 85 | 0 | 3 | 33 | 0.00 | 0.00 |
IPC send completion sync | 3,459 | 0 | 2 | 1 | 0.02 | 0.00 |
latch: object queue header operation | 26 | 0 | 1 | 51 | 0.00 | 0.00 |
gc current block congested | 225 | 0 | 1 | 6 | 0.00 | 0.00 |
latch: gcs resource hash | 6 | 0 | 1 | 208 | 0.00 | 0.00 |
enq: JQ - contention | 25 | 100 | 1 | 34 | 0.00 | 0.00 |
PX Deq: reap credit | 20,892 | 100 | 1 | 0 | 0.13 | 0.00 |
external table read | 209 | 0 | 1 | 4 | 0.00 | 0.00 |
gc current multi block request | 27 | 0 | 1 | 24 | 0.00 | 0.00 |
asynch descriptor resize | 14,218 | 100 | 1 | 0 | 0.09 | 0.00 |
rdbms ipc reply | 446 | 0 | 1 | 1 | 0.00 | 0.00 |
enq: FB - contention | 14 | 0 | 1 | 37 | 0.00 | 0.00 |
log file switch completion | 6 | 0 | 0 | 68 | 0.00 | 0.00 |
ASM file metadata operation | 2 | 0 | 0 | 104 | 0.00 | 0.00 |
PX Deq: Slave Session Stats | 889 | 0 | 0 | 0 | 0.01 | 0.00 |
undo segment extension | 15 | 100 | 0 | 11 | 0.00 | 0.00 |
cr request retry | 14 | 100 | 0 | 10 | 0.00 | 0.00 |
gc current split | 35 | 0 | 0 | 3 | 0.00 | 0.00 |
SQL*Net more data to client | 4,292 | 0 | 0 | 0 | 0.03 | 0.00 |
resmgr:internal state change | 1 | 100 | 0 | 100 | 0.00 | 0.00 |
gc cr disk read | 122 | 0 | 0 | 1 | 0.00 | 0.00 |
buffer deadlock | 788 | 100 | 0 | 0 | 0.00 | 0.00 |
CSS initialization | 2 | 0 | 0 | 20 | 0.00 | 0.00 |
latch: enqueue hash chains | 62 | 0 | 0 | 1 | 0.00 | 0.00 |
external table seek | 13 | 0 | 0 | 2 | 0.00 | 0.00 |
enq: TX - allocate ITL entry | 17 | 0 | 0 | 1 | 0.00 | 0.00 |
utl_file I/O | 1,785 | 0 | 0 | 0 | 0.01 | 0.00 |
PX Deq: Signal ACK RSG | 39 | 0 | 0 | 0 | 0.00 | 0.00 |
CSS operation: action | 2 | 0 | 0 | 4 | 0.00 | 0.00 |
enq: TT - contention | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
gc cr failure | 14 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: session allocation | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
PX Deq: Signal ACK EXT | 39 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: AE - lock | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
global enqueue expand wait | 6 | 0 | 0 | 1 | 0.00 | 0.00 |
CSS operation: query | 6 | 0 | 0 | 0 | 0.00 | 0.00 |
cursor: pin S | 17 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: TM - contention | 4 | 100 | 0 | 1 | 0.00 | 0.00 |
enq: TO - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
direct path write temp | 1 | 0 | 0 | 2 | 0.00 | 0.00 |
latch: cache buffers lru chain | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: MD - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
SQL*Net message from client | 5,193,671 | 0 | 10,123,748 | 1949 | 31.18 | |
jobq slave wait | 4,025 | 100 | 2,011 | 500 | 0.02 | |
PX Deq: Execution Msg | 3,400 | 0 | 588 | 173 | 0.02 | |
PX Deq: Msg Fragment | 775 | 0 | 4 | 6 | 0.00 | |
PX Deq: Parse Reply | 39 | 0 | 3 | 79 | 0.00 | |
PX Deq Credit: send blkd | 5,251 | 0 | 1 | 0 | 0.03 | |
PX Deq: Join ACK | 39 | 0 | 1 | 19 | 0.00 | |
PX Deq: Execute Reply | 40 | 0 | 1 | 14 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
latch free | 536 | 0 | 1,028 | 1918 | 0.00 | 6.90 |
log file parallel write | 121,883 | 0 | 324 | 3 | 0.73 | 2.17 |
os thread startup | 105 | 1 | 271 | 2580 | 0.00 | 1.82 |
enq: PR - contention | 5 | 0 | 241 | 48207 | 0.00 | 1.62 |
gcs log flush sync | 42,725 | 12 | 128 | 3 | 0.26 | 0.86 |
enq: PV - syncstart | 4 | 0 | 108 | 26882 | 0.00 | 0.72 |
db file parallel write | 13,995 | 0 | 93 | 7 | 0.08 | 0.62 |
gc cr block 2-way | 2,448 | 0 | 92 | 37 | 0.01 | 0.61 |
control file sequential read | 15,084 | 0 | 76 | 5 | 0.09 | 0.51 |
process diagnostic dump | 2,428 | 0 | 42 | 17 | 0.01 | 0.28 |
ges inquiry response | 2,415 | 0 | 26 | 11 | 0.01 | 0.17 |
enq: CF - contention | 352 | 95 | 22 | 63 | 0.00 | 0.15 |
enq: WF - contention | 18 | 0 | 17 | 964 | 0.00 | 0.12 |
Streams AQ: qmn coordinator waiting for slave to start | 3 | 100 | 17 | 5644 | 0.00 | 0.11 |
control file parallel write | 5,007 | 0 | 15 | 3 | 0.03 | 0.10 |
gc buffer busy acquire | 1 | 0 | 13 | 12806 | 0.00 | 0.09 |
db file sequential read | 967 | 0 | 11 | 11 | 0.01 | 0.07 |
log file sequential read | 191 | 0 | 8 | 40 | 0.00 | 0.05 |
latch: gc element | 85 | 0 | 8 | 89 | 0.00 | 0.05 |
ges lms sync during dynamic remastering and reconfig | 72 | 88 | 7 | 99 | 0.00 | 0.05 |
row cache lock | 4,696 | 0 | 6 | 1 | 0.03 | 0.04 |
latch: ges resource hash list | 285 | 0 | 5 | 18 | 0.00 | 0.03 |
row cache cleanup | 72,898 | 0 | 5 | 0 | 0.44 | 0.03 |
ASM file metadata operation | 1,117 | 0 | 4 | 4 | 0.01 | 0.03 |
gc cr grant 2-way | 243 | 0 | 4 | 15 | 0.00 | 0.02 |
LGWR wait for redo copy | 1,535 | 0 | 4 | 2 | 0.01 | 0.02 |
DFS lock handle | 5,553 | 31 | 3 | 1 | 0.03 | 0.02 |
PX Deq: reap credit | 6,710 | 100 | 2 | 0 | 0.04 | 0.01 |
row cache process | 37,413 | 0 | 2 | 0 | 0.22 | 0.01 |
latch: gcs resource hash | 29 | 0 | 2 | 56 | 0.00 | 0.01 |
latch: object queue header operation | 185 | 0 | 2 | 9 | 0.00 | 0.01 |
gc current block 2-way | 2,191 | 0 | 2 | 1 | 0.01 | 0.01 |
ksdxexeotherwait | 3 | 0 | 1 | 435 | 0.00 | 0.01 |
reliable message | 522 | 0 | 1 | 2 | 0.00 | 0.01 |
gc current grant busy | 117 | 0 | 1 | 10 | 0.00 | 0.01 |
library cache: mutex X | 4 | 0 | 1 | 216 | 0.00 | 0.01 |
libcache interrupt action by LCK | 54,301 | 0 | 1 | 0 | 0.33 | 0.00 |
CGS wait for IPC msg | 29,274 | 100 | 1 | 0 | 0.18 | 0.00 |
latch: row cache objects | 41 | 0 | 1 | 14 | 0.00 | 0.00 |
ksxr poll remote instances | 49,835 | 100 | 1 | 0 | 0.30 | 0.00 |
library cache lock | 444 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: US - contention | 981 | 0 | 0 | 0 | 0.01 | 0.00 |
kjbdrmcvtq lmon drm quiesce: ping completion | 22 | 0 | 0 | 18 | 0.00 | 0.00 |
enq: TM - contention | 10 | 80 | 0 | 39 | 0.00 | 0.00 |
ADR block file write | 19 | 0 | 0 | 19 | 0.00 | 0.00 |
db file parallel read | 13 | 0 | 0 | 28 | 0.00 | 0.00 |
Parameter File I/O | 80 | 0 | 0 | 4 | 0.00 | 0.00 |
CSS initialization | 5 | 0 | 0 | 67 | 0.00 | 0.00 |
library cache pin | 489 | 0 | 0 | 1 | 0.00 | 0.00 |
gc current grant 2-way | 302 | 0 | 0 | 1 | 0.00 | 0.00 |
name-service call wait | 8 | 0 | 0 | 34 | 0.00 | 0.00 |
gc current block busy | 35 | 0 | 0 | 7 | 0.00 | 0.00 |
latch: messages | 4 | 0 | 0 | 65 | 0.00 | 0.00 |
ADR block file read | 47 | 0 | 0 | 5 | 0.00 | 0.00 |
ADR file lock | 22 | 18 | 0 | 10 | 0.00 | 0.00 |
gc cr multi block request | 214 | 0 | 0 | 1 | 0.00 | 0.00 |
Disk file operations I/O | 372 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: KO - fast object checkpoint | 212 | 0 | 0 | 1 | 0.00 | 0.00 |
ges generic event | 15 | 87 | 0 | 10 | 0.00 | 0.00 |
enq: CR - block range reuse ckpt | 290 | 0 | 0 | 0 | 0.00 | 0.00 |
Log archive I/O | 4 | 0 | 0 | 32 | 0.00 | 0.00 |
gc current grant congested | 4 | 0 | 0 | 30 | 0.00 | 0.00 |
CSS operation: action | 12 | 0 | 0 | 10 | 0.00 | 0.00 |
gc cr grant congested | 5 | 0 | 0 | 22 | 0.00 | 0.00 |
gc cr block busy | 11 | 0 | 0 | 6 | 0.00 | 0.00 |
ges LMON to get to FTDONE | 4 | 50 | 0 | 16 | 0.00 | 0.00 |
latch: shared pool | 37 | 0 | 0 | 1 | 0.00 | 0.00 |
db file scattered read | 2 | 0 | 0 | 24 | 0.00 | 0.00 |
buffer busy waits | 59 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: PS - contention | 24 | 50 | 0 | 2 | 0.00 | 0.00 |
ARCH wait for archivelog lock | 1 | 0 | 0 | 40 | 0.00 | 0.00 |
gc buffer busy release | 5 | 0 | 0 | 5 | 0.00 | 0.00 |
enq: TQ - TM contention | 16 | 0 | 0 | 2 | 0.00 | 0.00 |
log file sync | 3 | 0 | 0 | 7 | 0.00 | 0.00 |
direct path write | 5 | 0 | 0 | 4 | 0.00 | 0.00 |
enq: RO - fast object reuse | 26 | 0 | 0 | 1 | 0.00 | 0.00 |
CSS operation: query | 14 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TT - contention | 27 | 67 | 0 | 0 | 0.00 | 0.00 |
enq: WL - contention | 1 | 100 | 0 | 10 | 0.00 | 0.00 |
enq: TA - contention | 13 | 0 | 0 | 1 | 0.00 | 0.00 |
ges2 LMON to wake up LMD - mrcvr | 4 | 0 | 0 | 2 | 0.00 | 0.00 |
rdbms ipc reply | 44 | 0 | 0 | 0 | 0.00 | 0.00 |
kfk: async disk IO | 3 | 0 | 0 | 2 | 0.00 | 0.00 |
CSS operation: data query | 2 | 0 | 0 | 3 | 0.00 | 0.00 |
gc current multi block request | 8 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: FB - contention | 9 | 0 | 0 | 1 | 0.00 | 0.00 |
CSS group registration | 1 | 0 | 0 | 5 | 0.00 | 0.00 |
IPC send completion sync | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
gc current block congested | 6 | 0 | 0 | 1 | 0.00 | 0.00 |
PX Deq: Signal ACK RSG | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
asynch descriptor resize | 1,841 | 100 | 0 | 0 | 0.01 | 0.00 |
SQL*Net message to client | 3,679 | 0 | 0 | 0 | 0.02 | 0.00 |
enq: HW - contention | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
PX Deq: Slave Session Stats | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers lru chain | 6 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: redo allocation | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: checkpoint queue latch | 1 | 0 | 0 | 2 | 0.00 | 0.00 |
log file single write | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
KJC: Wait for msg sends to complete | 173 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: PW - flush prewarm buffers | 2 | 100 | 0 | 1 | 0.00 | 0.00 |
PX Deq: Signal ACK EXT | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
gc object scan | 12 | 100 | 0 | 0 | 0.00 | 0.00 |
latch: cache buffers chains | 50 | 0 | 0 | 0 | 0.00 | 0.00 |
rdbms ipc message | 307,233 | 24 | 87,921 | 286 | 1.84 | |
PX Idle Wait | 858 | 0 | 12,841 | 14966 | 0.01 | |
class slave wait | 107 | 0 | 11,945 | 111632 | 0.00 | |
Streams AQ: waiting for time management or cleanup tasks | 122 | 81 | 7,880 | 64589 | 0.00 | |
wait for unread message on broadcast channel | 7,220 | 100 | 7,218 | 1000 | 0.04 | |
DIAG idle wait | 238,066 | 95 | 6,996 | 29 | 1.43 | |
gcs remote message | 1,382,015 | 26 | 6,700 | 5 | 8.30 | |
Space Manager: slave idle wait | 1,036 | 98 | 5,127 | 4949 | 0.01 | |
Streams AQ: qmn slave idle wait | 198 | 2 | 4,905 | 24772 | 0.00 | |
ASM background timer | 737 | 0 | 3,611 | 4899 | 0.00 | |
pmon timer | 1,312 | 89 | 3,602 | 2746 | 0.01 | |
PING | 1,410 | 20 | 3,602 | 2555 | 0.01 | |
shared server idle wait | 120 | 100 | 3,600 | 30002 | 0.00 | |
dispatcher timer | 60 | 100 | 3,600 | 60003 | 0.00 | |
smon timer | 81 | 6 | 3,578 | 44175 | 0.00 | |
ges remote message | 1,357,068 | 93 | 3,577 | 3 | 8.15 | |
Streams AQ: qmn coordinator idle wait | 288 | 43 | 3,528 | 12249 | 0.00 | |
GCR sleep | 680 | 100 | 3,400 | 5000 | 0.00 | |
VKRM Idle | 1 | 0 | 2,406 | 2406250 | 0.00 | |
SGA: MMAN sleep for component shrink | 26,830 | 100 | 275 | 10 | 0.16 | |
SQL*Net message from client | 5,044 | 0 | 8 | 1 | 0.03 | |
KSV master wait | 2,205 | 98 | 3 | 1 | 0.01 | |
PX Deq: Join ACK | 18 | 0 | 0 | 12 | 0.00 | |
heartbeat monitor sleep | 1 | 0 | 0 | 77 | 0.00 | |
PX Deq: Parse Reply | 18 | 0 | 0 | 4 | 0.00 | |
PX Deq: Execute Reply | 18 | 0 | 0 | 0 | 0.00 | |
Streams AQ: RAC qmn coordinator idle wait | 292 | 100 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 47 | 48.9 | 6.4 | 23.4 | 12.8 | 8.5 | |||
ADR block file write | 19 | 5.3 | 5.3 | 36.8 | 42.1 | 10.5 | |||
ADR file lock | 22 | 86.4 | 4.5 | 4.5 | 4.5 | ||||
ARCH wait for archivelog lock | 1 | 100.0 | |||||||
ASM file metadata operation | 1117 | 96.3 | 1.0 | 1.0 | .4 | .1 | .1 | 1.0 | .1 |
CGS wait for IPC msg | 29.3K | 99.9 | .0 | .0 | .0 | .0 | .0 | .0 | |
CSS group registration | 1 | 100.0 | |||||||
CSS initialization | 7 | 42.9 | 57.1 | ||||||
CSS operation: action | 14 | 21.4 | 7.1 | 14.3 | 35.7 | 7.1 | 14.3 | ||
CSS operation: data query | 2 | 100.0 | |||||||
CSS operation: query | 20 | 85.0 | 10.0 | 5.0 | |||||
DFS lock handle | 5785 | 92.6 | 5.4 | .9 | .3 | .2 | .2 | .3 | .2 |
Disk file operations I/O | 11.8K | 93.8 | 4.7 | 1.1 | .2 | .1 | .0 | .1 | |
IPC send completion sync | 3458 | 92.3 | 5.3 | 1.2 | .8 | .2 | .1 | .1 | |
KJC: Wait for msg sends to complete | 4046 | 92.8 | .1 | .1 | .1 | .0 | .0 | .1 | 6.6 |
LGWR wait for redo copy | 1534 | 92.0 | 1.0 | 2.2 | 2.1 | 1.0 | .8 | .9 | |
Log archive I/O | 4 | 25.0 | 25.0 | 50.0 | |||||
PX Deq: Signal ACK EXT | 57 | 100.0 | |||||||
PX Deq: Signal ACK RSG | 57 | 87.7 | 12.3 | ||||||
PX Deq: Slave Session Stats | 904 | 97.2 | 1.2 | .8 | .4 | .2 | .1 | ||
PX Deq: reap credit | 27.6K | 99.9 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
PX qref latch | 8 | 100.0 | |||||||
Parameter File I/O | 80 | 36.3 | 1.3 | 26.3 | 28.8 | 1.3 | 6.3 | ||
SQL*Net break/reset to client | 39.8K | 97.0 | 2.1 | .5 | .1 | .1 | .1 | .1 | .0 |
SQL*Net message to client | 5201.5K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
SQL*Net more data from client | 6572 | 67.4 | .1 | .2 | .3 | .8 | 1.4 | 29.9 | |
SQL*Net more data to client | 4302 | 100.0 | .0 | ||||||
Streams AQ: qmn coordinator waiting for slave to start | 3 | 100.0 | |||||||
asynch descriptor resize | 16.1K | 99.7 | .1 | .0 | .0 | .1 | .0 | .0 | |
buffer busy waits | 1420 | 34.4 | 2.5 | 3.5 | 5.6 | 6.0 | 8.7 | 37.3 | 2.2 |
buffer deadlock | 786 | 99.2 | .1 | .5 | .1 | ||||
buffer exterminate | 318 | .9 | 99.1 | ||||||
control file parallel write | 5008 | .3 | 72.6 | 14.3 | 7.9 | 3.4 | .9 | .5 | |
control file sequential read | 24.1K | 50.5 | 32.5 | 5.0 | 4.5 | 3.4 | 1.9 | 2.3 | |
cr request retry | 14 | 100.0 | |||||||
cursor: mutex S | 1 | 100.0 | |||||||
cursor: pin S | 17 | 94.1 | 5.9 | ||||||
cursor: pin S wait on X | 218 | 43.1 | 1.8 | 11.9 | 43.1 | ||||
db file parallel read | 1301 | 3.4 | 5.3 | 6.9 | 6.8 | 25.7 | 33.8 | 18.1 | |
db file parallel write | 14K | 3.5 | 52.0 | 15.8 | 12.3 | 9.9 | 3.3 | 3.3 | |
db file scattered read | 19K | 21.2 | 57.2 | 10.7 | 3.5 | 4.4 | 2.3 | .7 | |
db file sequential read | 143.9K | 27.3 | 16.4 | 3.9 | 7.5 | 28.0 | 13.5 | 3.4 | .0 |
direct path read | 79.6K | .0 | .2 | .8 | 2.4 | 46.5 | 32.3 | 17.8 | |
direct path write | 5 | 20.0 | 40.0 | 40.0 | |||||
direct path write temp | 1 | 100.0 | |||||||
enq: AE - lock | 7 | 100.0 | |||||||
enq: CF - contention | 352 | 83.0 | 9.1 | 3.1 | 2.0 | .6 | .6 | .6 | 1.1 |
enq: CR - block range reuse ckpt | 290 | 95.2 | 3.4 | 1.4 | |||||
enq: FB - contention | 23 | 73.9 | 13.0 | 4.3 | 4.3 | 4.3 | |||
enq: HW - contention | 4 | 75.0 | 25.0 | ||||||
enq: JQ - contention | 25 | 28.0 | 36.0 | 12.0 | 12.0 | 4.0 | 8.0 | ||
enq: JS - job run lock - synchronize | 1 | 100.0 | |||||||
enq: KO - fast object checkpoint | 679 | 75.0 | 5.3 | 3.8 | 2.7 | 6.6 | 3.5 | 3.1 | |
enq: MD - contention | 4 | 100.0 | |||||||
enq: PR - contention | 5 | 20.0 | 80.0 | ||||||
enq: PS - contention | 899 | 85.8 | 9.0 | 2.7 | .9 | .7 | .4 | .3 | .2 |
enq: PV - syncstart | 4 | 100.0 | |||||||
enq: PW - flush prewarm buffers | 2 | 100.0 | |||||||
enq: RO - fast object reuse | 26 | 92.3 | 3.8 | 3.8 | |||||
enq: SQ - contention | 140 | 5.0 | 5.7 | 12.1 | 8.6 | 2.9 | 3.6 | 62.1 | |
enq: TA - contention | 13 | 92.3 | 7.7 | ||||||
enq: TD - KTF dump entries | 1 | 100.0 | |||||||
enq: TM - contention | 14 | 92.9 | 7.1 | ||||||
enq: TO - contention | 4 | 100.0 | |||||||
enq: TQ - TM contention | 16 | 75.0 | 12.5 | 12.5 | |||||
enq: TT - contention | 38 | 89.5 | 7.9 | 2.6 | |||||
enq: TX - allocate ITL entry | 17 | 70.6 | 11.8 | 5.9 | 11.8 | ||||
enq: TX - contention | 93 | 74.2 | 9.7 | 6.5 | 3.2 | 1.1 | 4.3 | 1.1 | |
enq: TX - index contention | 466 | 26.4 | 6.4 | 4.3 | 2.6 | 5.4 | 5.8 | 48.5 | .6 |
enq: TX - row lock contention | 387 | 34.6 | 16.8 | 12.9 | 9.3 | 10.1 | 7.2 | 5.9 | 3.1 |
enq: US - contention | 1022 | 94.7 | 1.7 | .8 | .3 | .1 | .4 | 1.2 | .9 |
enq: WF - contention | 18 | 77.8 | 5.6 | 5.6 | 5.6 | 5.6 | |||
enq: WL - contention | 1 | 100.0 | |||||||
external table open | 13 | 92.3 | 7.7 | ||||||
external table read | 209 | 94.7 | .5 | 2.4 | 2.4 | ||||
external table seek | 13 | 92.3 | 7.7 | ||||||
gc buffer busy acquire | 20K | 81.3 | 7.4 | 2.7 | 2.0 | 1.8 | 1.5 | 3.1 | .2 |
gc buffer busy release | 1157 | 7.5 | 6.7 | 3.6 | 4.2 | 3.8 | 10.1 | 63.8 | .3 |
gc cr block 2-way | 123.6K | 93.8 | 4.0 | 1.1 | .4 | .3 | .2 | .2 | .0 |
gc cr block busy | 19.3K | .6 | 48.8 | 31.8 | 9.3 | 5.9 | 1.9 | 1.7 | .0 |
gc cr block congested | 159 | 79.2 | 7.5 | 1.9 | 1.9 | .6 | .6 | 7.5 | .6 |
gc cr disk read | 123 | 91.9 | 5.7 | .8 | .8 | .8 | |||
gc cr failure | 14 | 92.9 | 7.1 | ||||||
gc cr grant 2-way | 37.2K | 94.9 | 3.0 | 1.0 | .4 | .3 | .2 | .2 | .0 |
gc cr grant congested | 61 | 68.9 | 3.3 | 3.3 | 1.6 | 3.3 | 13.1 | 6.6 | |
gc cr multi block request | 8926 | 88.6 | 7.6 | 1.8 | 1.1 | .6 | .2 | .1 | |
gc current block 2-way | 208.7K | 94.7 | 3.6 | .9 | .4 | .2 | .1 | .1 | .0 |
gc current block busy | 2209 | 14.2 | 27.7 | 21.1 | 12.4 | 13.9 | 4.8 | 5.4 | .5 |
gc current block congested | 230 | 85.2 | 7.0 | .4 | 2.6 | .9 | 1.3 | 2.6 | |
gc current grant 2-way | 9727 | 94.3 | 2.8 | 1.0 | .6 | .5 | .3 | .5 | .1 |
gc current grant busy | 42.9K | 92.7 | 4.6 | 1.4 | .5 | .3 | .1 | .3 | .0 |
gc current grant congested | 28 | 42.9 | 7.1 | 10.7 | 3.6 | 17.9 | 17.9 | ||
gc current multi block request | 35 | 51.4 | 11.4 | 2.9 | 8.6 | 8.6 | 5.7 | 11.4 | |
gc current retry | 12 | 66.7 | 8.3 | 8.3 | 8.3 | 8.3 | |||
gc current split | 36 | 83.3 | 2.8 | 2.8 | 5.6 | 2.8 | 2.8 | ||
gc object scan | 12 | 100.0 | |||||||
gcs log flush sync | 42.6K | 39.9 | 32.5 | 8.6 | 6.7 | 10.6 | 1.5 | .2 | .0 |
ges LMON to get to FTDONE | 4 | 50.0 | 50.0 | ||||||
ges generic event | 15 | 13.3 | 73.3 | 13.3 | |||||
ges inquiry response | 2413 | 86.2 | 9.0 | 2.5 | 1.2 | .5 | .1 | .2 | .2 |
ges lms sync during dynamic remastering and reconfig | 72 | 2.8 | 9.7 | 1.4 | 20.8 | 63.9 | 1.4 | ||
ges2 LMON to wake up LMD - mrcvr | 4 | 75.0 | 25.0 | ||||||
global enqueue expand wait | 6 | 100.0 | |||||||
kfk: async disk IO | 3 | 33.3 | 33.3 | 33.3 | |||||
kjbdrmcvtq lmon drm quiesce: ping completion | 22 | 27.3 | 4.5 | 13.6 | 4.5 | 13.6 | 22.7 | 13.6 | |
ksdxexeotherwait | 3 | 33.3 | 33.3 | 33.3 | |||||
ksxr poll remote instances | 49.6K | 100.0 | .0 | .0 | |||||
latch free | 2652 | 84.3 | 4.7 | 2.1 | .9 | 1.3 | .5 | 2.6 | 3.6 |
latch: cache buffers chains | 3914 | 98.0 | .6 | .4 | .4 | .2 | .2 | .2 | .0 |
latch: cache buffers lru chain | 10 | 90.0 | 10.0 | ||||||
latch: call allocation | 4 | 100.0 | |||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 64 | 92.2 | 4.7 | 1.6 | 1.6 | ||||
latch: gc element | 170 | 55.3 | 11.2 | 7.6 | 5.9 | 3.5 | 2.9 | 12.9 | .6 |
latch: gcs resource hash | 35 | 17.1 | 11.4 | 20.0 | 14.3 | 2.9 | 34.3 | ||
latch: ges resource hash list | 1232 | 36.0 | 1.3 | 1.8 | 4.7 | 1.4 | .3 | 39.8 | 14.8 |
latch: messages | 4 | 25.0 | 25.0 | 50.0 | |||||
latch: object queue header operation | 211 | 69.7 | 12.3 | 9.0 | 1.9 | 2.8 | .9 | 3.3 | |
latch: redo allocation | 10 | 100.0 | |||||||
latch: row cache objects | 754 | 55.4 | 3.7 | 4.9 | 4.1 | 3.1 | 4.0 | 24.8 | |
latch: session allocation | 7 | 57.1 | 42.9 | ||||||
latch: shared pool | 1837 | 83.6 | 6.6 | 3.9 | .5 | .3 | 1.5 | 3.4 | |
latch: undo global data | 1 | 100.0 | |||||||
libcache interrupt action by LCK | 54.1K | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
library cache load lock | 2204 | 2.6 | 3.4 | 6.9 | .6 | 1.1 | 2.5 | 47.2 | 35.8 |
library cache lock | 7992 | 78.3 | 5.6 | 2.5 | 1.0 | .8 | .6 | 1.4 | 9.8 |
library cache pin | 9823 | 84.5 | 3.8 | 2.1 | 1.6 | 3.3 | .2 | .5 | 4.0 |
library cache: mutex X | 13.7K | 62.7 | 4.4 | 4.2 | 5.0 | 7.1 | 5.0 | 11.5 | .1 |
lock deadlock retry | 2 | 100.0 | |||||||
lock escalate retry | 9 | 100.0 | |||||||
log file parallel write | 122K | 44.4 | 36.8 | 5.8 | 7.2 | 3.9 | 1.2 | .7 | |
log file sequential read | 191 | 4.2 | .5 | 23.0 | 52.4 | 19.9 | |||
log file single write | 2 | 100.0 | |||||||
log file switch completion | 6 | 16.7 | 16.7 | 66.7 | |||||
log file sync | 68.5K | 15.5 | 50.5 | 14.1 | 9.3 | 6.1 | 2.3 | 2.1 | .0 |
name-service call wait | 259 | .4 | .4 | .8 | 3.1 | 95.4 | |||
os thread startup | 105 | 88.6 | 11.4 | ||||||
process diagnostic dump | 2428 | 22.5 | 64.5 | 11.9 | .6 | .2 | .2 | .2 | |
rdbms ipc reply | 481 | 79.0 | 11.4 | 3.7 | 4.0 | 1.0 | .2 | .6 | |
read by other session | 1134 | 12.0 | 10.3 | 7.5 | 15.0 | 32.7 | 18.7 | 3.8 | |
reliable message | 813 | 62.1 | 10.3 | 19.9 | 4.9 | 1.4 | .5 | .9 | |
resmgr:cpu quantum | 64.3K | 14.0 | 6.1 | 8.8 | 13.4 | 17.2 | 17.1 | 23.3 | .0 |
resmgr:internal state change | 1 | 100.0 | |||||||
row cache cleanup | 72.6K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
row cache lock | 15.7K | 87.8 | 8.6 | 1.8 | 1.0 | .2 | .2 | .4 | .1 |
row cache process | 37.2K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
undo segment extension | 15 | 33.3 | 33.3 | 26.7 | 6.7 | ||||
utl_file I/O | 1785 | 99.9 | .1 | ||||||
ASM background timer | 737 | .8 | .3 | .1 | .1 | .1 | .3 | 98.2 | |
DIAG idle wait | 238.5K | 3.5 | .5 | .5 | 15.2 | 55.1 | 9.6 | 15.7 | .0 |
GCR sleep | 680 | 100.0 | |||||||
KSV master wait | 2205 | 99.5 | .0 | .1 | .1 | .1 | .0 | ||
PING | 1410 | 77.8 | .6 | 1.0 | .1 | .2 | .1 | 20.1 | |
PX Deq Credit: send blkd | 5251 | 99.6 | .1 | .0 | .1 | .0 | .0 | .1 | |
PX Deq: Execute Reply | 58 | 72.4 | 6.9 | 10.3 | 5.2 | 1.7 | 3.4 | ||
PX Deq: Execution Msg | 3388 | 76.1 | 7.5 | 2.9 | 2.3 | 3.1 | 2.3 | 4.0 | 1.9 |
PX Deq: Join ACK | 57 | 24.6 | 3.5 | 40.4 | 19.3 | 3.5 | 1.8 | 7.0 | |
PX Deq: Msg Fragment | 775 | 95.7 | 2.6 | .9 | .3 | .1 | .1 | .1 | .1 |
PX Deq: Parse Reply | 57 | 19.3 | 12.3 | 8.8 | 17.5 | 10.5 | 5.3 | 24.6 | 1.8 |
PX Idle Wait | 847 | 3.9 | 34.9 | 16.9 | 5.9 | 1.9 | 1.4 | 6.3 | 28.8 |
SGA: MMAN sleep for component shrink | 26.8K | .1 | .0 | .0 | .0 | 99.2 | .5 | .1 | |
SQL*Net message from client | 5202.5K | 81.3 | 7.5 | 1.9 | .8 | .6 | .8 | 5.4 | 1.6 |
Space Manager: slave idle wait | 1036 | .1 | .1 | .3 | 99.5 | ||||
Streams AQ: RAC qmn coordinator idle wait | 292 | 100.0 | |||||||
Streams AQ: qmn coordinator idle wait | 288 | 50.7 | 2.1 | 1.4 | 1.0 | 1.0 | .3 | 43.4 | |
Streams AQ: qmn slave idle wait | 198 | 11.1 | 88.9 | ||||||
Streams AQ: waiting for time management or cleanup tasks | 122 | 17.2 | 27.0 | 55.7 | |||||
class slave wait | 106 | 44.3 | 2.8 | .9 | 11.3 | 7.5 | 9.4 | 23.6 | |
dispatcher timer | 60 | 100.0 | |||||||
gcs remote message | 1381K | 29.8 | 13.8 | 13.5 | 13.2 | 27.3 | 2.4 | .0 | .0 |
ges remote message | 1356.9K | 95.5 | .6 | .4 | .3 | .3 | .3 | 2.5 | .0 |
heartbeat monitor sleep | 1 | 100.0 | |||||||
jobq slave wait | 3995 | 100.0 | |||||||
pmon timer | 1313 | 4.3 | .1 | .1 | 3.7 | 91.9 | |||
rdbms ipc message | 307.3K | 35.2 | 4.4 | 5.5 | 6.4 | 7.3 | 5.0 | 30.8 | 5.5 |
shared server idle wait | 120 | 100.0 | |||||||
smon timer | 81 | 37.0 | 1.2 | 3.7 | 58.0 | ||||
wait for unread message on broadcast channel | 7220 | .0 | .0 | 99.9 | .1 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file write | 2 | 89.5 | 10.5 | ||||||
ADR file lock | 1 | 95.5 | 4.5 | ||||||
ARCH wait for archivelog lock | 1 | 100.0 | |||||||
ASM file metadata operation | 12 | 98.9 | .2 | .4 | .2 | .2 | .1 | ||
CGS wait for IPC msg | 2 | 100.0 | .0 | .0 | |||||
CSS initialization | 4 | 42.9 | 28.6 | 28.6 | |||||
CSS operation: action | 2 | 85.7 | 14.3 | ||||||
DFS lock handle | 17 | 99.6 | .1 | .1 | .0 | .0 | .1 | .2 | |
Disk file operations I/O | 6 | 99.9 | .0 | .0 | .0 | ||||
IPC send completion sync | 3 | 99.9 | .1 | ||||||
KJC: Wait for msg sends to complete | 5 | 93.3 | .0 | .1 | 6.6 | ||||
LGWR wait for redo copy | 14 | 99.1 | .5 | .1 | .1 | .1 | |||
Log archive I/O | 2 | 50.0 | 50.0 | ||||||
PX Deq: Slave Session Stats | 1 | 99.9 | .1 | ||||||
PX Deq: reap credit | 4 | 100.0 | .0 | .0 | .0 | ||||
SQL*Net break/reset to client | 30 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
SQL*Net message to client | 29 | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
SQL*Net more data from client | 1963 | 70.1 | 3.0 | 5.6 | 21.3 | ||||
asynch descriptor resize | 2 | 100.0 | .0 | .0 | |||||
buffer busy waits | 542 | 60.6 | 10.3 | 8.8 | 5.7 | 9.3 | 3.2 | .9 | 1.3 |
control file parallel write | 26 | 99.5 | .2 | .2 | .1 | ||||
control file sequential read | 558 | 97.7 | 1.2 | .9 | .2 | .0 | .0 | ||
cursor: pin S wait on X | 35 | 45.0 | .9 | 3.2 | 3.2 | 4.6 | 4.1 | 39.0 | |
db file parallel read | 235 | 81.9 | 13.9 | 3.2 | .9 | .1 | |||
db file parallel write | 465 | 96.7 | 2.0 | .8 | .5 | .0 | |||
db file scattered read | 128 | 99.3 | .5 | .1 | .0 | .0 | |||
db file sequential read | 4850 | 96.6 | 2.6 | .6 | .2 | .0 | .0 | .0 | |
direct path read | 14.1K | 82.2 | 12.0 | 4.0 | 1.6 | .2 | .0 | ||
enq: CF - contention | 2 | 98.3 | .6 | 1.1 | |||||
enq: FB - contention | 1 | 95.7 | 4.3 | ||||||
enq: JQ - contention | 2 | 92.0 | 4.0 | 4.0 | |||||
enq: KO - fast object checkpoint | 21 | 96.9 | 1.5 | .7 | .7 | .1 | |||
enq: PR - contention | 2 | 20.0 | 20.0 | 60.0 | |||||
enq: PS - contention | 3 | 99.4 | .2 | .1 | .2 | ||||
enq: SQ - contention | 87 | 37.9 | 7.1 | 37.9 | 8.6 | 7.1 | 1.4 | ||
enq: TM - contention | 1 | 92.9 | 7.1 | ||||||
enq: TX - contention | 5 | 94.6 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 | ||
enq: TX - index contention | 226 | 50.9 | 13.3 | 12.7 | 3.4 | 17.2 | 1.9 | .6 | |
enq: TX - row lock contention | 28 | 91.0 | 1.8 | 1.6 | 1.6 | .3 | .8 | 1.3 | 1.8 |
enq: US - contention | 12 | 97.9 | .1 | .5 | .3 | .2 | .1 | .9 | |
enq: WF - contention | 1 | 88.9 | 5.6 | 5.6 | |||||
external table read | 5 | 97.6 | .5 | 1.0 | 1.0 | ||||
gc buffer busy acquire | 637 | 96.7 | 1.2 | .5 | .7 | .5 | .2 | .1 | .1 |
gc buffer busy release | 740 | 36.0 | 10.4 | 12.8 | 8.7 | 12.6 | 19.3 | .2 | .1 |
gc cr block 2-way | 312 | 99.7 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
gc cr block busy | 323 | 98.3 | .8 | .5 | .4 | .1 | .0 | .0 | |
gc cr block congested | 13 | 91.8 | 1.3 | 1.3 | 1.3 | 2.5 | 1.3 | .6 | |
gc cr grant 2-way | 83 | 99.8 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
gc cr grant congested | 8 | 80.3 | 3.3 | 4.9 | 3.3 | 1.6 | 6.6 | ||
gc cr multi block request | 13 | 99.9 | .1 | .0 | .0 | ||||
gc current block 2-way | 290 | 99.9 | .1 | .0 | .0 | .0 | .0 | .0 | .0 |
gc current block busy | 124 | 94.1 | 2.7 | 1.7 | .9 | .2 | .2 | .3 | |
gc current block congested | 6 | 97.4 | .4 | .9 | .4 | .9 | |||
gc current grant 2-way | 52 | 99.4 | .1 | .2 | .1 | .0 | .1 | .0 | .0 |
gc current grant busy | 121 | 99.7 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
gc current grant congested | 6 | 64.3 | 3.6 | 3.6 | 10.7 | 3.6 | 14.3 | ||
gc current multi block request | 4 | 88.6 | 5.7 | 5.7 | |||||
gc current retry | 1 | 83.3 | 8.3 | 8.3 | |||||
gc current split | 1 | 97.2 | 2.8 | ||||||
gcs log flush sync | 79 | 99.8 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
ges inquiry response | 6 | 99.6 | .0 | .1 | .0 | .1 | .1 | ||
ges lms sync during dynamic remastering and reconfig | 46 | 34.7 | 31.9 | 23.6 | 5.6 | 2.8 | 1.4 | ||
kjbdrmcvtq lmon drm quiesce: ping completion | 3 | 86.4 | 9.1 | 4.5 | |||||
ksdxexeotherwait | 2 | 33.3 | 33.3 | 33.3 | |||||
latch free | 70 | 93.8 | .5 | .8 | 1.3 | .1 | 3.6 | ||
latch: cache buffers chains | 9 | 99.8 | .1 | .1 | .0 | ||||
latch: gc element | 22 | 86.5 | 2.9 | 2.9 | 2.9 | 1.8 | 2.4 | .6 | |
latch: gcs resource hash | 12 | 65.7 | 11.4 | 5.7 | 5.7 | 8.6 | 2.9 | ||
latch: ges resource hash list | 621 | 45.5 | 2.6 | 11.9 | 6.8 | 4.8 | 13.6 | 10.6 | 4.1 |
latch: messages | 2 | 50.0 | 25.0 | 25.0 | |||||
latch: object queue header operation | 7 | 96.7 | .9 | .5 | .9 | .9 | |||
latch: row cache objects | 187 | 75.2 | 2.0 | 3.1 | 4.0 | 15.5 | .3 | ||
latch: shared pool | 63 | 96.6 | 2.0 | .7 | .7 | ||||
library cache load lock | 1394 | 17.1 | 6.8 | 20.5 | 7.1 | 1.6 | 11.3 | 16.1 | 19.7 |
library cache lock | 133 | 88.8 | .5 | .4 | .1 | .2 | .2 | .3 | 9.5 |
library cache pin | 58 | 95.5 | .1 | .1 | .1 | .1 | .1 | .1 | 3.9 |
library cache: mutex X | 1581 | 88.4 | 3.1 | 3.1 | 4.7 | .5 | .2 | .1 | .0 |
log file parallel write | 856 | 99.3 | .5 | .1 | .1 | .0 | .0 | ||
log file sequential read | 38 | 80.1 | 7.9 | 5.8 | 5.2 | .5 | .5 | ||
log file switch completion | 4 | 33.3 | 16.7 | 33.3 | 16.7 | ||||
log file sync | 1463 | 97.8 | 1.2 | .6 | .2 | .1 | .0 | .0 | .0 |
name-service call wait | 247 | 4.6 | 1.2 | 3.9 | .4 | 83.8 | 6.2 | ||
os thread startup | 96 | 82.9 | 3.8 | 1.0 | 1.0 | 2.9 | 8.6 | ||
process diagnostic dump | 6 | 99.7 | .0 | .1 | .1 | .1 | |||
rdbms ipc reply | 3 | 99.4 | .4 | .2 | |||||
read by other session | 43 | 96.2 | 3.4 | .4 | .1 | ||||
reliable message | 7 | 99.1 | .2 | .1 | .1 | .4 | |||
resmgr:cpu quantum | 15K | 76.7 | 8.7 | 7.5 | 3.2 | 2.9 | .9 | .0 | .0 |
resmgr:internal state change | 1 | 100.0 | |||||||
row cache cleanup | 7 | 100.0 | .0 | .0 | .0 | .0 | |||
row cache lock | 62 | 99.6 | .1 | .0 | .1 | .0 | .1 | .0 | .0 |
row cache process | 3 | 100.0 | .0 | .0 | |||||
undo segment extension | 1 | 93.3 | 6.7 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
DFS lock handle | 9 | 99.8 | .0 | .0 | .1 | ||||
KJC: Wait for msg sends to complete | 268 | 93.4 | 6.6 | ||||||
SQL*Net message to client | 6 | 100.0 | .0 | .0 | |||||
Streams AQ: qmn coordinator waiting for slave to start | 3 | 100.0 | |||||||
buffer busy waits | 18 | 98.7 | .1 | .1 | 1.1 | ||||
cursor: pin S wait on X | 19 | 61.0 | .9 | 2.8 | .9 | .5 | 1.4 | 2.3 | 30.3 |
enq: CF - contention | 4 | 98.9 | .6 | .3 | .3 | ||||
enq: PR - contention | 2 | 40.0 | 20.0 | 20.0 | 20.0 | ||||
enq: PS - contention | 2 | 99.8 | .2 | ||||||
enq: PV - syncstart | 4 | 50.0 | 50.0 | ||||||
enq: TX - index contention | 3 | 99.4 | .2 | .4 | |||||
enq: TX - row lock contention | 3 | 98.2 | .3 | .5 | 1.0 | ||||
enq: US - contention | 9 | 99.1 | .5 | .4 | |||||
enq: WF - contention | 1 | 94.4 | 5.6 | ||||||
external table open | 1 | 92.3 | 7.7 | ||||||
gc buffer busy acquire | 20 | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
gc buffer busy release | 1 | 99.9 | .1 | ||||||
gc cr block 2-way | 12 | 100.0 | .0 | .0 | .0 | .0 | |||
gc cr grant 2-way | 7 | 100.0 | .0 | .0 | .0 | ||||
gc cr grant congested | 4 | 93.4 | 1.6 | 3.3 | 1.6 | ||||
gc current block 2-way | 15 | 100.0 | .0 | .0 | .0 | .0 | |||
gc current block busy | 6 | 99.7 | .2 | .0 | .0 | ||||
gc current grant 2-way | 4 | 100.0 | .0 | ||||||
gc current grant busy | 7 | 100.0 | .0 | .0 | .0 | ||||
gc current grant congested | 4 | 85.7 | 7.1 | 3.6 | 3.6 | ||||
gc current retry | 1 | 91.7 | 8.3 | ||||||
gcs log flush sync | 1 | 100.0 | .0 | ||||||
ges inquiry response | 3 | 99.9 | .0 | .0 | .0 | ||||
ges lms sync during dynamic remastering and reconfig | 1 | 98.6 | 1.4 | ||||||
latch free | 95 | 96.4 | 1.2 | 2.3 | .1 | .0 | |||
latch: gc element | 1 | 99.4 | .6 | ||||||
latch: ges resource hash list | 51 | 95.9 | 1.8 | 2.4 | |||||
library cache load lock | 434 | 80.3 | 13.4 | 6.3 | |||||
library cache lock | 374 | 90.5 | .3 | 1.3 | 2.8 | .1 | .1 | .1 | 4.8 |
library cache pin | 386 | 96.1 | .2 | 3.7 | .0 | ||||
library cache: mutex X | 3 | 100.0 | .0 | ||||||
log file sync | 22 | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
os thread startup | 8 | 91.4 | 2.9 | 2.9 | 1.0 | 1.0 | 1.0 | ||
process diagnostic dump | 2 | 99.9 | .0 | .0 | |||||
resmgr:cpu quantum | 18 | 100.0 | .0 | .0 | |||||
row cache cleanup | 1 | 100.0 | .0 | ||||||
row cache lock | 6 | 100.0 | .0 |
% of Total Waits | ||||||||
---|---|---|---|---|---|---|---|---|
Event | Waits 4m to 1h | <2m | <4m | <8m | <1/4h | <1/2h | < 1h | >=1h |
cursor: pin S wait on X | 66 | 69.7 | 6.9 | 11.5 | 11.9 | |||
enq: PR - contention | 1 | 80.0 | 20.0 | |||||
enq: TX - row lock contention | 4 | 99.0 | .8 | .3 | ||||
library cache lock | 386 | 95.2 | .7 | 2.4 | 1.7 | |||
os thread startup | 1 | 99.0 | 1.0 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
coredb. | 248,263 | 5,744 | 32,377 | 374,186 |
SYS$USERS | 1,086 | 404 | 7 | 905 |
SYS$BACKGROUND | 0 | 0 | 3 | 353 |
coredbXDB | 0 | 0 | 0 | 0 |
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 |
---|---|---|---|---|---|---|---|---|
coredb. | 249835 | 3427 | 39157 | 222608 | 0 | 0 | 5149352 | 392 |
SYS$USERS | 7970 | 34 | 12913 | 17 | 0 | 0 | 54850 | 46 |
SYS$BACKGROUND | 1431 | 11 | 60184 | 280 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
3,991.80 | 1,112 | 3.59 | 1.60 | 0.04 | 0.05 | 7ncnu7ud2ykhu | JDBC Thin Client | insert into ORDERS (domesticin... |
2,710.22 | 5 | 542.04 | 1.09 | 0.12 | 0.00 | gt918y7x55jkh | JDBC Thin Client | SELECT 1 FROM DUAL WHERE EXIST... |
2,596.58 | 5 | 519.32 | 1.04 | 0.12 | 0.00 | azv5apyucyna9 | JDBC Thin Client | select * from ( select /*+USE_... |
1,781.89 | 3 | 593.96 | 0.71 | 0.12 | 0.00 | g2zczp1a02hk1 | JDBC Thin Client | select orderno, bookAgent from... |
1,777.03 | 3 | 592.34 | 0.71 | 0.12 | 0.00 | 35q7sbkf9dqxu | JDBC Thin Client | select p.orderno, o.bookUser f... |
1,733.57 | 4 | 433.39 | 0.70 | 0.12 | 0.03 | d5zsfzmzs2r1w | JDBC Thin Client | select count(*) as returnstatu... |
1,727.94 | 3 | 575.98 | 0.69 | 0.12 | 0.02 | 885s9c2hvbwqy | JDBC Thin Client | select count(*) as returnstatu... |
1,687.16 | 4 | 421.79 | 0.68 | 0.01 | 0.00 | 9awmqbn8w5tkq | JDBC Thin Client | SELECT O.STATUS, P.TICKETNO FR... |
1,434.30 | 6 | 239.05 | 0.58 | 0.09 | 0.00 | dchg4jkvzb5aw | JDBC Thin Client | SELECT 1 FROM ORDERS WHERE ORD... |
1,342.72 | 3 | 447.57 | 0.54 | 0.10 | 0.00 | 9w5zg0b4d0392 | JDBC Thin Client | SELECT 1 FROM ORDERS WHERE ORD... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
545.15 | 1,663 | 0.33 | 8.87 | 729.17 | 74.76 | 0.20 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
368.22 | 228 | 1.62 | 5.99 | 550.87 | 66.84 | 0.10 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
259.07 | 53 | 4.89 | 4.21 | 402.41 | 64.38 | 6.42 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
205.11 | 1,084 | 0.19 | 3.34 | 272.84 | 75.17 | 0.00 | gyudauqxd8gqc | JDBC Thin Client | select ag.ORGAREA ORGAREA from... |
158.87 | 234 | 0.68 | 2.58 | 351.72 | 45.17 | 0.01 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
149.17 | 23 | 6.49 | 2.43 | 734.96 | 20.30 | 71.03 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
141.30 | 56 | 2.52 | 2.30 | 177.68 | 79.53 | 0.00 | f71kx19hsq60a | JDBC Thin Client | select * from exchange t where... |
87.92 | 151 | 0.58 | 1.43 | 113.94 | 77.16 | 0.00 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
69.58 | 234 | 0.30 | 1.13 | 91.32 | 76.19 | 0.54 | 7qkh5ucsbcqk6 | JDBC Thin Client | select sum(o.seatnum) from ord... |
64.13 | 0 | 1.04 | 89.55 | 71.61 | 0.01 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
522.05 | 23 | 22.70 | 15.04 | 734.96 | 20.30 | 71.03 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
316.48 | 9 | 35.16 | 9.12 | 382.60 | 11.50 | 82.72 | 7zpq6vurnvy2v | JDBC Thin Client | select tt.changeno from segcha... |
203.32 | 20 | 10.17 | 5.86 | 286.30 | 20.24 | 71.02 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
107.28 | 10 | 10.73 | 3.09 | 151.78 | 20.10 | 70.68 | d6fwfwn6jjbsb | JDBC Thin Client | select distinct pi.orderno, o.... |
25.84 | 53 | 0.49 | 0.74 | 402.41 | 64.38 | 6.42 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
16.85 | 10,602 | 0.00 | 0.49 | 32.59 | 4.57 | 51.71 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
9.19 | 6 | 1.53 | 0.26 | 36.59 | 60.92 | 25.11 | d38ugrdrr80np | JDBC Thin Client | select o.orderno, p.psgname, p... |
9.15 | 10,519 | 0.00 | 0.26 | 18.92 | 9.99 | 48.37 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
9.00 | 13 | 0.69 | 0.26 | 43.31 | 63.50 | 20.77 | 35s6v3maugv34 | JDBC Thin Client | select pi.orderno, o.createdat... |
8.28 | 10,615 | 0.00 | 0.24 | 15.61 | 6.09 | 53.08 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
49,669,901 | 1,663 | 29,867.65 | 13.23 | 729.17 | 74.8 | .2 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
28,623,613 | 234 | 122,323.13 | 7.63 | 351.72 | 45.2 | 0 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
26,691,675 | 53 | 503,616.51 | 7.11 | 402.41 | 64.4 | 6.4 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
16,197,510 | 228 | 71,041.71 | 4.32 | 550.87 | 66.8 | .1 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
14,599,682 | 234 | 62,391.80 | 3.89 | 91.32 | 76.2 | .5 | 7qkh5ucsbcqk6 | JDBC Thin Client | select sum(o.seatnum) from ord... |
14,426,790 | 151 | 95,541.66 | 3.84 | 113.94 | 77.2 | 0 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
11,798,771 | 1,084 | 10,884.48 | 3.14 | 272.84 | 75.2 | 0 | gyudauqxd8gqc | JDBC Thin Client | select ag.ORGAREA ORGAREA from... |
10,624,132 | 234 | 45,402.27 | 2.83 | 76.87 | 72.6 | 0 | 9b2r0p9d97p92 | JDBC Thin Client | select sum(t.seatnum) from ord... |
9,179,844 | 23 | 399,123.65 | 2.45 | 734.96 | 20.3 | 71 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
4,939,441 | 234 | 21,108.72 | 1.32 | 74.22 | 73.6 | 0 | 67jr1q3uanf6w | JDBC Thin Client | select count(*) from orders o ... |
4,891,981 | 9 | 543,553.44 | 1.30 | 382.60 | 11.5 | 82.7 | 7zpq6vurnvy2v | JDBC Thin Client | select tt.changeno from segcha... |
4,866,065 | 151 | 32,225.60 | 1.30 | 33.10 | 74.5 | .7 | c5jycdptb6cj3 | JDBC Thin Client | select sum(o.seatnum) from ord... |
4,254,479 | 58 | 73,353.09 | 1.13 | 99.61 | 58.7 | 0 | 1ubkxxgj9aynq | JDBC Thin Client | select * from (select c.chang... |
3,989,052 | 20 | 199,452.60 | 1.06 | 286.30 | 20.2 | 71 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
8,206,216 | 23 | 356,792.00 | 25.36 | 734.96 | 20.30 | 71.03 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
4,879,924 | 9 | 542,213.78 | 15.08 | 382.60 | 11.50 | 82.72 | 7zpq6vurnvy2v | JDBC Thin Client | select tt.changeno from segcha... |
3,567,920 | 20 | 178,396.00 | 11.02 | 286.30 | 20.24 | 71.02 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
1,783,960 | 10 | 178,396.00 | 5.51 | 151.78 | 20.10 | 70.68 | d6fwfwn6jjbsb | JDBC Thin Client | select distinct pi.orderno, o.... |
2,614 | 53 | 49.32 | 0.01 | 402.41 | 64.38 | 6.42 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
1,295 | 10,602 | 0.12 | 0.00 | 32.59 | 4.57 | 51.71 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
775 | 6 | 129.17 | 0.00 | 36.59 | 60.92 | 25.11 | d38ugrdrr80np | JDBC Thin Client | select o.orderno, p.psgname, p... |
749 | 13 | 57.62 | 0.00 | 43.31 | 63.50 | 20.77 | 35s6v3maugv34 | JDBC Thin Client | select pi.orderno, o.createdat... |
739 | 10,519 | 0.07 | 0.00 | 18.92 | 9.99 | 48.37 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
602 | 10,615 | 0.06 | 0.00 | 15.61 | 6.09 | 53.08 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
66,102 | 66,102 | 23 | 2,874.00 | 0.00 | 14.40 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
28,740 | 28,740 | 20 | 1,437.00 | 0.00 | 6.26 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
3,377 | 3,377 | 11 | 307.00 | 0.00 | 0.74 | 8kvgs3007httw | Foglight for Oracle <5.6.4.311> | select /*+ rule */ decode(INST... |
3,070 | 3,070 | 10 | 307.00 | 0.00 | 0.67 | cdth6mx505rb3 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ * from ( se... |
2,614 | 2,614 | 53 | 49.32 | 0.00 | 0.57 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
1,437 | 1,437 | 10 | 143.70 | 0.00 | 0.31 | d6fwfwn6jjbsb | JDBC Thin Client | select distinct pi.orderno, o.... |
1,295 | 1,295 | 10,602 | 0.12 | 0.00 | 0.28 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
739 | 739 | 10,519 | 0.07 | 0.00 | 0.16 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
602 | 602 | 10,615 | 0.06 | 0.00 | 0.13 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
407 | 407 | 12,344 | 0.03 | 0.00 | 0.09 | f4uf0u8q871js | JDBC Thin Client | select min(pt.ticketno) as min... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
164,170 | 0 | 0.00 | 22.40 | 3.3 | 0 | 4yq6qwgw992zk | JDBC Thin Client | select CABINS from GENERALIZEL... |
105,251 | 105,252 | 1.00 | 33.15 | 16.9 | 0 | ftj9uawt4wwzb | select condition from cdef$ wh... | |
92,026 | 92,024 | 1.00 | 42.10 | .5 | 0 | 520mkxqpf15q8 | JDBC Thin Client | select 1 from dual |
91,604 | 0 | 0.00 | 135.45 | 1.8 | 0 | d4ggk0agny9tf | JDBC Thin Client | SET TRANSACTION READ WRITE |
24,597 | 24,590 | 1.00 | 20.83 | 4.5 | 18.6 | 09uaa1krtq5by | JDBC Thin Client | select f.agentfeereturntype fr... |
20,712 | 20,711 | 1.00 | 2.73 | 7 | 0 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
13,835 | 13,835 | 1.00 | 2.45 | .4 | 0 | 87tu7wk540dwq | JDBC Thin Client | select MAX_THREAD_COUNT from p... |
13,709 | 13,702 | 1.00 | 3.60 | 8.9 | 0 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
12,374 | 12,367 | 1.00 | 4.73 | 12.9 | .2 | bhvwd3sbwdyga | JDBC Thin Client | select f.isautoconfirm from fl... |
12,344 | 12,337 | 1.00 | 2.67 | 5.6 | 0 | ckg1n91hh2qkk | JDBC Thin Client | select o.pricefileno from flig... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
164,033 | 164,170 | 11.32 | 4yq6qwgw992zk | JDBC Thin Client | select CABINS from GENERALIZEL... |
105,252 | 105,251 | 7.26 | ftj9uawt4wwzb | select condition from cdef$ wh... | |
92,023 | 92,026 | 6.35 | 520mkxqpf15q8 | JDBC Thin Client | select 1 from dual |
91,599 | 91,604 | 6.32 | d4ggk0agny9tf | JDBC Thin Client | SET TRANSACTION READ WRITE |
20,710 | 20,712 | 1.43 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
13,835 | 13,835 | 0.95 | 87tu7wk540dwq | JDBC Thin Client | select MAX_THREAD_COUNT from p... |
13,671 | 13,709 | 0.94 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
12,343 | 12,343 | 0.85 | bhwz3x2mjy7s3 | JDBC Thin Client | SELECT PL.PNRNO FROM PNRLIST P... |
12,342 | 12,343 | 0.85 | 5f0955qkz78g4 | JDBC Thin Client | select DOMESTICINDICATE from o... |
12,341 | 12,343 | 0.85 | a7pqvnr44uy38 | JDBC Thin Client | SELECT HO.PAYMONEY, HO.HOTELOR... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
8,273,790 | 0 | 0.08 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
4,816,728 | 486 | 0.05 | c6awqs517jpj0 | select /*+ index(idl_char$ i_i... | |
4,776,093 | 486 | 0.05 | 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_id... | |
4,597,237 | 486 | 0.05 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_id... | |
4,032,191 | 0 | 0.04 | 89nf3yvxk8yq7 | Foglight for Oracle <5.6.4.311> | select /*+ rule */ rownum, sid... |
2,341,597 | 492 | 0.02 | ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_id... | |
1,834,836 | 1 | 0.02 | dg13jqzazvhwg | JDBC Thin Client | select count(*) as count from ... |
1,694,276 | 0 | 0.02 | am19a1bvysghh | Foglight for Oracle <5.6.4.311> | select (jj.act_jobs_jobs + js.... |
1,691,853 | 1,876 | 0.02 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
1,632,356 | 1,603 | 0.02 | 3w4qs0tbpmxr6 | select con#, obj#, rcon#, enab... | |
1,060,782 | 544 | 0.01 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
1,056,294 | 544 | 0.01 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
127 | 0 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
51 | 486 | 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_id... | |
51 | 486 | c6awqs517jpj0 | select /*+ index(idl_char$ i_i... | |
51 | 486 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_id... | |
40 | 492 | ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_id... | |
39 | 0 | d0av6s1umpzgf | Foglight for Oracle <5.5.8.127> | select decode(dp.dest_param, '... |
31 | 0 | 69subccxd9b03 | JDBC Thin Client | SELECT signature, inuse_featur... |
30 | 1,603 | 3w4qs0tbpmxr6 | select con#, obj#, rcon#, enab... | |
30 | 7 | bt51szvfrcdpn | JDBC Thin Client | SELECT obj_type, plan_id, comp... |
29 | 1,876 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
24 | 544 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
24 | 544 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
23 | 6,437 | 53saa2zkr6wc3 | select intcol#, nvl(pos#, 0), ... | |
23 | 6,437 | 53saa2zkr6wc3 | select intcol#, nvl(pos#, 0), ... | |
22 | 151 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
21 | 28 | buzp8cfu6upry | JDBC Thin Client | SELECT C.CHANGENO, C.ORDERNO, ... |
21 | 28 | buzp8cfu6upry | JDBC Thin Client | SELECT C.CHANGENO, C.ORDERNO, ... |
Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
94.77 | 234 | 3.70 | 351.72 | 26.94 | 45.17 | 0.01 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
53.07 | 53 | 2.07 | 402.41 | 13.19 | 64.38 | 6.42 | 8663vhj8vkpp0 | JDBC Thin Client | select/*+index(ORDERPNRLIST_F... |
19.86 | 228 | 0.77 | 550.87 | 3.60 | 66.84 | 0.10 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
9.85 | 12,343 | 0.38 | 17.48 | 56.37 | 4.18 | 23.96 | bhwz3x2mjy7s3 | JDBC Thin Client | SELECT PL.PNRNO FROM PNRLIST P... |
9.36 | 1,663 | 0.37 | 729.17 | 1.28 | 74.76 | 0.20 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
8.78 | 10,602 | 0.34 | 32.59 | 26.94 | 4.57 | 51.71 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
8.06 | 1,360 | 0.31 | 14.60 | 55.20 | 8.42 | 21.03 | 4vs91dcv7u1p6 | JDBC Thin Client | insert into sys.aud$( sessioni... |
7.51 | 24,597 | 0.29 | 20.83 | 36.07 | 4.51 | 18.57 | 09uaa1krtq5by | JDBC Thin Client | select f.agentfeereturntype fr... |
6.53 | 12,344 | 0.25 | 20.78 | 31.43 | 8.66 | 28.12 | f4uf0u8q871js | JDBC Thin Client | select min(pt.ticketno) as min... |
5.84 | 2 | 0.23 | 984.25 | 0.59 | 0.08 | 0.00 | 99g18d3aqu23g | JDBC Thin Client | SELECT P.TYPE, P.PNRNO, RI.ORD... |
5.59 | 12,343 | 0.22 | 9.64 | 57.95 | 8.19 | 14.13 | 5f0955qkz78g4 | JDBC Thin Client | select DOMESTICINDICATE from o... |
5.47 | 10,562 | 0.21 | 16.78 | 32.59 | 8.40 | 39.77 | 6u1fc9nj87uhd | JDBC Thin Client | SELECT S.SEGORDER, (S.CARRIER ... |
4.77 | 10,519 | 0.19 | 18.92 | 25.23 | 9.99 | 48.37 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
4.00 | 2,077 | 0.16 | 1,294.46 | 0.31 | 0.09 | 0.01 | 7jk3kcjxvz83k | JDBC Thin Client | UPDATE PAYBILL SET PAYSTATUS =... |
3.97 | 3 | 0.15 | 1,093.89 | 0.36 | 0.07 | 0.00 | dx3zc47x1cw9p | JDBC Thin Client | select p.orderno from paybill ... |
3.84 | 12,343 | 0.15 | 6.31 | 60.80 | 9.66 | 0.02 | a7pqvnr44uy38 | JDBC Thin Client | SELECT HO.PAYMONEY, HO.HOTELOR... |
3.76 | 544 | 0.15 | 16.24 | 23.18 | 0.86 | 2.67 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
3.55 | 10,615 | 0.14 | 5.09 | 69.77 | 10.81 | 0.02 | 9tzrcb1d5f06z | JDBC Thin Client | SELECT O.ORDERNO, O.GROUPFLAG,... |
3.38 | 234 | 0.13 | 76.87 | 4.40 | 72.62 | 0.00 | 9b2r0p9d97p92 | JDBC Thin Client | select sum(t.seatnum) from ord... |
2.89 | 9,943 | 0.11 | 4.02 | 72.01 | 11.20 | 0.00 | 95bdypfq2ky5g | JDBC Thin Client | select o.domesticindicate from... |
2.76 | 58 | 0.11 | 99.61 | 2.77 | 58.68 | 0.00 | 1ubkxxgj9aynq | JDBC Thin Client | select * from (select c.chang... |
2.63 | 12,374 | 0.10 | 4.73 | 55.56 | 12.88 | 0.18 | bhvwd3sbwdyga | JDBC Thin Client | select f.isautoconfirm from fl... |
2.62 | 234 | 0.10 | 74.22 | 3.53 | 73.64 | 0.05 | 67jr1q3uanf6w | JDBC Thin Client | select count(*) from orders o ... |
2.39 | 10,615 | 0.09 | 15.61 | 15.29 | 6.09 | 53.08 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
2.32 | 1,112 | 0.09 | 3,991.80 | 0.06 | 0.04 | 0.05 | 7ncnu7ud2ykhu | JDBC Thin Client | insert into ORDERS (domesticin... |
2.08 | 13,709 | 0.08 | 3.60 | 57.66 | 8.89 | 0.00 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
2.07 | 10,615 | 0.08 | 5.11 | 40.53 | 7.63 | 0.00 | 5s3uwrd1gxt7q | JDBC Thin Client | SELECT NVL(AG.AGENTTYPE, OU1.F... |
1.95 | 6 | 0.08 | 1,434.30 | 0.14 | 0.09 | 0.00 | dchg4jkvzb5aw | JDBC Thin Client | SELECT 1 FROM ORDERS WHERE ORD... |
1.89 | 151 | 0.07 | 29.31 | 6.44 | 70.21 | 0.00 | g2yqaqwzb765r | JDBC Thin Client | select sum(t.seatnum) from ord... |
1.56 | 10,615 | 0.06 | 2.90 | 53.81 | 5.52 | 0.00 | g128myz1mz13n | JDBC Thin Client | select 1 from dual where exist... |
1.54 | 151 | 0.06 | 45.60 | 3.38 | 74.63 | 0.08 | 52ngpnc7n319u | JDBC Thin Client | select count(*) from orders o ... |
1.41 | 234 | 0.06 | 91.32 | 1.55 | 76.19 | 0.54 | 7qkh5ucsbcqk6 | JDBC Thin Client | select sum(o.seatnum) from ord... |
1.37 | 10,571 | 0.05 | 2.56 | 53.60 | 8.58 | 0.00 | 8whvjha2fnk63 | JDBC Thin Client | SELECT F.TOTALPRICE, F.AGENTFE... |
1.29 | 12,344 | 0.05 | 2.67 | 48.42 | 5.62 | 0.00 | ckg1n91hh2qkk | JDBC Thin Client | select o.pricefileno from flig... |
1.13 | 151 | 0.04 | 113.94 | 0.99 | 77.16 | 0.00 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
0.99 | 151 | 0.04 | 33.10 | 3.00 | 74.50 | 0.72 | c5jycdptb6cj3 | JDBC Thin Client | select sum(o.seatnum) from ord... |
0.97 | 23 | 0.04 | 734.96 | 0.13 | 20.30 | 71.03 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
0.90 | 3 | 0.03 | 1,781.89 | 0.05 | 0.12 | 0.00 | g2zczp1a02hk1 | JDBC Thin Client | select orderno, bookAgent from... |
0.63 | 3 | 0.02 | 1,133.48 | 0.06 | 0.01 | 0.00 | 57g40763jz1hx | JDBC Thin Client | SELECT O.STATUS, P.TICKETNO FR... |
0.56 | 10,615 | 0.02 | 6.63 | 8.47 | 5.89 | 23.40 | 90yfsh8rb8gma | JDBC Thin Client | select p.TYPE from paxinsuranc... |
0.44 | 5 | 0.02 | 770.85 | 0.06 | 0.01 | 0.00 | fyn11ybbbgd4t | JDBC Thin Client | SELECT 1 FROM ORDERS WHERE ORD... |
0.37 | 9 | 0.01 | 382.60 | 0.10 | 11.50 | 82.72 | 7zpq6vurnvy2v | JDBC Thin Client | select tt.changeno from segcha... |
0.34 | 109 | 0.01 | 2.30 | 14.59 | 47.47 | 0.00 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
0.30 | 20 | 0.01 | 286.30 | 0.10 | 20.24 | 71.02 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
0.24 | 3 | 0.01 | 782.41 | 0.03 | 0.01 | 0.00 | a1d4259qsz5s3 | JDBC Thin Client | SELECT 1 FROM ORDERS WHERE ORD... |
0.22 | 4 | 0.01 | 1,171.94 | 0.02 | 0.09 | 0.00 | 2duyv3zxb3gzb | JDBC Thin Client | select count(*) as orderstatus... |
0.22 | 13 | 0.01 | 43.31 | 0.51 | 63.50 | 20.77 | 35s6v3maugv34 | JDBC Thin Client | select pi.orderno, o.createdat... |
0.21 | 3 | 0.01 | 1,214.75 | 0.02 | 0.11 | 0.00 | 0sdd673b06r28 | JDBC Thin Client | select od.orderno, od.domestic... |
0.21 | 6 | 0.01 | 36.59 | 0.57 | 60.92 | 25.11 | d38ugrdrr80np | JDBC Thin Client | select o.orderno, p.psgname, p... |
0.18 | 3 | 0.01 | 1,175.59 | 0.02 | 0.09 | 0.05 | 6t7d38cwb4t1a | JDBC Thin Client | select count(*) as returnstatu... |
0.16 | 3 | 0.01 | 1,777.03 | 0.01 | 0.12 | 0.00 | 35q7sbkf9dqxu | JDBC Thin Client | select p.orderno, o.bookUser f... |
0.14 | 10,615 | 0.01 | 2.58 | 5.59 | 8.92 | 0.00 | 78txh8n821266 | JDBC Thin Client | select 1 from dual where exist... |
0.14 | 10 | 0.01 | 151.78 | 0.09 | 20.10 | 70.68 | d6fwfwn6jjbsb | JDBC Thin Client | select distinct pi.orderno, o.... |
0.13 | 3 | 0.01 | 1,727.94 | 0.01 | 0.12 | 0.02 | 885s9c2hvbwqy | JDBC Thin Client | select count(*) as returnstatu... |
0.12 | 486 | 0.00 | 1.02 | 11.69 | 20.57 | 70.55 | cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_id... | |
0.08 | 299 | 0.00 | 0.19 | 41.92 | 10.62 | 26.49 | 7sn14ggsm4682 | JDBC Thin Client | insert into INTELTAXTOORDERS (... |
0.06 | 2 | 0.00 | 1,128.10 | 0.01 | 0.08 | 0.00 | bnkw4gr0bwb52 | JDBC Thin Client | select * from ( select /*+USE_... |
0.05 | 10 | 0.00 | 2.36 | 2.16 | 21.16 | 62.22 | 0nvtgf57cgppu | JDBC Thin Client | select count(*) as recordscoun... |
0.05 | 5 | 0.00 | 2,596.58 | 0.00 | 0.12 | 0.00 | azv5apyucyna9 | JDBC Thin Client | select * from ( select /*+USE_... |
0.04 | 971 | 0.00 | 0.36 | 11.47 | 19.64 | 12.80 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... | |
0.04 | 71 | 0.00 | 0.85 | 4.12 | 54.04 | 0.00 | 1qzsjc90kxcma | JDBC Thin Client | select count(*) as count from ... |
0.03 | 1,876 | 0.00 | 1.18 | 2.61 | 21.15 | 10.38 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
0.03 | 492 | 0.00 | 0.39 | 7.07 | 31.01 | 57.87 | ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_id... | |
0.02 | 486 | 0.00 | 0.40 | 4.38 | 27.38 | 67.85 | 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_id... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 1,818 | 0.50 | 0.01 |
Batched IO (full) vector count | 15 | 0.00 | 0.00 |
Batched IO (space) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 36,750 | 10.18 | 0.22 |
Batched IO buffer defrag count | 286 | 0.08 | 0.00 |
Batched IO double miss count | 2,030 | 0.56 | 0.01 |
Batched IO same unit count | 12,185 | 3.38 | 0.07 |
Batched IO single block count | 1,091 | 0.30 | 0.01 |
Batched IO slow jump count | 11 | 0.00 | 0.00 |
Batched IO vector block count | 23,797 | 6.59 | 0.14 |
Batched IO vector read count | 2,410 | 0.67 | 0.01 |
Block Cleanout Optim referenced | 2,458 | 0.68 | 0.01 |
CCursor + sql area evicted | 3,677 | 1.02 | 0.02 |
CPU used by this session | 555,126 | 153.81 | 3.33 |
CPU used when call started | 530,712 | 147.05 | 3.19 |
CR blocks created | 30,457 | 8.44 | 0.18 |
Cached Commit SCN referenced | 1,836 | 0.51 | 0.01 |
Clusterwide global transactions | 16 | 0.00 | 0.00 |
Clusterwide global transactions spanning RAC nodes | 0 | 0.00 | 0.00 |
Commit SCN cached | 3,692 | 1.02 | 0.02 |
DB time | 24,754,861 | 6,858.92 | 148.62 |
DBWR checkpoint buffers written | 47,317 | 13.11 | 0.28 |
DBWR checkpoints | 150 | 0.04 | 0.00 |
DBWR fusion writes | 18,068 | 5.01 | 0.11 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 1,690 | 0.47 | 0.01 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 797 | 0.22 | 0.00 |
DBWR undo block writes | 22,576 | 6.26 | 0.14 |
DFO trees parallelized | 39 | 0.01 | 0.00 |
DX/BB enqueue lock background get time | 15 | 0.00 | 0.00 |
DX/BB enqueue lock background gets | 32 | 0.01 | 0.00 |
DX/BB enqueue lock foreground requests | 266 | 0.07 | 0.00 |
DX/BB enqueue lock foreground wait time | 20 | 0.01 | 0.00 |
Effective IO time | 2,002,720,183 | 554,901.40 | 12,023.94 |
HSC Heap Segment Block Changes | 218,011 | 60.41 | 1.31 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 4,579 | 1.27 | 0.03 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Number of read IOs issued | 256,026 | 70.94 | 1.54 |
PX local messages recv'd | 72 | 0.02 | 0.00 |
PX local messages sent | 72 | 0.02 | 0.00 |
PX remote messages recv'd | 2,518 | 0.70 | 0.02 |
PX remote messages sent | 6,993 | 1.94 | 0.04 |
Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 39 | 0.01 | 0.00 |
RowCR - row contention | 861 | 0.24 | 0.01 |
RowCR attempts | 78,210 | 21.67 | 0.47 |
RowCR hits | 78,256 | 21.68 | 0.47 |
SMON posted for instance recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 44 | 0.01 | 0.00 |
SQL*Net roundtrips to/from client | 5,194,276 | 1,439.20 | 31.19 |
SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 |
active txn count during cleanout | 108,497 | 30.06 | 0.65 |
application wait time | 127,774 | 35.40 | 0.77 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 45,007 | 12.47 | 0.27 |
branch node splits | 4 | 0.00 | 0.00 |
buffer is not pinned count | 169,335,764 | 46,918.51 | 1,016.66 |
buffer is pinned count | 563,469,892 | 156,122.78 | 3,382.96 |
bytes received via SQL*Net from client | 408,556,120 | 113,200.22 | 2,452.89 |
bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 |
bytes sent via SQL*Net to client | 557,501,412 | 154,469.07 | 3,347.13 |
bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 |
calls to get snapshot scn: kcmgss | 1,657,069 | 459.13 | 9.95 |
calls to kcmgas | 457,520 | 126.77 | 2.75 |
calls to kcmgcs | 195,639 | 54.21 | 1.17 |
cell physical IO interconnect bytes | 267,461,221,376 | 74,106,512.00 | 1,605,785.40 |
change write time | 1,838 | 0.51 | 0.01 |
cleanout - number of ktugct calls | 40,173 | 11.13 | 0.24 |
cleanouts and rollbacks - consistent read gets | 26,906 | 7.45 | 0.16 |
cleanouts only - consistent read gets | 2,470 | 0.68 | 0.01 |
cluster key scan block gets | 36,515 | 10.12 | 0.22 |
cluster key scans | 24,826 | 6.88 | 0.15 |
cluster wait time | 256,271 | 71.01 | 1.54 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 15,600 | 4.32 | 0.09 |
commit batch/immediate requested | 15,600 | 4.32 | 0.09 |
commit cleanout failures: block lost | 2,190 | 0.61 | 0.01 |
commit cleanout failures: buffer being written | 4 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 1,031 | 0.29 | 0.01 |
commit cleanout failures: cannot pin | 151 | 0.04 | 0.00 |
commit cleanouts | 283,875 | 78.65 | 1.70 |
commit cleanouts successfully completed | 280,499 | 77.72 | 1.68 |
commit immediate performed | 15,600 | 4.32 | 0.09 |
commit immediate requested | 15,600 | 4.32 | 0.09 |
commit txn count during cleanout | 55,006 | 15.24 | 0.33 |
concurrency wait time | 22,290,403 | 6,176.09 | 133.83 |
consistent changes | 107,436 | 29.77 | 0.65 |
consistent gets | 373,718,913 | 103,547.74 | 2,243.74 |
consistent gets - examination | 22,299,887 | 6,178.72 | 133.88 |
consistent gets direct | 32,074,627 | 8,887.04 | 192.57 |
consistent gets from cache | 341,644,273 | 94,660.70 | 2,051.17 |
consistent gets from cache (fastpath) | 314,977,115 | 87,271.92 | 1,891.06 |
cursor authentications | 30,452 | 8.44 | 0.18 |
data blocks consistent reads - undo records applied | 102,687 | 28.45 | 0.62 |
db block changes | 1,297,179 | 359.41 | 7.79 |
db block gets | 1,600,430 | 443.44 | 9.61 |
db block gets direct | 938 | 0.26 | 0.01 |
db block gets from cache | 1,599,492 | 443.18 | 9.60 |
db block gets from cache (fastpath) | 421,119 | 116.68 | 2.53 |
deferred (CURRENT) block cleanout applications | 87,647 | 24.28 | 0.53 |
dirty buffers inspected | 2,669 | 0.74 | 0.02 |
enqueue conversions | 18,941 | 5.25 | 0.11 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 1,179,807 | 326.89 | 7.08 |
enqueue requests | 1,180,106 | 326.98 | 7.09 |
enqueue timeouts | 15 | 0.00 | 0.00 |
enqueue waits | 4,552 | 1.26 | 0.03 |
exchange deadlocks | 1,202 | 0.33 | 0.01 |
execute count | 1,738,534 | 481.70 | 10.44 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 1,782,770,607 | 493,959.13 | 10,703.41 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 538,302 | 149.15 | 3.23 |
free buffer requested | 743,299 | 205.95 | 4.46 |
gc blocks compressed | 218,708 | 60.60 | 1.31 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block flush time | 55,324 | 15.33 | 0.33 |
gc cr block receive time | 58,795 | 16.29 | 0.35 |
gc cr blocks received | 149,300 | 41.37 | 0.90 |
gc cr blocks served | 165,659 | 45.90 | 0.99 |
gc current block flush time | 23,900 | 6.62 | 0.14 |
gc current block pin time | 1,899 | 0.53 | 0.01 |
gc current block receive time | 66,122 | 18.32 | 0.40 |
gc current blocks received | 225,405 | 62.45 | 1.35 |
gc current blocks served | 471,429 | 130.62 | 2.83 |
gc kbytes saved | 671,330 | 186.01 | 4.03 |
gc kbytes sent | 4,425,374 | 1,226.16 | 26.57 |
gc local grants | 258,000 | 71.49 | 1.55 |
gc remote grants | 103,826 | 28.77 | 0.62 |
gcs messages sent | 1,521,837 | 421.66 | 9.14 |
ges messages sent | 142,886 | 39.59 | 0.86 |
global enqueue get time | 19,009,371 | 5,267.00 | 114.13 |
global enqueue gets async | 21,919 | 6.07 | 0.13 |
global enqueue gets sync | 2,033,416 | 563.41 | 12.21 |
global enqueue releases | 2,040,099 | 565.26 | 12.25 |
heap block compress | 2,984 | 0.83 | 0.02 |
hot buffers moved to head of LRU | 580,767 | 160.92 | 3.49 |
immediate (CR) block cleanout applications | 29,381 | 8.14 | 0.18 |
immediate (CURRENT) block cleanout applications | 19,142 | 5.30 | 0.11 |
index crx upgrade (positioned) | 462 | 0.13 | 0.00 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 5,713 | 1.58 | 0.03 |
index fetch by key | 4,638,735 | 1,285.27 | 27.85 |
index scans kdiixs1 | 92,431,865 | 25,610.45 | 554.94 |
leaf node 90-10 splits | 390 | 0.11 | 0.00 |
leaf node splits | 1,367 | 0.38 | 0.01 |
lob reads | 1,014 | 0.28 | 0.01 |
lob writes | 213 | 0.06 | 0.00 |
lob writes unaligned | 213 | 0.06 | 0.00 |
logons cumulative | 2,346 | 0.65 | 0.01 |
max cf enq hold time | 13 | 0.00 | 0.00 |
messages received | 191,339 | 53.02 | 1.15 |
messages sent | 191,339 | 53.02 | 1.15 |
min active SCN optimization applied on CR | 12,015 | 3.33 | 0.07 |
no buffer to keep pinned count | 47 | 0.01 | 0.00 |
no work - consistent read gets | 350,212,630 | 97,034.76 | 2,102.61 |
non-idle wait count | 12,746,367 | 3,531.69 | 76.53 |
non-idle wait time | 23,924,079 | 6,628.74 | 143.64 |
opened cursors cumulative | 1,724,022 | 477.68 | 10.35 |
parse count (describe) | 41 | 0.01 | 0.00 |
parse count (failures) | 2,314 | 0.64 | 0.01 |
parse count (hard) | 183,924 | 50.96 | 1.10 |
parse count (total) | 1,449,123 | 401.51 | 8.70 |
parse time cpu | 44,502 | 12.33 | 0.27 |
parse time elapsed | 19,054,718 | 5,279.56 | 114.40 |
physical read IO requests | 459,021 | 127.18 | 2.76 |
physical read bytes | 265,120,169,984 | 73,457,867.87 | 1,591,730.18 |
physical read total IO requests | 487,466 | 135.06 | 2.93 |
physical read total bytes | 266,008,152,576 | 73,703,904.63 | 1,597,061.45 |
physical read total multi block requests | 255,962 | 70.92 | 1.54 |
physical reads | 32,363,302 | 8,967.02 | 194.30 |
physical reads cache | 289,017 | 80.08 | 1.74 |
physical reads cache prefetch | 128,428 | 35.58 | 0.77 |
physical reads direct | 32,074,285 | 8,886.95 | 192.57 |
physical reads direct (lob) | 17 | 0.00 | 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 | 42,444 | 11.76 | 0.25 |
physical write bytes | 557,547,520 | 154,481.84 | 3,347.41 |
physical write total IO requests | 175,445 | 48.61 | 1.05 |
physical write total bytes | 1,453,069,312 | 402,607.52 | 8,723.95 |
physical write total multi block requests | 1,720 | 0.48 | 0.01 |
physical writes | 68,060 | 18.86 | 0.41 |
physical writes direct | 980 | 0.27 | 0.01 |
physical writes direct (lob) | 3 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 2 | 0.00 | 0.00 |
physical writes from cache | 67,080 | 18.59 | 0.40 |
physical writes non checkpoint | 46,384 | 12.85 | 0.28 |
pinned buffers inspected | 91 | 0.03 | 0.00 |
pinned cursors current | 29 | 0.01 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 14 | 0.00 | 0.00 |
process last non-idle time | 3,596 | 1.00 | 0.02 |
queries parallelized | 35 | 0.01 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 2,768,690 | 767.13 | 16.62 |
recursive cpu usage | 69,554 | 19.27 | 0.42 |
redo KB read | 446,526 | 123.72 | 2.68 |
redo blocks checksummed by FG (exclusive) | 70,235 | 19.46 | 0.42 |
redo blocks written | 535,420 | 148.35 | 3.21 |
redo buffer allocation retries | 11 | 0.00 | 0.00 |
redo entries | 750,516 | 207.95 | 4.51 |
redo log space requests | 7 | 0.00 | 0.00 |
redo log space wait time | 40 | 0.01 | 0.00 |
redo ordering marks | 21,795 | 6.04 | 0.13 |
redo size | 229,340,664 | 63,544.30 | 1,376.92 |
redo size for direct writes | 7,742,856 | 2,145.34 | 46.49 |
redo subscn max counts | 9,118 | 2.53 | 0.05 |
redo synch long waits | 21,863 | 6.06 | 0.13 |
redo synch time | 122,851 | 34.04 | 0.74 |
redo synch time (usec) | 1,229,473,503 | 340,654.96 | 7,381.52 |
redo synch writes | 71,153 | 19.71 | 0.43 |
redo wastage | 35,970,636 | 9,966.52 | 215.96 |
redo write broadcast ack count | 57,720 | 15.99 | 0.35 |
redo write broadcast ack time | 88,710,567 | 24,579.38 | 532.60 |
redo write broadcast lgwr post count | 6 | 0.00 | 0.00 |
redo write time | 33,765 | 9.36 | 0.20 |
redo writes | 121,958 | 33.79 | 0.73 |
remote Oradebug requests | 3 | 0.00 | 0.00 |
rollback changes - undo records applied | 43,096 | 11.94 | 0.26 |
rollbacks only - consistent read gets | 6,305 | 1.75 | 0.04 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 2,617,416 | 725.22 | 15.71 |
scheduler wait time | 273,466 | 75.77 | 1.64 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 536,102 | 148.54 | 3.22 |
session logical reads | 375,319,203 | 103,991.14 | 2,253.34 |
shared hash latch upgrades - no wait | 1,004,818 | 278.41 | 6.03 |
shared hash latch upgrades - wait | 466 | 0.13 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 2,008,079 | 556.39 | 12.06 |
sorts (rows) | 192,601,877 | 53,364.94 | 1,156.34 |
sql area evicted | 177,555 | 49.20 | 1.07 |
sql area purged | 607 | 0.17 | 0.00 |
summed dirty queue length | 7,693 | 2.13 | 0.05 |
switch current to new buffer | 7,153 | 1.98 | 0.04 |
table fetch by rowid | 315,426,752 | 87,396.51 | 1,893.76 |
table fetch continued row | 231,454 | 64.13 | 1.39 |
table scan blocks gotten | 154,970,041 | 42,938.15 | 930.41 |
table scan rows gotten | 12,358,543,413 | 3,424,229.28 | 74,198.30 |
table scans (cache partitions) | 0 | 0.00 | 0.00 |
table scans (direct read) | 216 | 0.06 | 0.00 |
table scans (long tables) | 216 | 0.06 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 58,879 | 16.31 | 0.35 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 10,260 | 2.84 | 0.06 |
total number of cf enq holders | 395 | 0.11 | 0.00 |
total number of times SMON posted | 76 | 0.02 | 0.00 |
transaction lock background gets | 172 | 0.05 | 0.00 |
transaction lock foreground requests | 172 | 0.05 | 0.00 |
transaction lock foreground wait time | 48 | 0.01 | 0.00 |
transaction rollbacks | 15,592 | 4.32 | 0.09 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 70,904,032 | 19,645.65 | 425.69 |
user I/O wait time | 346,833 | 96.10 | 2.08 |
user calls | 5,703,997 | 1,580.43 | 34.25 |
user commits | 53,470 | 14.82 | 0.32 |
user rollbacks | 113,091 | 31.33 | 0.68 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 1,423,616 | 394.45 | 8.55 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 21 | 0.01 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 437,601,873,808 | 439,090,903,504 |
session cursor cache count | 34,246,441 | 34,276,512 |
session uga memory | 338,911,012,231,392 | 339,057,358,403,592 |
opened cursors current | 3,669 | 6,576 |
workarea memory allocated | 18,839 | 13,991 |
logons current | 501 | 838 |
session uga memory max | 3,613,682,057,408 | 3,616,545,214,272 |
session pga memory | 321,797,052,400 | 323,144,804,464 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 1 | 1.00 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Direct Reads | 244.3G | 70.82 | 69.3014 | 0M | 0.00 | 0M | 0 | |
Buffer Cache Reads | 2.2G | 56.12 | .625078 | 0M | 0.00 | 0M | 160.2K | 9.06 |
Others | 844M | 7.87 | .233850 | 592M | 2.90 | .164027 | 33K | 3.24 |
DBWR | 0M | 0.00 | 0M | 524M | 11.74 | .145186 | 0 | |
LGWR | 0M | 0.00 | 0M | 262M | 33.96 | .072593 | 122K | 2.30 |
Direct Writes | 0M | 0.00 | 0M | 7M | 0.02 | .001939 | 0 | |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 18.62 |
TOTAL: | 247.3G | 134.82 | 70.1603 | 1.4G | 48.63 | .383747 | 315.3K | 5.84 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 246.5G | 128.00 | 69.9303 | 526M | 11.76 | .145740 | 7.00 | 40.11 |
Log File | 436M | 0.12 | .120804 | 262M | 33.96 | .072593 | 4.00 | 70.25 |
Control File | 377M | 6.68 | .104456 | 157M | 2.77 | .043500 | 3.60 | 79.00 |
Archive Log | 0M | 0.00 | 0M | 436M | 0.12 | .120804 | ||
Other | 0M | 0.01 | 0M | 0M | 0.01 | 0M | 0.20 | |
Temp File | 0M | 0.01 | 0M | 0M | 0.00 | 0M | 1.92 | |
TOTAL: | 247.3G | 134.82 | 70.1556 | 1.3G | 48.63 | .382638 | 6.64 | 40.16 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Direct Reads | 244.1G | 70.78 | 69.2565 | 0M | 0.00 | 0M | 0 | |
Direct Reads (Data File) | 244.1G | 70.78 | 69.2565 | 0M | 0.00 | 0M | 0 | |
Buffer Cache Reads | 2.2G | 56.13 | .625355 | 0M | 0.00 | 0M | 158.9K | 8.93 |
Buffer Cache Reads (Data File) | 2.2G | 56.13 | .625355 | 0M | 0.00 | 0M | 158.9K | 8.93 |
Others | 844M | 7.87 | .233850 | 592M | 2.89 | .164027 | 28K | 3.33 |
Others (Control File) | 377M | 6.67 | .104456 | 156M | 2.77 | .043223 | 24.1K | 3.60 |
Others (Archive Log) | 0M | 0.00 | 0M | 436M | 0.12 | .120804 | 0 | |
Others (Log File) | 436M | 0.12 | .120804 | 0M | 0.00 | 0M | 4 | 3.25 |
Others (Data File) | 31M | 1.07 | .008589 | 0M | 0.00 | 0M | 3877 | 1.66 |
DBWR | 0M | 0.00 | 0M | 524M | 11.74 | .145186 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 524M | 11.74 | .145186 | 0 | |
LGWR | 0M | 0.00 | 0M | 262M | 33.97 | .072593 | 19 | 2.68 |
LGWR (Log File) | 0M | 0.00 | 0M | 262M | 33.96 | .072593 | 4 | 1.25 |
LGWR (Control File) | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 15 | 3.07 |
Direct Writes | 0M | 0.00 | 0M | 7M | 0.02 | .001939 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 7M | 0.02 | .001939 | 0 | |
Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 18.62 |
Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 13 | 18.62 |
TOTAL: | 247.1G | 134.78 | 70.1157 | 1.4G | 48.61 | .383747 | 186.9K | 8.10 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
coredata | 391,234 | 108 | 1.64 | 82.60 | 16,896 | 5 | 20,097 | 2.84 |
core_INDEX | 39,605 | 11 | 12.13 | 1.00 | 13,736 | 4 | 2,758 | 48.79 |
USERS | 23,439 | 6 | 10.80 | 1.00 | 7,055 | 2 | 2,112 | 179.16 |
SYSTEM | 3,296 | 1 | 4.08 | 1.01 | 122 | 0 | 433 | 589.28 |
UNDOTBS2 | 129 | 0 | 17.21 | 1.00 | 2,476 | 1 | 101 | 2.57 |
SYSAUX | 1,000 | 0 | 12.07 | 5.87 | 1,116 | 0 | 0 | 0.00 |
QUEST | 471 | 0 | 7.56 | 1.17 | 985 | 0 | 0 | 0.00 |
ETS_TMP | 88 | 0 | 2.73 | 1.00 | 1 | 0 | 0 | 0.00 |
TEMP | 6 | 0 | 10.00 | 1.00 | 2 | 0 | 0 | 0.00 |
AMSDATA | 2 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
UNDOTBS1 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 361 | 245.54 |
AMSINDEX | 1 | 0 | 0.00 | 1.00 | 1 | 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) |
---|---|---|---|---|---|---|---|---|---|
AMSDATA | +DATADG/coredb/datafile/amsdata.297.786494983 | 1 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
AMSDATA | +DATADG/coredb/datafile/amsdata.309.817664033 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
AMSINDEX | +DATADG/coredb/datafile/amsindex.298.786495075 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
coredata | +DATADG/coredb/datafile/coredata.270.730202259 | 36,050 | 10 | 1.41 | 104.07 | 1,448 | 0 | 2,385 | 1.59 |
coredata | +DATADG/coredb/datafile/coredata.271.730202435 | 36,828 | 10 | 1.38 | 104.50 | 1,810 | 1 | 2,455 | 1.03 |
coredata | +DATADG/coredb/datafile/coredata.272.730202619 | 37,032 | 10 | 1.37 | 102.04 | 2,799 | 1 | 2,204 | 0.90 |
coredata | +DATADG/coredb/datafile/coredata.273.730202791 | 35,847 | 10 | 1.44 | 101.57 | 2,461 | 1 | 2,115 | 0.73 |
coredata | +DATADG/coredb/datafile/coredata.274.730202937 | 37,151 | 10 | 1.56 | 100.51 | 2,766 | 1 | 2,112 | 0.82 |
coredata | +DATADG/coredb/datafile/coredata.283.745515419 | 36,147 | 10 | 1.39 | 103.88 | 1,791 | 0 | 2,282 | 2.84 |
coredata | +DATADG/coredb/datafile/coredata.295.783256433 | 62,928 | 17 | 1.67 | 56.87 | 268 | 0 | 1,651 | 1.05 |
coredata | +DATADG/coredb/datafile/coredata.296.783257507 | 64,127 | 18 | 1.75 | 56.05 | 671 | 0 | 1,618 | 1.34 |
coredata | +DATADG/coredb/datafile/coredata.305.796495117 | 25,646 | 7 | 2.47 | 66.14 | 2,031 | 1 | 2,228 | 13.64 |
coredata | +DATADG/coredb/datafile/coredata.307.803139899 | 19,478 | 5 | 2.42 | 48.18 | 851 | 0 | 1,047 | 4.47 |
core_INDEX | +DATADG/coredb/datafile/core_index.276.730204269 | 4,073 | 1 | 11.26 | 1.00 | 914 | 0 | 190 | 152.58 |
core_INDEX | +DATADG/coredb/datafile/core_index.277.730204109 | 4,044 | 1 | 11.64 | 1.00 | 1,218 | 0 | 110 | 32.55 |
core_INDEX | +DATADG/coredb/datafile/core_index.280.730204413 | 4,099 | 1 | 10.48 | 1.00 | 1,833 | 1 | 323 | 20.80 |
core_INDEX | +DATADG/coredb/datafile/core_index.281.730204551 | 2,718 | 1 | 12.30 | 1.00 | 1,074 | 0 | 80 | 13.63 |
core_INDEX | +DATADG/coredb/datafile/core_index.282.730204685 | 3,293 | 1 | 11.23 | 1.00 | 918 | 0 | 29 | 24.83 |
core_INDEX | +DATADG/coredb/datafile/core_index.286.745515665 | 2,705 | 1 | 12.18 | 1.00 | 693 | 0 | 12 | 53.33 |
core_INDEX | +DATADG/coredb/datafile/core_index.291.771353279 | 3,008 | 1 | 12.09 | 1.00 | 1,399 | 0 | 20 | 18.00 |
core_INDEX | +DATADG/coredb/datafile/core_index.292.771353509 | 1,789 | 0 | 14.18 | 1.00 | 483 | 0 | 29 | 88.28 |
core_INDEX | +DATADG/coredb/datafile/core_index.293.783255523 | 2,570 | 1 | 13.75 | 1.00 | 1,055 | 0 | 36 | 38.89 |
core_INDEX | +DATADG/coredb/datafile/core_index.294.783255951 | 2,759 | 1 | 13.07 | 1.00 | 1,220 | 0 | 966 | 44.01 |
core_INDEX | +DATADG/coredb/datafile/core_index.302.796411061 | 2,341 | 1 | 14.12 | 1.00 | 777 | 0 | 199 | 21.76 |
core_INDEX | +DATADG/coredb/datafile/core_index.303.796493979 | 2,933 | 1 | 12.08 | 1.00 | 1,249 | 0 | 217 | 136.22 |
core_INDEX | +DATADG/coredb/datafile/core_index.306.803129617 | 3,273 | 1 | 12.10 | 1.00 | 903 | 0 | 547 | 22.10 |
ETS_TMP | +DATADG/coredb/datafile/ets_tmp.275.730287209 | 88 | 0 | 2.73 | 1.00 | 1 | 0 | 0 | 0.00 |
QUEST | +DATADG/coredb/datafile/quest.289.748266187 | 471 | 0 | 7.56 | 1.17 | 985 | 0 | 0 | 0.00 |
SYSAUX | +DATADG/coredb/datafile/sysaux.260.729362609 | 927 | 0 | 12.29 | 6.25 | 1,017 | 0 | 0 | 0.00 |
SYSAUX | +DATADG/coredb/datafile/sysaux.301.787835057 | 73 | 0 | 9.32 | 1.03 | 99 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/coredb/datafile/system.259.729362599 | 3,296 | 1 | 4.08 | 1.01 | 122 | 0 | 433 | 589.28 |
TEMP | +DATADG/coredb/tempfile/temp.262.729362685 | 6 | 0 | 10.00 | 1.00 | 2 | 0 | 0 | |
UNDOTBS1 | +DATADG/coredb/datafile/undotbs1.261.744737439 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 361 | 245.54 |
UNDOTBS2 | +DATADG/coredb/datafile/undotbs2.263.744738251 | 129 | 0 | 17.21 | 1.00 | 2,476 | 1 | 101 | 2.57 |
USERS | +DATADG/coredb/datafile/users.264.730203979 | 3,200 | 1 | 10.52 | 1.00 | 945 | 0 | 377 | 419.10 |
USERS | +DATADG/coredb/datafile/users.278.730203631 | 3,591 | 1 | 11.14 | 1.00 | 1,661 | 0 | 65 | 428.46 |
USERS | +DATADG/coredb/datafile/users.279.730203813 | 3,422 | 1 | 10.58 | 1.00 | 710 | 0 | 45 | 623.78 |
USERS | +DATADG/coredb/datafile/users.287.733311617 | 4,867 | 1 | 10.29 | 1.00 | 850 | 0 | 1,154 | 114.96 |
USERS | +DATADG/coredb/datafile/users.288.733311861 | 3,457 | 1 | 10.77 | 1.00 | 1,498 | 0 | 424 | 72.76 |
USERS | +DATADG/coredb/datafile/users.290.745515943 | 3,254 | 1 | 10.87 | 1.00 | 667 | 0 | 43 | 21.40 |
USERS | +DATADG/coredb/datafile/users.300.787832331 | 745 | 0 | 12.32 | 1.00 | 228 | 0 | 2 | 10.00 |
USERS | +DATADG/coredb/datafile/users.304.796494633 | 464 | 0 | 13.81 | 1.00 | 493 | 0 | 0 | 0.00 |
USERS | +DATADG/coredb/datafile/users.308.803140519 | 439 | 0 | 11.39 | 1.00 | 3 | 0 | 2 | 5.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 1,746,218 | 100 | 343,084,719 | 288,983 | 66,965 | 0 | 0 | 25,995 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 45,625 | 0 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
---|---|---|---|---|---|---|---|---|---|---|
B | 0 | 9 | 5673 | 46630 | 289654 | 2488320 | 289654 | 4 | ||
E | 0 | 10 | 6958 | 64926 | 289331 | 2488320 | 289331 | 5 |
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 | 1,472 | 0.10 | 174 | 44.23 | 103,769,108 | 1 | 682308187.00 |
D | 2,944 | 0.20 | 348 | 21.84 | 51,242,167 | 1 | 332652794.00 |
D | 4,416 | 0.30 | 522 | 11.43 | 26,812,274 | 1 | 170030634.00 |
D | 5,888 | 0.40 | 696 | 6.14 | 14,394,071 | 1 | 87366533.00 |
D | 7,360 | 0.50 | 869 | 3.41 | 7,998,493 | 1 | 44793169.00 |
D | 8,832 | 0.60 | 1,043 | 2.13 | 5,001,171 | 1 | 24840936.00 |
D | 10,304 | 0.70 | 1,217 | 1.55 | 3,638,780 | 1 | 15771927.00 |
D | 11,776 | 0.80 | 1,391 | 1.27 | 2,970,816 | 1 | 11325496.00 |
D | 13,248 | 0.90 | 1,565 | 1.11 | 2,597,441 | 1 | 8840052.00 |
D | 14,720 | 1.00 | 1,739 | 1.00 | 2,353,779 | 1 | 7218075.00 |
D | 14,784 | 1.00 | 1,746 | 1.00 | 2,346,168 | 1 | 7167410.00 |
D | 16,192 | 1.10 | 1,913 | 0.93 | 2,178,676 | 1 | 6052470.00 |
D | 17,664 | 1.19 | 2,087 | 0.87 | 2,045,031 | 1 | 5162833.00 |
D | 19,136 | 1.29 | 2,260 | 0.83 | 1,944,180 | 1 | 4491503.00 |
D | 20,608 | 1.39 | 2,434 | 0.79 | 1,864,064 | 1 | 3958194.00 |
D | 22,080 | 1.49 | 2,608 | 0.77 | 1,797,376 | 1 | 3514272.00 |
D | 23,552 | 1.59 | 2,782 | 0.74 | 1,741,317 | 1 | 3141109.00 |
D | 25,024 | 1.69 | 2,956 | 0.72 | 1,691,901 | 1 | 2812162.00 |
D | 26,496 | 1.79 | 3,130 | 0.70 | 1,646,125 | 1 | 2507444.00 |
D | 27,968 | 1.89 | 3,304 | 0.68 | 1,595,560 | 1 | 2170844.00 |
D | 29,440 | 1.99 | 3,478 | 0.65 | 1,534,048 | 1 | 1761384.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 44,264 | 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 | 6,144 | 3,702 | 2,756.74 | 11.59 | 0.42 | 100.00 | 0.00 | 629,140 |
E | 6,144 | 2,799 | 4,113.90 | 0.19 | 0.00 | 100.00 | 0.00 | 629,140 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 1,379,497 | 1,379,497 | 0 | 0 |
64K | 128K | 6,803 | 6,803 | 0 | 0 |
128K | 256K | 980 | 980 | 0 | 0 |
256K | 512K | 382 | 382 | 0 | 0 |
512K | 1024K | 16,092 | 16,092 | 0 | 0 |
1M | 2M | 19,760 | 19,760 | 0 | 0 |
4M | 8M | 50 | 50 | 0 | 0 |
8M | 16M | 45 | 45 | 0 | 0 |
32M | 64M | 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 |
---|---|---|---|---|---|---|
768 | 0.13 | 116,501,759.48 | 37,594,431.22 | 76.00 | 2,042,059 | 151,236,799,984 |
1,536 | 0.25 | 116,501,759.48 | 36,078,048.54 | 76.00 | 1,945,618 | 149,748,555,130 |
3,072 | 0.50 | 116,501,759.48 | 284,001.90 | 100.00 | 1,744 | 114,618,698,585 |
4,608 | 0.75 | 116,501,759.48 | 243,228.32 | 100.00 | 0 | 114,578,681,602 |
6,144 | 1.00 | 116,501,759.48 | 31,805.25 | 100.00 | 0 | 114,371,181,665 |
7,373 | 1.20 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
8,602 | 1.40 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
9,830 | 1.60 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
11,059 | 1.80 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
12,288 | 2.00 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
18,432 | 3.00 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
24,576 | 4.00 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
36,864 | 6.00 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
49,152 | 8.00 | 116,501,759.48 | 30,851.84 | 100.00 | 0 | 114,370,245,956 |
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) |
---|---|---|---|---|---|---|---|---|
9,472 | 1.00 | 461 | 34,040 | 66,428,370 | 1.00 | 4,039,069 | 1.00 | 1,680,417 |
10,432 | 1.10 | 1,427 | 96,395 | 66,498,177 | 1.00 | 3,969,262 | 0.98 | 3,548,017 |
11,392 | 1.20 | 2,386 | 148,216 | 66,610,986 | 1.00 | 3,856,453 | 0.95 | 3,566,465 |
12,352 | 1.30 | 3,345 | 199,446 | 66,670,949 | 1.00 | 3,796,490 | 0.94 | 3,577,788 |
13,312 | 1.41 | 4,305 | 250,472 | 66,706,985 | 1.00 | 3,760,454 | 0.93 | 3,585,069 |
14,272 | 1.51 | 5,264 | 301,709 | 66,730,857 | 1.00 | 3,736,582 | 0.93 | 3,590,241 |
15,232 | 1.61 | 6,224 | 353,044 | 66,747,362 | 1.00 | 3,720,077 | 0.92 | 3,594,138 |
16,192 | 1.71 | 7,184 | 404,357 | 66,759,329 | 1.01 | 3,708,110 | 0.92 | 3,597,211 |
17,152 | 1.81 | 8,144 | 455,669 | 66,768,768 | 1.01 | 3,698,671 | 0.92 | 3,599,749 |
18,112 | 1.91 | 9,103 | 506,794 | 66,776,706 | 1.01 | 3,690,733 | 0.91 | 3,601,929 |
19,072 | 2.01 | 10,063 | 558,049 | 66,783,471 | 1.01 | 3,683,968 | 0.91 | 3,603,843 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
12,288 | 0.50 | 713,680,731 | 103,768,883,741 |
15,360 | 0.63 | 201,404,066 | 26,812,238,555 |
18,432 | 0.75 | 56,282,558 | 5,001,090,969 |
21,504 | 0.88 | 42,768,875 | 2,970,717,482 |
24,576 | 1.00 | 38,610,521 | 2,346,167,653 |
27,648 | 1.13 | 36,537,137 | 2,044,919,726 |
30,720 | 1.25 | 35,332,489 | 1,864,030,200 |
33,792 | 1.38 | 34,255,255 | 1,691,821,495 |
36,864 | 1.50 | 33,614,320 | 1,595,628,621 |
39,936 | 1.63 | 33,023,580 | 1,534,159,028 |
43,008 | 1.75 | 32,903,888 | 1,534,159,028 |
46,080 | 1.88 | 32,865,278 | 1,534,159,028 |
49,152 | 2.00 | 32,849,834 | 1,534,159,028 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
64 | 1.00 | 0 | 0 | 0 | 0 |
128 | 2.00 | 0 | 0 | 0 | 0 |
192 | 3.00 | 0 | 0 | 0 | 0 |
256 | 4.00 | 0 | 0 | 0 | 0 |
320 | 5.00 | 0 | 0 | 0 | 0 |
384 | 6.00 | 0 | 0 | 0 | 0 |
448 | 7.00 | 0 | 0 | 0 | 0 |
512 | 8.00 | 0 | 0 | 0 | 0 |
576 | 9.00 | 0 | 0 | 0 | 0 |
640 | 10.00 | 0 | 0 | 0 | 0 |
704 | 11.00 | 0 | 0 | 0 | 0 |
768 | 12.00 | 0 | 0 | 0 | 0 |
832 | 13.00 | 0 | 0 | 0 | 0 |
896 | 14.00 | 0 | 0 | 0 | 0 |
960 | 15.00 | 0 | 0 | 0 | 0 |
1,024 | 16.00 | 0 | 0 | 0 | 0 |
1,088 | 17.00 | 0 | 0 | 0 | 0 |
1,152 | 18.00 | 0 | 0 | 0 | 0 |
1,216 | 19.00 | 0 | 0 | 0 | 0 |
1,280 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 25,453 | 812 | 32 |
undo header | 362 | 88 | 244 |
system undo header | 65 | 13 | 206 |
undo block | 100 | 1 | 5 |
2nd level bmb | 2 | 0 | 80 |
1st level bmb | 8 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 402 | 402 | 0 | 387 | 1,258 | 3,249.86 |
PR-Process Startup | 105 | 105 | 0 | 5 | 241 | 48,207.00 |
PV-KSV slave startup (syncstart) | 27 | 27 | 0 | 4 | 108 | 26,881.50 |
US-Undo Segment | 2,056 | 2,056 | 0 | 1,022 | 90 | 88.25 |
TX-Transaction (index contention) | 582 | 582 | 0 | 465 | 69 | 147.67 |
CF-Controlfile Transaction | 10,168 | 10,161 | 7 | 352 | 22 | 63.44 |
WF-AWR Flush | 27 | 27 | 0 | 18 | 17 | 963.89 |
SQ-Sequence Cache | 1,706 | 1,706 | 0 | 140 | 12 | 86.54 |
PS-PX Process Reservation | 1,037 | 1,030 | 7 | 902 | 9 | 10.27 |
TX-Transaction | 76,819 | 76,816 | 0 | 93 | 4 | 47.24 |
KO-Multiple Object Checkpoint (fast object checkpoint) | 2,188 | 2,188 | 0 | 679 | 4 | 5.84 |
FB-Format Block | 47 | 47 | 0 | 23 | 1 | 52.04 |
JQ-Job Queue | 35 | 34 | 1 | 25 | 1 | 35.20 |
TM-DML | 262,079 | 262,080 | 0 | 14 | 0 | 28.43 |
CR-Reuse Block Range (block range reuse ckpt) | 1,450 | 1,450 | 0 | 290 | 0 | 0.49 |
WL-Being Written Redo Log | 1 | 1 | 0 | 1 | 0 | 51.00 |
TX-Transaction (allocate ITL entry) | 26 | 26 | 0 | 17 | 0 | 1.59 |
TQ-Queue table enqueue (TM contention) | 60 | 60 | 0 | 16 | 0 | 1.63 |
TT-Tablespace | 4,468 | 4,468 | 0 | 38 | 0 | 0.61 |
RO-Multiple Object Reuse (fast object reuse) | 64 | 64 | 0 | 26 | 0 | 0.77 |
TA-Instance Undo | 14 | 14 | 0 | 13 | 0 | 0.69 |
AE-Edition Lock (lock) | 1,430 | 1,430 | 0 | 7 | 0 | 1.00 |
TO-Temp Object | 14 | 14 | 0 | 4 | 0 | 1.00 |
HW-Segment High Water Mark | 2,986 | 2,986 | 0 | 4 | 0 | 0.75 |
MD-Materialized View Log DDL | 6 | 6 | 0 | 4 | 0 | 0.50 |
PW-Buffer Cache PreWarm (flush prewarm buffers) | 2 | 2 | 0 | 2 | 0 | 1.00 |
JS-Job Scheduler (job run lock - synchronize) | 1 | 1 | 0 | 1 | 0 | 1.00 |
TD-KTF map table enqueue (KTF dump entries) | 10 | 10 | 0 | 1 | 0 | 1.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 |
---|---|---|---|---|---|---|---|
4 | 21.01 | 71,702 | 1,065 | 117 | 180/180 | 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 |
---|---|---|---|---|---|---|---|
07-8月 22:51 | 5,629 | 19,532 | 69 | 6 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:41 | 803 | 4,529 | 757 | 117 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:31 | 3,662 | 11,836 | 35 | 38 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:21 | 3,468 | 11,626 | 759 | 6 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:11 | 3,361 | 11,363 | 729 | 5 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:01 | 4,084 | 12,816 | 1,065 | 6 | 180 | 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 | 5 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 830 | 0.00 | 0 | 0 | ||
ASM Keyed state latch | 3,314 | 0.24 | 0.00 | 0 | 0 | |
ASM allocation | 789 | 0.00 | 0 | 0 | ||
ASM db client latch | 10,298 | 0.00 | 0 | 0 | ||
ASM map headers | 21 | 0.00 | 0 | 0 | ||
ASM map load waiting list | 6 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 8,315 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 1,335,476 | 0.00 | 0.00 | 0 | 0 | |
ASM network background latch | 1,882 | 0.00 | 0 | 0 | ||
ASM network state latch | 279 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 65,467 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,131 | 0.00 | 0 | 0 | ||
Consistent RBA | 121,888 | 0.00 | 0.00 | 0 | 0 | |
DML lock allocation | 162,097,466 | 0.37 | 0.00 | 1 | 0 | |
Event Group Locks | 1,831 | 0.00 | 0 | 0 | ||
FAL Queue | 98 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 26 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 17,935 | 0.07 | 0.00 | 0 | 0 | |
File State Object Pool Parent Latch | 5 | 0.00 | 0 | 0 | ||
I/O Staticstics latch | 5 | 0.00 | 0 | 0 | ||
IPC other latch | 31 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 5,791 | 0.00 | 0 | 7,232 | 0.11 | |
In memory undo latch | 5 | 0.00 | 0 | 0 | ||
JS Sh mem access | 13 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 16,732 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 16,732 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 16,630 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 14 | 0.00 | 0 | 0 | ||
JS queue access latch | 19 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 598,694 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 157 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 5 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 5 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 5 | 0.00 | 0 | 0 | ||
KFK SGA Libload latch | 960 | 0.00 | 0 | 0 | ||
KFMD SGA | 3 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 5 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 5 | 0.00 | 0 | 0 | ||
KJC message pool free list | 68,204 | 0.10 | 0.00 | 0 | 12,126 | 0.00 |
KJCT flow control latch | 1,433,445 | 0.02 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 27,916 | 0.00 | 0 | 0 | ||
KMG resize request state object freelist | 12 | 0.00 | 0 | 0 | ||
KTF sga latch | 32 | 0.00 | 0 | 1,184 | 0.00 | |
KWQMN job cache list latch | 574 | 0.17 | 1.00 | 0 | 0 | |
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 31 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 64 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 5 | 0.00 | 0 | 0 | ||
Lsod array latch | 20,859 | 0.14 | 0.00 | 0 | 0 | |
MQL Tracking Latch | 0 | 0 | 72 | 0.00 | ||
Memory Management Latch | 26,953 | 0.00 | 0 | 27,916 | 0.00 | |
Memory Queue | 5 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 5 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 5 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 5 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 5 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 5 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 2,340 | 0.00 | 0 | 0 | ||
Mutex | 5 | 0.00 | 0 | 0 | ||
Mutex Stats | 5 | 0.00 | 0 | 0 | ||
OS process | 5,102 | 0.00 | 0 | 0 | ||
OS process allocation | 10,711 | 0.94 | 34.17 | 1025 | 0 | |
OS process: request allocation | 3,316 | 0.06 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 48,207 | 0.00 | 0 | 0 | ||
PX hash array latch | 5 | 0.00 | 0 | 0 | ||
QMT | 5 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 22,791 | 0.00 | 0 | 0 | ||
Reserved Space Latch | 4 | 0.00 | 0 | 0 | ||
Result Cache: RC Latch | 10 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 35 | 0.00 | 0 | 35 | 0.00 | |
SGA blob parent | 5 | 0.00 | 0 | 0 | ||
SGA bucket locks | 5 | 0.00 | 0 | 0 | ||
SGA heap locks | 5 | 0.00 | 0 | 0 | ||
SGA pool locks | 5 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 5 | 0.00 | 0 | 3,498 | 0.00 | |
SQL memory manager workarea list latch | 433,345 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 458 | 0.00 | 0 | 0 | ||
Streams Generic | 5 | 0.00 | 0 | 0 | ||
Testing | 5 | 0.00 | 0 | 0 | ||
Token Manager | 5 | 0.00 | 0 | 0 | ||
WCR: sync | 5 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 5 | 0.00 | 0 | 0 | ||
X$KSFQP | 13,810 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 5 | 0.00 | 0 | 0 | ||
XDB unused session pool | 5 | 0.00 | 0 | 0 | ||
XDB used session pool | 5 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 27,394 | 0.31 | 0.00 | 0 | 0 | |
active service list | 5,814,499 | 0.01 | 0.04 | 0 | 1,404,658 | 0.01 |
alert log latch | 2 | 0.00 | 0 | 0 | ||
archive control | 352 | 0.00 | 0 | 0 | ||
archive process latch | 295 | 0.00 | 0 | 0 | ||
begin backup scn array | 34 | 0.00 | 0 | 0 | ||
buffer pool | 11 | 0.00 | 0 | 0 | ||
business card | 83 | 0.00 | 0 | 0 | ||
cache buffer handles | 86,520 | 0.01 | 0.00 | 0 | 0 | |
cache buffers chains | 688,324,486 | 0.15 | 0.00 | 3 | 16,728,139 | 0.00 |
cache buffers lru chain | 525,248 | 0.02 | 0.12 | 0 | 15,598,442 | 0.04 |
cache table scan latch | 18,980 | 0.02 | 0.00 | 0 | 18,980 | 0.00 |
call allocation | 24,019 | 0.07 | 0.24 | 0 | 0 | |
cas latch | 5 | 0.00 | 0 | 0 | ||
change notification client cache latch | 5 | 0.00 | 0 | 0 | ||
channel handle pool latch | 3,383 | 0.38 | 0.00 | 0 | 0 | |
channel operations parent latch | 3,300,436 | 0.00 | 0.00 | 0 | 0 | |
checkpoint queue latch | 2,538,175 | 0.00 | 0.03 | 0 | 256,424 | 0.00 |
client/application info | 18,259 | 0.01 | 0.00 | 0 | 0 | |
compile environment latch | 2,355 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 145,022 | 0.02 | 0.00 | 0 | 0 | |
cp cmon/server latch | 5 | 0.00 | 0 | 0 | ||
cp pool latch | 5 | 0.00 | 0 | 0 | ||
cp server hash latch | 5 | 0.00 | 0 | 0 | ||
cp sga latch | 187 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 5 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 187 | 0.00 | 0 | 0 | ||
dml lock allocation | 187 | 0.00 | 0 | 0 | ||
done queue latch | 5 | 0.00 | 0 | 0 | ||
dummy allocation | 4,378 | 0.02 | 0.00 | 0 | 0 | |
enqueue hash chains | 2,938,681 | 0.02 | 0.13 | 0 | 2,362 | 0.00 |
enqueues | 1,673,252 | 0.03 | 0.01 | 0 | 0 | |
error message lists | 149 | 0.00 | 0 | 0 | ||
fifth spare latch | 5 | 0.00 | 0 | 0 | ||
file cache latch | 903 | 0.00 | 0 | 0 | ||
flashback copy | 5 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 5 | 0.00 | 0 | 0 | ||
gc element | 3,259,289 | 0.05 | 0.12 | 10 | 2,670,756 | 0.05 |
gcr global ctx | 1 | 0.00 | 0 | 0 | ||
gcs commit scn state | 5 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 818,220 | 0.18 | 0.01 | 0 | 0 | |
gcs partitioned table hash | 19,798,401 | 0.26 | 0.00 | 0 | 342,110 | 0.00 |
gcs pcm hashed value bucket hash | 5 | 0.00 | 0 | 0 | ||
gcs remaster request queue | 13 | 0.00 | 0 | 0 | ||
gcs remastering latch | 3,868,918 | 1.74 | 0.00 | 1 | 594 | 1.85 |
gcs resource freelist | 691,994 | 0.00 | 0.00 | 0 | 948,786 | 0.00 |
gcs resource hash | 9,529,797 | 0.01 | 0.04 | 3 | 69 | 0.00 |
gcs resource scan list | 161 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 875,805 | 0.00 | 0.00 | 0 | 1,064,348 | 0.00 |
ges caches resource lists | 1,031,790 | 0.02 | 0.07 | 0 | 1,434,432 | 0.01 |
ges deadlock list | 37,184 | 0.02 | 0.00 | 0 | 36,671 | 0.00 |
ges domain table | 4,043,756 | 0.00 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 4,109,700 | 0.01 | 0.02 | 0 | 0 | |
ges group table | 4,043,405 | 0.00 | 0.13 | 0 | 0 | |
ges process hash list | 1,262,143 | 0.01 | 0.74 | 0 | 0 | |
ges process parent latch | 8,347,510 | 0.00 | 0.00 | 0 | 1 | 0.00 |
ges process table freelist | 3,314 | 0.03 | 0.00 | 0 | 0 | |
ges resource hash list | 6,225,337 | 0.04 | 1.31 | 606 | 78,766 | 0.00 |
ges resource scan list | 1,404 | 0.00 | 0 | 0 | ||
ges resource table freelist | 109,758 | 0.00 | 0.00 | 0 | 0 | |
ges timeout list | 18,126 | 0.01 | 0.00 | 0 | 1,677 | 0.00 |
ges value block free list | 483 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 1,364 | 0.00 | 0 | 0 | ||
global ctx hash table latch | 1 | 0.00 | 0 | 0 | ||
global tx hash mapping | 237 | 0.00 | 0 | 0 | ||
granule operation | 5 | 0.00 | 0 | 0 | ||
hash table column usage latch | 1,779 | 0.00 | 0 | 5,859,272 | 0.01 | |
hash table modification latch | 119 | 0.00 | 0 | 0 | ||
heartbeat check | 5 | 0.00 | 0 | 2,623 | 0.00 | |
heartbeat structure management | 2 | 0.00 | 0 | 680 | 0.00 | |
internal temp table object number allocation latch | 33 | 0.00 | 0 | 0 | ||
interrupt manipulation | 6,937 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 5 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 5 | 0.00 | 0 | 0 | ||
job workq parent latch | 40 | 0.00 | 0 | 35 | 0.00 | |
job_queue_processes free list latch | 72 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 16,719 | 0.00 | 0 | 0 | ||
k2q global data latch | 2,478 | 0.00 | 0 | 0 | ||
k2q lock allocation | 341 | 0.00 | 0 | 0 | ||
kcbtsemkid latch | 1 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 5 | 0.00 | 0 | 0 | ||
kgb parent | 5 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 5 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 3,736 | 0.00 | 0 | 0 | ||
krbmrosl | 2 | 0.00 | 0 | 0 | ||
ksfv messages | 5 | 0.00 | 0 | 0 | ||
ksim group membership cache | 1,929 | 0.00 | 0 | 0 | ||
ksim membership request latch | 314 | 0.00 | 0 | 3,181 | 0.00 | |
kss move lock | 59 | 0.00 | 0 | 0 | ||
ksuosstats global area | 259 | 0.00 | 0 | 0 | ||
ksv allocation latch | 295 | 0.00 | 0 | 0 | ||
ksv class latch | 6,893 | 0.00 | 0 | 0 | ||
ksv instance latch | 16 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 12 | 0.00 | 0 | 7 | 0.00 | |
ksxp shared latch | 3,314 | 0.21 | 0.00 | 0 | 0 | |
ksxp so latch | 3,314 | 0.21 | 0.00 | 0 | 0 | |
ksz_so allocation latch | 3,314 | 0.63 | 0.00 | 0 | 0 | |
ktm global data | 276 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 126 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 141,216 | 0.03 | 0.06 | 0 | 0 | |
list of block allocation | 3,658 | 0.08 | 0.00 | 0 | 0 | |
loader state object freelist | 507 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 5 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 17 | 0.00 | 0 | 0 | ||
lob segment query latch | 5 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 5 | 0.00 | 0 | 0 | ||
logical standby cache | 5 | 0.00 | 0 | 0 | ||
logminer context allocation | 6 | 0.00 | 0 | 0 | ||
logminer work area | 5 | 0.00 | 0 | 0 | ||
longop free list parent | 158 | 0.00 | 0 | 153 | 0.00 | |
managed standby latch | 97 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 5 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 12,401 | 0.00 | 0 | 0 | ||
messages | 873,642 | 0.03 | 0.01 | 0 | 0 | |
mostly latch-free SCN | 142,273 | 0.62 | 0.00 | 0 | 0 | |
msg queue latch | 5 | 0.00 | 0 | 0 | ||
multiblock read objects | 231,916 | 0.04 | 0.04 | 0 | 0 | |
name-service memory objects | 26,101 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 35,073 | 0.00 | 0 | 0 | ||
name-service pending queue | 10,110 | 0.00 | 0 | 0 | ||
name-service request | 52 | 0.00 | 0 | 0 | ||
name-service request queue | 46,438 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 187 | 0.00 | 0 | 0 | ||
object queue header heap | 16,175 | 0.00 | 0 | 15,418 | 0.00 | |
object queue header operation | 3,131,467 | 0.01 | 0.57 | 3 | 90,152 | 0.00 |
object stats modification | 3,419 | 0.00 | 0 | 1 | 0.00 | |
parallel query alloc buffer | 7,636 | 0.00 | 0 | 0 | ||
parallel query stats | 967 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 24,934 | 0.00 | 0 | 0 | ||
parameter list | 7,597 | 0.00 | 0 | 0 | ||
parameter table management | 10,824 | 0.01 | 1.00 | 0 | 0 | |
peshm | 5 | 0.00 | 0 | 0 | ||
pesom_free_list | 5 | 0.00 | 0 | 0 | ||
pesom_hash_node | 5 | 0.00 | 0 | 0 | ||
post/wait queue | 231,958 | 0.02 | 0.02 | 0 | 120,567 | 0.02 |
process allocation | 3,421 | 1.72 | 0.81 | 2 | 1,815 | 0.61 |
process group creation | 3,314 | 0.00 | 0 | 0 | ||
process queue | 2,821 | 0.00 | 0 | 0 | ||
process queue reference | 96,535 | 0.00 | 0 | 10,619 | 0.08 | |
qmn state object latch | 5 | 0.00 | 0 | 0 | ||
qmn task context latch | 3 | 0.00 | 0 | 0 | ||
qmn task queue latch | 839 | 2.62 | 0.82 | 0 | 0 | |
query server freelists | 1,953 | 0.00 | 0 | 0 | ||
query server process | 8 | 0.00 | 0 | 9 | 0.00 | |
queued dump request | 12 | 0.00 | 0 | 0 | ||
queuing load statistics | 5 | 0.00 | 0 | 0 | ||
recovery domain hash list | 5 | 0.00 | 0 | 0 | ||
redo allocation | 405,080 | 0.05 | 0.05 | 0 | 749,956 | 0.13 |
redo copy | 5 | 0.00 | 0 | 750,332 | 0.32 | |
redo writing | 396,793 | 0.01 | 0.00 | 0 | 0 | |
reservation so alloc latch | 2 | 0.00 | 0 | 0 | ||
resmgr group change latch | 3,171 | 0.00 | 0 | 0 | ||
resmgr:active threads | 36,351 | 0.07 | 1.04 | 0 | 1,802 | 0.00 |
resmgr:actses change group | 2,329 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 161 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 4,405 | 0.02 | 0.00 | 0 | 0 | |
resmgr:plan CPU method | 5 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 6 | 0.00 | 0 | 0 | ||
resmgr:schema config | 184,756 | 0.12 | 0.97 | 0 | 117 | 0.85 |
resmgr:session queuing | 5 | 0.00 | 0 | 0 | ||
rm cas latch | 5 | 0.00 | 0 | 0 | ||
row cache objects | 47,126,142 | 0.47 | 0.00 | 55 | 5,146 | 0.45 |
rules engine aggregate statistics | 12 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 124 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 5 | 0.00 | 0 | 0 | ||
second spare latch | 5 | 0.00 | 0 | 0 | ||
segmented array pool | 6 | 0.00 | 0 | 0 | ||
sequence cache | 111,387 | 0.02 | 0.00 | 0 | 0 | |
session allocation | 807,806 | 0.00 | 0.27 | 0 | 803,557 | 0.02 |
session idle bit | 12,207,391 | 0.01 | 0.01 | 0 | 0 | |
session queue latch | 5 | 0.00 | 0 | 0 | ||
session state list latch | 4,677 | 0.09 | 0.00 | 0 | 0 | |
session switching | 7,642 | 0.00 | 0 | 0 | ||
session timer | 1,313 | 0.00 | 0 | 0 | ||
shared pool | 11,120,518 | 0.08 | 0.21 | 7 | 0 | |
shared pool sim alloc | 5 | 0.00 | 0 | 0 | ||
shared pool simulator | 1,980,468 | 0.01 | 0.31 | 0 | 0 | |
sim partition latch | 5 | 0.00 | 0 | 0 | ||
simulator hash latch | 21,855,094 | 0.00 | 0.03 | 0 | 0 | |
simulator lru latch | 1,308 | 0.15 | 0.50 | 0 | 21,847,130 | 0.29 |
sort extent pool | 406 | 0.00 | 0 | 0 | ||
space background state object latch | 10 | 0.00 | 0 | 0 | ||
space background task latch | 3,215 | 0.00 | 0 | 2,223 | 0.00 | |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 784 | 0.00 | 0 | 0 | ||
tablespace key chain | 2,908 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 20 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 5 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 5 | 0.00 | 0 | 0 | ||
third spare latch | 5 | 0.00 | 0 | 0 | ||
threshold alerts latch | 221 | 0.00 | 0 | 0 | ||
trace latch | 85 | 0.00 | 0 | 0 | ||
transaction allocation | 41,522,276 | 0.17 | 0.00 | 0 | 0 | |
transaction branch allocation | 1,497 | 0.00 | 0 | 0 | ||
undo global data | 519,230 | 0.02 | 0.01 | 0 | 725 | 0.41 |
virtual circuit buffers | 5 | 0.00 | 0 | 0 | ||
virtual circuit holder | 5 | 0.00 | 0 | 0 | ||
virtual circuit queues | 5 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 688,324,486 | 1,030,634 | 4,018 | 1,026,775 |
DML lock allocation | 162,097,466 | 607,024 | 1,624 | 605,455 |
row cache objects | 47,126,142 | 220,845 | 835 | 220,092 |
transaction allocation | 41,522,276 | 70,863 | 320 | 70,556 |
gcs remastering latch | 3,868,918 | 67,409 | 4 | 67,409 |
shared pool | 11,120,518 | 8,814 | 1,861 | 6,979 |
ges resource hash list | 6,225,337 | 2,403 | 3,144 | 1,177 |
gc element | 3,259,289 | 1,545 | 188 | 1,375 |
gcs opaque info freelist | 818,220 | 1,485 | 16 | 1,470 |
gcs resource hash | 9,529,797 | 1,077 | 40 | 1,042 |
mostly latch-free SCN | 142,273 | 876 | 3 | 873 |
active service list | 5,814,499 | 778 | 31 | 747 |
session idle bit | 12,207,391 | 696 | 8 | 688 |
enqueue hash chains | 2,938,681 | 500 | 65 | 436 |
enqueues | 1,673,252 | 487 | 5 | 482 |
object queue header operation | 3,131,467 | 400 | 228 | 191 |
simulator hash latch | 21,855,094 | 278 | 7 | 271 |
messages | 873,642 | 276 | 4 | 272 |
ges enqueue table freelist | 4,109,700 | 248 | 5 | 243 |
KJCT flow control latch | 1,433,445 | 229 | 1 | 228 |
resmgr:schema config | 184,756 | 215 | 209 | 6 |
ges caches resource lists | 1,031,790 | 210 | 15 | 196 |
ges process hash list | 1,262,143 | 189 | 140 | 49 |
redo allocation | 405,080 | 187 | 10 | 177 |
ges group table | 4,043,405 | 181 | 23 | 158 |
OS process allocation | 10,711 | 101 | 3,451 | 6 |
shared pool simulator | 1,980,468 | 100 | 31 | 69 |
undo global data | 519,230 | 93 | 1 | 92 |
multiblock read objects | 231,916 | 83 | 3 | 80 |
cache buffers lru chain | 525,248 | 81 | 10 | 71 |
process allocation | 3,421 | 59 | 48 | 12 |
post/wait queue | 231,958 | 48 | 1 | 47 |
lgwr LWN SCN | 141,216 | 36 | 2 | 34 |
checkpoint queue latch | 2,538,175 | 35 | 1 | 34 |
resmgr:active threads | 36,351 | 27 | 28 | 0 |
session allocation | 807,806 | 26 | 7 | 19 |
qmn task queue latch | 839 | 22 | 18 | 5 |
call allocation | 24,019 | 17 | 4 | 13 |
simulator lru latch | 1,308 | 2 | 1 | 1 |
KWQMN job cache list latch | 574 | 1 | 1 | 0 |
parameter table management | 10,824 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
DML lock allocation | ktadmc | 0 | 1,623 | 1,550 |
DML lock allocation | ktaiam | 0 | 1 | 49 |
KJCT flow control latch | kjctcsnd: send normal message | 0 | 1 | 1 |
KWQMN job cache list latch | kwqmnprsc: loop | 0 | 1 | 0 |
OS process allocation | kso_new_process:1 | 0 | 3,357 | 0 |
OS process allocation | kso_new_process:2 | 0 | 89 | 3,295 |
OS process allocation | ksosp_forknew | 0 | 2 | 0 |
OS process allocation | kso_delete_process:1 | 0 | 1 | 89 |
OS process allocation | ksoreq_cancel:1 | 0 | 1 | 67 |
OS process allocation | ksoreq_submit | 0 | 1 | 0 |
active service list | kswslogon: session logout | 0 | 18 | 3 |
active service list | kswsite: service iterator | 0 | 16 | 0 |
active service list | kswslogon: session login | 0 | 6 | 1 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 3,486 | 1,572 |
cache buffers chains | kcbgtcr_2 | 0 | 691 | 692 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 417 | 1,048 |
cache buffers chains | kcbrls_1 | 0 | 343 | 1,627 |
cache buffers chains | kcbzwb | 0 | 177 | 110 |
cache buffers chains | kcbchg1: kslbegin: bufs not pinned | 0 | 113 | 107 |
cache buffers chains | kcbgtcr: fast path | 0 | 100 | 34 |
cache buffers chains | kcbgcur_2 | 0 | 65 | 27 |
cache buffers chains | kcbget: pin buffer | 0 | 17 | 34 |
cache buffers chains | kcbrls_2 | 0 | 17 | 107 |
cache buffers chains | kcbchg1: kslbegin: call CR func | 0 | 15 | 36 |
cache buffers chains | kclcls_3 | 0 | 11 | 18 |
cache buffers chains | kclbla | 0 | 8 | 0 |
cache buffers chains | kcllkopesc | 0 | 8 | 0 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 5 | 0 |
cache buffers chains | kclpdcl | 0 | 3 | 0 |
cache buffers chains | kcbso1: set no access | 0 | 2 | 1 |
cache buffers chains | kcbsod1 | 0 | 2 | 7 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 2 | 0 |
cache buffers chains | kcl_fairness | 0 | 2 | 0 |
cache buffers chains | kcbbxsv | 0 | 1 | 1 |
cache buffers chains | kcbgcur_1 | 0 | 1 | 1 |
cache buffers chains | kcbget: exchange rls | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 1 | 0 |
cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 1 | 0 |
cache buffers chains | kclwcrs | 0 | 1 | 4 |
cache buffers chains | kclwlr | 0 | 1 | 1 |
cache buffers lru chain | kcbzgws | 0 | 8 | 0 |
cache buffers lru chain | kcbo_link_q | 0 | 1 | 1 |
cache buffers lru chain | kcbw_activate_granule | 0 | 1 | 0 |
call allocation | ksuxds | 0 | 4 | 4 |
checkpoint queue latch | kcbkubc_4 | 0 | 1 | 0 |
enqueue hash chains | ksqexpandres | 0 | 60 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 2 | 13 |
enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 1 | 1 |
enqueue hash chains | ksqcmi: if lk mode requested | 0 | 1 | 0 |
enqueue hash chains | ksqrcl | 0 | 1 | 48 |
enqueues | ksqgel: create enqueue | 0 | 3 | 3 |
enqueues | ksqdel | 0 | 2 | 2 |
gc element | kclnfndnewm | 0 | 45 | 53 |
gc element | kclchkping | 0 | 35 | 0 |
gc element | kclbla | 0 | 27 | 3 |
gc element | kclollnumiter | 0 | 27 | 0 |
gc element | kclevict | 0 | 26 | 0 |
gc element | kclfwrite1 | 0 | 14 | 7 |
gc element | kclnfndnew | 0 | 11 | 1 |
gc element | kclnfndx | 0 | 8 | 6 |
gc element | kcl_fairness | 0 | 6 | 3 |
gc element | kclnfnds | 0 | 6 | 2 |
gc element | kcl_get_le_latch | 0 | 4 | 0 |
gc element | kclrwrite | 0 | 4 | 16 |
gc element | kclwrt | 0 | 3 | 2 |
gc element | kclpdcl | 0 | 2 | 15 |
gc element | kclulb | 0 | 2 | 21 |
gc element | kclclose_1 | 0 | 1 | 0 |
gc element | kclcqchk_1 | 0 | 1 | 0 |
gc element | kclhngcbk1_1 | 0 | 1 | 0 |
gc element | kclnfnd | 0 | 1 | 7 |
gc element | kclpdc_21 | 0 | 1 | 2 |
gcs opaque info freelist | kjbrinfofree free opaque info | 0 | 12 | 0 |
gcs opaque info freelist | kjbrcvt save opaque info | 0 | 4 | 16 |
gcs remastering latch | kjfcdrmrfg beginning | 0 | 4 | 0 |
gcs resource hash | kclrwrite | 0 | 6 | 6 |
gcs resource hash | kjbmpwrite | 0 | 6 | 1 |
gcs resource hash | kjbcropen | 0 | 5 | 0 |
gcs resource hash | kjbopen:affinity | 0 | 4 | 0 |
gcs resource hash | kjbcropen:affinity | 0 | 3 | 0 |
gcs resource hash | kjblocalobj_nolock | 0 | 3 | 1 |
gcs resource hash | kjbrdrmcvtq_98 | 0 | 3 | 15 |
gcs resource hash | kclgrantlk_1 | 0 | 2 | 0 |
gcs resource hash | kjbmpopen | 0 | 2 | 0 |
gcs resource hash | kjbassume | 0 | 1 | 0 |
gcs resource hash | kjbconvert | 0 | 1 | 3 |
gcs resource hash | kjbcrcomplete | 0 | 1 | 1 |
gcs resource hash | kjbmdowncvt | 0 | 1 | 0 |
gcs resource hash | kjbmpcreatepi | 0 | 1 | 1 |
gcs resource hash | kjbrwrdone reget | 0 | 1 | 0 |
ges enqueue table freelist | kjlfr: remove lock from parent object | 0 | 3 | 1 |
ges enqueue table freelist | kjlalc: lock allocation | 0 | 2 | 4 |
ges group table | kjgagll: move a lock from process lock list to group lock list | 0 | 21 | 23 |
ges group table | kjgdgll: move a lock from group lock list to process lock list | 0 | 2 | 0 |
ges process hash list | kjakiqa: set inquiry response | 0 | 96 | 44 |
ges process hash list | 32 | 0 | 44 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 2,750 | 7 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 189 | 32 |
ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 110 | 6 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 76 | 370 |
ges resource hash list | kjrref: find matched resource | 0 | 10 | 2,696 |
ges resource hash list | kjucvl: lock convert request | 0 | 4 | 30 |
ges resource hash list | kjcvscn: remove from scan queue | 0 | 3 | 0 |
ges resource table freelist | kjruch: cached obj cleanup | 0 | 7 | 0 |
ges resource table freelist | kjrm2c: move resource to cache | 0 | 4 | 15 |
ges resource table freelist | kjchc: clean resource cache | 0 | 3 | 0 |
ges resource table freelist | kjrchc: cached obj cleanup | 0 | 1 | 0 |
lgwr LWN SCN | kcs023 | 0 | 3 | 0 |
messages | ksarcv | 0 | 2 | 0 |
messages | ksarcv: after wait | 0 | 2 | 2 |
mostly latch-free SCN | kcs024 | 0 | 2 | 0 |
multiblock read objects | kcbzibmlt | 0 | 3 | 1 |
object queue header operation | kclobj_5 | 0 | 127 | 100 |
object queue header operation | kclobj_1 | 0 | 53 | 54 |
object queue header operation | kclobj_2 | 0 | 42 | 37 |
object queue header operation | kcbo_link_q:reget | 0 | 5 | 0 |
object queue header operation | kcbo_link_q | 0 | 2 | 13 |
object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 2 |
object queue header operation | kcbo_unlink_q | 0 | 1 | 16 |
object queue header operation | kcbo_write_q | 0 | 1 | 0 |
object queue header operation | kcldbufs | 0 | 1 | 1 |
parameter table management | kspcpy | 0 | 1 | 0 |
post/wait queue | kslpstevent:get | 0 | 1 | 1 |
process allocation | ksucrp:1 | 0 | 45 | 0 |
process allocation | ksuapc | 0 | 3 | 48 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 12 | 0 |
qmn task queue latch | kwqmngettsk: get task | 0 | 4 | 18 |
qmn task queue latch | kwqmndntsk: task done but retry | 0 | 2 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 10 | 0 |
resmgr:active threads | kgsksimsetup1 | 0 | 28 | 0 |
resmgr:resource group CPU method | kgkprraddtorl | 0 | 72 | 49 |
resmgr:resource group CPU method | kgkprrpicknext | 0 | 12 | 35 |
resmgr:schema config | kgskgmaxdop1 | 0 | 132 | 10 |
resmgr:schema config | kgskgasi1 | 0 | 76 | 198 |
resmgr:schema config | kgskmetricupd | 0 | 1 | 0 |
row cache objects | kqreqd: reget | 0 | 526 | 5 |
row cache objects | kqrpre: find obj | 0 | 183 | 730 |
row cache objects | kqrso | 0 | 69 | 38 |
row cache objects | kqreqd | 0 | 27 | 26 |
row cache objects | kqrbgl | 0 | 14 | 1 |
row cache objects | kqrbtm: pop parent | 0 | 10 | 4 |
row cache objects | kqrigt | 0 | 2 | 23 |
row cache objects | kqrigt2 | 0 | 1 | 1 |
row cache objects | kqrpre: init complete | 0 | 1 | 1 |
row cache objects | ksucallcbksafely: kqrhngc | 0 | 1 | 0 |
session allocation | kspallmod | 0 | 7 | 0 |
session idle bit | ksupuc: clear busy | 0 | 4 | 4 |
session idle bit | ksupuc: set busy | 0 | 4 | 5 |
session idle bit | ksuxds | 0 | 1 | 0 |
shared pool | kghalo | 0 | 1,332 | 709 |
shared pool | kghupr1 | 0 | 262 | 605 |
shared pool | kghalp | 0 | 171 | 496 |
shared pool | kgh_heap_sizes | 0 | 92 | 34 |
shared pool | kghasp | 0 | 1 | 7 |
shared pool | kghfre | 0 | 1 | 9 |
shared pool | kghfrunp: alloc: wait | 0 | 1 | 0 |
shared pool | kghfrunp: clatch: nowait | 0 | 1 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 28 | 3 |
shared pool simulator | kglsim_scan_lru: scan | 0 | 2 | 14 |
shared pool simulator | kglsim_upd_newhp | 0 | 1 | 10 |
simulator hash latch | kcbsacc: lookup dba | 0 | 7 | 7 |
simulator lru latch | kcbs_shrink_pool | 0 | 1 | 0 |
transaction allocation | ktcxbr | 0 | 320 | 320 |
undo global data | ktudba: KSLBEGIN | 0 | 1 | 1 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kkslce [KKSCHLPIN2] | 2,931,077 | 64,182 |
Library Cache | kglhdgn1 62 | 505,569 | 13,941 |
Library Cache | kglhdgh1 64 | 318,882 | 19,709 |
Library Cache | kgllkal1 80 | 140,557 | 20,907 |
Library Cache | kglllal3 111 | 117,632 | 109,025 |
Library Cache | kgllkdl1 85 | 89,717 | 3,008 |
Library Cache | kglpnal2 91 | 81,610 | 34,540 |
Library Cache | kgldtin1 42 | 34,939 | 8,006 |
Library Cache | kglpin1 4 | 32,393 | 4,945 |
Library Cache | kglget1 1 | 31,333 | 1,627 |
Library Cache | kglobpn1 71 | 21,409 | 7,966 |
Library Cache | kglpnal1 90 | 18,390 | 2,173 |
Library Cache | kgllldl2 112 | 10,855 | 5,173 |
Library Cache | kglllal1 109 | 9,765 | 1,353 |
Library Cache | kglpndl1 95 | 5,868 | 2,789 |
Library Cache | kglhdgn2 106 | 5,404 | 2,128 |
Library Cache | kglrfcl1 79 | 1,837 | 70 |
Library Cache | kglget2 2 | 501 | 32 |
Library Cache | kglReleaseHandleReference 125 | 165 | 2 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 102 | 2 |
Library Cache | kgllkc1 57 | 86 | 83 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 34 | 0 |
Library Cache | kglnti1 46 | 9 | 0 |
Library Cache | kglini1 32 | 3 | 0 |
Library Cache | kglobld1 75 | 3 | 1 |
Library Cache | kglUpgradeLock 119 | 1 | 0 |
Library Cache | kglati1 45 | 1 | 0 |
Cursor Stat | kkocsStoreBindAwareStats [KKSSTALOC8] | 1 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
ECS | coredata | EXCHANGE | TABLE | 65,064,816 | 17.34 | |
ECS | USERS | ORGANIZATIONUNITPROFILE | TABLE | 46,663,680 | 12.43 | |
ECS | core_INDEX | IDX_OUNESTLOOP | INDEX | 26,136,672 | 6.96 | |
ECS | coredata | CHANGE | TABLE | 21,737,840 | 5.79 | |
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 20,966,528 | 5.59 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
ECS | coredata | PASSENGERINFO | TABLE | 16,389,208 | 50.64 | |
ECS | coredata | REFUNDORDER | TABLE | 10,844,956 | 33.51 | |
ECS | coredata | ORDERS | SYS_P2048 | TABLE PARTITION | 187,427 | 0.58 |
ECS | coredata | ORDERS | SYS_P2489 | TABLE PARTITION | 171,563 | 0.53 |
ECS | coredata | ORDERS | SYS_P2448 | TABLE PARTITION | 138,439 | 0.43 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
ECS | coredata | PASSENGERINFO | TABLE | 132,019 | 28.76 | |
ECS | coredata | REFUNDORDER | TABLE | 92,466 | 20.14 | |
ECS | coredata | ORDERS | SYS_P2048 | TABLE PARTITION | 33,233 | 7.24 |
ECS | USERS | FLIGHTPRICEDOMESTIC | TABLE | 11,005 | 2.40 | |
ECS | coredata | PSGTICKET | TABLE | 4,654 | 1.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
ECS | coredata | PASSENGERINFO | TABLE | 132,019 | 28.76 | |
ECS | coredata | REFUNDORDER | TABLE | 92,466 | 20.14 | |
ECS | coredata | ORDERS | SYS_P2048 | TABLE PARTITION | 33,233 | 7.24 |
ECS | USERS | FLIGHTPRICEDOMESTIC | TABLE | 11,005 | 2.40 | |
ECS | coredata | PSGTICKET | TABLE | 4,654 | 1.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
---|---|---|---|---|---|---|
ECS | coredata | PASSENGERINFO | TABLE | 16,389,203 | 51.10 | |
ECS | coredata | REFUNDORDER | TABLE | 10,838,380 | 33.79 | |
ECS | coredata | ORDERS | SYS_P2489 | TABLE PARTITION | 171,410 | 0.53 |
ECS | coredata | ORDERS | SYS_P2448 | TABLE PARTITION | 138,024 | 0.43 |
ECS | coredata | ORDERS | SYS_P2048 | TABLE PARTITION | 126,046 | 0.39 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
ECS | coredata | PAYBILL | TABLE | 1,979 | 2.91 | |
ECS | coredata | PASSENGERINFO | TABLE | 1,879 | 2.76 | |
ECS | core_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 1,835 | 2.70 |
ECS | core_INDEX | IDX_BOOKUSER | SYS_P2548 | INDEX PARTITION | 1,272 | 1.87 |
ECS | core_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 1,035 | 1.52 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
ECS | core_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 1,774 | 4.18 |
ECS | coredata | PASSENGERINFO | TABLE | 1,735 | 4.09 | |
ECS | coredata | PAYBILL | TABLE | 1,725 | 4.06 | |
ECS | core_INDEX | IDX_BOOKUSER | SYS_P2548 | INDEX PARTITION | 1,198 | 2.82 |
ECS | core_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 1,009 | 2.38 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_87227165_25433 | TABLE PARTITION | 933 | 95.20 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
ECS | core_INDEX | PK_ORGANIZATIONUNITPROFILE | INDEX | 4,451 | 75.07 | |
ECS | coredata | PASSENGERINFO | TABLE | 91 | 1.53 | |
ECS | coredata | REFUNDORDER | TABLE | 35 | 0.59 | |
PAO | TEMP | QUEST_ADV_SEGSTAT_WIDE_PK | INDEX | 4 | 0.07 | |
ECS | coredata | ORDERS | SYS_P2048 | TABLE PARTITION | 2 | 0.03 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 167,456 | 29.12 |
ECS | core_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 42,096 | 7.32 |
ECS | core_INDEX | IDX_CREATEDATE_STATUS | SYS_P2548 | INDEX PARTITION | 36,032 | 6.26 |
ECS | core_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 24,208 | 4.21 |
ECS | USERS | TRACEOFPROCESS | SYS_P2528 | TABLE PARTITION | 23,872 | 4.15 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 338 | 37.06 |
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 259 | 28.40 |
ECS | core_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 80 | 8.77 |
ECS | USERS | TICKETNOSECTION | TABLE | 30 | 3.29 | |
ECS | core_INDEX | IDX_CREATEDATE_STATUS | SYS_P2548 | INDEX PARTITION | 27 | 2.96 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 20 | 83.33 |
ECS | core_INDEX | SYS_C0049434 | INDEX | 2 | 8.33 | |
ECS | core_INDEX | IDX_SEARCHBILL | INDEX | 1 | 4.17 | |
ECS | core_INDEX | WEBTERMCOMMANDHISTORY_PK | INDEX | 1 | 4.17 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 661 | 43.43 |
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 303 | 19.91 |
SYS | SYSTEM | UNDO$ | TABLE | 275 | 18.07 | |
ECS | core_INDEX | IDX_CREATEDATE_STATUS | SYS_P2548 | INDEX PARTITION | 80 | 5.26 |
ECS | core_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 57 | 3.75 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
ECS | coredata | CHANGE | TABLE | 15,920 | 70.76 | |
ECS | coredata | EXCHANGE | TABLE | 1,835 | 8.16 | |
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 1,183 | 5.26 |
ECS | core_INDEX | PK_ORDERS | INDEX | 1,153 | 5.12 | |
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 659 | 2.93 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 29,849 | 19.99 |
ECS | core_INDEX | PK_ORDERS | INDEX | 10,630 | 7.12 | |
ECS | USERS | PNRLIST | TABLE | 9,018 | 6.04 | |
ECS | core_INDEX | IDX_CREATEDATE_STATUS | SYS_P2548 | INDEX PARTITION | 6,752 | 4.52 |
ECS | core_INDEX | PK_FLIGHTPRICEDOMESTIC | INDEX | 5,683 | 3.81 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
ECS | coredata | ORDERS | SYS_P2548 | TABLE PARTITION | 19,176 | 8.51 |
ECS | coredata | ORDERS | SYS_P2489 | TABLE PARTITION | 15,252 | 6.77 |
ECS | coredata | CHANGE | TABLE | 13,315 | 5.91 | |
ECS | coredata | ORDERS | SYS_P2448 | TABLE PARTITION | 12,172 | 5.40 |
ECS | core_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 11,362 | 5.04 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 67 | 2.99 | 0 | 0 | 1 | |
dc_files | 672 | 37.50 | 0 | 0 | 0 | |
dc_global_oids | 6,294 | 0.81 | 0 | 0 | 28 | |
dc_histogram_data | 8,388,485 | 0.10 | 0 | 0 | 4,962 | |
dc_histogram_defs | 3,423,644 | 0.33 | 0 | 13 | 3,005 | |
dc_object_grants | 40,708 | 0.01 | 0 | 0 | 29 | |
dc_objects | 5,044,782 | 0.02 | 0 | 26 | 1,804 | |
dc_profiles | 2,753 | 0.36 | 0 | 0 | 3 | |
dc_rollback_segments | 126,524 | 0.18 | 0 | 172 | 1,920 | |
dc_segments | 1,397,573 | 0.13 | 0 | 5 | 928 | |
dc_sequences | 1,568 | 74.74 | 0 | 1,568 | 7 | |
dc_table_scns | 6 | 100.00 | 0 | 0 | 0 | |
dc_tablespaces | 846,585 | 0.00 | 0 | 0 | 13 | |
dc_users | 2,008,919 | 0.00 | 0 | 0 | 45 | |
global database name | 5,657 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 76 | 90.79 | 0 | 12 | 0 | |
qmtmrctn_cache_entries | 1 | 100.00 | 0 | 0 | 0 | |
qmtmrctq_cache_entries | 1 | 100.00 | 0 | 0 | 0 | |
sch_lj_oids | 2 | 50.00 | 0 | 0 | 4 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 2 | 2 | 0 |
dc_files | 252 | 0 | 294 |
dc_global_oids | 51 | 0 | 63 |
dc_histogram_defs | 11,430 | 598 | 11,037 |
dc_objects | 1,162 | 8 | 946 |
dc_profiles | 10 | 0 | 12 |
dc_rollback_segments | 411 | 225 | 0 |
dc_segments | 1,920 | 5 | 1,655 |
dc_sequences | 3,133 | 1,122 | 48 |
dc_table_scns | 6 | 0 | 0 |
dc_tablespaces | 6 | 0 | 6 |
dc_users | 27 | 0 | 47 |
outstanding_alerts | 134 | 56 | 7 |
qmtmrctn_cache_entries | 1 | 0 | 1 |
qmtmrctq_cache_entries | 1 | 0 | 1 |
sch_lj_oids | 1 | 0 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 2,728 | 0.95 | 0 | 0 | 0 | |
APP CONTEXT | 1 | 100.00 | 2 | 50.00 | 0 | 0 |
BODY | 10,826 | 1.25 | 98,433 | 0.16 | 13 | 0 |
CLUSTER | 593 | 1.52 | 596 | 1.51 | 0 | 0 |
DBLINK | 2,731 | 0.00 | 0 | 0 | 0 | |
DIRECTORY | 46 | 6.52 | 66 | 12.12 | 2 | 0 |
EDITION | 1,416 | 0.00 | 2,814 | 0.00 | 0 | 0 |
HINTSET OBJECT | 39 | 17.95 | 39 | 35.90 | 0 | 0 |
INDEX | 140,747 | 0.02 | 140,747 | 0.55 | 6 | 0 |
OBJECT ID | 8 | 100.00 | 0 | 0 | 0 | |
QUEUE | 956 | 1.46 | 1,115 | 2.69 | 4 | 0 |
RULESET | 0 | 12 | 8.33 | 1 | 0 | |
SCHEMA | 2,945 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 564,328 | 28.14 | 2,435,763 | 22.70 | 22,834 | 618 |
SQL AREA BUILD | 183,005 | 94.75 | 0 | 0 | 0 | |
SQL AREA STATS | 175,379 | 95.20 | 175,379 | 95.20 | 0 | 0 |
SUBSCRIPTION | 13 | 92.31 | 13 | 92.31 | 0 | 0 |
TABLE/PROCEDURE | 396,401 | 0.18 | 1,430,171 | 0.70 | 5,663 | 0 |
TRANSFORMATION | 359 | 0.00 | 359 | 0.00 | 0 | 0 |
TRIGGER | 655 | 2.44 | 66,313 | 0.03 | 2 | 0 |
XML SCHEMA | 5 | 0.00 | 9 | 0.00 | 0 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
ACCOUNT_STATUS | 2,728 | 0 | 0 | 0 | 0 |
BODY | 0 | 96,904 | 96,904 | 0 | 0 |
CLUSTER | 596 | 596 | 596 | 0 | 0 |
DBLINK | 2,731 | 0 | 0 | 0 | 0 |
DIRECTORY | 26 | 52 | 52 | 0 | 0 |
EDITION | 1,416 | 1,417 | 1,417 | 0 | 0 |
HINTSET OBJECT | 39 | 39 | 39 | 0 | 0 |
INDEX | 140,747 | 140,747 | 140,747 | 0 | 0 |
QUEUE | 463 | 1,115 | 1,115 | 0 | 0 |
RULESET | 0 | 12 | 12 | 0 | 0 |
SCHEMA | 1,406 | 0 | 0 | 0 | 0 |
SUBSCRIPTION | 0 | 13 | 13 | 0 | 0 |
TABLE/PROCEDURE | 525,359 | 687,431 | 687,431 | 0 | 0 |
TRANSFORMATION | 359 | 359 | 359 | 0 | 0 |
TRIGGER | 0 | 66,313 | 66,313 | 0 | 0 |
XML SCHEMA | 5 | 5 | 5 | 0 | 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 | 14,784.00 | 14,784.00 | 12,928.00 | 16,576.00 | 6 | SHR/DEF |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 6,144.00 | 6,144.00 | 6,144.00 | 6,144.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 24,576.00 | 24,576.00 | 24,576.00 | 24,576.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
large pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
shared pool | 9,472.00 | 9,472.00 | 7,680.00 | 11,328.00 | 6 | GRO/DEF |
streams pool | 64.00 | 64.00 | 64.00 | 128.00 | 0 | SHR/DEF |
Component | Min Size (Mb) | Max Size (Mb) | Avg Size (Mb) | Re- Sizes | Grows | Shrinks |
---|---|---|---|---|---|---|
DEFAULT buffer cache | 14,784.00 | 14,784.00 | 14,784.00 | 5 | 0 | 5 |
shared pool | 9,472.00 | 9,472.00 | 9,472.00 | 5 | 5 | 0 |
Start | Ela (s) | Component | Oper Typ/Mod | Init Size (M) | Delta | Target Delta | Final (M) | Sta |
---|---|---|---|---|---|---|---|---|
08/07 22:54:07 | 60 | bufcache | SHR/DEF | 14,784 | 0 | -128 | 14,784 | CAN |
08/07 22:54:07 | 60 | shared | GRO/DEF | 9,472 | 0 | 128 | 9,472 | CAN |
08/07 22:43:34 | 60 | bufcache | SHR/DEF | 14,784 | 0 | -128 | 14,784 | CAN |
08/07 22:43:34 | 60 | shared | GRO/DEF | 9,472 | 0 | 128 | 9,472 | CAN |
08/07 22:23:17 | 60 | bufcache | SHR/DEF | 14,784 | 0 | -128 | 14,784 | CAN |
08/07 22:23:17 | 60 | shared | GRO/DEF | 9,472 | 0 | 128 | 9,472 | CAN |
08/07 22:14:15 | 60 | bufcache | SHR/DEF | 14,784 | 0 | -128 | 14,784 | CAN |
08/07 22:14:15 | 60 | shared | GRO/DEF | 9,472 | 0 | 128 | 9,472 | CAN |
08/07 22:05:13 | 60 | bufcache | SHR/DEF | 14,784 | 0 | -128 | 14,784 | CAN |
08/07 22:05:13 | 60 | shared | GRO/DEF | 9,472 | 0 | 128 | 9,472 | CAN |
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 | 2,265.73 | 4.49 | 4.37 | 44 | 51 | 505 | 505 | |
B | Freeable | 356.13 | 0.00 | 0.84 | 0.50 | 5 | 422 | 422 | |
B | PL/SQL | 90.83 | 56.77 | 0.18 | 0.18 | 2 | 3 | 504 | 502 |
B | SQL | 43.80 | 20.67 | 0.09 | 0.68 | 15 | 204 | 471 | 461 |
E | Other | 3,410.78 | 4.06 | 3.68 | 44 | 51 | 841 | 841 | |
E | Freeable | 528.50 | 0.00 | 0.79 | 0.47 | 5 | 666 | 666 | |
E | PL/SQL | 131.84 | 95.87 | 0.16 | 0.16 | 2 | 3 | 840 | 839 |
E | SQL | 52.36 | 16.76 | 0.06 | 0.28 | 8 | 204 | 808 | 800 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 15,502,147,584 | |
Fixed Size | 2,231,608 | |
Redo Buffers | 16,932,864 | |
Variable Size | 10,133,439,176 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 64.00 | 64.00 | 0.00 |
large | PX msg pool | 7.81 | 7.81 | 0.00 |
large | free memory | 55.28 | 55.28 | 0.00 |
shared | KGH: NO ACCESS | 126.88 | 126.88 | 0.00 |
shared | KGLH0 | 788.54 | 762.74 | -3.27 |
shared | KGLHD | 2,311.09 | 2,313.07 | 0.09 |
shared | SQLA | 578.15 | 590.38 | 2.11 |
shared | free memory | 4,215.12 | 4,209.53 | -0.13 |
shared | gcs resources | 270.51 | 270.51 | 0.00 |
shared | gcs shadows | 199.32 | 199.32 | 0.00 |
shared | kglsim object batch | 150.59 | 150.59 | 0.00 |
streams | KGH: NO ACCESS | 63.99 | 63.99 | 0.00 |
streams | free memory | 64.01 | 64.01 | 0.00 |
buffer_cache | 14,784.00 | 14,784.00 | 0.00 | |
fixed_sga | 2.13 | 2.13 | 0.00 | |
log_buffer | 16.15 | 16.15 | 0.00 |
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
QMON Slaves | 0517 04:51:59 | 0.28 | 0.15 | 0.00 |
QMON Coordinator | 0517 04:51:59 | 0.21 | 0.00 | 0.00 |
Rule | Evals | No-SQL Eval% | SQL Execs | CPU(s) | Ela(s) | Eval /Sec | SQL per Eval | Ela(s) per Eval | CPU(s) per Eval | Reloads |
---|---|---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE_R | 12 | 0.00 | 0 | 0.10 | 2.12 | 0.00 | 0.00 | 0.18 | 0.01 | 1 |
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
SYS.ALERT_QUE(12343) | 12 | 0 | 100.00 | 0.00 | 3.78 | 0.00 | 0.00 | 57.09 |
SYS.AQ$_ALERT_QT_E(12342) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_NOTIFY_Q(49961) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(49631) | 37 | 37 | 0.00 | 0.00 | 0.24 | 0.68 | 0.00 | 0.00 |
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
SYS.ALERT_QUE(12343) | 0.00 | 0.00 | 0.32 | |
SYS.AQ$_ALERT_QT_E(12342) | 0.00 | 0.00 | ||
SYSMAN.MGMT_NOTIFY_Q(49961) | 0.00 | 0.00 | ||
SYSMAN.MGMT_TASK_Q(49631) | 0.01 | 0.01 | 0.01 | 0.02 |
Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
---|---|---|---|---|---|---|
core_DB1_3938_coredb1(22)/SYS.ALERT_QUE | 12 | 0 | 0 | 0.00 | 0.00 | 0.00 |
core_DB2_3938_coredb2(42)/SYS.ALERT_QUE | 12 | 0 | 0 | 0.00 | 0.00 | 0.00 |
HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
3,608 | 0.00 | 100.00 | 0.00 | 0.00 |
Name | Avg Conns | Total Disp Time (s) | %Busy | %Idle | Total Queued | Total Queue Wait (s) | Avg Queue Wait (ms) |
---|---|---|---|---|---|---|---|
D000 | 0.00 | 3,608 | 0.05 | 99.95 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.05 | 99.95 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.05 | 99.95 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.05 | 99.95 | 0 | 0 | |
Sum | 0.00 | 0 | 0 | ||||
Avg | 0.00 | 0.05 | 99.95 | 0 | 0 | ||
Std | 0.00 | 0.00 | 0.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /oracle/app/oracle/admin/coredb/adump | |
audit_trail | DB | |
cluster_database | TRUE | |
compatible | 11.2.0.0.0 | |
control_files | +DATADG/coredb/controlfile/current.256.729362595, +FLASHDG/coredb/controlfile/current.256.729362595 | |
db_block_size | 8192 | |
db_create_file_dest | +DATADG | |
db_domain | ||
db_name | coredb | |
db_recovery_file_dest | +FLASHDG | |
db_recovery_file_dest_size | 1887436800000 | |
diagnostic_dest | /oracle/app/oracle | |
dispatchers | (PROTOCOL=TCP) (SERVICE=coredbXDB) | |
instance_number | 2 | |
job_queue_processes | 1000 | |
local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.10.32)(PORT=1521)))) | |
log_archive_format | %t_%s_%r.dbf | |
max_dump_file_size | 20480 | |
memory_max_target | 34359738368 | |
memory_target | 0 | |
open_cursors | 3000 | |
pga_aggregate_target | 6442450944 | |
processes | 2000 | |
remote_listener | core-db-cluster-scan:1521 | |
remote_login_passwordfile | EXCLUSIVE | |
resource_limit | TRUE | |
sec_case_sensitive_logon | FALSE | |
service_names | coredb. | |
sessions | 3024 | |
sga_max_size | 25769803776 | |
sga_target | 25769803776 | |
thread | 2 | |
undo_retention | 10800 | |
undo_tablespace | UNDOTBS2 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
control_files | +DATADG/coredb/controlfile/current.256.729362595 | |
control_files | +FLASHDG/coredb/controlfile/current.256.729362595 |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 59,043 | 16.36 | 0.35 |
acks for commit broadcast(logical) | 68,853 | 19.08 | 0.41 |
broadcast msgs on commit(actual) | 58,637 | 16.25 | 0.35 |
broadcast msgs on commit(logical) | 102,997 | 28.54 | 0.62 |
broadcast msgs on commit(wasted) | 13,914 | 3.86 | 0.08 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
flow control messages received | 0 | 0.00 | 0.00 |
flow control messages sent | 3 | 0.00 | 0.00 |
gcs apply delta | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 284,327 | 78.78 | 1.71 |
gcs ast xid | 35 | 0.01 | 0.00 |
gcs blocked converts | 81,808 | 22.67 | 0.49 |
gcs blocked cr converts | 114,788 | 31.80 | 0.69 |
gcs compatible basts | 892 | 0.25 | 0.01 |
gcs compatible cr basts (global) | 25,556 | 7.08 | 0.15 |
gcs compatible cr basts (local) | 317,955 | 88.10 | 1.91 |
gcs cr basts to PIs | 0 | 0.00 | 0.00 |
gcs cr serve without current lock | 0 | 0.00 | 0.00 |
gcs dbwr flush pi msgs | 14,905 | 4.13 | 0.09 |
gcs dbwr write request msgs | 11,755 | 3.26 | 0.07 |
gcs delta msgs sent | 0 | 0.00 | 0.00 |
gcs delta push aborted by cancel | 0 | 0.00 | 0.00 |
gcs delta push aborted by remastering | 0 | 0.00 | 0.00 |
gcs delta push cancelled | 0 | 0.00 | 0.00 |
gcs delta push cancelled at master | 0 | 0.00 | 0.00 |
gcs delta push cancelled by close | 0 | 0.00 | 0.00 |
gcs delta push cancelled by consign | 0 | 0.00 | 0.00 |
gcs delta push cancelled by cvt ping | 0 | 0.00 | 0.00 |
gcs delta push cancelled by dwncvt | 0 | 0.00 | 0.00 |
gcs delta push create pi | 0 | 0.00 | 0.00 |
gcs delta update master msgs sent | 0 | 0.00 | 0.00 |
gcs delta wait aborted by remastering | 0 | 0.00 | 0.00 |
gcs delta wait cancelled | 0 | 0.00 | 0.00 |
gcs error msgs | 0 | 0.00 | 0.00 |
gcs force cr block only | 117 | 0.03 | 0.00 |
gcs force cr grant | 138 | 0.04 | 0.00 |
gcs force cr no current | 0 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 11,120 | 3.08 | 0.07 |
gcs immediate (null) converts | 73,436 | 20.35 | 0.44 |
gcs immediate cr (compatible) converts | 1,148 | 0.32 | 0.01 |
gcs immediate cr (null) converts | 810,816 | 224.66 | 4.87 |
gcs indirect ast | 137,881 | 38.20 | 0.83 |
gcs indirect bidless ast | 117 | 0.03 | 0.00 |
gcs indirect fg ast | 137,589 | 38.12 | 0.83 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 5,544 | 1.54 | 0.03 |
gcs msgs process time(ms) | 99,023 | 27.44 | 0.59 |
gcs msgs received | 2,637,830 | 730.87 | 15.84 |
gcs new served by master | 1,210 | 0.34 | 0.01 |
gcs out-of-order msgs | 5 | 0.00 | 0.00 |
gcs pings refused | 106 | 0.03 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs push delta | 0 | 0.00 | 0.00 |
gcs queued converts | 38 | 0.01 | 0.00 |
gcs reader bypass N->Xw ping local | 0 | 0.00 | 0.00 |
gcs reader bypass N->Xw ping remote | 0 | 0.00 | 0.00 |
gcs reader bypass grant X on assume | 0 | 0.00 | 0.00 |
gcs reader bypass grant ast | 0 | 0.00 | 0.00 |
gcs reader bypass grant fg ast | 0 | 0.00 | 0.00 |
gcs reader bypass grant immediate | 0 | 0.00 | 0.00 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 30 | 0.01 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 2 | 0.00 | 0.00 |
gcs share recovery bast | 0 | 0.00 | 0.00 |
gcs side channel msgs actual | 20,997 | 5.82 | 0.13 |
gcs side channel msgs logical | 446,656 | 123.76 | 2.68 |
gcs stale cr | 40,768 | 11.30 | 0.24 |
gcs undo cr | 12,438 | 3.45 | 0.07 |
gcs write notification msgs | 789 | 0.22 | 0.00 |
gcs writes refused | 16 | 0.00 | 0.00 |
ges msgs process time(ms) | 8,891 | 2.46 | 0.05 |
ges msgs received | 139,889 | 38.76 | 0.84 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 133 | 0.04 | 0.00 |
global posts queued | 49 | 0.01 | 0.00 |
global posts requested | 49 | 0.01 | 0.00 |
global posts sent | 49 | 0.01 | 0.00 |
implicit batch messages received | 96,702 | 26.79 | 0.58 |
implicit batch messages sent | 34,940 | 9.68 | 0.21 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 2,919 | 0.81 | 0.02 |
messages queue sent actual | 241,957 | 67.04 | 1.45 |
messages queue sent logical | 119,596 | 33.14 | 0.72 |
messages received actual | 1,150,101 | 318.66 | 6.90 |
messages received logical | 2,777,728 | 769.64 | 16.68 |
messages sent directly | 530,556 | 147.00 | 3.19 |
messages sent indirectly | 277,580 | 76.91 | 1.67 |
messages sent not implicit batched | 156 | 0.04 | 0.00 |
messages sent pbatched | 953,433 | 264.17 | 5.72 |
msgs causing lmd to send msgs | 41,137 | 11.40 | 0.25 |
msgs causing lms(s) to send msgs | 126,525 | 35.06 | 0.76 |
msgs received queue time (ms) | 980,888 | 271.78 | 5.89 |
msgs received queued | 2,777,652 | 769.61 | 16.68 |
msgs sent queue time (ms) | 2,061,181 | 571.10 | 12.37 |
msgs sent queue time on ksxp (ms) | 16,961,834 | 4,699.68 | 101.84 |
msgs sent queued | 320,692 | 88.86 | 1.93 |
msgs sent queued on ksxp | 887,713 | 245.96 | 5.33 |
number of broadcasted resources | 0 | 0.00 | 0.00 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 236,414 | 65.50 | 1.42 |
process batch messages sent | 255,859 | 70.89 | 1.54 |
0 | 0.00 | 0.00 |
Statistic | Total |
---|---|
CR Block Requests | 146,375 |
CURRENT Block Requests | 60,092 |
Data Block Requests | 146,375 |
Undo Block Requests | 1,806 |
TX Block Requests | 24,853 |
Current Results | 145,607 |
Private results | 3,117 |
Zero Results | 16,919 |
Disk Read Results | 40,784 |
Fail Results | 2 |
Fairness Down Converts | 49,325 |
Fairness Clears | 9,961 |
Free GC Elements | 0 |
Flushes | 20,163 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 32,556,874 |
Light Works | 2,769 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 436 | 16.28 | 50.92 | 28.21 | 3.44 | 1.15 |
Flushes | 1,495 | 16.12 | 67.56 | 14.92 | 1.40 | 0.00 |
Writes | 18,017 | 0.02 | 68.92 | 27.09 | 3.19 | 0.78 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 133,745 | 85.42 | 14.42 | 0.16 | 224,024 | 98.82 | 0.98 | 0.20 |
1 | undo header | 11,445 | 99.10 | 0.76 | 0.14 | 206 | 94.17 | 4.85 | 0.97 |
1 | undo block | 3,048 | 98.13 | 1.71 | 0.16 | 27 | 100.00 | 0.00 | 0.00 |
1 | Others | 1,042 | 99.52 | 0.19 | 0.29 | 1,081 | 99.44 | 0.46 | 0.09 |
CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
1 | data block | 3.52 | 3.24 | 5.09 | 14.70 | 2.93 | 2.42 | 52.81 | 6.35 |
1 | undo header | 10.04 | 9.90 | 10.74 | 110.05 | 31.76 | 0.63 | 641.93 | 0.89 |
1 | undo block | 0.86 | 0.77 | 6.19 | 1.65 | 29.15 | 29.15 | ||
1 | others | 1.30 | 1.30 | 2.96 | 0.48 | 0.74 | 0.73 | 2.92 | 0.49 |
CR | Current | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
1 | data block | 0 | 114,247 | 100.00 | 0.00 | 221,372 | 100.00 | 0.00 |
1 | undo header | 0 | 11,342 | 100.00 | 0.00 | 194 | 100.00 | 0.00 |
1 | undo block | 0 | 2,991 | 100.00 | 0.00 | 27 | 100.00 | 0.00 |
1 | others | 0 | 1,037 | 100.00 | 0.00 | 1,075 | 100.00 | 0.00 |
CR Avg Time (ms) | Current Avg Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
1 | data block | 3.24 | 3.24 | 2.42 | 2.42 | |||
1 | undo header | 9.90 | 9.90 | 0.63 | 0.63 | |||
1 | undo block | 0.77 | 0.77 | 29.15 | 29.15 | |||
1 | others | 1.30 | 1.30 | 0.73 | 0.73 |
Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
---|---|---|---|---|---|---|
1 | 284 | 14.19 | 224.51 | 284 | 28.13 | 316.91 |
2 | 284 | 0.19 | 0.05 | 284 | 0.17 | 0.05 |
Used By | Send Mbytes/sec | Receive Mbytes/sec |
---|---|---|
Global Cache | 1.20 | 0.67 |
Parallel Query | 0.03 | 0.01 |
DB Locks | 0.10 | 0.21 |
DB Streams | 0.00 | 0.00 |
Other | 0.01 | 0.00 |
Device Name | IP Address | Public | Source | Send Mbytes/sec | Send Errors | Send Dropped | Send Buffer Overrun | Send Carrier Lost | Receive Mbytes/sec | Receive Errors | Receive Dropped | Receive Buffer Overrun | Receive Frame Errors |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
en9 | 169.254.224.51 | NO | 1.60 | 0 | 0 | 0 | 0 | 1.05 | 0 | 0 | 0 | 0 | |
en9 | 169.254.224.51 | NO | 1.60 | 0 | 161,364,648 | 0 | 0 | 1.05 | 0 | 0 | 1,398,030,667 | 4 | |
en9 | 169.254.224.51 | NO | 1.60 | 0 | -161,364,648 | 0 | 0 | 1.05 | 0 | 0 | -1,398,030,667 | -4 | |
en9 | 169.254.224.51 | NO | 1.60 | 0 | 0 | 0 | 0 | 1.05 | 0 | 0 | 0 | 0 |
Name | Total | per Remaster Op | Begin Snap | End Snap |
---|---|---|---|---|
remaster ops | 3 | 1.00 | ||
remastered objects | 3 | 1.00 | ||
replayed locks received | 9 | 3.00 | ||
replayed locks sent | 3,072 | 1,024.00 | ||
resources cleaned | 0 | 0.00 | ||
remaster time (s) | 27.3 | 9.11 | ||
quiesce time (s) | 15.4 | 5.13 | ||
freeze time (s) | 0.8 | 0.26 | ||
cleanup time (s) | 4.2 | 1.39 | ||
replay time (s) | 1.6 | 0.52 | ||
fixwrite time (s) | 1.5 | 0.49 | ||
sync time (s) | 1.5 | 0.51 | ||
affinity objects | 118 | 117 |