DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
ORCL | 1385339541 | orcl2 | 2 | 25-7月 -15 09:07 | 11.2.0.1.0 | YES |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
orac2.com | Linux x86 64-bit | 2 | 1.96 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 85 | 25-7月 -15 12:00:18 | 41 | .8 |
End Snap: | 86 | 25-7月 -15 13:00:02 | 41 | .8 |
Elapsed: | 59.74 (mins) | |||
DB Time: | 0.10 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 100M | 100M | Std Block Size: | 8K |
Shared Pool Size: | 280M | 280M | Log Buffer: | 6,436K |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 0.0 | 0.0 | 0.00 | 0.01 |
DB CPU(s): | 0.0 | 0.0 | 0.00 | 0.01 |
Redo size: | 667.5 | 5,270.6 | ||
Logical reads: | 18.5 | 146.4 | ||
Block changes: | 2.7 | 21.4 | ||
Physical reads: | 0.1 | 0.8 | ||
Physical writes: | 0.3 | 2.2 | ||
User calls: | 0.2 | 1.5 | ||
Parses: | 1.5 | 12.1 | ||
Hard parses: | 0.0 | 0.0 | ||
W/A MB processed: | 0.0 | 0.1 | ||
Logons: | 0.1 | 0.4 | ||
Executes: | 2.9 | 22.6 | ||
Rollbacks: | 0.0 | 0.0 | ||
Transactions: | 0.1 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.45 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.92 | Soft Parse %: | 99.91 |
Execute to Parse %: | 46.28 | Latch Hit %: | 100.00 |
Parse CPU to Parse Elapsd %: | 57.69 | % Non-Parse CPU: | 96.53 |
Begin | End | |
---|---|---|
Memory Usage %: | 59.10 | 59.23 |
% SQL with executions>1: | 79.08 | 82.65 |
% Memory for SQL w/exec>1: | 76.57 | 78.53 |
Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DB CPU | 4 | 74.60 | |||
name-service call wait | 12 | 1 | 70 | 14.43 | Other |
db file sequential read | 184 | 1 | 4 | 11.57 | User I/O |
os thread startup | 5 | 1 | 106 | 9.15 | Concurrency |
DFS lock handle | 33 | 0 | 12 | 6.99 | Other |
Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|
0.31 | 0.65 | 0.3 | 0.3 | 0.5 | 99.2 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
0.1 | 15.6 | 0.0 |
Begin | End | |
---|---|---|
Host Mem (MB): | 2,010.4 | 2,010.4 |
SGA use (MB): | 400.0 | 400.0 |
PGA use (MB): | 189.5 | 187.3 |
% Host Mem used for SGA+PGA: | 29.32 | 29.21 |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 0.15 | 1.21 |
Global Cache blocks served: | 0.22 | 1.74 |
GCS/GES messages received: | 1.54 | 12.19 |
GCS/GES messages sent: | 1.62 | 12.81 |
DBWR Fusion writes: | 0.04 | 0.35 |
Estd Interconnect traffic (KB) | 3.61 |
Buffer access - local cache %: | 98.62 |
Buffer access - remote cache %: | 0.83 |
Buffer access - disk %: | 0.55 |
Avg global enqueue get time (ms): | 0.1 |
Avg global cache cr block receive time (ms): | 0.5 |
Avg global cache current block receive time (ms): | 0.6 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.1 |
Global cache log flushes for cr blocks served %: | 2.6 |
Avg global cache cr block flush time (ms): | 9.2 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.1 |
Global cache log flushes for current blocks served %: | 2.1 |
Avg global cache current block flush time (ms): | 18.3 |
Avg message sent queue time (ms): | 0.0 |
Avg message sent queue time on ksxp (ms): | 0.8 |
Avg message received queue time (ms): | 0.0 |
Avg GCS message process time (ms): | 0.0 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 68.82 |
% of indirect sent messages: | 29.36 |
% of flow controlled messages: | 1.82 |
Begin | End | |||||
---|---|---|---|---|---|---|
Interface | IP Address | Pub | Source | IP | Pub | Src |
eth1 | 192.168.100.22 | N | Oracle Cluster Repository |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 7.60 | 131.14 |
DB CPU | 4.33 | 74.60 |
PL/SQL execution elapsed time | 0.80 | 13.87 |
parse time elapsed | 0.41 | 7.01 |
hard parse elapsed time | 0.12 | 2.13 |
repeated bind elapsed time | 0.00 | 0.00 |
DB time | 5.80 | |
background elapsed time | 45.86 | |
background cpu time | 4.51 |
Statistic | Value | End Value |
---|---|---|
BUSY_TIME | 5,658 | |
IDLE_TIME | 711,076 | |
IOWAIT_TIME | 3,698 | |
NICE_TIME | 88 | |
SYS_TIME | 2,453 | |
USER_TIME | 2,448 | |
LOAD | 0 | 1 |
PHYSICAL_MEMORY_BYTES | 2,108,108,800 | |
NUM_CPUS | 2 | |
GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
TCP_RECEIVE_SIZE_MIN | 4,096 | |
TCP_SEND_SIZE_DEFAULT | 16,384 | |
TCP_SEND_SIZE_MAX | 4,194,304 | |
TCP_SEND_SIZE_MIN | 4,096 |
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
25-7月 12:00:18 | 0.31 | |||||
25-7月 13:00:02 | 0.65 | 0.79 | 0.34 | 0.34 | 99.21 | 0.52 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
DB CPU | 4 | 74.60 | |||
Other | 1,309 | 31 | 2 | 1 | 30.78 |
User I/O | 275 | 0 | 1 | 3 | 14.10 |
Concurrency | 22 | 9 | 1 | 25 | 9.31 |
Commit | 43 | 0 | 0 | 4 | 3.31 |
Cluster | 464 | 0 | 0 | 0 | 3.20 |
System I/O | 12 | 0 | 0 | 1 | 0.14 |
Application | 2 | 100 | 0 | 1 | 0.03 |
Configuration | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
name-service call wait | 12 | 0 | 1 | 70 | 0.03 | 14.43 |
db file sequential read | 184 | 0 | 1 | 4 | 0.41 | 11.57 |
os thread startup | 5 | 0 | 1 | 106 | 0.01 | 9.15 |
DFS lock handle | 33 | 6 | 0 | 12 | 0.07 | 6.99 |
reliable message | 35 | 0 | 0 | 11 | 0.08 | 6.80 |
log file sync | 43 | 0 | 0 | 4 | 0.09 | 3.31 |
enq: JQ - contention | 21 | 100 | 0 | 4 | 0.05 | 1.44 |
gc current grant busy | 90 | 0 | 0 | 1 | 0.20 | 1.12 |
Disk file operations I/O | 87 | 0 | 0 | 1 | 0.19 | 0.96 |
db file parallel read | 2 | 0 | 0 | 26 | 0.00 | 0.91 |
gc cr grant 2-way | 175 | 0 | 0 | 0 | 0.39 | 0.83 |
db file scattered read | 2 | 0 | 0 | 19 | 0.00 | 0.67 |
gc current block 2-way | 119 | 0 | 0 | 0 | 0.26 | 0.64 |
gc cr block 2-way | 65 | 0 | 0 | 0 | 0.14 | 0.48 |
IPC send completion sync | 72 | 0 | 0 | 0 | 0.16 | 0.44 |
enq: PS - contention | 38 | 37 | 0 | 1 | 0.08 | 0.33 |
control file sequential read | 12 | 0 | 0 | 1 | 0.03 | 0.14 |
PX Deq: Slave Session Stats | 31 | 0 | 0 | 0 | 0.07 | 0.13 |
library cache pin | 12 | 0 | 0 | 0 | 0.03 | 0.10 |
gc current multi block request | 8 | 0 | 0 | 0 | 0.02 | 0.06 |
gc current grant 2-way | 6 | 0 | 0 | 0 | 0.01 | 0.05 |
ges message buffer allocation | 635 | 0 | 0 | 0 | 1.40 | 0.05 |
PX Deq: reap credit | 337 | 100 | 0 | 0 | 0.74 | 0.05 |
library cache lock | 2 | 100 | 0 | 1 | 0.00 | 0.04 |
enq: UL - contention | 2 | 100 | 0 | 1 | 0.00 | 0.03 |
KJC: Wait for msg sends to complete | 47 | 0 | 0 | 0 | 0.10 | 0.03 |
enq: JS - job run lock - synchronize | 2 | 100 | 0 | 1 | 0.00 | 0.03 |
PX Deq: Signal ACK RSG | 12 | 50 | 0 | 0 | 0.03 | 0.02 |
row cache lock | 2 | 0 | 0 | 1 | 0.00 | 0.02 |
jobq slave wait | 6,279 | 100 | 3,146 | 501 | 13.83 | |
PX Deq: Execution Msg | 149 | 17 | 0 | 3 | 0.33 | |
PX Deq: Join ACK | 24 | 33 | 0 | 1 | 0.05 | |
PX Deq: Parse Reply | 22 | 27 | 0 | 1 | 0.05 | |
PX Deq: Execute Reply | 19 | 26 | 0 | 0 | 0.04 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
control file sequential read | 11,130 | 0 | 12 | 1 | 24.52 | 27.03 |
control file parallel write | 1,192 | 0 | 5 | 4 | 2.63 | 11.53 |
db file parallel write | 785 | 0 | 4 | 5 | 1.73 | 8.32 |
os thread startup | 128 | 0 | 3 | 24 | 0.28 | 6.82 |
log file parallel write | 451 | 0 | 2 | 4 | 0.99 | 4.13 |
db file sequential read | 132 | 0 | 1 | 10 | 0.29 | 2.80 |
enq: CO - master slave det | 1,194 | 100 | 1 | 1 | 2.63 | 1.50 |
name-service call wait | 6 | 0 | 1 | 91 | 0.01 | 1.19 |
gcs log flush sync | 73 | 1 | 0 | 4 | 0.16 | 0.61 |
CGS wait for IPC msg | 33,064 | 100 | 0 | 0 | 72.83 | 0.57 |
enq: WF - contention | 11 | 0 | 0 | 17 | 0.02 | 0.41 |
gc current grant busy | 111 | 0 | 0 | 1 | 0.24 | 0.33 |
gc current block 2-way | 207 | 0 | 0 | 1 | 0.46 | 0.29 |
db file scattered read | 11 | 0 | 0 | 12 | 0.02 | 0.28 |
gc cr block 2-way | 148 | 0 | 0 | 1 | 0.33 | 0.22 |
gc current block busy | 6 | 0 | 0 | 16 | 0.01 | 0.22 |
gc current split | 2 | 0 | 0 | 42 | 0.00 | 0.18 |
DFS lock handle | 150 | 80 | 0 | 0 | 0.33 | 0.13 |
ksxr poll remote instances | 4,556 | 100 | 0 | 0 | 10.04 | 0.09 |
gc current multi block request | 42 | 0 | 0 | 1 | 0.09 | 0.09 |
log file sync | 2 | 0 | 0 | 18 | 0.00 | 0.08 |
Disk file operations I/O | 52 | 0 | 0 | 1 | 0.11 | 0.06 |
rdbms ipc reply | 135 | 0 | 0 | 0 | 0.30 | 0.06 |
gc cr block busy | 4 | 0 | 0 | 6 | 0.01 | 0.05 |
ADR block file read | 13 | 0 | 0 | 2 | 0.03 | 0.05 |
row cache lock | 38 | 0 | 0 | 1 | 0.08 | 0.04 |
library cache pin | 30 | 0 | 0 | 1 | 0.07 | 0.04 |
db file parallel read | 1 | 0 | 0 | 15 | 0.00 | 0.03 |
gc cr grant 2-way | 40 | 0 | 0 | 0 | 0.09 | 0.03 |
gc current grant 2-way | 47 | 0 | 0 | 0 | 0.10 | 0.03 |
enq: CR - block range reuse ckpt | 1 | 0 | 0 | 14 | 0.00 | 0.03 |
enq: CF - contention | 20 | 0 | 0 | 1 | 0.04 | 0.03 |
reliable message | 37 | 0 | 0 | 0 | 0.08 | 0.02 |
ges message buffer allocation | 3,328 | 0 | 0 | 0 | 7.33 | 0.02 |
PX Deq: reap credit | 1,557 | 100 | 0 | 0 | 3.43 | 0.02 |
enq: PS - contention | 18 | 33 | 0 | 0 | 0.04 | 0.02 |
enq: TA - contention | 12 | 0 | 0 | 1 | 0.03 | 0.02 |
enq: HW - contention | 14 | 0 | 0 | 0 | 0.03 | 0.01 |
library cache lock | 16 | 6 | 0 | 0 | 0.04 | 0.01 |
ASM file metadata operation | 716 | 0 | 0 | 0 | 1.58 | 0.01 |
enq: TX - index contention | 3 | 0 | 0 | 1 | 0.01 | 0.01 |
IPC send completion sync | 14 | 0 | 0 | 0 | 0.03 | 0.01 |
gc cr multi block request | 11 | 0 | 0 | 0 | 0.02 | 0.01 |
enq: TK - Auto Task Serialization | 6 | 100 | 0 | 0 | 0.01 | 0.01 |
PX Deq: Signal ACK RSG | 24 | 50 | 0 | 0 | 0.05 | 0.01 |
enq: FB - contention | 5 | 0 | 0 | 1 | 0.01 | 0.01 |
enq: TM - contention | 5 | 100 | 0 | 0 | 0.01 | 0.01 |
ADR block file write | 5 | 0 | 0 | 0 | 0.01 | 0.01 |
KJC: Wait for msg sends to complete | 52 | 0 | 0 | 0 | 0.11 | 0.00 |
gc buffer busy release | 3 | 0 | 0 | 1 | 0.01 | 0.00 |
PX Deq: Slave Session Stats | 11 | 0 | 0 | 0 | 0.02 | 0.00 |
enq: DR - contention | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
rdbms ipc message | 60,682 | 91 | 82,488 | 1359 | 133.66 | |
wait for unread message on broadcast channel | 7,176 | 90 | 7,169 | 999 | 15.81 | |
DIAG idle wait | 147,916 | 54 | 7,159 | 48 | 325.81 | |
smon timer | 12 | 92 | 3,595 | 299606 | 0.03 | |
Streams AQ: qmn slave idle wait | 125 | 0 | 3,593 | 28745 | 0.28 | |
Streams AQ: qmn coordinator idle wait | 250 | 50 | 3,593 | 14372 | 0.55 | |
PING | 1,389 | 21 | 3,591 | 2585 | 3.06 | |
heartbeat monitor sleep | 717 | 100 | 3,586 | 5002 | 1.58 | |
Space Manager: slave idle wait | 723 | 99 | 3,586 | 4960 | 1.59 | |
pmon timer | 1,347 | 89 | 3,585 | 2661 | 2.97 | |
ges remote message | 43,090 | 94 | 3,584 | 83 | 94.91 | |
ASM background timer | 716 | 0 | 3,583 | 5004 | 1.58 | |
gcs remote message | 107,872 | 98 | 3,582 | 33 | 237.60 | |
shared server idle wait | 119 | 100 | 3,571 | 30005 | 0.26 | |
dispatcher timer | 59 | 100 | 3,540 | 60005 | 0.13 | |
PX Idle Wait | 1,297 | 98 | 3,354 | 2586 | 2.86 | |
PX Deq: Join ACK | 33 | 36 | 0 | 1 | 0.07 | |
KSV master wait | 2,152 | 100 | 0 | 0 | 4.74 | |
PX Deq: Parse Reply | 26 | 31 | 0 | 0 | 0.06 | |
PX Deq: Execute Reply | 20 | 10 | 0 | 0 | 0.04 | |
Streams AQ: RAC qmn coordinator idle wait | 254 | 100 | 0 | 0 | 0.56 | |
class slave wait | 17 | 0 | 0 | 0 | 0.04 |
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 13 | 76.9 | 23.1 | ||||||
ADR block file write | 5 | 100.0 | |||||||
ADR file lock | 6 | 100.0 | |||||||
ASM file metadata operation | 716 | 100.0 | |||||||
CGS wait for IPC msg | 33.1K | 100.0 | |||||||
DFS lock handle | 183 | 92.9 | 3.3 | 1.1 | 2.7 | ||||
Disk file operations I/O | 139 | 82.0 | 2.2 | 15.1 | .7 | ||||
IPC send completion sync | 86 | 98.8 | 1.2 | ||||||
KJC: Wait for msg sends to complete | 99 | 100.0 | |||||||
LGWR wait for redo copy | 7 | 100.0 | |||||||
PX Deq: Signal ACK EXT | 6 | 100.0 | |||||||
PX Deq: Signal ACK RSG | 36 | 100.0 | |||||||
PX Deq: Slave Session Stats | 42 | 100.0 | |||||||
PX Deq: reap credit | 1895 | 100.0 | |||||||
asynch descriptor resize | 152 | 100.0 | |||||||
buffer busy waits | 1 | 100.0 | |||||||
control file parallel write | 1192 | 9.2 | 61.2 | 20.6 | 7.0 | 1.8 | .3 | ||
control file sequential read | 11.1K | 45.6 | 53.3 | .4 | .1 | .6 | .0 | ||
db file parallel read | 3 | 33.3 | 66.7 | ||||||
db file parallel write | 785 | 6.4 | 48.3 | 10.3 | 12.2 | 18.6 | 3.3 | .9 | |
db file scattered read | 11 | 9.1 | 18.2 | 9.1 | 36.4 | 18.2 | 9.1 | ||
db file sequential read | 311 | 18.3 | 43.1 | 1.9 | 7.1 | 20.6 | 7.4 | 1.6 | |
enq: AF - task serialization | 1 | 100.0 | |||||||
enq: CF - contention | 20 | 100.0 | |||||||
enq: CO - master slave det | 1194 | 98.2 | 1.5 | .2 | .1 | ||||
enq: CR - block range reuse ckpt | 1 | 100.0 | |||||||
enq: DR - contention | 2 | 100.0 | |||||||
enq: FB - contention | 3 | 66.7 | 33.3 | ||||||
enq: HW - contention | 9 | 100.0 | |||||||
enq: JQ - contention | 21 | 14.3 | 14.3 | 28.6 | 38.1 | 4.8 | |||
enq: JS - job run lock - synchronize | 2 | 50.0 | 50.0 | ||||||
enq: MW - contention | 2 | 100.0 | |||||||
enq: PI - contention | 5 | 100.0 | |||||||
enq: PS - contention | 56 | 98.2 | 1.8 | ||||||
enq: TA - contention | 12 | 91.7 | 8.3 | ||||||
enq: TK - Auto Task Serialization | 6 | 100.0 | |||||||
enq: TM - contention | 5 | 100.0 | |||||||
enq: TT - contention | 2 | 100.0 | |||||||
enq: UL - contention | 2 | 50.0 | 50.0 | ||||||
enq: WF - contention | 11 | 72.7 | 9.1 | 9.1 | 9.1 | ||||
gc buffer busy release | 1 | 100.0 | |||||||
gc cr block 2-way | 207 | 91.3 | 7.7 | .5 | .5 | ||||
gc cr block busy | 4 | 50.0 | 25.0 | 25.0 | |||||
gc cr grant 2-way | 215 | 98.1 | 1.9 | ||||||
gc cr multi block request | 12 | 100.0 | |||||||
gc current block 2-way | 320 | 95.9 | 3.8 | .3 | |||||
gc current block busy | 2 | 50.0 | 50.0 | ||||||
gc current grant 2-way | 48 | 93.8 | 6.3 | ||||||
gc current grant busy | 201 | 87.1 | 9.0 | 3.5 | .5 | ||||
gc current multi block request | 43 | 95.3 | 2.3 | 2.3 | |||||
gcs log flush sync | 29 | 44.8 | 10.3 | 3.4 | 10.3 | 27.6 | 3.4 | ||
ges message buffer allocation | 3880 | 100.0 | |||||||
kfk: async disk IO | 74 | 100.0 | |||||||
ksxr poll remote instances | 4548 | 100.0 | |||||||
latch: call allocation | 1 | 100.0 | |||||||
latch: ges resource hash list | 15 | 100.0 | |||||||
latch: shared pool | 1 | 100.0 | |||||||
library cache lock | 16 | 93.8 | 6.3 | ||||||
library cache pin | 40 | 95.0 | 2.5 | 2.5 | |||||
log file parallel write | 438 | 6.8 | 55.9 | 16.2 | 3.7 | 12.3 | 4.3 | .7 | |
log file sync | 45 | 2.2 | 51.1 | 31.1 | 4.4 | 6.7 | 4.4 | ||
name-service call wait | 18 | 5.6 | 16.7 | 77.8 | |||||
os thread startup | 133 | 7.5 | 85.7 | 6.8 | |||||
rdbms ipc reply | 144 | 100.0 | |||||||
reliable message | 72 | 97.2 | 1.4 | 1.4 | |||||
row cache lock | 37 | 97.3 | 2.7 | ||||||
ASM background timer | 716 | 100.0 | |||||||
DIAG idle wait | 147.9K | 1.9 | .1 | .1 | .2 | 39.6 | 31.0 | 27.1 | |
KSV master wait | 2152 | 100.0 | |||||||
PING | 1389 | 79.3 | .1 | 20.5 | |||||
PX Deq: Execute Reply | 39 | 100.0 | |||||||
PX Deq: Execution Msg | 149 | 87.2 | 8.7 | 2.0 | .7 | .7 | .7 | ||
PX Deq: Join ACK | 57 | 77.2 | 17.5 | 3.5 | 1.8 | ||||
PX Deq: Parse Reply | 48 | 87.5 | 12.5 | ||||||
PX Idle Wait | 1298 | .1 | .2 | .2 | .2 | .4 | 99.0 | ||
Space Manager: slave idle wait | 723 | .8 | 99.2 | ||||||
Streams AQ: RAC qmn coordinator idle wait | 254 | 100.0 | |||||||
Streams AQ: qmn coordinator idle wait | 250 | 50.0 | 50.0 | ||||||
Streams AQ: qmn slave idle wait | 125 | 100.0 | |||||||
class slave wait | 17 | 100.0 | |||||||
dispatcher timer | 59 | 100.0 | |||||||
gcs remote message | 107.8K | .9 | .4 | .3 | .2 | .3 | 48.3 | 49.5 | |
ges remote message | 43K | 1.8 | .3 | .3 | .5 | .8 | .9 | 95.4 | |
heartbeat monitor sleep | 717 | 100.0 | |||||||
jobq slave wait | 6279 | 100.0 | |||||||
pmon timer | 1347 | 11.3 | 88.7 | ||||||
rdbms ipc message | 60.7K | 3.2 | .4 | .2 | .1 | .4 | .3 | 63.6 | 31.8 |
shared server idle wait | 119 | 100.0 | |||||||
smon timer | 12 | 100.0 | |||||||
wait for unread message on broadcast channel | 7175 | .0 | .0 | .1 | 99.8 | .0 |
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
DFS lock handle | 5 | 97.3 | 1.1 | 1.6 | |||||
control file parallel write | 3 | 99.7 | .2 | .1 | |||||
control file sequential read | 1 | 100.0 | .0 | ||||||
db file parallel write | 7 | 99.1 | .8 | .1 | |||||
db file scattered read | 1 | 90.9 | 9.1 | ||||||
db file sequential read | 5 | 98.4 | 1.6 | ||||||
enq: WF - contention | 1 | 90.9 | 9.1 | ||||||
gc current grant busy | 1 | 99.5 | .5 | ||||||
gcs log flush sync | 1 | 96.6 | 3.4 | ||||||
log file parallel write | 3 | 99.3 | .7 | ||||||
log file sync | 2 | 95.6 | 4.4 | ||||||
name-service call wait | 14 | 22.2 | 5.6 | 72.2 | |||||
os thread startup | 9 | 93.2 | 2.3 | 4.5 | |||||
reliable message | 1 | 98.6 | 1.4 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
SYS$USERS | 6 | 4 | 0 | 37 |
SYS$BACKGROUND | 0 | 0 | 0 | 30 |
orcl | 0 | 0 | 0 | 0 |
orclXDB | 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 |
---|---|---|---|---|---|---|---|---|
SYS$USERS | 275 | 1 | 22 | 1 | 0 | 0 | 0 | 0 |
SYS$BACKGROUND | 196 | 1 | 217 | 3 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
3.51 | 39 | 0.09 | 60.61 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
2.27 | 42 | 0.05 | 39.07 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
1.30 | 5 | 0.26 | 22.50 | 1.46 | 0.00 | 6mvfay19q3v4n | SELECT COUNT(CLIENT_INFO) FROM... | |
0.74 | 1 | 0.74 | 12.81 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
0.29 | 1 | 0.29 | 5.02 | 3.09 | 65.59 | cpqs5k8jpd9kz | Oracle Enterprise Manager.rollup | SELECT MT.TARGET_GUID, LAST_LO... |
0.29 | 1 | 0.29 | 4.93 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.26 | 214 | 0.00 | 4.50 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
0.26 | 49 | 0.01 | 4.45 | 0.77 | 97.55 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
0.23 | 2 | 0.11 | 3.93 | 9.65 | 81.24 | fnk7155mk2jq6 | insert into wrh$_sysmetric_his... | |
0.17 | 716 | 0.00 | 2.95 | 7.02 | 5.97 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
0.14 | 1 | 0.14 | 2.45 | 2.82 | 13.72 | 7g732rx16j8jc | insert into WRH$_SERVICE_STAT ... | |
0.11 | 2,156 | 0.00 | 1.86 | 97.15 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
0.11 | 1 | 0.11 | 1.82 | 0.95 | 99.56 | ftq5ggts67764 | insert into WRH$_IC_DEVICE_STA... | |
0.10 | 44 | 0.00 | 1.75 | 43.39 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
0.08 | 1 | 0.08 | 1.40 | 3.71 | 91.27 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
0.08 | 1 | 0.08 | 1.36 | 1.27 | 96.97 | 46zsasxjf8hb9 | insert into WRH$_MEM_DYNAMIC_C... | |
0.08 | 725 | 0.00 | 1.32 | 18.25 | 0.00 | 3rrrnq9axk0dz | select count(*) from SYS.AQ$_S... | |
0.07 | 1 | 0.07 | 1.29 | 75.08 | 19.26 | bunssq950snhf | insert into wrh$_sga_target_ad... | |
0.07 | 2 | 0.04 | 1.21 | 4.26 | 90.77 | fh2sspdq8rm9p | insert into wrh$_waitclassmetr... | |
0.07 | 119 | 0.00 | 1.19 | 148.98 | 0.00 | aykvshm7zsabd | select size_for_estimate, size... | |
0.07 | 1 | 0.07 | 1.13 | 87.28 | 6.53 | dayq182sk41ks | insert into wrh$_memory_target... | |
0.06 | 1 | 0.06 | 1.11 | 4.65 | 39.15 | 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETY... | |
0.06 | 1 | 0.06 | 1.04 | 91.39 | 0.00 | bm2pwrpcr8ru6 | select sga_size s, sga_size_fa... | |
0.06 | 2 | 0.03 | 1.02 | 79.58 | 0.00 | ab3swhv5g138y | select OBJOID, CLSOID, RUNTIME... |
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
1.11 | 39 | 0.03 | 25.66 | 3.51 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.20 | 42 | 0.00 | 4.69 | 2.27 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
0.10 | 2,156 | 0.00 | 2.43 | 0.11 | 97.15 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
0.10 | 119 | 0.00 | 2.38 | 0.07 | 148.98 | 0.00 | aykvshm7zsabd | select size_for_estimate, size... | |
0.09 | 1 | 0.09 | 2.15 | 0.74 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
0.07 | 1 | 0.07 | 1.66 | 0.29 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.06 | 214 | 0.00 | 1.50 | 0.26 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
0.06 | 1 | 0.06 | 1.32 | 0.07 | 87.28 | 6.53 | dayq182sk41ks | insert into wrh$_memory_target... | |
0.06 | 1 | 0.06 | 1.29 | 0.07 | 75.08 | 19.26 | bunssq950snhf | insert into wrh$_sga_target_ad... | |
0.05 | 1 | 0.05 | 1.27 | 0.06 | 91.39 | 0.00 | bm2pwrpcr8ru6 | select sga_size s, sga_size_fa... | |
0.05 | 2 | 0.02 | 1.09 | 0.06 | 79.58 | 0.00 | ab3swhv5g138y | select OBJOID, CLSOID, RUNTIME... | |
0.04 | 44 | 0.00 | 1.02 | 0.10 | 43.39 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... |
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
0.82 | 39 | 0.02 | 35.94 | 3.51 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.64 | 42 | 0.02 | 28.03 | 2.27 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
0.57 | 1 | 0.57 | 25.09 | 0.74 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
0.25 | 49 | 0.01 | 11.09 | 0.26 | 0.77 | 97.55 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
0.19 | 1 | 0.19 | 8.42 | 0.29 | 3.09 | 65.59 | cpqs5k8jpd9kz | Oracle Enterprise Manager.rollup | SELECT MT.TARGET_GUID, LAST_LO... |
0.19 | 2 | 0.09 | 8.16 | 0.23 | 9.65 | 81.24 | fnk7155mk2jq6 | insert into wrh$_sysmetric_his... | |
0.14 | 214 | 0.00 | 6.16 | 0.26 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
0.13 | 1 | 0.13 | 5.77 | 0.29 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.10 | 1 | 0.10 | 4.62 | 0.11 | 0.95 | 99.56 | ftq5ggts67764 | insert into WRH$_IC_DEVICE_STA... | |
0.08 | 1 | 0.08 | 3.36 | 0.08 | 1.27 | 96.97 | 46zsasxjf8hb9 | insert into WRH$_MEM_DYNAMIC_C... | |
0.07 | 1 | 0.07 | 3.25 | 0.08 | 3.71 | 91.27 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
0.06 | 2 | 0.03 | 2.82 | 0.07 | 4.26 | 90.77 | fh2sspdq8rm9p | insert into wrh$_waitclassmetr... | |
0.05 | 132 | 0.00 | 1.99 | 0.06 | 12.72 | 82.27 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
0.04 | 25 | 0.00 | 1.92 | 0.05 | 0.00 | 93.93 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
0.04 | 1 | 0.04 | 1.61 | 0.04 | 2.63 | 95.92 | ak1t0asdv0yjs | insert into wrh$_current_block... | |
0.03 | 1 | 0.03 | 1.11 | 0.06 | 4.65 | 39.15 | 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETY... | |
0.02 | 1 | 0.02 | 1.03 | 0.03 | 7.39 | 86.38 | 6wm3n4d7bnddg | SELECT source, (case when tim... |
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
26,053 | 39 | 668.03 | 39.21 | 3.51 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
11,600 | 725 | 16.00 | 17.46 | 0.08 | 18.25 | 0.00 | 3rrrnq9axk0dz | select count(*) from SYS.AQ$_S... | |
7,580 | 42 | 180.48 | 11.41 | 2.27 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
7,304 | 2,156 | 3.39 | 10.99 | 0.11 | 97.15 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
5,087 | 1 | 5,087.00 | 7.66 | 0.74 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
3,080 | 2 | 1,540.00 | 4.64 | 0.06 | 79.58 | 0.00 | ab3swhv5g138y | select OBJOID, CLSOID, RUNTIME... | |
2,508 | 44 | 57.00 | 3.77 | 0.02 | 66.95 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
2,148 | 716 | 3.00 | 3.23 | 0.17 | 7.02 | 5.97 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
1,910 | 1 | 1,910.00 | 2.87 | 0.29 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
1,771 | 214 | 8.28 | 2.67 | 0.26 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
1,272 | 186 | 6.84 | 1.91 | 0.02 | 84.36 | 0.52 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... | |
1,053 | 81 | 13.00 | 1.58 | 0.03 | 31.36 | 3.92 | fsbqktj5vw6n9 | select next_run_date, obj#, ru... | |
924 | 6 | 154.00 | 1.39 | 0.01 | 101.07 | 3.25 | d8mayxqw0wnpv | SELECT OWNER FROM DBA_PROCEDUR... | |
911 | 50 | 18.22 | 1.37 | 0.02 | 109.45 | 0.00 | 4jrfrtx4u6zcx | SELECT TASK_TGT.TARGET_GUID TA... |
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
195 | 39 | 5.00 | 53.13 | 3.51 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
178 | 42 | 4.24 | 48.50 | 2.27 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
167 | 1 | 167.00 | 45.50 | 0.74 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
24 | 2 | 12.00 | 6.54 | 0.23 | 9.65 | 81.24 | fnk7155mk2jq6 | insert into wrh$_sysmetric_his... | |
22 | 1 | 22.00 | 5.99 | 0.29 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
15 | 49 | 0.31 | 4.09 | 0.26 | 0.77 | 97.55 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
11 | 214 | 0.05 | 3.00 | 0.26 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
8 | 1 | 8.00 | 2.18 | 0.08 | 3.71 | 91.27 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
8 | 1 | 8.00 | 2.18 | 0.03 | 7.39 | 86.38 | 6wm3n4d7bnddg | SELECT source, (case when tim... | |
6 | 1 | 6.00 | 1.63 | 0.29 | 3.09 | 65.59 | cpqs5k8jpd9kz | Oracle Enterprise Manager.rollup | SELECT MT.TARGET_GUID, LAST_LO... |
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
202 | 202 | 39 | 5.18 | 0.00 | 62.15 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
187 | 187 | 42 | 4.45 | 0.00 | 57.54 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
179 | 179 | 1 | 179.00 | 0.00 | 55.08 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
65 | 65 | 10 | 6.50 | 0.00 | 20.00 | bn4b3vjw2mj3u | SELECT OBJOID, CLSOID, DECODE(... | |
33 | 33 | 1 | 33.00 | 0.00 | 10.15 | 1cq3qr774cu45 | insert into WRH$_IOSTAT_FILETY... | |
18 | 18 | 1 | 18.00 | 0.00 | 5.54 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
15 | 15 | 49 | 0.31 | 0.00 | 4.62 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
6 | 6 | 1 | 6.00 | 0.00 | 1.85 | cpqs5k8jpd9kz | Oracle Enterprise Manager.rollup | SELECT MT.TARGET_GUID, LAST_LO... |
4 | 4 | 1 | 4.00 | 0.00 | 1.23 | 0z1031991bd7w | insert into wrh$_sysmetric_sum... | |
3 | 3 | 132 | 0.02 | 0.00 | 0.92 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... |
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
2,156 | 3,168 | 1.47 | 0.11 | 97.15 | 0.00 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
725 | 725 | 1.00 | 0.08 | 18.25 | 0.00 | 3rrrnq9axk0dz | select count(*) from SYS.AQ$_S... | |
716 | 58 | 0.08 | 0.17 | 7.02 | 5.97 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
280 | 280 | 1.00 | 0.01 | 77.75 | 0.00 | 089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIME... | |
214 | 214 | 1.00 | 0.26 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
186 | 186 | 1.00 | 0.02 | 86.25 | 0.00 | 5kyb5bvnu3s04 | SELECT DISTINCT METRIC_GUID FR... | |
186 | 186 | 1.00 | 0.02 | 84.36 | 0.52 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... | |
165 | 165 | 1.00 | 0.02 | 60.02 | 0.03 | 5j0q2df7hm1k2 | INSERT INTO MGMT_METRICS_RAW (... | |
160 | 160 | 1.00 | 0.00 | 55.20 | 0.00 | b0320g1xasbx7 | SEVERITY EVALUATION | SELECT TIMEZONE_REGION FROM MG... |
160 | 160 | 1.00 | 0.01 | 102.83 | 0.00 | c3hhngpbpvvmk | SEVERITY EVALUATION | SELECT MARKER_TIMESTAMP FROM M... |
160 | 160 | 1.00 | 0.01 | 176.59 | 0.00 | gj8t03n06hmq0 | SEVERITY EVALUATION | SELECT CURRENT_STATUS FROM MGM... |
132 | 132 | 1.00 | 0.06 | 12.72 | 82.27 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
128 | 78 | 0.61 | 0.01 | 106.55 | 0.00 | 08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MG... | |
119 | 2,499 | 21.00 | 0.07 | 148.98 | 0.00 | aykvshm7zsabd | select size_for_estimate, size... | |
116 | 0 | 0.00 | 0.01 | 115.43 | 0.00 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
116 | 116 | 1.00 | 0.02 | 97.24 | 0.00 | g00cj285jmgsw | update sys.mon_mods$ set inser... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
2,156 | 2,156 | 39.20 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
128 | 128 | 2.33 | 08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MG... | |
116 | 116 | 2.11 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
116 | 116 | 2.11 | g00cj285jmgsw | update sys.mon_mods$ set inser... | |
81 | 81 | 1.47 | fsbqktj5vw6n9 | select next_run_date, obj#, ru... | |
80 | 280 | 1.45 | 089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIME... | |
80 | 160 | 1.45 | c3hhngpbpvvmk | SEVERITY EVALUATION | SELECT MARKER_TIMESTAMP FROM M... |
80 | 80 | 1.45 | c8h3jdwaa532q | EM_PING | SELECT TO_NUMBER(PARAMETER_VAL... |
50 | 50 | 0.91 | 4jrfrtx4u6zcx | SELECT TASK_TGT.TARGET_GUID TA... | |
44 | 44 | 0.80 | 0k8522rmdzg4k | select privilege# from sysauth... |
Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
0.13 | 39 | 3.58 | 3.51 | 14.73 | 31.58 | 23.22 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.12 | 1 | 83.43 | 0.14 | 13.86 | 2.82 | 13.72 | 7g732rx16j8jc | insert into WRH$_SERVICE_STAT ... | |
0.05 | 42 | 2.37 | 2.27 | 6.29 | 8.96 | 28.09 | 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_... | |
0.05 | 44 | 49.17 | 0.10 | 5.84 | 43.39 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
0.05 | 716 | 29.14 | 0.17 | 5.83 | 7.02 | 5.97 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
0.05 | 1 | 6.27 | 0.74 | 5.45 | 12.52 | 76.69 | gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) F... | |
0.03 | 1 | 11.90 | 0.29 | 3.98 | 25.21 | 45.87 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
0.02 | 214 | 8.70 | 0.26 | 2.66 | 24.92 | 53.63 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
0.01 | 165 | 40.31 | 0.02 | 1.10 | 60.02 | 0.03 | 5j0q2df7hm1k2 | INSERT INTO MGMT_METRICS_RAW (... | |
0.01 | 2 | 3.65 | 0.23 | 0.97 | 9.65 | 81.24 | fnk7155mk2jq6 | insert into wrh$_sysmetric_his... | |
0.01 | 38 | 30.94 | 0.02 | 0.75 | 72.59 | 10.84 | 0xqn4sx1ytghr | select /*+ first_rows(1) no_ex... | |
0.01 | 186 | 25.02 | 0.02 | 0.69 | 84.36 | 0.52 | 8vwv6hx92ymmm | UPDATE MGMT_CURRENT_METRICS SE... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 0 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 43 | 0.01 | 0.09 |
CCursor + sql area evicted | 0 | 0.00 | 0.00 |
CPU used by this session | 431 | 0.12 | 0.95 |
CPU used when call started | 58 | 0.02 | 0.13 |
CR blocks created | 20 | 0.01 | 0.04 |
Commit SCN cached | 1 | 0.00 | 0.00 |
DB time | 315,004 | 87.88 | 693.84 |
DBWR checkpoint buffers written | 845 | 0.24 | 1.86 |
DBWR checkpoints | 0 | 0.00 | 0.00 |
DBWR fusion writes | 157 | 0.04 | 0.35 |
DBWR transaction table writes | 89 | 0.02 | 0.20 |
DBWR undo block writes | 222 | 0.06 | 0.49 |
DFO trees parallelized | 20 | 0.01 | 0.04 |
HSC Heap Segment Block Changes | 1,372 | 0.38 | 3.02 |
Heap Segment Array Inserts | 110 | 0.03 | 0.24 |
Heap Segment Array Updates | 4 | 0.00 | 0.01 |
PX local messages recv'd | 56 | 0.02 | 0.12 |
PX local messages sent | 56 | 0.02 | 0.12 |
PX remote messages recv'd | 72 | 0.02 | 0.16 |
PX remote messages sent | 72 | 0.02 | 0.16 |
Parallel operations not downgraded | 20 | 0.01 | 0.04 |
RowCR attempts | 231 | 0.06 | 0.51 |
RowCR hits | 231 | 0.06 | 0.51 |
SMON posted for undo segment shrink | 1 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 0 | 0.00 | 0.00 |
active txn count during cleanout | 55 | 0.02 | 0.12 |
application wait time | 1 | 0.00 | 0.00 |
background timeouts | 22,189 | 6.19 | 48.87 |
buffer is not pinned count | 24,975 | 6.97 | 55.01 |
buffer is pinned count | 12,491 | 3.48 | 27.51 |
bytes received via SQL*Net from client | 0 | 0.00 | 0.00 |
bytes sent via SQL*Net to client | 0 | 0.00 | 0.00 |
calls to get snapshot scn: kcmgss | 13,302 | 3.71 | 29.30 |
calls to kcmgas | 2,077 | 0.58 | 4.57 |
calls to kcmgcs | 6,618 | 1.85 | 14.58 |
cell physical IO interconnect bytes | 237,905,920 | 66,369.22 | 524,021.85 |
change write time | 10 | 0.00 | 0.02 |
cleanout - number of ktugct calls | 57 | 0.02 | 0.13 |
cleanouts and rollbacks - consistent read gets | 0 | 0.00 | 0.00 |
cleanouts only - consistent read gets | 1 | 0.00 | 0.00 |
cluster key scan block gets | 2,199 | 0.61 | 4.84 |
cluster key scans | 1,959 | 0.55 | 4.31 |
cluster wait time | 74 | 0.02 | 0.16 |
commit cleanout failures: block lost | 14 | 0.00 | 0.03 |
commit cleanout failures: callback failure | 3 | 0.00 | 0.01 |
commit cleanouts | 2,173 | 0.61 | 4.79 |
commit cleanouts successfully completed | 2,156 | 0.60 | 4.75 |
commit txn count during cleanout | 30 | 0.01 | 0.07 |
concurrency wait time | 372 | 0.10 | 0.82 |
consistent changes | 55 | 0.02 | 0.12 |
consistent gets | 57,736 | 16.11 | 127.17 |
consistent gets - examination | 18,822 | 5.25 | 41.46 |
consistent gets from cache | 57,736 | 16.11 | 127.17 |
consistent gets from cache (fastpath) | 35,779 | 9.98 | 78.81 |
cursor authentications | 61 | 0.02 | 0.13 |
data blocks consistent reads - undo records applied | 40 | 0.01 | 0.09 |
db block changes | 9,732 | 2.71 | 21.44 |
db block gets | 8,713 | 2.43 | 19.19 |
db block gets from cache | 8,713 | 2.43 | 19.19 |
db block gets from cache (fastpath) | 2,397 | 0.67 | 5.28 |
deferred (CURRENT) block cleanout applications | 1,189 | 0.33 | 2.62 |
dirty buffers inspected | 0 | 0.00 | 0.00 |
enqueue conversions | 807 | 0.23 | 1.78 |
enqueue releases | 41,250 | 11.51 | 90.86 |
enqueue requests | 42,458 | 11.84 | 93.52 |
enqueue timeouts | 1,208 | 0.34 | 2.66 |
enqueue waits | 1,358 | 0.38 | 2.99 |
exchange deadlocks | 1 | 0.00 | 0.00 |
execute count | 10,238 | 2.86 | 22.55 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 4,340,718 | 1,210.94 | 9,561.05 |
free buffer inspected | 1,070 | 0.30 | 2.36 |
free buffer requested | 1,906 | 0.53 | 4.20 |
gc CPU used by this session | 47 | 0.01 | 0.10 |
gc blocks compressed | 606 | 0.17 | 1.33 |
gc cr block build time | 1 | 0.00 | 0.00 |
gc cr block flush time | 12 | 0.00 | 0.03 |
gc cr block receive time | 12 | 0.00 | 0.03 |
gc cr block send time | 3 | 0.00 | 0.01 |
gc cr blocks received | 219 | 0.06 | 0.48 |
gc cr blocks served | 501 | 0.14 | 1.10 |
gc current block flush time | 11 | 0.00 | 0.02 |
gc current block pin time | 1 | 0.00 | 0.00 |
gc current block receive time | 19 | 0.01 | 0.04 |
gc current block send time | 2 | 0.00 | 0.00 |
gc current blocks received | 331 | 0.09 | 0.73 |
gc current blocks served | 290 | 0.08 | 0.64 |
gc kbytes saved | 3,002 | 0.84 | 6.61 |
gc kbytes sent | 3,326 | 0.93 | 7.33 |
gc local grants | 179 | 0.05 | 0.39 |
gc remote grants | 499 | 0.14 | 1.10 |
gcs messages sent | 3,103 | 0.87 | 6.83 |
ges messages sent | 2,713 | 0.76 | 5.98 |
global enqueue get time | 204 | 0.06 | 0.45 |
global enqueue gets async | 90 | 0.03 | 0.20 |
global enqueue gets sync | 14,152 | 3.95 | 31.17 |
global enqueue releases | 12,699 | 3.54 | 27.97 |
heap block compress | 24 | 0.01 | 0.05 |
hot buffers moved to head of LRU | 2 | 0.00 | 0.00 |
immediate (CR) block cleanout applications | 1 | 0.00 | 0.00 |
immediate (CURRENT) block cleanout applications | 551 | 0.15 | 1.21 |
index crx upgrade (positioned) | 725 | 0.20 | 1.60 |
index fast full scans (full) | 4 | 0.00 | 0.01 |
index fetch by key | 9,480 | 2.64 | 20.88 |
index scans kdiixs1 | 7,958 | 2.22 | 17.53 |
leaf node 90-10 splits | 17 | 0.00 | 0.04 |
leaf node splits | 26 | 0.01 | 0.06 |
lob reads | 0 | 0.00 | 0.00 |
lob writes | 2 | 0.00 | 0.00 |
lob writes unaligned | 2 | 0.00 | 0.00 |
logons cumulative | 202 | 0.06 | 0.44 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 1,705 | 0.48 | 3.76 |
messages sent | 1,705 | 0.48 | 3.76 |
min active SCN optimization applied on CR | 4 | 0.00 | 0.01 |
no buffer to keep pinned count | 2 | 0.00 | 0.00 |
no work - consistent read gets | 30,828 | 8.60 | 67.90 |
non-idle wait count | 102,016 | 28.46 | 224.70 |
non-idle wait time | 3,363 | 0.94 | 7.41 |
opened cursors cumulative | 8,851 | 2.47 | 19.50 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (hard) | 5 | 0.00 | 0.01 |
parse count (total) | 5,500 | 1.53 | 12.11 |
parse time cpu | 15 | 0.00 | 0.03 |
parse time elapsed | 26 | 0.01 | 0.06 |
physical read IO requests | 325 | 0.09 | 0.72 |
physical read bytes | 3,006,464 | 838.72 | 6,622.17 |
physical read total IO requests | 11,471 | 3.20 | 25.27 |
physical read total bytes | 185,581,568 | 51,772.16 | 408,769.97 |
physical read total multi block requests | 0 | 0.00 | 0.00 |
physical reads | 367 | 0.10 | 0.81 |
physical reads cache | 367 | 0.10 | 0.81 |
physical reads cache prefetch | 49 | 0.01 | 0.11 |
physical reads direct | 0 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 41 | 0.01 | 0.09 |
physical write IO requests | 787 | 0.22 | 1.73 |
physical write bytes | 7,995,392 | 2,230.49 | 17,611.00 |
physical write total IO requests | 4,067 | 1.13 | 8.96 |
physical write total bytes | 52,324,352 | 14,597.06 | 115,251.88 |
physical write total multi block requests | 6 | 0.00 | 0.01 |
physical writes | 976 | 0.27 | 2.15 |
physical writes from cache | 976 | 0.27 | 2.15 |
physical writes non checkpoint | 489 | 0.14 | 1.08 |
pinned buffers inspected | 1 | 0.00 | 0.00 |
pinned cursors current | 0 | 0.00 | 0.00 |
queries parallelized | 20 | 0.01 | 0.04 |
recursive calls | 61,006 | 17.02 | 134.37 |
recursive cpu usage | 191 | 0.05 | 0.42 |
redo blocks checksummed by FG (exclusive) | 1,979 | 0.55 | 4.36 |
redo blocks written | 5,146 | 1.44 | 11.33 |
redo entries | 6,159 | 1.72 | 13.57 |
redo ordering marks | 125 | 0.03 | 0.28 |
redo size | 2,392,848 | 667.54 | 5,270.59 |
redo subscn max counts | 210 | 0.06 | 0.46 |
redo synch time | 24 | 0.01 | 0.05 |
redo synch writes | 45 | 0.01 | 0.10 |
redo wastage | 116,768 | 32.58 | 257.20 |
redo write broadcast ack count | 2 | 0.00 | 0.00 |
redo write broadcast ack time | 1,393 | 0.39 | 3.07 |
redo write time | 198 | 0.06 | 0.44 |
redo writes | 447 | 0.12 | 0.98 |
rollbacks only - consistent read gets | 20 | 0.01 | 0.04 |
rows fetched via callback | 4,098 | 1.14 | 9.03 |
session cursor cache hits | 6,016 | 1.68 | 13.25 |
session logical reads | 66,449 | 18.54 | 146.36 |
shared hash latch upgrades - no wait | 2,585 | 0.72 | 5.69 |
sorts (memory) | 6,944 | 1.94 | 15.30 |
sorts (rows) | 23,234 | 6.48 | 51.18 |
sql area evicted | 0 | 0.00 | 0.00 |
sql area purged | 0 | 0.00 | 0.00 |
summed dirty queue length | 0 | 0.00 | 0.00 |
switch current to new buffer | 6 | 0.00 | 0.01 |
table fetch by rowid | 9,637 | 2.69 | 21.23 |
table fetch continued row | 4 | 0.00 | 0.01 |
table scan blocks gotten | 14,351 | 4.00 | 31.61 |
table scan rows gotten | 212,954 | 59.41 | 469.06 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 2,092 | 0.58 | 4.61 |
total cf enq hold time | 50 | 0.01 | 0.11 |
total number of cf enq holders | 156 | 0.04 | 0.34 |
total number of times SMON posted | 1 | 0.00 | 0.00 |
transaction lock background gets | 0 | 0.00 | 0.00 |
transaction lock foreground requests | 0 | 0.00 | 0.00 |
transaction lock foreground wait time | 0 | 0.00 | 0.00 |
undo change vector size | 796,224 | 222.12 | 1,753.80 |
user I/O wait time | 218 | 0.06 | 0.48 |
user calls | 672 | 0.19 | 1.48 |
user commits | 454 | 0.13 | 1.00 |
workarea executions - optimal | 2,620 | 0.73 | 5.77 |
Statistic | Begin Value | End Value |
---|---|---|
opened cursors current | 34 | 34 |
logons current | 41 | 41 |
session uga memory max | 215,311,152 | 351,856,208 |
session pga memory | 251,180,280 | 395,955,888 |
session pga memory max | 264,025,336 | 410,308,272 |
session cursor cache count | 2,397 | 5,799 |
session uga memory | 103,114,294,840 | 287,808,115,408 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 0 | 0.00 |
Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Others | 174M | 3.11 | .048541 | 38M | 0.67 | .010600 | 12.3K | 1.04 |
DBWR | 0M | 0.00 | 0M | 8M | 0.22 | .002231 | 0 | |
LGWR | 0M | 0.00 | 0M | 5M | 0.24 | .001394 | 0 | |
Buffer Cache Reads | 3M | 0.09 | .000836 | 0M | 0.00 | 0M | 319 | 6.12 |
TOTAL: | 177M | 3.20 | .049378 | 51M | 1.13 | .014227 | 12.7K | 1.16 |
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Control File | 174M | 3.11 | .048541 | 38M | 0.67 | .010600 | 0.70 | |
Data File | 3M | 0.09 | .000836 | 6M | 0.22 | .001673 | 5.89 | |
Log File | 0M | 0.00 | 0M | 5M | 0.25 | .001394 | ||
TOTAL: | 177M | 3.20 | .049378 | 49M | 1.13 | .013669 | 0.85 |
Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
---|---|---|---|---|---|---|---|---|
Others | 174M | 3.11 | .048541 | 38M | 0.67 | .010600 | 11.1K | 0.70 |
Others (Control File) | 174M | 3.11 | .048541 | 38M | 0.67 | .010600 | 11.1K | 0.70 |
Others (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 5 | 0.00 |
DBWR | 0M | 0.00 | 0M | 8M | 0.22 | .002231 | 0 | |
DBWR (Data File) | 0M | 0.00 | 0M | 8M | 0.22 | .002231 | 0 | |
LGWR | 0M | 0.00 | 0M | 5M | 0.25 | .001394 | 0 | |
LGWR (Log File) | 0M | 0.00 | 0M | 5M | 0.25 | .001394 | 0 | |
Buffer Cache Reads | 3M | 0.09 | .000836 | 0M | 0.00 | 0M | 319 | 6.95 |
Buffer Cache Reads (Data File) | 3M | 0.09 | .000836 | 0M | 0.00 | 0M | 319 | 6.95 |
TOTAL: | 177M | 3.20 | .049378 | 51M | 1.13 | .014227 | 11.5K | 0.87 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
SYSAUX | 162 | 0 | 0.00 | 1.27 | 559 | 0 | 0 | 0.00 |
SYSTEM | 171 | 0 | 0.00 | 1.00 | 34 | 0 | 0 | 0.00 |
UNDOTBS2 | 0 | 0 | 0.00 | 0.00 | 194 | 0 | 1 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
SYSAUX | +DATA/orcl/datafile/sysaux.257.857558709 | 162 | 0 | 0.00 | 1.27 | 559 | 0 | 0 | 0.00 |
SYSTEM | +DATA/orcl/datafile/system.256.857558707 | 171 | 0 | 0.00 | 1.00 | 34 | 0 | 0 | 0.00 |
UNDOTBS2 | +DATA/orcl/datafile/undotbs2.264.857558977 | 0 | 0 | 194 | 0 | 1 | 0.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 11,775 | 99 | 66,498 | 375 | 976 | 0 | 0 | 1 |
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 845 | 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 | 0 | 250 | 1366 | 1079 | 82944 | 1079 | 0 | ||
E | 0 | 0 | 233 | 1379 | 941 | 82944 | 941 | 0 |
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 | 8 | 0.08 | 1 | 2.02 | 23 | 1 | 0.00 |
D | 16 | 0.16 | 2 | 1.46 | 17 | 1 | 0.00 |
D | 24 | 0.24 | 3 | 1.28 | 15 | 1 | 0.00 |
D | 32 | 0.32 | 4 | 1.16 | 13 | 1 | 0.00 |
D | 40 | 0.40 | 5 | 1.12 | 13 | 1 | 0.00 |
D | 48 | 0.48 | 6 | 1.08 | 12 | 1 | 0.00 |
D | 56 | 0.56 | 7 | 1.03 | 12 | 1 | 0.00 |
D | 64 | 0.64 | 8 | 1.02 | 12 | 1 | 0.00 |
D | 72 | 0.72 | 8 | 1.01 | 12 | 1 | 0.00 |
D | 80 | 0.80 | 9 | 1.00 | 12 | 1 | 0.00 |
D | 88 | 0.88 | 10 | 1.00 | 11 | 1 | 0.00 |
D | 96 | 0.96 | 11 | 1.00 | 11 | 1 | 0.00 |
D | 100 | 1.00 | 12 | 1.00 | 11 | 1 | 0.00 |
D | 104 | 1.04 | 12 | 1.00 | 11 | 1 | 0.00 |
D | 112 | 1.12 | 13 | 1.00 | 11 | 1 | 0.00 |
D | 120 | 1.20 | 14 | 1.00 | 11 | 1 | 0.00 |
D | 128 | 1.28 | 15 | 1.00 | 11 | 1 | 0.00 |
D | 136 | 1.36 | 16 | 1.00 | 11 | 1 | 0.00 |
D | 144 | 1.44 | 17 | 1.00 | 11 | 1 | 0.00 |
D | 152 | 1.52 | 18 | 1.00 | 11 | 1 | 0.00 |
D | 160 | 1.60 | 19 | 1.00 | 11 | 1 | 0.00 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 23 | 0 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 2,604 | 2,604 | 0 | 0 |
64K | 128K | 4 | 4 | 0 | 0 |
512K | 1024K | 10 | 10 | 0 | 0 |
4M | 8M | 2 | 2 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count | Estd Time |
---|---|---|---|---|---|---|
51 | 0.13 | 88.96 | 7.84 | 92.00 | 2 | 0 |
101 | 0.25 | 88.96 | 7.84 | 92.00 | 2 | 0 |
202 | 0.50 | 88.96 | 0.00 | 100.00 | 0 | 0 |
303 | 0.75 | 88.96 | 0.00 | 100.00 | 0 | 0 |
404 | 1.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
485 | 1.20 | 88.96 | 0.00 | 100.00 | 0 | 0 |
566 | 1.40 | 88.96 | 0.00 | 100.00 | 0 | 0 |
646 | 1.60 | 88.96 | 0.00 | 100.00 | 0 | 0 |
727 | 1.80 | 88.96 | 0.00 | 100.00 | 0 | 0 |
808 | 2.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
1,212 | 3.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
1,616 | 4.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
2,424 | 6.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
3,232 | 8.00 | 88.96 | 0.00 | 100.00 | 0 | 0 |
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) |
---|---|---|---|---|---|---|---|---|
140 | 0.50 | 16 | 1,039 | 748 | 0.99 | 32 | 1.33 | 24 |
168 | 0.60 | 38 | 2,453 | 753 | 1.00 | 27 | 1.13 | 42 |
196 | 0.70 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
224 | 0.80 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
252 | 0.90 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
280 | 1.00 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
308 | 1.10 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
336 | 1.20 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
364 | 1.30 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
392 | 1.40 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
420 | 1.50 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
448 | 1.60 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
476 | 1.70 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
504 | 1.80 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
532 | 1.90 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
560 | 2.00 | 45 | 2,931 | 756 | 1.00 | 24 | 1.00 | 42 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
200 | 0.50 | 106 | 23,041 |
300 | 0.75 | 103 | 11,460 |
400 | 1.00 | 103 | 11,419 |
500 | 1.25 | 103 | 11,419 |
600 | 1.50 | 103 | 11,419 |
700 | 1.75 | 103 | 11,419 |
800 | 2.00 | 103 | 11,419 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
undo header | 1 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
CO-KTUCLO Master Slave enq (master slave det) | 1,194 | 0 | 1,194 | 1,194 | 1 | 0.49 |
WF-AWR Flush | 22 | 22 | 0 | 11 | 0 | 17.27 |
JQ-Job Queue | 57 | 43 | 14 | 21 | 0 | 3.81 |
PS-PX Process Reservation | 138 | 138 | 0 | 56 | 0 | 0.54 |
CR-Reuse Block Range (block range reuse ckpt) | 5 | 5 | 0 | 1 | 0 | 20.00 |
TX-Transaction (index contention) | 4 | 4 | 0 | 3 | 0 | 3.33 |
MW-MWIN Schedule | 2 | 2 | 0 | 2 | 0 | 5.00 |
UL-User-defined | 4 | 4 | 0 | 2 | 0 | 5.00 |
CF-Controlfile Transaction | 7,739 | 7,739 | 0 | 20 | 0 | 0.00 |
HW-Segment High Water Mark | 78 | 78 | 0 | 14 | 0 | 0.00 |
TA-Instance Undo | 12 | 12 | 0 | 12 | 0 | 0.00 |
TK-Auto Task Serialization (Auto Task Serialization) | 6 | 6 | 0 | 6 | 0 | 0.00 |
FB-Format Block | 5 | 5 | 0 | 5 | 0 | 0.00 |
PI-Remote PX Process Spawn Status | 11 | 11 | 0 | 5 | 0 | 0.00 |
TM-DML | 4,265 | 4,265 | 0 | 5 | 0 | 0.00 |
TT-Tablespace | 61 | 61 | 0 | 3 | 0 | 0.00 |
DR-Distributed Recovery | 2 | 2 | 0 | 2 | 0 | 0.00 |
JS-Job Scheduler (job run lock - synchronize) | 2 | 2 | 0 | 2 | 0 | 0.00 |
AF-Advisor Framework (task serialization) | 13 | 13 | 0 | 1 | 0 | 0.00 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
5 | 0.13 | 672 | 877 | 3 | 19.2/29.5 | 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 |
---|---|---|---|---|---|---|---|
25-7月 12:58 | 13 | 111 | 864 | 3 | 29 | 0/0 | 0/0/0/0/0/0 |
25-7月 12:48 | 4 | 78 | 263 | 2 | 19 | 0/0 | 0/0/0/0/0/0 |
25-7月 12:38 | 1 | 23 | 871 | 1 | 29 | 0/0 | 0/0/0/0/0/0 |
25-7月 12:28 | 17 | 95 | 270 | 3 | 19 | 0/0 | 0/0/0/0/0/0 |
25-7月 12:18 | 7 | 206 | 877 | 1 | 29 | 0/0 | 0/0/0/0/0/0 |
25-7月 12:08 | 88 | 159 | 275 | 3 | 19 | 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 | 1 | 0.00 | 0 | 0 | ||
ASM Keyed state latch | 59 | 0.00 | 0 | 0 | ||
ASM db client latch | 2,401 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 83 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 31,121 | 0.00 | 0 | 0 | ||
ASM network background latch | 1,432 | 0.00 | 0 | 0 | ||
ASM network state latch | 64 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 26,422 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,194 | 0.00 | 0 | 0 | ||
Consistent RBA | 451 | 0.00 | 0 | 0 | ||
DML lock allocation | 8,542 | 0.00 | 0 | 0 | ||
Event Group Locks | 134 | 0.00 | 0 | 0 | ||
FAL Queue | 96 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 281 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
IPC other latch | 31 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 437 | 0.00 | 0 | 435 | 0.00 | |
In memory undo latch | 1 | 0.00 | 0 | 0 | ||
JS Sh mem access | 9 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 828 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 828 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 718 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 12 | 0.00 | 0 | 0 | ||
JS queue access latch | 13 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 26,132 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 221 | 0.00 | 0 | 0 | ||
KFC FX Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFC Hash Latch | 1 | 0.00 | 0 | 0 | ||
KFCL LE Freelist | 1 | 0.00 | 0 | 0 | ||
KFK SGA Libload latch | 476 | 0.00 | 0 | 0 | ||
KFMD SGA | 42 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 1 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 1 | 0.00 | 0 | 0 | ||
KJC message pool free list | 667 | 0.00 | 0 | 237 | 0.00 | |
KJCT flow control latch | 9,820 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 1,194 | 0.00 | 0 | 0 | ||
KSXR large replies | 2 | 0.00 | 0 | 0 | ||
KTF sga latch | 26 | 0.00 | 0 | 1,142 | 0.00 | |
KWQMN job cache list latch | 264 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 8 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 54 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
Lsod array latch | 243 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 72 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 1,194 | 0.00 | |
Memory Queue | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #1 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #2 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #3 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Message Subscriber #4 | 1 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 1 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 20 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
OS process | 1,198 | 0.00 | 0 | 0 | ||
OS process allocation | 1,992 | 0.00 | 0 | 0 | ||
OS process: request allocation | 266 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 253 | 0.00 | 0 | 0 | ||
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time plan statistics latch | 59 | 0.00 | 0 | 0 | ||
SGA blob parent | 1 | 0.00 | 0 | 0 | ||
SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
SGA heap locks | 1 | 0.00 | 0 | 0 | ||
SGA pool locks | 1 | 0.00 | 0 | 0 | ||
SQL memory manager latch | 120 | 0.00 | 0 | 1,192 | 0.00 | |
SQL memory manager workarea list latch | 80,546 | 0.00 | 0 | 0 | ||
Shared B-Tree | 288 | 0.00 | 0 | 0 | ||
Streams Generic | 1 | 0.00 | 0 | 0 | ||
Testing | 1 | 0.00 | 0 | 0 | ||
Token Manager | 1 | 0.00 | 0 | 0 | ||
WCR: sync | 1 | 0.00 | 0 | 0 | ||
Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
X$KSFQP | 1 | 0.00 | 0 | 0 | ||
XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
XDB used session pool | 1 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 2,145 | 0.00 | 0 | 0 | ||
active service list | 13,721 | 0.00 | 0 | 1,931 | 0.00 | |
archive control | 60 | 0.00 | 0 | 0 | ||
archive process latch | 288 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
business card | 41 | 0.00 | 0 | 0 | ||
cache buffer handles | 460 | 0.00 | 0 | 0 | ||
cache buffers chains | 141,389 | 0.00 | 1.00 | 0 | 4,654 | 0.02 |
cache buffers lru chain | 3,990 | 0.00 | 0 | 5,342 | 0.00 | |
cache table scan latch | 1 | 0.00 | 0 | 1 | 0.00 | |
call allocation | 1,089 | 0.18 | 0.50 | 0 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 321 | 0.00 | 0 | 0 | ||
channel operations parent latch | 362,043 | 0.00 | 0 | 0 | ||
checkpoint queue latch | 70,776 | 0.00 | 0 | 1,106 | 0.00 | |
client/application info | 1,139 | 0.00 | 0 | 0 | ||
compile environment latch | 208 | 0.00 | 0 | 0 | ||
cp cmon/server latch | 1 | 0.00 | 0 | 0 | ||
cp pool latch | 1 | 0.00 | 0 | 0 | ||
cp server hash latch | 1 | 0.00 | 0 | 0 | ||
cp sga latch | 64 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 64 | 0.00 | 0 | 0 | ||
dml lock allocation | 64 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dummy allocation | 417 | 0.00 | 0 | 0 | ||
enqueue hash chains | 95,486 | 0.00 | 0.00 | 0 | 1 | 0.00 |
enqueues | 74,677 | 0.00 | 0 | 0 | ||
error message lists | 88 | 0.00 | 0 | 0 | ||
fifth spare latch | 1 | 0.00 | 0 | 0 | ||
file cache latch | 219 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
gc element | 9,090 | 0.01 | 1.00 | 0 | 44 | 0.00 |
gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 510 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 9,757,402 | 0.00 | 0 | 131 | 0.00 | |
gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
gcs remaster request queue | 3 | 0.00 | 0 | 0 | ||
gcs remastering latch | 237 | 0.00 | 0 | 0 | ||
gcs resource freelist | 319 | 0.00 | 0 | 11 | 0.00 | |
gcs resource hash | 7,600 | 0.00 | 0 | 6 | 0.00 | |
gcs resource scan list | 13 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 436 | 0.00 | 0 | 113 | 0.00 | |
ges caches resource lists | 9,287 | 0.00 | 0 | 33,712 | 0.00 | |
ges deadlock list | 120 | 0.00 | 0 | 0 | ||
ges domain table | 27,669 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 28,617 | 0.00 | 0 | 0 | ||
ges group table | 38,937 | 0.00 | 0 | 0 | ||
ges process hash list | 1,978 | 0.00 | 0 | 0 | ||
ges process parent latch | 57,534 | 0.00 | 0 | 0 | ||
ges process table freelist | 266 | 0.00 | 0 | 0 | ||
ges resource hash list | 42,588 | 0.04 | 0.83 | 0 | 480 | 0.00 |
ges resource scan list | 31 | 0.00 | 0 | 0 | ||
ges resource table freelist | 903 | 0.00 | 0 | 0 | ||
ges timeout list | 182 | 0.00 | 0 | 27 | 0.00 | |
ges value block free list | 9 | 0.00 | 0 | 0 | ||
global tx hash mapping | 1 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table column usage latch | 123 | 0.00 | 0 | 2,464 | 0.00 | |
hash table modification latch | 79 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 719 | 0.00 | |
heartbeat structure management | 0 | 0 | 717 | 0.00 | ||
intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
job workq parent latch | 60 | 0.00 | 0 | 59 | 1.69 | |
job_queue_processes free list latch | 118 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 827 | 0.00 | 0 | 0 | ||
k2q global data latch | 2,388 | 0.00 | 0 | 0 | ||
k2q lock allocation | 1 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kks stats | 8 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 528 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksim membership request latch | 336 | 0.00 | 0 | 1,558 | 0.00 | |
kss move lock | 35 | 0.00 | 0 | 0 | ||
ksuosstats global area | 242 | 0.00 | 0 | 0 | ||
ksv allocation latch | 132 | 0.00 | 0 | 0 | ||
ksv class latch | 6,525 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksxp shared latch | 266 | 0.00 | 0 | 0 | ||
ksxp so latch | 266 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 266 | 0.00 | 0 | 0 | ||
ktm global data | 20 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 125 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 1,521 | 0.00 | 0 | 0 | ||
list of block allocation | 145 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 13 | 0.00 | 0 | 0 | ||
lob segment query latch | 1 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
logical standby cache | 1 | 0.00 | 0 | 0 | ||
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 1 | 0.00 | 0 | 0 | ||
managed standby latch | 96 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 4,784 | 0.00 | 0 | 0 | ||
messages | 124,632 | 0.00 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 1,521 | 0.00 | 0 | 0 | ||
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 618 | 0.00 | 0 | 0 | ||
name-service memory objects | 398 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 27,386 | 0.00 | 0 | 0 | ||
name-service namespace objects | 12 | 0.00 | 0 | 0 | ||
name-service pending queue | 202 | 0.00 | 0 | 0 | ||
name-service request | 36 | 0.00 | 0 | 0 | ||
name-service request queue | 33,386 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 64 | 0.00 | 0 | 0 | ||
object queue header heap | 4,440 | 0.00 | 0 | 136 | 0.00 | |
object queue header operation | 27,654 | 0.00 | 0 | 0 | ||
object stats modification | 115 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 933 | 0.00 | 0 | 0 | ||
parallel query stats | 91 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 240 | 0.00 | 0 | 0 | ||
parameter list | 152 | 0.00 | 0 | 0 | ||
parameter table management | 416 | 0.00 | 0 | 0 | ||
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 1 | 0.00 | 0 | 0 | ||
pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 197 | 0.00 | 0 | 112 | 0.00 | |
process allocation | 399 | 0.00 | 0 | 133 | 0.00 | |
process group creation | 266 | 0.00 | 0 | 0 | ||
process queue | 245 | 0.00 | 0 | 0 | ||
process queue reference | 3,770 | 0.00 | 0 | 354 | 0.00 | |
qmn task queue latch | 512 | 0.00 | 0 | 0 | ||
query server freelists | 201 | 0.00 | 0 | 0 | ||
query server process | 6 | 0.00 | 0 | 6 | 0.00 | |
queued dump request | 12 | 0.00 | 0 | 0 | ||
queuing load statistics | 1 | 0.00 | 0 | 0 | ||
recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
redo allocation | 3,494 | 0.06 | 0.00 | 0 | 6,210 | 0.02 |
redo copy | 1 | 0.00 | 0 | 6,210 | 0.21 | |
redo writing | 6,001 | 0.00 | 0 | 0 | ||
resmgr group change latch | 346 | 0.00 | 0 | 0 | ||
resmgr:active threads | 17,721 | 0.00 | 0 | 602 | 0.00 | |
resmgr:actses change group | 124 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 12 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 438 | 0.00 | 0 | 0 | ||
resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:schema config | 182,781 | 0.00 | 0 | 60 | 0.00 | |
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 49,065 | 0.00 | 0 | 0 | ||
rules engine aggregate statistics | 4 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 8 | 0.00 | 0 | 0 | ||
second spare latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 162 | 0.00 | 0 | 0 | ||
session allocation | 853 | 0.00 | 0 | 284 | 0.00 | |
session idle bit | 1,433 | 0.00 | 0 | 0 | ||
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 440 | 0.00 | 0 | 0 | ||
session switching | 730 | 0.00 | 0 | 0 | ||
session timer | 1,347 | 0.00 | 0 | 0 | ||
shared pool | 16,654 | 0.05 | 0.13 | 0 | 0 | |
shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
shared pool simulator | 69 | 0.00 | 0 | 0 | ||
sim partition latch | 1 | 0.00 | 0 | 0 | ||
simulator hash latch | 5,093 | 0.00 | 0 | 0 | ||
simulator lru latch | 1 | 0.00 | 0 | 5,046 | 0.00 | |
sort extent pool | 118 | 0.00 | 0 | 0 | ||
space background state object latch | 12 | 0.00 | 0 | 0 | ||
space background task latch | 2,658 | 0.00 | 0 | 2,388 | 0.00 | |
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 560 | 0.00 | 0 | 0 | ||
tablespace key chain | 1 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
third spare latch | 1 | 0.00 | 0 | 0 | ||
threshold alerts latch | 122 | 0.00 | 0 | 0 | ||
transaction allocation | 633 | 0.00 | 0 | 0 | ||
undo global data | 2,560 | 0.00 | 0 | 0 | ||
virtual circuit buffers | 1 | 0.00 | 0 | 0 | ||
virtual circuit holder | 1 | 0.00 | 0 | 0 | ||
virtual circuit queues | 1 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
ges resource hash list | 42,588 | 18 | 15 | 3 |
shared pool | 16,654 | 8 | 1 | 7 |
call allocation | 1,089 | 2 | 1 | 1 |
cache buffers chains | 141,389 | 1 | 1 | 0 |
gc element | 9,090 | 1 | 1 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
call allocation | ksuxds | 0 | 1 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 13 | 0 |
ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 1 | 1 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 1 | 0 |
shared pool | kghalo | 0 | 1 | 1 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSAUX | AQ$_SYS$SERVICE_METRICS_TAB_S | TABLE | 11,600 | 17.46 | |
SYS | SYSTEM | I_SYSAUTH1 | INDEX | 9,632 | 14.50 | |
SYS | SYSTEM | JOB$ | TABLE | 3,104 | 4.67 | |
SYS | SYSTEM | I_OBJ2 | INDEX | 3,088 | 4.65 | |
SYS | SYSTEM | I_OBJ# | INDEX | 2,832 | 4.26 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | TAB$ | TABLE | 167 | 45.50 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 21 | 5.72 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 11 | 3.00 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 10 | 2.72 | |
SYS | SYSAUX | WRH$_PARAMETER | WRH$_PARAME_1385339541_74 | TABLE PARTITION | 7 | 1.91 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | TAB$ | TABLE | 167 | 51.38 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 10 | 3.08 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 10 | 3.08 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 7 | 2.15 | |
SYS | SYSAUX | WRH$_SHARED_POOL_ADVICE_PK | INDEX | 5 | 1.54 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | TAB$ | TABLE | 167 | 51.38 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 10 | 3.08 | |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY | TABLE | 10 | 3.08 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 7 | 2.15 | |
SYS | SYSAUX | WRH$_SHARED_POOL_ADVICE_PK | INDEX | 5 | 1.54 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
---|---|---|---|---|---|---|
SYSMAN | SYSAUX | MGMT_METRICS_RAW_PK | INDEX | 62 | 6.35 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 33 | 3.38 | |
SYSMAN | SYSAUX | MGMT_CURRENT_METRICS_PK | INDEX | 22 | 2.25 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERFORMANCE_LOG | TABLE | 21 | 2.15 | |
SYSMAN | SYSAUX | MGMT_TASK_QTABLE | TABLE | 18 | 1.84 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
---|---|---|---|---|---|---|
SYSMAN | SYSAUX | MGMT_METRICS_RAW_PK | INDEX | 59 | 7.50 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 28 | 3.56 | |
SYSMAN | SYSAUX | MGMT_CURRENT_METRICS_PK | INDEX | 22 | 2.80 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERFORMANCE_LOG | TABLE | 19 | 2.41 | |
SYSMAN | SYSAUX | MGMT_TASK_QTABLE | TABLE | 16 | 2.03 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | I_OBJ2 | INDEX | 4 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_02 | INDEX | 592 | 13.31 | |
SYSMAN | SYSAUX | MGMT_CURRENT_METRICS_PK | INDEX | 496 | 11.15 | |
SYSMAN | SYSAUX | MGMT_CURRENT_AVAILABILITY_PK | INDEX | 464 | 10.43 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERFORMANCE_LOG | TABLE | 448 | 10.07 | |
SYSMAN | SYSAUX | MGMT_METRIC_DEPENDENCY | TABLE | 400 | 8.99 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
SYS | SYSAUX | WRH$_SGASTAT_U | WRH$_SGASTA_1385339541_74 | INDEX PARTITION | 2 | 100.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
SYS | SYSTEM | JOB$ | TABLE | 46 | 21.00 | |
SYSMAN | SYSAUX | MGMT_TASK_QTABLE | TABLE | 11 | 5.02 | |
SYSMAN | SYSAUX | MGMT_CURRENT_METRICS_PK | INDEX | 10 | 4.57 | |
SYS | SYSAUX | SMON_SCN_TIME | TABLE | 8 | 3.65 | |
SYS | SYSAUX | WRH$_SQL_PLAN_PK | INDEX | 8 | 3.65 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
SYSMAN | SYSAUX | MGMT_METRICS_RAW_PK | INDEX | 26 | 7.85 | |
SYSMAN | SYSAUX | MGMT_SYSTEM_PERF_LOG_IDX_01 | INDEX | 22 | 6.65 | |
SYS | SYSTEM | JOB$ | TABLE | 18 | 5.44 | |
SYS | SYSAUX | WRH$_SQLSTAT_INDEX | WRH$_SQLSTA_1385339541_74 | INDEX PARTITION | 17 | 5.14 |
SYS | SYSAUX | WRH$_SYSMETRIC_HISTORY_INDEX | INDEX | 11 | 3.32 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 66 | 0.00 | 0 | 2 | 1 | |
dc_files | 5 | 0.00 | 0 | 0 | 5 | |
dc_global_oids | 737 | 0.00 | 0 | 0 | 42 | |
dc_histogram_data | 133 | 0.00 | 0 | 0 | 1,159 | |
dc_histogram_defs | 472 | 0.00 | 0 | 0 | 3,687 | |
dc_object_grants | 2 | 0.00 | 0 | 0 | 4 | |
dc_objects | 3,048 | 0.23 | 0 | 0 | 1,470 | |
dc_profiles | 43 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 421 | 0.00 | 0 | 0 | 22 | |
dc_segments | 45 | 6.67 | 0 | 4 | 622 | |
dc_tablespaces | 836 | 0.00 | 0 | 0 | 7 | |
dc_users | 7,169 | 0.00 | 0 | 0 | 70 | |
global database name | 3,305 | 0.00 | 0 | 0 | 1 | |
outstanding_alerts | 28 | 75.00 | 0 | 4 | 6 | |
sch_lj_oids | 4 | 0.00 | 0 | 0 | 2 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 4 | 0 | 0 |
dc_objects | 7 | 2 | 0 |
dc_segments | 11 | 1 | 0 |
outstanding_alerts | 43 | 19 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 963 | 0.00 | 1,220 | 0.00 | 0 | 0 |
CLUSTER | 14 | 0.00 | 4 | 0.00 | 0 | 0 |
DBLINK | 2 | 0.00 | 0 | 0 | 0 | |
EDITION | 54 | 0.00 | 97 | 0.00 | 0 | 0 |
QUEUE | 36 | 0.00 | 883 | 0.00 | 0 | 0 |
RULESET | 4 | 0.00 | 4 | 0.00 | 0 | 0 |
SCHEMA | 47 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 1,066 | 0.56 | 13,160 | 0.09 | 0 | 0 |
SUBSCRIPTION | 12 | 0.00 | 12 | 0.00 | 0 | 0 |
TABLE/PROCEDURE | 625 | 0.00 | 2,122 | 0.09 | 2 | 0 |
TRIGGER | 9 | 0.00 | 45 | 0.00 | 0 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
BODY | 0 | 1,174 | 1,174 | 0 | 0 |
CLUSTER | 4 | 4 | 4 | 0 | 0 |
DBLINK | 2 | 0 | 0 | 0 | 0 |
EDITION | 54 | 54 | 54 | 0 | 0 |
QUEUE | 0 | 883 | 883 | 0 | 0 |
RULESET | 0 | 4 | 4 | 0 | 0 |
SCHEMA | 43 | 0 | 0 | 0 | 0 |
SUBSCRIPTION | 0 | 12 | 12 | 0 | 0 |
TABLE/PROCEDURE | 231 | 2,048 | 2,048 | 0 | 0 |
TRIGGER | 0 | 45 | 45 | 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 | 100.00 | 100.00 | 100.00 | 100.00 | 0 | INI/ |
KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
PGA Target | 404.00 | 404.00 | 404.00 | 404.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 400.00 | 400.00 | 400.00 | 400.00 | 0 | STA/ |
Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
java pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
large pool | 4.00 | 4.00 | 4.00 | 4.00 | 0 | STA/ |
shared pool | 280.00 | 280.00 | 280.00 | 280.00 | 0 | STA/ |
streams pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
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 | 175.60 | 3.99 | 4.42 | 13 | 13 | 44 | 44 | |
Freeable | 13.56 | 0.00 | 1.36 | 1.40 | 4 | 10 | 10 | ||
PL/SQL | 0.21 | 0.13 | 0.00 | 0.01 | 0 | 0 | 42 | 42 | |
SQL | 0.09 | 0.05 | 0.01 | 0.01 | 0 | 23 | 13 | 8 | |
E | Other | 174.93 | 3.98 | 4.44 | 13 | 13 | 44 | 44 | |
Freeable | 12.13 | 0.00 | 1.21 | 1.45 | 4 | 10 | 10 | ||
PL/SQL | 0.19 | 0.11 | 0.00 | 0.01 | 0 | 0 | 42 | 41 | |
SQL | 0.09 | 0.05 | 0.01 | 0.01 | 0 | 2 | 13 | 8 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 104,857,600 | |
Fixed Size | 2,217,992 | |
Redo Buffers | 6,590,464 | |
Variable Size | 725,616,632 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 4.00 | 4.00 | 0.00 |
large | ASM map operations hashta | 0.38 | 0.38 | 0.00 |
large | PX msg pool | 2.25 | 2.25 | 0.00 |
large | free memory | 1.38 | 1.38 | 0.00 |
shared | ASH buffers | 4.00 | 4.00 | 0.00 |
shared | CCUR | 4.75 | 4.79 | 0.81 |
shared | FileOpenBlock | 3.79 | 3.79 | 0.00 |
shared | KCB Table Scan Buffer | 3.80 | 3.80 | 0.00 |
shared | KGLH0 | 4.43 | 4.43 | 0.00 |
shared | KGLHD | 3.81 | 3.81 | 0.09 |
shared | KGLS | 8.70 | 8.70 | 0.00 |
shared | KGLSG | 5.02 | 5.02 | 0.00 |
shared | KQR L PO | 4.30 | 4.30 | 0.05 |
shared | KSFD SGA I/O b | 3.79 | 3.79 | 0.00 |
shared | PCUR | 3.58 | 3.58 | 0.22 |
shared | PLMCD | 4.28 | 4.28 | 0.00 |
shared | SQLA | 21.91 | 22.20 | 1.33 |
shared | event statistics per sess | 3.03 | 3.03 | 0.00 |
shared | free memory | 114.52 | 114.17 | -0.31 |
shared | ges big msg buffers | 3.79 | 3.79 | 0.00 |
shared | ges enqueues | 5.91 | 5.91 | 0.00 |
shared | ges resource | 3.62 | 3.62 | 0.00 |
shared | kglsim hash table bkts | 4.00 | 4.00 | 0.00 |
shared | ksunfy : SSO free list | 2.81 | 2.81 | 0.00 |
shared | row cache | 7.23 | 7.23 | 0.00 |
buffer_cache | 100.00 | 100.00 | 0.00 | |
fixed_sga | 2.12 | 2.12 | 0.00 | |
log_buffer | 6.29 | 6.29 | 0.00 |
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 1 | 0 | 1 | 0 |
Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
---|---|---|---|---|---|---|---|
0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
---|---|---|---|---|
3,584 | 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,584 | 0.00 | 100.00 | 0 | 0 | |
D000 | 0.00 | 3,584 | 0.00 | 100.00 | 0 | 0 | |
D000 | 0.00 | 3,584 | 0.00 | 100.00 | 0 | 0 | |
D000 | 0.00 | 3,584 | 0.00 | 100.00 | 0 | 0 | |
Sum | 0.00 | 0 | 0 | ||||
Avg | 0.00 | 0.00 | 100.00 | 0 | 0 | ||
Std | 0.00 | 0.00 | 0.00 | 0 | 0 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /u01/app/oracle/admin/orcl/adump | |
audit_trail | DB | |
cluster_database | TRUE | |
compatible | 11.2.0.0.0 | |
control_files | +DATA/orcl/controlfile/current.260.857558805, +FRA/orcl/controlfile/current.256.857558805 | |
db_block_size | 8192 | |
db_create_file_dest | +DATA | |
db_domain | ||
db_name | orcl | |
db_recovery_file_dest | +FRA | |
db_recovery_file_dest_size | 4070572032 | |
diagnostic_dest | /u01/app/oracle | |
dispatchers | (PROTOCOL=TCP) (SERVICE=orclXDB) | |
instance_number | 2 | |
local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orac2v)(PORT=1521)))) | |
log_archive_format | %t_%s_%r.dbf | |
memory_target | 843055104 | |
nls_language | JAPANESE | |
nls_territory | JAPAN | |
open_cursors | 300 | |
processes | 150 | |
remote_listener | orac-cluster-scan:1521 | |
remote_login_passwordfile | EXCLUSIVE | |
spfile | +DATA/orcl/spfileorcl.ora | |
thread | 2 | |
undo_tablespace | UNDOTBS2 |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 291 | 0.08 | 0.64 |
acks for commit broadcast(logical) | 297 | 0.08 | 0.65 |
broadcast msgs on commit(actual) | 431 | 0.12 | 0.95 |
broadcast msgs on commit(logical) | 433 | 0.12 | 0.95 |
broadcast msgs on commit(wasted) | 5 | 0.00 | 0.01 |
broadcast on commit wait time(ms) | 0 | 0.00 | 0.00 |
broadcast on commit waits | 2 | 0.00 | 0.00 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 0 | 0.00 | 0.00 |
flow control messages received | 0 | 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 | 84 | 0.02 | 0.19 |
gcs ast xid | 0 | 0.00 | 0.00 |
gcs blocked converts | 291 | 0.08 | 0.64 |
gcs blocked cr converts | 324 | 0.09 | 0.71 |
gcs compatible basts | 2 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 7 | 0.00 | 0.02 |
gcs compatible cr basts (local) | 0 | 0.00 | 0.00 |
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 | 149 | 0.04 | 0.33 |
gcs dbwr write request msgs | 147 | 0.04 | 0.32 |
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 forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 22 | 0.01 | 0.05 |
gcs immediate (null) converts | 27 | 0.01 | 0.06 |
gcs immediate cr (compatible) converts | 37 | 0.01 | 0.08 |
gcs immediate cr (null) converts | 3 | 0.00 | 0.01 |
gcs indirect ast | 88 | 0.02 | 0.19 |
gcs indirect bidless ast | 0 | 0.00 | 0.00 |
gcs indirect fg ast | 88 | 0.02 | 0.19 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 9 | 0.00 | 0.02 |
gcs msgs process time(ms) | 57 | 0.02 | 0.13 |
gcs msgs received | 2,666 | 0.74 | 5.87 |
gcs new served by master | 0 | 0.00 | 0.00 |
gcs out-of-order msgs | 0 | 0.00 | 0.00 |
gcs pings refused | 1 | 0.00 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs push delta | 0 | 0.00 | 0.00 |
gcs queued converts | 0 | 0.00 | 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 | 0 | 0.00 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 0 | 0.00 | 0.00 |
gcs share recovery bast | 0 | 0.00 | 0.00 |
gcs side channel msgs actual | 139 | 0.04 | 0.31 |
gcs side channel msgs logical | 970 | 0.27 | 2.14 |
gcs stale cr | 0 | 0.00 | 0.00 |
gcs undo cr | 0 | 0.00 | 0.00 |
gcs write notification msgs | 6 | 0.00 | 0.01 |
gcs writes refused | 0 | 0.00 | 0.00 |
ges msgs process time(ms) | 35 | 0.01 | 0.08 |
ges msgs received | 2,868 | 0.80 | 6.32 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 54 | 0.02 | 0.12 |
global posts queued | 54 | 0.02 | 0.12 |
global posts requested | 54 | 0.02 | 0.12 |
global posts sent | 54 | 0.02 | 0.12 |
implicit batch messages received | 40 | 0.01 | 0.09 |
implicit batch messages sent | 84 | 0.02 | 0.19 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 87 | 0.02 | 0.19 |
messages queue sent actual | 1,956 | 0.55 | 4.31 |
messages queue sent logical | 182 | 0.05 | 0.40 |
messages received actual | 5,130 | 1.43 | 11.30 |
messages received logical | 5,534 | 1.54 | 12.19 |
messages sent directly | 3,289 | 0.92 | 7.24 |
messages sent indirectly | 1,403 | 0.39 | 3.09 |
messages sent not implicit batched | 0 | 0.00 | 0.00 |
messages sent pbatched | 1,764 | 0.49 | 3.89 |
msgs causing lmd to send msgs | 532 | 0.15 | 1.17 |
msgs causing lms(s) to send msgs | 205 | 0.06 | 0.45 |
msgs received queue time (ms) | 35 | 0.01 | 0.08 |
msgs received queued | 5,534 | 1.54 | 12.19 |
msgs sent queue time (ms) | 45 | 0.01 | 0.10 |
msgs sent queue time on ksxp (ms) | 4,459 | 1.24 | 9.82 |
msgs sent queued | 2,044 | 0.57 | 4.50 |
msgs sent queued on ksxp | 5,282 | 1.47 | 11.63 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 2,425 | 0.68 | 5.34 |
process batch messages sent | 1,354 | 0.38 | 2.98 |
Statistic | Total |
---|---|
CR Block Requests | 254 |
CURRENT Block Requests | 246 |
Data Block Requests | 254 |
Undo Block Requests | 0 |
TX Block Requests | 209 |
Current Results | 496 |
Private results | 0 |
Zero Results | 4 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 140 |
Fairness Clears | 31 |
Free GC Elements | 0 |
Flushes | 13 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 14,318 |
Light Works | 0 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 283 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Flushes | 6 | 0.00 | 50.00 | 50.00 | 0.00 | 0.00 |
Writes | 157 | 0.00 | 75.80 | 24.20 | 0.00 | 0.00 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 178 | 97.75 | 2.25 | 0.00 | 314 | 99.36 | 0.64 | 0.00 |
1 | Others | 33 | 100.00 | 0.00 | 0.00 | 22 | 100.00 | 0.00 | 0.00 |
1 | undo header | 3 | 100.00 | 0.00 | 0.00 | 4 | 100.00 | 0.00 | 0.00 |
CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
1 | data block | 0.69 | 0.58 | 5.71 | 0.75 | 0.63 | 18.60 | ||
1 | others | 0.81 | 0.81 | 0.57 | 0.57 | ||||
1 | undo header | 0.49 | 0.49 | 0.30 | 0.30 | ||||
1 | undo block |
CR | Current | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
1 | data block | 0 | 174 | 100.00 | 0.00 | 312 | 100.00 | 0.00 |
1 | others | 0 | 33 | 100.00 | 0.00 | 22 | 100.00 | 0.00 |
1 | undo header | 0 | 3 | 100.00 | 0.00 | 4 | 100.00 | 0.00 |
1 | undo block | 0 | 0 | 0 |
CR Avg Time (ms) | Current Avg Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
1 | data block | 0.58 | 0.58 | 0.63 | 0.63 | |||
1 | others | 0.81 | 0.81 | 0.57 | 0.57 | |||
1 | undo header | 0.49 | 0.49 | 0.30 | 0.30 | |||
1 | undo block |
Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
---|---|---|---|---|---|---|
1 | 285 | 0.44 | 0.14 | 285 | 0.55 | 0.23 |
2 | 285 | 0.21 | 0.12 | 285 | 0.20 | 0.12 |
Used By | Send Mbytes/sec | Receive Mbytes/sec |
---|---|---|
Global Cache | 0.00 | 0.00 |
Parallel Query | 0.00 | 0.00 |
DB Locks | 0.00 | 0.00 |
DB Streams | 0.00 | 0.00 |
Other | 0.00 | 0.00 |