WORKLOAD REPOSITORY report for
DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
---|---|---|---|---|---|---|
OAPRD | 4112780385 | OAPRD1 | 1 | 26-May-20 17:05 | 12.1.0.2.0 | YES |
Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
---|---|---|---|---|---|
dbora-bot-prod01.uio.no | Linux x86 64-bit | 32 | 16 | 2 | 252.17 |
Snap Id | Snap Time | Sessions | Cursors/Session | Instances | |
---|---|---|---|---|---|
Begin Snap: | 50192 | 07-Sep-20 19:00:31 | 241 | 21.8 | 2 |
End Snap: | 50193 | 07-Sep-20 20:00:44 | 241 | 21.5 | 2 |
Elapsed: | 60.22 (mins) | ||||
DB Time: | 79.48 (mins) |
Report Summary
Top ADDM Findings by Average Active SessionsFinding Name | Avg active sessions of the task | Percent active sessions of finding | Task Name | Begin Snap Time | End Snap Time |
---|---|---|---|---|---|
Top SQL Statements | 1.32 | 92.49 | ADDM:4112780385_1_50193 | 07-Sep-20 19:00 | 07-Sep-20 20:00 |
Undersized SGA | 1.32 | 19.94 | ADDM:4112780385_1_50193 | 07-Sep-20 19:00 | 07-Sep-20 20:00 |
Top Segments by "User I/O" and "Cluster" | 1.32 | 3.59 | ADDM:4112780385_1_50193 | 07-Sep-20 19:00 | 07-Sep-20 20:00 |
Per Second | Per Transaction | Per Exec | Per Call | |
---|---|---|---|---|
DB Time(s): | 1.3 | 0.7 | 0.01 | 0.03 |
DB CPU(s): | 1.2 | 0.6 | 0.01 | 0.03 |
Background CPU(s): | 0.1 | 0.1 | 0.00 | 0.00 |
Redo size (bytes): | 26,817.3 | 13,238.0 | ||
Logical read (blocks): | 680,137.3 | 335,740.1 | ||
Block changes: | 168.6 | 83.2 | ||
Physical read (blocks): | 111.8 | 55.2 | ||
Physical write (blocks): | 6.7 | 3.3 | ||
Read IO requests: | 106.5 | 52.6 | ||
Write IO requests: | 4.2 | 2.1 | ||
Read IO (MB): | 0.9 | 0.4 | ||
Write IO (MB): | 0.1 | 0.0 | ||
IM scan rows: | 0.0 | 0.0 | ||
Session Logical Read IM: | ||||
Global Cache blocks received: | 1.1 | 0.6 | ||
Global Cache blocks served: | 0.5 | 0.2 | ||
User calls: | 45.7 | 22.6 | ||
Parses (SQL): | 26.3 | 13.0 | ||
Hard parses (SQL): | 0.1 | 0.0 | ||
SQL Work Area (MB): | 1.3 | 0.6 | ||
Logons: | 1.9 | 0.9 | ||
Executes (SQL): | 148.8 | 73.4 | ||
Rollbacks: | 0.7 | 0.3 | ||
Transactions: | 2.0 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.98 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.99 | Soft Parse %: | 99.83 |
Execute to Parse %: | 82.34 | Latch Hit %: | 99.99 |
Parse CPU to Parse Elapsd %: | 81.82 | % Non-Parse CPU: | 99.17 |
Flash Cache Hit %: | 0.00 |
Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
---|---|---|---|---|---|
DB CPU | 4186.7 | 87.8 | |||
db file sequential read | 355,956 | 473.5 | 1.33 | 9.9 | User I/O |
db file parallel read | 7,724 | 40.6 | 5.26 | .9 | User I/O |
external table read | 2,154 | 20.3 | 9.42 | .4 | User I/O |
gc cr disk read | 67,976 | 19.9 | 0.29 | .4 | Cluster |
db file scattered read | 2,369 | 8.8 | 3.73 | .2 | User I/O |
SQL*Net more data to client | 53,325 | 5.8 | 0.11 | .1 | Network |
library cache pin | 15,371 | 5 | 0.32 | .1 | Concurrency |
gc current grant busy | 7,192 | 4.8 | 0.66 | .1 | Cluster |
CRS call completion | 54 | 4 | 74.77 | .1 | Other |
Wait Class | Waits | Total Wait Time (sec) | Avg Wait (ms) | % DB time | Avg Active Sessions |
---|---|---|---|---|---|
DB CPU | 4,187 | 87.8 | 1.2 | ||
User I/O | 378,453 | 548 | 1.45 | 11.5 | 0.2 |
Concurrency | 252,618 | 46 | 0.18 | 1.0 | 0.0 |
Other | 284,690 | 36 | 0.12 | .7 | 0.0 |
Cluster | 82,376 | 27 | 0.33 | .6 | 0.0 |
System I/O | 30,057 | 17 | 0.56 | .4 | 0.0 |
Network | 172,949 | 6 | 0.03 | .1 | 0.0 |
Commit | 3,919 | 3 | 0.88 | .1 | 0.0 |
Application | 1,582 | 2 | 1.57 | .1 | 0.0 |
Configuration | 5 | 0 | 0.20 | .0 | 0.0 |
CPUs | Cores | Sockets | Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
---|---|---|---|---|---|---|---|---|
32 | 16 | 2 | 1.49 | 2.25 | 5.4 | 1.2 | 0.4 | 93.4 |
%Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
---|---|---|
4.0 | 59.7 | 0.0 |
Read+Write Per Second | Read per Second | Write Per Second | |
---|---|---|---|
Total Requests: | 123.6 | 114.1 | 9.5 |
Database Requests: | 110.6 | 106.5 | 4.2 |
Optimized Requests: | 0.0 | 0.0 | 0.0 |
Redo Requests: | 4.2 | 0.0 | 4.2 |
Total (MB): | 1.8 | 1.7 | 0.1 |
Database (MB): | 0.9 | 0.9 | 0.1 |
Optimized Total (MB): | 0.0 | 0.0 | 0.0 |
Redo (MB): | 0.1 | 0.0 | 0.1 |
Database (blocks): | 118.4 | 111.8 | 6.7 |
Via Buffer Cache (blocks): | 118.3 | 111.7 | 6.6 |
Direct (blocks): | 0.2 | 0.1 | 0.1 |
Begin | End | |
---|---|---|
Host Mem (MB): | 258,218.1 | 258,218.1 |
SGA use (MB): | 163,840.0 | 163,840.0 |
PGA use (MB): | 2,557.1 | 2,608.6 |
% Host Mem used for SGA+PGA: | 64.44 | 64.46 |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 117,760M | 117,760M | Std Block Size: | 8K |
Shared Pool Size: | 39,936M | 39,936M | Log Buffer: | 516,812K |
In-Memory Area: | 0M | 0M |
Begin | End | |
---|---|---|
Memory Usage %: | 85.07 | 85.07 |
% SQL with executions>1: | 99.28 | 99.61 |
% Memory for SQL w/exec>1: | 97.05 | 97.15 |
Main Report
- Report Summary
- Wait Events Statistics
- SQL Statistics
- Instance Activity Statistics
- IO Stats
- Buffer Pool Statistics
- Advisory Statistics
- Wait Statistics
- Undo Statistics
- Latch Statistics
- Segment Statistics
- Dictionary Cache Statistics
- Library Cache Statistics
- Memory Statistics
- Replication Statistics (GoldenGate, XStream)
- Streams Statistics
- Resource Limit Statistics
- Shared Server Statistics
- init.ora Parameters
- Active Session History (ASH) Report
- ADDM Reports
RAC Statistics
- RAC Report Summary
- Global Messaging Statistics
- Global CR Served Stats
- Global CURRENT Served Stats
- Global Cache Transfer Stats
- Interconnect Stats
- Dynamic Remastering Statistics
Back to Top
Wait Events Statistics
- Time Model Statistics
- Operating System Statistics
- Operating System Statistics - Detail
- Foreground Wait Class
- Foreground Wait Events
- Background Wait Events
- Wait Event Histogram
- Wait Event Histogram Detail (64 msec to 2 sec)
- Wait Event Histogram Detail (4 sec to 2 min)
- Wait Event Histogram Detail (4 min to 1 hr)
- Service Statistics
- Service Wait Class Stats
Time Model Statistics
- DB Time represents total time in user calls
- DB CPU represents CPU time of foreground processes
- Total CPU Time represents foreground and background processes
- Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
- Ordered by % of DB time in descending order, followed by Statistic Name
Statistic Name | Time (s) | % of DB Time | % of Total CPU Time |
---|---|---|---|
sql execute elapsed time | 4,705.82 | 98.68 | |
DB CPU | 4,186.68 | 87.80 | 91.59 |
parse time elapsed | 49.28 | 1.03 | |
hard parse elapsed time | 45.37 | 0.95 | |
inbound PL/SQL rpc elapsed time | 28.67 | 0.60 | |
PL/SQL execution elapsed time | 26.20 | 0.55 | |
connection management call elapsed time | 13.10 | 0.27 | |
hard parse (sharing criteria) elapsed time | 7.85 | 0.16 | |
Java execution elapsed time | 0.08 | 0.00 | |
PL/SQL compilation elapsed time | 0.03 | 0.00 | |
repeated bind elapsed time | 0.02 | 0.00 | |
sequence load elapsed time | 0.01 | 0.00 | |
failed parse elapsed time | 0.01 | 0.00 | |
DB time | 4,768.62 | ||
background elapsed time | 414.35 | ||
background cpu time | 384.21 | 8.41 | |
total CPU time | 4,570.89 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics
- *TIME statistic values are diffed. All others display actual values. End Value is displayed if different
- ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name
Statistic | Value | End Value |
---|---|---|
FREE_MEMORY_BYTES | 11,800,952,832 | 13,577,785,344 |
INACTIVE_MEMORY_BYTES | 4,414,922,752 | 3,039,420,416 |
SWAP_FREE_BYTES | 10,737,414,144 | |
BUSY_TIME | 765,545 | |
IDLE_TIME | 10,747,651 | |
IOWAIT_TIME | 47,224 | |
NICE_TIME | 0 | |
SYS_TIME | 138,948 | |
USER_TIME | 624,973 | |
LOAD | 1 | 2 |
PHYSICAL_MEMORY_BYTES | 270,761,345,024 | |
NUM_CPUS | 32 | |
NUM_CPU_CORES | 16 | |
NUM_CPU_SOCKETS | 2 | |
GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
TCP_RECEIVE_SIZE_MAX | 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 |
Back to Wait Events Statistics
Back to Top
Operating System Statistics - Detail
Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
---|---|---|---|---|---|---|
07-Sep 19:00:31 | 1.49 | |||||
07-Sep 20:00:44 | 2.25 | 6.65 | 5.43 | 1.21 | 93.35 | 0.41 |
Back to Wait Events Statistics
Back to Top
Foreground Wait Class
- s - second, ms - millisecond - 1000th of a second
- ordered by wait time desc, waits desc
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
- Captured Time accounts for 100.7% of Total DB time 4,768.62 (s)
- Total FG Wait Time: 613.28 (s) DB CPU time: 4,186.68 (s)
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
---|---|---|---|---|---|
DB CPU | 4,187 | 87.80 | |||
User I/O | 377,120 | 0 | 547 | 1.45 | 11.46 |
Cluster | 81,471 | 0 | 27 | 0.33 | 0.56 |
Other | 144,989 | 68 | 16 | 0.11 | 0.34 |
Concurrency | 24,108 | 0 | 8 | 0.33 | 0.17 |
Network | 171,655 | 0 | 6 | 0.03 | 0.13 |
System I/O | 5,208 | 0 | 4 | 0.74 | 0.08 |
Commit | 3,896 | 0 | 3 | 0.88 | 0.07 |
Application | 1,270 | 0 | 2 | 1.89 | 0.05 |
Configuration | 4 | 0 | 0 | 0.20 | 0.00 |
Back to Wait Events Statistics
Back to Top
Foreground Wait Events
- s - second, ms - millisecond - 1000th of a second
- Only events with Total Wait Time (s) >= .001 are shown
- ordered by wait time desc, waits desc (idle events last)
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
---|---|---|---|---|---|---|
db file sequential read | 355,956 | 473 | 1.33 | 48.63 | 9.93 | |
db file parallel read | 7,724 | 41 | 5.26 | 1.06 | 0.85 | |
external table read | 2,154 | 20 | 9.42 | 0.29 | 0.43 | |
gc cr disk read | 67,976 | 20 | 0.29 | 9.29 | 0.42 | |
db file scattered read | 2,369 | 9 | 3.73 | 0.32 | 0.19 | |
SQL*Net more data to client | 53,325 | 6 | 0.11 | 7.29 | 0.12 | |
library cache pin | 15,371 | 5 | 0.32 | 2.10 | 0.10 | |
gc current grant busy | 7,192 | 5 | 0.66 | 0.98 | 0.10 | |
CRS call completion | 54 | 4 | 74.77 | 0.01 | 0.08 | |
control file sequential read | 5,208 | 4 | 0.74 | 0.71 | 0.08 | |
log file sync | 3,896 | 3 | 0.88 | 0.53 | 0.07 | |
library cache lock | 8,413 | 1 | 3 | 0.36 | 1.15 | 0.06 |
PX Deq: Slave Session Stats | 13,260 | 2 | 0.18 | 1.81 | 0.05 | |
SQL*Net break/reset to client | 1,264 | 2 | 1.71 | 0.17 | 0.05 | |
Disk file operations I/O | 1,774 | 2 | 1.14 | 0.24 | 0.04 | |
IPC send completion sync | 12,234 | 2 | 0.15 | 1.67 | 0.04 | |
enq: PS - contention | 5,321 | 1 | 1 | 0.26 | 0.73 | 0.03 |
reliable message | 3,573 | 1 | 0.38 | 0.49 | 0.03 | |
utl_file I/O | 4,748 | 1 | 0.24 | 0.65 | 0.02 | |
GPnP Initialization | 54 | 1 | 17.11 | 0.01 | 0.02 | |
enq: IV - contention | 2,013 | 7 | 1 | 0.40 | 0.28 | 0.02 |
gc current block 2-way | 2,660 | 1 | 0.29 | 0.36 | 0.02 | |
gc current grant 2-way | 1,874 | 1 | 0.38 | 0.26 | 0.01 | |
name-service call wait | 6 | 1 | 97.62 | 0.00 | 0.01 | |
PX Deq: reap credit | 98,453 | 100 | 1 | 0.01 | 13.45 | 0.01 |
GPnP Get Item | 54 | 0 | 8.92 | 0.01 | 0.01 | |
CSS operation: action | 112 | 0 | 4.02 | 0.02 | 0.01 | |
gc cr grant 2-way | 1,213 | 0 | 0.22 | 0.17 | 0.01 | |
enq: TM - contention | 3 | 33 | 0 | 78.52 | 0.00 | 0.00 |
ADR block file read | 40 | 0 | 5.70 | 0.01 | 0.00 | |
ASM file metadata operation | 118 | 0 | 1.77 | 0.02 | 0.00 | |
latch free | 2 | 0 | 99.18 | 0.00 | 0.00 | |
CSS initialization | 112 | 0 | 1.47 | 0.02 | 0.00 | |
external table open | 12 | 0 | 11.01 | 0.00 | 0.00 | |
gc cr block 2-way | 382 | 0 | 0.32 | 0.05 | 0.00 | |
GPnP Termination | 54 | 0 | 1.83 | 0.01 | 0.00 | |
SQL*Net more data from client | 2,505 | 0 | 0.04 | 0.34 | 0.00 | |
KSV master wait | 20 | 0 | 4.49 | 0.00 | 0.00 | |
rdbms ipc reply | 772 | 0 | 0.10 | 0.11 | 0.00 | |
SQL*Net message to client | 115,825 | 0 | 0.00 | 15.83 | 0.00 | |
gc cr block busy | 50 | 0 | 1.46 | 0.01 | 0.00 | |
oracle thread bootstrap | 3 | 0 | 22.21 | 0.00 | 0.00 | |
PX Deq: Signal ACK EXT | 7,122 | 0 | 0.01 | 0.97 | 0.00 | |
enq: TT - contention | 260 | 0 | 0.21 | 0.04 | 0.00 | |
external table write | 2,364 | 0 | 0.02 | 0.32 | 0.00 | |
row cache lock | 280 | 0 | 0.16 | 0.04 | 0.00 | |
CSS operation: data query | 162 | 0 | 0.26 | 0.02 | 0.00 | |
gc cr multi block request | 70 | 0 | 0.54 | 0.01 | 0.00 | |
CSS group membership query | 54 | 0 | 0.56 | 0.01 | 0.00 | |
DFS lock handle | 99 | 0 | 0.29 | 0.01 | 0.00 | |
enq: TO - contention | 123 | 0 | 0.21 | 0.02 | 0.00 | |
enq: KM - contention | 90 | 0 | 0.20 | 0.01 | 0.00 | |
gc current block busy | 32 | 0 | 0.48 | 0.00 | 0.00 | |
gc current multi block request | 18 | 0 | 0.43 | 0.00 | 0.00 | |
direct path read | 6 | 0 | 1.15 | 0.00 | 0.00 | |
cursor: pin S | 6 | 0 | 1.10 | 0.00 | 0.00 | |
enq: JS - job run lock - synchronize | 18 | 100 | 0 | 0.33 | 0.00 | 0.00 |
enq: AE - lock | 21 | 0 | 0.21 | 0.00 | 0.00 | |
enq: FB - contention | 17 | 0 | 0.25 | 0.00 | 0.00 | |
latch: ges resource hash list | 31 | 0 | 0.13 | 0.00 | 0.00 | |
direct path read temp | 11 | 0 | 0.37 | 0.00 | 0.00 | |
gc buffer busy acquire | 4 | 0 | 1.02 | 0.00 | 0.00 | |
enq: CF - contention | 14 | 0 | 0.28 | 0.00 | 0.00 | |
KJC: Wait for msg sends to complete | 532 | 0 | 0.01 | 0.07 | 0.00 | |
CSS operation: query | 120 | 0 | 0.01 | 0.02 | 0.00 | |
enq: DV - contention | 4 | 0 | 0.26 | 0.00 | 0.00 | |
SQL*Net message from client | 115,831 | 338,626 | 2923.45 | 15.83 | ||
Streams AQ: waiting for messages in the queue | 5,693 | 38 | 21,691 | 3810.14 | 0.78 | |
PL/SQL lock timer | 188 | 100 | 2,056 | 10938.09 | 0.03 | |
jobq slave wait | 1,689 | 100 | 846 | 500.90 | 0.23 | |
PX Deq: Execution Msg | 18,414 | 10 | 0.56 | 2.52 | ||
PX Deq: Execute Reply | 7,101 | 5 | 0.65 | 0.97 | ||
PX Deq: Join ACK | 14,244 | 3 | 0.24 | 1.95 | ||
PX Deq: Parse Reply | 7,122 | 2 | 0.30 | 0.97 | ||
PX Deq: Msg Fragment | 429 | 0 | 0.17 | 0.06 |
Back to Wait Events Statistics
Back to Top
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
- Only events with Total Wait Time (s) >= .001 are shown
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
---|---|---|---|---|---|---|
library cache pin | 218,147 | 0 | 38 | 0.17 | 29.81 | 9.09 |
control file sequential read | 12,653 | 0 | 6 | 0.50 | 1.73 | 1.52 |
log file parallel write | 7,417 | 0 | 6 | 0.74 | 1.01 | 1.33 |
oracle thread bootstrap | 195 | 0 | 4 | 22.70 | 0.03 | 1.07 |
name-service call wait | 124 | 0 | 4 | 30.87 | 0.02 | 0.92 |
enq: PS - contention | 1,412 | 38 | 3 | 2.26 | 0.19 | 0.77 |
enq: XR - database force logging | 1,203 | 0 | 1 | 1.22 | 0.16 | 0.35 |
enq: CO - master slave det | 1,200 | 100 | 1 | 1.14 | 0.16 | 0.33 |
db file sequential read | 549 | 0 | 1 | 1.71 | 0.08 | 0.23 |
reliable message | 1,112 | 0 | 1 | 0.70 | 0.15 | 0.19 |
os thread creation | 198 | 0 | 1 | 3.84 | 0.03 | 0.18 |
control file parallel write | 1,335 | 0 | 1 | 0.56 | 0.18 | 0.18 |
PX Deq: Slave Join Frag | 6,138 | 0 | 1 | 0.10 | 0.84 | 0.14 |
target log write size | 877 | 1 | 1 | 0.66 | 0.12 | 0.14 |
db file parallel write | 2,020 | 0 | 0 | 0.22 | 0.28 | 0.11 |
library cache lock | 676 | 72 | 0 | 0.61 | 0.09 | 0.10 |
PX Deq: reap credit | 46,685 | 100 | 0 | 0.01 | 6.38 | 0.07 |
IPC send completion sync | 1,762 | 0 | 0 | 0.14 | 0.24 | 0.06 |
CGS wait for IPC msg | 34,129 | 100 | 0 | 0.01 | 4.66 | 0.05 |
ASM file metadata operation | 1,197 | 0 | 0 | 0.16 | 0.16 | 0.05 |
PX Deq: Slave Session Stats | 1,756 | 0 | 0 | 0.10 | 0.24 | 0.04 |
wait for scn ack | 1 | 0 | 0 | 141.68 | 0.00 | 0.03 |
LGWR any worker group | 3 | 0 | 0 | 42.98 | 0.00 | 0.03 |
LGWR worker group ordering | 2 | 0 | 0 | 62.78 | 0.00 | 0.03 |
gc current block 2-way | 441 | 0 | 0 | 0.28 | 0.06 | 0.03 |
CSS initialization | 34 | 0 | 0 | 3.14 | 0.00 | 0.03 |
Disk file operations I/O | 584 | 0 | 0 | 0.17 | 0.08 | 0.02 |
libcache interrupt action by LCK | 9,515 | 0 | 0 | 0.01 | 1.30 | 0.02 |
enq: RO - fast object reuse | 303 | 0 | 0 | 0.26 | 0.04 | 0.02 |
gcs log flush sync | 127 | 0 | 0 | 0.61 | 0.02 | 0.02 |
ksxr poll remote instances | 10,774 | 100 | 0 | 0.01 | 1.47 | 0.02 |
CSS operation: data query | 166 | 0 | 0 | 0.43 | 0.02 | 0.02 |
DFS lock handle | 242 | 100 | 0 | 0.29 | 0.03 | 0.02 |
gc cr block 2-way | 250 | 0 | 0 | 0.27 | 0.03 | 0.02 |
CSS operation: data update | 111 | 0 | 0 | 0.44 | 0.02 | 0.01 |
PX Deq: Signal ACK EXT | 1,756 | 0 | 0 | 0.03 | 0.24 | 0.01 |
gc cr block busy | 39 | 0 | 0 | 0.98 | 0.01 | 0.01 |
direct path write temp | 145 | 0 | 0 | 0.25 | 0.02 | 0.01 |
enq: IV - contention | 152 | 0 | 0 | 0.23 | 0.02 | 0.01 |
gc current grant busy | 130 | 0 | 0 | 0.26 | 0.02 | 0.01 |
change tracking file synchronous read | 58 | 0 | 0 | 0.57 | 0.01 | 0.01 |
change tracking file synchronous write | 58 | 0 | 0 | 0.53 | 0.01 | 0.01 |
CSS operation: action | 70 | 0 | 0 | 0.33 | 0.01 | 0.01 |
enq: US - contention | 107 | 0 | 0 | 0.21 | 0.01 | 0.01 |
enq: TO - contention | 79 | 0 | 0 | 0.28 | 0.01 | 0.01 |
library cache: mutex X | 132 | 0 | 0 | 0.17 | 0.02 | 0.01 |
ADR block file read | 16 | 0 | 0 | 1.15 | 0.00 | 0.00 |
row cache process | 11,007 | 0 | 0 | 0.00 | 1.50 | 0.00 |
row cache cleanup | 10,002 | 0 | 0 | 0.00 | 1.37 | 0.00 |
KJC: Wait for msg sends to complete | 2,609 | 0 | 0 | 0.00 | 0.36 | 0.00 |
enq: TT - contention | 48 | 23 | 0 | 0.26 | 0.01 | 0.00 |
KSV master wait | 2,225 | 99 | 0 | 0.01 | 0.30 | 0.00 |
db file scattered read | 42 | 0 | 0 | 0.24 | 0.01 | 0.00 |
enq: CF - contention | 17 | 100 | 0 | 0.58 | 0.00 | 0.00 |
CSS operation: query | 102 | 0 | 0 | 0.09 | 0.01 | 0.00 |
log file sync | 23 | 0 | 0 | 0.36 | 0.00 | 0.00 |
row cache lock | 57 | 0 | 0 | 0.13 | 0.01 | 0.00 |
asynch descriptor resize | 1,267 | 100 | 0 | 0.01 | 0.17 | 0.00 |
gc current grant 2-way | 32 | 0 | 0 | 0.19 | 0.00 | 0.00 |
latch free | 39 | 0 | 0 | 0.15 | 0.01 | 0.00 |
LGWR wait for redo copy | 210 | 0 | 0 | 0.03 | 0.03 | 0.00 |
gc current multi block request | 11 | 0 | 0 | 0.40 | 0.00 | 0.00 |
enq: WF - contention | 17 | 0 | 0 | 0.25 | 0.00 | 0.00 |
gc current block busy | 5 | 0 | 0 | 0.80 | 0.00 | 0.00 |
latch: ges resource hash list | 69 | 0 | 0 | 0.06 | 0.01 | 0.00 |
enq: TM - contention | 9 | 0 | 0 | 0.42 | 0.00 | 0.00 |
enq: FB - contention | 17 | 0 | 0 | 0.22 | 0.00 | 0.00 |
direct path write | 14 | 0 | 0 | 0.26 | 0.00 | 0.00 |
enq: SM - contention | 10 | 0 | 0 | 0.30 | 0.00 | 0.00 |
enq: DW - contention | 7 | 100 | 0 | 0.38 | 0.00 | 0.00 |
gc cr multi block request | 4 | 0 | 0 | 0.63 | 0.00 | 0.00 |
enq: TA - contention | 12 | 0 | 0 | 0.20 | 0.00 | 0.00 |
gc buffer busy release | 5 | 0 | 0 | 0.43 | 0.00 | 0.00 |
enq: WT - contention | 8 | 0 | 0 | 0.23 | 0.00 | 0.00 |
gc cr grant 2-way | 8 | 0 | 0 | 0.21 | 0.00 | 0.00 |
AQ Background Master: slave start | 1 | 0 | 0 | 1.63 | 0.00 | 0.00 |
enq: TD - KTF dump entries | 7 | 0 | 0 | 0.22 | 0.00 | 0.00 |
db file async I/O submit | 1,427 | 0 | 0 | 0.00 | 0.19 | 0.00 |
rdbms ipc message | 110,768 | 60 | 108,252 | 977.28 | 15.13 | |
Streams AQ: waiting for time management or cleanup tasks | 594 | 68 | 34,828 | 58632.45 | 0.08 | |
EMON slave idle wait | 3,664 | 98 | 18,064 | 4930.13 | 0.50 | |
class slave wait | 982,167 | 100 | 15,726 | 16.01 | 134.19 | |
gcs remote message | 367,628 | 94 | 10,834 | 29.47 | 50.23 | |
Space Manager: slave idle wait | 1,978 | 85 | 8,433 | 4263.21 | 0.27 | |
LGWR worker group idle | 7,417 | 0 | 7,600 | 1024.67 | 1.01 | |
Streams AQ: qmn slave idle wait | 2,619 | 0 | 7,228 | 2759.73 | 0.36 | |
wait for unread message on broadcast channel | 1,924 | 100 | 7,226 | 3755.93 | 0.26 | |
ges remote message | 333,116 | 19 | 7,219 | 21.67 | 45.51 | |
GCR sleep | 25,642 | 7 | 7,218 | 281.50 | 3.50 | |
DIAG idle wait | 53,111 | 71 | 7,203 | 135.62 | 7.26 | |
PX Idle Wait | 6,142 | 0 | 5,011 | 815.82 | 0.84 | |
REPL Capture/Apply: RAC AQ qmn coordinator | 49 | 98 | 4,191 | 85536.96 | 0.01 | |
ASM background timer | 735 | 0 | 3,615 | 4918.39 | 0.10 | |
lreg timer | 1,203 | 100 | 3,615 | 3004.83 | 0.16 | |
pmon timer | 1,204 | 100 | 3,614 | 3001.77 | 0.16 | |
Streams AQ: emn coordinator idle wait | 361 | 100 | 3,613 | 10008.72 | 0.05 | |
heartbeat redo informer | 3,609 | 0 | 3,613 | 1001.11 | 0.49 | |
Streams AQ: qmn coordinator idle wait | 1,526 | 34 | 3,613 | 2367.47 | 0.21 | |
PING | 1,475 | 19 | 3,610 | 2447.52 | 0.20 | |
Streams AQ: load balancer idle | 774 | 0 | 3,603 | 4655.65 | 0.11 | |
AQPC idle | 120 | 100 | 3,602 | 30013.18 | 0.02 | |
smon timer | 203 | 5 | 3,525 | 17364.41 | 0.03 | |
JOX Jit Process Sleep | 223 | 100 | 3,346 | 15004.21 | 0.03 | |
SQL*Net message from client | 1,730 | 0 | 5 | 2.94 | 0.24 | |
PX Deq: Join ACK | 3,512 | 0 | 4 | 1.01 | 0.48 | |
PX Deq: Execute Reply | 1,756 | 0 | 3 | 1.79 | 0.24 | |
PX Deq: Parse Reply | 1,756 | 0 | 1 | 0.40 | 0.24 | |
PX Deq Credit: send blkd | 400 | 0 | 0 | 0.30 | 0.05 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram
- Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
- % of Waits: value of .0 indicates value was <.05%; value of null is truly 0
- % of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
- Ordered by Event (idle events last)
% of Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
ADR block file read | 56 | 92.9 | 3.6 | 1.8 | 1.8 | ||||
ADR block file write | 10 | 100.0 | |||||||
ADR file lock | 24 | 100.0 | |||||||
AQ Background Master: slave start | 1 | 100.0 | |||||||
ASM background starting | 3 | 100.0 | |||||||
ASM file metadata operation | 1315 | 98.3 | .4 | .6 | .3 | .4 | |||
CGS wait for IPC msg | 34.1K | 100.0 | .0 | ||||||
CRS call completion | 54 | 98.1 | 1.9 | ||||||
CSS group membership query | 54 | 100.0 | |||||||
CSS initialization | 146 | 13.7 | 71.9 | 3.4 | 10.3 | .7 | |||
CSS operation: action | 182 | 40.7 | 58.8 | .5 | |||||
CSS operation: data query | 328 | 99.4 | .3 | .3 | |||||
CSS operation: data update | 111 | 99.1 | .9 | ||||||
CSS operation: query | 222 | 100.0 | |||||||
DFS lock handle | 341 | 100.0 | |||||||
Disk file operations I/O | 2360 | 96.9 | .8 | .0 | .0 | 1.6 | .7 | ||
GCR CSS group query | 166 | 100.0 | |||||||
GCR CSS group update | 111 | 100.0 | |||||||
GPnP Get Item | 54 | 57.4 | 40.7 | 1.9 | |||||
GPnP Initialization | 54 | 31.5 | 68.5 | ||||||
GPnP Termination | 54 | 92.6 | 7.4 | ||||||
IPC send completion sync | 14K | 99.9 | .0 | .0 | .0 | ||||
KJC: Wait for msg sends to complete | 3141 | 100.0 | |||||||
KSV master wait | 2245 | 99.9 | .1 | .0 | |||||
LGWR all worker groups | 1 | 100.0 | |||||||
LGWR any worker group | 3 | 33.3 | 33.3 | 33.3 | |||||
LGWR wait for redo copy | 210 | 100.0 | |||||||
LGWR worker group ordering | 2 | 50.0 | 50.0 | ||||||
PX Deq: Signal ACK EXT | 8878 | 100.0 | |||||||
PX Deq: Slave Join Frag | 6138 | 100.0 | .0 | ||||||
PX Deq: Slave Session Stats | 15K | 99.6 | .3 | .0 | .0 | .0 | .0 | ||
PX Deq: reap credit | 145.1K | 100.0 | .0 | .0 | |||||
PX qref latch | 51 | 100.0 | |||||||
SQL*Net break/reset to client | 1263 | 96.9 | 1.3 | .2 | .6 | .2 | .7 | ||
SQL*Net message to client | 116.3K | 100.0 | |||||||
SQL*Net more data from client | 2505 | 100.0 | .0 | ||||||
SQL*Net more data to client | 53.3K | 99.8 | .0 | .0 | .1 | .0 | .0 | .0 | |
asynch descriptor resize | 1267 | 100.0 | |||||||
buffer busy waits | 12 | 100.0 | |||||||
change tracking file synchronous read | 58 | 86.2 | 8.6 | 3.4 | 1.7 | ||||
change tracking file synchronous write | 58 | 93.1 | 3.4 | 1.7 | 1.7 | ||||
control file parallel write | 1335 | 97.1 | 1.6 | .9 | .2 | .1 | .1 | ||
control file sequential read | 17.9K | 95.2 | 1.9 | 1.6 | .7 | .4 | .1 | .1 | |
cursor: pin S | 6 | 100.0 | |||||||
db file async I/O submit | 1427 | 100.0 | |||||||
db file parallel read | 7724 | 46.3 | 11.2 | 5.4 | 13.6 | 15.9 | 6.0 | 1.6 | |
db file parallel write | 2020 | 97.2 | 1.6 | .6 | .4 | .1 | .0 | ||
db file scattered read | 2411 | 44.5 | 19.1 | 9.4 | 10.9 | 12.0 | 3.6 | .4 | |
db file sequential read | 356.6K | 77.6 | 11.1 | 2.9 | 3.8 | 3.7 | .7 | .1 | |
direct path read | 6 | 66.7 | 16.7 | 16.7 | |||||
direct path read temp | 11 | 100.0 | |||||||
direct path write | 14 | 100.0 | |||||||
direct path write temp | 147 | 95.9 | 3.4 | .7 | |||||
enq: AE - lock | 21 | 100.0 | |||||||
enq: AF - task serialization | 2 | 100.0 | |||||||
enq: CF - contention | 31 | 96.8 | 3.2 | ||||||
enq: CO - master slave det | 1200 | 99.4 | .1 | .3 | .2 | ||||
enq: CR - block range reuse ckpt | 2 | 100.0 | |||||||
enq: DL - contention | 1 | 100.0 | |||||||
enq: DR - contention | 2 | 100.0 | |||||||
enq: DV - contention | 4 | 100.0 | |||||||
enq: DW - contention | 7 | 100.0 | |||||||
enq: FB - contention | 22 | 100.0 | |||||||
enq: FH - contention | 1 | 100.0 | |||||||
enq: HW - contention | 7 | 100.0 | |||||||
enq: IV - contention | 2169 | 99.1 | .8 | .1 | |||||
enq: JS - job run lock - synchronize | 18 | 100.0 | |||||||
enq: KM - contention | 90 | 100.0 | |||||||
enq: MW - contention | 2 | 100.0 | |||||||
enq: PS - contention | 6733 | 99.8 | .1 | .1 | |||||
enq: RO - fast object reuse | 305 | 97.7 | 1.0 | 1.3 | |||||
enq: SM - contention | 10 | 100.0 | |||||||
enq: SV - contention | 2 | 100.0 | |||||||
enq: TA - contention | 12 | 100.0 | |||||||
enq: TD - KTF dump entries | 8 | 100.0 | |||||||
enq: TM - contention | 12 | 91.7 | 8.3 | ||||||
enq: TO - contention | 202 | 100.0 | |||||||
enq: TQ - TM contention | 2 | 100.0 | |||||||
enq: TS - contention | 2 | 100.0 | |||||||
enq: TT - contention | 307 | 100.0 | |||||||
enq: TX - contention | 1 | 100.0 | |||||||
enq: UL - contention | 1 | 100.0 | |||||||
enq: US - contention | 107 | 99.1 | .9 | ||||||
enq: WF - contention | 17 | 100.0 | |||||||
enq: WT - contention | 8 | 100.0 | |||||||
enq: XR - database force logging | 1203 | 99.6 | .2 | .2 | |||||
enq: ZZ - update hash tables | 4 | 100.0 | |||||||
external table open | 12 | 8.3 | 25.0 | 25.0 | 25.0 | 8.3 | 8.3 | ||
external table read | 2154 | .3 | 77.7 | 7.2 | 10.6 | 4.2 | |||
external table write | 2364 | 99.9 | .0 | .1 | |||||
gc buffer busy acquire | 4 | 50.0 | 50.0 | ||||||
gc buffer busy release | 2 | 100.0 | |||||||
gc cr block 2-way | 666 | 100.0 | |||||||
gc cr block busy | 92 | 60.9 | 32.6 | 3.3 | 3.3 | ||||
gc cr disk read | 68K | 99.9 | .1 | .0 | .0 | .0 | .0 | .0 | |
gc cr grant 2-way | 1222 | 99.7 | .1 | .2 | .1 | ||||
gc cr multi block request | 74 | 94.6 | 2.7 | 1.4 | 1.4 | ||||
gc current block 2-way | 3131 | 99.7 | .2 | .1 | |||||
gc current block busy | 45 | 88.9 | 11.1 | ||||||
gc current grant 2-way | 1915 | 99.8 | .1 | .1 | .1 | ||||
gc current grant busy | 7333 | 99.1 | .7 | .1 | .0 | .0 | .0 | .0 | .0 |
gc current multi block request | 31 | 100.0 | |||||||
gcs log flush sync | 116 | 93.1 | 5.2 | .9 | .9 | ||||
ges DFS hang analysis phase 2 acks | 1 | 100.0 | |||||||
ksxr poll remote instances | 10.8K | 100.0 | |||||||
latch free | 41 | 95.1 | 4.9 | ||||||
latch: cache buffers chains | 23 | 100.0 | |||||||
latch: ges resource hash list | 100 | 99.0 | 1.0 | ||||||
latch: redo allocation | 1 | 100.0 | |||||||
latch: row cache objects | 2 | 100.0 | |||||||
libcache interrupt action by LCK | 9536 | 100.0 | .0 | ||||||
library cache lock | 9089 | 99.5 | .3 | .0 | .0 | .0 | .1 | ||
library cache pin | 233.5K | 99.8 | .2 | .0 | .0 | .0 | |||
library cache: mutex X | 152 | 98.7 | 1.3 | ||||||
log file parallel write | 7415 | 92.8 | 5.3 | 1.0 | .5 | .4 | .1 | .1 | |
log file sync | 3918 | 91.8 | 5.6 | 1.4 | .8 | .2 | .1 | .2 | |
name-service call wait | 130 | 46.9 | .8 | 1.5 | 3.8 | 5.4 | 41.5 | ||
oracle thread bootstrap | 198 | 97.0 | 3.0 | ||||||
os thread creation | 198 | 78.3 | 21.2 | .5 | |||||
rdbms ipc reply | 774 | 100.0 | |||||||
reliable message | 4685 | 98.0 | 1.6 | .1 | .2 | .0 | .1 | ||
row cache cleanup | 10K | 100.0 | |||||||
row cache lock | 342 | 100.0 | |||||||
row cache process | 11K | 100.0 | |||||||
target log write size | 879 | 87.8 | 8.8 | 1.5 | .7 | 1.3 | |||
utl_file I/O | 4748 | 96.0 | 1.6 | 1.2 | 1.0 | .1 | .1 | .0 | |
wait for scn ack | 1 | 100.0 | |||||||
AQPC idle | 120 | 100.0 | |||||||
ASM background timer | 735 | 1.4 | 98.6 | ||||||
DIAG idle wait | 53.1K | 25.2 | .9 | .6 | .5 | 2.8 | 3.7 | 66.3 | .0 |
EMON slave idle wait | 3664 | .0 | 1.4 | 98.5 | |||||
GCR sleep | 25.6K | 93.0 | 7.0 | ||||||
JOX Jit Process Sleep | 223 | 100.0 | |||||||
LGWR worker group idle | 7415 | 17.3 | 21.5 | 10.9 | 7.1 | 9.2 | 9.9 | 13.9 | 10.2 |
PING | 1475 | 80.5 | .1 | .1 | 19.3 | ||||
PL/SQL lock timer | 188 | 100.0 | |||||||
PX Deq Credit: send blkd | 400 | 99.8 | .3 | ||||||
PX Deq: Execute Reply | 8857 | 98.1 | .5 | .4 | .1 | .2 | .1 | .5 | |
PX Deq: Execution Msg | 18.4K | 91.9 | 7.7 | .2 | .0 | .1 | .0 | .0 | |
PX Deq: Join ACK | 17.8K | 99.4 | .5 | .1 | .0 | .0 | |||
PX Deq: Msg Fragment | 429 | 100.0 | |||||||
PX Deq: Parse Reply | 8878 | 98.6 | .7 | .3 | .4 | ||||
PX Idle Wait | 6138 | 78.8 | 1.3 | .8 | 1.2 | .2 | .6 | 3.3 | 13.8 |
REPL Capture/Apply: RAC AQ qmn coordinator | 49 | 100.0 | |||||||
SQL*Net message from client | 117.3K | 72.7 | 2.5 | .9 | 2.3 | .8 | .1 | 15.8 | 4.9 |
Space Manager: slave idle wait | 1979 | 13.3 | .3 | .1 | .2 | .9 | 85.3 | ||
Streams AQ: emn coordinator idle wait | 361 | 100.0 | |||||||
Streams AQ: load balancer idle | 774 | .1 | .3 | 6.3 | 93.3 | ||||
Streams AQ: qmn coordinator idle wait | 1526 | 65.4 | .1 | 34.5 | |||||
Streams AQ: qmn slave idle wait | 2618 | .0 | 4.5 | .1 | 16.2 | 79.1 | |||
Streams AQ: waiting for messages in the queue | 5693 | .0 | .1 | 5.2 | .8 | 12.9 | 81.0 | ||
Streams AQ: waiting for time management or cleanup tasks | 579 | 3.8 | 1.7 | 14.7 | 1.0 | 1.2 | 39.2 | 38.3 | |
class slave wait | 979.8K | .0 | .0 | .0 | .0 | 100.0 | .0 | .0 | .0 |
gcs remote message | 366.4K | 2.2 | .8 | .6 | .6 | 1.0 | 94.2 | .6 | .0 |
ges remote message | 333.1K | 68.1 | 6.7 | 2.5 | .5 | .5 | .6 | 21.0 | .0 |
heartbeat redo informer | 3609 | 99.8 | .2 | ||||||
jobq slave wait | 1689 | 99.9 | .1 | ||||||
lreg timer | 1204 | 100.0 | |||||||
pmon timer | 1203 | 100.0 | |||||||
rdbms ipc message | 110.8K | 21.5 | 2.4 | 4.8 | 1.6 | 1.4 | 1.2 | 43.5 | 23.7 |
smon timer | 204 | 87.7 | 1.5 | 3.4 | 7.4 | ||||
wait for unread message on broadcast channel | 1924 | 100.0 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram Detail (64 msec to 2 sec)
- Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
- Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
- % of Total Waits: total waits for all wait classes, including Idle
- % of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
- Ordered by Event (only non-idle events are displayed)
% of Total Waits | |||||||||
---|---|---|---|---|---|---|---|---|---|
Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
ADR block file read | 1 | 98.2 | 1.8 | ||||||
ASM file metadata operation | 5 | 99.6 | .4 | ||||||
CRS call completion | 54 | 96.3 | 1.9 | 1.9 | |||||
CSS operation: action | 1 | 99.5 | .5 | ||||||
Disk file operations I/O | 16 | 99.3 | .7 | ||||||
GPnP Get Item | 1 | 98.1 | 1.9 | ||||||
KSV master wait | 1 | 100.0 | .0 | ||||||
LGWR any worker group | 1 | 66.7 | 33.3 | ||||||
LGWR worker group ordering | 1 | 50.0 | 50.0 | ||||||
PX Deq: Slave Session Stats | 1 | 100.0 | .0 | ||||||
SQL*Net break/reset to client | 9 | 99.3 | .2 | .1 | .3 | .2 | |||
SQL*Net more data to client | 17 | 100.0 | .0 | .0 | .0 | ||||
control file parallel write | 1 | 99.9 | .1 | ||||||
control file sequential read | 12 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
db file parallel read | 127 | 98.4 | 1.4 | .2 | .0 | ||||
db file parallel write | 1 | 100.0 | .0 | ||||||
db file scattered read | 10 | 99.6 | .4 | ||||||
db file sequential read | 348 | 99.9 | .1 | .0 | .0 | .0 | .0 | ||
enq: CO - master slave det | 2 | 99.8 | .1 | .1 | |||||
enq: PS - contention | 5 | 99.9 | .0 | .0 | .0 | ||||
enq: TM - contention | 1 | 91.7 | 8.3 | ||||||
enq: XR - database force logging | 2 | 99.8 | .1 | .1 | |||||
external table open | 1 | 91.7 | 8.3 | ||||||
external table read | 90 | 95.8 | 3.5 | .6 | .1 | ||||
gc cr disk read | 8 | 100.0 | .0 | .0 | .0 | .0 | |||
gc current grant 2-way | 1 | 99.9 | .1 | ||||||
gc current grant busy | 3 | 100.0 | .0 | .0 | .0 | ||||
latch free | 2 | 95.1 | 4.9 | ||||||
library cache lock | 11 | 99.9 | .0 | .1 | .0 | .0 | |||
library cache pin | 12 | 100.0 | .0 | .0 | .0 | .0 | |||
log file parallel write | 5 | 99.9 | .0 | .0 | .0 | .0 | |||
log file sync | 6 | 99.8 | .1 | .1 | .0 | .0 | |||
name-service call wait | 54 | 58.5 | 13.1 | 28.5 | |||||
oracle thread bootstrap | 6 | 97.0 | 1.5 | 1.5 | |||||
reliable message | 5 | 99.9 | .1 | .0 | |||||
utl_file I/O | 1 | 100.0 | .0 | ||||||
wait for scn ack | 1 | 100.0 |
Back to Wait Events Statistics
Back to Top
Wait Event Histogram Detail (4 sec to 2 min)
No data exists for this section of the report. Back to Wait Events StatisticsBack to Top
Wait Event Histogram Detail (4 min to 1 hr)
No data exists for this section of the report. Back to Wait Events StatisticsBack to Top
Service Statistics
- ordered by DB Time
Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
---|---|---|---|---|
OAPRD.uio.no | 4,477 | 4,145 | 268 | 2,455,965 |
SYS$USERS | 290 | 38 | 135 | 1,079 |
SYS$BACKGROUND | 5 | 4 | 1 | 378 |
APPLSYS.WF_CONTROL | 0 | 0 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
Service Wait Class Stats
- Wait Class info for services in the Service Statistics section.
- Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
- Time Waited (Wt Time) in seconds
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 |
---|---|---|---|---|---|---|---|---|
OAPRD.uio.no | 241463 | 311 | 22260 | 7 | 0 | 0 | 169693 | 6 |
SYS$USERS | 135726 | 236 | 1133 | 1 | 0 | 0 | 1969 | 0 |
SYS$BACKGROUND | 1354 | 1 | 229287 | 38 | 0 | 0 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
SQL Statistics
- SQL ordered by Elapsed Time
- SQL ordered by CPU Time
- SQL ordered by User I/O Wait Time
- SQL ordered by Gets
- SQL ordered by Reads
- SQL ordered by Physical Reads (UnOptimized)
- SQL ordered by Executions
- SQL ordered by Parse Calls
- SQL ordered by Sharable Memory
- SQL ordered by Version Count
- SQL ordered by Cluster Wait Time
- Complete List of SQL Text
SQL ordered by Elapsed Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
- %Total - Elapsed Time as a percentage of Total DB time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 97.4% of Total DB Time (s): 4,769
- Captured PL/SQL account for 81.0% of Total DB Time (s): 4,769
Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
3,634.16 | 0 | 76.21 | 99.90 | 0.00 | 2sw0p1qqt0rda | e:SQLGL:cp:uni/UNIPKDOB | declare oh_ferdig_v varchar2(3... | |
3,634.16 | 0 | 76.21 | 99.90 | 0.00 | df7ccwkvh6886 | e:SQLGL:cp:uni/UNIPKDOB | SELECT GJL.JE_HEADER_ID, GJL.J... | |
363.42 | 3 | 121.14 | 7.62 | 38.09 | 63.54 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
273.35 | 2 | 136.68 | 5.73 | 9.03 | 86.43 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
91.03 | 6 | 15.17 | 1.91 | 99.87 | 0.00 | f7mmad5jy3rv8 | e:PA:cp:uni/UNIUAAGREE | DECLARE v_count number:=0; --v... |
89.83 | 6 | 14.97 | 1.88 | 99.90 | 0.00 | 0kvkkju7wb8u1 | e:PA:cp:uni/UNIUAAGREE | SELECT DISTINCT(PPE.PROJECT_ID... |
54.44 | 3 | 18.15 | 1.14 | 50.14 | 49.99 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
52.59 | 2 | 26.29 | 1.10 | 97.55 | 0.00 | 5603s24fd1pqz | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_DATO" FROM "... |
33.39 | 3 | 11.13 | 0.70 | 41.22 | 58.80 | 5zj4jx8mhq1pk | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
27.29 | 2 | 13.65 | 0.57 | 98.48 | 0.83 | gyvfyqp2kwxms | e:SQLAP:cp:sqlap/APPRVL | SELECT /*+ dynamic_sampling(2)... |
Back to SQL Statistics
Back to Top
SQL ordered by CPU Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - CPU Time as a percentage of Total DB CPU
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 97.9% of Total CPU Time (s): 4,187
- Captured PL/SQL account for 91.1% of Total CPU Time (s): 4,187
CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
3,630.53 | 0 | 86.72 | 3,634.16 | 99.90 | 0.00 | 2sw0p1qqt0rda | e:SQLGL:cp:uni/UNIPKDOB | declare oh_ferdig_v varchar2(3... | |
3,630.53 | 0 | 86.72 | 3,634.16 | 99.90 | 0.00 | df7ccwkvh6886 | e:SQLGL:cp:uni/UNIPKDOB | SELECT GJL.JE_HEADER_ID, GJL.J... | |
138.44 | 3 | 46.15 | 3.31 | 363.42 | 38.09 | 63.54 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
90.91 | 6 | 15.15 | 2.17 | 91.03 | 99.87 | 0.00 | f7mmad5jy3rv8 | e:PA:cp:uni/UNIUAAGREE | DECLARE v_count number:=0; --v... |
89.74 | 6 | 14.96 | 2.14 | 89.83 | 99.90 | 0.00 | 0kvkkju7wb8u1 | e:PA:cp:uni/UNIUAAGREE | SELECT DISTINCT(PPE.PROJECT_ID... |
51.30 | 2 | 25.65 | 1.23 | 52.59 | 97.55 | 0.00 | 5603s24fd1pqz | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_DATO" FROM "... |
27.30 | 3 | 9.10 | 0.65 | 54.44 | 50.14 | 49.99 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
26.88 | 2 | 13.44 | 0.64 | 27.29 | 98.48 | 0.83 | gyvfyqp2kwxms | e:SQLAP:cp:sqlap/APPRVL | SELECT /*+ dynamic_sampling(2)... |
24.69 | 2 | 12.34 | 0.59 | 273.35 | 9.03 | 86.43 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
18.47 | 30 | 0.62 | 0.44 | 19.15 | 96.45 | 1.35 | dfffkcnqfystw | MMON_SLAVE | WITH MONITOR_DATA AS (SELECT I... |
Back to SQL Statistics
Back to Top
SQL ordered by User I/O Wait Time
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - User I/O Time as a percentage of Total User I/O Wait time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Captured SQL account for 95.1% of Total User I/O Wait Time (s): 548
- Captured PL/SQL account for 7.4% of Total User I/O Wait Time (s): 548
User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
236.27 | 2 | 118.14 | 43.14 | 273.35 | 9.03 | 86.43 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
230.93 | 3 | 76.98 | 42.16 | 363.42 | 38.09 | 63.54 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
27.21 | 3 | 9.07 | 4.97 | 54.44 | 50.14 | 49.99 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
19.64 | 3 | 6.55 | 3.59 | 33.39 | 41.22 | 58.80 | 5zj4jx8mhq1pk | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
12.40 | 69 | 0.18 | 2.26 | 14.29 | 7.06 | 86.79 | 6a4hrxan3tuw3 | e:SYSADMIN:cp:fnd/FNDCPPUR | delete from fnd_concurrent_req... |
7.58 | 3 | 2.53 | 1.38 | 20.69 | 63.70 | 36.63 | bqmc00u1qysrg | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
7.32 | 1 | 7.32 | 1.34 | 15.14 | 44.88 | 48.34 | 5t39uchjqpyfm | e:AR:cp:xla/XLAACCUP | BEGIN xla_accounting_pkg.unit_... |
5.70 | 2 | 2.85 | 1.04 | 23.39 | 67.73 | 24.37 | adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL | BEGIN AP_APPROVAL_PKG.WORKER_A... |
5.46 | 1 | 5.46 | 1.00 | 6.11 | 4.49 | 89.32 | 00qqgyvc3nhs6 | e:SQLGL:cp:sqlgl/GLPPOS | insert into GL_BALANCES (ledge... |
4.38 | 2 | 2.19 | 0.80 | 4.45 | 1.75 | 98.45 | 75a4qsa2xu8bj | e:AR:bes:oracle.apps.xla.accounting.extract | INSERT ALL WHEN ANC_ID_1 IS NO... |
Back to SQL Statistics
Back to Top
SQL ordered by Gets
- Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
- %Total - Buffer Gets as a percentage of Total Buffer Gets
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Buffer Gets: 2,457,281,648
- Captured SQL account for 8.8% of Total
Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
2,247,847,298 | 0 | 91.48 | 3,634.16 | 99.9 | 0 | 2sw0p1qqt0rda | e:SQLGL:cp:uni/UNIPKDOB | declare oh_ferdig_v varchar2(3... | |
98,034,148 | 3 | 32,678,049.33 | 3.99 | 363.42 | 38.1 | 63.5 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
56,366,689 | 6 | 9,394,448.17 | 2.29 | 91.03 | 99.9 | 0 | f7mmad5jy3rv8 | e:PA:cp:uni/UNIUAAGREE | DECLARE v_count number:=0; --v... |
55,813,709 | 6 | 9,302,284.83 | 2.27 | 89.83 | 99.9 | 0 | 0kvkkju7wb8u1 | e:PA:cp:uni/UNIUAAGREE | SELECT DISTINCT(PPE.PROJECT_ID... |
37,959,871 | 2 | 18,979,935.50 | 1.54 | 52.59 | 97.6 | 0 | 5603s24fd1pqz | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_DATO" FROM "... |
12,975,641 | 2 | 6,487,820.50 | 0.53 | 27.29 | 98.5 | .8 | gyvfyqp2kwxms | e:SQLAP:cp:sqlap/APPRVL | SELECT /*+ dynamic_sampling(2)... |
4,881,079 | 1,500 | 3,254.05 | 0.20 | 8.63 | 92.3 | 0 | cbkrhurr510pt | e::cp:30 | update Fnd_Concurrent_Queues Q... |
1,832,282 | 2 | 916,141.00 | 0.07 | 23.39 | 67.7 | 24.4 | adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL | BEGIN AP_APPROVAL_PKG.WORKER_A... |
1,204,584 | 24 | 50,191.00 | 0.05 | 4.80 | 99.3 | .1 | 4gyy6fvr32sr2 | zabbix_proxy: poller #56 [got 1 values in 0.0018 | select count(distinct user_id)... |
1,129,200 | 12 | 94,100.00 | 0.05 | 9.67 | 91.4 | 0 | d9t4bv1uhjza0 | oracle@dbora-saf-prod01.uio.no (TNS V1-V3) | SELECT "A1"."SUP_ID", "A1"."SU... |
Back to SQL Statistics
Back to Top
SQL ordered by Reads
- %Total - Physical Reads as a percentage of Total Disk Reads
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Disk Reads: 403,759
- Captured SQL account for 94.3% of Total
Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
238,513 | 3 | 79,504.33 | 59.07 | 363.42 | 38.09 | 63.54 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
135,160 | 2 | 67,580.00 | 33.48 | 273.35 | 9.03 | 86.43 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
2,494 | 3 | 831.33 | 0.62 | 54.44 | 50.14 | 49.99 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
1,982 | 69 | 28.72 | 0.49 | 14.29 | 7.06 | 86.79 | 6a4hrxan3tuw3 | e:SYSADMIN:cp:fnd/FNDCPPUR | delete from fnd_concurrent_req... |
1,812 | 3 | 604.00 | 0.45 | 33.39 | 41.22 | 58.80 | 5zj4jx8mhq1pk | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
927 | 1 | 927.00 | 0.23 | 15.14 | 44.88 | 48.34 | 5t39uchjqpyfm | e:AR:cp:xla/XLAACCUP | BEGIN xla_accounting_pkg.unit_... |
682 | 3 | 227.33 | 0.17 | 20.69 | 63.70 | 36.63 | bqmc00u1qysrg | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
677 | 2 | 338.50 | 0.17 | 23.39 | 67.73 | 24.37 | adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL | BEGIN AP_APPROVAL_PKG.WORKER_A... |
634 | 1 | 634.00 | 0.16 | 6.11 | 4.49 | 89.32 | 00qqgyvc3nhs6 | e:SQLGL:cp:sqlgl/GLPPOS | insert into GL_BALANCES (ledge... |
525 | 30 | 17.50 | 0.13 | 17.47 | 95.59 | 1.58 | fhf8upax5cxsz | MMON_SLAVE | BEGIN sys.dbms_auto_report_int... |
Back to SQL Statistics
Back to Top
SQL ordered by Physical Reads (UnOptimized)
- UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
- %Opt - Optimized Reads as percentage of SQL Read Requests
- %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
- Total Physical Read Requests: 384,604
- Captured SQL account for 37.0% of Total
- Total UnOptimized Read Requests: 384,604
- Captured SQL account for 37.0% of Total
- Total Optimized Read Requests: 1
- Captured SQL account for 0.0% of Total
UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
135,160 | 135,160 | 2 | 67,580.00 | 0.00 | 35.14 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
4,648 | 4,648 | 3 | 1,549.33 | 0.00 | 1.21 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
2,889 | 2,889 | 3 | 963.00 | 0.00 | 0.75 | 5zj4jx8mhq1pk | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
1,982 | 1,982 | 69 | 28.72 | 0.00 | 0.52 | 6a4hrxan3tuw3 | e:SYSADMIN:cp:fnd/FNDCPPUR | delete from fnd_concurrent_req... |
876 | 876 | 30 | 29.20 | 0.00 | 0.23 | fhf8upax5cxsz | MMON_SLAVE | BEGIN sys.dbms_auto_report_int... |
808 | 808 | 1 | 808.00 | 0.00 | 0.21 | 5t39uchjqpyfm | e:AR:cp:xla/XLAACCUP | BEGIN xla_accounting_pkg.unit_... |
677 | 677 | 2 | 338.50 | 0.00 | 0.18 | adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL | BEGIN AP_APPROVAL_PKG.WORKER_A... |
665 | 665 | 30 | 22.17 | 0.00 | 0.17 | 0w26sk6t6gq98 | MMON_SLAVE | SELECT XMLTYPE(DBMS_REPORT.GET... |
665 | 665 | 30 | 22.17 | 0.00 | 0.17 | dfffkcnqfystw | MMON_SLAVE | WITH MONITOR_DATA AS (SELECT I... |
641 | 641 | 1 | 641.00 | 0.00 | 0.17 | 00qqgyvc3nhs6 | e:SQLGL:cp:sqlgl/GLPPOS | insert into GL_BALANCES (ledge... |
Back to SQL Statistics
Back to Top
SQL ordered by Executions
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Total Executions: 537,482
- Captured SQL account for 12.3% of Total
Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
22,300 | 22,300 | 1.00 | 0.49 | 101.6 | 0 | d4zr8df6z0ww4 | select s, c from (select /*+ i... | |
12,098 | 3,224 | 0.27 | 0.16 | 91.5 | 0 | 7qs7fx89194u1 | JDBC Thin Client | SELECT PROFILE_OPTION_VALUE FR... |
8,601 | 7,909 | 0.92 | 0.34 | 80.7 | 0 | 9gdxsmyzbrdkr | JDBC Thin Client | SELECT PROFILE_OPTION_ID, APPL... |
4,415 | 829 | 0.19 | 0.07 | 86 | 0 | 55dc767ajydh3 | e::cp:30 | SELECT PROFILE_OPTION_VALUE FR... |
1,847 | 1,570 | 0.85 | 0.11 | 104.9 | 0 | 7umy6juhzw766 | select /*+ connect_by_filterin... | |
1,744 | 1,327 | 0.76 | 0.29 | 72.9 | 0 | 98j69vs3ymzjv | JDBC Thin Client | SELECT DECODE(:B2 , 'UTF8', FL... |
1,500 | 1,500 | 1.00 | 8.63 | 92.3 | 0 | cbkrhurr510pt | e::cp:30 | update Fnd_Concurrent_Queues Q... |
1,404 | 0 | 0.00 | 0.02 | 93.7 | 0 | bn7jfdsf4zh36 | e:SQLGL:frm:ARXTWMAI | DELETE FROM ZX_JURISDICTIONS_G... |
1,200 | 1,200 | 1.00 | 0.07 | 31 | 0 | 75r3t7hw0n9a9 | e::cp:30 | Select S.SERVICE_HANDLE, S.CAR... |
1,064 | 7,448 | 7.00 | 0.21 | 63.6 | 0 | 19w2h52d7ggr7 | JDBC Thin Client | SELECT * FROM V$NLS_PARAMETERS... |
Back to SQL Statistics
Back to Top
SQL ordered by Parse Calls
- Total Parse Calls: 94,943
- Captured SQL account for 45.2% of Total
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
22,300 | 22,300 | 23.49 | d4zr8df6z0ww4 | select s, c from (select /*+ i... | |
4,818 | 5.07 | 44fs2t6qsqtcd | SELECT distinct(ofri.pid), ofr... | ||
1,847 | 1,847 | 1.95 | 7umy6juhzw766 | select /*+ connect_by_filterin... | |
1,548 | 774 | 1.63 | a3vfsb1vvtr3s | Streams | select queue_id, queue_schema,... |
1,200 | 1,200 | 1.26 | 75r3t7hw0n9a9 | e::cp:30 | Select S.SERVICE_HANDLE, S.CAR... |
1,044 | 1,064 | 1.10 | 2a0bdyyn0sgcb | e:SQLAP:wf:PAAPINVW | SELECT ALOC.RULE_TYPE FROM AP_... |
1,020 | 1,020 | 1.07 | 5us2xwzatpnwy | e::cp:30 | begin fnd_dcp.check_process_st... |
1,017 | 1,017 | 1.07 | 1v818hwxjxy58 | e:PA:cp:ar/RAXTRX | select FND_FLEX_VALUES_VL.FLEX... |
979 | 8,601 | 1.03 | 9gdxsmyzbrdkr | JDBC Thin Client | SELECT PROFILE_OPTION_ID, APPL... |
862 | 1,404 | 0.91 | bn7jfdsf4zh36 | e:SQLGL:frm:ARXTWMAI | DELETE FROM ZX_JURISDICTIONS_G... |
Back to SQL Statistics
Back to Top
SQL ordered by Sharable Memory
- Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
297,839,816 | 56 | 0.71 | frjd8zfy2jfdq | e:SYSADMIN:cp:fnd/FNDWFLSC | SELECT executions, end_of_fetc... |
176,176,590 | 1 | 0.42 | 9k5pyrgwa1p33 | Disco10, NOETIX_SYS | EXPLAIN PLAN SET STATEMENT_ID ... |
43,057,008 | 0.10 | 8awazg1gzathv | |||
41,745,232 | 0.10 | 53qybbn88gtwn | EXPLAIN PLAN SET STATEMENT_ID ... | ||
33,578,344 | 30 | 0.08 | dfffkcnqfystw | MMON_SLAVE | WITH MONITOR_DATA AS (SELECT I... |
29,901,888 | 0.07 | b248yx5mtavhk | |||
25,039,937 | 36 | 0.06 | 01d5n1nm17r2h | select nvl2(stale_stats, decod... | |
20,931,214 | 48 | 0.05 | bva6tcq11hqh6 | e:PA:cp:fnd/FNDRSSUB | INSERT INTO FND_CONCURRENT_REQ... |
20,929,928 | 0.05 | 7k2vfm1k7147j | |||
14,514,460 | 1 | 0.03 | 90bvc17px6ypk | e:SQLAP:bes:oracle.apps.xla.accounting.extract | SELECT /*+ leading(xet) cardin... |
8,106,045 | 30 | 0.02 | 8mdz49zkajhw3 | MMON_SLAVE | SELECT /*+ OPT_PARAM('_fix_con... |
6,308,922 | 5 | 0.02 | bsgjj12c4am0n | e:SYSADMIN:cp:fnd/FNDOAMCOL | select upper(substr(machine, 0... |
3,406,363 | 2 | 0.01 | 622ufbrgvxdc7 | select decode(u.type#, 2, u.ex... | |
2,907,897 | 150 | 0.01 | 986wx8492b7zb | e:PA:cp:uni/UNIUAAGREE | SELECT DISTINCT(PPE.PROJECT_ID... |
2,902,285 | 48 | 0.01 | gwxz4a8zh2x91 | e::fwk:fnd.sso.login.server.MainLoginPageAM | SELECT FCPOI.CONNSTR1 FROM FND... |
2,435,646 | 31 | 0.01 | 1p5grz1gs7fjq | select obj#, type#, ctime, mti... | |
2,385,857 | 8,601 | 0.01 | 9gdxsmyzbrdkr | JDBC Thin Client | SELECT PROFILE_OPTION_ID, APPL... |
2,210,167 | 1,744 | 0.01 | 98j69vs3ymzjv | JDBC Thin Client | SELECT DECODE(:B2 , 'UTF8', FL... |
2,126,431 | 48 | 0.01 | 07bs4cpqybb5f | e::fwk:fnd.sso.login.server.MainLoginPageAM | SELECT FCPOI.NODE_NAME1 FROM F... |
1,921,896 | 1,064 | 0.00 | 19w2h52d7ggr7 | JDBC Thin Client | SELECT * FROM V$NLS_PARAMETERS... |
1,584,858 | 52 | 0.00 | 23s96rf87635s | select count(*) from sys.col_g... | |
1,446,554 | 2 | 0.00 | 75a4qsa2xu8bj | e:AR:bes:oracle.apps.xla.accounting.extract | INSERT ALL WHEN ANC_ID_1 IS NO... |
1,181,177 | 606 | 0.00 | b1cp8pancvaaf | e:PA:cp:pa/PASTRM | SELECT NVL(MPI.STATUS, 'N') FR... |
1,085,648 | 90 | 0.00 | cb21bacyh3c7d | select metadata from kopm$ whe... | |
1,059,451 | 1,017 | 0.00 | 1v818hwxjxy58 | e:PA:cp:ar/RAXTRX | select FND_FLEX_VALUES_VL.FLEX... |
Back to SQL Statistics
Back to Top
SQL ordered by Version Count
- Only Statements with Version Count greater than 20 are displayed
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
871 | 44fs2t6qsqtcd | SELECT distinct(ofri.pid), ofr... | ||
861 | 8awazg1gzathv | |||
324 | b248yx5mtavhk | |||
244 | 7k2vfm1k7147j | |||
220 | 53qybbn88gtwn | EXPLAIN PLAN SET STATEMENT_ID ... | ||
193 | 5 | bsgjj12c4am0n | e:SYSADMIN:cp:fnd/FNDOAMCOL | select upper(substr(machine, 0... |
157 | 48 | bva6tcq11hqh6 | e:PA:cp:fnd/FNDRSSUB | INSERT INTO FND_CONCURRENT_REQ... |
152 | 56 | frjd8zfy2jfdq | e:SYSADMIN:cp:fnd/FNDWFLSC | SELECT executions, end_of_fetc... |
105 | 1 | 9k5pyrgwa1p33 | Disco10, NOETIX_SYS | EXPLAIN PLAN SET STATEMENT_ID ... |
80 | 31 | 1p5grz1gs7fjq | select obj#, type#, ctime, mti... | |
75 | 48 | gwxz4a8zh2x91 | e::fwk:fnd.sso.login.server.MainLoginPageAM | SELECT FCPOI.CONNSTR1 FROM FND... |
73 | 52 | 23s96rf87635s | select count(*) from sys.col_g... | |
64 | 1,744 | 98j69vs3ymzjv | JDBC Thin Client | SELECT DECODE(:B2 , 'UTF8', FL... |
59 | 2 | 622ufbrgvxdc7 | select decode(u.type#, 2, u.ex... | |
59 | 8,601 | 9gdxsmyzbrdkr | JDBC Thin Client | SELECT PROFILE_OPTION_ID, APPL... |
58 | 48 | 07bs4cpqybb5f | e::fwk:fnd.sso.login.server.MainLoginPageAM | SELECT FCPOI.NODE_NAME1 FROM F... |
56 | 90 | cb21bacyh3c7d | select metadata from kopm$ whe... | |
54 | 606 | b1cp8pancvaaf | e:PA:cp:pa/PASTRM | SELECT NVL(MPI.STATUS, 'N') FR... |
53 | 150 | 986wx8492b7zb | e:PA:cp:uni/UNIUAAGREE | SELECT DISTINCT(PPE.PROJECT_ID... |
50 | 1,064 | 19w2h52d7ggr7 | JDBC Thin Client | SELECT * FROM V$NLS_PARAMETERS... |
38 | 36 | 01d5n1nm17r2h | select nvl2(stale_stats, decod... | |
31 | 1 | 90bvc17px6ypk | e:SQLAP:bes:oracle.apps.xla.accounting.extract | SELECT /*+ leading(xet) cardin... |
29 | 395 | 036uuc1nhwjdq | e:PA:cp:PASMGR | select local_date_language, ut... |
25 | 1,017 | 1v818hwxjxy58 | e:PA:cp:ar/RAXTRX | select FND_FLEX_VALUES_VL.FLEX... |
24 | 408 | 4vs91dcv7u1p6 | JDBC Thin Client | insert into sys.aud$( sessioni... |
Back to SQL Statistics
Back to Top
SQL ordered by Cluster Wait Time
- %Total - Cluster Time as a percentage of Total Cluster Wait Time
- %Clu - Cluster Time as a percentage of Elapsed Time
- %CPU - CPU Time as a percentage of Elapsed Time
- %IO - User I/O Time as a percentage of Elapsed Time
- Only SQL with Cluster Wait Time > .005 seconds is reported
- Total Cluster Wait Time (s): 27
- Captured SQL account for 89.6% of Total
Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
19.97 | 2 | 74.04 | 273.35 | 7.31 | 9.03 | 86.43 | a3kxyqjurdtp8 | Oracle Enterprise Manager.Metric Engine | insert into mgmt_db_size_gtt S... |
1.84 | 2 | 6.81 | 23.39 | 7.86 | 67.73 | 24.37 | adj796q5rqv7m | e:SQLAP:cp:sqlap/WORKERAPPRVL | BEGIN AP_APPROVAL_PKG.WORKER_A... |
1.59 | 522 | 5.90 | 5.41 | 29.42 | 12.53 | 59.47 | 0hqzd66q8bkbz | e:SQLAP:wf:PAAPINVW | INSERT INTO AP_INVOICE_DISTRIB... |
1.03 | 69 | 3.81 | 14.29 | 7.19 | 7.06 | 86.79 | 6a4hrxan3tuw3 | e:SYSADMIN:cp:fnd/FNDCPPUR | delete from fnd_concurrent_req... |
0.49 | 1 | 1.81 | 6.11 | 7.98 | 4.49 | 89.32 | 00qqgyvc3nhs6 | e:SQLGL:cp:sqlgl/GLPPOS | insert into GL_BALANCES (ledge... |
0.47 | 39 | 1.74 | 9.11 | 5.17 | 93.80 | 0.75 | 90qc35z536uyh | e:PA:cp:fnd/FNDRSSTG | BEGIN FND_REQUEST_SET.FNDRSSTG... |
0.46 | 20 | 1.71 | 8.82 | 5.22 | 94.74 | 0.00 | 8u5bcx7k90a60 | e:PA:cp:fnd/FNDRSSTG | SELECT R.REQUEST_ID, A.APPLICA... |
0.46 | 20 | 1.71 | 8.83 | 5.21 | 94.73 | 0.00 | gnvu6ctuhxupk | e:PA:cp:fnd/FNDRSSTG | begin :r := FND_REQUEST_SET.ST... |
0.22 | 1 | 0.83 | 15.14 | 1.47 | 44.88 | 48.34 | 5t39uchjqpyfm | e:AR:cp:xla/XLAACCUP | BEGIN xla_accounting_pkg.unit_... |
0.22 | 3 | 0.81 | 54.44 | 0.40 | 50.14 | 49.99 | 86237s31u25vy | e:AR:cp:uni/OPPDATER_EFAKTURA | Declare resp_org_id integer; -... |
0.18 | 3 | 0.66 | 363.42 | 0.05 | 38.09 | 63.54 | bq8r44u67tf9g | oracle@dbora-dv-prod01.uio.no (TNS V1-V3) | SELECT "ART", "HB_BILAGSNR" FR... |
0.17 | 3 | 0.62 | 33.39 | 0.50 | 41.22 | 58.80 | 5zj4jx8mhq1pk | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
0.12 | 2 | 0.43 | 27.29 | 0.43 | 98.48 | 0.83 | gyvfyqp2kwxms | e:SQLAP:cp:sqlap/APPRVL | SELECT /*+ dynamic_sampling(2)... |
0.05 | 3 | 0.19 | 20.69 | 0.25 | 63.70 | 36.63 | bqmc00u1qysrg | e:AR:cp:uni/OPPDATER_EFAKTURA | SELECT DISTINCT REGEXP_REPLACE... |
0.03 | 1,500 | 0.13 | 8.63 | 0.40 | 92.25 | 0.00 | cbkrhurr510pt | e::cp:30 | update Fnd_Concurrent_Queues Q... |
0.02 | 48 | 0.09 | 0.29 | 8.48 | 24.99 | 78.51 | bva6tcq11hqh6 | e:PA:cp:fnd/FNDRSSUB | INSERT INTO FND_CONCURRENT_REQ... |
0.02 | 840 | 0.06 | 0.06 | 26.43 | 22.35 | 0.00 | 85yg51mb2tc1t | e::cp:30 | Update fnd_concurrent_queues s... |
0.02 | 406 | 0.06 | 0.19 | 8.17 | 91.57 | 0.55 | 9zg9qd9bm4spu | sqlplus@bot-app-prod03.uio.no (TNS V1-V3) | update user$ set spare6=DECODE... |
0.01 | 2 | 0.04 | 4.45 | 0.23 | 1.75 | 98.45 | 75a4qsa2xu8bj | e:AR:bes:oracle.apps.xla.accounting.extract | INSERT ALL WHEN ANC_ID_1 IS NO... |
0.01 | 24 | 0.03 | 4.80 | 0.19 | 99.25 | 0.09 | 4gyy6fvr32sr2 | zabbix_proxy: poller #56 [got 1 values in 0.0018 | select count(distinct user_id)... |
0.01 | 406 | 0.03 | 0.05 | 17.23 | 83.88 | 10.44 | 865qwpcdyggkk | select spare6 from user$ where... | |
0.01 | 30 | 0.03 | 17.47 | 0.04 | 95.59 | 1.58 | fhf8upax5cxsz | MMON_SLAVE | BEGIN sys.dbms_auto_report_int... |
0.01 | 31 | 0.02 | 0.02 | 26.93 | 63.63 | 0.00 | 1p5grz1gs7fjq | select obj#, type#, ctime, mti... | |
0.01 | 2 | 0.02 | 3.93 | 0.13 | 85.09 | 0.00 | 1f2jjrmndu6jc | e:SQLAP:bes:oracle.apps.xla.accounting.extract | BEGIN :1 := XLA_00200_AAD_C_01... |
Back to SQL Statistics
Back to Top
Complete List of SQL Text
Back to SQL StatisticsBack to Top
Instance Activity Statistics
- Key Instance Activity Stats
- Instance Activity Stats
- Instance Activity Stats - Absolute Values
- Instance Activity Stats - Thread Activity
Key Instance Activity Stats
- Ordered by statistic name
Statistic | Total | per Second | per Trans |
---|---|---|---|
db block changes | 609,152 | 168.60 | 83.23 |
execute count | 537,482 | 148.77 | 73.44 |
gc cr block receive time | 19 | 0.01 | 0.00 |
gc cr blocks received | 783 | 0.22 | 0.11 |
gc current block receive time | 86 | 0.02 | 0.01 |
gc current blocks received | 3,221 | 0.89 | 0.44 |
logons cumulative | 6,790 | 1.88 | 0.93 |
opened cursors cumulative | 468,522 | 129.68 | 64.01 |
parse count (total) | 94,943 | 26.28 | 12.97 |
parse time elapsed | 4,246 | 1.18 | 0.58 |
physical reads | 403,759 | 111.75 | 55.17 |
physical writes | 24,134 | 6.68 | 3.30 |
redo size | 96,888,768 | 26,817.30 | 13,237.98 |
session cursor cache hits | 233,162 | 64.54 | 31.86 |
session logical reads | 2,457,281,648 | 680,137.30 | 335,740.08 |
user calls | 165,062 | 45.69 | 22.55 |
user commits | 4,814 | 1.33 | 0.66 |
user rollbacks | 2,505 | 0.69 | 0.34 |
workarea executions - onepass | 4 | 0.00 | 0.00 |
workarea executions - optimal | 28,720 | 7.95 | 3.92 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats
- Ordered by statistic name
Statistic | Total | per Second | per Trans |
---|---|---|---|
Batched IO (bound) vector count | 179,631 | 49.72 | 24.54 |
Batched IO (full) vector count | 1 | 0.00 | 0.00 |
Batched IO (space) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 580,856 | 160.77 | 79.36 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 6,210 | 1.72 | 0.85 |
Batched IO same unit count | 372,755 | 103.17 | 50.93 |
Batched IO single block count | 177,260 | 49.06 | 24.22 |
Batched IO slow jump count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 27,522 | 7.62 | 3.76 |
Batched IO vector read count | 8,582 | 2.38 | 1.17 |
Block Cleanout Optim referenced | 2,493 | 0.69 | 0.34 |
CCursor + sql area evicted | 243 | 0.07 | 0.03 |
CPU used by this session | 82,663 | 22.88 | 11.29 |
CPU used when call started | 75,883 | 21.00 | 10.37 |
CR blocks created | 4,114 | 1.14 | 0.56 |
Cached Commit SCN referenced | 1,041 | 0.29 | 0.14 |
Clusterwide global transactions | 194 | 0.05 | 0.03 |
Commit SCN cached | 5,774 | 1.60 | 0.79 |
DBWR checkpoint buffers written | 20,598 | 5.70 | 2.81 |
DBWR checkpoints | 109 | 0.03 | 0.01 |
DBWR fusion writes | 322 | 0.09 | 0.04 |
DBWR object drop buffers written | 151 | 0.04 | 0.02 |
DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 151 | 0.04 | 0.02 |
DBWR undo block writes | 4,124 | 1.14 | 0.56 |
DDL statements parallelized | 0 | 0.00 | 0.00 |
DFO trees parallelized | 1,274 | 0.35 | 0.17 |
DML statements parallelized | 0 | 0.00 | 0.00 |
DX/BB enqueue lock background get time | 5 | 0.00 | 0.00 |
DX/BB enqueue lock background gets | 388 | 0.11 | 0.05 |
DX/BB enqueue lock foreground requests | 8,892 | 2.46 | 1.21 |
Effective IO time | 6,895 | 1.91 | 0.94 |
GTX processes spawned by autotune | 0 | 0.00 | 0.00 |
GTX processes stopped by autotune | 0 | 0.00 | 0.00 |
HSC Compressed Segment Block Changes | 0 | 0.00 | 0.00 |
HSC Heap Segment Block Changes | 94,976 | 26.29 | 12.98 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 2,083 | 0.58 | 0.28 |
Heap Segment Array Updates | 1,397 | 0.39 | 0.19 |
Heatmap BlkLevel Flushed | 1 | 0.00 | 0.00 |
Heatmap BlkLevel Flushed to BF | 1 | 0.00 | 0.00 |
Heatmap BlkLevel Ranges Flushed | 1 | 0.00 | 0.00 |
Heatmap Blklevel Flush Task Count | 1 | 0.00 | 0.00 |
KTFB alloc req | 50 | 0.01 | 0.01 |
KTFB alloc space (block) | 8,126,464 | 2,249.28 | 1,110.32 |
KTFB alloc time (ms) | 4,877 | 1.35 | 0.67 |
KTFB apply req | 0 | 0.00 | 0.00 |
KTFB apply time (ms) | 0 | 0.00 | 0.00 |
KTFB commit req | 0 | 0.00 | 0.00 |
KTFB commit time (ms) | 0 | 0.00 | 0.00 |
KTFB free req | 0 | 0.00 | 0.00 |
KTFB free space (block) | 0 | 0.00 | 0.00 |
KTFB free time (ms) | 0 | 0.00 | 0.00 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
Number of read IOs issued | 8 | 0.00 | 0.00 |
OLAP Engine Calls | 0 | 0.00 | 0.00 |
OLAP Paging Manager Cache Changed Page | 0 | 0.00 | 0.00 |
OLAP Paging Manager Cache Hit | 0 | 0.00 | 0.00 |
OLAP Paging Manager Cache Miss | 0 | 0.00 | 0.00 |
OLAP Paging Manager New Page | 0 | 0.00 | 0.00 |
OLAP Perm LOB Read | 0 | 0.00 | 0.00 |
PX local messages recv'd | 18,113 | 5.01 | 2.47 |
PX local messages sent | 18,113 | 5.01 | 2.47 |
PX remote messages recv'd | 12,327 | 3.41 | 1.68 |
PX remote messages sent | 12,657 | 3.50 | 1.73 |
Parallel operations downgraded 25 to 50 pct | 0 | 0.00 | 0.00 |
Parallel operations downgraded 75 to 99 pct | 0 | 0.00 | 0.00 |
Parallel operations downgraded to serial | 1 | 0.00 | 0.00 |
Parallel operations not downgraded | 4,442 | 1.23 | 0.61 |
Requests to/from client | 115,809 | 32.05 | 15.82 |
RowCR - row contention | 1,328 | 0.37 | 0.18 |
RowCR attempts | 50,011 | 13.84 | 6.83 |
RowCR hits | 50,159 | 13.88 | 6.85 |
SCN increments due to another database | 3,968,363 | 1,098.38 | 542.20 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 115,831 | 32.06 | 15.83 |
SQL*Net roundtrips to/from dblink | 0 | 0.00 | 0.00 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 3,069 | 0.85 | 0.42 |
background checkpoints completed | 0 | 0.00 | 0.00 |
background checkpoints started | 0 | 0.00 | 0.00 |
background timeouts | 32,331 | 8.95 | 4.42 |
branch node splits | 1 | 0.00 | 0.00 |
buffer is not pinned count | 2,395,479,556 | 663,031.44 | 327,296.02 |
buffer is pinned count | 3,854,368,742 | 1,066,829.25 | 526,625.05 |
bytes received via SQL*Net from client | 21,609,979 | 5,981.31 | 2,952.59 |
bytes received via SQL*Net from dblink | 0 | 0.00 | 0.00 |
bytes sent via SQL*Net to client | 449,683,643 | 124,465.43 | 61,440.59 |
bytes sent via SQL*Net to dblink | 0 | 0.00 | 0.00 |
calls to get snapshot scn: kcmgss | 660,895 | 182.93 | 90.30 |
calls to kcmgas | 22,459 | 6.22 | 3.07 |
calls to kcmgcs | 1,336,433 | 369.90 | 182.60 |
cell physical IO interconnect bytes | 6,738,738,426 | 1,865,177.87 | 920,718.46 |
change write time | 191 | 0.05 | 0.03 |
cleanout - number of ktugct calls | 15,930 | 4.41 | 2.18 |
cleanouts and rollbacks - consistent read gets | 318 | 0.09 | 0.04 |
cleanouts only - consistent read gets | 10,534 | 2.92 | 1.44 |
cluster key scan block gets | 14,135 | 3.91 | 1.93 |
cluster key scans | 7,354 | 2.04 | 1.00 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 8 | 0.00 | 0.00 |
commit batch/immediate requested | 8 | 0.00 | 0.00 |
commit cleanout failures: block lost | 1,385 | 0.38 | 0.19 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 1 | 0.00 | 0.00 |
commit cleanouts | 46,106 | 12.76 | 6.30 |
commit immediate performed | 8 | 0.00 | 0.00 |
commit immediate requested | 8 | 0.00 | 0.00 |
commit txn count during cleanout | 28,659 | 7.93 | 3.92 |
consistent changes | 151,008 | 41.80 | 20.63 |
consistent gets | 2,456,566,778 | 679,939.43 | 335,642.41 |
consistent gets direct | 14 | 0.00 | 0.00 |
consistent gets examination | 118,867,419 | 32,900.65 | 16,240.94 |
consistent gets examination (fastpath) | 118,863,233 | 32,899.49 | 16,240.37 |
consistent gets from cache | 2,456,566,745 | 679,939.42 | 335,642.40 |
consistent gets pin | 2,337,699,313 | 647,038.77 | 319,401.46 |
consistent gets pin (fastpath) | 2,337,163,987 | 646,890.60 | 319,328.32 |
cursor authentications | 44 | 0.01 | 0.01 |
cursor reload failures | 1 | 0.00 | 0.00 |
data blocks consistent reads - undo records applied | 7,880 | 2.18 | 1.08 |
db block changes | 609,152 | 168.60 | 83.23 |
db block gets | 714,507 | 197.76 | 97.62 |
db block gets direct | 246 | 0.07 | 0.03 |
db block gets from cache | 714,261 | 197.70 | 97.59 |
db block gets from cache (fastpath) | 274,101 | 75.87 | 37.45 |
deferred (CURRENT) block cleanout applications | 5,718 | 1.58 | 0.78 |
dirty buffers inspected | 10 | 0.00 | 0.00 |
enqueue conversions | 20,960 | 5.80 | 2.86 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 137,279 | 38.00 | 18.76 |
enqueue requests | 140,017 | 38.75 | 19.13 |
enqueue timeouts | 2,705 | 0.75 | 0.37 |
enqueue waits | 10,344 | 2.86 | 1.41 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 537,482 | 148.77 | 73.44 |
failed probes on index block reclamation | 5 | 0.00 | 0.00 |
fastpath consistent get quota limit | 116,916 | 32.36 | 15.97 |
file io service time | 450,799 | 124.77 | 61.59 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 283,103 | 78.36 | 38.68 |
free buffer requested | 445,265 | 123.24 | 60.84 |
gc blocks compressed | 1,238 | 0.34 | 0.17 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block flush time | 7 | 0.00 | 0.00 |
gc cr block receive time | 19 | 0.01 | 0.00 |
gc cr blocks flushed | 87 | 0.02 | 0.01 |
gc cr blocks received | 783 | 0.22 | 0.11 |
gc cr blocks served | 1,066 | 0.30 | 0.15 |
gc current block flush time | 2 | 0.00 | 0.00 |
gc current block pin time | 0 | 0.00 | 0.00 |
gc current block receive time | 86 | 0.02 | 0.01 |
gc current blocks flushed | 18 | 0.00 | 0.00 |
gc current blocks pinned | 1 | 0.00 | 0.00 |
gc current blocks received | 3,221 | 0.89 | 0.44 |
gc current blocks served | 678 | 0.19 | 0.09 |
gc force cr read cr | 133,636 | 36.99 | 18.26 |
gc force cr read current | 11 | 0.00 | 0.00 |
gc kbytes saved | 5,500 | 1.52 | 0.75 |
gc kbytes sent | 8,453 | 2.34 | 1.15 |
gc local grants | 336,902 | 93.25 | 46.03 |
gc read time waited | 0 | 0.00 | 0.00 |
gc read wait timeouts | 0 | 0.00 | 0.00 |
gc read waits | 0 | 0.00 | 0.00 |
gc reader bypass grants | 168 | 0.05 | 0.02 |
gc reader bypass waits | 82 | 0.02 | 0.01 |
gc remote grants | 79,245 | 21.93 | 10.83 |
gcs messages sent | 241,128 | 66.74 | 32.95 |
ges messages sent | 513,460 | 142.12 | 70.15 |
global enqueue get time | 6,728 | 1.86 | 0.92 |
global enqueue gets async | 1,430 | 0.40 | 0.20 |
global enqueue gets sync | 995,155 | 275.44 | 135.97 |
global enqueue releases | 965,077 | 267.12 | 131.86 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 8,520 | 2.36 | 1.16 |
hot buffers moved to head of LRU | 32,837 | 9.09 | 4.49 |
immediate (CR) block cleanout applications | 10,852 | 3.00 | 1.48 |
immediate (CURRENT) block cleanout applications | 4,463 | 1.24 | 0.61 |
index crx upgrade (positioned) | 10,990 | 3.04 | 1.50 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (direct read) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 406 | 0.11 | 0.06 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 2,518,806,195 | 697,166.33 | 344,146.22 |
index scans kdiixs1 | 9,755,767 | 2,700.24 | 1,332.94 |
java call heap collected bytes | 0 | 0.00 | 0.00 |
java call heap collected count | 0 | 0.00 | 0.00 |
java call heap gc count | 0 | 0.00 | 0.00 |
java call heap live object count | 0 | 0.00 | 0.00 |
java call heap live object count max | 0 | 0.00 | 0.00 |
java call heap live size | 0 | 0.00 | 0.00 |
java call heap live size max | 0 | 0.00 | 0.00 |
java call heap object count | 0 | 0.00 | 0.00 |
java call heap object count max | 0 | 0.00 | 0.00 |
java call heap total size | 0 | 0.00 | 0.00 |
java call heap total size max | 0 | 0.00 | 0.00 |
java call heap used size | 0 | 0.00 | 0.00 |
java call heap used size max | 0 | 0.00 | 0.00 |
java session heap live object count | 0 | 0.00 | 0.00 |
java session heap live object count max | 0 | 0.00 | 0.00 |
java session heap live size | 0 | 0.00 | 0.00 |
java session heap live size max | 0 | 0.00 | 0.00 |
java session heap object count | 0 | 0.00 | 0.00 |
java session heap object count max | 0 | 0.00 | 0.00 |
java session heap used size | 0 | 0.00 | 0.00 |
java session heap used size max | 0 | 0.00 | 0.00 |
leaf node 90-10 splits | 63 | 0.02 | 0.01 |
leaf node splits | 569 | 0.16 | 0.08 |
lob reads | 4,720 | 1.31 | 0.64 |
lob writes | 5,696 | 1.58 | 0.78 |
lob writes unaligned | 5,696 | 1.58 | 0.78 |
logical read bytes from cache | 20,130,045,853,696 | 5,571,683,251.69 | 2,750,381,999.41 |
logons cumulative | 6,790 | 1.88 | 0.93 |
max cf enq hold time | 0 | 0.00 | 0.00 |
messages received | 14,558 | 4.03 | 1.99 |
messages sent | 14,558 | 4.03 | 1.99 |
min active SCN optimization applied on CR | 352 | 0.10 | 0.05 |
no buffer to keep pinned count | 443 | 0.12 | 0.06 |
no work - consistent read gets | 2,328,183,419 | 644,404.92 | 318,101.30 |
non-idle wait count | 2,013,086 | 557.19 | 275.05 |
opened cursors cumulative | 468,522 | 129.68 | 64.01 |
parse count (describe) | 1 | 0.00 | 0.00 |
parse count (failures) | 14 | 0.00 | 0.00 |
parse count (hard) | 166 | 0.05 | 0.02 |
parse count (total) | 94,943 | 26.28 | 12.97 |
parse time cpu | 3,474 | 0.96 | 0.47 |
parse time elapsed | 4,246 | 1.18 | 0.58 |
physical read IO requests | 384,604 | 106.45 | 52.55 |
physical read bytes | 3,307,593,728 | 915,490.44 | 451,918.80 |
physical read total IO requests | 412,106 | 114.06 | 56.31 |
physical read total bytes | 6,304,353,280 | 1,744,946.82 | 861,368.12 |
physical read total multi block requests | 9,016 | 2.50 | 1.23 |
physical reads | 403,759 | 111.75 | 55.17 |
physical reads cache | 403,591 | 111.71 | 55.14 |
physical reads cache prefetch | 36,974 | 10.23 | 5.05 |
physical reads direct | 167 | 0.05 | 0.02 |
physical reads direct (lob) | 14 | 0.00 | 0.00 |
physical reads direct temporary tablespace | 153 | 0.04 | 0.02 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 15,055 | 4.17 | 2.06 |
physical write bytes | 197,705,728 | 54,721.87 | 27,012.67 |
physical write total IO requests | 34,442 | 9.53 | 4.71 |
physical write total bytes | 434,385,146 | 120,231.04 | 59,350.34 |
physical write total multi block requests | 781 | 0.22 | 0.11 |
physical writes | 24,134 | 6.68 | 3.30 |
physical writes direct | 430 | 0.12 | 0.06 |
physical writes direct (lob) | 35 | 0.01 | 0.00 |
physical writes direct temporary tablespace | 366 | 0.10 | 0.05 |
physical writes from cache | 23,704 | 6.56 | 3.24 |
physical writes non checkpoint | 10,672 | 2.95 | 1.46 |
pinned buffers inspected | 4 | 0.00 | 0.00 |
pinned cursors current | 4 | 0.00 | 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,053 | 0.29 | 0.14 |
process last non-idle time | 3,640 | 1.01 | 0.50 |
queries parallelized | 1,274 | 0.35 | 0.17 |
recovery blocks read | 1 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 1,321,559 | 365.79 | 180.57 |
recursive cpu usage | 26,370 | 7.30 | 3.60 |
redo KB read | 0 | 0.00 | 0.00 |
redo blocks checksummed by FG (exclusive) | 31,548 | 8.73 | 4.31 |
redo blocks written | 200,062 | 55.37 | 27.33 |
redo blocks written (group 0) | 199,479 | 55.21 | 27.25 |
redo blocks written (group 1) | 583 | 0.16 | 0.08 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 485,848 | 134.48 | 66.38 |
redo entries for lost write detection | 231,008 | 63.94 | 31.56 |
redo log space requests | 0 | 0.00 | 0.00 |
redo ordering marks | 10 | 0.00 | 0.00 |
redo size | 96,888,768 | 26,817.30 | 13,237.98 |
redo size for direct writes | 271,788 | 75.23 | 37.13 |
redo size for lost write detection | 15,208,332 | 4,209.43 | 2,077.92 |
redo subscn max counts | 5,559 | 1.54 | 0.76 |
redo synch long waits | 16 | 0.00 | 0.00 |
redo synch time | 310 | 0.09 | 0.04 |
redo synch time (usec) | 3,453,969 | 956.00 | 471.92 |
redo synch time overhead (usec) | 1,583,999 | 438.43 | 216.42 |
redo synch time overhead count ( 2ms) | 4,066 | 1.13 | 0.56 |
redo synch time overhead count ( 8ms) | 16 | 0.00 | 0.00 |
redo synch time overhead count ( 32ms) | 1 | 0.00 | 0.00 |
redo synch time overhead count (128ms) | 1 | 0.00 | 0.00 |
redo synch time overhead count (inf) | 3 | 0.00 | 0.00 |
redo synch writes | 4,507 | 1.25 | 0.62 |
redo wastage | 1,883,860 | 521.42 | 257.39 |
redo write broadcast ack count | 1,029 | 0.28 | 0.14 |
redo write broadcast ack time | 2,186,532 | 605.20 | 298.75 |
redo write broadcast lgwr post count | 0 | 0.00 | 0.00 |
redo write finish time | 6,088,556 | 1,685.22 | 831.88 |
redo write gather time | 502,042 | 138.96 | 68.59 |
redo write info find | 4,087 | 1.13 | 0.56 |
redo write info find fail | 0 | 0.00 | 0.00 |
redo write schedule time | 512,073 | 141.73 | 69.96 |
redo write size count ( 4KB) | 5,708 | 1.58 | 0.78 |
redo write size count ( 8KB) | 566 | 0.16 | 0.08 |
redo write size count ( 16KB) | 439 | 0.12 | 0.06 |
redo write size count ( 32KB) | 264 | 0.07 | 0.04 |
redo write size count ( 128KB) | 173 | 0.05 | 0.02 |
redo write size count ( 256KB) | 75 | 0.02 | 0.01 |
redo write size count ( 512KB) | 191 | 0.05 | 0.03 |
redo write size count (1024KB) | 1 | 0.00 | 0.00 |
redo write size count (inf) | 0 | 0.00 | 0.00 |
redo write time | 610 | 0.17 | 0.08 |
redo write time (usec) | 6,092,925 | 1,686.43 | 832.48 |
redo write total time | 6,442,709 | 1,783.24 | 880.27 |
redo write worker delay (usec) | 255,005 | 70.58 | 34.84 |
redo writes | 7,417 | 2.05 | 1.01 |
redo writes (group 0) | 7,412 | 2.05 | 1.01 |
redo writes (group 1) | 5 | 0.00 | 0.00 |
redo writes adaptive all | 7,417 | 2.05 | 1.01 |
redo writes adaptive worker | 7,417 | 2.05 | 1.01 |
remote Oradebug requests | 0 | 0.00 | 0.00 |
rollback changes - undo records applied | 136 | 0.04 | 0.02 |
rollbacks only - consistent read gets | 1,039 | 0.29 | 0.14 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 47,928,626 | 13,265.90 | 6,548.52 |
securefile allocation bytes | 253,952 | 70.29 | 34.70 |
securefile allocation chunks | 21 | 0.01 | 0.00 |
securefile bytes non-transformed | 180,593 | 49.99 | 24.67 |
securefile direct read bytes | 0 | 0.00 | 0.00 |
securefile direct read ops | 0 | 0.00 | 0.00 |
securefile direct write bytes | 253,952 | 70.29 | 34.70 |
securefile direct write ops | 21 | 0.01 | 0.00 |
securefile number of flushes | 0 | 0.00 | 0.00 |
securefile number of non-transformed flushes | 30 | 0.01 | 0.00 |
segment cfs allocations | 34 | 0.01 | 0.00 |
segment chunks allocation from disepnser | 20 | 0.01 | 0.00 |
segment dispenser allocations | 20 | 0.01 | 0.00 |
segment dispenser load empty | 68 | 0.02 | 0.01 |
segment dispenser load tasks | 681 | 0.19 | 0.09 |
segment prealloc bytes | 0 | 0.00 | 0.00 |
segment prealloc ops | 245 | 0.07 | 0.03 |
segment prealloc tasks | 170 | 0.05 | 0.02 |
segment prealloc time (ms) | 11 | 0.00 | 0.00 |
segment prealloc ufs2cfs bytes | 0 | 0.00 | 0.00 |
segment total chunk allocation | 0 | 0.00 | 0.00 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 233,162 | 64.54 | 31.86 |
session logical reads | 2,457,281,648 | 680,137.30 | 335,740.08 |
shared hash latch upgrades - no wait | 544,893 | 150.82 | 74.45 |
shared hash latch upgrades - wait | 1,313 | 0.36 | 0.18 |
shared io pool buffer get success | 21 | 0.01 | 0.00 |
sorts (disk) | 2 | 0.00 | 0.00 |
sorts (memory) | 146,301 | 40.49 | 19.99 |
sorts (rows) | 1,383,592 | 382.96 | 189.04 |
sql area evicted | 196 | 0.05 | 0.03 |
sql area purged | 17 | 0.00 | 0.00 |
summed dirty queue length | 8 | 0.00 | 0.00 |
switch current to new buffer | 18,814 | 5.21 | 2.57 |
table fetch by rowid | 2,544,350,093 | 704,236.49 | 347,636.30 |
table fetch continued row | 1,124,654,494 | 311,286.85 | 153,662.32 |
table scan blocks gotten | 20,616,683 | 5,706.38 | 2,816.87 |
table scan disk non-IMC rows gotten | 812,634,422 | 224,924.55 | 111,030.80 |
table scan rows gotten | 815,672,638 | 225,765.49 | 111,445.91 |
table scans (cache partitions) | 0 | 0.00 | 0.00 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 15 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 319,085 | 88.32 | 43.60 |
temp space allocated (bytes) | 22,020,096 | 6,094.82 | 3,008.62 |
total cf enq hold time | 80 | 0.02 | 0.01 |
total number of cf enq holders | 53 | 0.01 | 0.01 |
total number of times SMON posted | 204 | 0.06 | 0.03 |
transaction lock background gets | 0 | 0.00 | 0.00 |
transaction lock foreground requests | 0 | 0.00 | 0.00 |
transaction rollbacks | 7 | 0.00 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 37,546,824 | 10,392.38 | 5,130.05 |
user calls | 165,062 | 45.69 | 22.55 |
user commits | 4,814 | 1.33 | 0.66 |
user logons cumulative | 437 | 0.12 | 0.06 |
user logouts cumulative | 438 | 0.12 | 0.06 |
user rollbacks | 2,505 | 0.69 | 0.34 |
workarea executions - onepass | 4 | 0.00 | 0.00 |
workarea executions - optimal | 28,720 | 7.95 | 3.92 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 5 | 0.00 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Absolute Values
- Statistics with absolute values (should not be diffed)
Statistic | Begin Value | End Value |
---|---|---|
logons current | 241 | 241 |
opened cursors current | 5,255 | 5,173 |
session cursor cache count | 90,442,818 | 90,476,300 |
session pga memory | 2,505,282,368 | 2,526,627,360 |
session pga memory max | 3,498,998,432 | 3,605,443,264 |
session uga memory | 1,082,712,562,680 | 1,083,324,159,792 |
session uga memory max | 14,510,658,387,240 | 14,516,164,147,776 |
workarea memory allocated | 108,465 | 111,064 |
Back to Instance Activity Statistics
Back to Top
Instance Activity Stats - Thread Activity
- Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 0 | 0.00 |
Back to Instance Activity Statistics
Back to Top
IO Stats
- IOStat by Function summary
- IOStat by Filetype summary
- IOStat by Function/Filetype summary
- Tablespace IO Stats
- File IO Stats
IOStat by Function summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- ordered by (Data Read + Write) desc
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 | 3.1G | 106.56 | .878M | 0M | 0.00 | 0M | 366.9K | 1.44 |
Others | 2.8G | 7.53 | .786M | 31M | 1.16 | .009M | 20.4K | 0.71 |
LGWR | 0M | 0.00 | 0M | 196M | 4.24 | .054M | 7403 | 0.75 |
DBWR | 0M | 0.00 | 0M | 186M | 4.10 | .051M | 1 | 0.00 |
Direct Reads | 2M | 0.01 | .001M | 0M | 0.00 | 0M | 0 | |
Direct Writes | 0M | 0.00 | 0M | 2M | 0.02 | .001M | 10 | 0.00 |
TOTAL: | 5.9G | 114.09 | 1.665M | 415M | 9.53 | .115M | 394.7K | 1.39 |
Back to IO Stats
Back to Top
IOStat by Filetype summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- Small Read and Large Read are average service times, in milliseconds
- Ordered by (Data Read + Write) desc
Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
---|---|---|---|---|---|---|---|---|
Data File | 3.1G | 106.38 | .872M | 185M | 4.07 | .051M | 1.02 | 3.51 |
External Table | 1.1G | 0.60 | .298M | 0M | 0.65 | 0M | 0.00 | |
Control File | 1013M | 4.94 | .28M | 21M | 0.37 | .006M | 0.23 | 2.55 |
Other | 766M | 2.02 | .212M | 9M | 0.10 | .002M | 0.40 | 0.14 |
Log File | 0M | 0.00 | 0M | 196M | 4.24 | .054M | ||
Temp File | 5M | 0.13 | .001M | 5M | 0.10 | .001M | 0.12 | 0.00 |
TOTAL: | 5.9G | 114.07 | 1.663M | 416M | 9.53 | .115M | 0.99 | 0.67 |
Back to IO Stats
Back to Top
IOStat by Function/Filetype summary
- 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
- Ordered by (Data Read + Write) desc for each function
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 | 3.1G | 106.48 | .873M | 0M | 0.00 | 0M | 359K | 1.35 |
Buffer Cache Reads (Data File) | 3.1G | 106.48 | .873M | 0M | 0.00 | 0M | 359K | 1.35 |
Others | 2G | 5.56 | .579M | 21M | 1.07 | .006M | 17.9K | 0.61 |
Others (External Table) | 1.1G | 0.60 | .298M | 0M | 0.65 | 0M | 0 | |
Others (Control File) | 1014M | 4.94 | .281M | 20M | 0.37 | .006M | 17.9K | 0.58 |
Others (Data File) | 1M | 0.02 | 0M | 1M | 0.04 | 0M | 63 | 9.12 |
LGWR | 0M | 0.00 | 0M | 197M | 4.24 | .055M | 0 | |
LGWR (Log File) | 0M | 0.00 | 0M | 197M | 4.24 | .055M | 0 | |
DBWR | 0M | 0.00 | 0M | 186M | 4.10 | .051M | 1 | 0.00 |
DBWR (Data File) | 0M | 0.00 | 0M | 186M | 4.10 | .051M | 1 | 0.00 |
Direct Writes | 0M | 0.00 | 0M | 2M | 0.02 | .001M | 10 | 0.00 |
Direct Writes (Data File) | 0M | 0.00 | 0M | 2M | 0.02 | .001M | 10 | 0.00 |
Direct Reads | 2M | 0.01 | .001M | 0M | 0.00 | 0M | 0 | |
Direct Reads (Data File) | 2M | 0.01 | .001M | 0M | 0.00 | 0M | 0 | |
TOTAL: | 5.1G | 112.04 | 1.453M | 406M | 9.44 | .112M | 376.9K | 1.32 |
Back to IO Stats
Back to Top
Tablespace IO Stats
- ordered by IOs (Reads + Writes) desc
Tablespace | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | % Opt Reads | Writes | Writes avg/s | Av Writes(ms) | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
APPS_TS_TX_DATA | 241,852 | 67 | 1.07 | 1.08 | 66 | 1.04 | 0.00 | 6,084 | 2 | 6.88 | 3 | 3.33 |
APPS_TS_TX_IDX | 91,790 | 25 | 2.05 | 1.00 | 25 | 2.05 | 0.00 | 6,471 | 2 | 4.91 | 5 | 0.00 |
APPS_TS_SUMMARY | 11,927 | 3 | 1.35 | 1.00 | 3 | 1.35 | 0.00 | 198 | 0 | 2.98 | 0 | 0.00 |
APPS_TS_SEED | 11,671 | 3 | 1.17 | 1.00 | 3 | 1.17 | 0.00 | 9 | 0 | 1.11 | 0 | 0.00 |
APPS_TS_INTERFACE | 8,539 | 2 | 1.39 | 1.00 | 2 | 1.39 | 0.00 | 11 | 0 | 0.91 | 0 | 0.00 |
APPS_TS_ARCHIVE | 6,979 | 2 | 1.10 | 1.00 | 2 | 1.10 | 0.00 | 112 | 0 | 1.16 | 0 | 0.00 |
SYSAUX | 4,171 | 1 | 1.66 | 1.00 | 1 | 1.66 | 0.00 | 940 | 0 | 5.91 | 1 | 0.00 |
PORTAL | 2,146 | 1 | 0.72 | 1.00 | 1 | 0.72 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
APPS_TS_MEDIA | 1,742 | 0 | 8.25 | 1.00 | 0 | 8.24 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
RAPPORT | 1,236 | 0 | 1.96 | 1.00 | 0 | 1.95 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
APPS_TS_QUEUES | 918 | 0 | 0.99 | 1.00 | 0 | 0.99 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
TEMP | 462 | 0 | 0.35 | 1.45 | 0 | 0.36 | 356 | 0 | 0.90 | 0 | 0.00 | |
UNDOTBS1 | 1 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 588 | 0 | 2.21 | 4 | 0.00 |
APPS_TS_NOLOGGING | 564 | 0 | 2.71 | 1.00 | 0 | 2.71 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
APPLSYSD | 432 | 0 | 0.81 | 1.00 | 0 | 0.81 | 0.00 | 8 | 0 | 0.00 | 0 | 0.00 |
SYSTEM | 8 | 0 | 8.75 | 1.00 | 0 | 10.00 | 0.00 | 283 | 0 | 1.48 | 3 | 3.33 |
CTXD | 208 | 0 | 1.15 | 1.00 | 0 | 1.11 | 0.00 | 0 | 0 | 0.00 | 0 | 0.00 |
Back to IO Stats
Back to Top
File IO Stats
- ordered by Tablespace, File
Tablespace | Filename | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | % Opt Reads | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
APPLSYSD | +DATA/oaprd/datafile/applsysd.306.866238421 | 432 | 0 | 0.81 | 1.00 | 0 | 0.81 | 0.00 | 8 | 0 | 0 | 0.00 |
APPS_TS_ARCHIVE | +DATA/oaprd/datafile/apps_ts_archive.302.866237193 | 6,979 | 2 | 1.10 | 1.00 | 2 | 1.10 | 0.00 | 112 | 0 | 0 | 0.00 |
APPS_TS_INTERFACE | +DATA/OAPRD/DATAFILE/apps_ts_interface.830.916925103 | 11 | 0 | 7.27 | 1.00 | 0 | 8.18 | 0.00 | 3 | 0 | 0 | 0.00 |
APPS_TS_INTERFACE | +DATA/oaprd/datafile/apps_ts_interface.297.866234943 | 8,528 | 2 | 1.39 | 1.00 | 2 | 1.38 | 0.00 | 8 | 0 | 0 | 0.00 |
APPS_TS_MEDIA | +DATA/OAPRD/DATAFILE/apps_ts_media.522.930526411 | 402 | 0 | 8.88 | 1.00 | 0 | 8.86 | 0.00 | 0 | 0 | 0 | 0.00 |
APPS_TS_MEDIA | +DATA/oaprd/datafile/apps_ts_media.294.866234941 | 1,340 | 0 | 8.06 | 1.00 | 0 | 8.06 | 0.00 | 0 | 0 | 0 | 0.00 |
APPS_TS_NOLOGGING | +DATA/oaprd/datafile/apps_ts_nologging.307.866238433 | 564 | 0 | 2.71 | 1.00 | 0 | 2.71 | 0.00 | 0 | 0 | 0 | 0.00 |
APPS_TS_QUEUES | +DATA/oaprd/datafile/apps_ts_queues.313.866238679 | 918 | 0 | 0.99 | 1.00 | 0 | 0.99 | 0.00 | 0 | 0 | 0 | 0.00 |
APPS_TS_SEED | +DATA/oaprd/datafile/apps_ts_seed.305.866238373 | 11,671 | 3 | 1.17 | 1.00 | 3 | 1.17 | 0.00 | 9 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/OAPRD/DATAFILE/apps_ts_summary.1078.960278519 | 343 | 0 | 1.46 | 1.00 | 0 | 1.43 | 0.00 | 20 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/OAPRD/DATAFILE/apps_ts_summary.574.995369723 | 140 | 0 | 1.64 | 1.00 | 0 | 1.64 | 0.00 | 28 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/OAPRD/DATAFILE/apps_ts_summary.599.882489013 | 433 | 0 | 1.18 | 1.00 | 0 | 1.15 | 0.00 | 25 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/OAPRD/DATAFILE/apps_ts_summary.664.931179129 | 451 | 0 | 1.40 | 1.00 | 0 | 1.40 | 0.00 | 24 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/oaprd/datafile/apps_ts_summary.280.866234937 | 82 | 0 | 7.07 | 1.00 | 0 | 7.20 | 0.00 | 20 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/oaprd/datafile/apps_ts_summary.290.866234941 | 425 | 0 | 2.56 | 1.00 | 0 | 2.59 | 0.00 | 26 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/oaprd/datafile/apps_ts_summary.298.866234943 | 9,018 | 2 | 1.25 | 1.00 | 2 | 1.25 | 0.00 | 28 | 0 | 0 | 0.00 |
APPS_TS_SUMMARY | +DATA/oaprd/datafile/apps_ts_summary.299.866234943 | 1,035 | 0 | 1.28 | 1.00 | 0 | 1.27 | 0.00 | 27 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.1023.995369557 | 10,029 | 3 | 1.26 | 1.01 | 3 | 1.26 | 0.00 | 283 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.1034.882488929 | 51,891 | 14 | 0.85 | 1.01 | 14 | 0.84 | 0.00 | 88 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.1138.886172551 | 2,986 | 1 | 1.47 | 1.05 | 1 | 1.42 | 0.00 | 32 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.391.886172489 | 717 | 0 | 2.37 | 1.22 | 0 | 2.19 | 0.00 | 32 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.440.957284541 | 10,333 | 3 | 1.07 | 1.01 | 3 | 1.07 | 0.00 | 326 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.482.993294221 | 10,167 | 3 | 0.99 | 1.01 | 3 | 0.99 | 0.00 | 290 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.593.995297023 | 10,166 | 3 | 1.01 | 1.01 | 3 | 1.00 | 0.00 | 282 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.606.938169177 | 10,226 | 3 | 1.15 | 1.02 | 3 | 1.14 | 0.00 | 262 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.658.885379391 | 780 | 0 | 2.24 | 1.17 | 0 | 2.11 | 0.00 | 26 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/OAPRD/DATAFILE/apps_ts_tx_data.728.996484651 | 6,284 | 2 | 1.04 | 1.01 | 2 | 1.04 | 0.00 | 1 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.278.866234937 | 20,058 | 6 | 1.52 | 1.22 | 5 | 1.46 | 0.00 | 1,176 | 0 | 2 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.281.866234939 | 4,987 | 1 | 2.37 | 3.30 | 1 | 1.97 | 0.00 | 2,897 | 1 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.283.866234939 | 3,795 | 1 | 1.85 | 1.05 | 1 | 1.84 | 0.00 | 65 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.284.866234939 | 2,462 | 1 | 1.51 | 1.10 | 1 | 1.50 | 0.00 | 161 | 0 | 1 | 10.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.286.866234939 | 1,728 | 0 | 2.67 | 1.07 | 0 | 2.65 | 0.00 | 71 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.288.866234941 | 2,479 | 1 | 2.83 | 1.02 | 1 | 2.82 | 0.00 | 25 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.292.866234941 | 454 | 0 | 6.23 | 1.38 | 0 | 5.99 | 0.00 | 15 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.303.866237849 | 24,804 | 7 | 0.86 | 1.01 | 7 | 0.86 | 0.00 | 16 | 0 | 0 | 0.00 |
APPS_TS_TX_DATA | +DATA/oaprd/datafile/apps_ts_tx_data.753.870080285 | 67,506 | 19 | 0.81 | 1.01 | 19 | 0.81 | 0.00 | 36 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/OAPRD/DATAFILE/apps_ts_tx_idx.1191.993294417 | 12,733 | 4 | 1.80 | 1.00 | 4 | 1.80 | 0.00 | 580 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/OAPRD/DATAFILE/apps_ts_tx_idx.450.910863045 | 846 | 0 | 5.91 | 1.16 | 0 | 5.82 | 0.00 | 188 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/OAPRD/DATAFILE/apps_ts_tx_idx.491.957284473 | 11,769 | 3 | 2.00 | 1.00 | 3 | 2.00 | 0.00 | 346 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/OAPRD/DATAFILE/apps_ts_tx_idx.784.995369661 | 12,189 | 3 | 1.85 | 1.00 | 3 | 1.85 | 0.00 | 631 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/OAPRD/DATAFILE/apps_ts_tx_idx.866.882488869 | 763 | 0 | 5.58 | 1.15 | 0 | 5.60 | 0.00 | 124 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.282.866234939 | 42,940 | 12 | 1.40 | 1.00 | 12 | 1.40 | 0.00 | 1,073 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.285.866234939 | 2,311 | 1 | 4.59 | 1.00 | 1 | 4.59 | 0.00 | 22 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.287.866234941 | 3,239 | 1 | 2.29 | 1.00 | 1 | 2.29 | 0.00 | 199 | 0 | 5 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.289.866234941 | 3,152 | 1 | 6.42 | 1.00 | 1 | 6.42 | 0.00 | 3,069 | 1 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.291.866234941 | 1,410 | 0 | 5.53 | 1.00 | 0 | 5.54 | 0.00 | 139 | 0 | 0 | 0.00 |
APPS_TS_TX_IDX | +DATA/oaprd/datafile/apps_ts_tx_idx.304.866238221 | 438 | 0 | 9.11 | 1.03 | 0 | 9.11 | 0.00 | 100 | 0 | 0 | 0.00 |
CTXD | +DATA/oaprd/datafile/ctxd.310.866238477 | 208 | 0 | 1.15 | 1.00 | 0 | 1.11 | 0.00 | 0 | 0 | 0 | 0.00 |
PORTAL | +DATA/oaprd/datafile/portal.308.866238451 | 2,146 | 1 | 0.72 | 1.00 | 1 | 0.72 | 0.00 | 0 | 0 | 0 | 0.00 |
RAPPORT | +DATA/OAPRD/DATAFILE/rapport.814.920294171 | 8 | 0 | 8.75 | 1.00 | 0 | 7.50 | 0.00 | 0 | 0 | 0 | 0.00 |
RAPPORT | +DATA/oaprd/datafile/rapport.279.866234937 | 1,008 | 0 | 1.71 | 1.00 | 0 | 1.72 | 0.00 | 0 | 0 | 0 | 0.00 |
RAPPORT | +DATA/oaprd/datafile/rapport.295.866234941 | 220 | 0 | 2.86 | 1.00 | 0 | 2.82 | 0.00 | 0 | 0 | 0 | 0.00 |
SYSAUX | +DATA/oaprd/datafile/sysaux.301.866234943 | 4,171 | 1 | 1.66 | 1.00 | 1 | 1.66 | 0.00 | 940 | 0 | 1 | 0.00 |
SYSTEM | +DATA/OAPRD/DATAFILE/system.1144.877627869 | 0 | 0 | 0 | 50 | 0 | 0 | 0.00 | ||||
SYSTEM | +DATA/oaprd/datafile/system.300.866234943 | 8 | 0 | 8.75 | 1.00 | 0 | 10.00 | 0.00 | 233 | 0 | 3 | 3.33 |
TEMP | +DATA/OAPRD/TEMPFILE/temp.587.974280559 | 151 | 0 | 0.60 | 1.19 | 0 | 0.59 | 112 | 0 | 0 | ||
TEMP | +DATA/oaprd/tempfile/temp.348.866241131 | 186 | 0 | 0.22 | 1.44 | 0 | 0.24 | 143 | 0 | 0 | ||
TEMP | +DATA/oaprd/tempfile/temp.349.866241131 | 125 | 0 | 0.24 | 1.80 | 0 | 0.27 | 101 | 0 | 0 | ||
UNDOTBS1 | +DATA/oaprd/datafile/undotbs1.293.866234941 | 1 | 0 | 0.00 | 1.00 | 0 | 0.00 | 0.00 | 588 | 0 | 4 | 0.00 |
Back to IO Stats
Back to Top
Buffer Pool Statistics
Back to TopBuffer Pool Statistics
- Standard block size Pools D: default, K: keep, R: recycle
- Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 13,821,066 | 100 | 2,457,164,157 | 403,572 | 23,704 | 0 | 0 | 16 |
K | 60,354 | 0 | 0 | 0 | 0 | 0 | 0 |
Back to Buffer Pool Statistics
Back to Top
Checkpoint Activity
- Total Physical Writes: 24,134
MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 20,598 | 0 |
Back to Buffer Pool Statistics
Back to Top
Advisory Statistics
- Instance Recovery Stats
- MTTR Advisory
- Buffer Pool Advisory
- PGA Aggr Summary
- PGA Aggr Target Stats
- PGA Aggr Target Histogram
- PGA Memory Advisory
- Shared Pool Advisory
- SGA Target Advisory
- Streams Pool Advisory
- Java Pool Advisory
Instance Recovery Stats
- B: Begin Snapshot, E: End Snapshot
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 | 32 | 0 | 636 | 5335 | 40450 | 2322432 | 40450 | 43102 | 0 | |
E | 43 | 0 | 1327 | 10804 | 27027 | 2322432 | 27027 | 31484 | 0 |
Back to Advisory Statistics
Back to Top
MTTR Advisory
- Only rows at end snap are displayed
- Estimated Writes and I/Os are in thousands
Size for Est (s) | Dirty Limit | Est Cache Writes | Est Cache Write Fctr | Est Total Writes | Est Total Write Fctr | Est Total IOs | Est Total IO Fctr |
---|---|---|---|---|---|---|---|
3 | 5,567 | 234,822 | 1.52 | 620,227 | 1.15 | ||
10 | 45,001 | 170,539 | 1.11 | 555,944 | 1.03 | ||
19 | 85,503 | 159,344 | 1.03 | 544,749 | 1.01 | ||
27 | 121,504 | 155,629 | 1.01 | 541,034 | 1.00 | ||
36 | 163,526 | 154,082 | 1.00 | 539,487 | 1.00 |
Back to Advisory Statistics
Back to Top
Buffer Pool Advisory
- Only rows with estimated physical reads >0 are displayed
- ordered by Block Size, Buffers For Estimate
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 | 11,264 | 0.10 | 1,328 | 2.67 | 7,971,227 | 1 | 8892228.00 |
D | 22,528 | 0.19 | 2,656 | 1.70 | 5,062,152 | 1 | 4860282.00 |
D | 33,792 | 0.29 | 3,983 | 1.38 | 4,133,617 | 1 | 3573342.00 |
D | 45,056 | 0.38 | 5,311 | 1.28 | 3,814,609 | 1 | 3131201.00 |
D | 56,320 | 0.48 | 6,639 | 1.19 | 3,547,313 | 1 | 2760731.00 |
D | 67,584 | 0.58 | 7,967 | 1.12 | 3,336,439 | 1 | 2468461.00 |
D | 78,848 | 0.67 | 9,295 | 1.08 | 3,232,520 | 1 | 2324432.00 |
D | 90,112 | 0.77 | 10,622 | 1.06 | 3,170,654 | 1 | 2238686.00 |
D | 101,376 | 0.86 | 11,950 | 1.04 | 3,102,791 | 1 | 2144629.00 |
D | 112,640 | 0.96 | 13,278 | 1.01 | 3,019,736 | 1 | 2029516.00 |
D | 117,248 | 1.00 | 13,821 | 1.00 | 2,985,434 | 1 | 1981973.00 |
D | 123,904 | 1.06 | 14,606 | 0.98 | 2,935,985 | 1 | 1913438.00 |
D | 135,168 | 1.15 | 15,933 | 0.95 | 2,840,374 | 1 | 1780921.00 |
D | 146,432 | 1.25 | 17,261 | 0.92 | 2,732,460 | 1 | 1631354.00 |
D | 157,696 | 1.35 | 18,589 | 0.88 | 2,619,016 | 1 | 1474122.00 |
D | 168,960 | 1.44 | 19,917 | 0.84 | 2,499,211 | 1 | 1308073.00 |
D | 180,224 | 1.54 | 21,245 | 0.80 | 2,381,195 | 1 | 1144504.00 |
D | 191,488 | 1.63 | 22,572 | 0.76 | 2,261,632 | 1 | 978790.00 |
D | 202,752 | 1.73 | 23,900 | 0.72 | 2,149,936 | 1 | 823982.00 |
D | 214,016 | 1.83 | 25,228 | 0.67 | 2,004,479 | 1 | 622380.00 |
D | 225,280 | 1.92 | 26,556 | 0.60 | 1,790,013 | 1 | 409322.00 |
Back to Advisory Statistics
Back to Top
PGA Aggr Summary
- PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
99.95 | 4,985 | 3 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Stats
- B: Begin Snap E: End Snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
- Auto PGA Target - actual workarea memory target
- W/A PGA Used - amount of memory used for all Workareas (manual + auto)
- %PGA W/A Mem - percentage of PGA memory allocated to workareas
- %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
- %Man W/A Mem - percentage of workarea memory under manual control
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 | 10,240 | 7,423 | 2,557.11 | 105.92 | 4.14 | 100.00 | 0.00 | 1,048,570 |
E | 10,240 | 7,411 | 2,608.60 | 110.59 | 4.24 | 100.00 | 0.00 | 1,048,570 |
Back to Advisory Statistics
Back to Top
PGA Aggr Target Histogram
- Optimal Executions are purely in-memory operations
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 24,422 | 24,422 | 0 | 0 |
64K | 128K | 45 | 45 | 0 | 0 |
128K | 256K | 213 | 213 | 0 | 0 |
256K | 512K | 81 | 81 | 0 | 0 |
512K | 1024K | 1,794 | 1,790 | 4 | 0 |
1M | 2M | 1,938 | 1,938 | 0 | 0 |
2M | 4M | 165 | 165 | 0 | 0 |
4M | 8M | 41 | 41 | 0 | 0 |
8M | 16M | 18 | 18 | 0 | 0 |
16M | 32M | 1 | 1 | 0 | 0 |
32M | 64M | 2 | 2 | 0 | 0 |
Back to Advisory Statistics
Back to Top
PGA Memory Advisory
- When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 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 |
---|---|---|---|---|---|---|
1,280 | 0.13 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
2,560 | 0.25 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
5,120 | 0.50 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
7,680 | 0.75 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
10,240 | 1.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
12,288 | 1.20 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
14,336 | 1.40 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
16,384 | 1.60 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
18,432 | 1.80 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
20,480 | 2.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
30,720 | 3.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
40,960 | 4.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
61,440 | 6.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
81,920 | 8.00 | 16,340,458.92 | 0.00 | 100.00 | 0 | 3,147,087,305 |
Back to Advisory Statistics
Back to Top
Shared Pool Advisory
- SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
- Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.
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) |
---|---|---|---|---|---|---|---|---|
27,648 | 0.69 | 2,818 | 145,893 | 372,991,140 | 0.76 | 117,908,584 | 448.18 | 1,578,979 |
31,744 | 0.79 | 6,914 | 222,913 | 414,249,770 | 0.84 | 76,649,954 | 291.35 | 2,356,401 |
34,816 | 0.87 | 9,986 | 257,303 | 445,613,397 | 0.91 | 45,286,327 | 172.14 | 2,942,814 |
35,328 | 0.88 | 10,497 | 263,034 | 450,837,214 | 0.92 | 40,062,510 | 152.28 | 3,040,551 |
35,840 | 0.90 | 11,008 | 268,765 | 456,068,220 | 0.93 | 34,831,504 | 132.40 | 3,138,277 |
36,352 | 0.91 | 11,519 | 274,496 | 461,291,622 | 0.94 | 29,608,102 | 112.54 | 3,236,010 |
36,864 | 0.92 | 12,030 | 280,227 | 466,522,459 | 0.95 | 24,377,265 | 92.66 | 3,333,732 |
37,376 | 0.94 | 12,541 | 285,958 | 471,747,173 | 0.96 | 19,152,551 | 72.80 | 3,432,377 |
37,888 | 0.95 | 13,052 | 291,689 | 476,888,950 | 0.97 | 14,010,774 | 53.26 | 3,531,673 |
38,400 | 0.96 | 13,563 | 297,420 | 481,285,699 | 0.98 | 9,614,025 | 36.54 | 3,616,414 |
38,912 | 0.97 | 14,074 | 303,151 | 485,667,373 | 0.99 | 5,232,351 | 19.89 | 3,701,608 |
39,424 | 0.99 | 14,585 | 308,882 | 489,530,902 | 1.00 | 1,368,822 | 5.20 | 3,783,934 |
39,936 | 1.00 | 15,096 | 314,613 | 490,636,640 | 1.00 | 263,084 | 1.00 | 3,821,982 |
40,448 | 1.01 | 15,607 | 320,344 | 490,638,110 | 1.00 | 261,614 | 0.99 | 3,821,997 |
40,960 | 1.03 | 16,118 | 326,075 | 490,638,210 | 1.00 | 261,514 | 0.99 | 3,822,005 |
41,472 | 1.04 | 16,629 | 331,806 | 490,638,297 | 1.00 | 261,427 | 0.99 | 3,822,012 |
41,984 | 1.05 | 17,140 | 337,537 | 490,638,448 | 1.00 | 261,276 | 0.99 | 3,822,020 |
42,496 | 1.06 | 17,651 | 343,268 | 490,638,540 | 1.00 | 261,184 | 0.99 | 3,822,028 |
43,008 | 1.08 | 18,162 | 348,999 | 490,638,639 | 1.00 | 261,085 | 0.99 | 3,822,036 |
43,520 | 1.09 | 18,673 | 354,730 | 490,638,782 | 1.00 | 260,942 | 0.99 | 3,822,044 |
44,032 | 1.10 | 19,184 | 360,461 | 490,638,902 | 1.00 | 260,822 | 0.99 | 3,822,053 |
44,544 | 1.12 | 19,695 | 366,192 | 490,639,164 | 1.00 | 260,560 | 0.99 | 3,822,065 |
48,128 | 1.21 | 23,278 | 406,314 | 490,642,456 | 1.00 | 257,268 | 0.98 | 3,822,176 |
52,224 | 1.31 | 27,373 | 452,168 | 490,646,013 | 1.00 | 253,711 | 0.96 | 3,822,300 |
56,320 | 1.41 | 31,469 | 519,516 | 490,647,348 | 1.00 | 252,376 | 0.96 | 3,822,388 |
60,416 | 1.51 | 35,565 | 580,081 | 490,648,573 | 1.00 | 251,151 | 0.95 | 3,822,475 |
64,512 | 1.62 | 39,661 | 640,646 | 490,650,075 | 1.00 | 249,649 | 0.95 | 3,822,561 |
68,608 | 1.72 | 43,757 | 701,211 | 490,651,308 | 1.00 | 248,416 | 0.94 | 3,822,643 |
72,704 | 1.82 | 47,853 | 761,776 | 490,652,529 | 1.00 | 247,195 | 0.94 | 3,822,725 |
76,800 | 1.92 | 51,949 | 822,341 | 490,653,897 | 1.00 | 245,827 | 0.93 | 3,822,802 |
80,896 | 2.03 | 56,045 | 882,906 | 490,655,277 | 1.00 | 244,447 | 0.93 | 3,822,876 |
Back to Advisory Statistics
Back to Top
SGA Target Advisory
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
51,200 | 0.31 | 33,811,757 | 8,105,451,876 |
61,440 | 0.38 | 14,744,896 | 8,105,451,876 |
71,680 | 0.44 | 10,675,532 | 5,147,484,392 |
81,920 | 0.50 | 9,376,324 | 4,203,191,785 |
92,160 | 0.56 | 8,930,419 | 3,878,973,710 |
102,400 | 0.63 | 8,556,137 | 3,607,000,721 |
112,640 | 0.69 | 8,261,177 | 3,392,646,598 |
122,880 | 0.75 | 8,115,623 | 3,286,962,253 |
133,120 | 0.81 | 8,029,368 | 3,223,969,606 |
143,360 | 0.88 | 7,934,642 | 3,155,006,093 |
153,600 | 0.94 | 7,772,915 | 3,035,588,754 |
163,840 | 1.00 | 7,701,293 | 2,985,433,472 |
174,080 | 1.06 | 7,567,291 | 2,888,108,341 |
184,320 | 1.13 | 7,417,115 | 2,778,542,932 |
194,560 | 1.19 | 7,258,469 | 2,663,006,657 |
204,800 | 1.25 | 7,090,580 | 2,541,200,971 |
215,040 | 1.31 | 6,925,773 | 2,421,186,546 |
225,280 | 1.38 | 6,758,655 | 2,299,679,403 |
235,520 | 1.44 | 6,602,318 | 2,186,232,932 |
245,760 | 1.50 | 6,399,004 | 2,038,155,431 |
256,000 | 1.56 | 6,184,138 | 1,820,218,788 |
266,240 | 1.63 | 6,179,518 | 1,820,218,788 |
276,480 | 1.69 | 6,173,356 | 1,820,218,788 |
286,720 | 1.75 | 6,171,046 | 1,820,218,788 |
296,960 | 1.81 | 6,166,425 | 1,820,218,788 |
307,200 | 1.88 | 6,166,425 | 1,820,218,788 |
317,440 | 1.94 | 6,166,425 | 1,820,218,788 |
327,680 | 2.00 | 6,166,425 | 1,820,218,788 |
Back to Advisory Statistics
Back to Top
Streams Pool Advisory
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
512 | 0.50 | 0 | 0 | 0 | 0 |
1,024 | 1.00 | 0 | 0 | 0 | 0 |
1,536 | 1.50 | 0 | 0 | 0 | 0 |
2,048 | 2.00 | 0 | 0 | 0 | 0 |
2,560 | 2.50 | 0 | 0 | 0 | 0 |
3,072 | 3.00 | 0 | 0 | 0 | 0 |
3,584 | 3.50 | 0 | 0 | 0 | 0 |
4,096 | 4.00 | 0 | 0 | 0 | 0 |
4,608 | 4.50 | 0 | 0 | 0 | 0 |
5,120 | 5.00 | 0 | 0 | 0 | 0 |
5,632 | 5.50 | 0 | 0 | 0 | 0 |
6,144 | 6.00 | 0 | 0 | 0 | 0 |
6,656 | 6.50 | 0 | 0 | 0 | 0 |
7,168 | 7.00 | 0 | 0 | 0 | 0 |
7,680 | 7.50 | 0 | 0 | 0 | 0 |
8,192 | 8.00 | 0 | 0 | 0 | 0 |
8,704 | 8.50 | 0 | 0 | 0 | 0 |
9,216 | 9.00 | 0 | 0 | 0 | 0 |
9,728 | 9.50 | 0 | 0 | 0 | 0 |
10,240 | 10.00 | 0 | 0 | 0 | 0 |
Back to Advisory Statistics
Back to Top
Java Pool Advisory
Java Pool Size(M) | JP 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 |
---|---|---|---|---|---|---|---|---|
512 | 0.14 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
1,024 | 0.29 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
1,536 | 0.43 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
2,048 | 0.57 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
2,560 | 0.71 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
3,072 | 0.86 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,492,566 |
3,584 | 1.00 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,375 |
4,096 | 1.14 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
4,608 | 1.29 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
5,120 | 1.43 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
5,632 | 1.57 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
6,144 | 1.71 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
6,656 | 1.86 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
7,168 | 2.00 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
7,680 | 2.14 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
8,192 | 2.29 | 56 | 986 | 314,605 | 1.00 | 263,084 | 1.00 | 37,558,453 |
Back to Advisory Statistics
Back to Top
Wait Statistics
Back to TopBuffer Wait Statistics
- ordered by wait time desc, waits desc
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 11 | 0 | 2 |
undo header | 3 | 0 | 0 |
free list | 1 | 0 | 0 |
undo block | 1 | 0 | 0 |
Back to Wait Statistics
Back to Top
Enqueue Activity
- only enqueues with requests are shown
- Enqueue stats gathered prior to 10g should not be compared with 10g data
- ordered by Wait Time desc, Waits desc, Requests desc
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
PS-PX Process Reservation | 32,783 | 32,775 | 8 | 6,733 | 5 | 0.72 |
XR-Quiesce / Force Logging (database force logging) | 1,203 | 1,203 | 0 | 1,203 | 1 | 1.24 |
CO-KTUCLO Master Slave enq (master slave det) | 1,200 | 0 | 1,200 | 1,200 | 1 | 0.90 |
TM-DML | 47,823 | 47,823 | 0 | 12 | 0 | 20.00 |
TT-Tablespace | 1,164 | 1,164 | 0 | 307 | 0 | 0.52 |
TO-Temp Object | 598 | 598 | 0 | 202 | 0 | 0.40 |
RO-Multiple Object Reuse (fast object reuse) | 1,090 | 1,090 | 0 | 305 | 0 | 0.20 |
US-Undo Segment | 180 | 180 | 0 | 107 | 0 | 0.19 |
KM-Scheduler | 313 | 313 | 0 | 90 | 0 | 0.22 |
FB-Format Block | 58 | 58 | 0 | 22 | 0 | 0.91 |
CF-Controlfile Transaction | 6,839 | 6,839 | 0 | 31 | 0 | 0.32 |
JS-Job Scheduler (job run lock - synchronize) | 18 | 18 | 0 | 18 | 0 | 0.56 |
DW-In memory Dispenser | 245 | 87 | 158 | 7 | 0 | 1.43 |
AE-Edition Lock (lock) | 1,211 | 1,211 | 0 | 21 | 0 | 0.00 |
WF-AWR Flush | 36 | 36 | 0 | 20 | 0 | 0.00 |
TA-Instance Undo | 13 | 13 | 0 | 12 | 0 | 0.00 |
WT-AWR CDB-Wide Table Lock | 34 | 34 | 0 | 8 | 0 | 0.00 |
TD-KTF map table enqueue (KTF dump entries) | 8 | 8 | 0 | 8 | 0 | 0.00 |
HW-Segment High Water Mark | 1,435 | 1,435 | 0 | 7 | 0 | 0.00 |
DV-Diana Versioning | 32 | 32 | 0 | 4 | 0 | 0.00 |
ZZ-Global Context Action (update hash tables) | 9 | 9 | 0 | 4 | 0 | 0.00 |
TQ-Queue table enqueue (TM contention) | 27 | 27 | 0 | 2 | 0 | 0.00 |
AF-Advisor Framework (task serialization) | 13 | 13 | 0 | 2 | 0 | 0.00 |
CR-Reuse Block Range (block range reuse ckpt) | 12 | 12 | 0 | 2 | 0 | 0.00 |
DR-Distributed Recovery | 2 | 2 | 0 | 2 | 0 | 0.00 |
MW-MWIN Schedule | 2 | 2 | 0 | 2 | 0 | 0.00 |
TS-Temporary Segment | 2 | 2 | 0 | 2 | 0 | 0.00 |
TX-Transaction | 8,189 | 8,188 | 0 | 1 | 0 | 0.00 |
UL-User-defined | 1,479 | 144 | 1,335 | 1 | 0 | 0.00 |
DL-Direct Loader Index Creation | 2 | 2 | 0 | 1 | 0 | 0.00 |
FH-Flush Stat | 1 | 1 | 0 | 1 | 0 | 0.00 |
TX-Transaction (index contention) | 1 | 1 | 0 | 1 | 0 | 0.00 |
JS-Job Scheduler | 20,657 | 20,657 | 0 | 0 | 0 | |
JS-Job Scheduler (queue lock) | 20,657 | 20,657 | 0 | 0 | 0 | |
SE-Session Migration | 7,011 | 7,011 | 0 | 0 | 0 | |
JS-Job Scheduler (q mem clnup lck) | 1,960 | 1,960 | 0 | 0 | 0 | |
DD-ASM Local Disk Group | 1,203 | 1,203 | 0 | 0 | 0 | |
MR-Media Recovery | 1,022 | 1,022 | 0 | 0 | 0 | |
TQ-Queue table enqueue (INI contention) | 621 | 621 | 0 | 0 | 0 | |
SR-Synchronized Replication | 452 | 452 | 0 | 0 | 0 | |
SJ-KTSJ Slave Task Cancel (Slave Task Cancel) | 410 | 410 | 0 | 0 | 0 | |
PR-Process Startup | 198 | 198 | 0 | 0 | 0 | |
PV-KSV slave startup (syncstart) | 167 | 167 | 0 | 0 | 0 | |
CU-Cursor | 149 | 149 | 0 | 0 | 0 | |
RC-Result Cache: Enqueue (Result Cache: Contention) | 126 | 126 | 0 | 0 | 0 | |
JD-Job Queue Date | 120 | 120 | 0 | 0 | 0 | |
IS-Instance State | 109 | 109 | 0 | 0 | 0 | |
TH-Threshold Chain (metric threshold evaluation) | 60 | 60 | 0 | 0 | 0 | |
SQ-Sequence Cache | 20 | 20 | 0 | 0 | 0 | |
TQ-Queue table enqueue (DDL contention) | 12 | 12 | 0 | 0 | 0 | |
PW-Buffer Cache PreWarm (flush prewarm buffers) | 2 | 0 | 2 | 0 | 0 | |
SH-Active Session History Flushing | 2 | 2 | 0 | 0 | 0 | |
TX-Transaction (row lock contention) | 2 | 0 | 2 | 0 | 0 |
Back to Wait Statistics
Back to Top
Undo Statistics
Back to TopUndo Segment Summary
- Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
- STO - Snapshot Too Old count, OOS - Out of Space count
- Undo segment block stats:
- uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
- eS - expired Stolen, eR - expired Released, eU - expired reUsed
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 |
---|---|---|---|---|---|---|---|
23 | 3.95 | 7,935 | 1,198 | 7 | 14225.7/14269.3 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Undo Segment Stats
- Most recent 35 Undostat rows, ordered by Time desc
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-Sep 19:57 | 72 | 1,090 | 600 | 5 | 14,269 | 0/0 | 0/0/0/0/0/0 |
07-Sep 19:47 | 419 | 976 | 1,198 | 5 | 14,265 | 0/0 | 0/0/0/0/0/0 |
07-Sep 19:37 | 62 | 922 | 595 | 6 | 14,269 | 0/0 | 0/0/0/0/0/0 |
07-Sep 19:27 | 62 | 962 | 152 | 4 | 14,267 | 0/0 | 0/0/0/0/0/0 |
07-Sep 19:17 | 60 | 939 | 1,192 | 4 | 14,267 | 0/0 | 0/0/0/0/0/0 |
07-Sep 19:07 | 3,279 | 3,046 | 590 | 7 | 14,226 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Latch Statistics
- Latch Activity
- Latch Sleep Breakdown
- Latch Miss Sources
- Mutex Sleep Summary
- Parent Latch Statistics
- Child Latch Statistics
Latch Activity
- "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
- "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
- "Pct Misses" for both should be very close to 0.0
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
AQ Background: interrupt command latch | 1 | 0.00 | 0 | 1,823 | 0.00 | |
AQ Coord jobx_kwsbgsgn latch | 120 | 0.00 | 0 | 0 | ||
AQ Sharded master pool latch | 124 | 0.00 | 0 | 0 | ||
AQ Slave freSlvL_kwsbgsgn latch | 6 | 0.00 | 0 | 0 | ||
AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
AQ deq log cmt cbk chunk latch | 4 | 0.00 | 0 | 0 | ||
AQ deq log statistics latch | 1 | 0.00 | 0 | 0 | ||
AQ dequeue txn counter latch | 17,488 | 0.06 | 0.00 | 0 | 0 | |
AQ ht cmt cbk chunk latch | 2 | 0.00 | 0 | 0 | ||
AQ process state object latch | 2 | 0.00 | 0 | 0 | ||
AQ: IPC master latch | 4 | 0.00 | 0 | 0 | ||
ASM Keyed state latch | 1,267 | 0.08 | 0.00 | 0 | 0 | |
ASM allocation | 205,166 | 0.00 | 0 | 0 | ||
ASM db client latch | 3,101 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 1,214 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 881,908 | 0.00 | 0.00 | 0 | 0 | |
ASM network background latch | 1,535 | 0.00 | 0 | 0 | ||
ASM network state latch | 189 | 0.00 | 0 | 0 | ||
ASM remote client latch | 57 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 41,693 | 0.00 | 0 | 0 | ||
Change Notification Hash table latch | 1,382 | 0.00 | 0 | 0 | ||
Consistent RBA | 7,417 | 0.00 | 0 | 0 | ||
DML lock allocation | 5,220,200 | 0.00 | 0.00 | 0 | 0 | |
Event Group Locks | 7,425 | 0.00 | 0 | 0 | ||
FAL Queue | 96 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 108 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 3,056 | 0.00 | 0 | 0 | ||
File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
Hang Manager wait event statistics | 237 | 0.00 | 0 | 2,721 | 0.00 | |
I/O Staticstics latch | 1 | 0.00 | 0 | 0 | ||
ILM Stats Stripe Latch | 1 | 0.00 | 0 | 0 | ||
ILM Stats main anchor latch | 7,042 | 0.00 | 0 | 0 | ||
ILM access tracking extent | 1 | 0.00 | 0 | 0 | ||
ILM activity tracking latch | 1 | 0.00 | 0 | 0 | ||
IM area sb latch | 1 | 0.00 | 0 | 0 | ||
IM area scb latch | 1 | 0.00 | 0 | 0 | ||
IM emb latch | 1 | 0.00 | 0 | 0 | ||
IM seg hdr latch | 1 | 0.00 | 0 | 0 | ||
IPC other latch | 30 | 0.00 | 0 | 0 | ||
IPC stats buffer allocation latch | 13,000 | 0.00 | 0 | 13,034 | 0.00 | |
In memory undo latch | 1 | 0.00 | 0 | 0 | ||
JOX SGA heap latch | 864 | 0.00 | 0 | 0 | ||
JS Sh mem access | 21 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 1,085 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 1,085 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 111 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 37 | 0.00 | 0 | 0 | ||
JS queue access latch | 38 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 41,314 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 54 | 0.00 | 0 | 0 | ||
KCNIBR - invalid block range tree | 1 | 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 | 846 | 0.00 | 0 | 0 | ||
KFMD SGA | 19 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SHM structure | 19 | 0.00 | 0 | 0 | ||
KGNFS-NFS:SVR LIST | 1,234 | 0.00 | 0 | 0 | ||
KJC message pool free list | 63,895 | 0.53 | 0.00 | 0 | 2,544 | 0.04 |
KJC message pool pending avail list | 1 | 0.00 | 0 | 0 | ||
KJCT flow control latch | 767,382 | 0.00 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 1,203 | 0.00 | 0 | 0 | ||
KSFS OFS ctx level parent latch | 1 | 0.00 | 0 | 0 | ||
KSFS OFS req layer parent latch | 1 | 0.00 | 0 | 0 | ||
KSFS OFS sess layer parent latch | 1 | 0.00 | 0 | 0 | ||
KSFS id table parent latch | 1 | 0.00 | 0 | 0 | ||
KSFS ksfs_node latch | 1 | 0.00 | 0 | 0 | ||
KSFSD name cache parent latch | 1 | 0.00 | 0 | 0 | ||
KSXR hang analysis phase 1 latch | 10,546 | 0.00 | 0 | 5 | 0.00 | |
KSXR hang analysis phase 2 latch | 3,405 | 0.00 | 0 | 0 | ||
KSXR large replies | 260 | 0.00 | 0 | 0 | ||
KTF sga latch | 26 | 0.00 | 0 | 998 | 0.00 | |
KTILM latch | 1 | 0.00 | 0 | 0 | ||
KWQMN job cache list latch | 2,244 | 11.63 | 0.06 | 0 | 0 | |
KWQP Prop Status | 452 | 0.00 | 0 | 0 | ||
KWQS pqsubs latch | 156 | 0.00 | 0 | 0 | ||
KWQS pqueue ctx latch | 55 | 0.00 | 0 | 0 | ||
Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
Lsod array latch | 994 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 72 | 0.00 | ||
Memory Management Latch | 1 | 0.00 | 0 | 1,203 | 0.00 | |
Memory Queue | 6 | 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 | ||
Message cache latch | 1 | 0.00 | 0 | 0 | ||
MinActiveScn Latch | 1,260 | 0.00 | 0 | 0 | ||
Mutex | 1 | 0.00 | 0 | 0 | ||
Mutex Stats | 1 | 0.00 | 0 | 0 | ||
ODM-NFS:Global file structure | 18 | 0.00 | 0 | 0 | ||
OS process | 3,524 | 0.00 | 0 | 0 | ||
OS process allocation | 9,237 | 0.02 | 0.00 | 0 | 0 | |
OS process: request allocation | 1,267 | 0.08 | 0.00 | 0 | 0 | |
PL/SQL warning settings | 21,409 | 0.00 | 0 | 0 | ||
PX hash array latch | 1 | 0.00 | 0 | 0 | ||
Parent latch for dependency tracking | 1 | 0.00 | 0 | 0 | ||
QMT | 1 | 0.00 | 0 | 0 | ||
Real-time descriptor latch | 217,876 | 0.00 | 0 | 0 | ||
Report Request stats latch | 265 | 0.00 | 0 | 0 | ||
Report Request struct latch | 60 | 0.00 | 0 | 0 | ||
Request holder compeltion list latch | 397 | 0.00 | 0 | 0 | ||
Result Cache: RC Latch | 541 | 0.00 | 0 | 0 | ||
Result Cache: SO Latch | 20 | 0.00 | 0 | 0 | ||
Retry Ht elm latch | 1 | 0.00 | 0 | 0 | ||
Retry bkt latch | 1 | 0.00 | 0 | 0 | ||
SGA Blackbox latch | 7 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 69 | 0.00 | 0 | 69 | 0.00 | |
SGA Logging Bkt Latch | 1 | 0.00 | 0 | 0 | ||
SGA Logging Log Latch | 65,611 | 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 | 1 | 0.00 | 0 | 1,203 | 0.00 | |
SQL memory manager workarea list latch | 160,828 | 0.00 | 0 | 0 | ||
SR Stats Stripe Latch | 1 | 0.00 | 0 | 0 | ||
SR Stats main anchor latch | 271,462 | 0.00 | 0 | 0 | ||
Sched IM Job latch | 58 | 0.00 | 0 | 0 | ||
Sched InMem Job Cache | 1,081 | 0.00 | 0 | 0 | ||
Shared B-Tree | 3,109 | 0.19 | 0.00 | 0 | 0 | |
Streams Generic | 1 | 0.00 | 0 | 0 | ||
Subscriber Ht elm latch | 1 | 0.00 | 0 | 0 | ||
Testing | 1 | 0.00 | 0 | 0 | ||
Token Manager | 1 | 0.00 | 0 | 0 | ||
Txn Ht elm latch | 1 | 0.00 | 0 | 0 | ||
Txn bkt latch | 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 | 6,236 | 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 | 9,303 | 1.28 | 0.00 | 0 | 0 | |
active service list | 72,475 | 0.00 | 0.00 | 0 | 25,443 | 0.00 |
archive destination | 250 | 0.00 | 0 | 0 | ||
archive process latch | 208 | 0.00 | 0 | 0 | ||
begin backup scn array | 28 | 0.00 | 0 | 0 | ||
bq:time manger info latch | 129 | 0.00 | 0 | 0 | ||
buffer pool | 1 | 0.00 | 0 | 0 | ||
bufq statistics | 5 | 0.00 | 0 | 0 | ||
business card | 8,885 | 0.00 | 0 | 0 | ||
cache buffer handles | 34,298 | 0.00 | 0 | 0 | ||
cache buffers chains | 4,798,279,329 | 0.01 | 0.00 | 0 | 479,420 | 0.01 |
cache buffers lru chain | 228,664 | 0.00 | 0.00 | 0 | 608,623 | 0.01 |
cache table scan latch | 2,411 | 0.00 | 0 | 2,411 | 0.00 | |
call allocation | 18,901 | 0.02 | 0.00 | 0 | 0 | |
cas latch | 1 | 0.00 | 0 | 0 | ||
change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
channel handle pool latch | 1,543 | 0.06 | 0.00 | 0 | 0 | |
channel operations parent latch | 71,832 | 0.05 | 0.00 | 0 | 5 | 0.00 |
checkpoint queue latch | 804,964 | 0.00 | 0.00 | 0 | 24,492 | 0.00 |
client/application info | 48,162 | 0.00 | 0 | 0 | ||
compile environment latch | 6,820 | 0.00 | 0 | 0 | ||
corrupted undo seg latch | 415 | 0.00 | 0 | 0 | ||
cp handoff 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 | 57 | 0.00 | 0 | 0 | ||
cp srv type state latch | 172 | 0.00 | 0 | 0 | ||
cp srv type wait latch | 1 | 0.00 | 0 | 0 | ||
cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
deferred cleanup latch | 57 | 0.00 | 0 | 0 | ||
dml lock allocation | 61 | 0.00 | 0 | 0 | ||
done queue latch | 1 | 0.00 | 0 | 0 | ||
dtp latch | 633 | 0.00 | 0 | 0 | ||
dummy allocation | 13,581 | 0.00 | 0 | 0 | ||
eighth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
eleventh spare latch - children | 1 | 0.00 | 0 | 0 | ||
enqueue freelist latch | 1 | 0.00 | 0 | 154,941 | 0.00 | |
enqueue hash chains | 458,689 | 0.05 | 0.00 | 0 | 6 | 0.00 |
enqueues | 3 | 0.00 | 0 | 0 | ||
error message lists | 22,198 | 0.00 | 0.00 | 0 | 0 | |
event stats latch | 6,790 | 0.00 | 0 | 0 | ||
fast space usage latch | 21 | 0.00 | 0 | 0 | ||
fifteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
file cache latch | 872 | 0.00 | 0 | 0 | ||
first Audit Vault latch | 434 | 0.00 | 0 | 0 | ||
flash file access latch | 1 | 0.00 | 0 | 0 | ||
flashback copy | 1 | 0.00 | 0 | 0 | ||
fourteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
fourth Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
gc element | 1,130,529 | 0.01 | 0.00 | 0 | 787 | 0.00 |
gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 5,139 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 5,466,554 | 0.00 | 0.00 | 0 | 269,608 | 0.00 |
gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
gcs remaster request queue | 789 | 0.00 | 0 | 0 | ||
gcs resource freelist | 7,181 | 0.00 | 0 | 0 | ||
gcs resource hash | 695,806 | 0.00 | 0.00 | 0 | 0 | |
gcs resource scan list | 1 | 0.00 | 0 | 0 | ||
gcs resource validate list | 1 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1,012 | 0.00 | 0 | 0 | ||
ges DFS wait callback info | 6 | 0.00 | 0 | 1 | 0.00 | |
ges cached resource lists | 564,400 | 0.06 | 0.01 | 0 | 583,892 | 0.10 |
ges deadlock list | 484,052 | 0.00 | 0.00 | 0 | 0 | |
ges domain table | 1,908,229 | 0.00 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 1,939,412 | 0.00 | 0.00 | 0 | 0 | |
ges group table | 1,961,955 | 0.00 | 0 | 0 | ||
ges process hash list | 3,773 | 0.00 | 0 | 0 | ||
ges process parent latch | 4,409,417 | 0.00 | 0.00 | 0 | 0 | |
ges process table freelist | 1,267 | 0.08 | 0.00 | 0 | 0 | |
ges resource hash list | 3,156,576 | 0.06 | 0.05 | 0 | 247,386 | 0.00 |
ges resource scan list | 553 | 0.00 | 0 | 0 | ||
ges resource table freelist | 706,651 | 0.03 | 0.01 | 0 | 0 | |
ges timeout list | 493,635 | 0.00 | 0.00 | 0 | 675 | 0.00 |
ges value block free list | 11,608 | 0.00 | 0 | 0 | ||
global KZLD latch for auth type mem in SGA | 407 | 0.00 | 0 | 0 | ||
global ctx hash table latch | 3,492 | 0.00 | 0 | 0 | ||
global tx hash mapping | 5,721 | 0.00 | 0 | 0 | ||
granule from data transfer cache | 1 | 0.00 | 0 | 0 | ||
granule operation | 1 | 0.00 | 0 | 0 | ||
hash table Sql Plan Finding latch | 2,602 | 0.00 | 0 | 750 | 0.00 | |
hash table column usage latch | 251 | 0.00 | 0 | 696,834 | 0.01 | |
hash table modification latch | 178 | 0.00 | 0 | 0 | ||
heartbeat check | 1 | 0.00 | 0 | 1,622 | 0.00 | |
heartbeat structure management | 0 | 0 | 1,806 | 0.00 | ||
imc buf hdl lat | 1 | 0.00 | 0 | 0 | ||
imc hash lat | 1 | 0.00 | 0 | 0 | ||
imc sj lat | 1 | 0.00 | 0 | 0 | ||
imc srchsp lat | 1 | 0.00 | 0 | 0 | ||
imc-txn-wrk-lat | 1 | 0.00 | 0 | 0 | ||
in-memory area latch | 1 | 0.00 | 0 | 0 | ||
in-memory columnar segment hash table latch | 1 | 0.00 | 0 | 0 | ||
in-memory columnar ts extent map chunk latch | 1 | 0.00 | 0 | 0 | ||
in-memory global pool latch | 1 | 0.00 | 0 | 0 | ||
interrupt manipulation | 41,317 | 0.00 | 0 | 0 | ||
intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
io pool granule list | 42 | 0.00 | 0 | 0 | ||
io pool granule metadata list | 85 | 0.00 | 0 | 0 | ||
job workq parent latch | 19 | 0.00 | 0 | 18 | 0.00 | |
job_queue_processes free list latch | 36 | 0.00 | 0 | 0 | ||
job_queue_processes parameter latch | 10 | 0.00 | 0 | 0 | ||
k2q global data latch | 3,224 | 0.00 | 0 | 0 | ||
k2q lock allocation | 9,900 | 0.00 | 0 | 0 | ||
kcb DW scan objtemp hash table latch | 1 | 0.00 | 0 | 0 | ||
kcn buffer chains | 1 | 0.00 | 0 | 0 | ||
kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
kgb parent | 1 | 0.00 | 0 | 0 | ||
kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
kjci objects freelist latch | 1 | 0.00 | 0 | 0 | ||
kjci process context latch | 1 | 0.00 | 0 | 6,565 | 0.00 | |
kjoedcso state object freelist latch | 57 | 0.00 | 0 | 0 | ||
kjoeq omni enqueue hash bucket latch | 1 | 0.00 | 0 | 0 | ||
kjoer owner hash bucket | 1 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 88 | 0.00 | 0 | 0 | ||
krbmrosl | 52 | 0.00 | 0 | 0 | ||
krso process latch | 120 | 0.00 | 0 | 0 | ||
ksbxic instance latch | 52 | 0.00 | 0 | 0 | ||
ksfv messages | 1 | 0.00 | 0 | 0 | ||
ksi resource reuse count | 1 | 0.00 | 0 | 0 | ||
ksim group membership cache | 609 | 0.00 | 0 | 0 | ||
ksim membership request latch | 0 | 0 | 2,141 | 0.00 | ||
kss move lock | 335 | 0.00 | 0 | 0 | ||
ksuosstats global area | 316 | 0.00 | 0 | 1,378 | 0.07 | |
ksv allocation latch | 727 | 0.00 | 0 | 0 | ||
ksv class latch | 12,117 | 0.00 | 0 | 0 | ||
ksv instance latch | 8 | 0.00 | 0 | 0 | ||
ksv msg queue latch | 1 | 0.00 | 0 | 0 | ||
ksxp shared latch | 1,267 | 0.00 | 0 | 0 | ||
ksxp so latch | 1,267 | 0.00 | 0 | 0 | ||
ksz_so allocation latch | 1,267 | 0.00 | 0 | 0 | ||
ktfbn latch | 769 | 0.00 | 0 | 0 | ||
ktm global data | 837 | 0.00 | 0 | 0 | ||
ktm prv jrnls | 1 | 0.00 | 0 | 0 | ||
ktmpj HT ls | 1 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 2,221 | 0.14 | 0.00 | 0 | 0 | |
kwqi:kchunk latch | 4 | 0.00 | 0 | 0 | ||
kwslbmdl: metadata latch | 3,096 | 0.00 | 0 | 0 | ||
kwslbql: queue latch | 1 | 0.00 | 0 | 0 | ||
kwsptQcachLt: queue cache latch | 1 | 0.00 | 0 | 0 | ||
kwsptTrncTsksLt: trunc task latch | 1 | 0.00 | 0 | 0 | ||
kwsptjobAdPtLt: AdPt list latch | 1,578 | 0.00 | 0 | 0 | ||
kxfxscanrate_latch | 1 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 8,136 | 0.22 | 0.00 | 0 | 0 | |
list of block allocation | 3,184 | 0.00 | 0 | 0 | ||
loader state object freelist | 844 | 0.00 | 0 | 0 | ||
lob segment dispenser latch | 43 | 0.00 | 0 | 0 | ||
lob segment hash table latch | 442 | 0.00 | 0 | 0 | ||
lob segment query latch | 1 | 0.00 | 0 | 0 | ||
lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
log write info | 0 | 0 | 8,503 | 0.12 | ||
log write slave phase | 5 | 0.00 | 0 | 0 | ||
logical standby cache | 1 | 0.00 | 0 | 0 | ||
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
logminer local | 1 | 0.00 | 0 | 0 | ||
logminer work area | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 109 | 0.00 | 0 | 1 | 0.00 | |
managed standby latch | 120 | 0.00 | 0 | 0 | ||
mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
message bitmap latch | 1 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 23,896 | 0.00 | 0 | 0 | ||
messages | 243,253 | 0.26 | 0.00 | 0 | 0 | |
msg queue latch | 1 | 0.00 | 0 | 0 | ||
multiblock read objects | 20,634 | 0.00 | 0 | 0 | ||
name-service memory objects | 6,463 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 39,196 | 0.00 | 0 | 0 | ||
name-service pending queue | 2,770 | 0.00 | 0 | 0 | ||
name-service request | 140 | 0.00 | 0 | 0 | ||
name-service request queue | 38,698 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 57 | 0.00 | 0 | 0 | ||
ninth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
object queue header freelist | 280,135 | 0.00 | 0 | 0 | ||
object queue header operation | 954,301 | 0.00 | 0 | 4,054,496 | 0.00 | |
object queue memory | 1 | 0.00 | 0 | 0 | ||
object stats modification | 207,055 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 81,272 | 0.00 | 0 | 872 | 0.00 | |
parallel query stats | 16,297 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 2,105 | 0.00 | 0 | 0 | ||
parameter table management | 82,333 | 0.00 | 0 | 0 | ||
peshm | 1 | 0.00 | 0 | 0 | ||
pesom_free_list | 187,973 | 0.00 | 0 | 0 | ||
pesom_hash_node | 187,973 | 0.00 | 0 | 0 | ||
pesom_heap_alloc | 16 | 0.00 | 0 | 0 | ||
pkey global statistics | 1 | 0.00 | 0 | 0 | ||
post/wait queue | 358,606 | 0.01 | 0.00 | 0 | 354,982 | 0.01 |
process allocation | 18,891 | 0.01 | 0.00 | 0 | 632 | 0.32 |
process group creation | 1,267 | 0.00 | 0 | 0 | ||
process pkey statistics list | 1 | 0.00 | 0 | 0 | ||
process queue | 36,184 | 0.00 | 0 | 0 | ||
process queue reference | 941,820 | 0.01 | 0.00 | 0 | 84,819 | 0.06 |
qmn task queue latch | 5,499 | 0.44 | 0.00 | 0 | 0 | |
query server freelists | 43,366 | 0.00 | 0 | 0 | ||
query server process | 7,633 | 0.03 | 1.00 | 0 | 3 | 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 | 23,965 | 1.18 | 0.00 | 0 | 485,592 | 0.03 |
redo copy | 1 | 0.00 | 0 | 485,643 | 0.05 | |
redo transport task latch | 76 | 0.00 | 0 | 0 | ||
redo writing | 33,374 | 0.14 | 0.00 | 0 | 0 | |
resmgr group change latch | 7,444 | 0.00 | 0 | 0 | ||
resmgr:active threads | 13,846 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 7,225 | 0.00 | 0 | 0 | ||
resmgr:actses change state | 242 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 13,580 | 0.01 | 0.00 | 0 | 0 | |
resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:pq event array | 4 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
resmgr:schema config | 210 | 0.00 | 0 | 0 | ||
resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
rm cas latch | 1 | 0.00 | 0 | 0 | ||
row cache objects | 1,074,089 | 0.05 | 0.00 | 0 | 6 | 0.00 |
rules engine aggregate statistics | 1 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 104 | 0.00 | 0 | 0 | ||
rules engine rule statistics | 2 | 0.00 | 0 | 0 | ||
second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
sequence cache | 47,271 | 0.00 | 0 | 0 | ||
session allocation | 34,979 | 0.00 | 0 | 21,735 | 0.00 | |
session idle bit | 345,050 | 0.00 | 0 | 0 | ||
session queue latch | 1 | 0.00 | 0 | 0 | ||
session state list latch | 14,721 | 0.01 | 0.00 | 0 | 0 | |
session statistics | 13,693 | 0.00 | 0 | 0 | ||
session switching | 694 | 0.00 | 0 | 0 | ||
session timer | 1,203 | 0.00 | 0 | 0 | ||
seventh spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
sga hash table parent latch | 1 | 0.00 | 0 | 0 | ||
shard latch | 1 | 0.00 | 0 | 0 | ||
shared pool | 685,070 | 0.00 | 0.00 | 0 | 14 | 0.00 |
shared pool sim alloc | 5 | 0.00 | 0 | 0 | ||
shared pool simulator | 527 | 0.00 | 0 | 0 | ||
sim partition latch | 2 | 0.00 | 0 | 100 | 0.00 | |
simulator hash latch | 13,197,796 | 0.00 | 0 | 0 | ||
simulator lru latch | 1 | 0.00 | 0 | 13,163,757 | 0.03 | |
sixth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
sort extent pool | 5,042 | 0.00 | 0 | 0 | ||
space background state object latch | 4 | 0.00 | 0 | 0 | ||
space background task latch | 1,973 | 1.22 | 0.79 | 0 | 2,409 | 0.00 |
state object free list | 12 | 0.00 | 0 | 0 | ||
statistics aggregation | 112 | 0.00 | 0 | 0 | ||
subscriber Ht bkt | 1 | 0.00 | 0 | 0 | ||
tablespace key chain | 1 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 34 | 0.00 | 0 | 0 | ||
temp undo so allocation | 372 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 376 | 0.00 | 0 | 0 | ||
tenth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
test excl. parent2 lmid cln | 1 | 0.00 | 0 | 0 | ||
test shared parent2 lmid | 1 | 0.00 | 0 | 0 | ||
thirteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
threshold alerts latch | 197 | 0.00 | 0 | 0 | ||
transaction allocation | 2,235,707 | 0.00 | 0.00 | 0 | 0 | |
transaction branch allocation | 6,340 | 0.00 | 0 | 0 | ||
twelfth spare latch - children | 1 | 0.00 | 0 | 0 | ||
twenty-fifth spare latch - S par | 1 | 0.00 | 0 | 0 | ||
twenty-first spare latch - S par | 1 | 0.00 | 0 | 0 | ||
twenty-fourth spare latch - S par | 1 | 0.00 | 0 | 0 | ||
twenty-second spare latch - S par | 1 | 0.00 | 0 | 0 | ||
twenty-third spare latch - S par | 1 | 0.00 | 0 | 0 | ||
undo global data | 65,860 | 0.02 | 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 |
Back to Latch Statistics
Back to Top
Latch Sleep Breakdown
- ordered by misses desc
Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
---|---|---|---|---|
cache buffers chains | 4,798,279,329 | 255,955 | 24 | 255,932 |
ges resource hash list | 3,156,576 | 1,846 | 100 | 1,746 |
row cache objects | 1,074,089 | 535 | 2 | 533 |
ges cached resource lists | 564,400 | 351 | 4 | 347 |
redo allocation | 23,965 | 283 | 1 | 282 |
KWQMN job cache list latch | 2,244 | 261 | 15 | 246 |
ges resource table freelist | 706,651 | 185 | 1 | 184 |
space background task latch | 1,973 | 24 | 19 | 5 |
query server process | 7,633 | 2 | 2 | 0 |
Back to Latch Statistics
Back to Top
Latch Miss Sources
- only latches with sleeps are shown
- ordered by name, sleeps desc
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
KWQMN job cache list latch | kwqmndej: dequeue | 0 | 17 | 17 |
PC and Classifier lists for WLM | No latch | 0 | 2 | 0 |
cache buffers chains | kcbchg: cr pin change | 0 | 13 | 0 |
cache buffers chains | kcbgtcr: slow path excl | 0 | 9 | 5 |
cache buffers chains | kcbgcur: fast path excl | 0 | 2 | 0 |
cache buffers chains | kcbgtcr: fast path exam | 0 | 2 | 3 |
cache buffers chains | kcbgtcr: fast path pin | 0 | 2 | 13 |
cache buffers chains | kcbchg: cr pin cleanout | 0 | 1 | 1 |
cache buffers chains | kcbget: new pin | 0 | 1 | 0 |
cache buffers chains | kclbla | 0 | 1 | 0 |
gc element | kclnfndx | 0 | 1 | 0 |
gc element | kclpdcl | 0 | 1 | 0 |
ges cached resource lists | kjruch: cached obj cleanup | 0 | 2 | 0 |
ges cached resource lists | kjchc: clean resource cache | 0 | 1 | 0 |
ges cached resource lists | kjrchc: cached obj cleanup | 0 | 1 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 55 | 10 |
ges resource hash list | kjucvl: lock convert request | 0 | 26 | 23 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 13 | 7 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 5 | 38 |
ges resource hash list | kjrref: find matched resource | 0 | 1 | 22 |
ges resource table freelist | kjralc: resource allocation | 0 | 1 | 0 |
query server process | kxfpg1srv | 0 | 2 | 2 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 1 | 0 |
row cache objects | kqrpre: find obj | 0 | 2 | 2 |
space background task latch | ktsj_grab_task | 0 | 17 | 19 |
Back to Latch Statistics
Back to Top
Mutex Sleep Summary
- ordered by number of sleeps desc
Mutex Type | Location | Sleeps | Wait Time (ms) |
---|---|---|---|
Library Cache | kglhdgn1 62 | 112 | 0 |
Library Cache | kglpnal2 91 | 14 | 0 |
Library Cache | kglpin1 4 | 11 | 22 |
Library Cache | kglhdgn2 106 | 7 | 0 |
Library Cache | kgllkdl1 85 | 4 | 0 |
Cursor Pin | kksfbc [KKSCHLFSP2] | 4 | 4 |
Library Cache | kglget1 1 | 2 | 0 |
Library Cache | kgllkal1 80 | 2 | 0 |
Library Cache | kglpnal1 90 | 2 | 0 |
Library Cache | kglpndl1 95 | 2 | 0 |
Cursor Pin | kksLockDelete [KKSCHLPIN6] | 2 | 2 |
Back to Latch Statistics
Back to Top
Parent Latch Statistics
No data exists for this section of the report. Back to Latch StatisticsBack to Top
Child Latch Statistics
No data exists for this section of the report. Back to Latch StatisticsBack to Top
Segment Statistics
- Segments by Logical Reads
- Segments by Physical Reads
- Segments by Physical Read Requests
- Segments by UnOptimized Reads
- Segments by Optimized Reads
- Segments by Direct Physical Reads
- Segments by Physical Writes
- Segments by Physical Write Requests
- Segments by Direct Physical Writes
- Segments by Table Scans
- Segments by DB Blocks Changes
- Segments by Row Lock Waits
- Segments by ITL Waits
- Segments by Buffer Busy Waits
- Segments by Global Cache Buffer Busy
- Segments by CR Blocks Received
- Segments by Current Blocks Received
Segments by Logical Reads
- Total Logical Reads: 2,457,281,648
- Captured Segments account for 99.8% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Logical Reads | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_DATA | GL_CODE_COMBINATIONS | TABLE | 39351 | 39351 | 2,296,104,816 | 93.44 | |
GL | APPS_TS_TX_IDX | GL_CODE_COMBINATIONS_U1 | INDEX | 39353 | 39353 | 68,394,240 | 2.78 | |
PA | APPS_TS_TX_DATA | PA_AGREEMENTS_ALL | TABLE | 52900 | 52900 | 39,141,984 | 1.59 | |
PA | APPS_TS_TX_DATA | PA_PROJECTS_ERP_EXT_B | AG_40 | TABLE PARTITION | 495763 | 495763 | 8,479,376 | 0.35 |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_PROCESSES_N2 | INDEX | 37083 | 37083 | 4,952,752 | 0.20 |
Back to Segment Statistics
Back to Top
Segments by Physical Reads
- Total Physical Reads: 403,759
- Captured Segments account for 64.4% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Physical Reads | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_DATA | GL_JE_LINES | TABLE | 39515 | 39515 | 205,481 | 50.89 | |
GL | APPS_TS_TX_IDX | GL_JE_LINES_U1 | INDEX | 39518 | 39518 | 35,271 | 8.74 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_PROCESSES | TABLE | 37081 | 37081 | 15,745 | 3.90 | |
GL | APPS_TS_TX_IDX | GL_ACCOUNT_HIERARCHIES_U2 | INDEX | 39239 | 39239 | 884 | 0.22 | |
GL | APPS_TS_TX_IDX | GL_BALANCES_N1 | INDEX | 39287 | 39287 | 524 | 0.13 |
Back to Segment Statistics
Back to Top
Segments by Physical Read Requests
- Total Physical Read Requests: 384,604
- Captured Segments account for 62.8% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Phys Read Requests | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_DATA | GL_JE_LINES | TABLE | 39515 | 39515 | 202,019 | 52.53 | |
GL | APPS_TS_TX_IDX | GL_JE_LINES_U1 | INDEX | 39518 | 39518 | 35,271 | 9.17 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_PROCESSES | TABLE | 37081 | 37081 | 1,001 | 0.26 | |
GL | APPS_TS_TX_IDX | GL_ACCOUNT_HIERARCHIES_U2 | INDEX | 39239 | 39239 | 884 | 0.23 | |
GL | APPS_TS_TX_IDX | GL_BALANCES_N1 | INDEX | 39287 | 39287 | 524 | 0.14 |
Back to Segment Statistics
Back to Top
Segments by UnOptimized Reads
- Total UnOptimized Read Requests: 384,604
- Captured Segments account for 62.8% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | UnOptimized Reads | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_DATA | GL_JE_LINES | TABLE | 39515 | 39515 | 202,019 | 52.53 | |
GL | APPS_TS_TX_IDX | GL_JE_LINES_U1 | INDEX | 39518 | 39518 | 35,271 | 9.17 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_PROCESSES | TABLE | 37081 | 37081 | 1,001 | 0.26 | |
GL | APPS_TS_TX_IDX | GL_ACCOUNT_HIERARCHIES_U2 | INDEX | 39239 | 39239 | 884 | 0.23 | |
GL | APPS_TS_TX_IDX | GL_BALANCES_N1 | INDEX | 39287 | 39287 | 524 | 0.14 |
Back to Segment Statistics
Back to Top
Segments by Optimized Reads
No data exists for this section of the report. Back to Segment StatisticsBack to Top
Segments by Direct Physical Reads
No data exists for this section of the report. Back to Segment StatisticsBack to Top
Segments by Physical Writes
- Total Physical Writes: 24,134
- Captured Segments account for 43.6% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Physical Writes | %Total |
---|---|---|---|---|---|---|---|---|
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 37114 | 37114 | 3,700 | 15.33 | |
GL | APPS_TS_TX_DATA | GL_BALANCES | TABLE | 39286 | 39286 | 1,308 | 5.42 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N8 | INDEX | 37122 | 37122 | 1,076 | 4.46 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N10 | INDEX | 37125 | 37125 | 908 | 3.76 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N2 | INDEX | 2186009 | 2186009 | 862 | 3.57 |
Back to Segment Statistics
Back to Top
Segments by Physical Write Requests
- Total Physical Write Requests: 15,055
- Captured Segments account for 52.6% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Phys Write Requests | %Total |
---|---|---|---|---|---|---|---|---|
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 37114 | 37114 | 3,343 | 22.21 | |
GL | APPS_TS_TX_DATA | GL_BALANCES | TABLE | 39286 | 39286 | 1,198 | 7.96 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N8 | INDEX | 37122 | 37122 | 729 | 4.84 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N10 | INDEX | 37125 | 37125 | 454 | 3.02 | |
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N2 | INDEX | 2186009 | 2186009 | 405 | 2.69 |
Back to Segment Statistics
Back to Top
Segments by Direct Physical Writes
- Total Direct Physical Writes: 430
- Captured Segments account for 21.9% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Direct Writes | %Total |
---|---|---|---|---|---|---|---|---|
SYS | SYSAUX | SYS_LOB0002378215C00009$$ | SYS_LOB_P25439 | LOB PARTITION | 3540537 | 3540537 | 31 | 7.21 |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_4112780385_50181 | TABLE PARTITION | 3540638 | 3540638 | 29 | 6.74 |
SYS | TEMP | SYS_TEMP_0FD9D6613_D9865A36 | TABLE | 4254950931 | 7649920 | 20 | 4.65 | |
SYS | TEMP | SYS_TEMP_0FD9D660F_D9865A36 | TABLE | 4254950927 | 15205504 | 7 | 1.63 | |
SYS | TEMP | SYS_TEMP_0FD9D660F_D9865A36 | TABLE | 4254950927 | 8469760 | 5 | 1.16 |
Back to Segment Statistics
Back to Top
Segments by Table Scans
- Total Table Scans: 421
- Captured Segments account for 4.5% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Table Scans | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_DATA | GL_JE_LINES | TABLE | 39515 | 39515 | 10 | 2.38 | |
GL | APPS_TS_TX_IDX | GL_ACCOUNT_HIERARCHIES_U2 | INDEX | 39239 | 39239 | 6 | 1.43 | |
AR | APPS_TS_TX_IDX | HZ_PARTIES_U1 | INDEX | 51285 | 51285 | 2 | 0.48 | |
XLA | APPS_TS_TX_DATA | XLA_AE_LINES | AP | TABLE PARTITION | 2069055 | 2069055 | 1 | 0.24 |
Back to Segment Statistics
Back to Top
Segments by DB Blocks Changes
- % of Capture shows % of DB Block Changes for each top segment compared
- with total DB Block Changes for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | DB Block Changes | % of Capture |
---|---|---|---|---|---|---|---|---|
AP | APPS_TS_TX_DATA | AP_INVOICE_DISTRIBUTIONS_ALL | TABLE | 2050147 | 2050147 | 13,472 | 9.15 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 37114 | 37114 | 9,232 | 6.27 | |
XLA | TEMP | XLA_AE_LINES_GT | TABLE | 2069066 | 6020992 | 7,568 | 5.14 | |
AP | APPS_TS_TX_IDX | AP_INVOICE_DISTRIBUTIONS_N32 | INDEX | 2109977 | 2109977 | 7,440 | 5.05 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_QUEUES | TABLE | 37097 | 37097 | 6,688 | 4.54 |
Back to Segment Statistics
Back to Top
Segments by Row Lock Waits
- % of Capture shows % of row lock waits for each top segment compared
- with total row lock waits for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|---|---|
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_REQUESTS | TABLE | 37114 | 37114 | 2 | 100.00 |
Back to Segment Statistics
Back to Top
Segments by ITL Waits
No data exists for this section of the report. Back to Segment StatisticsBack to Top
Segments by Buffer Busy Waits
- % of Capture shows % of Buffer Busy Waits for each top segment compared
- with total Buffer Busy Waits for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|---|---|
APPLSYS | APPS_TS_TX_IDX | FND_CONCURRENT_REQUESTS_N2 | INDEX | 2186009 | 2186009 | 5 | 62.50 | |
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_QUEUES | TABLE | 37097 | 37097 | 2 | 25.00 | |
SYS | SYSAUX | SYS_LOB0002378215C00009$$ | SYS_LOB_P25439 | LOB PARTITION | 3540537 | 3540537 | 1 | 12.50 |
Back to Segment Statistics
Back to Top
Segments by Global Cache Buffer Busy
- % of Capture shows % of GC Buffer Busy for each top segment compared
- with GC Buffer Busy for all segments captured by the Snapshot
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|---|---|
SYS | SYSTEM | OBJ$ | TABLE | 2400696 | 2400696 | 2 | 66.67 | |
SYS | SYSTEM | SCHEDULER$_JOB | TABLE | 212868 | 212868 | 1 | 33.33 |
Back to Segment Statistics
Back to Top
Segments by CR Blocks Received
- Total CR Blocks Received: 783
- Captured Segments account for 53.4% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | CR Blocks Received | %Total |
---|---|---|---|---|---|---|---|---|
APPLSYS | APPS_TS_TX_DATA | FND_CONCURRENT_PROCESSES | TABLE | 37081 | 37081 | 92 | 11.75 | |
SYS | SYSAUX | WRH$_SEG_STAT_OBJ | TABLE | 215080 | 215080 | 80 | 10.22 | |
SYS | SYSTEM | USER$ | TABLE | 2400706 | 2400704 | 54 | 6.90 | |
SYS | SYSTEM | OBJ$ | TABLE | 2400696 | 2400696 | 34 | 4.34 | |
SYS | SYSTEM | SCHEDULER$_JOB | TABLE | 212868 | 212868 | 32 | 4.09 |
Back to Segment Statistics
Back to Top
Segments by Current Blocks Received
- Total Current Blocks Received: 3,221
- Captured Segments account for 85.4% of Total
- When ** MISSING ** occurs, some of the object attributes may not be available
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Obj# | Dataobj# | Current Blocks Received | %Total |
---|---|---|---|---|---|---|---|---|
GL | APPS_TS_TX_IDX | GL_JE_BATCHES_N1 | INDEX | 39502 | 39502 | 700 | 21.73 | |
AR | APPS_TS_TX_IDX | HZ_CUST_SITE_USES_N1 | INDEX | 50883 | 50883 | 366 | 11.36 | |
AP | APPS_TS_TX_IDX | AP_INVOICE_DISTRIBUTIONS_N33 | INDEX | 2109978 | 2109978 | 325 | 10.09 | |
GL | APPS_TS_TX_IDX | GL_BALANCES_N1 | INDEX | 39287 | 39287 | 271 | 8.41 | |
AR | APPS_TS_TX_IDX | HZ_CUST_ACCOUNTS_U1 | INDEX | 50827 | 50827 | 222 | 6.89 |
Back to Segment Statistics
Back to Top
Dictionary Cache Statistics
Back to TopDictionary Cache Stats
- "Pct Misses" should be very low (< 2% in most cases)
- "Final Usage" is the number of cache entries being used
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 98 | 0.00 | 0 | 2 | 1 | |
dc_constraints | 16 | 50.00 | 0 | 16 | 315 | |
dc_files | 130 | 0.00 | 0 | 0 | 63 | |
dc_global_oids | 6,404 | 0.09 | 0 | 6 | 354 | |
dc_histogram_data | 1,190 | 0.00 | 0 | 0 | 2,109 | |
dc_histogram_defs | 38,752 | 0.35 | 0 | 134 | 1,879,270 | |
dc_object_grants | 181 | 0.00 | 0 | 0 | 749 | |
dc_objects | 25,162 | 0.31 | 0 | 27 | 81,532 | |
dc_profiles | 908 | 0.00 | 0 | 0 | 3 | |
dc_props | 12,051 | 0.00 | 0 | 0 | 60 | |
dc_rollback_segments | 11,280 | 0.00 | 0 | 1 | 180 | |
dc_segments | 5,109 | 0.10 | 0 | 14 | 68,245 | |
dc_sequences | 62 | 1.61 | 0 | 62 | 207 | |
dc_table_scns | 447 | 0.00 | 0 | 0 | 32 | |
dc_tablespace_quotas | 180 | 0.00 | 0 | 0 | 35 | |
dc_tablespaces | 106,075 | 0.00 | 0 | 0 | 26 | |
dc_users | 160,841 | 0.00 | 0 | 0 | 1,339 | |
outstanding_alerts | 5 | 100.00 | 0 | 0 | 7 | |
sch_lj_oids | 35 | 0.00 | 0 | 0 | 119 |
Back to Dictionary Cache Statistics
Back to Top
Dictionary Cache Stats (RAC)
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 4 | 0 | 0 |
dc_constraints | 32 | 0 | 0 |
dc_global_oids | 14 | 0 | 0 |
dc_histogram_defs | 269 | 0 | 0 |
dc_objects | 61 | 18 | 4 |
dc_rollback_segments | 2 | 0 | 0 |
dc_segments | 29 | 4 | 1 |
dc_sequences | 124 | 0 | 0 |
dc_tablespace_quotas | 88 | 0 | 0 |
dc_users | 6 | 0 | 0 |
outstanding_alerts | 10 | 6 | 0 |
Back to Dictionary Cache Statistics
Back to Top
Library Cache Statistics
Back to TopLibrary Cache Activity
- "Pct Misses" should be very low
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
ACCOUNT_STATUS | 1,628 | 0.00 | 0 | 0 | 0 | |
APP CONTEXT | 1,058 | 0.00 | 10,125 | 0.00 | 0 | 0 |
BODY | 12,424 | 0.00 | 91,554 | 0.00 | 0 | 0 |
DBLINK | 1,695 | 0.00 | 0 | 0 | 0 | |
DIRECTORY | 750 | 0.00 | 750 | 0.00 | 0 | 0 |
EDITION | 1,182 | 0.00 | 1,182 | 0.00 | 0 | 0 |
HINTSET OBJECT | 6 | 0.00 | 6 | 0.00 | 0 | 0 |
INDEX | 42 | 2.38 | 57 | 3.51 | 0 | 0 |
JAVA RESOURCE | 3 | 0.00 | 3 | 0.00 | 0 | 0 |
OBJECT ID | 7 | 100.00 | 0 | 0 | 0 | |
QUEUE | 1,236 | 0.32 | 19,455 | 0.08 | 4 | 0 |
RULESET | 1 | 0.00 | 1 | 0.00 | 0 | 0 |
SCHEMA | 451 | 0.00 | 0 | 0 | 0 | |
SQL AREA | 25,434 | 0.62 | 967,664 | 0.00 | 57 | 59 |
SQL AREA BUILD | 142 | 54.23 | 0 | 0 | 0 | |
SQL AREA STATS | 144 | 63.19 | 144 | 63.19 | 0 | 0 |
SUBSCRIPTION | 5 | 60.00 | 5 | 60.00 | 0 | 0 |
TABLE/PROCEDURE | 376,940 | 0.00 | 644,012 | 0.00 | 21 | 0 |
TRIGGER | 2,026 | 0.00 | 37,757 | 0.00 | 0 | 0 |
USER PRIVILEGE | 260 | 0.00 | 260 | 0.00 | 0 | 0 |
Back to Library Cache Statistics
Back to Top
Library Cache Activity (RAC)
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
ACCOUNT_STATUS | 1,628 | 0 | 0 | 0 | 0 |
BODY | 3 | 91,145 | 91,145 | 0 | 0 |
DBLINK | 1,695 | 0 | 0 | 0 | 0 |
DIRECTORY | 18 | 750 | 750 | 0 | 0 |
EDITION | 1,182 | 1,182 | 1,182 | 0 | 0 |
HINTSET OBJECT | 6 | 6 | 6 | 0 | 0 |
INDEX | 57 | 57 | 57 | 0 | 0 |
JAVA RESOURCE | 0 | 3 | 3 | 0 | 0 |
QUEUE | 1,149 | 19,376 | 19,376 | 0 | 0 |
RULESET | 0 | 1 | 1 | 0 | 0 |
SCHEMA | 441 | 0 | 0 | 0 | 0 |
SUBSCRIPTION | 0 | 5 | 5 | 0 | 0 |
TABLE/PROCEDURE | 45,292 | 640,853 | 640,853 | 0 | 0 |
TRIGGER | 0 | 37,757 | 37,757 | 0 | 0 |
USER PRIVILEGE | 0 | 260 | 260 | 0 | 0 |
Back to Library Cache Statistics
Back to Top
Memory Statistics
- Memory Dynamic Components
- Memory Resize Operations Summary
- Memory Resize Ops
- Process Memory Summary
- SGA Memory Summary
- SGA breakdown difference
Memory Dynamic Components
- Min/Max sizes since instance startup
- Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
- ordered by Component
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 | 117,248.00 | 117,248.00 | 117,248.00 | 119,808.00 | 0 | SHR/DEF |
Data Transfer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
In-Memory Area | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
KEEP buffer cache | 512.00 | 512.00 | 512.00 | 512.00 | 0 | STA/ |
PGA Target | 10,240.00 | 10,240.00 | 10,240.00 | 10,240.00 | 0 | STA/ |
RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
SGA Target | 163,840.00 | 163,840.00 | 163,840.00 | 163,840.00 | 0 | STA/ |
Shared IO Pool | 512.00 | 512.00 | 512.00 | 512.00 | 0 | STA/ |
java pool | 3,584.00 | 3,584.00 | 3,584.00 | 3,584.00 | 0 | STA/ |
large pool | 512.00 | 512.00 | 512.00 | 512.00 | 0 | STA/ |
shared pool | 39,936.00 | 39,936.00 | 37,376.00 | 39,936.00 | 0 | GRO/DEF |
streams pool | 1,024.00 | 1,024.00 | 1,024.00 | 1,024.00 | 0 | STA/ |
Back to Memory Statistics
Back to Top
Memory Resize Operations Summary
No data exists for this section of the report. Back to Memory StatisticsBack to Top
Memory Resize Ops
No data exists for this section of the report. Back to Memory StatisticsBack to Top
Process Memory Summary
- B: Begin Snap E: End Snap
- All rows below contain absolute values (i.e. not diffed over the interval)
- Max Alloc is Maximum PGA Allocation size at snapshot time
- Hist Max Alloc is the Historical Max Allocation for still-connected processes
- ordered by Begin/End snapshot, Alloc (MB) desc
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 | 1,667.78 | 7.25 | 20.27 | 257 | 257 | 230 | 230 | |
B | PL/SQL | 372.04 | 286.22 | 1.62 | 3.15 | 30 | 31 | 230 | 230 |
B | JAVA | 188.05 | 110.86 | 6.96 | 15.20 | 83 | 236 | 27 | 27 |
B | Freeable | 187.13 | 0.00 | 1.21 | 1.62 | 14 | 155 | 155 | |
B | SQL | 142.22 | 102.31 | 0.79 | 4.48 | 51 | 103 | 181 | 164 |
E | Other | 1,667.57 | 7.22 | 20.23 | 257 | 257 | 231 | 231 | |
E | PL/SQL | 387.03 | 297.61 | 1.68 | 3.39 | 30 | 31 | 231 | 230 |
E | Freeable | 238.00 | 0.00 | 1.46 | 2.70 | 27 | 163 | 163 | |
E | JAVA | 184.01 | 106.79 | 7.08 | 15.49 | 83 | 236 | 26 | 26 |
E | SQL | 144.08 | 103.98 | 0.79 | 4.45 | 51 | 103 | 182 | 163 |
Back to Memory Statistics
Back to Top
SGA Memory Summary
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 124,017,180,672 | |
Fixed Size | 7,654,304 | |
Redo Buffers | 529,215,488 | |
Variable Size | 47,244,641,376 |
Back to Top
SGA breakdown difference
- ordered by Pool, Name
- N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | JOXLE | 48.80 | 48.80 | 0.00 |
java | free memory | 3,532.17 | 3,532.17 | 0.00 |
large | PX msg pool | 7.81 | 7.81 | 0.00 |
large | free memory | 496.24 | 496.24 | 0.00 |
large | krcc extent chunk | 5.94 | 5.94 | 0.00 |
shared | KGLH0 | 4,086.97 | 4,087.09 | 0.00 |
shared | KGLHD | 1,010.06 | 1,010.19 | 0.01 |
shared | KGLS | 519.15 | 518.86 | -0.06 |
shared | KQR X PO | 2,047.74 | 2,047.90 | 0.01 |
shared | SQLA | 15,595.29 | 15,591.86 | -0.02 |
shared | db_block_hash_buckets | 704.00 | 704.00 | 0.00 |
shared | free memory | 5,960.60 | 5,963.77 | 0.05 |
shared | gcs resources | 3,856.60 | 3,856.60 | 0.00 |
shared | gcs shadows | 2,142.56 | 2,142.56 | 0.00 |
shared | ges resource dynamic | 1,018.21 | 1,018.21 | 0.00 |
streams | free memory | 1,023.99 | 1,023.99 | 0.00 |
buffer_cache | 117,760.00 | 117,760.00 | 0.00 | |
fixed_sga | 7.30 | 7.30 | 0.00 | |
log_buffer | 504.70 | 504.70 | 0.00 | |
shared_io_pool | 512.00 | 512.00 | 0.00 |
Back to Memory Statistics
Back to Top
Replication Statistics (GoldenGate, XStream)
- Replication System Resource Usage
- Replication SGA Usage
- GoldenGate Capture
- GoldenGate Capture Rate
- GoldenGate Apply Reader
- GoldenGate Apply Coordinator
- GoldenGate Apply Server
- GoldenGate Apply Coordinator Rate
- GoldenGate Apply Reader and Server Rate
- XStream Capture
- XStream Capture Rate
- XStream Apply Reader
- XStream Apply Coordinator
- XStream Apply Server
- XStream Apply Coordinator Rate
- XStream Apply Reader and Server Rate
- Table Statistics by DML Operations
- Table Statistics by Conflict Resolutions
- Replication Large Transaction Statistics
- Replication Long Running Transaction Statistics
Replication System Resource Usage
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Replication SGA Usage
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Capture
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Capture Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Apply Reader
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Apply Coordinator
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Apply Server
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Apply Coordinator Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
GoldenGate Apply Reader and Server Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Capture
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Capture Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Apply Reader
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Apply Coordinator
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Apply Server
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Apply Coordinator Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
XStream Apply Reader and Server Rate
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Table Statistics by DML Operations
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Table Statistics by Conflict Resolutions
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Replication Large Transaction Statistics
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Replication Long Running Transaction Statistics
No data exists for this section of the report. Back to Replication Statistics (GoldenGate, XStream)Back to Top
Streams Statistics
- Streams CPU/IO Usage
- Streams Capture
- Streams Capture Rate
- Streams Apply
- Streams Apply Rate
- Buffered Queues
- Buffered Queue Subscribers
- Rule Set
- Persistent Queues
- Persistent Queues Rate
- Persistent Queue Subscribers
Streams CPU/IO Usage
- Streams processes ordered by CPU Time in descending order
Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
---|---|---|---|---|
AQ LB Coordinator | 26-May-20 17:08:37 | 1.43 | 0.00 | 0.00 |
QMON Slave | 26-May-20 17:08:37 | 0.74 | 0.00 | 0.00 |
EMON Reliable Slave | 26-May-20 17:08:37 | 0.29 | 0.00 | 0.00 |
EMON Regular Slave | 26-May-20 17:08:37 | 0.17 | 0.00 | 0.00 |
QMON Coordinator | 26-May-20 17:08:37 | 0.07 | 0.00 | 0.00 |
EMON Coordinator | 26-May-20 17:08:37 | 0.04 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Streams Capture
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Capture Rate
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Apply
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Streams Apply Rate
No data exists for this section of the report. Back to Streams StatisticsBack to Top
Buffered Queues
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
Queue Name | Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs |
---|---|---|---|---|---|---|---|
APPLSYS.WF_CONTROL(2117178) | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 |
Back to Streams Statistics
Back to Top
Buffered Queue Subscribers
- Ordered by Queue Name, Subscriber Name
- * indicates Subscriber activity (re)started between Begin/End snaps
Subscriber/Queue | Enq Msgs | Enq Msgs/sec | Deq Msgs | Deq Msgs/sec | Spill Msgs | Spill Msgs/sec | %Spill Msgs |
---|---|---|---|---|---|---|---|
WFBESCL_5736(3425)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | |
WFBESCL_5737(3424)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 | |
WFBESCL_5738(3423)/APPLSYS.WF_CONTROL | 0 | 0.00 | 0 | 0.00 | 0 | 0.00 |
Back to Streams Statistics
Back to Top
Rule Set
- Rule Sets ordered by Evaluations
- * indicates Rule Set activity (re)started between Begin/End snaps
- SQL per Eval - average # of SQL statements executed for non-SQL free evals
- CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals
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 |
---|---|---|---|---|---|---|---|---|---|---|
APPLSYS.FND_CP_GSM_OPP_AQ_R | 1 | 0.00 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 |
Back to Streams Statistics
Back to Top
Persistent Queues
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
- %Exp Msgs - % of msgs enqueued with expiry
- %Delay Msgs - % of msgs enqueued with delay
- %Trasf Time - % of Enqueue time spent in transformation
- %Eval Time - % of Enqueue time spent in rule evaluation
Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
---|---|---|---|---|---|---|---|---|
APPLSYS.FND_CP_GSM_IPC_AQ(2112758) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.FND_CP_GSM_OPP_AQ(2075416) | 1 | 2 | 100.00 | 0.00 | 0.84 | 5.28 | 0.00 | 0.04 |
APPLSYS.WF_CONTROL(2117178) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.WF_DEFERRED(210823) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.WF_DEFERRED_QUEUE_M(210820) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.WF_ERROR(210826) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.WF_JAVA_DEFERRED(210740) | 0 | 0 | 0.00 | 0.00 | ||||
APPLSYS.WF_JAVA_ERROR(210738) | 0 | 0 | 0.00 | 0.00 | ||||
SYS.ALERT_QUE(214814) | 0 | 0 | 0.00 | 0.00 | ||||
SYS.AQ$_ALERT_QT_E(214813) | 2 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
*XLA.XLA_43237766_DOC_Q(3541008) | 1 | 1 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Persistent Queues Rate
- Ordered by Queue Name
- * indicates queue (re)started between Begin/End snaps
Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
---|---|---|---|---|
APPLSYS.FND_CP_GSM_IPC_AQ(2112758) | 0.00 | 0.00 | ||
APPLSYS.FND_CP_GSM_OPP_AQ(2075416) | 0.00 | 0.00 | 0.84 | 2.64 |
APPLSYS.WF_CONTROL(2117178) | 0.00 | 0.00 | ||
APPLSYS.WF_DEFERRED(210823) | 0.00 | 0.00 | ||
APPLSYS.WF_DEFERRED_QUEUE_M(210820) | 0.00 | 0.00 | ||
APPLSYS.WF_ERROR(210826) | 0.00 | 0.00 | ||
APPLSYS.WF_JAVA_DEFERRED(210740) | 0.00 | 0.00 | ||
APPLSYS.WF_JAVA_ERROR(210738) | 0.00 | 0.00 | ||
SYS.ALERT_QUE(214814) | 0.00 | 0.00 | ||
SYS.AQ$_ALERT_QT_E(214813) | 0.00 | 0.00 | 0.00 | |
*XLA.XLA_43237766_DOC_Q(3541008) | 0.00 | 0.00 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Persistent Queue Subscribers
- Ordered by Queue Name, Subscriber Name
- * indicates Subscriber activity (re)started between Begin/End snaps
Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
---|---|---|---|---|---|---|
OPP971354(2968)/APPLSYS.FND_CP_GSM_OPP_AQ | 1 | 0 | 0 | 0.00 | 0.00 | 0.00 |
OPP971355(2986)/APPLSYS.FND_CP_GSM_OPP_AQ | 1 | 1 | 0 | 0.00 | 0.00 | 0.00 |
WF_DEFERRED(1)/APPLSYS.WF_DEFERRED | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
WF_JAVA_DEFERRED(21)/APPLSYS.WF_JAVA_DEFERRED | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
BOT_DBPROD01__3872_OAPRD1(81)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
BOT_DBPROD02__3872_OAPRD2(102)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
BOT_PROD01_UI_3872_OAPRD1(61)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
BOT_PROD02_UI_3872_OAPRD2(41)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_(123)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_IOAPRD1(182)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_IOAPRD2(162)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_IROAPRD1(202)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_OAPRD1(122)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_OAPRD2(142)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_R(222)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_ROAPRD1(183)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGBOT_DBPROD_3872_ROAPRD2(163)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IIROAPRD1(303)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IIROAPRD2(323)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IOAPRD1(262)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IOAPRD2(242)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IROAPRD1(282)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_IROAPRD2(302)/SYS.ALERT_QUE | 0 | 0 | 2 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_ROAPRD1(263)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
NGDBORA_BOT__3872_ROAPRD2(243)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
Back to Streams Statistics
Back to Top
Resource Limit Stats
- Only rows with Current or Maximum Utilization > 80% of Limit are shown
- For "UNLIMITED" resources, rows whose Current or Maximum Utilization exceeds 2*Initial Allocation are shown
- Ordered by Resource Name
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
ges_cache_ress | 108,218 | 673,040 | 0 | UNLIMITED |
ges_reg_msgs | 286 | 12,498 | 4730 | UNLIMITED |
ges_ress | 2,061,137 | 3,276,764 | 45666 | UNLIMITED |
smartio_overhead_memory | 0 | 164,888 | 0 | UNLIMITED |
smartio_sessions | 0 | 1 | 0 | UNLIMITED |
Back to Top
Shared Server Statistics
- Shared Servers Activity
- Shared Servers Rates
- Shared Servers Utilization
- Shared Servers Common Queue
- Shared Servers Dispatchers
Shared Servers Activity
- Values represent averages for all samples
Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
---|---|---|---|---|---|
0 | 0 | 0 | 0 | 0 | 0 |
Back to Shared Server Statistics
Back to Top
Shared Servers Rates
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 |
Back to Shared Server Statistics
Back to Top
Shared Servers Utilization
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
Shared Servers Common Queue
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
Shared Servers Dispatchers
No data exists for this section of the report. Back to Shared Server StatisticsBack to Top
init.ora Parameters
Back to Topinit.ora Parameters
Parameter Name | Begin value | End value (if different) |
---|---|---|
O7_DICTIONARY_ACCESSIBILITY | FALSE | |
_optimizer_autostats_job | FALSE | |
_optimizer_nlj_hj_adaptive_join | FALSE | |
aq_tm_processes | 8 | |
audit_file_dest | /opt/ora/oracle/admin/OAPRD/adump | |
audit_trail | DB, EXTENDED | |
cluster_database | TRUE | |
compatible | 12.1.0 | |
control_file_record_keep_time | 5 | |
control_files | +DATA/oaprd/controlfile/current.277.866234901 | |
cursor_sharing | EXACT | |
db_block_checking | FALSE | |
db_block_checksum | TRUE | |
db_block_size | 8192 | |
db_create_file_dest | +DATA | |
db_create_online_log_dest_1 | +DATA | |
db_create_online_log_dest_2 | +DATA | |
db_domain | uio.no | |
db_files | 512 | |
db_keep_cache_size | 536870912 | |
db_name | OAPRD | |
db_recovery_file_dest | +FRA | |
db_recovery_file_dest_size | 77309411328 | |
db_ultra_safe | data_and_index | |
diagnostic_dest | /opt/ora/oracle | |
disk_asynch_io | TRUE | |
dml_locks | 10000 | |
event | ||
fast_start_mttr_target | 600 | |
instance_number | 1 | |
listener_networks | ||
local_listener | (ADDRESS=(PROTOCOL=TCP)(HOST=129.240.119.54)(PORT=1552)) | |
log_archive_dest_1 | LOCATION=+DATA | |
log_archive_dest_2 | LOCATION=USE_DB_RECOVERY_FILE_DEST | |
log_archive_format | arch%t_%s_%r.log | |
log_archive_min_succeed_dest | 1 | |
log_buffer | 1703936 | |
log_checkpoints_to_alert | TRUE | |
max_dump_file_size | UNLIMITED | |
nls_comp | BINARY | |
nls_date_format | DD-MON-RR | |
nls_length_semantics | byte | |
nls_numeric_characters | ., | |
nls_sort | BINARY | |
nls_territory | AMERICA | |
olap_page_pool_size | 4194304 | |
open_cursors | 600 | |
optimizer_secure_view_merging | FALSE | |
parallel_force_local | TRUE | |
parallel_max_servers | 8 | |
parallel_min_percent | 0 | |
parallel_min_servers | 0 | |
parallel_threads_per_cpu | 2 | |
pga_aggregate_target | 10737418240 | |
plsql_code_type | INTERPRETED | |
processes | 2000 | |
recyclebin | OFF | |
remote_listener | dbora-bot-prod-scan.uio.no:1522 | |
replication_dependency_tracking | FALSE | |
sec_case_sensitive_logon | TRUE | |
session_cached_cursors | 500 | |
session_max_open_files | 20 | |
sessions | 4000 | |
sga_max_size | 171798691840 | |
sga_target | 171798691840 | |
shared_pool_size | 536870912 | |
smtp_out_server | smtp.uio.no | |
standby_file_management | AUTO | |
streams_pool_size | 536870912 | |
temp_undo_enabled | TRUE | |
thread | 1 | |
trace_enabled | TRUE | |
undo_retention | 14400 | |
undo_tablespace | UNDOTBS1 | |
utl_file_dir | /oaprd/bot_data, /tmp/, /oaprd/bot_data/sap |
Back to init.ora Parameters
Back to Top
init.ora Multi-Valued Parameters
- This section only displays parameters that have more than one value
- '(NULL)' indicates a missing parameter value
- A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot'
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_trail | DB | |
audit_trail | EXTENDED | |
utl_file_dir | /oaprd/bot_data | |
utl_file_dir | /oaprd/bot_data/sap | |
utl_file_dir | /tmp/ |
Back to init.ora Parameters
Back to Top
Active Session History (ASH) Report
- Top SQL with Top Events
- Top SQL with Top Row Sources
- Top Sessions
- Top Blocking Sessions
- Top PL/SQL Procedures
- Top Events
- Top Event P1/P2/P3 Values
- Top DB Objects
- Activity Over Time
Top SQL with Top Events
- Top SQL statements by DB Time along with the top events by DB Time for those SQLs.
- % Activity is the percentage of DB Time due to the SQL.
- % Event is the percentage of DB Time due to the event that the SQL is waiting on.
- % Row Source is the percentage of DB Time due to the row source for the SQL waiting on the event.
- Executions is the number of executions of the SQL that were sampled in ASH.
SQL ID | Plan Hash | Executions | % Activity | Event | % Event | Top Row Source | % Row Source | SQL Text |
---|---|---|---|---|---|---|---|---|
df7ccwkvh6886 | 1101441442 | 1 | 70.59 | CPU + Wait for CPU | 70.59 | TABLE ACCESS - BY INDEX ROWID | 36.67 | SELECT GJL.JE_HEADER_ID, GJL.J... |
bq8r44u67tf9g | 605623522 | 2 | 6.27 | db file sequential read | 4.12 | TABLE ACCESS - BY INDEX ROWID BATCHED | 2.75 | SELECT "ART", "HB_BILAGSNR" FR... |
bq8r44u67tf9g | 605623522 | 2 | 6.2745098039215686274509803921568627451 |
CPU + Wait for CPU | 1.57 | INDEX - UNIQUE SCAN | 0.78 | |
a3kxyqjurdtp8 | 1596157045 | 2 | 5.10 | db file sequential read | 4.31 | FIXED TABLE - FULL | 4.31 | insert into mgmt_db_size_gtt S... |
0kvkkju7wb8u1 | 3434282502 | 6 | 1.96 | CPU + Wait for CPU | 1.96 | TABLE ACCESS - FULL | 0.98 | SELECT DISTINCT(PPE.PROJECT_ID... |
5603s24fd1pqz | 605623522 | 2 | 1.18 | CPU + Wait for CPU | 1.18 | INDEX - UNIQUE SCAN | 0.59 | SELECT "ART", "HB_DATO" FROM "... |
Back to Active Session History (ASH) Report
Back to Top
Top SQL with Top Row Sources
- Top SQL statements by DB Time along with the top row sources by DB Time for those SQLs.
- % Activity is the percentage of DB Time due to the SQL.
- % Row Source is the percentage of DB Time spent on the row source by that SQL.
- % Event is the percentage of DB Time spent on the event by the SQL executing the row source.
- Executions is the number of executions of the SQL that were sampled in ASH.
SQL ID | Plan Hash | Executions | % Activity | Row Source | % Row Source | Top Event | % Event | SQL Text |
---|---|---|---|---|---|---|---|---|
df7ccwkvh6886 | 1101441442 | 1 | 70.59 | TABLE ACCESS - BY INDEX ROWID | 36.67 | CPU + Wait for CPU | 36.67 | SELECT GJL.JE_HEADER_ID, GJL.J... |
df7ccwkvh6886 | 1101441442 | 1 | 70.58823529411764705882352941176470588235 |
INDEX - UNIQUE SCAN | 17.25 | CPU + Wait for CPU | 17.25 | |
df7ccwkvh6886 | 1101441442 | 1 | 70.58823529411764705882352941176470588235 |
HASH JOIN | 16.27 | CPU + Wait for CPU | 16.27 | |
bq8r44u67tf9g | 605623522 | 2 | 6.27 | TABLE ACCESS - BY INDEX ROWID BATCHED | 3.73 | db file sequential read | 2.75 | SELECT "ART", "HB_BILAGSNR" FR... |
bq8r44u67tf9g | 605623522 | 2 | 6.2745098039215686274509803921568627451 |
INDEX - RANGE SCAN | 1.37 | db file sequential read | 1.37 | |
a3kxyqjurdtp8 | 1596157045 | 2 | 5.10 | FIXED TABLE - FULL | 5.10 | db file sequential read | 4.31 | insert into mgmt_db_size_gtt S... |
0kvkkju7wb8u1 | 3434282502 | 6 | 1.96 | TABLE ACCESS - FULL | 0.98 | CPU + Wait for CPU | 0.98 | SELECT DISTINCT(PPE.PROJECT_ID... |
5603s24fd1pqz | 605623522 | 2 | 1.18 | INDEX - UNIQUE SCAN | 0.59 | CPU + Wait for CPU | 0.59 | SELECT "ART", "HB_DATO" FROM "... |
Back to Active Session History (ASH) Report
Back to Top
Top Sessions
- '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
- 'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
Sid, Serial# | % Activity | Event | % Event | User | Program | # Samples Active | XIDs |
---|---|---|---|---|---|---|---|
1883,46638 | 70.59 | CPU + Wait for CPU | 70.59 | APPS | sqlplus@bot-ap...o (TNS V1-V3) | 360/361 [100%] | 1 |
3254,18353 | 8.04 | db file sequential read | 4.12 | DV_TABLEAU | oracle@dbora-d...o (TNS V1-V3) | 21/361 [ 6%] | 0 |
3254,18353 | 8.03921568627450980392156862745098039216 | CPU + Wait for CPU | 3.33 | DV_TABLEAU | oracle@dbora-d...o (TNS V1-V3) | 17/361 [ 5%] | 0 |
2134,34064 | 5.29 | CPU + Wait for CPU | 4.71 | SYS | oracle@dbora-b...uio.no (M000) | 24/361 [ 7%] | 0 |
262,35706 | 2.55 | db file sequential read | 2.16 | DBSNMP | perl@dbora-bot...o (TNS V1-V3) | 11/361 [ 3%] | 1 |
1886, 1835 | 2.55 | db file sequential read | 2.16 | DBSNMP | perl@dbora-bot...o (TNS V1-V3) | 11/361 [ 3%] | 1 |
Back to Active Session History (ASH) Report
Back to Top
Top Blocking Sessions
No data exists for this section of the report. Back to Active Session History (ASH) ReportBack to Top
Top PL/SQL Procedures
- 'PL/SQL entry subprogram' represents the application's top-level entry-point (procedure, function, trigger, package initialization or RPC call) into PL/SQL.
- 'PL/SQL current subprogram' is the PL/SQL subprogram being executed at the point of sampling . If the value is 'SQL', it represents the percentage of time spent executing SQL for the particular PL/SQL entry subprogram
PL/SQL Entry Subprogram | % Activity | PL/SQL Current Subprogram | % Current |
---|---|---|---|
APPS.UNI_OVERHEAD_PK.UNI_OH_VELG_LINJER_P | 70.59 | SQL | 70.59 |
Back to Active Session History (ASH) Report
Back to Top
Top Events
- Top Events by DB Time
- % Activity is the percentage of DB Time due to the event
Event | Event Class | Session Type | % Activity | Avg Active Sessions |
---|---|---|---|---|
CPU + Wait for CPU | CPU | FOREGROUND | 79.61 | 1.12 |
db file sequential read | User I/O | FOREGROUND | 9.02 | 0.13 |
CPU + Wait for CPU | CPU | BACKGROUND | 7.25 | 0.10 |
Back to Active Session History (ASH) Report
Back to Top
Top Event P1/P2/P3 Values
- Top Events by DB Time and the top P1/P2/P3 values for those events.
- % Event is the percentage of DB Time due to the event
- % Activity is the percentage of DB Time due to the event with the given P1,P2,P3 Values.
Event | % Event | P1, P2, P3 Values | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
db file sequential read | 9.22 | "2","30299","1" | 0.20 | file# | block# | blocks |
Back to Active Session History (ASH) Report
Back to Top
Top DB Objects
- Top DB Objects by DB Time with respect to Application, Cluster, User I/O, buffer busy waits and In-Memory DB events only.
- Tablespace name is not available for reports generated from the root PDB of a consolidated database.
Object ID | % Activity | Event | % Event | Object Name (Type) | Tablespace |
---|---|---|---|---|---|
39515 | 3.33 | db file sequential read | 2.75 | GL.GL_JE_LINES (TABLE) | APPS_TS_TX_DATA |
39518 | 1.37 | db file sequential read | 1.37 | GL.GL_JE_LINES_U1 (INDEX) | APPS_TS_TX_IDX |
Back to Active Session History (ASH) Report
Back to Top
Activity Over Time
- Analysis period is divided into smaller time slots as indicated in the 'Slot Time (Duration)'.
- Top 3 events are reported in each of those slots
- 'Slot Count' shows the number of ASH samples in that slot
- 'Event Count' shows the number of ASH samples waiting for that event in that slot
- '% Event' is 'Event Count' over all ASH samples in the analysis period
Slot Time (Duration) | Slot Count | Event | Event Count | % Event |
---|---|---|---|---|
19:00:31 (4.5 min) | 59 | CPU + Wait for CPU | 42 | 8.24 |
19:00:31 (4.5 min) | 59 | db file sequential read | 13 | 2.55 |
19:00:31 (4.5 min) | 59 | db file scattered read | 1 | 0.20 |
19:05:00 (5.0 min) | 36 | CPU + Wait for CPU | 34 | 6.67 |
19:05:00 (5.0 min) | 36 | db file sequential read | 2 | 0.39 |
19:10:00 (5.0 min) | 36 | CPU + Wait for CPU | 36 | 7.06 |
19:15:00 (5.0 min) | 34 | CPU + Wait for CPU | 32 | 6.27 |
19:15:00 (5.0 min) | 34 | SQL*Net break/reset to client | 1 | 0.20 |
19:15:00 (5.0 min) | 34 | control file sequential read | 1 | 0.20 |
19:20:00 (5.0 min) | 64 | CPU + Wait for CPU | 45 | 8.82 |
19:20:00 (5.0 min) | 64 | db file sequential read | 17 | 3.33 |
19:20:00 (5.0 min) | 64 | db file parallel read | 1 | 0.20 |
19:25:00 (5.0 min) | 39 | CPU + Wait for CPU | 33 | 6.47 |
19:25:00 (5.0 min) | 39 | db file sequential read | 4 | 0.78 |
19:25:00 (5.0 min) | 39 | db file parallel read | 1 | 0.20 |
19:30:00 (5.0 min) | 49 | CPU + Wait for CPU | 36 | 7.06 |
19:30:00 (5.0 min) | 49 | db file sequential read | 11 | 2.16 |
19:30:00 (5.0 min) | 49 | gc cr disk read | 1 | 0.20 |
19:35:00 (5.0 min) | 34 | CPU + Wait for CPU | 33 | 6.47 |
19:35:00 (5.0 min) | 34 | control file sequential read | 1 | 0.20 |
19:40:00 (5.0 min) | 38 | CPU + Wait for CPU | 38 | 7.45 |
19:45:00 (5.0 min) | 42 | CPU + Wait for CPU | 39 | 7.65 |
19:45:00 (5.0 min) | 42 | external table read | 1 | 0.20 |
19:45:00 (5.0 min) | 42 | gc current grant busy | 1 | 0.20 |
19:50:00 (5.0 min) | 39 | CPU + Wait for CPU | 38 | 7.45 |
19:50:00 (5.0 min) | 39 | external table read | 1 | 0.20 |
19:55:00 (5.0 min) | 37 | CPU + Wait for CPU | 34 | 6.67 |
19:55:00 (5.0 min) | 37 | control file sequential read | 1 | 0.20 |
19:55:00 (5.0 min) | 37 | external table read | 1 | 0.20 |
20:00:00 (44 secs) | 3 | CPU + Wait for CPU | 3 | 0.59 |
Back to Active Session History (ASH) Report
Back to Top
ADDM Task ADDM:4112780385_1_50193
Error encountered in special section 99995 ORA-13605: The specified task or object does not exist for the curren t user.Continuing to Next Section...
Back to Top
RAC Statistics
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 1.11 | 0.55 |
Global Cache blocks served: | 0.48 | 0.24 |
GCS/GES messages received: | 80.97 | 39.97 |
GCS/GES messages sent: | 208.86 | 103.10 |
DBWR Fusion writes: | 0.09 | 0.04 |
Estd Interconnect traffic (KB) | 69.33 |
Buffer access - local cache %: | 99.98 |
Buffer access - remote cache %: | 0.00 |
Buffer access - disk %: | 0.02 |
Avg global enqueue get time (ms): | 0.1 |
Avg global cache cr block receive time (ms): | 0.2 |
Avg global cache current block receive time (ms): | 0.3 |
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 %: | 8.1 |
Avg global cache cr block flush time (ms): | 0.8 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.0 |
Global cache log flushes for current blocks served %: | 2.2 |
Avg global cache current block flush time (ms): | 1.3 |
Avg message sent queue time (ms): | 11.1 |
Avg message sent queue time on ksxp (ms): | 0.2 |
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: | 46.25 |
% of indirect sent messages: | 53.68 |
% of flow controlled messages: | 0.08 |
Cluster Interconnect
- if Public/Source at End snap is different a '*' is displayed
Begin | End | ||||
---|---|---|---|---|---|
Interface | IP Address | Pub | Source | Pub | Src |
bond1:1 | 169.254.86.226 | N |
RAC Statistics
- RAC Report Summary
- Global Messaging Statistics
- Global CR Served Stats
- Global CURRENT Served Stats
- Global Cache Transfer Stats
- Interconnect Stats
- Dynamic Remastering Statistics
Back to Top
Back to Top
Global Messaging Statistics
Statistic | Total | per Second | per Trans |
---|---|---|---|
KA local message waits | 0 | 0.00 | 0.00 |
KA local messages received | 0 | 0.00 | 0.00 |
KA messages received actual | 0 | 0.00 | 0.00 |
KA messages received logical | 0 | 0.00 | 0.00 |
KA requests failed | 0 | 0.00 | 0.00 |
KA requests succeeded | 0 | 0.00 | 0.00 |
acks for commit broadcast(actual) | 700 | 0.19 | 0.10 |
acks for commit broadcast(logical) | 739 | 0.20 | 0.10 |
broadcast msgs on commit(actual) | 6,797 | 1.88 | 0.93 |
broadcast msgs on commit(logical) | 7,354 | 2.04 | 1.00 |
broadcast msgs on commit(wasted) | 251 | 0.07 | 0.03 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
flow control messages received | 12 | 0.00 | 0.00 |
flow control messages sent | 104 | 0.03 | 0.01 |
gcs apply delta | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 401 | 0.11 | 0.05 |
gcs ast xid | 0 | 0.00 | 0.00 |
gcs blocked converts | 3,813 | 1.06 | 0.52 |
gcs blocked cr converts | 1,189 | 0.33 | 0.16 |
gcs compatible basts | 8 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 230 | 0.06 | 0.03 |
gcs compatible cr basts (local) | 1,322 | 0.37 | 0.18 |
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 | 9,571 | 2.65 | 1.31 |
gcs dbwr write request msgs | 121 | 0.03 | 0.02 |
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 | 5 | 0.00 | 0.00 |
gcs force cr grant | 5 | 0.00 | 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 | 199 | 0.06 | 0.03 |
gcs immediate (null) converts | 1,650 | 0.46 | 0.23 |
gcs immediate cr (compatible) converts | 0 | 0.00 | 0.00 |
gcs immediate cr (null) converts | 970 | 0.27 | 0.13 |
gcs indirect ast | 443 | 0.12 | 0.06 |
gcs indirect bidless ast | 0 | 0.00 | 0.00 |
gcs indirect fg ast | 251 | 0.07 | 0.03 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 130 | 0.04 | 0.02 |
gcs msgs process time(ms) | 239 | 0.07 | 0.03 |
gcs msgs received | 23,752 | 6.57 | 3.25 |
gcs new served by master | 416 | 0.12 | 0.06 |
gcs out-of-order msgs | 0 | 0.00 | 0.00 |
gcs pings refused | 253 | 0.07 | 0.03 |
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 | 168 | 0.05 | 0.02 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 1 | 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 | 3,598 | 1.00 | 0.49 |
gcs side channel msgs logical | 79,632 | 22.04 | 10.88 |
gcs stale cr | 65,650 | 18.17 | 8.97 |
gcs undo cr | 0 | 0.00 | 0.00 |
gcs write notification msgs | 14 | 0.00 | 0.00 |
gcs writes refused | 2 | 0.00 | 0.00 |
ges msgs process time(ms) | 1,650 | 0.46 | 0.23 |
ges msgs received | 268,786 | 74.40 | 36.72 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 4 | 0.00 | 0.00 |
global posts queued | 14 | 0.00 | 0.00 |
global posts requested | 22 | 0.01 | 0.00 |
global posts sent | 14 | 0.00 | 0.00 |
implicit batch messages received | 697 | 0.19 | 0.10 |
implicit batch messages sent | 17,832 | 4.94 | 2.44 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 580 | 0.16 | 0.08 |
messages queue sent actual | 50,518 | 13.98 | 6.90 |
messages queue sent logical | 121,782 | 33.71 | 16.64 |
messages received actual | 288,735 | 79.92 | 39.45 |
messages received logical | 292,538 | 80.97 | 39.97 |
messages sent directly | 342,798 | 94.88 | 46.84 |
messages sent indirectly | 397,881 | 110.13 | 54.36 |
messages sent not implicit batched | 134 | 0.04 | 0.02 |
messages sent pbatched | 397,674 | 110.07 | 54.33 |
msgs causing lmd to send msgs | 0 | 0.00 | 0.00 |
msgs causing lms(s) to send msgs | 0 | 0.00 | 0.00 |
msgs received queue time (ms) | 843 | 0.23 | 0.12 |
msgs received queued | 292,538 | 80.97 | 39.97 |
msgs sent queue time (ms) | 956,705 | 264.80 | 130.72 |
msgs sent queue time on ksxp (ms) | 92,874 | 25.71 | 12.69 |
msgs sent queued | 86,416 | 23.92 | 11.81 |
msgs sent queued on ksxp | 394,234 | 109.12 | 53.86 |
number of broadcasted resources | 0 | 0.00 | 0.00 |
number of directly freed master res | 107,921 | 29.87 | 14.75 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
number of lock borrowed by LMD | 0 | 0.00 | 0.00 |
number of received ODPS messages | 0 | 0.00 | 0.00 |
number of resource borrowed by LMD | 0 | 0.00 | 0.00 |
number of sent ODPS messages | 0 | 0.00 | 0.00 |
process batch messages received | 267,527 | 74.05 | 36.55 |
process batch messages sent | 73,218 | 20.27 | 10.00 |
Back to Top
Global CR Served Stats
Statistic | Total |
---|---|
CR Block Requests | 686 |
CURRENT Block Requests | 365 |
Data Block Requests | 686 |
Undo Block Requests | 0 |
TX Block Requests | 314 |
Current Results | 1,046 |
Private results | 0 |
Zero Results | 5 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 333 |
Fairness Clears | 126 |
Free GC Elements | 0 |
Flushes | 86 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 3 |
Errors | 0 |
Back to Top
Global CURRENT Served Stats
- Pins = CURRENT Block Pin Operations
- Flushes = Redo Flush before CURRENT Block Served Operations
- Writes = CURRENT Block Fusion Write Operations
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 0 | |||||
Flushes | 15 | 86.67 | 13.33 | 0.00 | 0.00 | 0.00 |
Writes | 322 | 58.39 | 26.71 | 14.91 |
Back to Top
Global Cache Transfer Stats
- Global Cache Transfer Stats
- Global Cache Transfer Times (ms)
- Global Cache Transfer (Immediate)
- Global Cache Times (Immediate)
Global Cache Transfer Stats
- Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
- Busy (Busy) - Block Transfer impacted by Remote Contention
- Congested (Congst) - Block Transfer impacted by Remote System Load
- ordered by CR + Current Blocks Received desc
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
2 | data block | 574 | 83.62 | 16.38 | 0.00 | 3,122 | 98.72 | 1.28 | 0.00 |
2 | undo header | 171 | 98.25 | 1.75 | 0.00 | 23 | 95.65 | 4.35 | 0.00 |
2 | Others | 48 | 100.00 | 0.00 | 0.00 | 91 | 96.70 | 3.30 | 0.00 |
2 | undo block | 0 | 1 | 100.00 | 0.00 | 0.00 |
Back to Global Cache Transfer Stats
Back to Top
Global Cache Transfer Times (ms)
- Avg Time - average time of all blocks (Immed,Busy,Congst) in ms
- Immed, Busy, Congst - Average times in ms
- ordered by CR + Current Blocks Received desc
CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
2 | data block | 0.48 | 0.33 | 1.24 | 0.32 | 0.32 | 0.61 | ||
2 | undo header | 0.28 | 0.26 | 0.96 | 0.32 | 0.30 | 0.77 | ||
2 | others | 0.23 | 0.23 | 0.25 | 0.24 | 0.46 | |||
2 | undo block | 0.25 | 0.25 |
Back to Global Cache Transfer Stats
Back to Top
Global Cache Transfer (Immediate)
- Immediate (Immed) - Block Transfer NOT impacted by Remote Processing Delays
- % of Blocks Received requiring 2 or 3 hops
- ordered by CR + Current Blocks Received desc
CR | Current | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
2 | data block | 0 | 480 | 100.00 | 0.00 | 3,082 | 100.00 | 0.00 |
2 | undo header | 0 | 168 | 100.00 | 0.00 | 22 | 100.00 | 0.00 |
2 | others | 0 | 48 | 100.00 | 0.00 | 88 | 100.00 | 0.00 |
2 | undo block | 0 | 0 | 1 | 100.00 | 0.00 |
Back to Global Cache Transfer Stats
Back to Top
Global Cache Times (Immediate)
- Blocks Lost, 2-hop and 3-hop Average times in (ms)
- ordered by CR + Current Blocks Received desc
CR Avg Time (ms) | Current Avg Time (ms) | |||||||
---|---|---|---|---|---|---|---|---|
Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
2 | data block | 0.33 | 0.33 | 0.32 | 0.32 | |||
2 | undo header | 0.26 | 0.26 | 0.30 | 0.30 | |||
2 | others | 0.23 | 0.23 | 0.24 | 0.24 | |||
2 | undo block | 0.25 | 0.25 |
Back to Global Cache Transfer Stats
Back to Top
Interconnect Stats
Back to TopInterconnect Ping Latency Stats
- Ping latency of the roundtrip of a message from this instance to
- target instances.
- The target instance is identified by an instance number.
- Average and standard deviation of ping latency is given in miliseconds
- for message sizes of 500 bytes and 8K.
- Note that latency of a message from the instance to itself is used as
- control, since message latency can include wait for CPU
Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
---|---|---|---|---|---|---|
1 | 284 | 0.13 | 0.03 | 284 | 0.12 | 0.03 |
2 | 284 | 0.74 | 8.89 | 284 | 0.89 | 8.91 |
Back to Interconnect Stats
Back to Top
Interconnect Throughput by Client
- Throughput of interconnect usage by major consumers
- All throughput numbers are megabytes per second
Used By | Send Mbytes/sec | Receive Mbytes/sec |
---|---|---|
Global Cache | 0.00 | 0.01 |
Parallel Query | 0.03 | 0.03 |
DB Locks | 0.03 | 0.02 |
DB Streams | 0.00 | 0.00 |
Other | 0.01 | 0.00 |
Back to Interconnect Stats
Back to Top
Interconnect Device Statistics
- Throughput and errors of interconnect devices (at OS level)
- All throughput numbers are megabytes per second
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
bond1:1 | 169.254.86.226 | NO | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
Back to Interconnect Stats
Back to Top
Dynamic Remastering Stats
- Times are in seconds
- Affinity objects - objects mastered due to affinity at begin/end snap
- Read-mostly objects - objects mastered as they are read-mostly at begin/end snap
Name | Total | per Remaster Op | Begin Snap | End Snap |
---|---|---|---|---|
remaster ops | 688 | 1.00 | ||
remastered objects | 524 | 0.76 | ||
replayed locks received | 431,378,679 | 627,003.89 | ||
replayed locks sent | 129,438,793 | 188,137.78 | ||
resources cleaned | 0 | 0.00 | ||
remaster time (s) | 3,501.3 | 5.09 | ||
quiesce time (s) | 0.0 | 0.00 | ||
freeze time (s) | 67.4 | 0.10 | ||
cleanup time (s) | 461.7 | 0.67 | ||
replay time (s) | 552.0 | 0.80 | ||
fixwrite time (s) | 728.7 | 1.06 | ||
sync time (s) | 1,688.7 | 2.45 |
Back to Top End of Report