DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
COREDB | 87227165 | COREDB1 | 1 | 17-5月 -13 05:05 | 11.2.0.2.0 | YES |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
CORE-DB1 | AIX-Based Systems (64-bit) | 24 | 12 | 48.25 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 25476 | 07-8月 -13 22:00:05 | 559 | 6.6 |
End Snap: | 25477 | 07-8月 -13 23:00:14 | 818 | 6.4 |
Elapsed: | 60.15 (mins) | |||
DB Time: | 4,776.06 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 15,616M | 15,552M | Std Block Size: | 8K |
Shared Pool Size: | 8,576M | 8,640M | Log Buffer: | 16,536K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 79.4 | 1.5 | 0.15 | 0.05 |
DB CPU(s): | 2.6 | 0.1 | 0.00 | 0.00 |
Redo size: | 91,898.6 | 1,767.4 | ||
Logical reads: | 162,169.0 | 3,118.9 | ||
Block changes: | 534.3 | 10.3 | ||
Physical reads: | 5,231.3 | 100.6 | ||
Physical writes: | 36.2 | 0.7 | ||
User calls: | 1,536.0 | 29.5 | ||
Parses: | 407.7 | 7.8 | ||
Hard parses: | 50.3 | 1.0 | ||
W/A MB processed: | 14.0 | 0.3 | ||
Logons: | 0.7 | 0.0 | ||
Executes: | 519.0 | 10.0 | ||
Rollbacks: | 35.8 | 0.7 | ||
Transactions: | 52.0 |
Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 98.01 | In-memory Sort %: | 100.00 |
Library Hit %: | 83.71 | Soft Parse %: | 87.67 |
Execute to Parse %: | 21.45 | Latch Hit %: | 99.81 |
Parse CPU to Parse Elapsd %: | 0.29 | % Non-Parse CPU: | 92.91 |
Begin | End | |
---|---|---|
Memory Usage %: | 62.18 | 64.21 |
% SQL with executions>1: | 79.34 | 64.61 |
% Memory for SQL w/exec>1: | 77.89 | 59.05 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
library cache lock | 8,244 | 181,704 | 22041 | 63.41 | Concurrency |
cursor: pin S wait on X | 380 | 61,008 | 160548 | 21.29 | Concurrency |
DB CPU | 9,196 | 3.21 | |||
resmgr:cpu quantum | 64,336 | 4,831 | 75 | 1.69 | Scheduler |
db file sequential read | 744,281 | 4,113 | 6 | 1.44 | User I/O |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
4.47 | 5.38 | 14.7 | 3.9 | 5.3 | 81.4 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
10.9 | 58.9 | 1.6 |
Begin | End | |
---|---|---|
Host Mem (MB): | 49,408.0 | 49,408.0 |
SGA use (MB): | 24,576.0 | 24,576.0 |
PGA use (MB): | 3,003.4 | 3,885.0 |
% Host Mem used for SGA+PGA: | 55.82 | 57.60 |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 176.53 | 3.40 |
Global Cache blocks served: | 103.85 | 2.00 |
GCS/GES messages received: | 461.48 | 8.88 |
GCS/GES messages sent: | 770.38 | 14.82 |
DBWR Fusion writes: | 5.49 | 0.11 |
Estd Interconnect traffic (KB) | 2,483.62 |
Buffer access - local cache %: | 97.90 |
Buffer access - remote cache %: | 0.11 |
Buffer access - disk %: | 1.99 |
Avg global enqueue get time (ms): | 87.1 |
Avg global cache cr block receive time (ms): | 7.0 |
Avg global cache current block receive time (ms): | 3.0 |
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 %: | 13.0 |
Avg global cache cr block flush time (ms): | 4.0 |
Avg global cache current block pin time (ms): | 0.1 |
Avg global cache current block send time (ms): | 0.0 |
Global cache log flushes for current blocks served %: | 0.7 |
Avg global cache current block flush time (ms): | 9.0 |
Avg message sent queue time (ms): | 0.3 |
Avg message sent queue time on ksxp (ms): | 7.1 |
Avg message received queue time (ms): | 0.2 |
Avg GCS message process time (ms): | 0.0 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 40.80 |
% of indirect sent messages: | 58.86 |
% of flow controlled messages: | 0.34 |
Begin | End | |||||
---|---|---|---|---|---|---|
Interface | IP Address | Pub | Source | IP | Pub | Src |
en9 | 169.254.131.102 | N |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
parse time elapsed | 242,484.63 | 84.62 |
hard parse elapsed time | 168,858.99 | 58.93 |
sql execute elapsed time | 49,755.47 | 17.36 |
PL/SQL compilation elapsed time | 12,318.86 | 4.30 |
DB CPU | 9,195.80 | 3.21 |
failed parse elapsed time | 3,802.18 | 1.33 |
hard parse (sharing criteria) elapsed time | 3,372.00 | 1.18 |
hard parse (bind mismatch) elapsed time | 3,335.37 | 1.16 |
sequence load elapsed time | 1,296.52 | 0.45 |
PL/SQL execution elapsed time | 1,048.14 | 0.37 |
connection management call elapsed time | 18.82 | 0.01 |
repeated bind elapsed time | 0.24 | 0.00 |
DB time | 286,563.44 | |
background elapsed time | 2,339.74 | |
background cpu time | 429.05 |
Statistic | Value | End Value |
---|---|---|
NUM_LCPUS | 0 | |
NUM_VCPUS | 0 | |
AVG_BUSY_TIME | 68,006 | |
AVG_IDLE_TIME | 298,157 | |
AVG_IOWAIT_TIME | 19,460 | |
AVG_SYS_TIME | 14,283 | |
AVG_USER_TIME | 53,609 | |
BUSY_TIME | 1,634,985 | |
IDLE_TIME | 7,158,549 | |
IOWAIT_TIME | 469,872 | |
SYS_TIME | 345,557 | |
USER_TIME | 1,289,428 | |
LOAD | 4 | 5 |
OS_CPU_WAIT_TIME | 2,180,600 | |
RSRC_MGR_CPU_WAIT_TIME | 471,533 | |
VM_IN_BYTES | 1,009,983,504 | |
VM_OUT_BYTES | 4,372,574,208 | |
PHYSICAL_MEMORY_BYTES | 51,808,043,008 | |
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.47 | |||||
07-8月 23:00:14 | 5.38 | 18.59 | 14.66 | 3.93 | 81.41 | 5.34 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
Concurrency | 65,593 | 0 | 244,552 | 3728 | 85.34 |
DB CPU | 9,196 | 3.21 | |||
User I/O | 1,148,046 | 0 | 7,202 | 6 | 2.51 |
Scheduler | 64,336 | 0 | 4,831 | 75 | 1.69 |
Cluster | 699,082 | 0 | 4,222 | 6 | 1.47 |
Application | 68,229 | 0 | 1,639 | 24 | 0.57 |
Configuration | 387 | 1 | 1,246 | 3220 | 0.43 |
Commit | 83,656 | 0 | 1,223 | 15 | 0.43 |
Other | 90,169 | 70 | 1,055 | 12 | 0.37 |
Network | 5,048,896 | 0 | 347 | 0 | 0.12 |
System I/O | 21,477 | 0 | 45 | 2 | 0.02 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
library cache lock | 8,244 | 1 | 181,704 | 22041 | 0.04 | 63.41 |
cursor: pin S wait on X | 380 | 0 | 61,008 | 160548 | 0.00 | 21.29 |
resmgr:cpu quantum | 64,336 | 0 | 4,831 | 75 | 0.34 | 1.69 |
db file sequential read | 744,281 | 0 | 4,113 | 6 | 3.97 | 1.44 |
db file scattered read | 354,655 | 0 | 2,349 | 7 | 1.89 | 0.82 |
enq: TX - row lock contention | 381 | 0 | 1,619 | 4249 | 0.00 | 0.56 |
buffer busy waits | 1,798 | 0 | 1,412 | 785 | 0.01 | 0.49 |
enq: SQ - contention | 290 | 0 | 1,246 | 4296 | 0.00 | 0.43 |
log file sync | 83,656 | 0 | 1,223 | 15 | 0.45 | 0.43 |
gc buffer busy acquire | 50,887 | 1 | 941 | 18 | 0.27 | 0.33 |
DFS lock handle | 6,524 | 6 | 627 | 96 | 0.03 | 0.22 |
gc current grant busy | 47,179 | 0 | 609 | 13 | 0.25 | 0.21 |
gc cr block busy | 19,946 | 0 | 537 | 27 | 0.11 | 0.19 |
direct path read | 13,305 | 0 | 457 | 34 | 0.07 | 0.16 |
gc current block congested | 408 | 0 | 365 | 895 | 0.00 | 0.13 |
enq: US - contention | 110 | 0 | 327 | 2977 | 0.00 | 0.11 |
gc cr block congested | 359 | 0 | 298 | 830 | 0.00 | 0.10 |
gc current block 2-way | 242,098 | 0 | 264 | 1 | 1.29 | 0.09 |
gc current block busy | 2,195 | 0 | 231 | 105 | 0.01 | 0.08 |
SQL*Net more data from client | 6,922 | 0 | 210 | 30 | 0.04 | 0.07 |
gc cr block 2-way | 138,312 | 0 | 205 | 1 | 0.74 | 0.07 |
gc cr multi block request | 35,731 | 0 | 200 | 6 | 0.19 | 0.07 |
gc current grant congested | 75 | 0 | 162 | 2161 | 0.00 | 0.06 |
row cache lock | 16,890 | 0 | 154 | 9 | 0.09 | 0.05 |
SQL*Net message to client | 5,033,319 | 0 | 137 | 0 | 26.82 | 0.05 |
gc cr grant congested | 128 | 0 | 125 | 978 | 0.00 | 0.04 |
read by other session | 17,662 | 0 | 120 | 7 | 0.09 | 0.04 |
library cache pin | 8,706 | 1 | 110 | 13 | 0.05 | 0.04 |
gc cr grant 2-way | 107,868 | 0 | 109 | 1 | 0.57 | 0.04 |
gc buffer busy release | 577 | 0 | 106 | 184 | 0.00 | 0.04 |
db file parallel read | 5,410 | 0 | 101 | 19 | 0.03 | 0.04 |
library cache: mutex X | 15,816 | 0 | 96 | 6 | 0.08 | 0.03 |
Disk file operations I/O | 10,462 | 0 | 59 | 6 | 0.06 | 0.02 |
name-service call wait | 108 | 82 | 49 | 451 | 0.00 | 0.02 |
control file sequential read | 21,447 | 0 | 45 | 2 | 0.11 | 0.02 |
gc current grant 2-way | 12,384 | 0 | 44 | 4 | 0.07 | 0.02 |
library cache load lock | 127 | 0 | 26 | 208 | 0.00 | 0.01 |
enq: TX - index contention | 362 | 0 | 24 | 67 | 0.00 | 0.01 |
gc cr disk read | 40,755 | 0 | 24 | 1 | 0.22 | 0.01 |
SQL*Net break/reset to client | 67,656 | 0 | 19 | 0 | 0.36 | 0.01 |
ASM file metadata operation | 151 | 0 | 17 | 113 | 0.00 | 0.01 |
latch: shared pool | 1,840 | 0 | 13 | 7 | 0.01 | 0.00 |
buffer exterminate | 652 | 99 | 7 | 10 | 0.00 | 0.00 |
reliable message | 4,557 | 0 | 7 | 1 | 0.02 | 0.00 |
enq: PS - contention | 963 | 10 | 4 | 4 | 0.01 | 0.00 |
PX Deq: Signal ACK RSG | 1,625 | 0 | 3 | 2 | 0.01 | 0.00 |
latch: ges resource hash list | 129 | 0 | 3 | 23 | 0.00 | 0.00 |
PX Deq: Slave Session Stats | 2,475 | 0 | 2 | 1 | 0.01 | 0.00 |
os thread startup | 12 | 0 | 2 | 163 | 0.00 | 0.00 |
latch: row cache objects | 496 | 0 | 2 | 4 | 0.00 | 0.00 |
direct path write temp | 86 | 0 | 2 | 19 | 0.00 | 0.00 |
enq: TX - contention | 230 | 100 | 2 | 7 | 0.00 | 0.00 |
rdbms ipc reply | 1,020 | 0 | 1 | 1 | 0.01 | 0.00 |
latch: cache buffers chains | 10,895 | 0 | 1 | 0 | 0.06 | 0.00 |
PX Deq: reap credit | 44,820 | 100 | 1 | 0 | 0.24 | 0.00 |
asynch descriptor resize | 15,566 | 100 | 1 | 0 | 0.08 | 0.00 |
gc current split | 28 | 0 | 1 | 32 | 0.00 | 0.00 |
direct path write | 146 | 0 | 1 | 6 | 0.00 | 0.00 |
latch free | 2,882 | 0 | 1 | 0 | 0.02 | 0.00 |
direct path read temp | 24 | 0 | 1 | 30 | 0.00 | 0.00 |
IPC send completion sync | 984 | 0 | 0 | 0 | 0.01 | 0.00 |
enq: KO - fast object checkpoint | 135 | 0 | 0 | 3 | 0.00 | 0.00 |
cr request retry | 45 | 100 | 0 | 10 | 0.00 | 0.00 |
buffer deadlock | 638 | 100 | 0 | 1 | 0.00 | 0.00 |
external table read | 212 | 0 | 0 | 2 | 0.00 | 0.00 |
enq: TM - contention | 24 | 29 | 0 | 18 | 0.00 | 0.00 |
enq: WF - contention | 7 | 0 | 0 | 59 | 0.00 | 0.00 |
gc cr block lost | 1 | 0 | 0 | 409 | 0.00 | 0.00 |
latch: object queue header operation | 123 | 0 | 0 | 3 | 0.00 | 0.00 |
PX Deq: Signal ACK EXT | 1,625 | 0 | 0 | 0 | 0.01 | 0.00 |
latch: gcs resource hash | 14 | 0 | 0 | 23 | 0.00 | 0.00 |
resmgr:internal state change | 3 | 100 | 0 | 100 | 0.00 | 0.00 |
SQL*Net more data to client | 8,655 | 0 | 0 | 0 | 0.05 | 0.00 |
CSS initialization | 8 | 0 | 0 | 21 | 0.00 | 0.00 |
enq: RO - fast object reuse | 33 | 0 | 0 | 5 | 0.00 | 0.00 |
enq: FB - contention | 83 | 0 | 0 | 2 | 0.00 | 0.00 |
gc current multi block request | 102 | 0 | 0 | 2 | 0.00 | 0.00 |
KJC: Wait for msg sends to complete | 3,609 | 0 | 0 | 0 | 0.02 | 0.00 |
log file switch completion | 2 | 0 | 0 | 72 | 0.00 | 0.00 |
enq: HW - contention | 64 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TT - contention | 79 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: enqueue hash chains | 143 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: JQ - contention | 1 | 100 | 0 | 52 | 0.00 | 0.00 |
CSS operation: action | 9 | 0 | 0 | 5 | 0.00 | 0.00 |
control file parallel write | 30 | 0 | 0 | 2 | 0.00 | 0.00 |
undo segment extension | 5 | 100 | 0 | 8 | 0.00 | 0.00 |
enq: TO - contention | 55 | 62 | 0 | 1 | 0.00 | 0.00 |
latch: cache buffers lru chain | 60 | 0 | 0 | 1 | 0.00 | 0.00 |
gc cr failure | 47 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TX - allocate ITL entry | 26 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: CR - block range reuse ckpt | 7 | 0 | 0 | 3 | 0.00 | 0.00 |
enq: OD - Serializing DDLs | 16 | 100 | 0 | 1 | 0.00 | 0.00 |
latch: gc element | 185 | 0 | 0 | 0 | 0.00 | 0.00 |
utl_file I/O | 1,775 | 0 | 0 | 0 | 0.01 | 0.00 |
enq: MD - contention | 23 | 0 | 0 | 1 | 0.00 | 0.00 |
CSS operation: query | 24 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: SK - contention | 19 | 100 | 0 | 1 | 0.00 | 0.00 |
ges inquiry response | 12 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: PI - contention | 8 | 100 | 0 | 1 | 0.00 | 0.00 |
wait list latch free | 1 | 0 | 0 | 6 | 0.00 | 0.00 |
latch: call allocation | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: undo global data | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
cursor: pin S | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
global enqueue expand wait | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
PX qref latch | 537 | 100 | 0 | 0 | 0.00 | 0.00 |
enq: AF - task serialization | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: CF - contention | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TS - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
lock deadlock retry | 13 | 100 | 0 | 0 | 0.00 | 0.00 |
latch: session allocation | 1 | 0 | 0 | 1 | 0.00 | 0.00 |
gc current retry | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
SQL*Net message from client | 5,033,058 | 0 | 11,035,739 | 2193 | 26.82 | |
jobq slave wait | 3,332 | 99 | 1,660 | 498 | 0.02 | |
PX Deq: Execution Msg | 3,400 | 0 | 643 | 189 | 0.02 | |
PX Deq: Parse Reply | 1,625 | 0 | 288 | 177 | 0.01 | |
PX Deq: Execute Reply | 10,360 | 0 | 189 | 18 | 0.06 | |
auto-sqltune: wait graph update | 13 | 92 | 64 | 4894 | 0.00 | |
PX Deq: Join ACK | 1,625 | 0 | 19 | 11 | 0.01 | |
PL/SQL lock timer | 4 | 100 | 4 | 1000 | 0.00 | |
PX Deq Credit: send blkd | 785 | 0 | 1 | 1 | 0.00 | |
KSV master wait | 15 | 0 | 0 | 30 | 0.00 | |
PX Deq Credit: need buffer | 5 | 0 | 0 | 41 | 0.00 | |
PX Deq: Msg Fragment | 775 | 0 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
log file parallel write | 137,330 | 0 | 359 | 3 | 0.73 | 15.33 |
os thread startup | 86 | 1 | 227 | 2634 | 0.00 | 9.68 |
db file parallel write | 14,170 | 0 | 97 | 7 | 0.08 | 4.16 |
gcs log flush sync | 35,349 | 7 | 80 | 2 | 0.19 | 3.40 |
gc current grant congested | 3 | 0 | 71 | 23590 | 0.00 | 3.02 |
control file sequential read | 14,733 | 0 | 68 | 5 | 0.08 | 2.93 |
gc current block busy | 28 | 0 | 37 | 1332 | 0.00 | 1.59 |
enq: PV - syncstart | 2 | 0 | 29 | 14561 | 0.00 | 1.24 |
reliable message | 745 | 3 | 26 | 35 | 0.00 | 1.13 |
row cache lock | 4,154 | 0 | 19 | 5 | 0.02 | 0.82 |
enq: CO - master slave det | 1,132 | 100 | 19 | 17 | 0.01 | 0.81 |
process diagnostic dump | 2,444 | 0 | 19 | 8 | 0.01 | 0.80 |
Streams AQ: qmn coordinator waiting for slave to start | 4 | 75 | 17 | 4262 | 0.00 | 0.73 |
enq: TH - metric threshold evaluation | 1 | 0 | 15 | 15265 | 0.00 | 0.65 |
db file sequential read | 1,405 | 0 | 15 | 11 | 0.01 | 0.63 |
control file parallel write | 4,996 | 0 | 14 | 3 | 0.03 | 0.59 |
gc cr grant congested | 13 | 0 | 12 | 921 | 0.00 | 0.51 |
enq: PR - contention | 2 | 0 | 11 | 5471 | 0.00 | 0.47 |
enq: CF - contention | 348 | 100 | 9 | 25 | 0.00 | 0.37 |
gc current block congested | 26 | 0 | 7 | 255 | 0.00 | 0.28 |
log file sequential read | 193 | 0 | 6 | 30 | 0.00 | 0.25 |
library cache lock | 560 | 22 | 3 | 6 | 0.00 | 0.15 |
gc current block 2-way | 1,001 | 0 | 3 | 3 | 0.01 | 0.14 |
buffer busy waits | 63 | 0 | 3 | 40 | 0.00 | 0.11 |
latch free | 334 | 0 | 2 | 7 | 0.00 | 0.11 |
enq: TD - KTF dump entries | 11 | 0 | 2 | 211 | 0.00 | 0.10 |
gc cr grant 2-way | 354 | 0 | 2 | 6 | 0.00 | 0.09 |
ges lms sync during dynamic remastering and reconfig | 72 | 78 | 2 | 30 | 0.00 | 0.09 |
row cache process | 51,720 | 0 | 2 | 0 | 0.28 | 0.08 |
ASM file metadata operation | 949 | 0 | 2 | 2 | 0.01 | 0.07 |
row cache cleanup | 89,459 | 0 | 2 | 0 | 0.48 | 0.07 |
DFS lock handle | 2,296 | 70 | 1 | 1 | 0.01 | 0.06 |
wait for scn ack | 6 | 0 | 1 | 201 | 0.00 | 0.05 |
ADR block file write | 24 | 0 | 1 | 40 | 0.00 | 0.04 |
LGWR wait for redo copy | 1,696 | 0 | 1 | 1 | 0.01 | 0.04 |
gc current grant busy | 105 | 0 | 1 | 6 | 0.00 | 0.03 |
ksxr poll remote instances | 61,535 | 100 | 1 | 0 | 0.33 | 0.03 |
kjbdrmcvtq lmon drm quiesce: ping completion | 3 | 67 | 1 | 196 | 0.00 | 0.03 |
CSS initialization | 4 | 0 | 1 | 139 | 0.00 | 0.02 |
gc cr multi block request | 43 | 0 | 1 | 12 | 0.00 | 0.02 |
CGS wait for IPC msg | 30,365 | 100 | 0 | 0 | 0.16 | 0.02 |
latch: shared pool | 57 | 0 | 0 | 8 | 0.00 | 0.02 |
gc current grant 2-way | 355 | 0 | 0 | 1 | 0.00 | 0.02 |
gc cr block 2-way | 259 | 0 | 0 | 2 | 0.00 | 0.02 |
name-service call wait | 8 | 0 | 0 | 47 | 0.00 | 0.02 |
ADR block file read | 69 | 0 | 0 | 5 | 0.00 | 0.01 |
library cache pin | 655 | 0 | 0 | 1 | 0.00 | 0.01 |
Parameter File I/O | 96 | 0 | 0 | 3 | 0.00 | 0.01 |
latch: cache buffers chains | 73 | 0 | 0 | 4 | 0.00 | 0.01 |
libcache interrupt action by LCK | 64,797 | 0 | 0 | 0 | 0.35 | 0.01 |
Log archive I/O | 6 | 0 | 0 | 48 | 0.00 | 0.01 |
gc cr block busy | 10 | 0 | 0 | 27 | 0.00 | 0.01 |
direct path write | 9 | 0 | 0 | 26 | 0.00 | 0.01 |
resmgr:internal state change | 2 | 100 | 0 | 104 | 0.00 | 0.01 |
enq: KO - fast object checkpoint | 367 | 0 | 0 | 1 | 0.00 | 0.01 |
ges inquiry response | 216 | 0 | 0 | 1 | 0.00 | 0.01 |
latch: ges resource hash list | 547 | 0 | 0 | 0 | 0.00 | 0.01 |
latch: row cache objects | 28 | 0 | 0 | 6 | 0.00 | 0.01 |
SQL*Net break/reset to client | 370 | 0 | 0 | 0 | 0.00 | 0.01 |
ges LMON to get to FTDONE | 6 | 100 | 0 | 21 | 0.00 | 0.01 |
latch: gc element | 141 | 0 | 0 | 1 | 0.00 | 0.01 |
ADR file lock | 28 | 14 | 0 | 4 | 0.00 | 0.00 |
gc cr block congested | 2 | 0 | 0 | 57 | 0.00 | 0.00 |
enq: DR - contention | 2 | 0 | 0 | 51 | 0.00 | 0.00 |
PX Deq: reap credit | 6,696 | 100 | 0 | 0 | 0.04 | 0.00 |
Disk file operations I/O | 368 | 0 | 0 | 0 | 0.00 | 0.00 |
latch: object queue header operation | 466 | 0 | 0 | 0 | 0.00 | 0.00 |
SGA: allocation forcing component growth | 1 | 0 | 0 | 59 | 0.00 | 0.00 |
log file sync | 3 | 0 | 0 | 16 | 0.00 | 0.00 |
IPC send completion sync | 15 | 0 | 0 | 3 | 0.00 | 0.00 |
CSS operation: action | 16 | 0 | 0 | 3 | 0.00 | 0.00 |
CSS operation: data query | 2 | 0 | 0 | 20 | 0.00 | 0.00 |
enq: TT - contention | 62 | 58 | 0 | 1 | 0.00 | 0.00 |
ksdxexeotherwait | 1 | 0 | 0 | 38 | 0.00 | 0.00 |
latch: messages | 3 | 0 | 0 | 12 | 0.00 | 0.00 |
ges generic event | 2 | 100 | 0 | 14 | 0.00 | 0.00 |
latch: gcs resource hash | 21 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: TX - index contention | 1 | 0 | 0 | 26 | 0.00 | 0.00 |
latch: cache buffers lru chain | 44 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: PS - contention | 21 | 43 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc reply | 77 | 0 | 0 | 0 | 0.00 | 0.00 |
gc buffer busy release | 5 | 0 | 0 | 3 | 0.00 | 0.00 |
buffer deadlock | 1 | 100 | 0 | 16 | 0.00 | 0.00 |
db file scattered read | 1 | 0 | 0 | 16 | 0.00 | 0.00 |
enq: TM - contention | 11 | 73 | 0 | 1 | 0.00 | 0.00 |
enq: PE - contention | 6 | 100 | 0 | 1 | 0.00 | 0.00 |
enq: WF - contention | 15 | 0 | 0 | 1 | 0.00 | 0.00 |
gc current multi block request | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: PG - contention | 6 | 100 | 0 | 1 | 0.00 | 0.00 |
enq: CR - block range reuse ckpt | 14 | 0 | 0 | 1 | 0.00 | 0.00 |
kfk: async disk IO | 3 | 0 | 0 | 2 | 0.00 | 0.00 |
db file parallel read | 1 | 0 | 0 | 7 | 0.00 | 0.00 |
enq: US - contention | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
SQL*Net message to client | 4,556 | 0 | 0 | 0 | 0.02 | 0.00 |
latch: enqueue hash chains | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
asynch descriptor resize | 2,113 | 100 | 0 | 0 | 0.01 | 0.00 |
enq: TK - Auto Task Serialization | 6 | 100 | 0 | 1 | 0.00 | 0.00 |
PX Deq: Signal ACK RSG | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: RO - fast object reuse | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
CSS operation: query | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: TA - contention | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
gc current split | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
SQL*Net more data from client | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
PX Deq: Slave Session Stats | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
library cache: mutex X | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
log file single write | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
gc current retry | 1 | 0 | 0 | 2 | 0.00 | 0.00 |
enq: FB - contention | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: HW - contention | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
latch: redo allocation | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
enq: AF - task serialization | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
enq: MW - contention | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc message | 337,842 | 23 | 88,252 | 261 | 1.80 | |
PX Idle Wait | 858 | 0 | 12,999 | 15150 | 0.00 | |
class slave wait | 92 | 0 | 9,638 | 104759 | 0.00 | |
wait for unread message on broadcast channel | 7,219 | 100 | 7,216 | 1000 | 0.04 | |
DIAG idle wait | 207,426 | 92 | 6,931 | 33 | 1.11 | |
gcs remote message | 1,210,653 | 34 | 6,851 | 6 | 6.45 | |
Space Manager: slave idle wait | 1,142 | 96 | 5,553 | 4862 | 0.01 | |
Streams AQ: qmn slave idle wait | 205 | 2 | 4,968 | 24235 | 0.00 | |
ASM background timer | 778 | 0 | 3,609 | 4639 | 0.00 | |
shared server idle wait | 120 | 100 | 3,600 | 30001 | 0.00 | |
dispatcher timer | 60 | 100 | 3,600 | 60002 | 0.00 | |
pmon timer | 1,466 | 75 | 3,594 | 2451 | 0.01 | |
ges remote message | 396,109 | 73 | 3,593 | 9 | 2.11 | |
PING | 1,367 | 21 | 3,585 | 2623 | 0.01 | |
GCR sleep | 710 | 100 | 3,551 | 5001 | 0.00 | |
Streams AQ: qmn coordinator idle wait | 291 | 42 | 3,539 | 12161 | 0.00 | |
smon timer | 752 | 0 | 3,520 | 4681 | 0.00 | |
SGA: MMAN sleep for component shrink | 30,968 | 100 | 315 | 10 | 0.17 | |
SQL*Net message from client | 6,188 | 0 | 9 | 1 | 0.03 | |
KSV master wait | 2,134 | 99 | 1 | 0 | 0.01 | |
PX Deq: Parse Reply | 18 | 0 | 0 | 6 | 0.00 | |
PX Deq: Join ACK | 18 | 0 | 0 | 3 | 0.00 | |
PX Deq: Execute Reply | 18 | 0 | 0 | 1 | 0.00 | |
Streams AQ: RAC qmn coordinator idle wait | 300 | 100 | 0 | 0 | 0.00 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 69 | 40.6 | 1.4 | 14.5 | 21.7 | 18.8 | 2.9 | ||
ADR block file write | 24 | 12.5 | 8.3 | 29.2 | 20.8 | 29.2 | |||
ADR file lock | 28 | 89.3 | 3.6 | 7.1 | |||||
ARCH wait for archivelog lock | 1 | 100.0 | |||||||
ASM file metadata operation | 1099 | 84.8 | .4 | .4 | .2 | 14.3 | |||
CGS wait for IPC msg | 30.4K | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
CSS initialization | 12 | 50.0 | 50.0 | ||||||
CSS operation: action | 25 | 24.0 | 20.0 | 52.0 | 4.0 | ||||
CSS operation: data query | 2 | 100.0 | |||||||
CSS operation: query | 36 | 83.3 | 2.8 | 13.9 | |||||
DFS lock handle | 8891 | 71.0 | 22.0 | 3.5 | .9 | .5 | .5 | .8 | .9 |
Disk file operations I/O | 10.8K | 93.1 | 4.6 | 1.3 | .1 | .0 | .0 | .8 | .1 |
IPC send completion sync | 996 | 96.2 | 2.5 | .3 | .5 | .2 | .1 | .2 | |
KJC: Wait for msg sends to complete | 3747 | 99.8 | .1 | .0 | .0 | .1 | .0 | ||
LGWR wait for redo copy | 1698 | 94.5 | 1.2 | 1.5 | 1.3 | .8 | .5 | .2 | |
Log archive I/O | 6 | 33.3 | 16.7 | 50.0 | |||||
PX Deq: Signal ACK EXT | 1638 | 96.5 | 1.2 | 1.6 | .3 | .2 | .1 | ||
PX Deq: Signal ACK RSG | 1638 | 90.4 | 2.3 | 1.5 | .9 | .5 | 4.0 | .3 | |
PX Deq: Slave Session Stats | 2486 | 91.4 | 5.3 | 1.7 | .8 | .4 | .1 | .2 | |
PX Deq: reap credit | 51.4K | 100.0 | .0 | .0 | .0 | .0 | |||
PX qref latch | 537 | 100.0 | |||||||
Parameter File I/O | 96 | 36.5 | 43.8 | 11.5 | 7.3 | 1.0 | |||
SGA: allocation forcing component growth | 1 | 100.0 | |||||||
SQL*Net break/reset to client | 68K | 98.5 | 1.1 | .2 | .1 | .0 | .0 | .0 | |
SQL*Net message to client | 5038.1K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
SQL*Net more data from client | 6968 | 78.1 | .2 | .2 | .3 | .4 | 1.0 | 19.8 | |
SQL*Net more data to client | 7243 | 100.0 | |||||||
Streams AQ: qmn coordinator waiting for slave to start | 4 | 25.0 | 75.0 | ||||||
asynch descriptor resize | 17.7K | 99.9 | .0 | .0 | .0 | .0 | .0 | .0 | |
buffer busy waits | 1860 | 45.8 | 4.3 | 7.2 | 2.8 | 2.6 | 4.1 | 19.3 | 13.9 |
buffer deadlock | 639 | 93.7 | 2.2 | 2.0 | 1.3 | .3 | .2 | .3 | |
buffer exterminate | 652 | .3 | .3 | 98.9 | .5 | ||||
control file parallel write | 5026 | .3 | 75.9 | 13.0 | 6.5 | 3.0 | .6 | .7 | |
control file sequential read | 36.2K | 53.5 | 31.1 | 4.7 | 4.5 | 3.5 | 1.4 | 1.4 | |
cr request retry | 45 | 100.0 | |||||||
cursor: mutex S | 2 | 100.0 | |||||||
cursor: pin S | 22 | 90.9 | 9.1 | ||||||
cursor: pin S wait on X | 380 | 29.2 | .5 | 9.5 | 60.8 | ||||
db file parallel read | 5409 | 5.5 | 17.6 | 7.6 | 8.0 | 19.6 | 25.2 | 16.5 | |
db file parallel write | 14.2K | 3.6 | 48.0 | 18.0 | 12.1 | 11.3 | 3.7 | 3.3 | |
db file scattered read | 354.4K | 15.2 | 49.4 | 8.5 | 3.9 | 11.8 | 7.1 | 4.0 | |
db file sequential read | 746.1K | 43.0 | 23.5 | 4.2 | 5.9 | 14.9 | 6.8 | 1.8 | .0 |
direct path read | 13.3K | .1 | .2 | .3 | .4 | 23.0 | 45.0 | 31.0 | |
direct path read temp | 24 | 8.3 | 8.3 | 20.8 | 20.8 | 41.7 | |||
direct path write | 155 | 4.5 | 25.8 | 15.5 | 45.2 | 2.6 | 2.6 | 3.9 | |
direct path write temp | 86 | 3.5 | 12.8 | 10.5 | 24.4 | 15.1 | 16.3 | 17.4 | |
enq: AF - task serialization | 4 | 75.0 | 25.0 | ||||||
enq: CF - contention | 352 | 85.8 | 8.5 | 2.6 | 1.1 | .3 | 1.1 | .6 | |
enq: CO - master slave det | 1132 | 85.6 | 9.3 | 3.1 | 1.0 | .4 | .4 | .3 | |
enq: CR - block range reuse ckpt | 22 | 68.2 | 4.5 | 22.7 | 4.5 | ||||
enq: DR - contention | 2 | 50.0 | 50.0 | ||||||
enq: FB - contention | 88 | 78.4 | 11.4 | 2.3 | 4.5 | 2.3 | 1.1 | ||
enq: HW - contention | 68 | 77.9 | 10.3 | 2.9 | 4.4 | 4.4 | |||
enq: JQ - contention | 1 | 100.0 | |||||||
enq: KO - fast object checkpoint | 502 | 91.8 | 4.0 | 1.4 | .4 | .8 | 1.0 | .6 | |
enq: MD - contention | 23 | 91.3 | 4.3 | 4.3 | |||||
enq: MW - contention | 2 | 100.0 | |||||||
enq: OD - Serializing DDLs | 16 | 75.0 | 12.5 | 6.3 | 6.3 | ||||
enq: PE - contention | 6 | 66.7 | 16.7 | 16.7 | |||||
enq: PG - contention | 6 | 83.3 | 16.7 | ||||||
enq: PI - contention | 8 | 62.5 | 25.0 | 12.5 | |||||
enq: PR - contention | 2 | 100.0 | |||||||
enq: PS - contention | 980 | 69.4 | 24.5 | 3.5 | 1.6 | .4 | .3 | .2 | .1 |
enq: PV - syncstart | 2 | 100.0 | |||||||
enq: RO - fast object reuse | 43 | 60.5 | 4.7 | 4.7 | 20.9 | 7.0 | 2.3 | ||
enq: SK - contention | 19 | 94.7 | 5.3 | ||||||
enq: SQ - contention | 290 | 6.2 | 4.1 | 4.5 | 3.4 | 2.4 | 6.9 | 20.3 | 52.1 |
enq: TA - contention | 5 | 80.0 | 20.0 | ||||||
enq: TD - KTF dump entries | 11 | 81.8 | 9.1 | 9.1 | |||||
enq: TH - metric threshold evaluation | 1 | 100.0 | |||||||
enq: TK - Auto Task Serialization | 6 | 83.3 | 16.7 | ||||||
enq: TM - contention | 34 | 94.1 | 2.9 | 2.9 | |||||
enq: TO - contention | 55 | 92.7 | 3.6 | 1.8 | 1.8 | ||||
enq: TS - contention | 4 | 100.0 | |||||||
enq: TT - contention | 141 | 87.9 | 8.5 | 1.4 | .7 | 1.4 | |||
enq: TX - allocate ITL entry | 26 | 84.6 | 11.5 | 3.8 | |||||
enq: TX - contention | 230 | 81.7 | 7.8 | 3.9 | 1.7 | 3.5 | 1.3 | ||
enq: TX - index contention | 364 | 36.3 | 3.6 | 2.7 | 5.8 | 6.3 | 9.6 | 35.7 | |
enq: TX - row lock contention | 381 | 44.1 | 14.4 | 8.1 | 8.7 | 7.3 | 4.7 | 8.7 | 3.9 |
enq: US - contention | 118 | 24.6 | 3.4 | 1.7 | 2.5 | 3.4 | 31.4 | 33.1 | |
enq: WF - contention | 22 | 90.9 | 4.5 | 4.5 | |||||
external table open | 14 | 100.0 | |||||||
external table read | 212 | 91.5 | 7.5 | .9 | |||||
external table seek | 14 | 100.0 | |||||||
gc buffer busy acquire | 50.9K | 35.2 | 38.2 | 10.7 | 3.7 | 5.4 | 2.7 | 4.0 | .1 |
gc buffer busy release | 583 | 15.4 | 16.5 | 8.7 | 8.4 | 11.7 | 6.0 | 31.7 | 1.5 |
gc cr block 2-way | 138.6K | 94.8 | 3.2 | .8 | .4 | .3 | .2 | .2 | .0 |
gc cr block busy | 19.9K | .7 | 49.3 | 31.1 | 9.1 | 5.6 | 2.1 | 2.1 | .1 |
gc cr block congested | 361 | 35.7 | 2.5 | 3.3 | 5.3 | 5.0 | 5.0 | 33.8 | 9.4 |
gc cr block lost | 1 | 100.0 | |||||||
gc cr disk read | 40.8K | 96.3 | 2.5 | .6 | .3 | .1 | .1 | .1 | .0 |
gc cr failure | 47 | 91.5 | 2.1 | 4.3 | 2.1 | ||||
gc cr grant 2-way | 107.7K | 96.2 | 2.6 | .7 | .3 | .1 | .1 | .1 | .0 |
gc cr grant congested | 141 | 65.2 | 5.0 | 2.1 | 3.5 | 5.7 | 2.1 | 12.1 | 4.3 |
gc cr multi block request | 35.5K | 55.4 | 32.6 | 4.6 | 6.2 | 1.0 | .2 | .1 | .0 |
gc current block 2-way | 243.2K | 95.5 | 3.0 | .8 | .3 | .2 | .1 | .2 | .0 |
gc current block busy | 2225 | 17.0 | 24.9 | 19.5 | 12.7 | 12.5 | 6.4 | 6.3 | .6 |
gc current block congested | 435 | 46.7 | .9 | 2.8 | 3.2 | 3.4 | 1.8 | 29.4 | 11.7 |
gc current grant 2-way | 12.8K | 95.7 | 2.3 | .7 | .3 | .2 | .2 | .4 | .1 |
gc current grant busy | 47.3K | 92.6 | 4.7 | 1.0 | .4 | .4 | .2 | .6 | .1 |
gc current grant congested | 78 | 12.8 | 2.6 | 1.3 | 2.6 | 2.6 | 2.6 | 52.6 | 23.1 |
gc current multi block request | 112 | 81.3 | 12.5 | 2.7 | 1.8 | 1.8 | |||
gc current retry | 3 | 66.7 | 33.3 | ||||||
gc current split | 30 | 73.3 | 10.0 | 3.3 | 6.7 | 6.7 | |||
gc object scan | 3 | 100.0 | |||||||
gcs log flush sync | 35.3K | 37.7 | 38.5 | 8.7 | 7.2 | 7.5 | .4 | .0 | |
ges LMON to get to FTDONE | 6 | 100.0 | |||||||
ges generic event | 2 | 50.0 | 50.0 | ||||||
ges inquiry response | 228 | 80.3 | 15.4 | 3.1 | 1.3 | ||||
ges lms sync during dynamic remastering and reconfig | 72 | 1.4 | 18.1 | 5.6 | 25.0 | 50.0 | |||
global enqueue expand wait | 7 | 100.0 | |||||||
kfk: async disk IO | 3 | 33.3 | 33.3 | 33.3 | |||||
kjbdrmcvtq lmon drm quiesce: ping completion | 3 | 100.0 | |||||||
ksdxexeotherwait | 1 | 100.0 | |||||||
ksxr poll remote instances | 60.3K | 100.0 | .0 | ||||||
latch free | 3213 | 91.1 | 4.9 | 1.4 | 1.2 | .8 | .2 | .4 | |
latch: cache buffers chains | 11K | 99.1 | .3 | .3 | .1 | .1 | .0 | .0 | |
latch: cache buffers lru chain | 104 | 90.4 | 3.8 | 1.9 | 2.9 | 1.0 | |||
latch: call allocation | 13 | 92.3 | 7.7 | ||||||
latch: checkpoint queue latch | 1 | 100.0 | |||||||
latch: enqueue hash chains | 145 | 92.4 | 3.4 | 1.4 | 2.8 | ||||
latch: gc element | 323 | 97.2 | .9 | .3 | .9 | .3 | .3 | ||
latch: gcs resource hash | 35 | 82.9 | 8.6 | 5.7 | 2.9 | ||||
latch: ges resource hash list | 688 | 89.8 | 1.9 | 1.5 | 2.6 | 2.2 | .9 | 1.2 | |
latch: messages | 3 | 66.7 | 33.3 | ||||||
latch: object queue header operation | 589 | 98.5 | .2 | .3 | .8 | .2 | |||
latch: redo allocation | 10 | 90.0 | 10.0 | ||||||
latch: row cache objects | 522 | 71.5 | 5.2 | 3.4 | 4.6 | 5.9 | 7.9 | 1.5 | |
latch: session allocation | 1 | 100.0 | |||||||
latch: shared pool | 1858 | 78.3 | 7.2 | 5.9 | 2.9 | 1.8 | 1.3 | 2.6 | |
latch: undo global data | 4 | 50.0 | 25.0 | 25.0 | |||||
libcache interrupt action by LCK | 63.6K | 100.0 | .0 | .0 | |||||
library cache load lock | 127 | 3.9 | 5.5 | 1.6 | 1.6 | 13.4 | 1.6 | 72.4 | |
library cache lock | 8767 | 81.9 | 5.7 | 2.0 | 1.1 | .6 | .3 | 1.5 | 6.8 |
library cache pin | 9318 | 92.6 | 4.1 | 1.1 | .8 | .4 | .2 | .8 | .1 |
library cache: mutex X | 15.8K | 62.8 | 3.1 | 3.7 | 6.8 | 9.4 | 10.0 | 4.2 | |
lock deadlock retry | 14 | 100.0 | |||||||
lock escalate retry | 2 | 100.0 | |||||||
log file parallel write | 137.3K | 45.0 | 36.6 | 5.5 | 7.0 | 4.1 | 1.3 | .6 | |
log file sequential read | 193 | 3.1 | .5 | .5 | 16.1 | 63.2 | 16.6 | ||
log file single write | 2 | 50.0 | 50.0 | ||||||
log file switch completion | 2 | 50.0 | 50.0 | ||||||
log file sync | 83.7K | 22.7 | 45.1 | 12.3 | 8.9 | 6.1 | 2.5 | 2.4 | .0 |
name-service call wait | 116 | .9 | .9 | .9 | 97.4 | ||||
os thread startup | 98 | 91.8 | 8.2 | ||||||
process diagnostic dump | 2444 | 10.9 | .1 | 71.9 | 16.3 | .5 | .1 | .2 | .0 |
rdbms ipc reply | 1089 | 60.6 | 27.5 | 9.4 | .9 | .9 | .2 | .5 | |
read by other session | 17.7K | 22.8 | 40.0 | 12.1 | 5.8 | 12.0 | 5.3 | 1.8 | .0 |
reliable message | 5311 | 92.2 | 3.9 | 2.0 | .6 | .2 | .2 | .9 | |
resmgr:cpu quantum | 64.3K | 8.8 | 6.6 | 8.3 | 8.9 | 7.4 | 10.3 | 49.6 | .1 |
resmgr:internal state change | 5 | 100.0 | |||||||
row cache cleanup | 87.6K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
row cache lock | 20.3K | 88.6 | 7.4 | 1.7 | 1.0 | .5 | .2 | .4 | .2 |
row cache process | 50.5K | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
undo segment extension | 11 | 27.3 | 27.3 | 18.2 | 27.3 | ||||
utl_file I/O | 381 | 99.5 | .3 | .3 | |||||
wait for scn ack | 6 | 16.7 | 83.3 | ||||||
wait list latch free | 1 | 100.0 | |||||||
ASM background timer | 778 | 1.3 | .1 | 4.6 | 94.0 | ||||
DIAG idle wait | 207.5K | 5.0 | .4 | .5 | 13.0 | 47.9 | 14.2 | 19.0 | .0 |
GCR sleep | 710 | 100.0 | |||||||
KSV master wait | 2149 | 99.5 | .1 | .1 | .0 | .2 | |||
PING | 1367 | 77.7 | .9 | .4 | .1 | .1 | .1 | 20.6 | |
PL/SQL lock timer | 4 | 100.0 | |||||||
PX Deq Credit: need buffer | 5 | 60.0 | 20.0 | 20.0 | |||||
PX Deq Credit: send blkd | 785 | 92.6 | 4.6 | 1.3 | .3 | .6 | .6 | ||
PX Deq: Execute Reply | 10.4K | 15.4 | 5.2 | 8.1 | 16.3 | 38.7 | 10.6 | 5.8 | .0 |
PX Deq: Execution Msg | 3392 | 42.5 | 27.3 | 11.2 | 5.1 | 3.8 | 3.3 | 4.6 | 2.2 |
PX Deq: Join ACK | 1638 | 25.3 | 47.4 | 17.0 | 5.6 | 2.3 | 1.1 | 1.0 | .2 |
PX Deq: Msg Fragment | 775 | 99.5 | .4 | .1 | |||||
PX Deq: Parse Reply | 1638 | 31.1 | 38.3 | 14.7 | 3.1 | 2.3 | 2.3 | 7.0 | 1.2 |
PX Idle Wait | 848 | 15.9 | 26.3 | 14.2 | 4.6 | 1.8 | 1.1 | 7.0 | 29.2 |
SGA: MMAN sleep for component shrink | 31K | .0 | .0 | .0 | .0 | 99.5 | .3 | .1 | |
SQL*Net message from client | 5039.5K | 83.0 | 6.7 | 1.5 | .7 | .7 | .8 | 5.2 | 1.4 |
Space Manager: slave idle wait | 1145 | .2 | .1 | 1.5 | 98.3 | ||||
Streams AQ: RAC qmn coordinator idle wait | 300 | 100.0 | |||||||
Streams AQ: qmn coordinator idle wait | 291 | 55.3 | 1.7 | 1.0 | .3 | 41.6 | |||
Streams AQ: qmn slave idle wait | 205 | 14.1 | 85.9 | ||||||
auto-sqltune: wait graph update | 13 | 100.0 | |||||||
class slave wait | 92 | 54.3 | 6.5 | 2.2 | 6.5 | 6.5 | 1.1 | 7.6 | 15.2 |
dispatcher timer | 60 | 100.0 | |||||||
gcs remote message | 1210.5K | 26.0 | 11.1 | 12.5 | 13.0 | 33.8 | 3.6 | .0 | .0 |
ges remote message | 396.1K | 84.7 | 2.2 | 1.5 | 1.2 | 1.0 | 1.0 | 8.4 | .0 |
jobq slave wait | 3343 | 100.0 | |||||||
pmon timer | 1467 | 6.5 | .1 | .2 | .3 | 8.9 | 84.0 | ||
rdbms ipc message | 336.8K | 37.0 | 5.0 | 5.4 | 8.8 | 6.6 | 4.4 | 27.8 | 4.9 |
shared server idle wait | 120 | 100.0 | |||||||
smon timer | 754 | 2.3 | .1 | 2.9 | 94.7 | ||||
wait for unread message on broadcast channel | 7219 | .0 | 99.9 | .0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file write | 7 | 70.8 | 12.5 | 12.5 | 4.2 | ||||
ADR file lock | 2 | 92.9 | 7.1 | ||||||
ASM file metadata operation | 157 | 85.7 | 12.2 | 1.7 | .2 | .2 | |||
CSS initialization | 6 | 50.0 | 41.7 | 8.3 | |||||
DFS lock handle | 71 | 98.4 | .1 | .1 | .0 | .6 | .0 | .8 | |
Disk file operations I/O | 97 | 99.1 | .0 | .1 | .1 | .2 | .4 | .1 | |
IPC send completion sync | 2 | 99.8 | .2 | ||||||
KJC: Wait for msg sends to complete | 1 | 100.0 | .0 | ||||||
LGWR wait for redo copy | 3 | 99.8 | .1 | .1 | |||||
Log archive I/O | 3 | 50.0 | 16.7 | 16.7 | 16.7 | ||||
PX Deq: Signal ACK RSG | 5 | 99.7 | .1 | .1 | .1 | .1 | |||
PX Deq: Slave Session Stats | 6 | 99.8 | .0 | .2 | .0 | ||||
PX Deq: reap credit | 2 | 100.0 | .0 | .0 | |||||
SGA: allocation forcing component growth | 1 | 100.0 | |||||||
SQL*Net break/reset to client | 14 | 100.0 | .0 | .0 | .0 | ||||
SQL*Net message to client | 19 | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
SQL*Net more data from client | 1383 | 80.2 | 1.9 | 3.9 | 14.1 | ||||
asynch descriptor resize | 1 | 100.0 | .0 | ||||||
buffer busy waits | 452 | 66.8 | 4.4 | 3.4 | .9 | 1.2 | 9.5 | 5.0 | 8.9 |
buffer deadlock | 2 | 99.7 | .2 | .2 | |||||
control file parallel write | 35 | 99.3 | .5 | .1 | .1 | ||||
control file sequential read | 519 | 98.6 | .7 | .6 | .1 | .0 | .0 | ||
cursor: pin S wait on X | 45 | 29.7 | 1.1 | .3 | 1.3 | 1.3 | 5.5 | 2.4 | 58.4 |
db file parallel read | 892 | 83.5 | 13.5 | 2.2 | .6 | .1 | .0 | ||
db file parallel write | 471 | 96.7 | 1.9 | .8 | .5 | .0 | .0 | ||
db file scattered read | 14.3K | 96.0 | 3.2 | .6 | .2 | .0 | .0 | ||
db file sequential read | 13.3K | 98.2 | 1.4 | .3 | .1 | .0 | .0 | .0 | |
direct path read | 4129 | 69.0 | 22.6 | 5.2 | 2.9 | .4 | .0 | ||
direct path read temp | 10 | 58.3 | 29.2 | 12.5 | |||||
direct path write | 6 | 96.1 | 2.6 | .6 | .6 | ||||
direct path write temp | 15 | 82.6 | 11.6 | 4.7 | 1.2 | ||||
enq: CF - contention | 4 | 98.3 | .9 | .3 | .6 | ||||
enq: CO - master slave det | 4 | 99.4 | .1 | .1 | .2 | .3 | |||
enq: DR - contention | 1 | 50.0 | 50.0 | ||||||
enq: FB - contention | 1 | 98.9 | 1.1 | ||||||
enq: JQ - contention | 1 | 100.0 | |||||||
enq: KO - fast object checkpoint | 3 | 99.4 | .2 | .4 | |||||
enq: PS - contention | 2 | 99.7 | .1 | .1 | .1 | ||||
enq: RO - fast object reuse | 1 | 97.7 | 2.3 | ||||||
enq: SQ - contention | 67 | 27.6 | 6.6 | 4.1 | 3.8 | 4.1 | 1.7 | 2.8 | 49.3 |
enq: TX - contention | 3 | 98.7 | 1.3 | ||||||
enq: TX - index contention | 130 | 64.3 | 7.7 | 9.9 | 6.9 | 11.0 | .3 | ||
enq: TX - row lock contention | 34 | 87.4 | 2.1 | 3.4 | 1.6 | 1.3 | .3 | .3 | 3.7 |
enq: US - contention | 39 | 35.6 | 2.5 | .8 | .8 | 27.1 | 1.7 | 31.4 | |
enq: WF - contention | 1 | 95.5 | 4.5 | ||||||
external table read | 2 | 99.1 | .9 | ||||||
gc buffer busy acquire | 2054 | 95.9 | .9 | 1.8 | .3 | .3 | .7 | .0 | .0 |
gc buffer busy release | 193 | 66.7 | 6.9 | 3.8 | 3.4 | 5.0 | 12.7 | 1.4 | .2 |
gc cr block 2-way | 353 | 99.7 | .1 | .1 | .0 | .0 | .0 | .0 | .0 |
gc cr block busy | 421 | 97.8 | 1.0 | .6 | .3 | .1 | .1 | .0 | .1 |
gc cr block congested | 136 | 56.8 | 3.0 | 8.0 | 7.2 | 8.3 | 7.2 | 3.9 | 5.5 |
gc cr block lost | 1 | 100.0 | |||||||
gc cr disk read | 24 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
gc cr grant 2-way | 156 | 99.8 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
gc cr grant congested | 18 | 83.7 | 2.8 | 3.5 | 2.8 | 2.8 | .7 | 3.5 | |
gc cr multi block request | 33 | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
gc current block 2-way | 429 | 99.8 | .1 | .0 | .0 | .0 | .0 | .0 | .0 |
gc current block busy | 148 | 93.0 | 3.4 | 1.3 | .9 | .5 | .3 | .3 | .3 |
gc current block congested | 154 | 58.9 | 2.5 | 5.1 | 7.6 | 6.9 | 7.4 | 6.0 | 5.7 |
gc current grant 2-way | 63 | 99.5 | .1 | .1 | .1 | .1 | .1 | .0 | .0 |
gc current grant busy | 328 | 99.3 | .2 | .1 | .1 | .2 | .1 | .1 | .1 |
gc current grant congested | 51 | 24.4 | 10.3 | 7.7 | 10.3 | 12.8 | 11.5 | 12.8 | 10.3 |
gc current split | 2 | 93.3 | 3.3 | 3.3 | |||||
gcs log flush sync | 11 | 100.0 | .0 | .0 | .0 | .0 | |||
ges lms sync during dynamic remastering and reconfig | 36 | 50.0 | 48.6 | 1.4 | |||||
kjbdrmcvtq lmon drm quiesce: ping completion | 3 | 100.0 | |||||||
ksdxexeotherwait | 1 | 100.0 | |||||||
latch free | 12 | 99.6 | .2 | .1 | .0 | .1 | |||
latch: cache buffers chains | 5 | 100.0 | .0 | .0 | .0 | ||||
latch: gc element | 1 | 99.7 | .3 | ||||||
latch: gcs resource hash | 1 | 97.1 | 2.9 | ||||||
latch: ges resource hash list | 8 | 98.8 | .3 | .1 | .4 | .3 | |||
latch: messages | 1 | 66.7 | 33.3 | ||||||
latch: object queue header operation | 1 | 99.8 | .2 | ||||||
latch: row cache objects | 8 | 98.5 | 1.5 | ||||||
latch: shared pool | 49 | 97.4 | .9 | .5 | .5 | .4 | .4 | ||
library cache load lock | 92 | 27.6 | 6.3 | 11.0 | 10.2 | 44.9 | |||
library cache lock | 157 | 91.6 | .3 | .2 | .1 | .7 | .2 | .3 | 6.6 |
library cache pin | 76 | 99.1 | .4 | .0 | .0 | .0 | .3 | .1 | |
library cache: mutex X | 657 | 95.8 | 3.7 | .4 | .0 | .0 | .0 | ||
log file parallel write | 823 | 99.4 | .4 | .1 | .1 | .0 | .0 | ||
log file sequential read | 32 | 83.4 | 6.2 | 8.3 | 2.1 | ||||
log file switch completion | 1 | 50.0 | 50.0 | ||||||
log file sync | 1972 | 97.6 | 1.1 | .7 | .4 | .1 | .1 | .0 | .0 |
name-service call wait | 113 | 2.6 | 7.8 | 9.5 | 2.6 | 73.3 | 4.3 | ||
os thread startup | 91 | 75.5 | 11.2 | 4.1 | 1.0 | 1.0 | 7.1 | ||
process diagnostic dump | 4 | 99.8 | .0 | .0 | .1 | .0 | |||
rdbms ipc reply | 5 | 99.5 | .5 | ||||||
read by other session | 333 | 98.1 | 1.2 | .3 | .2 | .1 | .1 | .0 | |
reliable message | 50 | 99.1 | .2 | .1 | .1 | .1 | .5 | ||
resmgr:cpu quantum | 32K | 50.3 | 17.3 | 16.4 | 8.9 | 5.6 | 1.3 | .1 | .0 |
resmgr:internal state change | 5 | 100.0 | |||||||
row cache cleanup | 5 | 100.0 | .0 | .0 | .0 | ||||
row cache lock | 94 | 99.3 | .1 | .1 | .0 | .1 | .1 | .0 | .2 |
row cache process | 3 | 100.0 | .0 | .0 | |||||
undo segment extension | 3 | 72.7 | 9.1 | 9.1 | 9.1 | ||||
wait for scn ack | 5 | 16.7 | 33.3 | 16.7 | 33.3 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
DFS lock handle | 74 | 99.2 | .1 | .4 | .2 | .0 | |||
SQL*Net message to client | 6 | 100.0 | .0 | .0 | |||||
Streams AQ: qmn coordinator waiting for slave to start | 3 | 25.0 | 75.0 | ||||||
buffer busy waits | 165 | 91.1 | .9 | 7.3 | .7 | ||||
cursor: pin S wait on X | 47 | 41.6 | 2.9 | 3.9 | 3.4 | .5 | .3 | 1.3 | 46.1 |
enq: CF - contention | 2 | 99.4 | .6 | ||||||
enq: CO - master slave det | 3 | 99.7 | .2 | .1 | |||||
enq: PR - contention | 2 | 50.0 | 50.0 | ||||||
enq: PS - contention | 1 | 99.9 | .1 | ||||||
enq: PV - syncstart | 2 | 50.0 | 50.0 | ||||||
enq: SQ - contention | 143 | 50.7 | 4.8 | 22.1 | 22.4 | ||||
enq: TD - KTF dump entries | 1 | 90.9 | 9.1 | ||||||
enq: TH - metric threshold evaluation | 1 | 100.0 | |||||||
enq: TX - row lock contention | 10 | 96.3 | .8 | .3 | 1.3 | .3 | 1.0 | ||
enq: US - contention | 37 | 68.6 | 5.1 | 12.7 | 13.6 | ||||
gc buffer busy acquire | 24 | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
gc buffer busy release | 1 | 99.8 | .2 | ||||||
gc cr block 2-way | 12 | 100.0 | .0 | .0 | |||||
gc cr block busy | 13 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
gc cr block congested | 20 | 94.5 | 1.1 | 1.7 | 1.4 | 1.4 | |||
gc cr disk read | 1 | 100.0 | .0 | ||||||
gc cr grant 2-way | 8 | 100.0 | .0 | ||||||
gc cr grant congested | 5 | 96.5 | .7 | 1.4 | .7 | .7 | |||
gc cr multi block request | 3 | 100.0 | .0 | .0 | .0 | ||||
gc current block 2-way | 7 | 100.0 | .0 | ||||||
gc current block busy | 7 | 99.7 | .0 | .0 | .0 | .2 | |||
gc current block congested | 25 | 94.3 | 1.6 | 2.3 | 1.1 | .5 | .2 | ||
gc current grant 2-way | 6 | 100.0 | .0 | .0 | |||||
gc current grant busy | 24 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
gc current grant congested | 8 | 89.7 | 6.4 | 1.3 | 2.6 | ||||
library cache lock | 188 | 93.4 | .3 | .8 | .9 | .0 | .1 | 4.4 | |
library cache pin | 6 | 99.9 | .0 | .1 | |||||
log file sync | 12 | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
os thread startup | 7 | 92.9 | 1.0 | 2.0 | 2.0 | 1.0 | 1.0 | ||
process diagnostic dump | 1 | 100.0 | .0 | ||||||
resmgr:cpu quantum | 31 | 100.0 | .0 | .0 | |||||
row cache lock | 39 | 99.8 | .2 |
% of Total Waits | ||||||||
---|---|---|---|---|---|---|---|---|
Event | Waits 4m to 1h | <2m | <4m | <8m | <1/4h | <1/2h | < 1h | >=1h |
cursor: pin S wait on X | 175 | 53.9 | 23.9 | 18.2 | 3.9 | |||
enq: TX - row lock contention | 4 | 99.0 | .3 | .8 | ||||
library cache lock | 388 | 95.6 | .8 | 1.9 | 1.7 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
COREDB. | 271,253 | 5,778 | 7,902 | 345,198 |
SYS$USERS | 15,325 | 3,426 | 10,982 | 239,735 |
SYS$BACKGROUND | 0 | 0 | 1 | 330 |
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. | 376275 | 3255 | 44056 | 243337 | 0 | 0 | 4994151 | 347 |
SYS$USERS | 771731 | 3947 | 21722 | 1215 | 0 | 0 | 54902 | 0 |
SYS$BACKGROUND | 1874 | 15 | 71035 | 253 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
4,914.25 | 210 | 23.40 | 1.71 | 0.15 | 0.00 | 95v76f5muyjjg | JDBC Thin Client | select originalorderno from or... |
3,763.54 | 1,203 | 3.13 | 1.31 | 0.05 | 0.06 | 7ncnu7ud2ykhu | JDBC Thin Client | insert into ORDERS (domesticin... |
3,333.34 | 6,868 | 0.49 | 1.16 | 0.14 | 0.00 | 9upvznnp7xgsj | JDBC Thin Client | SELECT BG.BANKGATEWAYNAME AS b... |
3,194.68 | 1 | 3,194.68 | 1.11 | 67.23 | 15.33 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
3,158.50 | 14 | 225.61 | 1.10 | 0.01 | 0.00 | fp1vatugjfuym | JDBC Thin Client | SELECT O.STATUS, P.TICKETNO FR... |
2,649.89 | 5 | 529.98 | 0.92 | 0.16 | 0.00 | 9awmqbn8w5tkq | JDBC Thin Client | SELECT O.STATUS, P.TICKETNO FR... |
2,573.07 | 328 | 7.84 | 0.90 | 80.20 | 3.42 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
1,998.32 | 6 | 333.05 | 0.70 | 0.15 | 0.00 | g3yjdvgd23b85 | JDBC Thin Client | select p.orderno, o.bookUser f... |
1,800.00 | 1,557 | 1.16 | 0.63 | 0.15 | 0.00 | 6wytwy7ry0jsb | JDBC Thin Client | UPDATE ORDERS SET TICKETOUTAGE... |
1,742.44 | 2,100 | 0.83 | 0.61 | 0.05 | 0.00 | 7jk3kcjxvz83k | JDBC Thin Client | UPDATE PAYBILL SET PAYSTATUS =... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
2,147.86 | 1 | 2,147.86 | 23.36 | 3,194.68 | 67.23 | 15.33 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
2,063.52 | 328 | 6.29 | 22.44 | 2,573.07 | 80.20 | 3.42 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
490.55 | 1,495 | 0.33 | 5.33 | 643.87 | 76.19 | 0.58 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
489.05 | 292 | 1.67 | 5.32 | 621.37 | 78.70 | 2.75 | bs6q10hmtbh49 | JDBC Thin Client | select bs.billno, bs.bankflowi... |
223.55 | 1,176 | 0.19 | 2.43 | 310.63 | 71.97 | 0.00 | gyudauqxd8gqc | JDBC Thin Client | select ag.ORGAREA ORGAREA from... |
195.79 | 116 | 1.69 | 2.13 | 281.73 | 69.50 | 0.00 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
130.24 | 174 | 0.75 | 1.42 | 171.04 | 76.14 | 0.00 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
104.26 | 185 | 0.56 | 1.13 | 162.48 | 64.17 | 0.01 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
80.09 | 216 | 0.37 | 0.87 | 106.61 | 75.12 | 0.00 | 25svbmrbjp20g | JDBC Thin Client | select g.airport from agentsal... |
76.42 | 56 | 1.36 | 0.83 | 216.95 | 35.23 | 33.22 | 3af2rnt9q4u9b | JDBC Thin Client | select cd.CCRDNO , cd.item, cd... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
489.71 | 1 | 489.71 | 6.79 | 3,194.68 | 67.23 | 15.33 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
87.95 | 328 | 0.27 | 1.22 | 2,573.07 | 80.20 | 3.42 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
85.71 | 56 | 1.53 | 1.19 | 254.27 | 29.96 | 33.71 | btrs48n39rhcd | JDBC Thin Client | select cd.CCRDNO, cd.item, cd.... |
72.07 | 56 | 1.29 | 1.00 | 216.95 | 35.23 | 33.22 | 3af2rnt9q4u9b | JDBC Thin Client | select cd.CCRDNO , cd.item, cd... |
54.00 | 5 | 10.80 | 0.75 | 108.97 | 35.72 | 49.56 | c6ksc6kfhjjc6 | DBMS_SCHEDULER | with ash_samples as ( SELECT /... |
34.38 | 22 | 1.56 | 0.48 | 118.34 | 55.64 | 29.05 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
21.16 | 10,454 | 0.00 | 0.29 | 32.11 | 4.89 | 65.91 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
17.10 | 292 | 0.06 | 0.24 | 621.37 | 78.70 | 2.75 | bs6q10hmtbh49 | JDBC Thin Client | select bs.billno, bs.bankflowi... |
13.08 | 6 | 2.18 | 0.18 | 63.19 | 59.85 | 20.69 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
8.75 | 10,398 | 0.00 | 0.12 | 27.29 | 6.27 | 32.06 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
192,797,703 | 1 | 192,797,703.00 | 32.94 | 3,194.68 | 67.2 | 15.3 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
189,334,952 | 328 | 577,240.71 | 32.35 | 2,573.07 | 80.2 | 3.4 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
44,649,569 | 1,495 | 29,865.93 | 7.63 | 643.87 | 76.2 | .6 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
25,694,766 | 174 | 147,671.07 | 4.39 | 171.04 | 76.1 | 0 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
16,350,773 | 185 | 88,382.56 | 2.79 | 162.48 | 64.2 | 0 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
13,076,553 | 1,176 | 11,119.52 | 2.23 | 310.63 | 72 | 0 | gyudauqxd8gqc | JDBC Thin Client | select ag.ORGAREA ORGAREA from... |
9,973,943 | 184 | 54,206.21 | 1.70 | 209.18 | 22.9 | .1 | 7qkh5ucsbcqk6 | JDBC Thin Client | select sum(o.seatnum) from ord... |
8,587,368 | 56 | 153,345.86 | 1.47 | 254.27 | 30 | 33.7 | btrs48n39rhcd | JDBC Thin Client | select cd.CCRDNO, cd.item, cd.... |
8,583,693 | 56 | 153,280.23 | 1.47 | 216.95 | 35.2 | 33.2 | 3af2rnt9q4u9b | JDBC Thin Client | select cd.CCRDNO , cd.item, cd... |
8,452,708 | 116 | 72,868.17 | 1.44 | 281.73 | 69.5 | 0 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
6,990,398 | 184 | 37,991.29 | 1.19 | 60.20 | 63 | 0 | 9b2r0p9d97p92 | JDBC Thin Client | select sum(t.seatnum) from ord... |
6,494,289 | 174 | 37,323.50 | 1.11 | 40.91 | 76.8 | .4 | c5jycdptb6cj3 | JDBC Thin Client | select sum(o.seatnum) from ord... |
6,124,940 | 292 | 20,975.82 | 1.05 | 621.37 | 78.7 | 2.8 | bs6q10hmtbh49 | JDBC Thin Client | select bs.billno, bs.bankflowi... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
159,277 | 5 | 31,855.40 | 0.84 | 108.97 | 35.72 | 49.56 | c6ksc6kfhjjc6 | DBMS_SCHEDULER | with ash_samples as ( SELECT /... |
81,811 | 1 | 81,811.00 | 0.43 | 3,194.68 | 67.23 | 15.33 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
19,627 | 328 | 59.84 | 0.10 | 2,573.07 | 80.20 | 3.42 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
12,720 | 22 | 578.18 | 0.07 | 118.34 | 55.64 | 29.05 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
8,187 | 56 | 146.20 | 0.04 | 254.27 | 29.96 | 33.71 | btrs48n39rhcd | JDBC Thin Client | select cd.CCRDNO, cd.item, cd.... |
6,532 | 56 | 116.64 | 0.03 | 216.95 | 35.23 | 33.22 | 3af2rnt9q4u9b | JDBC Thin Client | select cd.CCRDNO , cd.item, cd... |
1,960 | 292 | 6.71 | 0.01 | 621.37 | 78.70 | 2.75 | bs6q10hmtbh49 | JDBC Thin Client | select bs.billno, bs.bankflowi... |
1,526 | 10,454 | 0.15 | 0.01 | 32.11 | 4.89 | 65.91 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
686 | 10,398 | 0.07 | 0.00 | 27.29 | 6.27 | 32.06 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
543 | 12,057 | 0.05 | 0.00 | 40.76 | 6.45 | 20.36 | f4uf0u8q871js | JDBC Thin Client | select min(pt.ticketno) as min... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
68,963 | 68,963 | 1 | 68,963.00 | 0.00 | 4.90 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
19,627 | 19,627 | 328 | 59.84 | 0.00 | 1.39 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
12,527 | 12,527 | 22 | 569.41 | 0.00 | 0.89 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
8,081 | 8,081 | 56 | 144.30 | 0.00 | 0.57 | btrs48n39rhcd | JDBC Thin Client | select cd.CCRDNO, cd.item, cd.... |
1,960 | 1,960 | 292 | 6.71 | 0.00 | 0.14 | bs6q10hmtbh49 | JDBC Thin Client | select bs.billno, bs.bankflowi... |
1,921 | 1,921 | 5 | 384.20 | 0.00 | 0.14 | c6ksc6kfhjjc6 | DBMS_SCHEDULER | with ash_samples as ( SELECT /... |
1,843 | 1,843 | 6 | 307.17 | 0.00 | 0.13 | 8kvgs3007httw | Foglight for Oracle <5.6.4.311> | select /*+ rule */ decode(INST... |
686 | 686 | 10,398 | 0.07 | 0.00 | 0.05 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
543 | 543 | 12,057 | 0.05 | 0.00 | 0.04 | f4uf0u8q871js | JDBC Thin Client | select min(pt.ticketno) as min... |
538 | 538 | 10,483 | 0.05 | 0.00 | 0.04 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
153,573 | 0 | 0.00 | 19.94 | 2.8 | 0 | 4yq6qwgw992zk | JDBC Thin Client | select CABINS from GENERALIZEL... |
105,919 | 105,912 | 1.00 | 37.78 | .7 | 0 | 520mkxqpf15q8 | JDBC Thin Client | select 1 from dual |
105,683 | 0 | 0.00 | 94.01 | 1 | 0 | d4ggk0agny9tf | JDBC Thin Client | SET TRANSACTION READ WRITE |
99,348 | 99,347 | 1.00 | 18.78 | 23.1 | 0 | ftj9uawt4wwzb | select condition from cdef$ wh... | |
25,882 | 25,882 | 1.00 | 2.36 | 3.4 | 0 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
24,008 | 24,008 | 1.00 | 36.35 | 2.8 | 15.9 | 09uaa1krtq5by | JDBC Thin Client | select f.agentfeereturntype fr... |
16,252 | 0 | 0.00 | 1.93 | 1.6 | 0 | 4xcfs63ggs8m0 | JDBC Thin Client | select CABINS from GENERALIZEL... |
15,149 | 15,149 | 1.00 | 1.67 | 25.8 | 3.2 | 2jfqzrxhrm93b | select /*+ rule */ c.name, u.n... | |
14,759 | 14,759 | 1.00 | 2.18 | 2.3 | 0 | 87tu7wk540dwq | JDBC Thin Client | select MAX_THREAD_COUNT from p... |
12,990 | 12,989 | 1.00 | 4.05 | 5.4 | 0 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
153,445 | 153,573 | 10.43 | 4yq6qwgw992zk | JDBC Thin Client | select CABINS from GENERALIZEL... |
105,907 | 105,919 | 7.20 | 520mkxqpf15q8 | JDBC Thin Client | select 1 from dual |
105,680 | 105,683 | 7.18 | d4ggk0agny9tf | JDBC Thin Client | SET TRANSACTION READ WRITE |
99,346 | 99,348 | 6.75 | ftj9uawt4wwzb | select condition from cdef$ wh... | |
25,879 | 25,882 | 1.76 | bunvx480ynf57 | JDBC Thin Client | SELECT 1 FROM DUAL |
16,240 | 16,252 | 1.10 | 4xcfs63ggs8m0 | JDBC Thin Client | select CABINS from GENERALIZEL... |
15,149 | 15,149 | 1.03 | 2jfqzrxhrm93b | select /*+ rule */ c.name, u.n... | |
14,759 | 14,759 | 1.00 | 87tu7wk540dwq | JDBC Thin Client | select MAX_THREAD_COUNT from p... |
12,959 | 12,990 | 0.88 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
12,058 | 12,058 | 0.82 | 5f0955qkz78g4 | JDBC Thin Client | select DOMESTICINDICATE from o... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
16,063,462 | 55 | 0.18 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
8,896,671 | 55 | 0.10 | 89nf3yvxk8yq7 | Foglight for Oracle <5.6.4.311> | select /*+ rule */ rownum, sid... |
2,912,279 | 11 | 0.03 | 21dnq66bcztyr | Foglight for Oracle <5.5.8.127> | select (jj.act_jobs_jobs + js.... |
1,632,209 | 1,122 | 0.02 | 8swypbbr0m372 | select order#, columns, types ... | |
1,561,372 | 9 | 0.02 | am19a1bvysghh | Foglight for Oracle <5.6.4.311> | select (jj.act_jobs_jobs + js.... |
1,075,065 | 32 | 0.01 | 9nz14w8x5fsfd | JDBC Thin Client | BEGIN PROCESSORDER.CallBackByB... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
109 | 55 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
45 | 6 | bt51szvfrcdpn | JDBC Thin Client | SELECT obj_type, plan_id, comp... |
36 | 1,683 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
36 | 1,683 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
34 | 2,790 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... | |
30 | 153 | 56h11bx91nk74 | select limit# from profile$ wh... | |
28 | 55 | 89nf3yvxk8yq7 | Foglight for Oracle <5.6.4.311> | select /*+ rule */ rownum, sid... |
28 | 1,122 | 8swypbbr0m372 | select order#, columns, types ... | |
24 | 32 | 9nz14w8x5fsfd | JDBC Thin Client | BEGIN PROCESSORDER.CallBackByB... |
23 | 2,487 | 5n1fs4m2n2y0r | select pos#, intcol#, col#, sp... | |
23 | 4 | 69subccxd9b03 | JDBC Thin Client | SELECT signature, inuse_featur... |
23 | 2,369 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
21 | 768 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
21 | 768 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... |
Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
191.09 | 450 | 4.39 | 1,429.48 | 13.37 | 0.02 | 0.00 | 5ansr7r9htpq3 | update undo$ set name=:2, file... | |
146.59 | 184 | 3.36 | 209.18 | 70.08 | 22.92 | 0.09 | 7qkh5ucsbcqk6 | JDBC Thin Client | select sum(o.seatnum) from ord... |
115.68 | 1 | 2.66 | 3,194.68 | 3.62 | 67.23 | 15.33 | 6mcpb06rctk0x | DBMS_SCHEDULER | call dbms_space.auto_space_adv... |
38.02 | 10,483 | 0.87 | 52.17 | 72.89 | 1.65 | 14.65 | 81h1tf5rjb8jr | JDBC Thin Client | select pt.segorder, p.type, co... |
33.87 | 12,058 | 0.78 | 46.89 | 72.22 | 1.98 | 6.26 | bhwz3x2mjy7s3 | JDBC Thin Client | SELECT PL.PNRNO FROM PNRLIST P... |
31.70 | 185 | 0.73 | 162.48 | 19.51 | 64.17 | 0.01 | 2ggs3r1ncmwwr | JDBC Thin Client | select count(*) as recordscoun... |
30.09 | 56 | 0.69 | 254.27 | 11.83 | 29.96 | 33.71 | btrs48n39rhcd | JDBC Thin Client | select cd.CCRDNO, cd.item, cd.... |
25.38 | 56 | 0.58 | 216.95 | 11.70 | 35.23 | 33.22 | 3af2rnt9q4u9b | JDBC Thin Client | select cd.CCRDNO , cd.item, cd... |
24.05 | 116 | 0.55 | 281.73 | 8.54 | 69.50 | 0.00 | dugh7uyrn80b4 | JDBC Thin Client | select * from( select /*+ inde... |
20.86 | 12,057 | 0.48 | 40.76 | 51.16 | 6.45 | 20.36 | f4uf0u8q871js | JDBC Thin Client | select min(pt.ticketno) as min... |
14.31 | 328 | 0.33 | 2,573.07 | 0.56 | 80.20 | 3.42 | 9q7k9nbpvk8pv | DBMS_SCHEDULER | SELECT NVL(SUM(TIME_WAITED/100... |
13.27 | 24,008 | 0.30 | 36.35 | 36.52 | 2.81 | 15.93 | 09uaa1krtq5by | JDBC Thin Client | select f.agentfeereturntype fr... |
12.71 | 10,437 | 0.29 | 39.39 | 32.27 | 2.95 | 18.68 | 6u1fc9nj87uhd | JDBC Thin Client | SELECT S.SEGORDER, (S.CARRIER ... |
8.64 | 184 | 0.20 | 60.20 | 14.36 | 63.04 | 0.00 | 9b2r0p9d97p92 | JDBC Thin Client | select sum(t.seatnum) from ord... |
8.36 | 12,058 | 0.19 | 11.99 | 69.70 | 6.34 | 9.72 | 5f0955qkz78g4 | JDBC Thin Client | select DOMESTICINDICATE from o... |
7.90 | 10,398 | 0.18 | 27.29 | 28.96 | 6.27 | 32.06 | 9nztpwka2vvp4 | JDBC Thin Client | SELECT SP.ORDERNO, SP.SEGORDER... |
7.60 | 2,100 | 0.17 | 1,742.44 | 0.44 | 0.05 | 0.00 | 7jk3kcjxvz83k | JDBC Thin Client | UPDATE PAYBILL SET PAYSTATUS =... |
7.34 | 1,495 | 0.17 | 643.87 | 1.14 | 76.19 | 0.58 | 0a1z1knkykfwz | JDBC Thin Client | select p.psgname, p.pnrno, (se... |
6.93 | 1,203 | 0.16 | 3,763.54 | 0.18 | 0.05 | 0.06 | 7ncnu7ud2ykhu | JDBC Thin Client | insert into ORDERS (domesticin... |
5.09 | 10,454 | 0.12 | 32.11 | 15.84 | 4.89 | 65.91 | 1ugz7d875p582 | JDBC Thin Client | select o.paymode, pb.paystatus... |
4.88 | 174 | 0.11 | 56.07 | 8.71 | 70.14 | 0.01 | 52ngpnc7n319u | JDBC Thin Client | select count(*) from orders o ... |
4.74 | 5 | 0.11 | 108.97 | 4.35 | 35.72 | 49.56 | c6ksc6kfhjjc6 | DBMS_SCHEDULER | with ash_samples as ( SELECT /... |
4.47 | 4 | 0.10 | 1,181.69 | 0.38 | 0.10 | 0.09 | ckh0xnga85szg | JDBC Thin Client | select * from ( select /*+USE_... |
3.53 | 12,058 | 0.08 | 16.90 | 20.85 | 3.25 | 0.06 | a7pqvnr44uy38 | JDBC Thin Client | SELECT HO.PAYMONEY, HO.HOTELOR... |
3.47 | 3 | 0.08 | 1,636.55 | 0.21 | 0.13 | 0.10 | 5q9n2yy5aj6hv | JDBC Thin Client | select count(*) as orderstatus... |
3.05 | 6 | 0.07 | 63.19 | 4.83 | 59.85 | 20.69 | 3bf7cptakrtga | JDBC Thin Client | select p.orderno from passenge... |
2.99 | 22 | 0.07 | 118.34 | 2.53 | 55.64 | 29.05 | 73fhvwt6xvk2x | JDBC Thin Client | select distinct pi.orderno fro... |
2.97 | 184 | 0.07 | 58.20 | 5.11 | 71.51 | 0.00 | 67jr1q3uanf6w | JDBC Thin Client | select count(*) from orders o ... |
2.89 | 12,095 | 0.07 | 5.74 | 50.30 | 12.19 | 0.00 | bhvwd3sbwdyga | JDBC Thin Client | select f.isautoconfirm from fl... |
2.62 | 10,483 | 0.06 | 6.50 | 40.33 | 7.54 | 0.00 | 5s3uwrd1gxt7q | JDBC Thin Client | SELECT NVL(AG.AGENTTYPE, OU1.F... |
2.60 | 9,201 | 0.06 | 3.84 | 67.68 | 9.10 | 0.00 | 95bdypfq2ky5g | JDBC Thin Client | select o.domesticindicate from... |
2.60 | 174 | 0.06 | 171.04 | 1.52 | 76.14 | 0.00 | 58z173u8h1kxc | JDBC Thin Client | select count(*) as recordscoun... |
2.55 | 10,483 | 0.06 | 4.06 | 62.86 | 12.06 | 0.00 | 9tzrcb1d5f06z | JDBC Thin Client | SELECT O.ORDERNO, O.GROUPFLAG,... |
2.23 | 12,990 | 0.05 | 4.05 | 55.02 | 5.43 | 0.00 | 2dqj3rc7b0x8q | JDBC Thin Client | select o.Isautocreate from ord... |
2.22 | 10,483 | 0.05 | 12.37 | 17.94 | 5.09 | 14.05 | 90yfsh8rb8gma | JDBC Thin Client | select p.TYPE from paxinsuranc... |
2.21 | 10,483 | 0.05 | 7.57 | 29.12 | 2.90 | 0.00 | 78txh8n821266 | JDBC Thin Client | select 1 from dual where exist... |
1.98 | 3 | 0.05 | 1,291.69 | 0.15 | 0.12 | 0.00 | 7qwgyfxhnaxna | JDBC Thin Client | select originalorderno from or... |
1.97 | 768 | 0.05 | 3.15 | 62.50 | 2.54 | 21.57 | 1gu8t96d0bdmu | select t.ts#, t.file#, t.block... | |
1.74 | 4 | 0.04 | 1,271.26 | 0.14 | 0.01 | 0.00 | 83bank242m66q | JDBC Thin Client | select o.campaignscriptid from... |
1.55 | 8 | 0.04 | 2.43 | 63.88 | 11.09 | 13.76 | fmbv2fxj0mwuy | DECLARE job BINARY_INTEGER := ... | |
1.46 | 10,439 | 0.03 | 2.60 | 56.06 | 12.29 | 0.00 | 8whvjha2fnk63 | JDBC Thin Client | SELECT F.TOTALPRICE, F.AGENTFE... |
1.44 | 174 | 0.03 | 40.91 | 3.51 | 76.76 | 0.43 | c5jycdptb6cj3 | JDBC Thin Client | select sum(o.seatnum) from ord... |
1.40 | 12,057 | 0.03 | 2.60 | 53.68 | 5.76 | 0.00 | ckg1n91hh2qkk | JDBC Thin Client | select o.pricefileno from flig... |
1.18 | 10,483 | 0.03 | 2.43 | 48.64 | 5.77 | 0.00 | g128myz1mz13n | JDBC Thin Client | select 1 from dual where exist... |
1.05 | 1,719 | 0.02 | 3.20 | 32.63 | 20.60 | 0.83 | fr6m3gyy3gwk7 | JDBC Thin Client | UPDATE PNRLIST SET TICKETFLAG ... |
1.02 | 1,532 | 0.02 | 1,666.52 | 0.06 | 0.13 | 0.00 | ab5gtgnqyskp7 | JDBC Thin Client | select o.campaignscriptid from... |
0.65 | 1,557 | 0.01 | 1,800.00 | 0.04 | 0.15 | 0.00 | 6wytwy7ry0jsb | JDBC Thin Client | UPDATE ORDERS SET TICKETOUTAGE... |
0.61 | 14 | 0.01 | 0.71 | 85.65 | 11.21 | 0.01 | buzp8cfu6upry | JDBC Thin Client | SELECT C.CHANGENO, C.ORDERNO, ... |
0.56 | 3 | 0.01 | 1,114.04 | 0.05 | 0.10 | 0.00 | 04havy07x2m26 | JDBC Thin Client | select count(*) as changestatu... |
0.48 | 8 | 0.01 | 0.73 | 66.20 | 20.68 | 0.00 | 74mb2gqrm9xb6 | JDBC Thin Client | select c.refaction, c.basiccon... |
0.47 | 1,172 | 0.01 | 0.63 | 75.11 | 0.00 | 11.28 | 87gaftwrm2h68 | select o.owner#, o.name, o.nam... | |
0.42 | 15 | 0.01 | 0.79 | 53.30 | 18.94 | 0.01 | 14abfzpgc5vkt | JDBC Thin Client | select c.refaction, c.basiccon... |
0.42 | 22 | 0.01 | 81.71 | 0.52 | 81.26 | 0.00 | d6fwfwn6jjbsb | JDBC Thin Client | select distinct pi.orderno, o.... |
0.35 | 32 | 0.01 | 0.92 | 37.96 | 41.21 | 1.04 | 9nz14w8x5fsfd | JDBC Thin Client | BEGIN PROCESSORDER.CallBackByB... |
0.33 | 1,683 | 0.01 | 32.97 | 1.01 | 1.76 | 2.00 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
0.28 | 48 | 0.01 | 0.84 | 32.74 | 11.86 | 0.21 | 8zr60wpvdvbtu | JDBC Thin Client | select /*+index(orders IDX_CR... |
0.25 | 2,487 | 0.01 | 0.54 | 45.59 | 16.66 | 0.01 | 5n1fs4m2n2y0r | select pos#, intcol#, col#, sp... | |
0.23 | 183 | 0.01 | 3.40 | 6.82 | 45.03 | 0.00 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
0.20 | 1,122 | 0.00 | 1.14 | 17.73 | 9.61 | 57.35 | 8swypbbr0m372 | select order#, columns, types ... | |
0.14 | 2,369 | 0.00 | 1.98 | 7.03 | 30.31 | 37.18 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
0.09 | 55 | 0.00 | 119.47 | 0.07 | 60.25 | 0.01 | b0d1f3vqvdca7 | Foglight for Oracle <5.5.8.127> | select /*+ rule */ rownum, sid... |
0.07 | 11 | 0.00 | 33.81 | 0.21 | 22.60 | 0.01 | 21dnq66bcztyr | Foglight for Oracle <5.5.8.127> | select (jj.act_jobs_jobs + js.... |
0.03 | 4 | 0.00 | 332.71 | 0.01 | 0.05 | 0.00 | 5wsn90a3fjnmj | JDBC Thin Client | UPDATE batchpay b SET b.pnrval... |
0.03 | 1,176 | 0.00 | 310.63 | 0.01 | 71.97 | 0.00 | gyudauqxd8gqc | JDBC Thin Client | select ag.ORGAREA ORGAREA from... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 8,398 | 2.33 | 0.04 |
Batched IO (full) vector count | 8,713 | 2.41 | 0.05 |
Batched IO (space) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 206,362 | 57.18 | 1.10 |
Batched IO buffer defrag count | 677 | 0.19 | 0.00 |
Batched IO double miss count | 23,564 | 6.53 | 0.13 |
Batched IO same unit count | 49,572 | 13.74 | 0.26 |
Batched IO single block count | 15,000 | 4.16 | 0.08 |
Batched IO slow jump count | 4,499 | 1.25 | 0.02 |
Batched IO vector block count | 149,656 | 41.47 | 0.80 |
Batched IO vector read count | 4,207 | 1.17 | 0.02 |
Block Cleanout Optim referenced | 3,161 | 0.88 | 0.02 |
CCursor + sql area evicted | 3,233 | 0.90 | 0.02 |
CPU used by this session | 860,457 | 238.42 | 4.59 |
CPU used when call started | 540,454 | 149.75 | 2.88 |
CR blocks created | 31,316 | 8.68 | 0.17 |
Cached Commit SCN referenced | 581,589 | 161.15 | 3.10 |
Clusterwide global transactions | 16 | 0.00 | 0.00 |
Clusterwide global transactions spanning RAC nodes | 0 | 0.00 | 0.00 |
Commit SCN cached | 10,260 | 2.84 | 0.05 |
DB time | 27,813,417 | 7,706.64 | 148.22 |
DBWR checkpoint buffers written | 61,143 | 16.94 | 0.33 |
DBWR checkpoints | 142 | 0.04 | 0.00 |
DBWR fusion writes | 19,830 | 5.49 | 0.11 |
DBWR object drop buffers written | 207 | 0.06 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 1,737 | 0.48 | 0.01 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 1,062 | 0.29 | 0.01 |
DBWR undo block writes | 42,121 | 11.67 | 0.22 |
DFO trees parallelized | 798 | 0.22 | 0.00 |
DX/BB enqueue lock background get time | 14 | 0.00 | 0.00 |
DX/BB enqueue lock background gets | 32 | 0.01 | 0.00 |
DX/BB enqueue lock foreground requests | 293 | 0.08 | 0.00 |
DX/BB enqueue lock foreground wait time | 14 | 0.00 | 0.00 |
Effective IO time | 456,636,087 | 126,526.27 | 2,433.38 |
GTX processes spawned by autotune | 0 | 0.00 | 0.00 |
GTX processes stopped by autotune | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 350,283 | 97.06 | 1.87 |
HSC IDL Compressed Blocks | 10,280 | 2.85 | 0.05 |
Heap Segment Array Inserts | 5,540 | 1.54 | 0.03 |
LOB table id lookup cache misses | 3 | 0.00 | 0.00 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
Number of read IOs issued | 58,504 | 16.21 | 0.31 |
PX local messages recv'd | 7,503 | 2.08 | 0.04 |
PX local messages sent | 7,503 | 2.08 | 0.04 |
PX remote messages recv'd | 6,993 | 1.94 | 0.04 |
PX remote messages sent | 2,518 | 0.70 | 0.01 |
Parallel operations not downgraded | 832 | 0.23 | 0.00 |
RowCR - row contention | 871 | 0.24 | 0.00 |
RowCR attempts | 119,402 | 33.08 | 0.64 |
RowCR hits | 175,400 | 48.60 | 0.93 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 17 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 5,032,219 | 1,394.34 | 26.82 |
SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 |
active txn count during cleanout | 88,679 | 24.57 | 0.47 |
application wait time | 163,872 | 45.41 | 0.87 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 45,314 | 12.56 | 0.24 |
branch node splits | 10 | 0.00 | 0.00 |
buffer is not pinned count | 395,940,462 | 109,708.52 | 2,109.94 |
buffer is pinned count | 2,626,739,530 | 727,825.86 | 13,997.71 |
bytes received via SQL*Net from client | 399,822,877 | 110,784.27 | 2,130.63 |
bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 |
bytes sent via SQL*Net to client | 575,775,729 | 159,537.88 | 3,068.27 |
bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 |
calls to get snapshot scn: kcmgss | 1,965,949 | 544.73 | 10.48 |
calls to kcmgas | 627,556 | 173.89 | 3.34 |
calls to kcmgcs | 304,015 | 84.24 | 1.62 |
cell physical IO interconnect bytes | 157,821,641,216 | 43,729,753.16 | 841,020.18 |
change write time | 2,608 | 0.72 | 0.01 |
cleanout - number of ktugct calls | 50,268 | 13.93 | 0.27 |
cleanouts and rollbacks - consistent read gets | 27,702 | 7.68 | 0.15 |
cleanouts only - consistent read gets | 10,335 | 2.86 | 0.06 |
cluster key scan block gets | 189,386 | 52.48 | 1.01 |
cluster key scans | 127,263 | 35.26 | 0.68 |
cluster wait time | 435,640 | 120.71 | 2.32 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 30,304 | 8.40 | 0.16 |
commit batch/immediate requested | 30,304 | 8.40 | 0.16 |
commit cleanout failures: block lost | 2,427 | 0.67 | 0.01 |
commit cleanout failures: buffer being written | 7 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 2,108 | 0.58 | 0.01 |
commit cleanout failures: cannot pin | 405 | 0.11 | 0.00 |
commit cleanouts | 316,321 | 87.65 | 1.69 |
commit cleanouts successfully completed | 311,374 | 86.28 | 1.66 |
commit immediate performed | 30,304 | 8.40 | 0.16 |
commit immediate requested | 30,304 | 8.40 | 0.16 |
commit txn count during cleanout | 74,874 | 20.75 | 0.40 |
concurrency wait time | 24,480,511 | 6,783.14 | 130.45 |
consistent changes | 189,635 | 52.54 | 1.01 |
consistent gets | 582,807,476 | 161,486.26 | 3,105.74 |
consistent gets - examination | 23,295,100 | 6,454.68 | 124.14 |
consistent gets direct | 7,394,756 | 2,048.96 | 39.41 |
consistent gets from cache | 575,412,712 | 159,437.30 | 3,066.33 |
consistent gets from cache (fastpath) | 546,227,385 | 151,350.53 | 2,910.81 |
cursor authentications | 29,216 | 8.10 | 0.16 |
data blocks consistent reads - undo records applied | 86,586 | 23.99 | 0.46 |
db block changes | 1,928,183 | 534.27 | 10.28 |
db block gets | 2,463,964 | 682.72 | 13.13 |
db block gets direct | 24,148 | 6.69 | 0.13 |
db block gets from cache | 2,439,816 | 676.03 | 13.00 |
db block gets from cache (fastpath) | 579,645 | 160.61 | 3.09 |
deferred (CURRENT) block cleanout applications | 96,892 | 26.85 | 0.52 |
dirty buffers inspected | 11,417 | 3.16 | 0.06 |
enqueue conversions | 21,671 | 6.00 | 0.12 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 1,232,526 | 341.51 | 6.57 |
enqueue requests | 1,234,446 | 342.04 | 6.58 |
enqueue timeouts | 1,675 | 0.46 | 0.01 |
enqueue waits | 4,969 | 1.38 | 0.03 |
exchange deadlocks | 791 | 0.22 | 0.00 |
execute count | 1,873,145 | 519.02 | 9.98 |
failed probes on index block reclamation | 3 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 7,120,899,129 | 1,973,082.77 | 37,946.76 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 12,050,042 | 3,338.87 | 64.21 |
free buffer requested | 12,252,949 | 3,395.09 | 65.30 |
gc blocks compressed | 176,831 | 49.00 | 0.94 |
gc blocks lost | 1 | 0.00 | 0.00 |
gc cr block flush time | 7,700 | 2.13 | 0.04 |
gc cr block receive time | 116,333 | 32.23 | 0.62 |
gc cr blocks received | 165,682 | 45.91 | 0.88 |
gc cr blocks served | 149,312 | 41.37 | 0.80 |
gc current block flush time | 1,474 | 0.41 | 0.01 |
gc current block pin time | 1,589 | 0.44 | 0.01 |
gc current block receive time | 142,991 | 39.62 | 0.76 |
gc current blocks received | 471,421 | 130.62 | 2.51 |
gc current blocks served | 225,473 | 62.47 | 1.20 |
gc kbytes saved | 526,155 | 145.79 | 2.80 |
gc kbytes sent | 2,472,116 | 684.98 | 13.17 |
gc local grants | 10,677,452 | 2,958.54 | 56.90 |
gc remote grants | 900,438 | 249.50 | 4.80 |
gcs messages sent | 2,640,237 | 731.57 | 14.07 |
ges messages sent | 140,077 | 38.81 | 0.75 |
global enqueue get time | 18,255,871 | 5,058.40 | 97.28 |
global enqueue gets async | 26,733 | 7.41 | 0.14 |
global enqueue gets sync | 2,069,190 | 573.34 | 11.03 |
global enqueue releases | 2,065,191 | 572.23 | 11.01 |
heap block compress | 4,937 | 1.37 | 0.03 |
hot buffers moved to head of LRU | 3,321,922 | 920.45 | 17.70 |
immediate (CR) block cleanout applications | 38,039 | 10.54 | 0.20 |
immediate (CURRENT) block cleanout applications | 26,738 | 7.41 | 0.14 |
index crx upgrade (positioned) | 177 | 0.05 | 0.00 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 5,261 | 1.46 | 0.03 |
index fetch by key | 13,922,471 | 3,857.69 | 74.19 |
index scans kdiixs1 | 113,335,042 | 31,403.26 | 603.95 |
leaf node 90-10 splits | 394 | 0.11 | 0.00 |
leaf node splits | 1,772 | 0.49 | 0.01 |
lob reads | 22,189 | 6.15 | 0.12 |
lob writes | 21,142 | 5.86 | 0.11 |
lob writes unaligned | 21,142 | 5.86 | 0.11 |
logons cumulative | 2,609 | 0.72 | 0.01 |
max cf enq hold time | 15 | 0.00 | 0.00 |
messages received | 230,694 | 63.92 | 1.23 |
messages sent | 230,692 | 63.92 | 1.23 |
min active SCN optimization applied on CR | 12,964 | 3.59 | 0.07 |
no buffer to keep pinned count | 1,292 | 0.36 | 0.01 |
no work - consistent read gets | 557,765,121 | 154,547.44 | 2,972.29 |
non-idle wait count | 16,809,745 | 4,657.70 | 89.58 |
non-idle wait time | 26,755,123 | 7,413.40 | 142.58 |
opened cursors cumulative | 1,856,187 | 514.32 | 9.89 |
parse count (describe) | 80 | 0.02 | 0.00 |
parse count (failures) | 2,713 | 0.75 | 0.01 |
parse count (hard) | 181,422 | 50.27 | 0.97 |
parse count (total) | 1,471,425 | 407.71 | 7.84 |
parse time cpu | 65,238 | 18.08 | 0.35 |
parse time elapsed | 22,706,043 | 6,291.47 | 121.00 |
physical read IO requests | 1,407,675 | 390.04 | 7.50 |
physical read bytes | 154,664,296,448 | 42,854,905.41 | 824,194.91 |
physical read total IO requests | 1,448,535 | 401.36 | 7.72 |
physical read total bytes | 155,749,903,360 | 43,155,709.04 | 829,980.03 |
physical read total multi block requests | 145,453 | 40.30 | 0.78 |
physical reads | 18,879,919 | 5,231.31 | 100.61 |
physical reads cache | 11,484,803 | 3,182.25 | 61.20 |
physical reads cache prefetch | 10,382,960 | 2,876.95 | 55.33 |
physical reads direct | 7,395,116 | 2,049.06 | 39.41 |
physical reads direct (lob) | 57 | 0.02 | 0.00 |
physical reads direct temporary tablespace | 360 | 0.10 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 56,992 | 15.79 | 0.30 |
physical write bytes | 1,068,777,472 | 296,140.47 | 5,695.44 |
physical write total IO requests | 206,010 | 57.08 | 1.10 |
physical write total bytes | 2,071,737,856 | 574,044.12 | 11,040.14 |
physical write total multi block requests | 3,555 | 0.99 | 0.02 |
physical writes | 130,466 | 36.15 | 0.70 |
physical writes direct | 24,508 | 6.79 | 0.13 |
physical writes direct (lob) | 63 | 0.02 | 0.00 |
physical writes direct temporary tablespace | 14,077 | 3.90 | 0.08 |
physical writes from cache | 105,958 | 29.36 | 0.56 |
physical writes non checkpoint | 108,656 | 30.11 | 0.58 |
pinned buffers inspected | 538 | 0.15 | 0.00 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1,385,663 | 383.94 | 7.38 |
process last non-idle time | 3,601 | 1.00 | 0.02 |
queries parallelized | 679 | 0.19 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 3,251,237 | 900.86 | 17.33 |
recursive cpu usage | 366,098 | 101.44 | 1.95 |
redo KB read | 446,714 | 123.78 | 2.38 |
redo blocks checksummed by FG (exclusive) | 101,011 | 27.99 | 0.54 |
redo blocks written | 743,743 | 206.08 | 3.96 |
redo buffer allocation retries | 4 | 0.00 | 0.00 |
redo entries | 1,040,517 | 288.31 | 5.54 |
redo log space requests | 5 | 0.00 | 0.00 |
redo log space wait time | 14 | 0.00 | 0.00 |
redo ordering marks | 41,502 | 11.50 | 0.22 |
redo size | 331,664,036 | 91,898.59 | 1,767.41 |
redo size for direct writes | 9,002,328 | 2,494.40 | 47.97 |
redo subscn max counts | 8,142 | 2.26 | 0.04 |
redo synch long waits | 25,055 | 6.94 | 0.13 |
redo synch time | 123,381 | 34.19 | 0.66 |
redo synch time (usec) | 1,233,929,845 | 341,901.45 | 6,575.52 |
redo synch writes | 85,821 | 23.78 | 0.46 |
redo wastage | 36,854,356 | 10,211.73 | 196.39 |
redo write broadcast ack count | 67,809 | 18.79 | 0.36 |
redo write broadcast ack time | 166,052,603 | 46,010.42 | 884.88 |
redo write broadcast lgwr post count | 6 | 0.00 | 0.00 |
redo write time | 37,556 | 10.41 | 0.20 |
redo writes | 137,326 | 38.05 | 0.73 |
remote Oradebug requests | 2 | 0.00 | 0.00 |
rollback changes - undo records applied | 57,341 | 15.89 | 0.31 |
rollbacks only - consistent read gets | 5,054 | 1.40 | 0.03 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 2,327,270 | 644.85 | 12.40 |
scheduler wait time | 483,092 | 133.86 | 2.57 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 574,724 | 159.25 | 3.06 |
session logical reads | 585,271,612 | 162,169.03 | 3,118.87 |
shared hash latch upgrades - no wait | 1,384,504 | 383.62 | 7.38 |
shared hash latch upgrades - wait | 1,343 | 0.37 | 0.01 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 2,121,094 | 587.72 | 11.30 |
sorts (rows) | 247,241,831 | 68,506.60 | 1,317.53 |
sql area evicted | 155,262 | 43.02 | 0.83 |
sql area purged | 2,313 | 0.64 | 0.01 |
summed dirty queue length | 13,834 | 3.83 | 0.07 |
switch current to new buffer | 16,128 | 4.47 | 0.09 |
table fetch by rowid | 1,446,745,530 | 400,869.14 | 7,709.60 |
table fetch continued row | 1,123,295 | 311.25 | 5.99 |
table scan blocks gotten | 151,893,785 | 42,087.24 | 809.43 |
table scan rows gotten | 12,220,678,907 | 3,386,146.97 | 65,123.12 |
table scans (cache partitions) | 0 | 0.00 | 0.00 |
table scans (direct read) | 61 | 0.02 | 0.00 |
table scans (long tables) | 410 | 0.11 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 128,222 | 35.53 | 0.68 |
temp space allocated (bytes) | 5,242,880 | 1,452.71 | 27.94 |
total cf enq hold time | 7,535 | 2.09 | 0.04 |
total number of cf enq holders | 375 | 0.10 | 0.00 |
total number of slots | 0 | 0.00 | 0.00 |
total number of times SMON posted | 755 | 0.21 | 0.00 |
transaction lock background gets | 450 | 0.12 | 0.00 |
transaction lock foreground requests | 450 | 0.12 | 0.00 |
transaction lock foreground wait time | 66 | 0.02 | 0.00 |
transaction rollbacks | 30,135 | 8.35 | 0.16 |
transaction tables consistent read rollbacks | 12 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 298 | 0.08 | 0.00 |
undo change vector size | 114,458,672 | 31,714.60 | 609.94 |
user I/O wait time | 721,578 | 199.94 | 3.85 |
user calls | 5,543,534 | 1,536.02 | 29.54 |
user commits | 58,567 | 16.23 | 0.31 |
user rollbacks | 129,088 | 35.77 | 0.69 |
workarea executions - onepass | 4 | 0.00 | 0.00 |
workarea executions - optimal | 1,513,090 | 419.25 | 8.06 |
write clones created in background | 1 | 0.00 | 0.00 |
write clones created in foreground | 22 | 0.01 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 378,553,070,208 | 379,508,273,712 |
session cursor cache count | 31,506,371 | 31,535,369 |
session uga memory | 279,034,938,040,344 | 279,206,950,168,384 |
opened cursors current | 3,673 | 5,221 |
workarea memory allocated | 3,929 | 2,428 |
logons current | 559 | 818 |
session uga memory max | 3,512,199,929,552 | 3,519,418,778,536 |
session pga memory | 281,321,954,688 | 282,266,448,016 |
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) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 87.5G | 373.71 | 24.8272 | 0M | 0.00 | 0M | 1101.4K | 5.69 |
Direct Reads | 56.4G | 16.21 | 16.0004 | 1M | 0.00 | .000277 | 0 | |
Others | 1G | 11.33 | .287058 | 630M | 2.98 | .174562 | 45.5K | 2.69 |
DBWR | 0M | 0.00 | 0M | 830M | 15.54 | .229979 | 0 | |
LGWR | 0M | 0.00 | 0M | 363M | 38.37 | .100581 | 137.3K | 2.26 |
Direct Writes | 0M | 0.00 | 0M | 155M | 0.20 | .042947 | 0 | |
TOTAL: | 144.9G | 401.25 | 41.1147 | 1.9G | 57.09 | .548348 | 1284.3K | 5.22 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 143.7G | 391.00 | 40.7772 | 914M | 15.66 | .253254 | 3.62 | 36.76 |
Log File | 437M | 0.12 | .121085 | 362M | 38.36 | .100304 | 20.00 | 42.15 |
Control File | 566M | 10.02 | .156829 | 157M | 2.78 | .043502 | 2.74 | 176.00 |
Archive Log | 0M | 0.00 | 0M | 436M | 0.12 | .120808 | ||
Temp File | 190M | 0.09 | .052645 | 110M | 0.14 | .030479 | 10.41 | 15.43 |
Other | 0M | 0.01 | 0M | 0M | 0.02 | 0M | 0.08 | |
TOTAL: | 144.9G | 401.24 | 41.1078 | 1.9G | 57.09 | .548348 | 3.59 | 36.75 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Buffer Cache Reads | 87.5G | 373.67 | 24.8161 | 0M | 0.00 | 0M | 1095.9K | 5.62 |
Buffer Cache Reads (Data File) | 87.5G | 373.67 | 24.8161 | 0M | 0.00 | 0M | 1095.9K | 5.62 |
Direct Reads | 56.3G | 16.17 | 15.9633 | 1M | 0.00 | .000277 | 0 | |
Direct Reads (Data File) | 56.3G | 16.17 | 15.9633 | 1M | 0.00 | .000277 | 0 | |
Others | 1G | 11.32 | .287058 | 630M | 2.97 | .174562 | 40.4K | 2.69 |
Others (Control File) | 566M | 10.02 | .156829 | 157M | 2.78 | .043502 | 36.2K | 2.75 |
Others (Archive Log) | 0M | 0.00 | 0M | 436M | 0.12 | .120808 | 0 | |
Others (Log File) | 436M | 0.12 | .120808 | 0M | 0.00 | 0M | 4 | 29.75 |
Others (Data File) | 34M | 1.18 | .009420 | 37M | 0.07 | .010252 | 4269 | 2.14 |
DBWR | 0M | 0.00 | 0M | 830M | 15.54 | .229979 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 830M | 15.54 | .229979 | 0 | |
LGWR | 0M | 0.00 | 0M | 363M | 38.37 | .100581 | 19 | 1.58 |
LGWR (Log File) | 0M | 0.00 | 0M | 362M | 38.36 | .100304 | 4 | 0.75 |
LGWR (Control File) | 0M | 0.00 | 0M | 1M | 0.01 | .000277 | 15 | 1.80 |
Direct Writes | 0M | 0.00 | 0M | 155M | 0.20 | .042947 | 0 | |
Direct Writes (Data File) | 0M | 0.00 | 0M | 155M | 0.20 | .042947 | 0 | |
TOTAL: | 144.7G | 401.17 | 41.0665 | 1.9G | 57.07 | .548348 | 1136.3K | 5.51 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
COREDATA | 937,315 | 260 | 4.09 | 18.79 | 19,728 | 5 | 75,251 | 4.19 |
CORE_INDEX | 164,226 | 46 | 6.92 | 1.37 | 16,134 | 4 | 3,503 | 164.10 |
USERS | 160,301 | 44 | 5.94 | 3.94 | 8,641 | 2 | 1,131 | 182.51 |
SYSAUX | 107,678 | 30 | 3.99 | 3.26 | 4,822 | 1 | 0 | 0.00 |
SYSTEM | 27,176 | 8 | 2.90 | 1.09 | 1,246 | 0 | 1,939 | 688.61 |
QUEST | 5,056 | 1 | 2.95 | 1.30 | 1,412 | 0 | 0 | 0.00 |
UNDOTBS1 | 365 | 0 | 12.79 | 1.00 | 4,522 | 1 | 106 | 1.51 |
AMSDATA | 2,625 | 1 | 2.03 | 1.00 | 0 | 0 | 0 | 0.00 |
ETS_TMP | 2,292 | 1 | 3.24 | 1.00 | 0 | 0 | 0 | 0.00 |
TEMP | 271 | 0 | 13.47 | 89.23 | 516 | 0 | 0 | 0.00 |
UNDOTBS2 | 101 | 0 | 4.65 | 1.00 | 0 | 0 | 3,350 | 12.05 |
AMSINDEX | 34 | 0 | 2.94 | 1.00 | 0 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
AMSDATA | +DATADG/COREDB/datafile/amsdata.297.786494983 | 2,625 | 1 | 2.03 | 1.00 | 0 | 0 | 0 | 0.00 |
AMSINDEX | +DATADG/COREDB/datafile/amsindex.298.786495075 | 34 | 0 | 2.94 | 1.00 | 0 | 0 | 0 | 0.00 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.270.730202259 | 115,108 | 32 | 3.81 | 20.72 | 2,015 | 1 | 2,204 | 2.98 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.271.730202435 | 110,347 | 31 | 4.08 | 21.53 | 2,434 | 1 | 3,473 | 3.27 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.272.730202619 | 119,504 | 33 | 3.83 | 20.72 | 2,669 | 1 | 3,640 | 4.03 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.273.730202791 | 108,910 | 30 | 3.82 | 20.94 | 3,018 | 1 | 2,751 | 3.50 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.274.730202937 | 117,246 | 32 | 3.82 | 19.10 | 2,571 | 1 | 3,220 | 3.62 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.283.745515419 | 112,568 | 31 | 3.89 | 20.57 | 1,969 | 1 | 2,964 | 3.06 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.295.783256433 | 85,011 | 24 | 4.66 | 15.90 | 599 | 0 | 15,061 | 3.20 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.296.783257507 | 82,222 | 23 | 4.71 | 16.26 | 1,130 | 0 | 13,958 | 3.39 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.305.796495117 | 51,967 | 14 | 4.57 | 12.26 | 1,795 | 0 | 15,337 | 4.52 |
COREDATA | +DATADG/COREDB/datafile/COREDATA.307.803139899 | 34,432 | 10 | 4.71 | 6.30 | 1,528 | 0 | 12,643 | 6.92 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.276.730204269 | 14,635 | 4 | 6.58 | 1.32 | 1,068 | 0 | 314 | 454.43 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.277.730204109 | 17,027 | 5 | 6.06 | 1.28 | 1,315 | 0 | 175 | 42.11 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.280.730204413 | 14,809 | 4 | 5.96 | 1.28 | 1,820 | 1 | 438 | 248.90 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.281.730204551 | 13,054 | 4 | 6.10 | 1.32 | 1,273 | 0 | 119 | 153.36 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.282.730204685 | 16,116 | 4 | 5.40 | 1.28 | 989 | 0 | 143 | 642.17 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.286.745515665 | 14,817 | 4 | 5.60 | 1.31 | 860 | 0 | 16 | 233.13 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.291.771353279 | 14,101 | 4 | 6.51 | 1.40 | 1,925 | 1 | 59 | 52.71 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.292.771353509 | 8,914 | 2 | 7.23 | 1.64 | 565 | 0 | 215 | 425.12 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.293.783255523 | 12,967 | 4 | 7.95 | 1.38 | 1,305 | 0 | 24 | 15.83 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.294.783255951 | 11,872 | 3 | 8.12 | 1.38 | 1,423 | 0 | 914 | 19.65 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.302.796411061 | 9,196 | 3 | 9.01 | 1.49 | 832 | 0 | 237 | 64.68 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.303.796493979 | 8,990 | 2 | 9.48 | 1.53 | 1,780 | 0 | 293 | 45.22 |
CORE_INDEX | +DATADG/COREDB/datafile/CORE_index.306.803129617 | 7,728 | 2 | 9.66 | 1.50 | 979 | 0 | 556 | 108.83 |
ETS_TMP | +DATADG/COREDB/datafile/ets_tmp.275.730287209 | 2,292 | 1 | 3.24 | 1.00 | 0 | 0 | 0 | 0.00 |
QUEST | +DATADG/COREDB/datafile/quest.289.748266187 | 5,056 | 1 | 2.95 | 1.30 | 1,412 | 0 | 0 | 0.00 |
SYSAUX | +DATADG/COREDB/datafile/sysaux.260.729362609 | 91,935 | 25 | 3.70 | 2.86 | 4,425 | 1 | 0 | 0.00 |
SYSAUX | +DATADG/COREDB/datafile/sysaux.301.787835057 | 15,743 | 4 | 5.68 | 5.59 | 397 | 0 | 0 | 0.00 |
SYSTEM | +DATADG/COREDB/datafile/system.259.729362599 | 27,176 | 8 | 2.90 | 1.09 | 1,246 | 0 | 1,939 | 688.61 |
TEMP | +DATADG/COREDB/tempfile/temp.262.729362685 | 271 | 0 | 13.47 | 89.23 | 516 | 0 | 0 | |
UNDOTBS1 | +DATADG/COREDB/datafile/undotbs1.261.744737439 | 365 | 0 | 12.79 | 1.00 | 4,522 | 1 | 106 | 1.51 |
UNDOTBS2 | +DATADG/COREDB/datafile/undotbs2.263.744738251 | 101 | 0 | 4.65 | 1.00 | 0 | 0 | 3,350 | 12.05 |
USERS | +DATADG/COREDB/datafile/users.264.730203979 | 21,807 | 6 | 7.03 | 4.16 | 1,242 | 0 | 230 | 85.61 |
USERS | +DATADG/COREDB/datafile/users.278.730203631 | 23,926 | 7 | 5.68 | 3.76 | 1,743 | 0 | 98 | 404.49 |
USERS | +DATADG/COREDB/datafile/users.279.730203813 | 24,125 | 7 | 5.91 | 3.75 | 1,480 | 0 | 68 | 67.21 |
USERS | +DATADG/COREDB/datafile/users.287.733311617 | 24,575 | 7 | 6.73 | 3.82 | 1,029 | 0 | 471 | 117.26 |
USERS | +DATADG/COREDB/datafile/users.288.733311861 | 21,747 | 6 | 6.85 | 4.59 | 941 | 0 | 218 | 390.55 |
USERS | +DATADG/COREDB/datafile/users.290.745515943 | 20,483 | 6 | 6.93 | 4.44 | 942 | 0 | 28 | 29.64 |
USERS | +DATADG/COREDB/datafile/users.300.787832331 | 8,091 | 2 | 2.96 | 4.32 | 614 | 0 | 1 | 320.00 |
USERS | +DATADG/COREDB/datafile/users.304.796494633 | 7,572 | 2 | 2.99 | 3.29 | 84 | 0 | 6 | 143.33 |
USERS | +DATADG/COREDB/datafile/users.308.803140519 | 7,975 | 2 | 2.32 | 2.09 | 566 | 0 | 11 | 12.73 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 1,833,220 | 98 | 577,545,030 | 11,486,185 | 105,958 | 0 | 0 | 85,302 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 59,406 | 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 | 3 | 8124 | 62380 | 355732 | 2488320 | 355732 | 2 | ||
E | 0 | 2 | 8147 | 64868 | 284971 | 2488320 | 284971 | 2 |
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,536 | 0.10 | 181 | 52.44 | 96,362,713 | 1 | 644172644.00 |
D | 3,072 | 0.20 | 363 | 29.53 | 54,270,823 | 1 | 360324790.00 |
D | 4,608 | 0.30 | 544 | 16.72 | 30,721,060 | 1 | 201516255.00 |
D | 6,144 | 0.40 | 726 | 9.34 | 17,167,990 | 1 | 110120743.00 |
D | 7,680 | 0.49 | 907 | 5.15 | 9,457,025 | 1 | 58121632.00 |
D | 9,216 | 0.59 | 1,089 | 2.99 | 5,491,581 | 1 | 31380549.00 |
D | 10,752 | 0.69 | 1,270 | 1.95 | 3,589,452 | 1 | 18553488.00 |
D | 12,288 | 0.79 | 1,452 | 1.44 | 2,646,158 | 1 | 12192362.00 |
D | 13,824 | 0.89 | 1,633 | 1.17 | 2,151,213 | 1 | 8854681.00 |
D | 15,360 | 0.99 | 1,814 | 1.01 | 1,861,445 | 1 | 6900622.00 |
D | 15,552 | 1.00 | 1,837 | 1.00 | 1,837,686 | 1 | 6740409.00 |
D | 16,896 | 1.09 | 1,996 | 0.91 | 1,671,378 | 1 | 5618903.00 |
D | 18,432 | 1.19 | 2,177 | 0.83 | 1,533,534 | 1 | 4689348.00 |
D | 19,968 | 1.28 | 2,359 | 0.78 | 1,427,792 | 1 | 3976271.00 |
D | 21,504 | 1.38 | 2,540 | 0.73 | 1,344,369 | 1 | 3413707.00 |
D | 23,040 | 1.48 | 2,722 | 0.69 | 1,275,180 | 1 | 2947131.00 |
D | 24,576 | 1.58 | 2,903 | 0.66 | 1,217,463 | 1 | 2557914.00 |
D | 26,112 | 1.68 | 3,084 | 0.63 | 1,165,254 | 1 | 2205842.00 |
D | 27,648 | 1.78 | 3,266 | 0.61 | 1,119,152 | 1 | 1894953.00 |
D | 29,184 | 1.88 | 3,447 | 0.59 | 1,078,687 | 1 | 1622072.00 |
D | 30,720 | 1.98 | 3,629 | 0.56 | 1,025,249 | 1 | 1261713.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
99.96 | 50,534 | 19 |
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,548 | 3,003.42 | 1.74 | 0.06 | 100.00 | 0.00 | 629,140 |
E | 6,144 | 2,989 | 3,885.05 | 2.66 | 0.07 | 100.00 | 0.00 | 629,140 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 1,461,926 | 1,461,926 | 0 | 0 |
64K | 128K | 8,848 | 8,848 | 0 | 0 |
128K | 256K | 1,212 | 1,212 | 0 | 0 |
256K | 512K | 608 | 608 | 0 | 0 |
512K | 1024K | 18,361 | 18,361 | 0 | 0 |
1M | 2M | 22,033 | 22,033 | 0 | 0 |
2M | 4M | 40 | 40 | 0 | 0 |
4M | 8M | 36 | 32 | 4 | 0 |
8M | 16M | 31 | 31 | 0 | 0 |
16M | 32M | 23 | 23 | 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 | 117,155,307.52 | 44,019,529.25 | 73.00 | 2,439,463 | 158,484,161,249 |
1,536 | 0.25 | 117,155,307.52 | 41,058,806.32 | 74.00 | 2,267,102 | 155,572,865,047 |
3,072 | 0.50 | 117,155,307.52 | 364,238.11 | 100.00 | 1,706 | 115,557,657,714 |
4,608 | 0.75 | 117,155,307.52 | 343,080.02 | 100.00 | 0 | 115,536,852,845 |
6,144 | 1.00 | 117,155,307.52 | 250,273.50 | 100.00 | 0 | 115,445,595,652 |
7,373 | 1.20 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
8,602 | 1.40 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
9,830 | 1.60 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
11,059 | 1.80 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
12,288 | 2.00 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
18,432 | 3.00 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
24,576 | 4.00 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
36,864 | 6.00 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
49,152 | 8.00 | 117,155,307.52 | 245,883.02 | 100.00 | 0 | 115,441,278,467 |
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) |
---|---|---|---|---|---|---|---|---|
8,640 | 1.00 | 459 | 31,205 | 63,226,566 | 1.00 | 2,555,950 | 1.00 | 1,940,877 |
9,600 | 1.11 | 1,360 | 86,656 | 63,302,747 | 1.00 | 2,479,769 | 0.97 | 3,847,851 |
10,496 | 1.21 | 2,255 | 135,731 | 63,426,175 | 1.00 | 2,356,341 | 0.92 | 3,868,144 |
11,392 | 1.32 | 3,150 | 185,240 | 63,501,120 | 1.00 | 2,281,396 | 0.89 | 3,881,581 |
12,288 | 1.42 | 4,046 | 234,472 | 63,543,604 | 1.01 | 2,238,912 | 0.88 | 3,890,159 |
13,184 | 1.53 | 4,941 | 283,089 | 63,569,579 | 1.01 | 2,212,937 | 0.87 | 3,896,087 |
14,080 | 1.63 | 5,837 | 332,127 | 63,586,816 | 1.01 | 2,195,700 | 0.86 | 3,900,494 |
14,976 | 1.73 | 6,733 | 381,380 | 63,599,292 | 1.01 | 2,183,224 | 0.85 | 3,903,955 |
15,872 | 1.84 | 7,628 | 430,389 | 63,609,026 | 1.01 | 2,173,490 | 0.85 | 3,906,795 |
16,704 | 1.93 | 8,524 | 478,922 | 63,617,179 | 1.01 | 2,165,337 | 0.85 | 3,909,228 |
17,664 | 2.04 | 9,420 | 527,765 | 63,624,350 | 1.01 | 2,158,166 | 0.84 | 3,911,382 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
12,288 | 0.50 | 386,558,497 | 54,270,884,678 |
15,360 | 0.63 | 136,353,081 | 17,168,021,984 |
18,432 | 0.75 | 57,613,653 | 5,491,554,462 |
21,504 | 0.88 | 38,423,391 | 2,646,082,813 |
24,576 | 1.00 | 32,972,960 | 1,837,685,126 |
27,648 | 1.13 | 30,846,205 | 1,533,548,238 |
30,720 | 1.25 | 29,570,151 | 1,344,450,438 |
33,792 | 1.38 | 28,712,854 | 1,217,466,396 |
36,864 | 1.50 | 27,855,557 | 1,078,721,169 |
39,936 | 1.63 | 27,417,017 | 1,025,244,532 |
43,008 | 1.75 | 27,149,939 | 1,025,244,532 |
46,080 | 1.88 | 27,110,371 | 1,025,244,532 |
49,152 | 2.00 | 27,097,183 | 1,025,244,532 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
64 | 0.50 | 0 | 0 | 0 | 0 |
128 | 1.00 | 0 | 0 | 0 | 0 |
192 | 1.50 | 0 | 0 | 0 | 0 |
256 | 2.00 | 0 | 0 | 0 | 0 |
320 | 2.50 | 0 | 0 | 0 | 0 |
384 | 3.00 | 0 | 0 | 0 | 0 |
448 | 3.50 | 0 | 0 | 0 | 0 |
512 | 4.00 | 0 | 0 | 0 | 0 |
576 | 4.50 | 0 | 0 | 0 | 0 |
640 | 5.00 | 0 | 0 | 0 | 0 |
704 | 5.50 | 0 | 0 | 0 | 0 |
768 | 6.00 | 0 | 0 | 0 | 0 |
832 | 6.50 | 0 | 0 | 0 | 0 |
896 | 7.00 | 0 | 0 | 0 | 0 |
960 | 7.50 | 0 | 0 | 0 | 0 |
1,024 | 8.00 | 0 | 0 | 0 | 0 |
1,088 | 8.50 | 0 | 0 | 0 | 0 |
1,152 | 9.00 | 0 | 0 | 0 | 0 |
1,216 | 9.50 | 0 | 0 | 0 | 0 |
1,280 | 10.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 81,257 | 2,364 | 29 |
system undo header | 477 | 68 | 143 |
undo header | 3,312 | 40 | 12 |
undo block | 139 | 1 | 5 |
1st level bmb | 100 | 0 | 1 |
2nd level bmb | 2 | 0 | 30 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 409 | 409 | 0 | 381 | 1,619 | 4,250.21 |
SQ-Sequence Cache | 1,952 | 1,952 | 0 | 290 | 1,246 | 4,296.52 |
US-Undo Segment | 255 | 255 | 0 | 117 | 329 | 2,811.24 |
PV-KSV slave startup (syncstart) | 29 | 29 | 0 | 2 | 29 | 14,561.00 |
TX-Transaction (index contention) | 537 | 537 | 0 | 363 | 24 | 67.29 |
CO-KTUCLO Master Slave enq (master slave det) | 1,132 | 0 | 1,132 | 1,132 | 19 | 16.72 |
TH-Threshold Chain (metric threshold evaluation) | 141 | 141 | 0 | 1 | 15 | 15,265.00 |
PR-Process Startup | 98 | 98 | 0 | 2 | 11 | 5,471.50 |
CF-Controlfile Transaction | 10,255 | 10,250 | 5 | 352 | 9 | 24.89 |
PS-PX Process Reservation | 6,253 | 5,788 | 465 | 984 | 4 | 3.89 |
TD-KTF map table enqueue (KTF dump entries) | 11 | 11 | 0 | 11 | 2 | 211.45 |
TX-Transaction | 97,468 | 97,469 | 1 | 230 | 2 | 7.84 |
KO-Multiple Object Checkpoint (fast object checkpoint) | 1,413 | 1,413 | 0 | 502 | 1 | 1.35 |
TT-Tablespace | 15,464 | 15,464 | 0 | 141 | 0 | 3.31 |
WF-AWR Flush | 446 | 424 | 22 | 22 | 0 | 19.50 |
FB-Format Block | 182 | 182 | 0 | 88 | 0 | 2.26 |
RO-Multiple Object Reuse (fast object reuse) | 144 | 144 | 0 | 43 | 0 | 4.05 |
DR-Distributed Recovery | 2 | 2 | 0 | 2 | 0 | 80.50 |
HW-Segment High Water Mark | 3,639 | 3,639 | 0 | 68 | 0 | 1.54 |
JQ-Job Queue | 40 | 36 | 4 | 1 | 0 | 53.00 |
TO-Temp Object | 309 | 309 | 0 | 55 | 0 | 0.67 |
CR-Reuse Block Range (block range reuse ckpt) | 1,069 | 1,069 | 0 | 21 | 0 | 1.52 |
TM-DML | 280,486 | 280,441 | 46 | 34 | 0 | 0.88 |
TX-Transaction (allocate ITL entry) | 29 | 29 | 0 | 26 | 0 | 0.92 |
OD-Online DDLs (Serializing DDLs) | 31 | 31 | 0 | 16 | 0 | 1.44 |
MD-Materialized View Log DDL | 46 | 46 | 0 | 23 | 0 | 0.70 |
SK-Shrink Segment | 32 | 32 | 0 | 19 | 0 | 0.74 |
PI-Remote PX Process Spawn Status | 16 | 16 | 0 | 8 | 0 | 1.25 |
PE-Parameter | 24 | 24 | 0 | 6 | 0 | 1.50 |
PG-Global Parameter | 12 | 12 | 0 | 6 | 0 | 1.00 |
TK-Auto Task Serialization (Auto Task Serialization) | 6 | 6 | 0 | 6 | 0 | 1.00 |
TA-Instance Undo | 23 | 23 | 0 | 5 | 0 | 1.00 |
AF-Advisor Framework (task serialization) | 412 | 412 | 0 | 4 | 0 | 1.00 |
MW-MWIN Schedule | 2 | 2 | 0 | 2 | 0 | 1.00 |
TS-Temporary Segment | 18 | 18 | 0 | 4 | 0 | 0.25 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
2 | 40.94 | 97,275 | 2,739 | 89 | 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:59 | 8,088 | 17,425 | 1,556 | 7 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:49 | 7,479 | 18,893 | 2,739 | 89 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:39 | 2,434 | 6,590 | 2,092 | 86 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:29 | 6,468 | 16,485 | 1,471 | 9 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:19 | 6,266 | 18,083 | 869 | 9 | 180 | 0/0 | 0/0/0/0/0/0 |
07-8月 22:09 | 10,200 | 19,799 | 1,026 | 9 | 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 | ||
ASM Keyed state latch | 3,800 | 0.34 | 0.00 | 0 | 0 | |
ASM allocation | 833 | 0.00 | 0 | 0 | ||
ASM db client latch | 10,602 | 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 | 10,272 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 3,461,070 | 0.00 | 0.06 | 0 | 0 | |
ASM network background latch | 2,092 | 0.00 | 0 | 0 | ||
ASM network state latch | 437 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 68,028 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,199 | 0.00 | 0 | 0 | ||
Consistent RBA | 137,335 | 0.00 | 0.00 | 0 | 0 | |
DML lock allocation | 171,563,018 | 0.35 | 0.00 | 0 | 0 | |
Event Group Locks | 2,034 | 0.00 | 0 | 0 | ||
FAL Queue | 98 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 30 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 19,108 | 0.26 | 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 | 30 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 6,602 | 0.00 | 0 | 7,540 | 0.08 | |
In memory undo latch | 5 | 0.00 | 0 | 0 | ||
JS Sh mem access | 13 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 16,891 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 16,891 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 16,787 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 12 | 0.00 | 0 | 0 | ||
JS queue access latch | 17 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 604,332 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 185 | 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 | 1,392 | 0.00 | 0 | 0 | ||
KFMD SGA | 7 | 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 | 131,576 | 0.12 | 0.02 | 0 | 29,662 | 0.01 |
KJCT flow control latch | 2,454,467 | 0.02 | 0.01 | 0 | 0 | |
KMG MMAN ready and startup request latch | 32,042 | 0.00 | 0 | 0 | ||
KMG resize request state object freelist | 16 | 0.00 | 0 | 0 | ||
KSXR large replies | 232 | 0.00 | 0 | 0 | ||
KTF sga latch | 34 | 0.00 | 0 | 1,181 | 0.00 | |
KWQMN job cache list latch | 362 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 29 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 59 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 5 | 0.00 | 0 | 0 | ||
Lsod array latch | 24,486 | 0.24 | 0.00 | 0 | 0 | |
MQL Tracking Latch | 0 | 0 | 71 | 0.00 | ||
Memory Management Latch | 31,121 | 0.00 | 0 | 32,041 | 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 | 1,209 | 0.00 | 0 | 0 | ||
Mutex | 5 | 0.00 | 0 | 0 | ||
Mutex Stats | 5 | 0.00 | 0 | 0 | ||
OS process | 5,906 | 0.00 | 0 | 0 | ||
OS process allocation | 11,340 | 0.08 | 0.00 | 0 | 0 | |
OS process: request allocation | 3,800 | 0.11 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 53,383 | 0.00 | 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,475 | 0.01 | 0.00 | 0 | 1 | 0.00 |
Reserved Space Latch | 4 | 0.00 | 0 | 0 | ||
Result Cache: RC Latch | 11 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 112 | 0.00 | 0 | 116 | 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,549 | 0.00 | |
SQL memory manager workarea list latch | 458,302 | 0.00 | 0 | 0 | ||
Shared B-Tree | 286 | 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 | 5 | 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 | 40,694 | 0.84 | 0.00 | 0 | 0 | |
active service list | 6,315,291 | 0.02 | 0.05 | 0 | 1,040,717 | 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 | 459 | 0.00 | 0 | 0 | ||
buffer pool | 14 | 0.00 | 0 | 0 | ||
business card | 1,669 | 0.00 | 0 | 0 | ||
cache buffer handles | 107,815 | 0.01 | 0.00 | 0 | 0 | |
cache buffers chains | 1,179,213,190 | 0.18 | 0.01 | 1 | 92,405,822 | 0.00 |
cache buffers lru chain | 1,855,755 | 0.08 | 0.08 | 0 | 91,026,858 | 0.06 |
cache table scan latch | 354,597 | 0.01 | 0.03 | 0 | 354,595 | 0.01 |
call allocation | 31,068 | 0.11 | 0.37 | 0 | 0 | |
cas latch | 5 | 0.00 | 0 | 0 | ||
change notification client cache latch | 5 | 0.00 | 0 | 0 | ||
channel handle pool latch | 3,878 | 0.34 | 0.00 | 0 | 0 | |
channel operations parent latch | 3,658,444 | 0.00 | 0.06 | 0 | 0 | |
checkpoint queue latch | 3,029,697 | 0.00 | 0.02 | 0 | 314,770 | 0.00 |
client/application info | 20,672 | 0.00 | 0 | 0 | ||
compile environment latch | 2,618 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 202,272 | 0.02 | 0.03 | 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 | 395 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 5 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 395 | 0.00 | 0 | 0 | ||
dml lock allocation | 407 | 0.00 | 0 | 0 | ||
done queue latch | 5 | 0.00 | 0 | 0 | ||
dummy allocation | 4,982 | 0.00 | 0 | 0 | ||
enqueue hash chains | 3,115,958 | 0.02 | 0.20 | 0 | 3,708 | 0.00 |
enqueues | 1,703,617 | 0.04 | 0.01 | 0 | 0 | |
error message lists | 3,975 | 0.03 | 0.00 | 0 | 0 | |
fifth spare latch | 5 | 0.00 | 0 | 0 | ||
file cache latch | 1,268 | 0.00 | 0 | 0 | ||
flashback copy | 5 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 5 | 0.00 | 0 | 0 | ||
gc element | 9,787,550 | 0.07 | 0.05 | 0 | 3,385,094 | 0.04 |
gcs commit scn state | 5 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 666,216 | 0.03 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 29,313,981 | 0.11 | 0.00 | 0 | 10,621,521 | 0.00 |
gcs pcm hashed value bucket hash | 5 | 0.00 | 0 | 0 | ||
gcs remaster request queue | 83 | 0.00 | 0 | 0 | ||
gcs remastering latch | 4,114,236 | 0.99 | 0.00 | 0 | 2,723 | 3.38 |
gcs resource freelist | 542,806 | 0.02 | 0.00 | 0 | 81,304 | 0.00 |
gcs resource hash | 25,896,480 | 0.01 | 0.01 | 0 | 423 | 0.00 |
gcs resource scan list | 1,058 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 189,177 | 0.00 | 0.00 | 0 | 122,215 | 0.00 |
ges caches resource lists | 934,164 | 0.03 | 0.04 | 0 | 458,928 | 0.02 |
ges deadlock list | 37,130 | 0.00 | 0 | 53,292 | 0.00 | |
ges domain table | 4,287,721 | 0.00 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 4,224,794 | 0.01 | 0.02 | 0 | 0 | |
ges group table | 4,151,984 | 0.00 | 0.01 | 0 | 0 | |
ges process hash list | 162,933 | 0.00 | 0.43 | 0 | 0 | |
ges process parent latch | 8,591,134 | 0.00 | 0.00 | 0 | 1 | 0.00 |
ges process table freelist | 3,800 | 0.03 | 0.00 | 0 | 0 | |
ges resource hash list | 6,738,735 | 0.03 | 0.31 | 3 | 87,933 | 0.01 |
ges resource scan list | 7,057 | 0.01 | 0.00 | 0 | 0 | |
ges resource table freelist | 115,385 | 0.00 | 0 | 0 | ||
ges timeout list | 23,236 | 0.16 | 0.08 | 0 | 4,141 | 0.00 |
ges value block free list | 3,441 | 0.00 | 0 | 0 | ||
global KZLD latch for mem in SGA | 1,626 | 0.00 | 0 | 0 | ||
global tx hash mapping | 255 | 0.00 | 0 | 0 | ||
granule operation | 5 | 0.00 | 0 | 0 | ||
hash table column usage latch | 2,075 | 0.10 | 0.00 | 0 | 5,813,640 | 0.02 |
hash table modification latch | 300 | 0.00 | 0 | 0 | ||
heartbeat check | 5 | 0.00 | 0 | 2,587 | 0.12 | |
heartbeat structure management | 0 | 0 | 709 | 0.00 | ||
internal temp table object number allocation latch | 77 | 0.00 | 0 | 0 | ||
interrupt manipulation | 7,637 | 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 | 41 | 0.00 | 0 | 36 | 0.00 | |
job_queue_processes free list latch | 77 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 16,878 | 0.00 | 0 | 0 | ||
k2q global data latch | 2,475 | 0.00 | 0 | 0 | ||
k2q lock allocation | 378 | 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 | 79,301 | 0.00 | 0 | 0 | ||
krbmrosl | 2 | 0.00 | 0 | 0 | ||
ksfv messages | 5 | 0.00 | 0 | 0 | ||
ksim group membership cache | 2,925 | 0.00 | 0 | 0 | ||
ksim membership request latch | 368 | 0.00 | 0 | 3,139 | 0.00 | |
kss move lock | 63 | 0.00 | 0 | 0 | ||
ksuosstats global area | 258 | 0.00 | 0 | 0 | ||
ksv allocation latch | 508 | 0.00 | 0 | 0 | ||
ksv class latch | 6,690 | 0.00 | 0 | 0 | ||
ksv instance latch | 4 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 11 | 0.00 | 0 | 6 | 0.00 | |
ksxp shared latch | 3,800 | 0.13 | 0.00 | 0 | 0 | |
ksxp so latch | 3,800 | 0.18 | 0.00 | 0 | 0 | |
ksz_so allocation latch | 3,800 | 0.97 | 0.00 | 0 | 0 | |
ktm global data | 1,593 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 124 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 154,789 | 0.02 | 0.00 | 0 | 0 | |
list of block allocation | 2,606 | 0.00 | 0 | 0 | ||
loader state object freelist | 666 | 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 | 2,130 | 0.00 | 0 | 310 | 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,314 | 0.00 | 0 | 0 | ||
messages | 998,450 | 0.09 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 156,294 | 0.82 | 0.00 | 0 | 0 | |
msg queue latch | 5 | 0.00 | 0 | 0 | ||
multiblock read objects | 1,290,322 | 0.02 | 0.03 | 0 | 0 | |
name-service memory objects | 26,107 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 109,464 | 0.00 | 0 | 0 | ||
name-service pending queue | 16,022 | 0.00 | 0 | 0 | ||
name-service request | 52 | 0.00 | 0 | 0 | ||
name-service request queue | 50,138 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 395 | 0.00 | 0 | 0 | ||
object queue header heap | 125,555 | 0.00 | 0 | 124,909 | 0.00 | |
object queue header operation | 26,655,765 | 0.01 | 0.25 | 0 | 112,803 | 0.02 |
object stats modification | 83,521 | 0.01 | 0.22 | 0 | 1 | 0.00 |
parallel query alloc buffer | 17,152 | 0.00 | 0 | 0 | ||
parallel query stats | 3,173 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 46,033 | 0.00 | 0 | 0 | ||
parameter list | 8,848 | 0.03 | 0.00 | 0 | 0 | |
parameter table management | 11,640 | 0.05 | 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 | 260,139 | 0.02 | 0.06 | 0 | 128,001 | 0.02 |
process allocation | 3,899 | 1.90 | 2.20 | 2 | 2,000 | 1.45 |
process group creation | 3,800 | 0.00 | 0 | 0 | ||
process queue | 9,165 | 0.00 | 0 | 0 | ||
process queue reference | 274,402 | 0.01 | 0.00 | 0 | 24,474 | 2.19 |
qmn state object latch | 6 | 0.00 | 0 | 0 | ||
qmn task queue latch | 837 | 1.91 | 0.63 | 0 | 0 | |
query server freelists | 7,504 | 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 | 448,525 | 0.06 | 0.04 | 0 | 1,039,870 | 0.16 |
redo copy | 5 | 0.00 | 0 | 1,040,516 | 0.23 | |
redo writing | 457,066 | 0.04 | 0.00 | 0 | 0 | |
reservation so alloc latch | 2 | 0.00 | 0 | 0 | ||
resmgr group change latch | 3,628 | 0.00 | 0 | 0 | ||
resmgr:active threads | 37,129 | 0.09 | 0.97 | 0 | 1,765 | 0.00 |
resmgr:actses change group | 2,587 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 308 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 5,003 | 0.04 | 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 | 185,213 | 0.13 | 0.98 | 0 | 115 | 2.61 |
resmgr:session queuing | 5 | 0.00 | 0 | 0 | ||
rm cas latch | 5 | 0.00 | 0 | 0 | ||
row cache objects | 46,324,828 | 0.65 | 0.00 | 2 | 4,971 | 0.68 |
rules engine aggregate statistics | 13 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 126 | 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 | 119,747 | 0.02 | 0.00 | 0 | 0 | |
session allocation | 781,667 | 0.01 | 0.02 | 0 | 776,695 | 0.02 |
session idle bit | 11,862,957 | 0.01 | 0.01 | 0 | 0 | |
session queue latch | 5 | 0.00 | 0 | 0 | ||
session state list latch | 5,187 | 0.15 | 0.00 | 0 | 0 | |
session switching | 9,255 | 0.00 | 0 | 0 | ||
session timer | 1,467 | 0.00 | 0 | 0 | ||
shared pool | 10,891,811 | 0.10 | 0.19 | 14 | 0 | |
shared pool sim alloc | 5 | 0.00 | 0 | 0 | ||
shared pool simulator | 1,876,583 | 0.01 | 0.21 | 0 | 0 | |
sim partition latch | 5 | 0.00 | 0 | 0 | ||
simulator hash latch | 39,345,429 | 0.00 | 0.02 | 0 | 0 | |
simulator lru latch | 1,937 | 0.21 | 0.75 | 0 | 38,109,304 | 0.43 |
sort extent pool | 1,811 | 0.00 | 0 | 0 | ||
space background state object latch | 11 | 0.00 | 0 | 0 | ||
space background task latch | 3,529 | 0.20 | 0.00 | 0 | 2,394 | 0.00 |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 1,568 | 0.00 | 0 | 0 | ||
tablespace key chain | 5,090 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 8 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 26 | 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 | 220 | 0.00 | 0 | 0 | ||
trace latch | 128 | 0.78 | 0.00 | 0 | 0 | |
transaction allocation | 43,961,861 | 0.13 | 0.01 | 0 | 0 | |
transaction branch allocation | 1,669 | 0.00 | 0 | 0 | ||
undo global data | 629,246 | 0.04 | 0.02 | 0 | 16 | 0.00 |
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 | 1,179,213,190 | 2,165,628 | 11,428 | 2,154,705 |
DML lock allocation | 171,563,018 | 604,524 | 2,066 | 602,516 |
row cache objects | 46,324,828 | 299,994 | 530 | 299,470 |
transaction allocation | 43,961,861 | 55,762 | 412 | 55,372 |
gcs remastering latch | 4,114,236 | 40,731 | 3 | 40,728 |
shared pool | 10,891,811 | 10,476 | 2,001 | 8,598 |
gc element | 9,787,550 | 6,899 | 345 | 6,573 |
gcs resource hash | 25,896,480 | 2,973 | 39 | 2,938 |
object queue header operation | 26,655,765 | 2,401 | 607 | 1,814 |
ges resource hash list | 6,738,735 | 2,238 | 686 | 1,563 |
cache buffers lru chain | 1,855,755 | 1,406 | 106 | 1,302 |
active service list | 6,315,291 | 1,341 | 61 | 1,278 |
mostly latch-free SCN | 156,294 | 1,283 | 4 | 1,279 |
messages | 998,450 | 869 | 3 | 866 |
simulator hash latch | 39,345,429 | 834 | 16 | 819 |
session idle bit | 11,862,957 | 797 | 5 | 792 |
enqueue hash chains | 3,115,958 | 739 | 146 | 594 |
enqueues | 1,703,617 | 641 | 5 | 636 |
KJCT flow control latch | 2,454,467 | 476 | 5 | 471 |
ges caches resource lists | 934,164 | 297 | 11 | 286 |
redo allocation | 448,525 | 283 | 10 | 273 |
ges enqueue table freelist | 4,224,794 | 275 | 6 | 269 |
multiblock read objects | 1,290,322 | 260 | 8 | 252 |
resmgr:schema config | 185,213 | 244 | 240 | 4 |
undo global data | 629,246 | 237 | 4 | 233 |
ges group table | 4,151,984 | 164 | 2 | 162 |
KJC message pool free list | 131,576 | 157 | 3 | 154 |
shared pool simulator | 1,876,583 | 117 | 25 | 92 |
process allocation | 3,899 | 74 | 163 | 29 |
checkpoint queue latch | 3,029,697 | 62 | 1 | 61 |
post/wait queue | 260,139 | 54 | 3 | 51 |
session allocation | 781,667 | 51 | 1 | 50 |
cache table scan latch | 354,597 | 40 | 1 | 39 |
ges timeout list | 23,236 | 37 | 3 | 34 |
call allocation | 31,068 | 35 | 13 | 22 |
channel operations parent latch | 3,658,444 | 35 | 2 | 33 |
resmgr:active threads | 37,129 | 34 | 33 | 1 |
corrupted undo seg latch | 202,272 | 33 | 1 | 32 |
ASM map operation hash table | 3,461,070 | 17 | 1 | 16 |
qmn task queue latch | 837 | 16 | 10 | 6 |
object stats modification | 83,521 | 9 | 2 | 7 |
ges process hash list | 162,933 | 7 | 3 | 4 |
parameter table management | 11,640 | 6 | 6 | 0 |
simulator lru latch | 1,937 | 4 | 3 | 1 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
ASM map operation hash table | kffmTranslate | 0 | 1 | 1 |
DML lock allocation | ktadmc | 0 | 2,064 | 2,027 |
DML lock allocation | ktaiam | 0 | 1 | 27 |
DML lock allocation | ktaidm | 0 | 1 | 12 |
KJC message pool free list | kjcsmpav: allocate a msg buffer | 0 | 3 | 3 |
KJCT flow control latch | kjctcsnd: send normal message | 0 | 3 | 3 |
KJCT flow control latch | kjcts_sedeqv2: dequeue a vector of msgs | 0 | 2 | 0 |
active service list | kswslogon: session logout | 0 | 37 | 1 |
active service list | kswsite: service iterator | 0 | 22 | 1 |
active service list | kswslogon: session login | 0 | 15 | 1 |
active service list | kswsgetso: get service object | 0 | 7 | 75 |
active service list | kswssetsvc: PX session switch service | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 7,499 | 3,332 |
cache buffers chains | kcbgtcr_2 | 0 | 6,086 | 5,934 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 749 | 1,527 |
cache buffers chains | kcbrls_1 | 0 | 708 | 4,475 |
cache buffers chains | kcbgtcr: fast path | 0 | 616 | 304 |
cache buffers chains | kcbchg1: kslbegin: bufs not pinned | 0 | 198 | 165 |
cache buffers chains | kcbzwb | 0 | 181 | 128 |
cache buffers chains | kcbgcur_2 | 0 | 93 | 55 |
cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 52 | 0 |
cache buffers chains | kcbrls_2 | 0 | 39 | 147 |
cache buffers chains | kcbget: pin buffer | 0 | 33 | 32 |
cache buffers chains | kclwrt | 0 | 26 | 0 |
cache buffers chains | kcbchg1: kslbegin: call CR func | 0 | 25 | 77 |
cache buffers chains | kclbla | 0 | 16 | 1 |
cache buffers chains | kclcls_3 | 0 | 14 | 65 |
cache buffers chains | kcllkopesc | 0 | 9 | 2 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 7 | 4 |
cache buffers chains | kcbbxsv | 0 | 5 | 15 |
cache buffers chains | kcl_fairness | 0 | 5 | 1 |
cache buffers chains | kcbgkcbcr | 0 | 4 | 5 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 3 | 0 |
cache buffers chains | kclcqchk | 0 | 3 | 0 |
cache buffers chains | kcbbic2 | 0 | 2 | 0 |
cache buffers chains | kcbesc: escalate | 0 | 2 | 1 |
cache buffers chains | kcbgtcr_1 | 0 | 2 | 2 |
cache buffers chains | kcbzibmlt: finish free bufs | 0 | 2 | 3 |
cache buffers chains | kcbbic1 | 0 | 1 | 0 |
cache buffers chains | kcbgcur: fast path (shr) | 0 | 1 | 0 |
cache buffers chains | kcbnlc | 0 | 1 | 7 |
cache buffers chains | kcbxbh | 0 | 1 | 0 |
cache buffers chains | kcbzib: finish processing buffer | 0 | 1 | 9 |
cache buffers chains | kclevict | 0 | 1 | 0 |
cache buffers chains | kcllwr_1 | 0 | 1 | 0 |
cache buffers chains | kclrlstp | 0 | 1 | 1 |
cache buffers lru chain | kcbzgws | 0 | 79 | 0 |
cache buffers lru chain | kcbzgb_2 | 0 | 18 | 8 |
cache buffers lru chain | kcbw_activate_granule | 0 | 3 | 0 |
cache buffers lru chain | kcbzgm | 0 | 3 | 0 |
cache buffers lru chain | kcbzgb | 0 | 2 | 47 |
cache buffers lru chain | kcbbic2 | 0 | 1 | 21 |
cache table scan latch | kcbz_free_table_scan_read_buffer | 0 | 1 | 1 |
call allocation | ksuxds | 0 | 12 | 3 |
call allocation | ksuprc | 0 | 1 | 1 |
channel operations parent latch | ksrpubwait():1 | 0 | 1 | 0 |
channel operations parent latch | ksrwait() | 0 | 1 | 1 |
checkpoint queue latch | kcbkubc_4 | 0 | 1 | 0 |
corrupted undo seg latch | ktudiscorrupted | 0 | 1 | 1 |
enqueue hash chains | ksqexpandres | 0 | 115 | 0 |
enqueue hash chains | ksqgtl3 | 0 | 12 | 39 |
enqueue hash chains | ksqrcl | 0 | 9 | 100 |
enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 6 | 1 |
enqueue hash chains | ksqcmi: if lk mode requested | 0 | 2 | 4 |
enqueue hash chains | ksqexpandwait | 0 | 2 | 1 |
enqueues | ksqdel | 0 | 3 | 3 |
enqueues | ksqgel: create enqueue | 0 | 2 | 2 |
gc element | kclbla | 0 | 186 | 2 |
gc element | kclnfndnewm | 0 | 90 | 63 |
gc element | kcl_fairness | 0 | 41 | 5 |
gc element | kclevict | 0 | 36 | 0 |
gc element | kclchkping | 0 | 29 | 0 |
gc element | kclulb | 0 | 28 | 84 |
gc element | kclplz | 0 | 23 | 63 |
gc element | kclfwrite1 | 0 | 17 | 6 |
gc element | kclnfndx | 0 | 15 | 97 |
gc element | KCLUNLNK | 0 | 6 | 89 |
gc element | kclwrt | 0 | 6 | 2 |
gc element | kclcqchk | 0 | 4 | 28 |
gc element | kcl_get_le_latch | 0 | 2 | 0 |
gc element | kclpto_3 | 0 | 2 | 0 |
gc element | kclrwrite | 0 | 2 | 8 |
gc element | kclebs | 0 | 1 | 2 |
gc element | kclhngcbk1 | 0 | 1 | 0 |
gc element | kclhngcbk1_1 | 0 | 1 | 0 |
gc element | kclnfndnew | 0 | 1 | 1 |
gc element | kclpdc_14 | 0 | 1 | 0 |
gc element | kclpdcl | 0 | 1 | 23 |
gc element | kclplz_1 | 0 | 1 | 11 |
gcs remastering latch | kjfcdrmrfg beginning | 0 | 3 | 0 |
gcs resource hash | kjblocalobj_nolock | 0 | 13 | 8 |
gcs resource hash | kjbconvert | 0 | 8 | 1 |
gcs resource hash | kjbcropen:affinity | 0 | 4 | 1 |
gcs resource hash | kjbassume | 0 | 3 | 2 |
gcs resource hash | kjbcrcomplete | 0 | 3 | 1 |
gcs resource hash | kjbopen | 0 | 2 | 0 |
gcs resource hash | kclfwrite1 | 0 | 1 | 0 |
gcs resource hash | kclpdc | 0 | 1 | 2 |
gcs resource hash | kclrwrite | 0 | 1 | 2 |
gcs resource hash | kjbcropen | 0 | 1 | 3 |
gcs resource hash | kjblpast | 0 | 1 | 1 |
gcs resource hash | kjbmpcreatepi | 0 | 1 | 1 |
ges enqueue table freelist | kjlalc: lock allocation | 0 | 3 | 4 |
ges enqueue table freelist | kjlfr: remove lock from parent object | 0 | 3 | 2 |
ges group table | kjgagll: move a lock from process lock list to group lock list | 0 | 2 | 2 |
ges process hash list | kjakiqa: set inquiry response | 0 | 3 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 497 | 2 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 81 | 7 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 59 | 183 |
ges resource hash list | kjucvl: lock convert request | 0 | 28 | 467 |
ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 21 | 1 |
ges resource hash list | kjrref: find matched resource | 0 | 6 | 36 |
ges resource hash list | kjcvscn: remove from scan queue | 0 | 4 | 0 |
ges resource hash list | kjuinq: inquire resource held mode | 0 | 1 | 0 |
ges resource table freelist | kjruch: cached obj cleanup | 0 | 4 | 0 |
ges resource table freelist | kjrm2c: move resource to cache | 0 | 3 | 11 |
ges resource table freelist | kjchc: clean resource cache | 0 | 2 | 0 |
ges resource table freelist | kjrchc2: cached obj cleanup | 0 | 1 | 0 |
ges resource table freelist | kjrchc: cached obj cleanup | 0 | 1 | 0 |
ges timeout list | kjtscn: try to lock timer queue | 0 | 3 | 0 |
lgwr LWN SCN | kcs023 | 0 | 2 | 0 |
messages | ksaamb: after wakeup | 0 | 2 | 1 |
messages | ksarcv: after wait | 0 | 1 | 2 |
mostly latch-free SCN | kcslcu3 | 0 | 2 | 4 |
multiblock read objects | kcbzibmlt | 0 | 4 | 2 |
multiblock read objects | kcbzibmlt: normal mbr free | 0 | 4 | 6 |
object queue header operation | kclobj_5 | 0 | 539 | 429 |
object queue header operation | kclobj_1 | 0 | 28 | 27 |
object queue header operation | kcbo_unlink_q | 0 | 22 | 124 |
object queue header operation | kcbo_link_q:reget | 0 | 10 | 0 |
object queue header operation | kcbo_link_q | 0 | 8 | 11 |
object queue header operation | kcbo_write_q | 0 | 4 | 4 |
object queue header operation | kcbo_switch_mq_bg | 0 | 3 | 5 |
object queue header operation | kcbo_unlink_q_bg | 0 | 3 | 6 |
object queue header operation | kcbo_switch_q_bg | 0 | 2 | 5 |
object queue header operation | kcldbufs | 0 | 2 | 8 |
object queue header operation | kcbo_sw_buf | 0 | 1 | 0 |
object queue header operation | kcbo_switch_cq | 0 | 1 | 4 |
object queue header operation | kclbufs | 0 | 1 | 1 |
object stats modification | ksolsgetchk | 0 | 2 | 0 |
parameter table management | kspcpy | 0 | 5 | 0 |
parameter table management | ksp_param_table_free | 0 | 1 | 0 |
post/wait queue | kslpstevent:get | 0 | 2 | 2 |
post/wait queue | ksliwat:remove | 0 | 1 | 1 |
process allocation | ksuapc | 0 | 119 | 162 |
process allocation | ksucrp:1 | 0 | 40 | 0 |
process allocation | ksudlp | 0 | 3 | 0 |
qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 5 | 0 |
qmn task queue latch | kwqmnaddtsk: add task | 0 | 2 | 0 |
qmn task queue latch | kwqmngettsk: get task | 0 | 2 | 10 |
qmn task queue latch | kwqmndntsk: task done but retry | 0 | 1 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 9 | 0 |
redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 1 | 0 |
resmgr:active threads | kgsksimsetup1 | 0 | 32 | 0 |
resmgr:active threads | kskdynthreshact | 0 | 1 | 0 |
resmgr:resource group CPU method | kgkprrpicknext | 0 | 290 | 299 |
resmgr:resource group CPU method | kgkprraddtorl | 0 | 23 | 14 |
resmgr:schema config | kgskgmaxdop1 | 0 | 150 | 6 |
resmgr:schema config | kgskgasi1 | 0 | 89 | 234 |
resmgr:schema config | kgskmetricupd | 0 | 1 | 0 |
row cache objects | kqreqd: reget | 0 | 287 | 11 |
row cache objects | kqrpre: find obj | 0 | 106 | 429 |
row cache objects | kqrso | 0 | 57 | 33 |
row cache objects | kqrbgl | 0 | 29 | 2 |
row cache objects | kqreqd | 0 | 22 | 24 |
row cache objects | kqrbtm: pop parent | 0 | 9 | 2 |
row cache objects | kqrbip | 0 | 4 | 2 |
row cache objects | kqrigt | 0 | 4 | 21 |
row cache objects | kqrigt2 | 0 | 3 | 0 |
row cache objects | ksucallcbksafely: kqrhngc | 0 | 3 | 0 |
row cache objects | kqrpre: init complete | 0 | 2 | 1 |
row cache objects | kqrcmt: while loop | 0 | 1 | 1 |
row cache objects | kqrigt3 | 0 | 1 | 0 |
session allocation | kspallmod | 0 | 1 | 0 |
session idle bit | ksupuc: clear busy | 0 | 3 | 2 |
session idle bit | ksupuc: set busy | 0 | 2 | 4 |
session idle bit | ksuxds | 0 | 2 | 1 |
shared pool | kghalo | 0 | 1,459 | 774 |
shared pool | kghupr1 | 0 | 261 | 680 |
shared pool | kghalp | 0 | 158 | 456 |
shared pool | kgh_heap_sizes | 0 | 54 | 45 |
shared pool | kgh_next_free | 0 | 47 | 2 |
shared pool | kghfrunp: alloc: wait | 0 | 11 | 0 |
shared pool | kghfre | 0 | 4 | 37 |
shared pool | kghasp | 0 | 2 | 2 |
shared pool | kghfrh | 0 | 1 | 1 |
shared pool | kghfrunp: clatch: nowait | 0 | 1 | 0 |
shared pool | kghfrunp: clatch: wait | 0 | 1 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 22 | 6 |
shared pool simulator | kglsim_scan_lru: scan | 0 | 2 | 6 |
shared pool simulator | kglsim_upd_newhp | 0 | 1 | 8 |
simulator hash latch | kcbsacc: lookup dba | 0 | 11 | 14 |
simulator hash latch | kcbsacc: insert dba | 0 | 2 | 0 |
simulator hash latch | kcbsacc: remove dba | 0 | 2 | 1 |
simulator hash latch | kcbs_lookup_setid: lookup dba | 0 | 1 | 1 |
simulator lru latch | kcbs_shrink_pool | 0 | 3 | 0 |
transaction allocation | ktcxbr | 0 | 412 | 412 |
undo global data | ktudba: KSLBEGIN | 0 | 2 | 2 |
undo global data | ktucof: at start | 0 | 1 | 0 |
undo global data | kturdc: KSLBEGIN | 0 | 1 | 0 |
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Cursor Pin | kkslce [KKSCHLPIN2] | 6,024,659 | 821,028 |
Library Cache | kgllkal1 80 | 233,612 | 7,013 |
Library Cache | kglget1 1 | 114,660 | 2,908 |
Library Cache | kglhdgn1 62 | 68,284 | 1,299 |
Library Cache | kglget2 2 | 59,981 | 1,233 |
Library Cache | kglpndl1 95 | 59,485 | 1,743 |
Library Cache | kglobpn1 71 | 53,954 | 1,156 |
Library Cache | kglpin1 4 | 47,603 | 1,015 |
Library Cache | kgldtin1 42 | 40,898 | 683 |
Library Cache | kglhdgn2 106 | 29,348 | 1,141 |
Library Cache | kglpnal2 91 | 29,346 | 877 |
Library Cache | kglpnal1 90 | 27,586 | 904 |
Library Cache | kgllkdl1 85 | 23,790 | 692 |
Library Cache | kglobld1 75 | 1,519 | 22 |
Library Cache | kglhdgh1 64 | 1,205 | 97 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 492 | 4,933 |
Library Cache | kglrfcl1 79 | 337 | 5 |
Cursor Pin | kksfbc [KKSCHLPIN1] | 208 | 2 |
Library Cache | kglReleaseHandleReference 125 | 200 | 3 |
Library Cache | kgllkc1 57 | 95 | 1 |
Library Cache | kglllal3 111 | 36 | 82 |
hash table | kkshGetNextChild [KKSHBKLOC1] | 31 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 19 | 0 |
Library Cache | kgllldl2 112 | 11 | 0 |
Library Cache | kglnti1 46 | 5 | 0 |
Library Cache | kglati1 45 | 4 | 5 |
Library Cache | kglini1 32 | 2 | 8 |
Library Cache | kglUpgradeLock 119 | 1 | 0 |
Library Cache | kglhbh1 63 | 1 | 0 |
Library Cache | kglic1 49 | 1 | 0 |
Library Cache | kgllkal3 82 | 1 | 0 |
Library Cache | kglllal1 109 | 1 | 2 |
Library Cache | kglrdtin1 44 | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | EXCHANGE | TABLE | 67,520,480 | 11.54 | |
ECS | USERS | ORGANIZATIONUNITPROFILE | TABLE | 57,782,240 | 9.87 | |
ECS | CORE_INDEX | IDX_OUNESTLOOP | INDEX | 34,678,768 | 5.93 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_87227165_25241 | TABLE PARTITION | 24,907,792 | 4.26 |
ECS | COREDATA | REPAYBILL | TABLE | 22,569,488 | 3.86 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | REFUNDORDER | TABLE | 4,968,766 | 26.32 | |
ECS | COREDATA | PSGTICKET | TABLE | 4,351,608 | 23.05 | |
SYS | USERS | AUD$ | TABLE | 420,329 | 2.23 | |
ECS | COREDATA | ORDERS | SYS_P2389 | TABLE PARTITION | 155,836 | 0.83 |
ECS | COREDATA | ORDERS | SYS_P2409 | TABLE PARTITION | 149,861 | 0.79 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | PSGTICKET | TABLE | 133,705 | 9.50 | |
ECS | COREDATA | REPAYBILL | TABLE | 113,103 | 8.03 | |
ECS | USERS | FLIGHTPRICEDOMESTIC | TABLE | 69,025 | 4.90 | |
ECS | COREDATA | REFUNDORDER | TABLE | 52,170 | 3.71 | |
ECS | USERS | TRACEOFPROCESS | SYS_P2528 | TABLE PARTITION | 50,301 | 3.57 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | PSGTICKET | TABLE | 133,705 | 9.50 | |
ECS | COREDATA | REPAYBILL | TABLE | 113,103 | 8.03 | |
ECS | USERS | FLIGHTPRICEDOMESTIC | TABLE | 69,025 | 4.90 | |
ECS | COREDATA | REFUNDORDER | TABLE | 52,170 | 3.71 | |
ECS | USERS | TRACEOFPROCESS | SYS_P2528 | TABLE PARTITION | 50,301 | 3.57 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | REFUNDORDER | TABLE | 4,954,688 | 67.00 | |
ECS | COREDATA | ORDERS | SYS_P2489 | TABLE PARTITION | 85,705 | 1.16 |
ECS | COREDATA | ORDERS | SYS_P2409 | TABLE PARTITION | 74,114 | 1.00 |
ECS | COREDATA | ORDERS | SYS_P2448 | TABLE PARTITION | 69,012 | 0.93 |
ECS | COREDATA | ORDERS | SYS_P2389 | TABLE PARTITION | 66,711 | 0.90 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
PAO | TEMP | QUEST_ADV_SEGSTAT_WIDE_PK | INDEX | 4,796 | 3.68 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_87227165_25433 | TABLE PARTITION | 4,073 | 3.12 |
ECS | COREDATA | PAYBILL | TABLE | 3,430 | 2.63 | |
SYS | USERS | AUD$ | TABLE | 2,635 | 2.02 | |
** MISSING ** | USERS | ** MISSING: 300054/300054 | ** MISSING ** | UNDEFINED | 2,434 | 1.87 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | PAYBILL | TABLE | 3,164 | 5.55 | |
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 1,849 | 3.24 |
ECS | CORE_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 1,847 | 3.24 |
ECS | COREDATA | PASSENGERINFO | TABLE | 1,707 | 3.00 | |
ECS | CORE_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 1,526 | 2.68 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
---|---|---|---|---|---|---|
PAO | TEMP | QUEST_ADV_SEGSTAT_WIDE_PK | INDEX | 4,796 | 19.57 | |
** MISSING ** | USERS | ** MISSING: 300054/300054 | ** MISSING ** | UNDEFINED | 2,447 | 9.98 |
** MISSING ** | COREDATA | ** MISSING: 300056/300056 | ** MISSING ** | UNDEFINED | 2,065 | 8.43 |
** MISSING ** | USERS | ** MISSING: 300055/300055 | ** MISSING ** | UNDEFINED | 1,734 | 7.08 |
** MISSING ** | COREDATA | ** MISSING: 300057/300057 | ** MISSING ** | UNDEFINED | 1,474 | 6.01 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
ECS | CORE_INDEX | PK_ORGANIZATIONUNITPROFILE | INDEX | 3,165 | 55.81 | |
ECS | COREDATA | REFUNDORDER | TABLE | 19 | 0.34 | |
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 16 | 0.28 |
ECS | COREDATA | ORDERS | SYS_P2389 | TABLE PARTITION | 15 | 0.26 |
ECS | COREDATA | ORDERS | SYS_P2409 | TABLE PARTITION | 15 | 0.26 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 151,760 | 23.46 |
SYS | USERS | AUD$ | TABLE | 49,664 | 7.68 | |
ECS | CORE_INDEX | IDX_SHOWLIST | SYS_P2548 | INDEX PARTITION | 42,400 | 6.55 |
ECS | CORE_INDEX | IDX_CREATEDATE_STATUS | SYS_P2548 | INDEX PARTITION | 38,128 | 5.89 |
ECS | CORE_INDEX | PK_PNRLIST | INDEX | 27,760 | 4.29 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 329 | 39.45 |
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 148 | 17.75 |
ECS | CORE_INDEX | IX_ITEMNO | SYS_P2528 | INDEX PARTITION | 92 | 11.03 |
ECS | CORE_INDEX | CATALOG | SYS_P2528 | INDEX PARTITION | 20 | 2.40 |
ECS | USERS | USERPROFILE | TABLE | 19 | 2.28 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 23 | 88.46 |
ECS | CORE_INDEX | SYS_C0049434 | INDEX | 3 | 11.54 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SYS | SYSTEM | UNDO$ | TABLE | 1,347 | 53.09 | |
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 484 | 19.08 |
ECS | USERS | IDX_TRACEID | SYS_P2528 | INDEX PARTITION | 238 | 9.38 |
ECS | CORE_INDEX | PK_PNRLIST | INDEX | 122 | 4.81 | |
ECS | CORE_INDEX | SYS_C0048724 | INDEX | 60 | 2.36 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
ECS | COREDATA | ORDERS | SYS_P2409 | TABLE PARTITION | 18,902 | 31.83 |
ECS | COREDATA | ORDERS | SYS_P2389 | TABLE PARTITION | 15,715 | 26.46 |
ECS | COREDATA | CHANGE | TABLE | 9,194 | 15.48 | |
ECS | COREDATA | CALLCENTERDATARECORD | TABLE | 9,175 | 15.45 | |
ECS | CORE_INDEX | PK_ORDERS | INDEX | 1,136 | 1.91 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | ORDERS | SYS_P2548 | TABLE PARTITION | 25,975 | 15.68 |
ECS | CORE_INDEX | PK_ORDERS | INDEX | 10,286 | 6.21 | |
ECS | USERS | PNRLIST | TABLE | 8,592 | 5.19 | |
ECS | CORE_INDEX | PK_FLIGHTPRICEDOMESTIC | INDEX | 5,846 | 3.53 | |
ECS | CORE_INDEX | PK_PNRLIST | INDEX | 5,652 | 3.41 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
ECS | COREDATA | CNPPHONEPAYINFO | TABLE | 84,409 | 17.91 | |
ECS | COREDATA | ORDERS | SYS_P2048 | TABLE PARTITION | 63,270 | 13.42 |
ECS | COREDATA | ORDERS | SYS_P2448 | TABLE PARTITION | 56,072 | 11.89 |
ECS | COREDATA | ORDERS | SYS_P2489 | TABLE PARTITION | 19,358 | 4.11 |
ECS | CORE_INDEX | ORDERSEGMENT_FK | INDEX | 18,884 | 4.01 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 409 | 0.00 | 0 | 2 | 1 | |
dc_constraints | 507 | 35.11 | 0 | 507 | 1 | |
dc_files | 882 | 0.00 | 0 | 0 | 42 | |
dc_global_oids | 29,365 | 0.38 | 0 | 0 | 51 | |
dc_histogram_data | 8,194,384 | 0.07 | 0 | 2,808 | 7,270 | |
dc_histogram_defs | 3,137,438 | 0.34 | 0 | 2,039 | 4,704 | |
dc_object_grants | 54,868 | 0.15 | 0 | 0 | 82 | |
dc_objects | 4,944,686 | 0.07 | 0 | 261 | 1,745 | |
dc_profiles | 3,274 | 0.37 | 0 | 0 | 4 | |
dc_rollback_segments | 151,277 | 0.06 | 0 | 450 | 1,920 | |
dc_segments | 1,405,666 | 0.17 | 0 | 46 | 1,163 | |
dc_sequences | 1,673 | 69.64 | 0 | 1,673 | 5 | |
dc_table_scns | 46 | 100.00 | 0 | 0 | 0 | |
dc_tablespaces | 897,558 | 0.00 | 0 | 0 | 14 | |
dc_users | 2,007,024 | 0.00 | 0 | 0 | 72 | |
global database name | 4,504 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 71 | 90.14 | 0 | 13 | 11 | |
qmtmrctn_cache_entries | 4 | 100.00 | 0 | 0 | 0 | |
qmtmrctq_cache_entries | 123 | 100.00 | 0 | 0 | 0 | |
sch_lj_objs | 6 | 50.00 | 0 | 0 | 3 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 4 | 0 | 0 |
dc_constraints | 845 | 0 | 8 |
dc_global_oids | 113 | 0 | 145 |
dc_histogram_defs | 13,437 | 0 | 6,770 |
dc_objects | 3,438 | 2 | 2,951 |
dc_profiles | 12 | 0 | 13 |
dc_rollback_segments | 552 | 86 | 0 |
dc_segments | 2,749 | 2 | 2,569 |
dc_sequences | 3,343 | 1,118 | 51 |
dc_table_scns | 46 | 0 | 0 |
dc_tablespaces | 19 | 0 | 19 |
dc_users | 68 | 0 | 76 |
outstanding_alerts | 132 | 18 | 38 |
qmtmrctn_cache_entries | 4 | 0 | 4 |
qmtmrctq_cache_entries | 123 | 0 | 123 |
sch_lj_objs | 3 | 0 | 5 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 3,067 | 1.01 | 0 | 0 | 0 | |
BODY | 11,230 | 1.81 | 98,248 | 0.24 | 12 | 0 |
CLUSTER | 1,024 | 1.37 | 1,037 | 1.45 | 1 | 0 |
DBLINK | 3,257 | 0.00 | 0 | 0 | 0 | |
DIRECTORY | 50 | 6.00 | 70 | 12.86 | 4 | 0 |
EDITION | 1,493 | 0.00 | 2,969 | 0.00 | 0 | 0 |
HINTSET OBJECT | 31 | 19.35 | 31 | 38.71 | 0 | 0 |
INDEX | 135,635 | 0.19 | 135,572 | 0.38 | 0 | 0 |
OBJECT ID | 49 | 100.00 | 0 | 0 | 0 | |
QUEUE | 27 | 7.41 | 179 | 3.35 | 3 | 0 |
RULESET | 0 | 13 | 7.69 | 1 | 0 | |
SCHEMA | 3,979 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 571,098 | 27.15 | 2,640,292 | 21.40 | 21,256 | 2,609 |
SQL AREA BUILD | 177,410 | 94.95 | 0 | 0 | 0 | |
SQL AREA STATS | 171,359 | 95.25 | 171,362 | 95.25 | 1 | 0 |
SUBSCRIPTION | 9 | 66.67 | 9 | 66.67 | 0 | 0 |
TABLE/PROCEDURE | 408,258 | 0.26 | 1,431,191 | 0.80 | 7,012 | 0 |
TEMPORARY INDEX | 121 | 100.00 | 121 | 100.00 | 0 | 0 |
TEMPORARY TABLE | 316 | 31.01 | 316 | 100.00 | 218 | 0 |
TRIGGER | 899 | 4.56 | 66,462 | 0.11 | 19 | 0 |
XML SCHEMA | 5 | 20.00 | 6 | 66.67 | 1 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
ACCOUNT_STATUS | 3,067 | 0 | 0 | 0 | 0 |
BODY | 0 | 96,448 | 96,448 | 0 | 0 |
CLUSTER | 1,037 | 1,037 | 1,037 | 0 | 0 |
DBLINK | 3,257 | 0 | 0 | 0 | 0 |
DIRECTORY | 29 | 57 | 57 | 0 | 0 |
EDITION | 1,493 | 1,493 | 1,493 | 0 | 0 |
HINTSET OBJECT | 31 | 31 | 31 | 0 | 0 |
INDEX | 135,550 | 135,551 | 135,551 | 0 | 0 |
QUEUE | 3 | 179 | 179 | 0 | 0 |
RULESET | 0 | 13 | 13 | 0 | 0 |
SCHEMA | 1,710 | 0 | 0 | 0 | 0 |
SUBSCRIPTION | 0 | 9 | 9 | 0 | 0 |
TABLE/PROCEDURE | 516,655 | 716,402 | 716,402 | 0 | 0 |
TEMPORARY INDEX | 121 | 121 | 121 | 0 | 0 |
TEMPORARY TABLE | 316 | 316 | 316 | 0 | 0 |
TRIGGER | 0 | 66,462 | 66,462 | 0 | 0 |
XML SCHEMA | 3 | 3 | 3 | 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 | 15,616.00 | 15,552.00 | 15,552.00 | 18,304.00 | 8 | 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 | 8,576.00 | 8,640.00 | 5,952.00 | 8,640.00 | 8 | GRO/DEF |
streams pool | 128.00 | 128.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 | 15,552.00 | 15,616.00 | 15,584.00 | 6 | 0 | 6 |
shared pool | 8,576.00 | 8,640.00 | 8,608.00 | 6 | 6 | 0 |
Start | Ela (s) | Component | Oper Typ/Mod | Init Size (M) | Delta | Target Delta | Final (M) | Sta |
---|---|---|---|---|---|---|---|---|
08/07 22:57:44 | 60 | bufcache | SHR/DEF | 15,552 | 0 | -128 | 15,552 | CAN |
08/07 22:57:44 | 60 | shared | GRO/DEF | 8,640 | 0 | 128 | 8,640 | CAN |
08/07 22:44:14 | 60 | bufcache | SHR/DEF | 15,552 | 0 | -128 | 15,552 | CAN |
08/07 22:44:14 | 60 | shared | GRO/DEF | 8,640 | 0 | 128 | 8,640 | CAN |
08/07 22:30:54 | 1 | bufcache | SHR/IMM | 15,616 | -64 | 15,552 | COM | |
08/07 22:30:54 | 1 | shared | GRO/IMM | 8,576 | 64 | 8,640 | COM | |
08/07 22:24:43 | 60 | bufcache | SHR/DEF | 15,616 | 0 | -128 | 15,616 | CAN |
08/07 22:24:43 | 60 | shared | GRO/DEF | 8,576 | 0 | 128 | 8,576 | CAN |
08/07 22:15:11 | 60 | bufcache | SHR/DEF | 15,616 | 0 | -128 | 15,616 | CAN |
08/07 22:15:11 | 60 | shared | GRO/DEF | 8,576 | 0 | 128 | 8,576 | CAN |
08/07 22:06:09 | 60 | bufcache | SHR/DEF | 15,616 | 0 | -128 | 15,616 | CAN |
08/07 22:06:09 | 60 | shared | GRO/DEF | 8,576 | 0 | 128 | 8,576 | 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,473.50 | 4.39 | 4.04 | 44 | 44 | 564 | 564 | |
B | Freeable | 402.56 | 0.00 | 0.87 | 0.67 | 11 | 464 | 464 | |
B | PL/SQL | 99.89 | 63.23 | 0.18 | 0.15 | 1 | 1 | 562 | 560 |
B | SQL | 40.55 | 17.48 | 0.08 | 0.52 | 12 | 275 | 529 | 430 |
E | Other | 3,225.48 | 3.92 | 3.58 | 44 | 44 | 822 | 822 | |
E | Freeable | 512.94 | 0.00 | 0.84 | 0.55 | 9 | 608 | 608 | |
E | PL/SQL | 113.27 | 79.44 | 0.14 | 0.14 | 1 | 2 | 820 | 819 |
E | SQL | 32.77 | 6.66 | 0.04 | 0.06 | 1 | 275 | 786 | 684 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 16,374,562,816 | 16,307,453,952 |
Fixed Size | 2,231,608 | |
Redo Buffers | 16,932,864 | |
Variable Size | 9,261,023,944 | 9,328,132,808 |
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.81 | 55.81 | 0.00 |
shared | KGH: NO ACCESS | 801.82 | 801.82 | 0.00 |
shared | KGLH0 | 582.60 | 627.28 | 7.67 |
shared | KGLHD | 2,762.98 | 2,773.19 | 0.37 |
shared | SQLA | 362.65 | 488.81 | 34.79 |
shared | free memory | 3,243.66 | 3,091.88 | -4.68 |
shared | gcs resources | 336.81 | 336.81 | 0.00 |
shared | gcs shadows | 248.18 | 248.18 | 0.00 |
shared | kglsim object batch | 125.21 | 125.21 | 0.00 |
streams | KGH: NO ACCESS | 63.99 | 63.99 | 0.00 |
streams | free memory | 127.95 | 127.95 | 0.00 |
buffer_cache | 15,616.00 | 15,552.00 | -0.41 | |
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 Coordinator | 0517 05:09:44 | 0.22 | 0.00 | 0.00 |
QMON Slaves | 0517 05:09:44 | 0.22 | 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 | 13 | 0.00 | 0 | 0.10 | 2.04 | 0.00 | 0.00 | 0.16 | 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) | 13 | 0 | 100.00 | 0.00 | 42.60 | 0.00 | 0.00 | 4.93 |
SYS.AQ$_ALERT_QT_E(12342) | 0 | 0 | 0.00 | 0.00 | ||||
SYSMAN.MGMT_TASK_Q(49631) | 34 | 34 | 0.00 | 0.00 | 0.18 | 0.43 | 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 | 3.28 | |
SYS.AQ$_ALERT_QT_E(12342) | 0.00 | 0.00 | ||
SYSMAN.MGMT_TASK_Q(49631) | 0.01 | 0.01 | 0.01 | 0.01 |
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 | 13 | 0 | 0 | 0.00 | 0.00 | 0.00 |
CORE_DB2_3938_COREDB2(42)/SYS.ALERT_QUE | 13 | 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.09 | 99.91 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.09 | 99.91 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.09 | 99.91 | 0 | 0 | |
D000 | 0.00 | 3,608 | 0.09 | 99.91 | 0 | 0 | |
Sum | 0.00 | 0 | 0 | ||||
Avg | 0.00 | 0.09 | 99.91 | 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 | |
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 | 1 | |
job_queue_processes | 1000 | |
local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.109.10.31)(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 | 1 | |
undo_retention | 10800 | |
undo_tablespace | UNDOTBS1 |
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) | 50,772 | 14.07 | 0.27 |
acks for commit broadcast(logical) | 58,633 | 16.25 | 0.31 |
broadcast msgs on commit(actual) | 68,850 | 19.08 | 0.37 |
broadcast msgs on commit(logical) | 120,469 | 33.38 | 0.64 |
broadcast msgs on commit(wasted) | 16,031 | 4.44 | 0.09 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
flow control messages received | 3 | 0.00 | 0.00 |
flow control messages sent | 0 | 0.00 | 0.00 |
gcs apply delta | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 119,324 | 33.06 | 0.64 |
gcs ast xid | 30 | 0.01 | 0.00 |
gcs blocked converts | 154,136 | 42.71 | 0.82 |
gcs blocked cr converts | 179,547 | 49.75 | 0.96 |
gcs compatible basts | 824 | 0.23 | 0.00 |
gcs compatible cr basts (global) | 43,082 | 11.94 | 0.23 |
gcs compatible cr basts (local) | 163,278 | 45.24 | 0.87 |
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 | 15,210 | 4.21 | 0.08 |
gcs dbwr write request msgs | 11,569 | 3.21 | 0.06 |
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 | 137 | 0.04 | 0.00 |
gcs force cr grant | 794 | 0.22 | 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 | 12,571 | 3.48 | 0.07 |
gcs immediate (null) converts | 20,896 | 5.79 | 0.11 |
gcs immediate cr (compatible) converts | 1,249 | 0.35 | 0.01 |
gcs immediate cr (null) converts | 257,327 | 71.30 | 1.37 |
gcs indirect ast | 71,951 | 19.94 | 0.38 |
gcs indirect bidless ast | 33 | 0.01 | 0.00 |
gcs indirect fg ast | 71,774 | 19.89 | 0.38 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 6,883 | 1.91 | 0.04 |
gcs msgs process time(ms) | 45,724 | 12.67 | 0.24 |
gcs msgs received | 1,525,497 | 422.69 | 8.13 |
gcs new served by master | 1,271 | 0.35 | 0.01 |
gcs out-of-order msgs | 11 | 0.00 | 0.00 |
gcs pings refused | 292 | 0.08 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs push delta | 0 | 0.00 | 0.00 |
gcs queued converts | 98 | 0.03 | 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 | 35 | 0.01 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 3 | 0.00 | 0.00 |
gcs share recovery bast | 0 | 0.00 | 0.00 |
gcs side channel msgs actual | 22,379 | 6.20 | 0.12 |
gcs side channel msgs logical | 815,484 | 225.96 | 4.35 |
gcs stale cr | 39,292 | 10.89 | 0.21 |
gcs undo cr | 8,171 | 2.26 | 0.04 |
gcs write notification msgs | 1,724 | 0.48 | 0.01 |
gcs writes refused | 56 | 0.02 | 0.00 |
ges msgs process time(ms) | 3,299 | 0.91 | 0.02 |
ges msgs received | 139,985 | 38.79 | 0.75 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 76 | 0.02 | 0.00 |
global posts queued | 46 | 0.01 | 0.00 |
global posts requested | 47 | 0.01 | 0.00 |
global posts sent | 46 | 0.01 | 0.00 |
implicit batch messages received | 34,940 | 9.68 | 0.19 |
implicit batch messages sent | 96,710 | 26.80 | 0.52 |
lmd msg send time(ms) | 10 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 5,856 | 1.62 | 0.03 |
messages queue sent actual | 315,605 | 87.45 | 1.68 |
messages queue sent logical | 848,077 | 234.99 | 4.52 |
messages received actual | 887,977 | 246.04 | 4.73 |
messages received logical | 1,665,577 | 461.50 | 8.88 |
messages sent directly | 703,044 | 194.80 | 3.75 |
messages sent indirectly | 1,014,276 | 281.04 | 5.41 |
messages sent not implicit batched | 323 | 0.09 | 0.00 |
messages sent pbatched | 1,136,685 | 314.96 | 6.06 |
msgs causing lmd to send msgs | 56,365 | 15.62 | 0.30 |
msgs causing lms(s) to send msgs | 55,565 | 15.40 | 0.30 |
msgs received queue time (ms) | 310,829 | 86.13 | 1.66 |
msgs received queued | 1,665,581 | 461.50 | 8.88 |
msgs sent queue time (ms) | 267,201 | 74.04 | 1.42 |
msgs sent queue time on ksxp (ms) | 8,113,781 | 2,248.19 | 43.24 |
msgs sent queued | 1,065,778 | 295.31 | 5.68 |
msgs sent queued on ksxp | 1,150,472 | 318.78 | 6.13 |
number of broadcasted resources | 0 | 0.00 | 0.00 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 229,774 | 63.67 | 1.22 |
process batch messages sent | 258,580 | 71.65 | 1.38 |
0 | 0.00 | 0.00 |
Statistic | Total |
---|---|
CR Block Requests | 133,779 |
CURRENT Block Requests | 15,657 |
Data Block Requests | 133,780 |
Undo Block Requests | 3,048 |
TX Block Requests | 11,444 |
Current Results | 130,170 |
Private results | 3,253 |
Zero Results | 15,879 |
Disk Read Results | 123 |
Fail Results | 0 |
Fairness Down Converts | 47,773 |
Fairness Clears | 8,701 |
Free GC Elements | 0 |
Flushes | 19,440 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 2,479 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 405 | 26.17 | 38.27 | 33.09 | 1.23 | 1.23 |
Flushes | 1,634 | 15.73 | 67.69 | 14.75 | 1.84 | 0.00 |
Writes | 19,809 | 0.01 | 62.56 | 32.07 | 3.71 | 1.65 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
2 | data block | 138,243 | 85.29 | 14.48 | 0.23 | 469,861 | 97.47 | 0.47 | 2.06 |
2 | undo header | 24,762 | 99.15 | 0.36 | 0.48 | 310 | 95.81 | 3.55 | 0.65 |
2 | Others | 829 | 98.79 | 0.12 | 1.09 | 1,230 | 99.59 | 0.08 | 0.33 |
2 | undo block | 1,800 | 96.78 | 3.06 | 0.17 | 24 | 87.50 | 0.00 | 12.50 |
CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
2 | data block | 7.15 | 1.21 | 30.18 | 758.37 | 2.85 | 1.64 | 119.67 | 33.03 |
2 | undo header | 6.98 | 2.77 | 543.98 | 464.68 | 16.78 | 1.37 | 337.22 | 542.48 |
2 | others | 1.22 | 0.99 | 75.53 | 13.41 | 1.81 | 1.79 | 0.81 | 6.57 |
2 | undo block | 1.41 | 0.91 | 6.76 | 193.61 | 3662.91 | 2.91 | 29282.91 |
CR | Current | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
2 | data block | 0 | 117,913 | 100.00 | 0.00 | 457,952 | 100.00 | 0.00 |
2 | undo header | 0 | 24,552 | 100.00 | 0.00 | 297 | 100.00 | 0.00 |
2 | others | 0 | 819 | 100.00 | 0.00 | 1,225 | 100.00 | 0.00 |
2 | undo block | 0 | 1,742 | 100.00 | 0.00 | 21 | 100.00 | 0.00 |
CR Avg Time (ms) | Current Avg Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
2 | data block | 1.21 | 1.21 | 1.64 | 1.64 | |||
2 | undo header | 2.77 | 2.77 | 1.37 | 1.37 | |||
2 | others | 0.99 | 0.99 | 1.79 | 1.79 | |||
2 | undo block | 0.91 | 0.91 | 2.91 | 2.91 |
Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
---|---|---|---|---|---|---|
1 | 282 | 0.53 | 5.55 | 282 | 0.51 | 5.55 |
2 | 282 | 1.70 | 15.07 | 282 | 1.96 | 15.07 |
Used By | Send Mbytes/sec | Receive Mbytes/sec |
---|---|---|
Global Cache | 0.67 | 1.20 |
Parallel Query | 0.01 | 0.03 |
DB Locks | 0.21 | 0.10 |
DB Streams | 0.00 | 0.00 |
Other | 0.00 | 0.01 |
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.131.102 | NO | 1.05 | 0 | 0 | 0 | 0 | 1.54 | 0 | 0 | 0 | 0 | |
en9 | 169.254.131.102 | NO | 1.05 | 0 | 161,364,648 | 0 | 0 | 1.54 | 0 | 0 | 1,398,030,667 | 4 | |
en9 | 169.254.131.102 | NO | 1.05 | 0 | -161,364,648 | 0 | 0 | 1.54 | 0 | 0 | -1,398,030,667 | -4 | |
en9 | 169.254.131.102 | NO | 1.05 | 0 | 0 | 0 | 0 | 1.54 | 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 | 3,072 | 1,024.00 | ||
replayed locks sent | 9 | 3.00 | ||
resources cleaned | 0 | 0.00 | ||
remaster time (s) | 58.8 | 19.59 | ||
quiesce time (s) | 2.3 | 0.77 | ||
freeze time (s) | 0.6 | 0.19 | ||
cleanup time (s) | 0.9 | 0.30 | ||
replay time (s) | 0.3 | 0.09 | ||
fixwrite time (s) | 1.3 | 0.45 | ||
sync time (s) | 52.2 | 17.39 | ||
affinity objects | 186 | 187 |