Using the report name awrrpt_1_112312_112313.html
DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
APPDBC | 2699934982 | appdbc1 | 1 | 10.2.0.4.0 | YES | erpdb-m9k-d00 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 112312 | 05-Dec-16 12:30:36 | 70 | 8.2 |
End Snap: | 112313 | 05-Dec-16 13:00:05 | 63 | 8.2 |
Elapsed: | 29.48 (mins) | |||
DB Time: | 4.70 (mins) |
Cache Sizes
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 22,960M | 22,960M | Std Block Size: | 8K |
Shared Pool Size: | 13,792M | 13,792M | Log Buffer: | 14,320K |
Load Profile
Per Second | Per Transaction | |
---|---|---|
Redo size: | 3,757.81 | 3,645.74 |
Logical reads: | 1,936.82 | 1,879.06 |
Block changes: | 28.06 | 27.22 |
Physical reads: | 105.44 | 102.30 |
Physical writes: | 3.71 | 3.60 |
User calls: | 10.79 | 10.47 |
Parses: | 83.05 | 80.57 |
Hard parses: | 0.14 | 0.14 |
Sorts: | 3.73 | 3.62 |
Logons: | 0.93 | 0.90 |
Executes: | 111.60 | 108.27 |
Transactions: | 1.03 |
% Blocks changed per Read: | 1.45 | Recursive Call %: | 99.44 |
Rollback per transaction %: | 98.85 | Rows per Sort: | 193.14 |
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 94.57 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.81 | Soft Parse %: | 99.83 |
Execute to Parse %: | 25.58 | Latch Hit %: | 99.99 |
Parse CPU to Parse Elapsd %: | 210.66 | % Non-Parse CPU: | 97.91 |
Shared Pool Statistics
Begin | End | |
---|---|---|
Memory Usage %: | 71.83 | 71.90 |
% SQL with executions>1: | 99.87 | 99.78 |
% Memory for SQL w/exec>1: | 99.49 | 99.30 |
Top 5 Timed Events
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
CPU time | 199 | 70.4 | |||
reliable message | 1,855 | 34 | 19 | 12.2 | Other |
db file sequential read | 123,793 | 32 | 0 | 11.4 | User I/O |
gc cr disk read | 59,558 | 23 | 0 | 8.0 | Cluster |
PX Deq: reap credit | 17,528 | 8 | 0 | 2.8 | Other |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Global Cache Load Profile
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 13.34 | 12.94 |
Global Cache blocks served: | 37.50 | 36.38 |
GCS/GES messages received: | 153.77 | 149.19 |
GCS/GES messages sent: | 113.93 | 110.53 |
DBWR Fusion writes: | 0.71 | 0.68 |
Estd Interconnect traffic (KB) | 459.00 |
Global Cache Efficiency Percentages (Target local+remote 100%)
Buffer access - local cache %: | 93.88 |
Buffer access - remote cache %: | 0.69 |
Buffer access - disk %: | 5.43 |
Global Cache and Enqueue Services - Workload Characteristics
Avg global enqueue get time (ms): | 0.0 |
Avg global cache cr block receive time (ms): | 0.5 |
Avg global cache current block receive time (ms): | 1.0 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.1 |
Global cache log flushes for cr blocks served %: | 3.3 |
Avg global cache cr block flush time (ms): | 3.3 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.1 |
Global cache log flushes for current blocks served %: | 0.0 |
Avg global cache current block flush time (ms): | 20.0 |
Global Cache and Enqueue Services - Messaging Statistics
Avg message sent queue time (ms): | 0.0 |
Avg message sent queue time on ksxp (ms): | 0.2 |
Avg message received queue time (ms): | 0.5 |
Avg GCS message process time (ms): | 0.0 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 79.80 |
% of indirect sent messages: | 18.61 |
% of flow controlled messages: | 1.58 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 283.61 | 100.50 |
DB CPU | 198.76 | 70.44 |
PL/SQL execution elapsed time | 6.84 | 2.42 |
parse time elapsed | 3.60 | 1.28 |
connection management call elapsed time | 2.30 | 0.81 |
hard parse elapsed time | 1.95 | 0.69 |
sequence load elapsed time | 0.16 | 0.06 |
PL/SQL compilation elapsed time | 0.05 | 0.02 |
failed parse elapsed time | 0.04 | 0.01 |
repeated bind elapsed time | 0.01 | 0.00 |
hard parse (sharing criteria) elapsed time | 0.01 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.00 | 0.00 |
DB time | 282.18 | |
background elapsed time | 118.97 | |
background cpu time | 63.07 |
Back to Wait Events Statistics
Back to Top
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
Other | 47,936 | 82.76 | 52 | 1 | 26.30 |
User I/O | 129,231 | 0.00 | 43 | 0 | 70.89 |
Cluster | 92,240 | 0.00 | 36 | 0 | 50.60 |
System I/O | 25,225 | 0.00 | 6 | 0 | 13.84 |
Concurrency | 459 | 0.00 | 0 | 1 | 0.25 |
Application | 487 | 0.00 | 0 | 0 | 0.27 |
Network | 19,680 | 0.00 | 0 | 0 | 10.80 |
Commit | 8 | 0.00 | 0 | 1 | 0.00 |
Configuration | 6 | 0.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
reliable message | 1,855 | 1.29 | 34 | 19 | 1.02 |
db file sequential read | 123,793 | 0.00 | 32 | 0 | 67.91 |
gc cr disk read | 59,558 | 0.00 | 23 | 0 | 32.67 |
PX Deq: reap credit | 17,528 | 97.85 | 8 | 0 | 9.61 |
gc cr multi block request | 17,527 | 0.00 | 6 | 0 | 9.61 |
db file parallel read | 2,576 | 0.00 | 6 | 2 | 1.41 |
PX Deq Credit: send blkd | 2,825 | 40.07 | 6 | 2 | 1.55 |
gc cr block 2-way | 11,013 | 0.00 | 5 | 0 | 6.04 |
control file sequential read | 19,096 | 0.00 | 5 | 0 | 10.48 |
db file scattered read | 2,312 | 0.00 | 5 | 2 | 1.27 |
gcs log flush sync | 684 | 15.94 | 2 | 3 | 0.38 |
db file parallel write | 4,854 | 0.00 | 1 | 0 | 2.66 |
gc current block 2-way | 2,058 | 0.00 | 1 | 0 | 1.13 |
enq: PS - contention | 1,174 | 0.00 | 0 | 0 | 0.64 |
control file parallel write | 679 | 0.00 | 0 | 1 | 0.37 |
wait for scn ack | 484 | 0.00 | 0 | 1 | 0.27 |
gc cr grant 2-way | 1,306 | 0.00 | 0 | 0 | 0.72 |
enq: WF - contention | 12 | 0.00 | 0 | 25 | 0.01 |
gc current grant busy | 659 | 0.00 | 0 | 0 | 0.36 |
latch free | 55 | 0.00 | 0 | 4 | 0.03 |
enq: JQ - contention | 354 | 0.00 | 0 | 1 | 0.19 |
CGS wait for IPC msg | 18,009 | 99.84 | 0 | 0 | 9.88 |
log file parallel write | 559 | 0.00 | 0 | 0 | 0.31 |
gc current block busy | 2 | 0.00 | 0 | 80 | 0.00 |
SQL*Net break/reset to client | 484 | 0.00 | 0 | 0 | 0.27 |
os thread startup | 2 | 0.00 | 0 | 70 | 0.00 |
row cache lock | 311 | 0.00 | 0 | 0 | 0.17 |
PX Deq: Signal ACK | 1,124 | 49.82 | 0 | 0 | 0.62 |
enq: TM - contention | 3 | 0.00 | 0 | 23 | 0.00 |
DFS lock handle | 187 | 0.00 | 0 | 0 | 0.10 |
log file sequential read | 19 | 0.00 | 0 | 2 | 0.01 |
enq: CF - contention | 92 | 0.00 | 0 | 0 | 0.05 |
SQL*Net more data to client | 1,605 | 0.00 | 0 | 0 | 0.88 |
ksxr poll remote instances | 3,311 | 79.10 | 0 | 0 | 1.82 |
SQL*Net more data from client | 558 | 0.00 | 0 | 0 | 0.31 |
library cache lock | 107 | 0.00 | 0 | 0 | 0.06 |
IPC send completion sync | 93 | 100.00 | 0 | 0 | 0.05 |
direct path read | 438 | 0.00 | 0 | 0 | 0.24 |
gc cr block busy | 23 | 0.00 | 0 | 1 | 0.01 |
gc cr block congested | 12 | 0.00 | 0 | 2 | 0.01 |
gc current grant 2-way | 59 | 0.00 | 0 | 0 | 0.03 |
rdbms ipc reply | 99 | 0.00 | 0 | 0 | 0.05 |
SQL*Net message to client | 15,903 | 0.00 | 0 | 0 | 8.72 |
log file sync | 8 | 0.00 | 0 | 1 | 0.00 |
library cache pin | 39 | 0.00 | 0 | 0 | 0.02 |
gc current block congested | 2 | 0.00 | 0 | 2 | 0.00 |
gc current multi block request | 20 | 0.00 | 0 | 0 | 0.01 |
direct path write | 112 | 0.00 | 0 | 0 | 0.06 |
enq: HW - contention | 6 | 0.00 | 0 | 0 | 0.00 |
enq: TA - contention | 6 | 0.00 | 0 | 0 | 0.00 |
gc cr grant congested | 1 | 0.00 | 0 | 1 | 0.00 |
Log archive I/O | 16 | 0.00 | 0 | 0 | 0.01 |
enq: SR - contention | 4 | 0.00 | 0 | 0 | 0.00 |
enq: JS - job run lock - synchronize | 2 | 0.00 | 0 | 1 | 0.00 |
SQL*Net message to dblink | 1,614 | 0.00 | 0 | 0 | 0.89 |
log file single write | 2 | 0.00 | 0 | 0 | 0.00 |
enq: FB - contention | 2 | 0.00 | 0 | 0 | 0.00 |
enq: AF - task serialization | 1 | 0.00 | 0 | 1 | 0.00 |
LGWR wait for redo copy | 23 | 0.00 | 0 | 0 | 0.01 |
enq: WL - contention | 1 | 0.00 | 0 | 0 | 0.00 |
enq: TQ - TM contention | 2 | 0.00 | 0 | 0 | 0.00 |
enq: DR - contention | 1 | 0.00 | 0 | 0 | 0.00 |
ges2 LMON to wake up LMD - mrcvr | 2 | 0.00 | 0 | 0 | 0.00 |
PX qref latch | 4 | 75.00 | 0 | 0 | 0.00 |
KJC: Wait for msg sends to complete | 2 | 0.00 | 0 | 0 | 0.00 |
SQL*Net message from client | 15,909 | 0.00 | 15,869 | 998 | 8.73 |
gcs remote message | 589,219 | 99.51 | 13,797 | 23 | 323.21 |
jobq slave wait | 4,557 | 45.25 | 10,313 | 2263 | 2.50 |
Streams AQ: qmn slave idle wait | 962 | 0.00 | 5,178 | 5382 | 0.53 |
wait for unread message on broadcast channel | 3,803 | 82.54 | 3,323 | 874 | 2.09 |
PX Idle Wait | 1,678 | 63.83 | 3,314 | 1975 | 0.92 |
Streams AQ: waiting for time management or cleanup tasks | 11 | 45.45 | 1,758 | 159805 | 0.01 |
Streams AQ: waiting for messages in the queue | 183 | 96.72 | 1,729 | 9446 | 0.10 |
virtual circuit status | 59 | 100.00 | 1,729 | 29297 | 0.03 |
DIAG idle wait | 8,833 | 0.00 | 1,727 | 196 | 4.85 |
ges remote message | 28,184 | 94.64 | 1,726 | 61 | 15.46 |
Streams AQ: qmn coordinator idle wait | 742 | 41.11 | 1,726 | 2326 | 0.41 |
SQL*Net message from dblink | 1,615 | 0.00 | 1,378 | 853 | 0.89 |
PX Deq: Join ACK | 1,711 | 34.02 | 108 | 63 | 0.94 |
PX Deq: Execution Msg | 3,039 | 2.83 | 69 | 23 | 1.67 |
PX Deq: Parse Reply | 1,623 | 32.96 | 0 | 0 | 0.89 |
PX Deq: Execute Reply | 1,200 | 22.75 | 0 | 0 | 0.66 |
PX Deq: Msg Fragment | 148 | 41.22 | 0 | 0 | 0.08 |
Streams AQ: RAC qmn coordinator idle wait | 744 | 98.52 | 0 | 0 | 0.41 |
class slave wait | 2 | 0.00 | 0 | 1 | 0.00 |
Back to Wait Events Statistics
Back to Top
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
events in waitclass Other | 23,120 | 89.84 | 35 | 2 | 12.68 |
db file sequential read | 44,355 | 0.00 | 11 | 0 | 24.33 |
gc cr disk read | 20,670 | 0.00 | 8 | 0 | 11.34 |
control file sequential read | 4,924 | 0.00 | 2 | 0 | 2.70 |
db file parallel write | 4,854 | 0.00 | 1 | 0 | 2.66 |
gc cr block 2-way | 1,162 | 0.00 | 1 | 0 | 0.64 |
control file parallel write | 675 | 0.00 | 0 | 1 | 0.37 |
log file parallel write | 559 | 0.00 | 0 | 0 | 0.31 |
gc cr grant 2-way | 750 | 0.00 | 0 | 0 | 0.41 |
os thread startup | 2 | 0.00 | 0 | 70 | 0.00 |
enq: TM - contention | 2 | 0.00 | 0 | 34 | 0.00 |
gc current block 2-way | 114 | 0.00 | 0 | 1 | 0.06 |
row cache lock | 112 | 0.00 | 0 | 0 | 0.06 |
log file sequential read | 19 | 0.00 | 0 | 2 | 0.01 |
gc current grant busy | 14 | 0.00 | 0 | 0 | 0.01 |
gc current grant 2-way | 13 | 0.00 | 0 | 0 | 0.01 |
enq: HW - contention | 6 | 0.00 | 0 | 0 | 0.00 |
gc cr block congested | 1 | 0.00 | 0 | 2 | 0.00 |
library cache lock | 7 | 0.00 | 0 | 0 | 0.00 |
direct path write | 110 | 0.00 | 0 | 0 | 0.06 |
Log archive I/O | 16 | 0.00 | 0 | 0 | 0.01 |
gc current multi block request | 7 | 0.00 | 0 | 0 | 0.00 |
direct path read | 412 | 0.00 | 0 | 0 | 0.23 |
log file single write | 2 | 0.00 | 0 | 0 | 0.00 |
rdbms ipc message | 33,225 | 82.79 | 27,616 | 831 | 18.23 |
gcs remote message | 589,232 | 99.51 | 13,797 | 23 | 323.22 |
Streams AQ: qmn slave idle wait | 962 | 0.00 | 5,178 | 5382 | 0.53 |
Streams AQ: waiting for time management or cleanup tasks | 11 | 45.45 | 1,758 | 159805 | 0.01 |
smon timer | 8 | 0.00 | 1,728 | 215986 | 0.00 |
DIAG idle wait | 8,833 | 0.00 | 1,727 | 196 | 4.85 |
ges remote message | 28,184 | 94.64 | 1,726 | 61 | 15.46 |
Streams AQ: qmn coordinator idle wait | 742 | 41.11 | 1,726 | 2326 | 0.41 |
pmon timer | 603 | 100.00 | 1,726 | 2862 | 0.33 |
Streams AQ: RAC qmn coordinator idle wait | 744 | 98.52 | 0 | 0 | 0.41 |
PX Deq: Join ACK | 4 | 50.00 | 0 | 1 | 0.00 |
PX Deq: Parse Reply | 4 | 50.00 | 0 | 1 | 0.00 |
PX Deq: Execute Reply | 4 | 50.00 | 0 | 0 | 0.00 |
Back to Wait Events Statistics
Back to Top
Statistic | Total |
---|---|
AVG_BUSY_TIME | 3,754 |
AVG_IDLE_TIME | 173,049 |
AVG_IOWAIT_TIME | 0 |
AVG_SYS_TIME | 1,411 |
AVG_USER_TIME | 2,279 |
BUSY_TIME | 121,987 |
IDLE_TIME | 5,539,317 |
IOWAIT_TIME | 0 |
SYS_TIME | 47,200 |
USER_TIME | 74,787 |
LOAD | 1 |
OS_CPU_WAIT_TIME | 39,500 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 13,205,504 |
VM_OUT_BYTES | 0 |
PHYSICAL_MEMORY_BYTES | 67,462,922,240 |
NUM_CPUS | 32 |
Back to Wait Events Statistics
Back to Top
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
---|---|---|---|---|
SYS$USERS | 274.50 | 191.60 | 140,632 | 2,708,490 |
appdbc | 5.90 | 5.30 | 1 | 293,414 |
hrms | 1.80 | 1.80 | 0 | 120,160 |
SYS$BACKGROUND | 0.00 | 0.00 | 44,812 | 293,204 |
SYS.KUPC$C_1_20161115174523 | 0.00 | 0.00 | 0 | 0 |
SYS.KUPC$C_1_20161115182328 | 0.00 | 0.00 | 0 | 0 |
SYS.KUPC$C_1_20161124101927 | 0.00 | 0.00 | 0 | 0 |
SYS.KUPC$C_1_20161124103225 | 0.00 | 0.00 | 0 | 0 |
SYS.KUPC$S_1_20161115174523 | 0.00 | 0.00 | 0 | 0 |
SYS.KUPC$S_1_20161115182328 | 0.00 | 0.00 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
SYS$USERS | 84046 | 3154 | 338 | 8 | 0 | 0 | 16172 | 2 |
appdbc | 1 | 0 | 0 | 0 | 0 | 0 | 1435 | 3 |
hrms | 0 | 0 | 0 | 0 | 0 | 0 | 243 | 0 |
SYS$BACKGROUND | 45174 | 1094 | 122 | 20 | 0 | 0 | 0 | 0 |
Back to Wait Events Statistics
Back to Top
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
77 | 77 | 1 | 77.02 | 27.29 | 23gzmzdtbb8w5 | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select sql_text, sql_id from ... |
67 | 37 | 6 | 11.14 | 23.70 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
27 | 27 | 45,529 | 0.00 | 9.63 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
26 | 11 | 1 | 25.79 | 9.14 | 0n1r5m24q9dvv | DECLARE job BINARY_INTEGER := ... | |
24 | 11 | 0 | 8.50 | 69atchvk0ukpy | ude@erpdb-m9k-d00 (TNS V1-V3) | BEGIN SYS.DBMS_DATAPUMP.A... | |
24 | 11 | 566 | 0.04 | 8.46 | afcz9s4uazbpk | ude@erpdb-m9k-d00 (TNS V1-V3) | BEGIN :1 := sys.kupc$que_int.t... |
23 | 8 | 1 | 22.51 | 7.98 | 4ct5wkrsqmsd3 | INSERT INTO GDPLANET.TMP_NOCON... | |
18 | 5 | 566 | 0.03 | 6.20 | gn74qsy7sv4z4 | ude@erpdb-m9k-d00 (TNS V1-V3) | SELECT COUNT(*) FROM gv$datapu... |
10 | 8 | 1 | 9.73 | 3.45 | 3u9c9mju3f3rp | DECLARE job BINARY_INTEGER := ... | |
6 | 5 | 1 | 5.85 | 2.07 | 9rx424vd77t3k | oracle@m8000-1 (TNS V1-V3) | SELECT /*+ OPAQUE_TRANSFORM */... |
6 | 4 | 1 | 5.79 | 2.05 | 48xp06cu8zahx | INSERT INTO GDPLANET.TMP_HASCO... | |
4 | 4 | 142,287 | 0.00 | 1.53 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
4 | 3 | 1 | 3.75 | 1.33 | fbspbft2c3gds | INSERT INTO GDPLANET.TMP_NOCON... | |
4 | 3 | 1 | 3.75 | 1.33 | 572fbaj0fdw2b | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select output from table(dbms_... |
3 | 3 | 1 | 3.20 | 1.13 | 3y7a5dzq7ttvu | INSERT INTO GDPLANET.TMP_HASCO... | |
3 | 3 | 0 | 1.10 | 5nsbr19rcb6hr | DECLARE job BINARY_INTEGER := ... |
Back to SQL Statistics
Back to Top
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
77 | 77 | 1 | 77.02 | 27.29 | 23gzmzdtbb8w5 | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select sql_text, sql_id from ... |
37 | 67 | 6 | 6.11 | 23.70 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
27 | 27 | 45,529 | 0.00 | 9.63 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
11 | 26 | 1 | 11.33 | 9.14 | 0n1r5m24q9dvv | DECLARE job BINARY_INTEGER := ... | |
11 | 24 | 566 | 0.02 | 8.46 | afcz9s4uazbpk | ude@erpdb-m9k-d00 (TNS V1-V3) | BEGIN :1 := sys.kupc$que_int.t... |
11 | 24 | 0 | 8.50 | 69atchvk0ukpy | ude@erpdb-m9k-d00 (TNS V1-V3) | BEGIN SYS.DBMS_DATAPUMP.A... | |
8 | 23 | 1 | 8.25 | 7.98 | 4ct5wkrsqmsd3 | INSERT INTO GDPLANET.TMP_NOCON... | |
8 | 10 | 1 | 7.59 | 3.45 | 3u9c9mju3f3rp | DECLARE job BINARY_INTEGER := ... | |
5 | 6 | 1 | 5.31 | 2.07 | 9rx424vd77t3k | oracle@m8000-1 (TNS V1-V3) | SELECT /*+ OPAQUE_TRANSFORM */... |
5 | 18 | 566 | 0.01 | 6.20 | gn74qsy7sv4z4 | ude@erpdb-m9k-d00 (TNS V1-V3) | SELECT COUNT(*) FROM gv$datapu... |
4 | 4 | 142,287 | 0.00 | 1.53 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
4 | 6 | 1 | 4.10 | 2.05 | 48xp06cu8zahx | INSERT INTO GDPLANET.TMP_HASCO... | |
3 | 4 | 1 | 3.40 | 1.33 | fbspbft2c3gds | INSERT INTO GDPLANET.TMP_NOCON... | |
3 | 3 | 1 | 3.07 | 1.13 | 3y7a5dzq7ttvu | INSERT INTO GDPLANET.TMP_HASCO... | |
3 | 3 | 0 | 1.10 | 5nsbr19rcb6hr | DECLARE job BINARY_INTEGER := ... | ||
3 | 4 | 1 | 2.77 | 1.33 | 572fbaj0fdw2b | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select output from table(dbms_... |
Back to SQL Statistics
Back to Top
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
1,411,296 | 6 | 235,216.00 | 41.20 | 36.66 | 66.87 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
502,419 | 1 | 502,419.00 | 14.67 | 11.33 | 25.79 | 0n1r5m24q9dvv | DECLARE job BINARY_INTEGER := ... | |
497,425 | 1 | 497,425.00 | 14.52 | 7.59 | 9.73 | 3u9c9mju3f3rp | DECLARE job BINARY_INTEGER := ... | |
426,861 | 142,287 | 3.00 | 12.46 | 4.30 | 4.30 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
293,397 | 1 | 293,397.00 | 8.57 | 5.31 | 5.85 | 9rx424vd77t3k | oracle@m8000-1 (TNS V1-V3) | SELECT /*+ OPAQUE_TRANSFORM */... |
284,528 | 1 | 284,528.00 | 8.31 | 8.25 | 22.51 | 4ct5wkrsqmsd3 | INSERT INTO GDPLANET.TMP_NOCON... | |
277,105 | 1 | 277,105.00 | 8.09 | 4.10 | 5.79 | 48xp06cu8zahx | INSERT INTO GDPLANET.TMP_HASCO... | |
216,913 | 1 | 216,913.00 | 6.33 | 3.07 | 3.20 | 3y7a5dzq7ttvu | INSERT INTO GDPLANET.TMP_HASCO... | |
213,105 | 1 | 213,105.00 | 6.22 | 3.40 | 3.75 | fbspbft2c3gds | INSERT INTO GDPLANET.TMP_NOCON... | |
198,952 | 0 | 5.81 | 2.82 | 3.10 | 5nsbr19rcb6hr | DECLARE job BINARY_INTEGER := ... | ||
197,277 | 45,529 | 4.33 | 5.76 | 27.02 | 27.16 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
134,113 | 1 | 134,113.00 | 3.92 | 2.77 | 3.75 | 572fbaj0fdw2b | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select output from table(dbms_... |
112,348 | 1 | 112,348.00 | 3.28 | 1.14 | 1.14 | bd502nbh9abbs | plsqldev.exe | select s.synonym_name object_n... |
96,476 | 6 | 16,079.33 | 2.82 | 1.32 | 2.42 | bnafqqprpz3u1 | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select tablespace_name, use_pr... |
Back to SQL Statistics
Back to Top
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
78,107 | 6 | 13,017.83 | 41.88 | 36.66 | 66.87 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
61,215 | 1 | 61,215.00 | 32.82 | 11.33 | 25.79 | 0n1r5m24q9dvv | DECLARE job BINARY_INTEGER := ... | |
61,185 | 1 | 61,185.00 | 32.81 | 8.25 | 22.51 | 4ct5wkrsqmsd3 | INSERT INTO GDPLANET.TMP_NOCON... | |
42,616 | 45,529 | 0.94 | 22.85 | 27.02 | 27.16 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
1,745 | 1 | 1,745.00 | 0.94 | 0.20 | 0.98 | b7jn4mf49n569 | select o.name, u.name from ob... | |
586 | 1 | 586.00 | 0.31 | 7.59 | 9.73 | 3u9c9mju3f3rp | DECLARE job BINARY_INTEGER := ... | |
574 | 1 | 574.00 | 0.31 | 2.77 | 3.75 | 572fbaj0fdw2b | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select output from table(dbms_... |
336 | 1 | 336.00 | 0.18 | 4.10 | 5.79 | 48xp06cu8zahx | INSERT INTO GDPLANET.TMP_HASCO... | |
121 | 536 | 0.23 | 0.06 | 0.06 | 0.06 | grwydz59pu6mc | select text from view$ where r... | |
82 | 0 | 0.04 | 2.82 | 3.10 | 5nsbr19rcb6hr | DECLARE job BINARY_INTEGER := ... |
Back to SQL Statistics
Back to Top
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
142,287 | 142,287 | 1.00 | 0.00 | 0.00 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
45,529 | 0 | 0.00 | 0.00 | 0.00 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
1,313 | 39 | 0.03 | 0.00 | 0.00 | 0h6b2sajwb74n | select privilege#, level from ... | |
635 | 1,270 | 2.00 | 0.00 | 0.00 | 05uqdabhzncdc | select role# from defrole$ d, ... | |
631 | 631 | 1.00 | 0.00 | 0.00 | 3f751tsaf2j02 | JDBC Thin Client | SELECT VALUE FROM NLS_INSTANCE... |
566 | 0 | 0.00 | 0.02 | 0.04 | afcz9s4uazbpk | ude@erpdb-m9k-d00 (TNS V1-V3) | BEGIN :1 := sys.kupc$que_int.t... |
566 | 566 | 1.00 | 0.01 | 0.03 | gn74qsy7sv4z4 | ude@erpdb-m9k-d00 (TNS V1-V3) | SELECT COUNT(*) FROM gv$datapu... |
536 | 536 | 1.00 | 0.00 | 0.00 | grwydz59pu6mc | select text from view$ where r... | |
500 | 4,285 | 8.57 | 0.00 | 0.00 | bsa0wjtftg3uw | select file# from file$ where ... | |
378 | 371 | 0.98 | 0.00 | 0.00 | 3c1kubcdjnppq | update sys.col_usage$ set eq... |
Back to SQL Statistics
Back to Top
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
142,287 | 142,287 | 96.87 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
1,313 | 1,313 | 0.89 | 0h6b2sajwb74n | select privilege#, level from ... | |
635 | 635 | 0.43 | 05uqdabhzncdc | select role# from defrole$ d, ... | |
631 | 631 | 0.43 | 3f751tsaf2j02 | JDBC Thin Client | SELECT VALUE FROM NLS_INSTANCE... |
566 | 566 | 0.39 | gn74qsy7sv4z4 | ude@erpdb-m9k-d00 (TNS V1-V3) | SELECT COUNT(*) FROM gv$datapu... |
536 | 536 | 0.36 | grwydz59pu6mc | select text from view$ where r... | |
500 | 500 | 0.34 | bsa0wjtftg3uw | select file# from file$ where ... | |
356 | 3 | 0.24 | 47a50dvdgnxc2 | update sys.job$ set failures=0... | |
356 | 356 | 0.24 | a1mbfp580hw3k | select u1.user#, u2.user#, u... | |
356 | 2 | 0.24 | aq8yqxyyb40nn | update sys.job$ set this_date=... |
Back to SQL Statistics
Back to Top
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
6,671,607 | 6 | 0.05 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
2,582,054 | 1 | 0.02 | bd502nbh9abbs | plsqldev.exe | select s.synonym_name object_n... |
2,564,673 | 1 | 0.02 | 31a13pnjps7j3 | SELECT source, (case w... | |
2,226,039 | 6 | 0.02 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
1,706,102 | 1 | 0.01 | 8vkjh60z1g287 | select OBJOID, CLSOID, RUNT... | |
1,610,967 | 1 | 0.01 | 8f1sjvfxuup9w | PL/SQL Developer | select t.*, o.*, m.comments ... |
1,550,054 | 1 | 0.01 | bd502nbh9abbs | plsqldev.exe | select s.synonym_name object_n... |
1,545,581 | 1 | 0.01 | 42b67jvy5ux34 | PL/SQL Developer | select col.*, com.Comments fr... |
1,295,798 | 1 | 0.01 | 91k4w10zgrg4m | plsqldev.exe | select object_name, object_ty... |
1,262,390 | 1 | 0.01 | 91k4w10zgrg4m | plsqldev.exe | select object_name, object_ty... |
1,109,167 | 1 | 0.01 | 8f1sjvfxuup9w | PL/SQL Developer | select t.*, o.*, m.comments ... |
Back to SQL Statistics
Back to Top
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
25 | 1 | 14566d856s6hs | SELECT owner# FROM sys.wri$_ad... | |
23 | 1 | 298ppdduqr7wm | SELECT status FROM sys.wri$_ad... | |
23 | 1 | gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri... | |
21 | 2 | 10xj8nynmpqtq | SELECT dbin.db_name, dbin.ins... |
Back to SQL Statistics
Back to Top
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
17.12 | 25.60 | 66.87 | 36.66 | 6 | 0yt1b8mbz63nk | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | SELECT e.owner, e.segment_typ... |
8.22 | 30.25 | 27.16 | 27.02 | 45,529 | 37k9g8mgfh7h8 | select 1 from x$ktfbue where k... | |
6.72 | 26.05 | 25.79 | 11.33 | 1 | 0n1r5m24q9dvv | DECLARE job BINARY_INTEGER := ... | |
6.47 | 28.74 | 22.51 | 8.25 | 1 | 4ct5wkrsqmsd3 | INSERT INTO GDPLANET.TMP_NOCON... | |
1.48 | 15.17 | 9.73 | 7.59 | 1 | 3u9c9mju3f3rp | DECLARE job BINARY_INTEGER := ... | |
1.07 | 18.41 | 5.79 | 4.10 | 1 | 48xp06cu8zahx | INSERT INTO GDPLANET.TMP_HASCO... | |
0.72 | 12.36 | 5.85 | 5.31 | 1 | 9rx424vd77t3k | oracle@m8000-1 (TNS V1-V3) | SELECT /*+ OPAQUE_TRANSFORM */... |
0.66 | 45.29 | 1.45 | 0.77 | 1 | 3v9c56u115sq3 | DECLARE job BINARY_INTEGER := ... | |
0.39 | 10.46 | 3.75 | 3.40 | 1 | fbspbft2c3gds | INSERT INTO GDPLANET.TMP_NOCON... | |
0.25 | 7.69 | 3.20 | 3.07 | 1 | 3y7a5dzq7ttvu | INSERT INTO GDPLANET.TMP_HASCO... | |
0.18 | 18.56 | 0.98 | 0.20 | 1 | b7jn4mf49n569 | select o.name, u.name from ob... | |
0.14 | 3.87 | 3.75 | 2.77 | 1 | 572fbaj0fdw2b | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select output from table(dbms_... |
0.04 | 7.71 | 0.54 | 0.52 | 2 | 5fjy338yh5p6p | PL/SQL Developer | select * from FBP_VENDORS w ... |
0.03 | 1.07 | 3.10 | 2.82 | 0 | 5nsbr19rcb6hr | DECLARE job BINARY_INTEGER := ... | |
0.03 | 1.11 | 2.42 | 1.32 | 6 | bnafqqprpz3u1 | sqlplus@erpdb-m9k-d00 (TNS V1-V3) | select tablespace_name, use_pr... |
0.01 | 26.32 | 0.05 | 0.05 | 378 | 3c1kubcdjnppq | update sys.col_usage$ set eq... | |
0.01 | 40.03 | 0.02 | 0.02 | 3 | c7sn076yz7030 | select smontabv.cnt, smontab.... | |
0.01 | 10.43 | 0.05 | 0.01 | 1 | g6wf9na8zs5hb | insert into wrh$_sysmetric_sum... | |
0.01 | 0.47 | 1.14 | 1.14 | 1 | 84qubbrsr0kfn | insert into wrh$_latch (snap... | |
0.01 | 0.77 | 0.66 | 0.66 | 635 | 05uqdabhzncdc | select role# from defrole$ d, ... |
Back to SQL Statistics
Back to Top
Back to SQL Statistics
Back to Top
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 19,567 | 11.06 | 10.73 |
CPU used when call started | 14,131 | 7.99 | 7.75 |
CR blocks created | 621 | 0.35 | 0.34 |
Cached Commit SCN referenced | 75,964 | 42.95 | 41.67 |
Commit SCN cached | 7 | 0.00 | 0.00 |
DB time | 1,279,143 | 723.24 | 701.67 |
DBWR checkpoint buffers written | 5,203 | 2.94 | 2.85 |
DBWR checkpoints | 1 | 0.00 | 0.00 |
DBWR fusion writes | 1,248 | 0.71 | 0.68 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR parallel query checkpoint buffers written | 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 | 26 | 0.01 | 0.01 |
DBWR undo block writes | 576 | 0.33 | 0.32 |
DDL statements parallelized | 0 | 0.00 | 0.00 |
DFO trees parallelized | 570 | 0.32 | 0.31 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
PX local messages recv'd | 3,408 | 1.93 | 1.87 |
PX local messages sent | 3,408 | 1.93 | 1.87 |
PX remote messages recv'd | 1,277 | 0.72 | 0.70 |
PX remote messages sent | 2,360 | 1.33 | 1.29 |
Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 570 | 0.32 | 0.31 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 4 | 0.00 | 0.00 |
RowCR hits | 11 | 0.01 | 0.01 |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
SMON posted for instance recovery | 0 | 0.00 | 0.00 |
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 | 14,068 | 7.95 | 7.72 |
SQL*Net roundtrips to/from dblink | 1,478 | 0.84 | 0.81 |
active txn count during cleanout | 417 | 0.24 | 0.23 |
application wait time | 23 | 0.01 | 0.01 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 8,031 | 4.54 | 4.41 |
branch node splits | 1 | 0.00 | 0.00 |
buffer is not pinned count | 1,096,243 | 619.83 | 601.34 |
buffer is pinned count | 1,039,961 | 588.00 | 570.47 |
bytes received via SQL*Net from client | 1,941,860 | 1,097.95 | 1,065.20 |
bytes received via SQL*Net from dblink | 324,363 | 183.40 | 177.93 |
bytes sent via SQL*Net to client | 4,290,343 | 2,425.80 | 2,353.45 |
bytes sent via SQL*Net to dblink | 152,091 | 85.99 | 83.43 |
calls to get snapshot scn: kcmgss | 493,356 | 278.95 | 270.63 |
calls to kcmgas | 144,053 | 81.45 | 79.02 |
calls to kcmgcs | 308 | 0.17 | 0.17 |
change write time | 13 | 0.01 | 0.01 |
cleanout - number of ktugct calls | 898 | 0.51 | 0.49 |
cleanouts and rollbacks - consistent read gets | 200 | 0.11 | 0.11 |
cleanouts only - consistent read gets | 463 | 0.26 | 0.25 |
cluster key scan block gets | 508,808 | 287.68 | 279.10 |
cluster key scans | 327,527 | 185.19 | 179.66 |
cluster wait time | 3,578 | 2.02 | 1.96 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 0 | 0.00 | 0.00 |
commit batch/immediate requested | 0 | 0.00 | 0.00 |
commit cleanout failures: block lost | 21 | 0.01 | 0.01 |
commit cleanout failures: callback failure | 5 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 0 | 0.00 | 0.00 |
commit cleanouts | 3,513 | 1.99 | 1.93 |
commit cleanouts successfully completed | 3,487 | 1.97 | 1.91 |
commit immediate performed | 0 | 0.00 | 0.00 |
commit immediate requested | 0 | 0.00 | 0.00 |
commit txn count during cleanout | 1,145 | 0.65 | 0.63 |
concurrency wait time | 27 | 0.02 | 0.01 |
consistent changes | 27,568 | 15.59 | 15.12 |
consistent gets | 3,295,422 | 1,863.26 | 1,807.69 |
consistent gets - examination | 677,488 | 383.06 | 371.63 |
consistent gets direct | 26 | 0.01 | 0.01 |
consistent gets from cache | 3,295,396 | 1,863.25 | 1,807.68 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 7 | 0.00 | 0.00 |
data blocks consistent reads - undo records applied | 716 | 0.40 | 0.39 |
db block changes | 49,623 | 28.06 | 27.22 |
db block gets | 130,111 | 73.57 | 71.37 |
db block gets direct | 20 | 0.01 | 0.01 |
db block gets from cache | 130,091 | 73.55 | 71.36 |
deferred (CURRENT) block cleanout applications | 1,159 | 0.66 | 0.64 |
dirty buffers inspected | 1 | 0.00 | 0.00 |
enqueue conversions | 7,049 | 3.99 | 3.87 |
enqueue releases | 195,836 | 110.73 | 107.43 |
enqueue requests | 195,905 | 110.77 | 107.46 |
enqueue timeouts | 76 | 0.04 | 0.04 |
enqueue waits | 1,659 | 0.94 | 0.91 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 197,378 | 111.60 | 108.27 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
free buffer inspected | 87,489 | 49.47 | 47.99 |
free buffer requested | 217,121 | 122.76 | 119.10 |
gc CPU used by this session | 4,293 | 2.43 | 2.35 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 26 | 0.01 | 0.01 |
gc cr block flush time | 205 | 0.12 | 0.11 |
gc cr block receive time | 558 | 0.32 | 0.31 |
gc cr block send time | 142 | 0.08 | 0.08 |
gc cr blocks received | 11,480 | 6.49 | 6.30 |
gc cr blocks served | 18,887 | 10.68 | 10.36 |
gc current block flush time | 2 | 0.00 | 0.00 |
gc current block pin time | 42 | 0.02 | 0.02 |
gc current block receive time | 1,216 | 0.69 | 0.67 |
gc current block send time | 327 | 0.18 | 0.18 |
gc current blocks received | 12,117 | 6.85 | 6.65 |
gc current blocks served | 47,432 | 26.82 | 26.02 |
gc local grants | 63,126 | 35.69 | 34.63 |
gc remote grants | 123,831 | 70.02 | 67.93 |
gcs messages sent | 194,741 | 110.11 | 106.82 |
ges messages sent | 6,753 | 3.82 | 3.70 |
global enqueue get time | 244 | 0.14 | 0.13 |
global enqueue gets async | 354 | 0.20 | 0.19 |
global enqueue gets sync | 158,557 | 89.65 | 86.98 |
global enqueue releases | 155,982 | 88.19 | 85.56 |
heap block compress | 218 | 0.12 | 0.12 |
hot buffers moved to head of LRU | 277 | 0.16 | 0.15 |
immediate (CR) block cleanout applications | 663 | 0.37 | 0.36 |
immediate (CURRENT) block cleanout applications | 160 | 0.09 | 0.09 |
index crx upgrade (found) | 0 | 0.00 | 0.00 |
index crx upgrade (positioned) | 2,270 | 1.28 | 1.25 |
index fast full scans (full) | 1 | 0.00 | 0.00 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 711,660 | 402.38 | 390.38 |
index scans kdiixs1 | 45,990 | 26.00 | 25.23 |
leaf node 90-10 splits | 6 | 0.00 | 0.00 |
leaf node splits | 37 | 0.02 | 0.02 |
lob reads | 4,157 | 2.35 | 2.28 |
lob writes | 6,886 | 3.89 | 3.78 |
lob writes unaligned | 6,886 | 3.89 | 3.78 |
logons cumulative | 1,648 | 0.93 | 0.90 |
messages received | 7,241 | 4.09 | 3.97 |
messages sent | 7,209 | 4.08 | 3.95 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 2,280,524 | 1,289.43 | 1,250.97 |
opened cursors cumulative | 147,770 | 83.55 | 81.06 |
parse count (failures) | 61 | 0.03 | 0.03 |
parse count (hard) | 253 | 0.14 | 0.14 |
parse count (total) | 146,882 | 83.05 | 80.57 |
parse time cpu | 415 | 0.23 | 0.23 |
parse time elapsed | 197 | 0.11 | 0.11 |
physical read IO requests | 157,214 | 88.89 | 86.24 |
physical read bytes | 1,527,742,464 | 863,799.93 | 838,037.56 |
physical read total IO requests | 176,579 | 99.84 | 96.86 |
physical read total bytes | 1,857,969,664 | 1,050,513.48 | 1,019,182.48 |
physical read total multi block requests | 2,327 | 1.32 | 1.28 |
physical reads | 186,492 | 105.44 | 102.30 |
physical reads cache | 186,054 | 105.20 | 102.06 |
physical reads cache prefetch | 56,590 | 32.00 | 31.04 |
physical reads direct | 438 | 0.25 | 0.24 |
physical reads direct (lob) | 26 | 0.01 | 0.01 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 5,097 | 2.88 | 2.80 |
physical write bytes | 53,714,944 | 30,370.93 | 29,465.14 |
physical write total IO requests | 7,708 | 4.36 | 4.23 |
physical write total bytes | 109,344,256 | 61,824.27 | 59,980.39 |
physical write total multi block requests | 893 | 0.50 | 0.49 |
physical writes | 6,557 | 3.71 | 3.60 |
physical writes direct | 130 | 0.07 | 0.07 |
physical writes direct (lob) | 0 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 6,427 | 3.63 | 3.53 |
physical writes non checkpoint | 4,810 | 2.72 | 2.64 |
pinned buffers inspected | 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 | 3 | 0.00 | 0.00 |
queries parallelized | 569 | 0.32 | 0.31 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 3,384,209 | 1,913.46 | 1,856.40 |
recursive cpu usage | 5,875 | 3.32 | 3.22 |
redo blocks written | 13,566 | 7.67 | 7.44 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 17,680 | 10.00 | 9.70 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 376 | 0.21 | 0.21 |
redo size | 6,646,180 | 3,757.81 | 3,645.74 |
redo subscn max counts | 155 | 0.09 | 0.09 |
redo synch time | 1 | 0.00 | 0.00 |
redo synch writes | 10 | 0.01 | 0.01 |
redo wastage | 165,368 | 93.50 | 90.71 |
redo write time | 25 | 0.01 | 0.01 |
redo writer latching time | 0 | 0.00 | 0.00 |
redo writes | 554 | 0.31 | 0.30 |
rollback changes - undo records applied | 0 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 61 | 0.03 | 0.03 |
rows fetched via callback | 206,282 | 116.63 | 113.16 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 140,759 | 79.59 | 77.21 |
session logical reads | 3,425,522 | 1,936.82 | 1,879.06 |
session pga memory | 77,317,986,440 | 43,716,315.14 | 42,412,499.42 |
session pga memory max | 78,188,746,216 | 44,208,650.89 | 42,890,151.52 |
session uga memory | 17,229,560,752 | 9,741,755.34 | 9,451,212.70 |
session uga memory max | 690,572,240 | 390,456.03 | 378,810.88 |
shared hash latch upgrades - no wait | 2,779 | 1.57 | 1.52 |
shared hash latch upgrades - wait | 0 | 0.00 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 6,603 | 3.73 | 3.62 |
sorts (rows) | 1,275,301 | 721.07 | 699.56 |
sql area evicted | 0 | 0.00 | 0.00 |
sql area purged | 61 | 0.03 | 0.03 |
summed dirty queue length | 1 | 0.00 | 0.00 |
switch current to new buffer | 119 | 0.07 | 0.07 |
table fetch by rowid | 435,304 | 246.12 | 238.78 |
table fetch continued row | 902 | 0.51 | 0.49 |
table scan blocks gotten | 1,545,014 | 873.57 | 847.51 |
table scan rows gotten | 48,157,093 | 27,228.47 | 26,416.40 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 1 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 63,787 | 36.07 | 34.99 |
total number of times SMON posted | 8 | 0.00 | 0.00 |
transaction lock background gets | 0 | 0.00 | 0.00 |
transaction lock foreground requests | 0 | 0.00 | 0.00 |
transaction lock foreground wait time | 0 | 0.00 | 0.00 |
transaction rollbacks | 0 | 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 | 2,786,716 | 1,575.64 | 1,528.64 |
user I/O wait time | 4,336 | 2.45 | 2.38 |
user calls | 19,084 | 10.79 | 10.47 |
user commits | 21 | 0.01 | 0.01 |
user rollbacks | 1,802 | 1.02 | 0.99 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 4,323 | 2.44 | 2.37 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |
Back to Instance Activity Statistics
Back to Top
Statistic | Begin Value | End Value |
---|---|---|
session cursor cache count | 6,136,505 | 6,141,869 |
opened cursors current | 571 | 519 |
workarea memory allocated | 1,595 | 4,778 |
logons current | 70 | 63 |
Back to Instance Activity Statistics
Back to Top
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 1 | 2.04 |
Back to Instance Activity Statistics
Back to Top
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
EAS_DATA | 71,318 | 40 | 0.23 | 1.00 | 3,449 | 2 | 0 | 0.00 |
EAS_DATA_NEW | 33,127 | 19 | 1.15 | 1.87 | 726 | 0 | 0 | 0.00 |
USERS | 19,300 | 11 | 0.29 | 1.00 | 3 | 0 | 0 | 0.00 |
SYSAUX | 10,218 | 6 | 0.30 | 1.02 | 331 | 0 | 0 | 0.00 |
SYSTEM | 8,405 | 5 | 0.29 | 1.00 | 19 | 0 | 0 | 0.00 |
DAT_EPM | 6,848 | 4 | 0.24 | 1.03 | 44 | 0 | 0 | 0.00 |
EPM_GD_DATA | 2,224 | 1 | 0.22 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_PAMS | 992 | 1 | 0.21 | 1.00 | 3 | 0 | 0 | 0.00 |
AUDIT_DATA | 917 | 1 | 0.24 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_IND | 350 | 0 | 0.77 | 1.00 | 369 | 0 | 0 | 0.00 |
DAT_EVSAS | 536 | 0 | 0.28 | 1.00 | 18 | 0 | 0 | 0.00 |
EIP_DATA | 348 | 0 | 0.20 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_PAMS | 287 | 0 | 0.24 | 1.00 | 1 | 0 | 0 | 0.00 |
MOB_DATA | 186 | 0 | 0.27 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | 90 | 0 | 0.00 | 1.00 | 20 | 0 | 0 | 0.00 |
UNDOTBS1 | 5 | 0 | 0.00 | 1.00 | 95 | 0 | 0 | 0.00 |
TDEIP_DATA | 96 | 0 | 0.10 | 1.00 | 0 | 0 | 0 | 0.00 |
SIED | 23 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
IDX_HRMS | 19 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
LISAPP_DAT | 16 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | 11 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SALARY_DATA | 6 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
LISAPP_IDX | 6 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_IND | 6 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
MOB_IDX | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SALARY_IDX | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
EIP_IND | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_EVSAS | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SIEX | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|---|
AUDIT_DATA | /dev/vx/rdsk/racdg/datafile69 | 917 | 1 | 0.24 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EPM | /dev/vx/rdsk/racdg/datafile304 | 127 | 0 | 0.79 | 1.98 | 27 | 0 | 0 | 0.00 |
DAT_EPM | /dev/vx/rdsk/racdg/datafile52 | 3,399 | 2 | 0.20 | 1.00 | 2 | 0 | 0 | 0.00 |
DAT_EPM | /dev/vx/rdsk/racdg/datafile53 | 3,322 | 2 | 0.26 | 1.02 | 15 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile103 | 7 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile109 | 17 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile333 | 21 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile36 | 254 | 0 | 0.35 | 1.00 | 2 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile37 | 55 | 0 | 0.36 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile373 | 10 | 0 | 1.00 | 1.00 | 9 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile374 | 19 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile38 | 13 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile388 | 15 | 0 | 0.67 | 1.00 | 2 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile72 | 29 | 0 | 0.34 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile81 | 84 | 0 | 0.12 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_EVSAS | /dev/vx/rdsk/racdg/datafile82 | 12 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile101 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile102 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile107 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile112 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile118 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile12 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile13 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile138 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile14 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile15 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile16 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile17 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile359 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile360 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile361 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile362 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile363 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile364 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile365 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile366 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile367 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile368 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile369 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile370 | 12 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile371 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile372 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile54 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile67 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile68 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile70 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile73 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile74 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile78 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile79 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile80 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile83 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile84 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile92 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile93 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile94 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_HRMS | /dev/vx/rdsk/racdg/datafile95 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DAT_PAMS | /dev/vx/rdsk/racdg/datafile27 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_PAMS | /dev/vx/rdsk/racdg/datafile28 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DAT_PAMS | /dev/vx/rdsk/racdg/datafile29 | 988 | 1 | 0.21 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile01 | 2,254 | 1 | 0.22 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile05 | 1,502 | 1 | 0.19 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile07 | 1,757 | 1 | 0.28 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile08 | 6,805 | 4 | 0.19 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile09 | 1,770 | 1 | 0.19 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile10 | 4,894 | 3 | 0.24 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile100 | 823 | 0 | 0.19 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile104 | 2,714 | 2 | 0.18 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile108 | 711 | 0 | 0.23 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile11 | 2,892 | 2 | 0.23 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile113 | 253 | 0 | 0.12 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile116 | 108 | 0 | 0.28 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile119 | 82 | 0 | 0.61 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile120 | 28 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile121 | 55 | 0 | 0.55 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile122 | 29 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile123 | 14 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile124 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile125 | 80 | 0 | 0.13 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile126 | 14 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile127 | 496 | 0 | 0.14 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile128 | 41 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile129 | 124 | 0 | 0.24 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile130 | 54 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile132 | 56 | 0 | 0.18 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile133 | 28 | 0 | 0.36 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile134 | 40 | 0 | 0.50 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile135 | 14 | 0 | 0.71 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile136 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile137 | 28 | 0 | 1.07 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile300 | 39 | 0 | 0.51 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile301 | 40 | 0 | 0.25 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile302 | 65 | 0 | 0.15 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile303 | 65 | 0 | 0.92 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile306 | 26 | 0 | 0.38 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile307 | 1,397 | 1 | 0.21 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile308 | 482 | 0 | 0.27 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile309 | 208 | 0 | 0.34 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile310 | 382 | 0 | 0.24 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile311 | 248 | 0 | 0.24 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile312 | 105 | 0 | 0.38 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile313 | 621 | 0 | 0.34 | 1.00 | 4 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile314 | 313 | 0 | 0.13 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile315 | 414 | 0 | 0.22 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile316 | 747 | 0 | 0.21 | 1.00 | 5 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile317 | 500 | 0 | 0.20 | 1.00 | 10 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile318 | 379 | 0 | 0.42 | 1.00 | 7 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile319 | 1,941 | 1 | 0.24 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile320 | 2,083 | 1 | 0.22 | 1.00 | 12 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile321 | 1,316 | 1 | 0.31 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile334 | 2,863 | 2 | 0.29 | 1.00 | 7 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile335 | 1,523 | 1 | 0.27 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile336 | 1,354 | 1 | 0.24 | 1.00 | 9 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile340 | 573 | 0 | 0.21 | 1.00 | 3 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile343 | 536 | 0 | 0.22 | 1.00 | 16 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile344 | 617 | 0 | 0.31 | 1.00 | 46 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile345 | 210 | 0 | 0.19 | 1.00 | 31 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile346 | 2,054 | 1 | 0.27 | 1.00 | 19 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile347 | 808 | 0 | 0.25 | 1.00 | 12 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile348 | 656 | 0 | 0.20 | 1.00 | 50 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile349 | 353 | 0 | 0.31 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile350 | 404 | 0 | 0.25 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile351 | 209 | 0 | 0.10 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile352 | 105 | 0 | 0.29 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile353 | 40 | 0 | 0.25 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile354 | 14 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile355 | 5,611 | 3 | 0.20 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile356 | 53 | 0 | 0.75 | 1.00 | 523 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile357 | 105 | 0 | 0.29 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile358 | 131 | 0 | 0.46 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile377 | 196 | 0 | 0.10 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile383 | 1,847 | 1 | 0.24 | 1.00 | 729 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile384 | 831 | 0 | 0.16 | 1.00 | 600 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile385 | 620 | 0 | 0.27 | 1.00 | 767 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile386 | 263 | 0 | 0.19 | 1.00 | 563 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile390 | 250 | 0 | 0.16 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile391 | 29 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile392 | 3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile55 | 1,692 | 1 | 0.23 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile75 | 1,225 | 1 | 0.20 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile76 | 1,127 | 1 | 0.21 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile87 | 2,441 | 1 | 0.20 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile88 | 1,291 | 1 | 0.29 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA | /dev/vx/rdsk/racdg/datafile99 | 2,245 | 1 | 0.23 | 1.00 | 0 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile409 | 1,635 | 1 | 0.62 | 1.88 | 2 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile410 | 1,435 | 1 | 0.93 | 2.21 | 9 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile411 | 1,374 | 1 | 0.74 | 2.27 | 16 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile412 | 1,634 | 1 | 0.78 | 1.91 | 16 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile413 | 1,595 | 1 | 0.72 | 1.96 | 18 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile414 | 1,684 | 1 | 1.19 | 1.89 | 43 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile415 | 1,777 | 1 | 1.22 | 1.75 | 60 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile416 | 1,620 | 1 | 1.25 | 1.93 | 7 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile417 | 1,566 | 1 | 1.63 | 1.88 | 6 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile418 | 1,518 | 1 | 1.37 | 1.82 | 159 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile419 | 1,628 | 1 | 0.68 | 1.62 | 20 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile420 | 1,804 | 1 | 1.23 | 1.75 | 37 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile421 | 2,001 | 1 | 1.27 | 1.61 | 25 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile422 | 1,885 | 1 | 1.25 | 1.67 | 220 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile423 | 1,927 | 1 | 1.42 | 1.74 | 24 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile424 | 1,698 | 1 | 1.27 | 1.86 | 4 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile425 | 1,651 | 1 | 1.25 | 1.94 | 35 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile426 | 1,724 | 1 | 1.60 | 1.81 | 15 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile427 | 1,436 | 1 | 1.23 | 2.18 | 8 | 0 | 0 | 0.00 |
EAS_DATA_NEW | /dev/vx/rdsk/racdg/datafile428 | 1,535 | 1 | 1.24 | 2.06 | 2 | 0 | 0 | 0.00 |
EAS_IND | /dev/vx/rdsk/racdg/datafile02 | 162 | 0 | 0.62 | 1.00 | 82 | 0 | 0 | 0.00 |
EAS_IND | /dev/vx/rdsk/racdg/datafile06 | 188 | 0 | 0.90 | 1.00 | 287 | 0 | 0 | 0.00 |
EIP_DATA | /dev/vx/rdsk/racdg/datafile03 | 348 | 0 | 0.20 | 1.00 | 1 | 0 | 0 | 0.00 |
EIP_IND | /dev/vx/rdsk/racdg/datafile04 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
EPM_GD_DATA | /dev/vx/rdsk/racdg/datafile378 | 2,224 | 1 | 0.22 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_EVSAS | /dev/vx/rdsk/racdg/datafile39 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile110 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile18 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile19 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile20 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile375 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile387 | 3 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile77 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile85 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_HRMS | /dev/vx/rdsk/racdg/datafile86 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_PAMS | /dev/vx/rdsk/racdg/datafile26 | 287 | 0 | 0.24 | 1.00 | 1 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile44 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile45 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile46 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile47 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile48 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile49 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile50 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_DAT | /dev/vx/rdsk/racdg/datafile51 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_IDX | /dev/vx/rdsk/racdg/datafile40 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_IDX | /dev/vx/rdsk/racdg/datafile42 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
LISAPP_IDX | /dev/vx/rdsk/racdg/datafile43 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
MOB_DATA | /dev/vx/rdsk/racdg/datafile31 | 186 | 0 | 0.27 | 1.00 | 1 | 0 | 0 | 0.00 |
MOB_IDX | /dev/vx/rdsk/racdg/datafile30 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SALARY_DATA | /dev/vx/rdsk/racdg/datafile33 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SALARY_DATA | /dev/vx/rdsk/racdg/datafile34 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SALARY_DATA | /dev/vx/rdsk/racdg/datafile35 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SALARY_IDX | /dev/vx/rdsk/racdg/datafile32 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SIED | /dev/vx/rdsk/racdg/datafile23 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SIED | /dev/vx/rdsk/racdg/datafile25 | 22 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SIEX | /dev/vx/rdsk/racdg/datafile24 | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile105 | 28 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile111 | 63 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile131 | 6 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile22 | 80 | 0 | 2.13 | 1.30 | 77 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile331 | 0 | 0 | 2 | 0 | 0 | 0.00 | ||
SYSAUX | /dev/vx/rdsk/racdg/datafile56 | 27 | 0 | 2.96 | 1.00 | 41 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile71 | 12 | 0 | 2.50 | 1.00 | 13 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile89 | 14 | 0 | 2.86 | 1.00 | 35 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/datafile90 | 112 | 0 | 0.09 | 1.00 | 5 | 0 | 0 | 0.00 |
SYSAUX | /dev/vx/rdsk/racdg/sysaux01 | 9,876 | 6 | 0.28 | 1.01 | 153 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/appdbc_system03 | 53 | 0 | 0.19 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/datafile328 | 330 | 0 | 0.27 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/datafile341 | 114 | 0 | 0.61 | 1.00 | 1 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/datafile97 | 47 | 0 | 0.21 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/datafile98 | 3 | 0 | 3.33 | 1.00 | 0 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/system01 | 7,808 | 4 | 0.29 | 1.00 | 18 | 0 | 0 | 0.00 |
SYSTEM | /dev/vx/rdsk/racdg/system02 | 50 | 0 | 0.40 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_DATA | /dev/vx/rdsk/racdg/datafile57 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_DATA | /dev/vx/rdsk/racdg/datafile58 | 90 | 0 | 0.11 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_DATA | /dev/vx/rdsk/racdg/datafile59 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_DATA | /dev/vx/rdsk/racdg/datafile60 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_IND | /dev/vx/rdsk/racdg/datafile61 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_IND | /dev/vx/rdsk/racdg/datafile62 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
TDEIP_IND | /dev/vx/rdsk/racdg/datafile63 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS1 | /dev/vx/rdsk/racdg/datafile381 | 2 | 0 | 0.00 | 1.00 | 68 | 0 | 0 | 0.00 |
UNDOTBS1 | /dev/vx/rdsk/racdg/undotbs01a | 1 | 0 | 0.00 | 1.00 | 27 | 0 | 0 | 0.00 |
UNDOTBS1 | /dev/vx/rdsk/racdg/undotbs01c | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/datafile380 | 2 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/datafile64 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/datafile65 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/datafile66 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/undotbs02a | 1 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/vx/rdsk/racdg/undotbs02b | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile106 | 1,403 | 1 | 0.33 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile115 | 757 | 0 | 0.18 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile117 | 2,548 | 1 | 0.26 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile139 | 580 | 0 | 0.29 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile21 | 770 | 0 | 0.31 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile330 | 4,186 | 2 | 0.27 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile342 | 1,782 | 1 | 0.39 | 1.00 | 1 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile382 | 636 | 0 | 0.52 | 1.00 | 1 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile91 | 150 | 0 | 0.27 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/datafile96 | 3,021 | 2 | 0.30 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/vx/rdsk/racdg/users01 | 3,467 | 2 | 0.24 | 1.00 | 1 | 0 | 0 | 0.00 |
P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
---|---|---|---|---|---|---|---|---|
D | 2,753,762 | 95 | 3,424,557 | 185,968 | 6,427 | 0 | 0 | 0 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks | |
---|---|---|---|---|---|---|---|---|
B | 0 | 1 | 5009 | 8977 | 16324 | 2147310 | 16324 | |
E | 0 | 0 | 378 | 2066 | 21152 | 2147310 | 21152 |
Back to Advisory Statistics
Back to Top
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,288 | 0.10 | 274,417 | 5.24 | 1,087,091,722 |
D | 4,576 | 0.20 | 548,834 | 3.05 | 632,974,955 |
D | 6,864 | 0.30 | 823,251 | 1.63 | 338,249,821 |
D | 9,152 | 0.40 | 1,097,668 | 1.30 | 270,480,178 |
D | 11,440 | 0.50 | 1,372,085 | 1.21 | 250,314,830 |
D | 13,728 | 0.60 | 1,646,502 | 1.14 | 237,321,184 |
D | 16,016 | 0.70 | 1,920,919 | 1.10 | 228,436,249 |
D | 18,304 | 0.80 | 2,195,336 | 1.06 | 219,079,506 |
D | 20,592 | 0.90 | 2,469,753 | 1.03 | 212,966,940 |
D | 22,880 | 1.00 | 2,744,170 | 1.00 | 207,421,455 |
D | 22,960 | 1.00 | 2,753,765 | 1.00 | 207,294,006 |
D | 25,168 | 1.10 | 3,018,587 | 0.98 | 202,581,446 |
D | 27,456 | 1.20 | 3,293,004 | 0.96 | 199,882,165 |
D | 29,744 | 1.30 | 3,567,421 | 0.95 | 197,892,683 |
D | 32,032 | 1.40 | 3,841,838 | 0.95 | 196,539,016 |
D | 34,320 | 1.49 | 4,116,255 | 0.94 | 195,758,246 |
D | 36,608 | 1.59 | 4,390,672 | 0.94 | 195,125,830 |
D | 38,896 | 1.69 | 4,665,089 | 0.94 | 194,175,058 |
D | 41,184 | 1.79 | 4,939,506 | 0.93 | 192,677,601 |
D | 43,472 | 1.89 | 5,213,923 | 0.90 | 187,524,067 |
D | 45,760 | 1.99 | 5,488,340 | 0.82 | 169,186,459 |
Back to Advisory Statistics
Back to Top
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 515 | 0 |
Back to Advisory Statistics
Back to Top
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 | 4,096 | 1,392 | 3,001.37 | 1.56 | 0.05 | 100.00 | 0.00 | 419,430 |
E | 4,096 | 1,437 | 2,792.71 | 4.67 | 0.17 | 100.00 | 0.00 | 419,430 |
Back to Advisory Statistics
Back to Top
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 3,756 | 3,756 | 0 | 0 |
64K | 128K | 40 | 40 | 0 | 0 |
128K | 256K | 10 | 10 | 0 | 0 |
256K | 512K | 2 | 2 | 0 | 0 |
512K | 1024K | 434 | 434 | 0 | 0 |
1M | 2M | 62 | 62 | 0 | 0 |
2M | 4M | 10 | 10 | 0 | 0 |
4M | 8M | 9 | 9 | 0 | 0 |
Back to Advisory Statistics
Back to Top
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 |
---|---|---|---|---|---|
512 | 0.13 | 16,019,824.34 | 952,754.52 | 94.00 | 12,086 |
1,024 | 0.25 | 16,019,824.34 | 855,797.29 | 95.00 | 10,990 |
2,048 | 0.50 | 16,019,824.34 | 250,497.78 | 98.00 | 2,965 |
3,072 | 0.75 | 16,019,824.34 | 29,596.26 | 100.00 | 0 |
4,096 | 1.00 | 16,019,824.34 | 29,596.26 | 100.00 | 0 |
4,915 | 1.20 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
5,734 | 1.40 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
6,554 | 1.60 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
7,373 | 1.80 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
8,192 | 2.00 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
12,288 | 3.00 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
16,384 | 4.00 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
24,576 | 6.00 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
32,768 | 8.00 | 16,019,824.34 | 24,239.42 | 100.00 | 0 |
Back to Advisory Statistics
Back to Top
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 |
---|---|---|---|---|---|---|---|---|
2,672 | 0.19 | 1,484 | 60,912 | 6,811,842 | 0.99 | 81,404 | 4.84 | 860,414,311 |
4,064 | 0.29 | 2,873 | 78,960 | 6,857,275 | 1.00 | 35,971 | 2.14 | 860,551,047 |
5,456 | 0.40 | 4,262 | 115,445 | 6,870,856 | 1.00 | 22,390 | 1.33 | 860,600,337 |
6,848 | 0.50 | 5,650 | 130,282 | 6,874,264 | 1.00 | 18,982 | 1.13 | 860,607,157 |
8,240 | 0.60 | 7,031 | 196,419 | 6,876,429 | 1.00 | 16,817 | 1.00 | 860,609,665 |
9,632 | 0.70 | 8,407 | 242,333 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,227 |
11,024 | 0.80 | 8,940 | 258,554 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,259 |
12,416 | 0.90 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
13,808 | 1.00 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
15,200 | 1.10 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
16,592 | 1.20 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
17,984 | 1.30 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
19,376 | 1.40 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
20,768 | 1.50 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
22,160 | 1.60 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
23,552 | 1.71 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
24,944 | 1.81 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
26,336 | 1.91 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
27,728 | 2.01 | 9,041 | 266,178 | 6,876,439 | 1.00 | 16,807 | 1.00 | 860,610,285 |
Back to Advisory Statistics
Back to Top
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
9,216 | 0.25 | 1,048,965 | 663,032,161 |
18,432 | 0.50 | 900,018 | 262,198,894 |
27,648 | 0.75 | 887,085 | 229,488,809 |
36,864 | 1.00 | 879,783 | 207,288,239 |
46,080 | 1.25 | 878,463 | 203,391,220 |
55,296 | 1.50 | 869,841 | 177,210,716 |
64,512 | 1.75 | 869,841 | 177,210,716 |
73,728 | 2.00 | 869,841 | 177,210,716 |
Back to Advisory Statistics
Back to Top
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 1.00 | 0 | 0 | 0 | 0 |
32 | 2.00 | 0 | 0 | 0 | 0 |
48 | 3.00 | 0 | 0 | 0 | 0 |
64 | 4.00 | 0 | 0 | 0 | 0 |
80 | 5.00 | 0 | 0 | 0 | 0 |
96 | 6.00 | 0 | 0 | 0 | 0 |
112 | 7.00 | 0 | 0 | 0 | 0 |
128 | 8.00 | 0 | 0 | 0 | 0 |
144 | 9.00 | 0 | 0 | 0 | 0 |
160 | 10.00 | 0 | 0 | 0 | 0 |
176 | 11.00 | 0 | 0 | 0 | 0 |
192 | 12.00 | 0 | 0 | 0 | 0 |
208 | 13.00 | 0 | 0 | 0 | 0 |
224 | 14.00 | 0 | 0 | 0 | 0 |
240 | 15.00 | 0 | 0 | 0 | 0 |
256 | 16.00 | 0 | 0 | 0 | 0 |
272 | 17.00 | 0 | 0 | 0 | 0 |
288 | 18.00 | 0 | 0 | 0 | 0 |
304 | 19.00 | 0 | 0 | 0 | 0 |
320 | 20.00 | 0 | 0 | 0 | 0 |
Back to Advisory Statistics
Back to Top
No data exists for this section of the report.
Back to Advisory Statistics
Back to Top
No data exists for this section of the report.
Back to Wait Statistics
Back to Top
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
PS-PX Process Reservation | 4,084 | 4,014 | 70 | 1,173 | 0 | 0.39 |
WF-AWR Flush | 20 | 20 | 0 | 12 | 0 | 25.75 |
JQ-Job Queue | 367 | 361 | 6 | 354 | 0 | 0.73 |
TM-DML | 1,904 | 1,904 | 0 | 3 | 0 | 23.00 |
CF-Controlfile Transaction | 4,227 | 4,227 | 0 | 92 | 0 | 0.62 |
HW-Segment High Water Mark | 1,275 | 1,275 | 0 | 6 | 0 | 0.50 |
TA-Instance Undo | 6 | 6 | 0 | 6 | 0 | 0.50 |
TQ-Queue table enqueue (TM contention) | 2 | 2 | 0 | 2 | 0 | 1.00 |
SR-Synchronized Replication | 1,592 | 1,592 | 0 | 4 | 0 | 0.25 |
FB-Format Block | 3 | 3 | 0 | 2 | 0 | 0.50 |
JS-Job Scheduler (job run lock - synchronize) | 2 | 2 | 0 | 2 | 0 | 0.50 |
AF-Advisor Framework (task serialization) | 7 | 7 | 0 | 1 | 0 | 0.00 |
DR-Distributed Recovery | 1 | 1 | 0 | 1 | 0 | 0.00 |
WL-Being Written Redo Log | 1 | 1 | 0 | 1 | 0 | 0.00 |
Back to Wait Statistics
Back to Top
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 |
---|---|---|---|---|---|---|---|
1 | 0.75 | 818 | 2,695 | 5 | 5760/5760 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
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 |
---|---|---|---|---|---|---|---|
05-Dec 13:08 | 211 | 222 | 2,695 | 4 | 5,760 | 0/0 | 0/0/0/0/0/0 |
05-Dec 12:58 | 0 | 3 | 2,094 | 1 | 5,760 | 0/0 | 0/0/0/0/0/0 |
05-Dec 12:48 | 244 | 102 | 1,491 | 4 | 5,760 | 0/0 | 0/0/0/0/0/0 |
05-Dec 12:38 | 298 | 491 | 1,458 | 5 | 5,760 | 0/0 | 0/0/0/0/0/0 |
Back to Undo Statistics
Back to Top
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
ASM db client latch | 1,185 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 12,407 | 0.00 | 0 | 0 | ||
Consistent RBA | 554 | 0.00 | 0 | 0 | ||
FAL request queue | 37 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 37 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 6 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 3,101 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 405 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 405 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 353 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 2 | 0.00 | 0 | 0 | ||
JS queue access latch | 2 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 36,286 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 6 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 1,354,786 | 0.00 | 0.00 | 0 | 225 | 0.00 |
KJC message pool free list | 6,742 | 0.06 | 0.00 | 0 | 2,662 | 0.00 |
KJCT flow control latch | 213,184 | 0.00 | 0 | 0 | ||
KMG MMAN ready and startup request latch | 589 | 0.00 | 0 | 0 | ||
KSXR large replies | 120 | 0.00 | 0 | 0 | ||
KTF sga latch | 6 | 0.00 | 0 | 466 | 0.00 | |
KWQMN job cache list latch | 761 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 201 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 35 | 0.00 | ||
Memory Management Latch | 0 | 0 | 589 | 0.00 | ||
Memory Queue | 4,179 | 0.00 | 0 | 0 | ||
Memory Queue Subscriber | 566 | 0.00 | 0 | 0 | ||
OS process | 2,106 | 0.00 | 0 | 0 | ||
OS process allocation | 1,986 | 0.00 | 0 | 0 | ||
OS process: request allocation | 1,389 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 1,894 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 2,312 | 0.04 | 0.00 | 0 | 2,312 | 0.00 |
SQL memory manager latch | 1 | 0.00 | 0 | 589 | 0.00 | |
SQL memory manager workarea list latch | 42,476 | 0.00 | 0 | 0 | ||
Shared B-Tree | 10,602 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 8,082 | 0.01 | 0.00 | 0 | 0 | |
active service list | 13,773 | 0.02 | 0.00 | 0 | 603 | 0.00 |
archive control | 34 | 0.00 | 0 | 0 | ||
archive process latch | 665 | 0.00 | 0 | 0 | ||
begin backup scn array | 2 | 0.00 | 0 | 0 | ||
bq:time manger info latch | 520 | 0.00 | 0 | 0 | ||
bufq statistics | 1,630 | 0.00 | 0 | 0 | ||
business card | 1,140 | 0.00 | 0 | 0 | ||
cache buffer handles | 4,045 | 0.00 | 0 | 0 | ||
cache buffers chains | 6,875,638 | 0.00 | 0.00 | 0 | 968,388 | 0.00 |
cache buffers lru chain | 109,824 | 0.00 | 0.00 | 0 | 482,974 | 0.01 |
cache table scan latch | 0 | 0 | 2,312 | 0.00 | ||
channel handle pool latch | 1,393 | 0.00 | 0 | 0 | ||
channel operations parent latch | 157,080 | 0.01 | 0.00 | 0 | 0 | |
checkpoint queue latch | 260,389 | 0.00 | 0 | 1,966 | 0.00 | |
client/application info | 6,510 | 0.00 | 0 | 0 | ||
commit callback allocation | 8 | 0.00 | 0 | 0 | ||
compile environment latch | 1,648 | 0.00 | 0 | 0 | ||
datapump attach fixed tables latch | 1,655 | 0.00 | 0 | 0 | ||
datapump job fixed tables latch | 1,655 | 0.00 | 0 | 0 | ||
dml lock allocation | 3,838 | 0.00 | 0 | 0 | ||
dummy allocation | 3,303 | 0.00 | 0 | 0 | ||
enqueue hash chains | 689,402 | 0.00 | 0.00 | 0 | 166 | 0.00 |
enqueues | 389,834 | 0.01 | 0.00 | 0 | 0 | |
error message lists | 581 | 0.00 | 0 | 0 | ||
event group latch | 691 | 0.00 | 0 | 0 | ||
file cache latch | 1,598 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 41,906 | 0.05 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 4,296,542 | 0.00 | 0 | 0 | ||
gcs remaster request queue | 3 | 0.00 | 0 | 0 | ||
gcs remastering latch | 1,473,858 | 0.00 | 0 | 0 | ||
gcs resource freelist | 91,445 | 0.02 | 0.00 | 0 | 13,732 | 0.23 |
gcs resource hash | 1,358,004 | 0.01 | 0.00 | 0 | 6 | 0.00 |
gcs resource scan list | 12 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 35,263 | 0.00 | 0 | 34,188 | 0.00 | |
ges caches resource lists | 85,775 | 0.06 | 0.00 | 0 | 24,168 | 0.02 |
ges deadlock list | 216 | 0.00 | 0 | 1 | 0.00 | |
ges domain table | 310,053 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 313,250 | 0.00 | 0 | 0 | ||
ges group table | 467,238 | 0.00 | 0 | 0 | ||
ges process hash list | 10,521 | 0.00 | 0 | 0 | ||
ges process parent latch | 629,880 | 0.00 | 0 | 0 | ||
ges process table freelist | 1,389 | 0.00 | 0 | 0 | ||
ges resource hash list | 479,883 | 0.16 | 0.00 | 0 | 5,868 | 0.00 |
ges resource scan list | 26 | 0.00 | 0 | 0 | ||
ges resource table freelist | 9,347 | 0.00 | 0 | 0 | ||
ges synchronous data | 32 | 0.00 | 0 | 773 | 0.39 | |
ges timeout list | 1,592 | 0.00 | 0 | 1,218 | 0.00 | |
global KZLD latch for mem in SGA | 636 | 0.00 | 0 | 0 | ||
global tx hash mapping | 4,081 | 0.00 | 0 | 0 | ||
hash table column usage latch | 110 | 0.00 | 0 | 27,172 | 0.00 | |
hash table modification latch | 30 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 714 | 0.00 | ||
job_queue_processes parameter latch | 383 | 0.00 | 0 | 0 | ||
kks stats | 240 | 0.00 | 0 | 0 | ||
kokc descriptor allocation latch | 244 | 0.00 | 0 | 0 | ||
krbmrosl | 15 | 0.00 | 0 | 0 | ||
ksuosstats global area | 120 | 0.00 | 0 | 0 | ||
ktm global data | 8 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 4,750 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 1,238 | 0.00 | 0 | 0 | ||
library cache | 111,983 | 0.19 | 0.00 | 0 | 3 | 0.00 |
library cache load lock | 180 | 0.00 | 0 | 0 | ||
library cache lock | 62,357 | 0.31 | 0.00 | 0 | 0 | |
library cache lock allocation | 1,668 | 0.00 | 0 | 0 | ||
library cache pin | 34,001 | 0.17 | 0.00 | 0 | 0 | |
library cache pin allocation | 168 | 0.00 | 0 | 0 | ||
list of block allocation | 219 | 0.00 | 0 | 0 | ||
loader state object freelist | 126 | 0.00 | 0 | 0 | ||
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 1 | 0.00 | 0 | 1 | 0.00 | |
message pool operations parent latch | 3,923 | 0.00 | 0 | 0 | ||
messages | 79,749 | 0.01 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 1,244 | 0.08 | 0.00 | 0 | 0 | |
multiblock read objects | 16,354 | 0.01 | 0.00 | 0 | 0 | |
name-service memory objects | 4,528 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 22,286 | 0.00 | 0 | 0 | ||
name-service pending queue | 736 | 0.00 | 0 | 0 | ||
name-service request queue | 19,906 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 29 | 0.00 | 0 | 0 | ||
object queue header heap | 118,689 | 0.00 | 0 | 85,288 | 0.00 | |
object queue header operation | 590,205 | 0.00 | 0.00 | 0 | 0 | |
object stats modification | 4 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 10,726 | 0.00 | 0 | 0 | ||
parallel query stats | 1,743 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 7,866 | 0.00 | 0 | 0 | ||
parameter list | 223 | 0.00 | 0 | 0 | ||
parameter table allocation management | 1,666 | 0.00 | 0 | 0 | ||
post/wait queue | 936 | 0.00 | 0 | 695 | 0.00 | |
process allocation | 20,117 | 0.07 | 0.93 | 0 | 691 | 0.00 |
process group creation | 1,389 | 0.00 | 0 | 0 | ||
process queue | 6,350 | 0.00 | 0 | 0 | ||
process queue reference | 105,973 | 0.01 | 0.00 | 0 | 9,320 | 0.04 |
qmn task queue latch | 2,274 | 31.40 | 0.06 | 0 | 0 | |
query server freelists | 5,186 | 0.00 | 0 | 0 | ||
queue sender's info. latch | 7,752 | 1.10 | 0.00 | 0 | 0 | |
queued dump request | 8,832 | 0.00 | 0 | 0 | ||
redo allocation | 3,039 | 0.00 | 0 | 17,550 | 0.01 | |
redo copy | 0 | 0 | 17,550 | 0.13 | ||
redo writing | 10,982 | 0.00 | 0 | 0 | ||
resmgr group change latch | 1,944 | 0.00 | 0 | 0 | ||
resmgr:active threads | 3,300 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 1,291 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 3,299 | 0.03 | 0.00 | 0 | 0 | |
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
row cache objects | 656,260 | 0.01 | 0.00 | 0 | 0 | |
rules engine aggregate statistics | 2 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 104 | 0.00 | 0 | 0 | ||
sequence cache | 2,245 | 0.00 | 0 | 0 | ||
session allocation | 45,760 | 0.03 | 0.00 | 0 | 0 | |
session idle bit | 43,652 | 0.00 | 0 | 0 | ||
session state list latch | 3,326 | 0.06 | 0.00 | 0 | 0 | |
session switching | 29 | 0.00 | 0 | 0 | ||
session timer | 603 | 0.00 | 0 | 0 | ||
shared pool | 80,318 | 0.00 | 0.00 | 0 | 0 | |
shared pool sim alloc | 14 | 0.00 | 0 | 0 | ||
shared pool simulator | 338,540 | 0.00 | 0.00 | 0 | 0 | |
simulator hash latch | 200,296 | 0.00 | 0 | 0 | ||
simulator lru latch | 0 | 0 | 191,324 | 0.01 | ||
slave class | 2 | 0.00 | 0 | 0 | ||
slave class create | 8 | 12.50 | 1.00 | 0 | 0 | |
sort extent pool | 87 | 0.00 | 0 | 0 | ||
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 8,820 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
threshold alerts latch | 247 | 0.00 | 0 | 0 | ||
transaction allocation | 5,532,970 | 0.00 | 0 | 0 | ||
transaction branch allocation | 626 | 0.00 | 0 | 0 | ||
undo global data | 62,414 | 0.00 | 0 | 0 | ||
user lock | 2,556 | 0.00 | 0 | 0 |
Back to Latch Statistics
Back to Top
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
qmn task queue latch | 2,274 | 714 | 40 | 674 | 0 | 0 | 0 |
process allocation | 20,117 | 15 | 14 | 1 | 0 | 0 | 0 |
slave class create | 8 | 1 | 1 | 0 | 0 | 0 | 0 |
Back to Latch Statistics
Back to Top
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 1 | 0 |
cache buffers chains | kclwrt | 0 | 1 | 0 |
event range base latch | No latch | 0 | 40 | 40 |
process allocation | ksucrp | 0 | 9 | 0 |
process allocation | ksufap: active procs | 0 | 5 | 7 |
slave class create | ksvcreate | 0 | 1 | 0 |
Back to Latch Statistics
Back to Top
No data exists for this section of the report.
Back to Latch Statistics
Back to Top
No data exists for this section of the report.
Back to Latch Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
SIE | EAS_DATA | SIE_BOE_HEADERS | TABLE | 890,624 | 26.00 | |
SYS | SYSTEM | FILE$ | TABLE | 337,328 | 9.85 | |
SYS | SYSTEM | I_FILE#_BLOCK# | INDEX | 269,776 | 7.88 | |
SYS | SYSTEM | SEG$ | TABLE | 204,496 | 5.97 | |
SYS | SYSTEM | USER$ | TABLE | 185,984 | 5.43 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
FBP | EAS_DATA_NEW | FBP_TASKS | TABLE | 61,356 | 32.90 | |
GDPLANET | DAT_EPM | TMP_HASCONTRACT_ALL | TABLE | 232 | 0.12 | |
APPS | EAS_IND | WFR_BILL_STATUS_N4 | INDEX | 90 | 0.05 | |
SIE | EAS_DATA_NEW | SIE_BOE_LINES | TABLE | 75 | 0.04 | |
SIE | EAS_DATA_NEW | SIE_BOE_LINES_N1 | INDEX | 16 | 0.01 |
Back to Segment Statistics
Back to Top
No data exists for this section of the report.
Back to Segment Statistics
Back to Top
No data exists for this section of the report.
Back to Segment Statistics
Back to Top
No data exists for this section of the report.
Back to Segment Statistics
Back to Top
No data exists for this section of the report.
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
SIE | EAS_DATA | SIE_BOE_HEADERS | TABLE | 1,053 | 9.17 | |
WFR | EAS_DATA_NEW | WFR_BILL_STATUS | TABLE | 969 | 8.44 | |
WFR | EAS_DATA_NEW | WFR_BILL_HISTORIES | TABLE | 771 | 6.72 | |
APPS | EAS_IND | WFR_BILL_STATUS_N4 | INDEX | 645 | 5.62 | |
WFR | EAS_IND | WFR_BILL_HISTORIES_N1 | INDEX | 579 | 5.04 |
Back to Segment Statistics
Back to Top
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
FBP | EAS_DATA_NEW | FBP_TASKS | TABLE | 9,958 | 82.18 | |
WFR | EAS_DATA_NEW | WFR_BILL_STATUS | TABLE | 687 | 5.67 | |
SIE | EAS_DATA | SIE_BOE_HEADERS | TABLE | 579 | 4.78 | |
SIE | EAS_DATA_NEW | SIE_BOE_LINES | TABLE | 191 | 1.58 | |
SIE | EAS_DATA | SIE_BOE_PAYMENTS | TABLE | 75 | 0.62 |
Back to Segment Statistics
Back to Top
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 31 | 3.23 | 0 | 1 | 1 | |
dc_database_links | 1,333 | 0.00 | 0 | 0 | 26 | |
dc_files | 3,000 | 0.00 | 0 | 0 | 254 | |
dc_global_oids | 1,969 | 0.00 | 0 | 0 | 309 | |
dc_histogram_data | 23,252 | 1.09 | 0 | 0 | 36,294 | |
dc_histogram_defs | 13,115 | 0.59 | 0 | 0 | 11,498 | |
dc_object_ids | 7,101 | 0.03 | 0 | 0 | 6,656 | |
dc_objects | 2,787 | 1.83 | 0 | 2 | 8,757 | |
dc_profiles | 643 | 0.00 | 0 | 0 | 2 | |
dc_rollback_segments | 13,312 | 0.00 | 0 | 0 | 1,313 | |
dc_segments | 2,435 | 0.08 | 0 | 2 | 2,701 | |
dc_sequences | 65 | 1.54 | 0 | 65 | 11 | |
dc_tablespaces | 144,938 | 0.00 | 0 | 0 | 43 | |
dc_usernames | 2,720 | 0.00 | 0 | 0 | 148 | |
dc_users | 22,939 | 0.00 | 0 | 0 | 196 | |
outstanding_alerts | 109 | 98.17 | 0 | 2 | 4 |
Back to Dictionary Cache Statistics
Back to Top
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 3 | 1 | 0 |
dc_histogram_defs | 77 | 0 | 0 |
dc_object_ids | 2 | 0 | 0 |
dc_objects | 55 | 1 | 0 |
dc_segments | 4 | 0 | 0 |
dc_sequences | 130 | 3 | 0 |
outstanding_alerts | 215 | 159 | 0 |
Back to Dictionary Cache Statistics
Back to Top
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 70 | 0.00 | 1,630 | 0.00 | 0 | 0 |
INDEX | 37 | 0.00 | 130 | 0.00 | 0 | 0 |
SQL AREA | 6,455 | 2.80 | 341,468 | 0.16 | 61 | 0 |
TABLE/PROCEDURE | 1,100 | 2.09 | 7,754 | 1.19 | 4 | 0 |
Back to Library Cache Statistics
Back to Top
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
INDEX | 130 | 0 | 0 | 0 | 0 |
TABLE/PROCEDURE | 3,240 | 43 | 2 | 39 | 0 |
Back to Library Cache Statistics
Back to Top
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,571.06 | 21.23 | 126.96 | 1,096 | 1,096 | 74 | 74 | |
PL/SQL | 1,144.73 | 123.93 | 15.90 | 134.14 | 1,138 | 1,138 | 72 | 72 | |
Freeable | 206.13 | 0.00 | 5.57 | 24.72 | 151 | 37 | 37 | ||
SQL | 79.50 | 69.17 | 1.59 | 7.58 | 38 | 402 | 50 | 34 | |
E | Other | 1,514.87 | 22.61 | 133.82 | 1,099 | 1,099 | 67 | 67 | |
PL/SQL | 1,145.54 | 123.88 | 17.62 | 141.31 | 1,139 | 1,139 | 65 | 65 | |
SQL | 82.65 | 72.37 | 1.92 | 8.17 | 38 | 402 | 43 | 27 | |
Freeable | 49.69 | 0.00 | 1.60 | 2.31 | 10 | 31 | 31 |
Back to Memory Statistics
Back to Top
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 24,075,304,960 | |
Fixed Size | 2,111,920 | |
Redo Buffers | 14,663,680 | |
Variable Size | 14,562,625,104 |
Back to Memory Statistics
Back to Top
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 32.00 | 32.00 | 0.00 |
large | PX msg pool | 1.09 | 1.09 | 0.00 |
large | free memory | 46.91 | 46.91 | 0.00 |
shared | CCursor | 638.94 | 639.52 | 0.09 |
shared | PCursor | 396.45 | 396.82 | 0.09 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | free memory | 3,885.57 | 3,876.23 | -0.24 |
shared | gcs resources | 478.41 | 478.41 | 0.00 |
shared | gcs shadows | 286.48 | 286.48 | 0.00 |
shared | library cache | 273.67 | 273.93 | 0.10 |
shared | sql area | 7,050.45 | 7,058.03 | 0.11 |
streams | KGH: NO ACCESS | 15.98 | 15.98 | 0.00 |
streams | free memory | 15.89 | 15.89 | 0.00 |
buffer_cache | 22,960.00 | 22,960.00 | 0.00 | |
fixed_sga | 2.01 | 2.01 | 0.00 | |
log_buffer | 13.98 | 13.98 | 0.00 |
Back to Memory Statistics
Back to Top
Session Type | CPU Time | User I/O Time | Sys I/O Time |
---|---|---|---|
QMON Slaves | 504,038 | 0 | 0 |
QMON Coordinator | 300,686 | 0 | 0 |
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
No data exists for this section of the report.
Back to Streams Statistics
Back to Top
Queue Schema and Name | Incoming per second | Outgoing per second | Spilled per second | Diff Pct Spilled |
---|---|---|---|---|
SYS.KUPC$C_1_20161115174523 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115182328 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124101927 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124103225 | 0 | 0 | 0 | 0 |
SYS.KUPC$S_1_20161115174523 | 0 | 0 | 0 | 0 |
SYS.KUPC$S_1_20161115182328 | 0 | 0 | 0 | 0 |
SYS.KUPC$S_1_20161124101927 | 0 | 0 | 0 | 0 |
SYS.KUPC$S_1_20161124103225 | 0 | 0 | 0 | 0 |
Back to Streams Statistics
Back to Top
Subscriber Name | Incoming per second | Outgoing per second | Spilled per second |
---|---|---|---|
KUPC$A_1_20161115174523 | 0 | 0 | 0 |
KUPC$A_1_20161115174523 | 0 | 0 | 0 |
KUPC$A_1_20161115180955 | 0 | 0 | 0 |
KUPC$A_1_20161115180955 | 0 | 0 | 0 |
KUPC$A_1_20161115181437 | 0 | 0 | 0 |
KUPC$A_1_20161115181437 | 0 | 0 | 0 |
KUPC$A_1_20161115181602 | 0 | 0 | 0 |
KUPC$A_1_20161115181602 | 0 | 0 | 0 |
KUPC$A_1_20161115182328 | 0 | 0 | 0 |
KUPC$A_1_20161115182328 | 0 | 0 | 0 |
KUPC$A_1_20161115182636 | 0 | 0 | 0 |
KUPC$A_1_20161115182636 | 0 | 0 | 0 |
KUPC$A_1_20161115182709 | 0 | 0 | 0 |
KUPC$A_1_20161115182709 | 0 | 0 | 0 |
KUPC$A_1_20161124101928 | 0 | 0 | 0 |
KUPC$A_1_20161124101928 | 0 | 0 | 0 |
KUPC$A_1_20161124103226 | 0 | 0 | 0 |
KUPC$A_1_20161124103226 | 0 | 0 | 0 |
MCP | 0 | 0 | 0 |
MCP | 0 | 0 | 0 |
MCP | 0 | 0 | 0 |
MCP | 0 | 0 | 0 |
Back to Streams Statistics
Back to Top
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 2 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6691 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6692 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6694 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6696 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124103225$6723 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115182328$6698 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115182328$6702 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115182328$6710 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124101927$6714 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124101927$6718 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161124103225$6719 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6687 | 0 | 0 | 0 | 0 | 0 |
SYS.KUPC$C_1_20161115174523$6708 | 0 | 0 | 0 | 0 | 0 |
Back to Streams Statistics
Back to Top
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
gcs_resources | 1,887,391 | 2,861,412 | 3096098 | 3096098 |
gcs_shadows | 2,148,004 | 3,095,936 | 3096098 | 3096098 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
_optimizer_cost_based_transformation | LINEAR | |
audit_file_dest | /oracle/admin/appdbc/adump | |
audit_sys_operations | TRUE | |
audit_trail | DB_EXTENDED | |
background_dump_dest | /oracle/admin/appdbc/bdump | |
cluster_database | TRUE | |
cluster_database_instances | 2 | |
cluster_interconnects | 192.168.9.1 | |
compatible | 10.2.0.3.0 | |
control_files | /dev/vx/rdsk/racdg/control01, /dev/vx/rdsk/racdg/control02, /dev/vx/rdsk/racdg/control03 | |
core_dump_dest | /oracle/admin/appdbc/cdump | |
db_block_size | 8192 | |
db_domain | ||
db_file_multiblock_read_count | 16 | |
db_files | 400 | |
db_name | appdbc | |
db_recovery_file_dest | ||
db_recovery_file_dest_size | 53687091200 | |
dispatchers | (PROTOCOL=TCP) (SERVICE=appdbcXDB) | |
instance_number | 1 | |
job_queue_processes | 20 | |
log_archive_dest_1 | LOCATION=/arch_0 | |
max_dump_file_size | 1024m | |
open_cursors | 600 | |
pga_aggregate_target | 4294967296 | |
processes | 2500 | |
remote_login_passwordfile | EXCLUSIVE | |
resource_limit | TRUE | |
service_names | SYS$SYS.KUPC$C_1_20161124103225.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161124101927.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161124101927.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161115182328.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161115182328.APPDBC.GMCC.NET, SYS$SYS.KUPC$S_1_20161115174523.APPDBC.GMCC.NET, SYS$SYS.KUPC$C_1_20161115174523.APPDBC.GMCC.NET, lis, mdbc1, hrms, appdbc, SYS$SYS.KUPC$S_1_20161124103225.APPDBC.GMCC.NET | |
sessions | 2755 | |
sga_max_size | 38654705664 | |
sga_target | 38654705664 | |
spfile | /dev/vx/rdsk/racdg/spfile | |
thread | 1 | |
undo_management | AUTO | |
undo_retention | 1800 | |
undo_tablespace | UNDOTBS1 | |
user_dump_dest | /oracle/admin/appdbc/udump |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 29,782 | 16.84 | 16.34 |
acks for commit broadcast(logical) | 30,647 | 17.33 | 16.81 |
broadcast msgs on commit(actual) | 550 | 0.31 | 0.30 |
broadcast msgs on commit(logical) | 554 | 0.31 | 0.30 |
broadcast msgs on commit(wasted) | 27 | 0.02 | 0.01 |
broadcast on commit wait time(ms) | 96 | 0.05 | 0.05 |
broadcast on commit waits | 478 | 0.27 | 0.26 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 0 | 0.00 | 0.00 |
flow control messages received | 63 | 0.04 | 0.03 |
flow control messages sent | 6 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 19,932 | 11.27 | 10.93 |
gcs ast xid | 0 | 0.00 | 0.00 |
gcs blocked converts | 671 | 0.38 | 0.37 |
gcs blocked cr converts | 3,410 | 1.93 | 1.87 |
gcs compatible basts | 7 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 191 | 0.11 | 0.10 |
gcs compatible cr basts (local) | 23,190 | 13.11 | 12.72 |
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 | 1,058 | 0.60 | 0.58 |
gcs dbwr write request msgs | 1,059 | 0.60 | 0.58 |
gcs error msgs | 0 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 528 | 0.30 | 0.29 |
gcs immediate (null) converts | 1,052 | 0.59 | 0.58 |
gcs immediate cr (compatible) converts | 0 | 0.00 | 0.00 |
gcs immediate cr (null) converts | 4,678 | 2.64 | 2.57 |
gcs indirect ast | 5,079 | 2.87 | 2.79 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 64 | 0.04 | 0.04 |
gcs msgs process time(ms) | 8,593 | 4.86 | 4.71 |
gcs msgs received | 264,839 | 149.74 | 145.28 |
gcs out-of-order msgs | 0 | 0.00 | 0.00 |
gcs pings refused | 1 | 0.00 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs queued converts | 0 | 0.00 | 0.00 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 0 | 0.00 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 0 | 0.00 | 0.00 |
gcs side channel msgs actual | 3,226 | 1.82 | 1.77 |
gcs side channel msgs logical | 25,515 | 14.43 | 14.00 |
gcs stale cr | 61,763 | 34.92 | 33.88 |
gcs undo cr | 0 | 0.00 | 0.00 |
gcs write notification msgs | 2 | 0.00 | 0.00 |
gcs writes refused | 0 | 0.00 | 0.00 |
ges msgs process time(ms) | 136 | 0.08 | 0.07 |
ges msgs received | 7,130 | 4.03 | 3.91 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 21 | 0.01 | 0.01 |
global posts queued | 4 | 0.00 | 0.00 |
global posts requested | 4 | 0.00 | 0.00 |
global posts sent | 4 | 0.00 | 0.00 |
implicit batch messages received | 6,879 | 3.89 | 3.77 |
implicit batch messages sent | 1,581 | 0.89 | 0.87 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 1,532 | 0.87 | 0.84 |
messages queue sent actual | 21,902 | 12.38 | 12.01 |
messages queue sent logical | 23,549 | 13.31 | 12.92 |
messages received actual | 170,518 | 96.41 | 93.54 |
messages received logical | 271,971 | 153.77 | 149.19 |
messages sent directly | 77,257 | 43.68 | 42.38 |
messages sent indirectly | 18,019 | 10.19 | 9.88 |
messages sent not implicit batched | 20,320 | 11.49 | 11.15 |
messages sent pbatched | 109,424 | 61.87 | 60.02 |
msgs causing lmd to send msgs | 3,112 | 1.76 | 1.71 |
msgs causing lms(s) to send msgs | 4,863 | 2.75 | 2.67 |
msgs received queue time (ms) | 147,946 | 83.65 | 81.16 |
msgs received queued | 271,979 | 153.78 | 149.19 |
msgs sent queue time (ms) | 661 | 0.37 | 0.36 |
msgs sent queue time on ksxp (ms) | 26,779 | 15.14 | 14.69 |
msgs sent queued | 23,549 | 13.31 | 12.92 |
msgs sent queued on ksxp | 135,218 | 76.45 | 74.17 |
process batch messages received | 75,322 | 42.59 | 41.32 |
process batch messages sent | 44,753 | 25.30 | 24.55 |
Statistic | Total |
---|---|
CR Block Requests | 18,858 |
CURRENT Block Requests | 29 |
Data Block Requests | 18,858 |
Undo Block Requests | 0 |
TX Block Requests | 7 |
Current Results | 18,630 |
Private results | 0 |
Zero Results | 257 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 4,630 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 617 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 1 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 47,429 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Flushes | 1 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 |
Writes | 1,248 | 64.26 | 33.97 | 0.48 | 0.32 | 0.96 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
2 | data block | 5,497 | 99.16 | 0.38 | 0.45 | 11,987 | 91.92 | 0.01 | 8.08 |
2 | undo header | 3,394 | 99.71 | 0.18 | 0.12 | 67 | 98.51 | 1.49 | 0.00 |
2 | Others | 2,598 | 99.85 | 0.00 | 0.15 | 67 | 100.00 | 0.00 | 0.00 |
End of Report Report written to awrrpt_1_112312_112313.html Prod:user=sys,db=appdbc SQL>