DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
NDMIS | 3941636119 | ndmis1 | 1 | 10.2.0.5.0 | YES | ndora1 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 26470 | 27-Mar-13 16:00:14 | 1773 | 20.0 |
End Snap: | 26471 | 27-Mar-13 16:30:17 | 1783 | 20.2 |
Elapsed: | 30.05 (mins) | |||
DB Time: | 114.62 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 22,960M | 22,960M | Std Block Size: | 8K |
Shared Pool Size: | 3,456M | 3,456M | Log Buffer: | 47,052K |
Per Second | Per Transaction | |
---|---|---|
Redo size: | 136,014.72 | 5,737.94 |
Logical reads: | 108,428.10 | 4,574.17 |
Block changes: | 524.80 | 22.14 |
Physical reads: | 1,010.20 | 42.62 |
Physical writes: | 60.16 | 2.54 |
User calls: | 3,056.25 | 128.93 |
Parses: | 340.87 | 14.38 |
Hard parses: | 54.82 | 2.31 |
Sorts: | 231.91 | 9.78 |
Logons: | 0.09 | 0.00 |
Executes: | 3,071.09 | 129.56 |
Transactions: | 23.70 |
% Blocks changed per Read: | 0.48 | Recursive Call %: | 67.84 |
Rollback per transaction %: | 2.91 | Rows per Sort: | 49.30 |
Buffer Nowait %: | 99.97 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.08 | In-memory Sort %: | 100.00 |
Library Hit %: | 94.36 | Soft Parse %: | 83.92 |
Execute to Parse %: | 88.90 | Latch Hit %: | 99.81 |
Parse CPU to Parse Elapsd %: | 19.09 | % Non-Parse CPU: | 98.13 |
Begin | End | |
---|---|---|
Memory Usage %: | 75.34 | 75.27 |
% SQL with executions>1: | 75.58 | 66.23 |
% Memory for SQL w/exec>1: | 80.64 | 72.30 |
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
db file sequential read | 486,678 | 2,253 | 5 | 32.8 | User I/O |
CPU time | 2,025 | 29.4 | |||
SQL*Net message from dblink | 115,648 | 645 | 6 | 9.4 | Network |
db file scattered read | 94,734 | 271 | 3 | 3.9 | User I/O |
gc current block 2-way | 444,659 | 182 | 0 | 2.6 | Cluster |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 820.77 | 34.63 |
Global Cache blocks served: | 592.05 | 24.98 |
GCS/GES messages received: | 2,722.86 | 114.87 |
GCS/GES messages sent: | 2,928.61 | 123.55 |
DBWR Fusion writes: | 9.88 | 0.42 |
Estd Interconnect traffic (KB) | 12,406.40 |
Buffer access - local cache %: | 98.33 |
Buffer access - remote cache %: | 0.76 |
Buffer access - disk %: | 0.92 |
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): | 0.9 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.0 |
Global cache log flushes for cr blocks served %: | 0.1 |
Avg global cache cr block flush time (ms): | 1.8 |
Avg global cache current block pin time (ms): | 0.0 |
Avg global cache current block send time (ms): | 0.0 |
Global cache log flushes for current blocks served %: | 0.0 |
Avg global cache current block flush time (ms): | 1.4 |
Avg message sent queue time (ms): | 0.4 |
Avg message sent queue time on ksxp (ms): | 0.3 |
Avg message received queue time (ms): | 0.0 |
Avg GCS message process time (ms): | 0.0 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 31.73 |
% of indirect sent messages: | 63.78 |
% of flow controlled messages: | 4.50 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 6,529.44 | 94.94 |
DB CPU | 2,024.95 | 29.44 |
parse time elapsed | 393.27 | 5.72 |
hard parse elapsed time | 355.34 | 5.17 |
PL/SQL execution elapsed time | 79.00 | 1.15 |
PL/SQL compilation elapsed time | 59.63 | 0.87 |
hard parse (sharing criteria) elapsed time | 46.03 | 0.67 |
hard parse (bind mismatch) elapsed time | 34.36 | 0.50 |
failed parse elapsed time | 4.27 | 0.06 |
repeated bind elapsed time | 3.66 | 0.05 |
connection management call elapsed time | 0.64 | 0.01 |
sequence load elapsed time | 0.19 | 0.00 |
DB time | 6,877.46 | |
background elapsed time | 496.05 | |
background cpu time | 335.24 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %Total Call Time |
---|---|---|---|---|---|
User I/O | 623,926 | 0 | 2,621 | 4 | 38.10 |
CPU time | 2,025 | 29.44 | |||
Network | 6,866,167 | 675 | 0 | 9.82 | |
Cluster | 1,678,879 | 0 | 602 | 0 | 8.76 |
System I/O | 192,489 | 85 | 0 | 1.23 | |
Other | 267,553 | 45 | 75 | 0 | 1.09 |
Commit | 41,649 | 0 | 66 | 2 | 0.96 |
Concurrency | 177,100 | 0 | 44 | 0 | 0.64 |
Application | 607 | 1 | 2 | 4 | 0.03 |
Configuration | 349 | 0 | 0 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
db file sequential read | 486,678 | 2,253 | 5 | 11.39 | |
SQL*Net message from dblink | 115,648 | 645 | 6 | 2.71 | |
db file scattered read | 94,734 | 271 | 3 | 2.22 | |
gc current block 2-way | 444,659 | 182 | 0 | 10.41 | |
gc cr multi block request | 753,085 | 152 | 0 | 17.62 | |
gc buffer busy | 50,385 | 0 | 106 | 2 | 1.18 |
gc cr grant 2-way | 272,786 | 92 | 0 | 6.38 | |
log file sync | 41,649 | 0 | 66 | 2 | 0.97 |
cr request retry | 68 | 100 | 66 | 964 | 0.00 |
read by other session | 16,149 | 0 | 43 | 3 | 0.38 |
gc cr block 2-way | 93,889 | 39 | 0 | 2.20 | |
db file parallel read | 9,990 | 37 | 4 | 0.23 | |
row cache lock | 139,740 | 36 | 0 | 3.27 | |
log file parallel write | 44,976 | 30 | 1 | 1.05 | |
db file parallel write | 40,554 | 29 | 1 | 0.95 | |
control file sequential read | 106,119 | 24 | 0 | 2.48 | |
SQL*Net more data to client | 1,441,165 | 20 | 0 | 33.72 | |
direct path read | 11,507 | 15 | 1 | 0.27 | |
gc current grant 2-way | 43,617 | 14 | 0 | 1.02 | |
gc current grant busy | 18,356 | 8 | 0 | 0.43 | |
SQL*Net more data from dblink | 3,111 | 6 | 2 | 0.07 | |
SQL*Net message to client | 5,166,327 | 3 | 0 | 120.89 | |
library cache lock | 8,171 | 3 | 0 | 0.19 | |
gc cr grant congested | 63 | 3 | 43 | 0.00 | |
gc current block congested | 81 | 2 | 30 | 0.00 | |
reliable message | 153 | 1 | 2 | 14 | 0.00 |
enq: TX - row lock contention | 13 | 31 | 2 | 159 | 0.00 |
ges lmd/lmses to freeze in rcfg - mrcvr | 387 | 24 | 2 | 4 | 0.01 |
gc current block busy | 270 | 2 | 6 | 0.01 | |
ksxr poll remote instances | 206,031 | 31 | 1 | 0 | 4.82 |
gc cr block congested | 21 | 1 | 70 | 0.00 | |
latch: cache buffers chains | 27,699 | 1 | 0 | 0.65 | |
direct path write temp | 1,434 | 1 | 1 | 0.03 | |
SQL*Net more data from client | 24,049 | 1 | 0 | 0.56 | |
direct path write | 3,429 | 1 | 0 | 0.08 | |
inactive session | 1 | 100 | 1 | 977 | 0.00 |
os thread startup | 15 | 1 | 60 | 0.00 | |
cursor: pin S wait on X | 94 | 96 | 1 | 9 | 0.00 |
CSS initialization | 13 | 1 | 66 | 0.00 | |
control file parallel write | 840 | 1 | 1 | 0.02 | |
gcs log flush sync | 692 | 0 | 1 | 1 | 0.02 |
library cache load lock | 13 | 1 | 46 | 0.00 | |
latch: shared pool | 110 | 1 | 5 | 0.00 | |
gc current grant congested | 11 | 0 | 45 | 0.00 | |
CGS wait for IPC msg | 55,210 | 99 | 0 | 0 | 1.29 |
library cache pin | 1,079 | 0 | 0 | 0.03 | |
DFS lock handle | 912 | 0 | 0 | 0.02 | |
latch free | 124 | 0 | 3 | 0.00 | |
gc cr block busy | 120 | 0 | 2 | 0.00 | |
gc current multi block request | 1,349 | 0 | 0 | 0.03 | |
rdbms ipc reply | 819 | 0 | 0 | 0.02 | |
enq: HW - contention | 346 | 0 | 0 | 0.01 | |
enq: TX - index contention | 60 | 0 | 1 | 0.00 | |
latch: object queue header operation | 27 | 0 | 3 | 0.00 | |
enq: TT - contention | 193 | 0 | 0 | 0.00 | |
SQL*Net message to dblink | 115,625 | 0 | 0 | 2.71 | |
SQL*Net break/reset to client | 544 | 0 | 0 | 0.01 | |
latch: KCL gc element parent latch | 87 | 0 | 1 | 0.00 | |
gc cr disk read | 109 | 0 | 0 | 0.00 | |
CSS operation: action | 25 | 0 | 2 | 0.00 | |
latch: library cache | 15 | 0 | 3 | 0.00 | |
kksfbc child completion | 1 | 100 | 0 | 49 | 0.00 |
enq: FB - contention | 103 | 0 | 0 | 0.00 | |
IPC send completion sync | 111 | 100 | 0 | 0 | 0.00 |
enq: TO - contention | 106 | 0 | 0 | 0.00 | |
enq: CF - contention | 101 | 0 | 0 | 0.00 | |
enq: PS - contention | 59 | 0 | 0 | 0.00 | |
gc cr failure | 68 | 0 | 0 | 0.00 | |
PX Deq: reap credit | 1,520 | 97 | 0 | 0 | 0.04 |
enq: TX - contention | 1 | 0 | 14 | 0.00 | |
LGWR wait for redo copy | 475 | 0 | 0 | 0.01 | |
latch: row cache objects | 4 | 0 | 3 | 0.00 | |
enq: TM - contention | 24 | 0 | 0 | 0.00 | |
gc quiesce | 2 | 50 | 0 | 5 | 0.00 |
PX Deq Credit: send blkd | 30 | 20 | 0 | 0 | 0.00 |
buffer busy waits | 97 | 0 | 0 | 0.00 | |
enq: WF - contention | 9 | 0 | 0 | 0.00 | |
SQL*Net more data to dblink | 242 | 0 | 0 | 0.01 | |
latch: gcs resource hash | 10 | 0 | 0 | 0.00 | |
enq: RO - fast object reuse | 6 | 0 | 1 | 0.00 | |
enq: TD - KTF dump entries | 6 | 0 | 0 | 0.00 | |
ges inquiry response | 5 | 0 | 0 | 0.00 | |
gc current split | 6 | 0 | 0 | 0.00 | |
KJC: Wait for msg sends to complete | 75 | 0 | 0 | 0.00 | |
PX Deq: Signal ACK | 19 | 37 | 0 | 0 | 0.00 |
enq: TX - allocate ITL entry | 3 | 0 | 0 | 0.00 | |
gc current block unknown | 2 | 0 | 0 | 0.00 | |
enq: MS - contention | 2 | 0 | 0 | 0.00 | |
ges2 LMON to wake up LMD - mrcvr | 14 | 0 | 0 | 0.00 | |
SQL*Net break/reset to dblink | 18 | 0 | 0 | 0.00 | |
direct path read temp | 5 | 0 | 0 | 0.00 | |
enq: MW - contention | 1 | 0 | 0 | 0.00 | |
enq: DR - contention | 1 | 0 | 0 | 0.00 | |
enq: AF - task serialization | 1 | 0 | 0 | 0.00 | |
enq: JI - contention | 1 | 0 | 0 | 0.00 | |
enq: JS - job run lock - synchronize | 1 | 0 | 0 | 0.00 | |
enq: UL - contention | 2 | 0 | 0 | 0.00 | |
latch: cache buffers lru chain | 1 | 0 | 0 | 0.00 | |
latch: session allocation | 2 | 0 | 0 | 0.00 | |
wait for scn ack | 5 | 0 | 0 | 0.00 | |
cursor: pin S | 148 | 0 | 0 | 0.00 | |
buffer deadlock | 3 | 100 | 0 | 0 | 0.00 |
cursor: mutex S | 2 | 0 | 0 | 0.00 | |
cursor: mutex X | 1 | 0 | 0 | 0.00 | |
SQL*Net message from client | 5,166,386 | 2,800,301 | 542 | 120.89 | |
gcs remote message | 2,296,140 | 22 | 27,869 | 12 | 53.73 |
Streams AQ: qmn slave idle wait | 552 | 1 | 3,521 | 6379 | 0.01 |
virtual circuit status | 61 | 100 | 1,787 | 29297 | 0.00 |
jobq slave wait | 617 | 96 | 1,772 | 2872 | 0.01 |
Streams AQ: qmn coordinator idle wait | 596 | 43 | 1,761 | 2954 | 0.01 |
DIAG idle wait | 9,000 | 1,759 | 195 | 0.21 | |
PX Idle Wait | 734 | 93 | 1,759 | 2397 | 0.02 |
Streams AQ: waiting for messages in the queue | 186 | 100 | 1,758 | 9451 | 0.00 |
Streams AQ: waiting for time management or cleanup tasks | 6 | 100 | 1,758 | 292969 | 0.00 |
ges remote message | 232,771 | 6 | 1,745 | 7 | 5.45 |
PX Deq: Execution Msg | 256 | 29 | 0 | 1 | 0.01 |
single-task message | 4 | 0 | 32 | 0.00 | |
PX Deq: Parse Reply | 27 | 37 | 0 | 4 | 0.00 |
PX Deq: Execute Reply | 22 | 32 | 0 | 1 | 0.00 |
PX Deq: Join ACK | 25 | 36 | 0 | 1 | 0.00 |
PX Deq: Msg Fragment | 92 | 47 | 0 | 0 | 0.00 |
Streams AQ: RAC qmn coordinator idle wait | 603 | 98 | 0 | 0 | 0.01 |
class slave wait | 4 | 0 | 1 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
log file parallel write | 44,978 | 30 | 1 | 1.05 | |
db file parallel write | 40,554 | 29 | 1 | 0.95 | |
control file sequential read | 37,291 | 13 | 0 | 0.87 | |
events in waitclass Other | 264,098 | 45 | 5 | 0 | 6.18 |
db file sequential read | 708 | 2 | 3 | 0.02 | |
os thread startup | 15 | 1 | 60 | 0.00 | |
control file parallel write | 840 | 1 | 1 | 0.02 | |
row cache lock | 736 | 0 | 0 | 0.02 | |
library cache load lock | 1 | 0 | 156 | 0.00 | |
gc current block 2-way | 315 | 0 | 0 | 0.01 | |
library cache lock | 161 | 0 | 0 | 0.00 | |
gc cr grant 2-way | 78 | 0 | 0 | 0.00 | |
gc current grant 2-way | 62 | 0 | 0 | 0.00 | |
gc cr block 2-way | 29 | 0 | 0 | 0.00 | |
gc quiesce | 2 | 50 | 0 | 5 | 0.00 |
enq: RO - fast object reuse | 6 | 0 | 1 | 0.00 | |
library cache pin | 13 | 0 | 0 | 0.00 | |
latch: shared pool | 3 | 0 | 0 | 0.00 | |
enq: TM - contention | 1 | 0 | 0 | 0.00 | |
buffer busy waits | 6 | 0 | 0 | 0.00 | |
latch: cache buffers chains | 5 | 0 | 0 | 0.00 | |
rdbms ipc message | 355,760 | 13 | 35,300 | 99 | 8.32 |
gcs remote message | 2,296,139 | 22 | 27,869 | 12 | 53.73 |
Streams AQ: qmn slave idle wait | 552 | 1 | 3,521 | 6379 | 0.01 |
Streams AQ: qmn coordinator idle wait | 596 | 43 | 1,761 | 2954 | 0.01 |
smon timer | 372 | 99 | 1,760 | 4731 | 0.01 |
DIAG idle wait | 9,000 | 1,759 | 195 | 0.21 | |
pmon timer | 702 | 99 | 1,758 | 2505 | 0.02 |
Streams AQ: waiting for time management or cleanup tasks | 6 | 100 | 1,758 | 292969 | 0.00 |
ges remote message | 232,764 | 6 | 1,745 | 7 | 5.45 |
Streams AQ: RAC qmn coordinator idle wait | 603 | 98 | 0 | 0 | 0.01 |
Statistic | Total |
---|---|
NUM_LCPUS | 0 |
NUM_VCPUS | 0 |
AVG_BUSY_TIME | 6,665 |
AVG_IDLE_TIME | 173,454 |
AVG_IOWAIT_TIME | 3,536 |
AVG_SYS_TIME | 1,579 |
AVG_USER_TIME | 5,036 |
BUSY_TIME | 430,512 |
IDLE_TIME | 11,105,279 |
IOWAIT_TIME | 229,756 |
SYS_TIME | 104,486 |
USER_TIME | 326,026 |
LOAD | 3 |
OS_CPU_WAIT_TIME | 447,800 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 12,414,976 |
VM_OUT_BYTES | 69,632,000 |
PHYSICAL_MEMORY_BYTES | 66,571,993,088 |
NUM_CPUS | 64 |
NUM_CPU_CORES | 32 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
---|---|---|---|---|
ndmis | 6,869.00 | 2,021.50 | 1,823,317 | 195,428,847 |
SYS$USERS | 35.40 | 15.40 | 554 | 234,135 |
SYS$BACKGROUND | 0.10 | 0.10 | 2,389 | 182,872 |
SYS.KUPC$S_1_20130323232332 | 0.00 | 0.00 | 0 | 0 |
nd_mis | 0.00 | 0.00 | 0 | 0 |
ndmisXDB | 0.00 | 0.00 | 0 | 0 |
Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
---|---|---|---|---|---|---|---|---|
ndmis | 620689 | 2608 | 164870 | 39 | 0 | 0 | 6864018 | 675 |
SYS$USERS | 535 | 2 | 7065 | 2 | 0 | 0 | 1604 | 0 |
SYS$BACKGROUND | 2623 | 11 | 5165 | 2 | 0 | 0 | 0 | 0 |
nd_mis | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
348 | 213 | 104,561 | 0.00 | 5.05 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
255 | 26 | 298 | 0.86 | 3.71 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
236 | 0 | 53 | 4.46 | 3.44 | c5tmjxj6rtck4 | JDBC Thin Client | SELECT mis_t.tg_id id, (SELECT... |
212 | 48 | 3 | 70.65 | 3.08 | aw6gj3r2syaxs | JDBC Thin Client | select interdata.area_code, in... |
193 | 74 | 4,733 | 0.04 | 2.80 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
169 | 6 | 2 | 84.38 | 2.45 | 0js73phthdt42 | JDBC Thin Client | select t.TASK_CD, t.TASK_NO, t... |
138 | 6 | 7,598 | 0.02 | 2.01 | 9yyb7wvndk114 | JDBC Thin Client | select * from v$_ST_DYLine whe... |
132 | 66 | 4,993 | 0.03 | 1.92 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
97 | 55 | 263 | 0.37 | 1.41 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
97 | 11 | 426,031 | 0.00 | 1.41 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
213 | 348 | 104,561 | 0.00 | 10.50 | 5.05 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
74 | 193 | 4,733 | 0.02 | 3.68 | 2.80 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
66 | 132 | 4,993 | 0.01 | 3.25 | 1.92 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
55 | 97 | 263 | 0.21 | 2.70 | 1.41 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
48 | 212 | 3 | 15.96 | 2.36 | 3.08 | aw6gj3r2syaxs | JDBC Thin Client | select interdata.area_code, in... |
29 | 58 | 318,465 | 0.00 | 1.45 | 0.84 | fc42s7rxq7chg | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
26 | 255 | 298 | 0.09 | 1.30 | 3.71 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
26 | 41 | 156 | 0.16 | 1.27 | 0.60 | awvtdy3vc6fum | JDBC Thin Client | SELECT codeId, codeSortId, par... |
18 | 64 | 388 | 0.05 | 0.87 | 0.92 | 91d0kuahyy84b | JDBC Thin Client | SELECT tmp.* FROM (SELECT l.ob... |
16 | 26 | 298 | 0.05 | 0.79 | 0.38 | 8u5s8xhp48xm2 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
33,087,216 | 104,561 | 316.44 | 16.93 | 212.63 | 347.61 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
25,896,656 | 4,733 | 5,471.51 | 13.25 | 74.48 | 192.69 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
25,611,846 | 4,993 | 5,129.55 | 13.10 | 65.82 | 132.20 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
21,654,668 | 318,465 | 68.00 | 11.08 | 29.33 | 58.08 | fc42s7rxq7chg | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
7,879,065 | 156 | 50,506.83 | 4.03 | 25.67 | 41.16 | awvtdy3vc6fum | JDBC Thin Client | SELECT codeId, codeSortId, par... |
5,986,068 | 298 | 20,087.48 | 3.06 | 16.04 | 26.21 | 8u5s8xhp48xm2 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
5,604,016 | 82,413 | 68.00 | 2.87 | 13.05 | 33.77 | 1gcnmuw9xtb3k | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
3,962,971 | 298 | 13,298.56 | 2.03 | 26.24 | 255.08 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
3,475,498 | 245 | 14,185.71 | 1.78 | 10.51 | 37.94 | 830q1znx77va1 | JDBC Thin Client | BEGIN OL$_CORE_EXPAND.LINESUPP... |
3,452,086 | 263 | 13,125.80 | 1.77 | 54.75 | 97.10 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
3,294,365 | 219 | 15,042.76 | 1.69 | 8.70 | 15.83 | 3tw8g2mwh4kgc | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
3,011,035 | 5,869 | 513.04 | 1.54 | 6.26 | 41.84 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
2,762,166 | 1,537 | 1,797.12 | 1.41 | 7.31 | 19.10 | bsm6gmajgmhuu | JDBC Thin Client | select * from indy_menu where ... |
2,433,967 | 53,411 | 45.57 | 1.25 | 1.03 | 50.55 | dpqpcqn109dcj | JDBC Thin Client | select * from st_institution_r... |
2,410,019 | 58 | 41,552.05 | 1.23 | 2.30 | 23.26 | gkw6wc3pm09j6 | JDBC Thin Client | SELECT USER_NAME FROM AMBER.IN... |
2,355,941 | 388 | 6,072.01 | 1.21 | 17.63 | 63.55 | 91d0kuahyy84b | JDBC Thin Client | SELECT tmp.* FROM (SELECT l.ob... |
2,136,152 | 426,031 | 5.01 | 1.09 | 10.85 | 96.76 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
2,037,976 | 3 | 679,325.33 | 1.04 | 47.88 | 211.95 | aw6gj3r2syaxs | JDBC Thin Client | select interdata.area_code, in... |
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
351,143 | 3 | 117,047.67 | 19.28 | 47.88 | 211.95 | aw6gj3r2syaxs | JDBC Thin Client | select interdata.area_code, in... |
50,787 | 311 | 163.30 | 2.79 | 13.81 | 44.08 | 4ydgzsjh9kb57 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
39,477 | 298 | 132.47 | 2.17 | 26.24 | 255.08 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
28,833 | 2 | 14,416.50 | 1.58 | 5.91 | 168.76 | 0js73phthdt42 | JDBC Thin Client | select t.TASK_CD, t.TASK_NO, t... |
19,525 | 7,598 | 2.57 | 1.07 | 6.15 | 138.24 | 9yyb7wvndk114 | JDBC Thin Client | select * from v$_ST_DYLine whe... |
19,361 | 150 | 129.07 | 1.06 | 11.22 | 57.77 | fdckt0yps3750 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
17,008 | 263 | 64.67 | 0.93 | 54.75 | 97.10 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
13,278 | 426,031 | 0.03 | 0.73 | 10.85 | 96.76 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
10,691 | 4,733 | 2.26 | 0.59 | 74.48 | 192.69 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
9,947 | 120 | 82.89 | 0.55 | 2.43 | 60.71 | 9yh5wgu938tja | JDBC Thin Client | BEGIN OL$_CORE_EXPAND.Batchins... |
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
426,031 | 426,029 | 1.00 | 0.00 | 0.00 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
393,851 | 393,842 | 1.00 | 0.00 | 0.00 | fkg1futrvwzbg | JDBC Thin Client | SELECT COUNT(1) FROM OL$_ASSOC... |
364,141 | 364,131 | 1.00 | 0.00 | 0.00 | 6xz0c679sk859 | JDBC Thin Client | SELECT NAME FROM V$_ST_IDENTIF... |
318,465 | 318,449 | 1.00 | 0.00 | 0.00 | fc42s7rxq7chg | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
154,010 | 2,652,608 | 17.22 | 0.00 | 0.00 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
104,561 | 104,308 | 1.00 | 0.00 | 0.00 | 964zgsudcdac7 | JDBC Thin Client | SELECT D.ATTR_URI FROM OL$_ATT... |
84,765 | 51,872 | 0.61 | 0.00 | 0.00 | 21w7mktubd1dq | JDBC Thin Client | SELECT :B2 , T.CAN_BE_NULL, T.... |
82,413 | 82,412 | 1.00 | 0.00 | 0.00 | 1gcnmuw9xtb3k | JDBC Thin Client | SELECT CLS_URI FROM OL$_CLASSE... |
80,664 | 156,230 | 1.94 | 0.00 | 0.00 | cfrwbnuu2xtam | JDBC Thin Client | select side_b from ol$_associa... |
77,356 | 73,771 | 0.95 | 0.00 | 0.00 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
70,123 | 70,123 | 1.00 | 0.00 | 0.00 | g4rzpg6rj116d | JDBC Thin Client | BEGIN OL$_RULE_CORE.SETSTRATTR... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
53,365 | 53,363 | 8.68 | grwydz59pu6mc | select text from view$ where r... | |
51,272 | 51,272 | 8.34 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
9,457 | 12,470 | 1.54 | d3gsxy5k0u8hw | JDBC Thin Client | select * from v$_ST_Asset wher... |
9,289 | 14,449 | 1.51 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
8,703 | 28,452 | 1.42 | 8b9zc43w360qt | JDBC Thin Client | SELECT O_28 partitionField FRO... |
8,519 | 17,957 | 1.39 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
7,786 | 33,283 | 1.27 | 7xgzx0zrnt0fc | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
7,688 | 18,369 | 1.25 | 02djppxs4a73n | JDBC Thin Client | update ol$_locks t set t.obj =... |
7,333 | 13,866 | 1.19 | dnctudjagb520 | JDBC Thin Client | select * from v$_ST_AssetModel... |
6,916 | 10,837 | 1.13 | 244v8yhfs7urr | JDBC Thin Client | SELECT C.CLS_ID, C.CLS_URI, C.... |
6,841 | 23,067 | 1.11 | 6pcrpqf5dkunf | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
6,780 | 12,055 | 1.10 | 1f5c885f3vvfx | JDBC Thin Client | select /*+ index(v$_ST_Asset I... |
6,245 | 80,664 | 1.02 | cfrwbnuu2xtam | JDBC Thin Client | select side_b from ol$_associa... |
Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
1,154,013 | 4 | 0.03 | f8uvk4ymbh19z | JDBC Thin Client | SELECT NAME, TYPE, ACTION_URL,... |
1,071,172 | 156 | 0.03 | awvtdy3vc6fum | JDBC Thin Client | SELECT codeId, codeSortId, par... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
512 | 3,260 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
478 | 4,678 | 83taa7kaw59c1 | select name, intcol#, segcol#,... | |
462 | 3,993 | f8pavn1bvsj7t | select con#, obj#, rcon#, enab... | |
409 | 51,272 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
384 | 154,010 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
377 | 232 | 47r1y8yn34jmj | select default$ from col$ wher... | |
344 | 3,336 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
344 | 3,336 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
329 | 77,356 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
328 | 4 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
254 | 5 | 9qgtwh66xg6nz | update seg$ set type#=:4, bloc... | |
235 | 322 | 8p7gycr8uy2j7 | JDBC Thin Client | update ol$_objects set S_04 = ... |
235 | 322 | 8p7gycr8uy2j7 | JDBC Thin Client | update ol$_objects set S_04 = ... |
177 | 4,190 | 2q93zsrvbdw48 | select grantee#, privilege#, n... | |
137 | 53,363 | grwydz59pu6mc | select text from view$ where r... | |
135 | 4,183 | 6aq34nj2zb2n7 | select col#, grantee#, privile... | |
112 | 6,363 | 6769wyy3yf66f | select pos#, intcol#, col#, sp... | |
86 | 19 | 8rdg2n7g8ftk3 | JDBC Thin Client | update ol$_objects set O_10 = ... |
86 | 19 | 8rdg2n7g8ftk3 | JDBC Thin Client | update ol$_objects set O_10 = ... |
83 | 28 | cma6d053zrny3 | JDBC Thin Client | update ol$_objects set S_35 = ... |
83 | 28 | cma6d053zrny3 | JDBC Thin Client | update ol$_objects set S_35 = ... |
69 | 426,031 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
67 | 98 | 41wp41sp2ns44 | JDBC Thin Client | SELECT TASKID FROM WF_TASK WHE... |
65 | 767 | 0ptxn6whczpaj | JDBC Thin Client | begin insert into indy_online_... |
61 | 101 | 88h1jt12xms4p | JDBC Thin Client | INSERT INTO WF_AMBER.INDYSP_TA... |
59 | 203 | 4nwucqtxta4mt | JDBC Thin Client | SELECT T.INSTANCE_LABEL, T.ACT... |
59 | 1,173 | fasvw7q199577 | select u.name, o.name, t.updat... | |
56 | 203 | 7hft0rhsu4hh2 | JDBC Thin Client | UPDATE WF_NOTIFICATIONS SET FR... |
45 | 109 | 0k8522rmdzg4k | select privilege# from sysauth... | |
45 | 800 | avjzuwm5npxv7 | JDBC Thin Client | select * from indy_menu where ... |
43 | 411 | apsygukcr19bq | JDBC Thin Client | SELECT R.NAME, SUBSTRB(R.DISPL... |
41 | 2 | 0h6b2sajwb74n | select privilege#, level from ... | |
38 | 1,537 | bsm6gmajgmhuu | JDBC Thin Client | select * from indy_menu where ... |
35 | 36 | 750bnanjunuhh | JDBC Thin Client | DELETE FROM OWF_MGR.WF_NOTIFIC... |
35 | 36 | a3rvzd26ud0vu | JDBC Thin Client | DELETE INDYWF_WORKLIST_CUR WHE... |
35 | 70,123 | g4rzpg6rj116d | JDBC Thin Client | BEGIN OL$_RULE_CORE.SETSTRATTR... |
33 | 17 | 2p70njsc3jdvy | JDBC Thin Client | DELETE FROM SGPM.P_TASK_ASSIGN... |
33 | 36 | fbg5fqdjsvbw9 | JDBC Thin Client | DELETE INDYWF_WORKLIST_COM WHE... |
31 | 489 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
31 | 489 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
31 | 14 | 95ugsq968zru6 | JDBC Thin Client | SELECT T.ORG_NAME FROM SGPM.O_... |
29 | 14,449 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
29 | 4,733 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
27 | 40 | 6229274rb7bpc | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
27 | 17,957 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
27 | 80,664 | cfrwbnuu2xtam | JDBC Thin Client | select side_b from ol$_associa... |
27 | 4 | g73tzgnm4722f | select u.name, o.name, trigger... | |
26 | 53,411 | dpqpcqn109dcj | JDBC Thin Client | select * from st_institution_r... |
25 | 8,722 | 5n9d2rmutsfqv | JDBC Thin Client | select t.* from ol$_attr_categ... |
25 | 9,933 | b3gxg1nhmrvnf | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
24 | 5,869 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
24 | 3 | 88awc7wsyhuwm | JDBC Thin Client | update ol$_objects set S_73 = ... |
24 | 3 | 88awc7wsyhuwm | JDBC Thin Client | update ol$_objects set S_73 = ... |
24 | 9 | cjy09frsxfv7n | JDBC Thin Client | SELECT COUNT(*) FROM T_YXDZ_CZ... |
24 | 9 | dtun9pmgvp9a8 | JDBC Thin Client | SELECT COUNT(*) FROM T_YXDZ_CZ... |
23 | 2,280 | 1hnz140zn79uv | JDBC Thin Client | SELECT T.ORG_NAME FROM SGPM.O_... |
23 | 364,141 | 6xz0c679sk859 | JDBC Thin Client | SELECT NAME FROM V$_ST_IDENTIF... |
23 | 2,300 | abhn803avcumh | JDBC Thin Client | SELECT A.USER_BUREAU_NAME FROM... |
23 | 9 | czknwx2xjru6y | JDBC Thin Client | SELECT COUNT(*) FROM T_YXDZ_CZ... |
23 | 13,866 | dnctudjagb520 | JDBC Thin Client | select * from v$_ST_AssetModel... |
23 | 1,509 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
22 | 120 | cs4fxq1s9xvyc | JDBC Thin Client | UPDATE OLIVE.V$_ST_ASSET X SET... |
21 | 12,055 | 1f5c885f3vvfx | JDBC Thin Client | select /*+ index(v$_ST_Asset I... |
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
110.00 | 51.90 | 211.95 | 47.88 | 3 | aw6gj3r2syaxs | JDBC Thin Client | select interdata.area_code, in... |
35.34 | 13.86 | 255.08 | 26.24 | 298 | ab0n17bxfj28d | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
27.93 | 16.55 | 168.76 | 5.91 | 2 | 0js73phthdt42 | JDBC Thin Client | select t.TASK_CD, t.TASK_NO, t... |
11.93 | 8.63 | 138.24 | 6.15 | 7,598 | 9yyb7wvndk114 | JDBC Thin Client | select * from v$_ST_DYLine whe... |
8.54 | 4.43 | 192.69 | 74.48 | 4,733 | 9g4jrwq86jnb7 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKANDUP... |
6.63 | 6.85 | 96.76 | 10.85 | 426,031 | 646v5z184310m | JDBC Thin Client | select t.s_01 from olive.ol$_o... |
6.37 | 17.09 | 37.27 | 5.97 | 78 | 7xn6xppmpg9u7 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
6.14 | 10.07 | 61.03 | 7.38 | 1,768 | g0mmxhhfz1q9g | JDBC Thin Client | select * from v$_LowArea where... |
6.12 | 13.88 | 44.08 | 13.81 | 311 | 4ydgzsjh9kb57 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
5.86 | 13.57 | 43.19 | 4.09 | 436 | 9vrbr3jjprusn | JDBC Thin Client | SELECT B OBJ_ID, (SELECT S_01 ... |
5.45 | 8.62 | 63.24 | 3.13 | 17,957 | a41yvpfth003x | JDBC Thin Client | select * from v$_ST_Equipment ... |
5.13 | 8.89 | 57.77 | 11.22 | 150 | fdckt0yps3750 | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
5.09 | 9.93 | 51.26 | 2.87 | 12,470 | d3gsxy5k0u8hw | JDBC Thin Client | select * from v$_ST_Asset wher... |
4.25 | 7.00 | 60.71 | 2.43 | 120 | 9yh5wgu938tja | JDBC Thin Client | BEGIN OL$_CORE_EXPAND.Batchins... |
4.25 | 7.00 | 60.63 | 2.42 | 120 | cs4fxq1s9xvyc | JDBC Thin Client | UPDATE OLIVE.V$_ST_ASSET X SET... |
3.95 | 4.07 | 97.10 | 54.75 | 263 | dbgctn9f6071v | JDBC Thin Client | SELECT a.obj_id objid, a.cls_u... |
3.39 | 5.33 | 63.55 | 17.63 | 388 | 91d0kuahyy84b | JDBC Thin Client | SELECT tmp.* FROM (SELECT l.ob... |
3.35 | 6.56 | 51.06 | 1.86 | 3,557 | 6xjqy1675jdyr | JDBC Thin Client | select * from v$_ST_EquipmentC... |
3.30 | 21.15 | 15.63 | 8.04 | 781 | 93dtuy0vt2k7q | JDBC Thin Client | SELECT task_id FROM p_task WHE... |
3.25 | 7.76 | 41.84 | 6.26 | 5,869 | 450w20twk6ku5 | JDBC Thin Client | BEGIN OL$_RULE_CORE.CHECKNAMEM... |
3.23 | 7.68 | 42.07 | 9.76 | 393,851 | fkg1futrvwzbg | JDBC Thin Client | SELECT COUNT(1) FROM OL$_ASSOC... |
3.13 | 8.20 | 38.12 | 1.83 | 3,778 | 8txqupfzzqh39 | JDBC Thin Client | select * from v$_ST_EquipmentC... |
3.12 | 30.60 | 10.19 | 1.54 | 14,449 | 449xyhjkn7apn | JDBC Thin Client | select * from v$_ST_EquipmentC... |
3.05 | 15.02 | 20.29 | 9.90 | 417 | 7wgzpzkd96b4p | JDBC Thin Client | SELECT n.id id, n.name name, n... |
2.44 | 5.40 | 45.13 | 3.41 | 248 | 1r7mjtz9kp72t | JDBC Thin Client | select * from (select /*+rule*... |
2.25 | 5.94 | 37.94 | 10.51 | 245 | 830q1znx77va1 | JDBC Thin Client | BEGIN OL$_CORE_EXPAND.LINESUPP... |
2.12 | 6.33 | 33.50 | 2.63 | 154,010 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
2.11 | 9.15 | 23.10 | 1.90 | 4,121 | apd7t7sfn2wxd | JDBC Thin Client | SELECT Getnamepathbyidpath(Pc.... |
1.90 | 8.96 | 21.20 | 7.10 | 364,141 | 6xz0c679sk859 | JDBC Thin Client | SELECT NAME FROM V$_ST_IDENTIF... |
1.70 | 1.29 | 132.20 | 65.82 | 4,993 | 5wfhpq886xacr | JDBC Thin Client | SELECT /*+index(t, NK_OL$_REFS... |
1.07 | 7.41 | 14.42 | 1.12 | 12,055 | 1f5c885f3vvfx | JDBC Thin Client | select /*+ index(v$_ST_Asset I... |
1.02 | 64.86 | 1.58 | 0.46 | 1,509 | ff40ndudptw4c | JDBC Thin Client | DELETE FROM INDY_ONLINE_USER W... |
1.00 | 8.56 | 11.73 | 2.80 | 3,336 | dczy7gkm3mpax | JDBC Thin Client | update ol$_objects set S_04 = ... |
0.88 | 57.02 | 1.54 | 0.65 | 767 | 0ptxn6whczpaj | JDBC Thin Client | begin insert into indy_online_... |
0.86 | 5.31 | 16.19 | 0.49 | 1,130 | cv0rtthxrhdxy | JDBC Thin Client | SELECT O.S_04 || :B2 FROM OL$_... |
0.84 | 1.65 | 50.55 | 1.03 | 53,411 | dpqpcqn109dcj | JDBC Thin Client | select * from st_institution_r... |
0.73 | 12.76 | 5.72 | 0.31 | 33,283 | 7xgzx0zrnt0fc | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
0.70 | 3.71 | 18.95 | 4.21 | 800 | avjzuwm5npxv7 | JDBC Thin Client | select * from indy_menu where ... |
0.65 | 11.90 | 5.48 | 1.76 | 489 | 8d3y3sqaj9f3s | JDBC Thin Client | SELECT * FROM (SELECT row_.*, ... |
0.64 | 14.34 | 4.43 | 0.35 | 28,452 | 8b9zc43w360qt | JDBC Thin Client | SELECT O_28 partitionField FRO... |
0.59 | 29.21 | 2.00 | 0.39 | 6,844 | 95jvxjj84rcct | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
0.53 | 14.44 | 3.65 | 0.38 | 23,067 | 6pcrpqf5dkunf | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
0.52 | 24.17 | 2.15 | 0.44 | 8,387 | 0cxypy0hx9g11 | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
0.49 | 7.45 | 6.64 | 0.35 | 77,356 | 96g93hntrzjtr | select /*+ rule */ bucket_cnt,... | |
0.39 | 2.45 | 15.89 | 9.88 | 67 | 5qr55krh9dkx5 | JDBC Thin Client | select APPLY_ID, APPLY_CD, APP... |
0.29 | 5.25 | 5.52 | 0.24 | 13,866 | dnctudjagb520 | JDBC Thin Client | select * from v$_ST_AssetModel... |
0.28 | 1.46 | 19.10 | 7.31 | 1,537 | bsm6gmajgmhuu | JDBC Thin Client | select * from indy_menu where ... |
0.22 | 9.00 | 2.46 | 0.75 | 3,648 | 5v8y4xqjc73kv | JDBC Thin Client | SELECT Q1.B OBJ_ID FROM OLIVE.... |
0.19 | 1.21 | 15.83 | 8.70 | 219 | 3tw8g2mwh4kgc | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
0.19 | 0.82 | 23.26 | 2.30 | 58 | gkw6wc3pm09j6 | JDBC Thin Client | SELECT USER_NAME FROM AMBER.IN... |
0.19 | 0.72 | 26.21 | 16.04 | 298 | 8u5s8xhp48xm2 | JDBC Thin Client | SELECT * FROM (SELECT D.OBJ_ID... |
0.18 | 1.52 | 11.65 | 7.21 | 11 | 0jat7ccc9fvct | JDBC Thin Client | Select Pc.Obj_Id, Pc.Cls_Uri, ... |
0.17 | 8.47 | 2.07 | 0.17 | 14,153 | b0mb9f2wdgnrk | JDBC Thin Client | select /*+ index(o PK_OL$_OBJE... |
0.17 | 8.69 | 1.94 | 0.12 | 101 | 88h1jt12xms4p | JDBC Thin Client | INSERT INTO WF_AMBER.INDYSP_TA... |
0.11 | 10.77 | 1.03 | 0.06 | 36 | 750bnanjunuhh | JDBC Thin Client | DELETE FROM OWF_MGR.WF_NOTIFIC... |
0.08 | 5.44 | 1.55 | 0.47 | 7 | 5bhhxz06fvgnk | JDBC Thin Client | SELECT OBJ_ID, NAME, A.CLS_URI... |
0.06 | 1.34 | 4.85 | 3.12 | 197 | 9rn5ah9npmbc8 | JDBC Thin Client | WITH CLS_LIST AS (SELECT (SELE... |
0.06 | 10.50 | 0.58 | 0.18 | 349 | dvqv84updkxnc | JDBC Thin Client | SELECT T.OBJ_ID, T.CLS_URI, T.... |
0.05 | 16.76 | 0.31 | 0.05 | 36 | fbg5fqdjsvbw9 | JDBC Thin Client | DELETE INDYWF_WORKLIST_COM WHE... |
0.05 | 13.33 | 0.39 | 0.42 | 322 | 8p7gycr8uy2j7 | JDBC Thin Client | update ol$_objects set S_04 = ... |
0.05 | 1.88 | 2.54 | 0.06 | 51,272 | 2ym6hhaq30r73 | select type#, blocks, extents,... | |
0.04 | 48.32 | 0.07 | 0.04 | 98 | 41wp41sp2ns44 | JDBC Thin Client | SELECT TASKID FROM WF_TASK WHE... |
0.03 | 10.66 | 0.32 | 0.14 | 47 | cr5dhraqryr2f | JDBC Thin Client | Insert Into V$_St_Transmispole... |
0.03 | 14.87 | 0.23 | 0.08 | 13 | gf8k0n5kg6hy2 | JDBC Thin Client | SELECT T.OBJ_ID, T.CLS_URI, T.... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 151,591 | 84.09 | 3.55 |
CPU used when call started | 150,311 | 83.38 | 3.52 |
CR blocks created | 2,777 | 1.54 | 0.06 |
Cached Commit SCN referenced | 5,104,100 | 2,831.17 | 119.44 |
Commit SCN cached | 7 | 0.00 | 0.00 |
DB time | 1,068,558 | 592.71 | 25.00 |
DBWR checkpoint buffers written | 62,970 | 34.93 | 1.47 |
DBWR checkpoints | 4 | 0.00 | 0.00 |
DBWR fusion writes | 17,804 | 9.88 | 0.42 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 143 | 0.08 | 0.00 |
DBWR undo block writes | 10,468 | 5.81 | 0.24 |
DDL statements parallelized | 0 | 0.00 | 0.00 |
DFO trees parallelized | 10 | 0.01 | 0.00 |
DML statements parallelized | 0 | 0.00 | 0.00 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
PX local messages recv'd | 35 | 0.02 | 0.00 |
PX local messages sent | 35 | 0.02 | 0.00 |
PX remote messages recv'd | 179 | 0.10 | 0.00 |
PX remote messages sent | 121 | 0.07 | 0.00 |
Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 10 | 0.01 | 0.00 |
RowCR - row contention | 807 | 0.45 | 0.02 |
RowCR attempts | 78,548 | 43.57 | 1.84 |
RowCR hits | 78,564 | 43.58 | 1.84 |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
SMON posted for undo segment recovery | 1 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 5,160,690 | 2,862.56 | 120.76 |
SQL*Net roundtrips to/from dblink | 115,667 | 64.16 | 2.71 |
active txn count during cleanout | 11,771 | 6.53 | 0.28 |
application wait time | 213 | 0.12 | 0.00 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 0 | 0.00 | 0.00 |
background checkpoints started | 0 | 0.00 | 0.00 |
background timeouts | 14,971 | 8.30 | 0.35 |
branch node splits | 54 | 0.03 | 0.00 |
buffer is not pinned count | 48,677,166 | 27,000.48 | 1,139.05 |
buffer is pinned count | 69,680,085 | 38,650.48 | 1,630.52 |
bytes received via SQL*Net from client | 389,247,355 | 215,909.55 | 9,108.40 |
bytes received via SQL*Net from dblink | 18,940,788 | 10,506.17 | 443.21 |
bytes sent via SQL*Net to client | 4,316,642,958 | 2,394,375.81 | 101,009.55 |
bytes sent via SQL*Net to dblink | 14,240,530 | 7,899.00 | 333.23 |
calls to get snapshot scn: kcmgss | 8,667,184 | 4,807.55 | 202.81 |
calls to kcmgas | 310,629 | 172.30 | 7.27 |
calls to kcmgcs | 8,926 | 4.95 | 0.21 |
change write time | 745 | 0.41 | 0.02 |
cleanout - number of ktugct calls | 23,682 | 13.14 | 0.55 |
cleanouts and rollbacks - consistent read gets | 698 | 0.39 | 0.02 |
cleanouts only - consistent read gets | 11,350 | 6.30 | 0.27 |
cluster key scan block gets | 397,811 | 220.66 | 9.31 |
cluster key scans | 312,717 | 173.46 | 7.32 |
cluster wait time | 60,136 | 33.36 | 1.41 |
commit batch performed | 278 | 0.15 | 0.01 |
commit batch requested | 278 | 0.15 | 0.01 |
commit batch/immediate performed | 348 | 0.19 | 0.01 |
commit batch/immediate requested | 348 | 0.19 | 0.01 |
commit cleanout failures: block lost | 495 | 0.27 | 0.01 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 4,375 | 2.43 | 0.10 |
commit cleanout failures: cannot pin | 5 | 0.00 | 0.00 |
commit cleanouts | 196,709 | 109.11 | 4.60 |
commit cleanouts successfully completed | 191,834 | 106.41 | 4.49 |
commit immediate performed | 70 | 0.04 | 0.00 |
commit immediate requested | 70 | 0.04 | 0.00 |
commit txn count during cleanout | 30,139 | 16.72 | 0.71 |
concurrency wait time | 4,369 | 2.42 | 0.10 |
consistent changes | 111,694 | 61.95 | 2.61 |
consistent gets | 194,196,171 | 107,717.64 | 4,544.19 |
consistent gets - examination | 50,098,471 | 27,788.86 | 1,172.31 |
consistent gets direct | 14,873 | 8.25 | 0.35 |
consistent gets from cache | 194,181,228 | 107,709.36 | 4,543.85 |
current blocks converted for CR | 35 | 0.02 | 0.00 |
cursor authentications | 10,717 | 5.94 | 0.25 |
data blocks consistent reads - undo records applied | 3,764 | 2.09 | 0.09 |
db block changes | 946,125 | 524.80 | 22.14 |
db block gets | 1,280,137 | 710.07 | 29.96 |
db block gets direct | 7,257 | 4.03 | 0.17 |
db block gets from cache | 1,272,880 | 706.05 | 29.79 |
deferred (CURRENT) block cleanout applications | 88,365 | 49.01 | 2.07 |
dirty buffers inspected | 20,303 | 11.26 | 0.48 |
drop segment calls in space pressure | 0 | 0.00 | 0.00 |
enqueue conversions | 238,480 | 132.28 | 5.58 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 553,701 | 307.13 | 12.96 |
enqueue requests | 553,699 | 307.13 | 12.96 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 1,006 | 0.56 | 0.02 |
exchange deadlocks | 9 | 0.00 | 0.00 |
execute count | 5,536,641 | 3,071.09 | 129.56 |
failed probes on index block reclamation | 1 | 0.00 | 0.00 |
frame signature mismatch | 0 | 0.00 | 0.00 |
free buffer inspected | 3,418,280 | 1,896.07 | 79.99 |
free buffer requested | 3,339,364 | 1,852.29 | 78.14 |
gc CPU used by this session | 54,575 | 30.27 | 1.28 |
gc blocks corrupt | 0 | 0.00 | 0.00 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 138 | 0.08 | 0.00 |
gc cr block flush time | 22 | 0.01 | 0.00 |
gc cr block receive time | 5,011 | 2.78 | 0.12 |
gc cr block send time | 333 | 0.18 | 0.01 |
gc cr blocks received | 99,580 | 55.24 | 2.33 |
gc cr blocks served | 88,513 | 49.10 | 2.07 |
gc current block flush time | 36 | 0.02 | 0.00 |
gc current block pin time | 896 | 0.50 | 0.02 |
gc current block receive time | 123,040 | 68.25 | 2.88 |
gc current block send time | 3,598 | 2.00 | 0.08 |
gc current blocks received | 1,380,134 | 765.54 | 32.30 |
gc current blocks served | 978,851 | 542.95 | 22.91 |
gc local grants | 872,864 | 484.16 | 20.43 |
gc remote grants | 966,068 | 535.86 | 22.61 |
gcs messages sent | 5,052,989 | 2,802.82 | 118.24 |
ges messages sent | 226,778 | 125.79 | 5.31 |
global enqueue get time | 4,212 | 2.34 | 0.10 |
global enqueue gets async | 143,194 | 79.43 | 3.35 |
global enqueue gets sync | 850,046 | 471.51 | 19.89 |
global enqueue releases | 994,644 | 551.71 | 23.27 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 7,979 | 4.43 | 0.19 |
hot buffers moved to head of LRU | 4,598,890 | 2,550.93 | 107.61 |
immediate (CR) block cleanout applications | 12,048 | 6.68 | 0.28 |
immediate (CURRENT) block cleanout applications | 24,524 | 13.60 | 0.57 |
index crx upgrade (found) | 0 | 0.00 | 0.00 |
index crx upgrade (positioned) | 22,081 | 12.25 | 0.52 |
index fast full scans (full) | 104,845 | 58.16 | 2.45 |
index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
index fetch by key | 14,498,999 | 8,042.37 | 339.28 |
index scans kdiixs1 | 5,319,721 | 2,950.77 | 124.48 |
leaf node 90-10 splits | 75 | 0.04 | 0.00 |
leaf node splits | 2,079 | 1.15 | 0.05 |
lob reads | 13,299 | 7.38 | 0.31 |
lob writes | 30,157 | 16.73 | 0.71 |
lob writes unaligned | 29,885 | 16.58 | 0.70 |
local undo segment hints helped | 0 | 0.00 | 0.00 |
local undo segment hints were stale | 0 | 0.00 | 0.00 |
logons cumulative | 168 | 0.09 | 0.00 |
messages received | 273,254 | 151.57 | 6.39 |
messages sent | 273,254 | 151.57 | 6.39 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 140,831,954 | 78,117.33 | 3,295.47 |
opened cursors cumulative | 864,319 | 479.42 | 20.23 |
parse count (failures) | 5,322 | 2.95 | 0.12 |
parse count (hard) | 98,835 | 54.82 | 2.31 |
parse count (total) | 614,524 | 340.87 | 14.38 |
parse time cpu | 3,790 | 2.10 | 0.09 |
parse time elapsed | 19,857 | 11.01 | 0.46 |
physical read IO requests | 696,891 | 386.55 | 16.31 |
physical read bytes | 14,919,409,664 | 8,275,568.28 | 349,114.54 |
physical read total IO requests | 803,284 | 445.57 | 18.80 |
physical read total bytes | 16,660,152,320 | 9,241,131.60 | 389,847.95 |
physical read total multi block requests | 96,226 | 53.38 | 2.25 |
physical reads | 1,821,217 | 1,010.20 | 42.62 |
physical reads cache | 1,806,346 | 1,001.95 | 42.27 |
physical reads cache prefetch | 1,215,327 | 674.12 | 28.44 |
physical reads direct | 14,871 | 8.25 | 0.35 |
physical reads direct (lob) | 14,207 | 7.88 | 0.33 |
physical reads direct temporary tablespace | 5 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 89,718 | 49.77 | 2.10 |
physical write bytes | 888,430,592 | 492,798.86 | 20,789.30 |
physical write total IO requests | 183,166 | 101.60 | 4.29 |
physical write total bytes | 1,460,681,728 | 810,217.81 | 34,179.99 |
physical write total multi block requests | 88,185 | 48.91 | 2.06 |
physical writes | 108,451 | 60.16 | 2.54 |
physical writes direct | 7,257 | 4.03 | 0.17 |
physical writes direct (lob) | 5,796 | 3.21 | 0.14 |
physical writes direct temporary tablespace | 1,435 | 0.80 | 0.03 |
physical writes from cache | 101,194 | 56.13 | 2.37 |
physical writes non checkpoint | 95,556 | 53.00 | 2.24 |
pinned buffers inspected | 67 | 0.04 | 0.00 |
pinned cursors current | 116 | 0.06 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 68 | 0.04 | 0.00 |
process last non-idle time | 1,655 | 0.92 | 0.04 |
queries parallelized | 10 | 0.01 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 11,625,216 | 6,448.33 | 272.03 |
recursive cpu usage | 56,636 | 31.42 | 1.33 |
redo blocks written | 518,519 | 287.61 | 12.13 |
redo buffer allocation retries | 0 | 0.00 | 0.00 |
redo entries | 513,347 | 284.75 | 12.01 |
redo log space requests | 0 | 0.00 | 0.00 |
redo log space wait time | 0 | 0.00 | 0.00 |
redo ordering marks | 10,241 | 5.68 | 0.24 |
redo size | 245,210,872 | 136,014.72 | 5,737.94 |
redo subscn max counts | 4,457 | 2.47 | 0.10 |
redo synch time | 6,817 | 3.78 | 0.16 |
redo synch writes | 42,794 | 23.74 | 1.00 |
redo wastage | 11,762,928 | 6,524.72 | 275.25 |
redo write broadcast ack time | 882 | 0.49 | 0.02 |
redo write time | 3,617 | 2.01 | 0.08 |
redo writer latching time | 5 | 0.00 | 0.00 |
redo writes | 44,954 | 24.94 | 1.05 |
rollback changes - undo records applied | 3,907 | 2.17 | 0.09 |
rollbacks only - consistent read gets | 710 | 0.39 | 0.02 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 8,253,502 | 4,578.09 | 193.13 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 581,683 | 322.65 | 13.61 |
session logical reads | 195,476,997 | 108,428.10 | 4,574.17 |
shared hash latch upgrades - no wait | 543,426 | 301.43 | 12.72 |
shared hash latch upgrades - wait | 393 | 0.22 | 0.01 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 418,101 | 231.91 | 9.78 |
sorts (rows) | 20,613,783 | 11,434.15 | 482.36 |
space was found by tune down | 0 | 0.00 | 0.00 |
sql area evicted | 90,855 | 50.40 | 2.13 |
sql area purged | 5,335 | 2.96 | 0.12 |
steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
summed dirty queue length | 30,127 | 16.71 | 0.70 |
switch current to new buffer | 9,884 | 5.48 | 0.23 |
table fetch by rowid | 46,280,467 | 25,671.07 | 1,082.96 |
table fetch continued row | 241,590 | 134.01 | 5.65 |
table scan blocks gotten | 70,396,898 | 39,048.08 | 1,647.29 |
table scan rows gotten | 814,447,369 | 451,761.50 | 19,058.09 |
table scans (cache partitions) | 0 | 0.00 | 0.00 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 680,080 | 377.23 | 15.91 |
total number of times SMON posted | 5 | 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 | 348 | 0.19 | 0.01 |
transaction tables consistent read rollbacks | 9 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 1,032 | 0.57 | 0.02 |
tune down retentions in space pressure | 0 | 0.00 | 0.00 |
undo change vector size | 69,940,332 | 38,794.83 | 1,636.61 |
user I/O wait time | 262,253 | 145.47 | 6.14 |
user calls | 5,509,894 | 3,056.25 | 128.93 |
user commits | 41,491 | 23.01 | 0.97 |
user rollbacks | 1,244 | 0.69 | 0.03 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 284,246 | 157.67 | 6.65 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 5 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 6.7E+13 | 6.7E+13 |
session cursor cache count | 11,297,203 | 11,300,082 |
session uga memory | 6.5E+14 | 6.5E+14 |
opened cursors current | 35,520 | 36,015 |
workarea memory allocated | 5,878 | 15,790 |
logons current | 1,773 | 1,783 |
session uga memory max | 4.8E+12 | 4.8E+12 |
session pga memory | 2.4E+12 | 2.4E+12 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 0 | 0.00 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
DATA_OL | 352,275 | 195 | 4.24 | 3.18 | 17,601 | 10 | 1,158 | 3.13 |
IDX_OL | 197,506 | 110 | 4.73 | 1.00 | 26,866 | 15 | 1,110 | 1.46 |
IDX_SCA7 | 18,820 | 10 | 5.60 | 1.00 | 17,602 | 10 | 1 | 0.00 |
DATA_P | 29,469 | 16 | 3.25 | 1.01 | 1,042 | 1 | 26,501 | 2.36 |
DATA_WF | 23,551 | 13 | 4.66 | 1.26 | 3,759 | 2 | 5,116 | 1.41 |
IDX_WF | 8,360 | 5 | 5.03 | 1.00 | 5,754 | 3 | 751 | 1.77 |
DATA_SCA4 | 9,402 | 5 | 3.05 | 5.22 | 34 | 0 | 4,078 | 2.90 |
DATA_SCA5 | 6,737 | 4 | 3.59 | 6.10 | 41 | 0 | 4,042 | 2.74 |
IDX_P | 4,790 | 3 | 4.71 | 1.00 | 1,856 | 1 | 2,969 | 3.25 |
SYSTEM | 6,266 | 3 | 3.92 | 1.00 | 122 | 0 | 0 | 0.00 |
TEMP | 1,472 | 1 | 0.35 | 1.00 | 3,073 | 2 | 0 | 0.00 |
DATA_BI9 | 4,240 | 2 | 3.05 | 2.32 | 0 | 0 | 0 | 0.00 |
DATA_SCA3 | 4,022 | 2 | 1.42 | 12.53 | 32 | 0 | 3,000 | 2.15 |
DATA_SCA2 | 3,968 | 2 | 1.52 | 12.76 | 44 | 0 | 2,913 | 2.22 |
DATA_SCA1 | 3,796 | 2 | 1.71 | 13.33 | 39 | 0 | 2,936 | 2.10 |
IDX_SCA | 3,283 | 2 | 2.80 | 13.42 | 366 | 0 | 0 | 0.00 |
DATA_YP | 684 | 0 | 4.05 | 1.03 | 2,919 | 2 | 0 | 0.00 |
DATA_SCA6 | 3,464 | 2 | 1.53 | 10.99 | 36 | 0 | 3,977 | 2.14 |
DATA_SCA8 | 3,059 | 2 | 1.96 | 12.34 | 44 | 0 | 3,994 | 2.17 |
IDX_SG | 1,153 | 1 | 5.19 | 1.00 | 1,833 | 1 | 0 | 0.00 |
DATA_SCA7 | 2,898 | 2 | 1.39 | 12.90 | 41 | 0 | 3,977 | 2.02 |
DATA_BI7 | 2,511 | 1 | 3.32 | 2.81 | 0 | 0 | 0 | 0.00 |
DATA_SG | 423 | 0 | 5.08 | 1.02 | 1,449 | 1 | 0 | 0.00 |
SYSAUX | 1,427 | 1 | 4.09 | 1.06 | 432 | 0 | 0 | 0.00 |
LOB_SCA | 0 | 0 | 0.00 | 0.00 | 1,854 | 1 | 0 | 0.00 |
UNDOTBS1 | 435 | 0 | 3.49 | 1.00 | 969 | 1 | 11 | 0.00 |
DATA_BI | 1,072 | 1 | 4.68 | 5.64 | 0 | 0 | 0 | 0.00 |
IDX_SCA6 | 321 | 0 | 5.89 | 1.00 | 205 | 0 | 0 | 0.00 |
IDX_SCA5 | 315 | 0 | 5.56 | 1.00 | 199 | 0 | 0 | 0.00 |
IDX_SCA4 | 325 | 0 | 4.86 | 1.00 | 183 | 0 | 0 | 0.00 |
IDX_SCA3 | 314 | 0 | 5.67 | 1.00 | 192 | 0 | 0 | 0.00 |
DATA_SCA15 | 65 | 0 | 6.62 | 1.00 | 73 | 0 | 0 | 0.00 |
DATA_SCA19 | 61 | 0 | 5.74 | 1.00 | 68 | 0 | 0 | 0.00 |
DATA_SCA20 | 63 | 0 | 5.24 | 1.00 | 60 | 0 | 0 | 0.00 |
DATA_SCA11 | 64 | 0 | 5.16 | 1.00 | 58 | 0 | 0 | 0.00 |
DATA_SCA22 | 63 | 0 | 5.87 | 1.00 | 59 | 0 | 0 | 0.00 |
DATA_SCA23 | 64 | 0 | 6.72 | 1.00 | 58 | 0 | 0 | 0.00 |
DATA_SCA21 | 58 | 0 | 5.86 | 1.00 | 63 | 0 | 0 | 0.00 |
DATA_SCA9 | 62 | 0 | 6.77 | 1.00 | 57 | 0 | 1 | 0.00 |
DATA_SCA14 | 61 | 0 | 7.38 | 1.00 | 52 | 0 | 0 | 0.00 |
DATA_SCA16 | 45 | 0 | 4.89 | 1.00 | 66 | 0 | 0 | 0.00 |
DATA_SCA18 | 47 | 0 | 4.68 | 1.00 | 63 | 0 | 0 | 0.00 |
DATA_SCA13 | 42 | 0 | 5.71 | 1.00 | 66 | 0 | 0 | 0.00 |
DATA_SCA10 | 43 | 0 | 5.81 | 1.00 | 60 | 0 | 0 | 0.00 |
DATA_SCA17 | 42 | 0 | 6.19 | 1.00 | 61 | 0 | 0 | 0.00 |
DATA_SCA24 | 31 | 0 | 7.10 | 1.00 | 59 | 0 | 0 | 0.00 |
DATA_SCA12 | 30 | 0 | 6.67 | 1.00 | 50 | 0 | 0 | 0.00 |
IDX_BI | 48 | 0 | 7.29 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI1 | 46 | 0 | 2.39 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_SCA1 | 14 | 0 | 5.00 | 1.00 | 32 | 0 | 0 | 0.00 |
IDX_SCA2 | 14 | 0 | 5.71 | 1.00 | 29 | 0 | 0 | 0.00 |
IDX_YP | 6 | 0 | 5.00 | 1.00 | 19 | 0 | 0 | 0.00 |
DATA_BI11 | 23 | 0 | 3.48 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | 7 | 0 | 4.29 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | 2 | 0 | 15.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_BI12 | 0 | 0 | 0.00 | 0.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) |
---|---|---|---|---|---|---|---|---|---|
DATA_BI | /dev/rndmis_4g_003 | 43 | 0 | 3.26 | 4.19 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_025 | 31 | 0 | 2.90 | 4.81 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_030 | 53 | 0 | 2.83 | 3.23 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_037 | 20 | 0 | 6.00 | 6.90 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_038 | 15 | 0 | 4.00 | 8.87 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_043 | 33 | 0 | 2.73 | 3.58 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_044 | 9 | 0 | 3.33 | 14.11 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_046 | 17 | 0 | 4.12 | 4.76 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_048 | 22 | 0 | 3.64 | 4.23 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_049 | 52 | 0 | 3.08 | 2.40 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_050 | 31 | 0 | 3.55 | 7.48 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_053 | 18 | 0 | 2.22 | 14.33 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_057 | 28 | 0 | 2.86 | 8.11 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_060 | 19 | 0 | 4.74 | 13.42 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_061 | 32 | 0 | 6.56 | 7.91 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_067 | 30 | 0 | 4.00 | 8.10 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_068 | 21 | 0 | 4.76 | 11.71 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_081 | 89 | 0 | 14.61 | 2.64 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_101 | 57 | 0 | 3.16 | 3.74 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_102 | 20 | 0 | 4.00 | 12.80 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_106 | 33 | 0 | 2.12 | 6.42 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_113 | 28 | 0 | 6.07 | 8.89 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_114 | 52 | 0 | 8.65 | 3.27 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_115 | 56 | 0 | 2.86 | 2.04 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_116 | 8 | 0 | 5.00 | 15.75 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_127 | 33 | 0 | 3.64 | 3.67 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_133 | 8 | 0 | 2.50 | 15.75 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_134 | 79 | 0 | 2.28 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_135 | 11 | 0 | 2.73 | 11.73 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_146 | 8 | 0 | 2.50 | 8.25 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_152 | 20 | 0 | 8.00 | 6.10 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_155 | 40 | 0 | 2.25 | 3.95 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_156 | 8 | 0 | 3.75 | 15.75 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_160 | 9 | 0 | 4.44 | 14.11 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_163 | 13 | 0 | 4.62 | 10.08 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_164 | 16 | 0 | 4.38 | 8.38 | 0 | 0 | 0 | 0.00 |
DATA_BI | /dev/rndmis_4g_167 | 10 | 0 | 1.00 | 12.80 | 0 | 0 | 0 | 0.00 |
DATA_BI11 | /dev/rndmis_8g_022 | 23 | 0 | 3.48 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_BI12 | /dev/rndmis_8g_023 | 0 | 0 | 1 | 0 | 0 | 0.00 | ||
DATA_BI7 | /dev/rndmis_8g_018 | 2,511 | 1 | 3.32 | 2.81 | 0 | 0 | 0 | 0.00 |
DATA_BI9 | /dev/rndmis_8g_020 | 4,240 | 2 | 3.05 | 2.32 | 0 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_015 | 19,522 | 11 | 3.98 | 2.89 | 538 | 0 | 13 | 3.85 |
DATA_OL | /dev/rndmis_4g_016 | 18,188 | 10 | 3.88 | 3.10 | 486 | 0 | 38 | 5.26 |
DATA_OL | /dev/rndmis_4g_017 | 20,261 | 11 | 3.44 | 2.85 | 568 | 0 | 21 | 3.33 |
DATA_OL | /dev/rndmis_4g_018 | 17,596 | 10 | 3.79 | 3.07 | 435 | 0 | 41 | 3.41 |
DATA_OL | /dev/rndmis_4g_019 | 19,212 | 11 | 3.95 | 2.93 | 355 | 0 | 90 | 3.33 |
DATA_OL | /dev/rndmis_4g_020 | 19,242 | 11 | 3.80 | 2.98 | 382 | 0 | 45 | 4.44 |
DATA_OL | /dev/rndmis_4g_021 | 19,164 | 11 | 3.69 | 2.94 | 517 | 0 | 19 | 3.68 |
DATA_OL | /dev/rndmis_4g_022 | 18,384 | 10 | 3.87 | 2.97 | 477 | 0 | 11 | 1.82 |
DATA_OL | /dev/rndmis_4g_023 | 17,930 | 10 | 3.94 | 3.11 | 554 | 0 | 23 | 1.74 |
DATA_OL | /dev/rndmis_4g_024 | 18,252 | 10 | 3.78 | 3.04 | 555 | 0 | 37 | 3.51 |
DATA_OL | /dev/rndmis_4g_026 | 6,178 | 3 | 3.92 | 2.69 | 348 | 0 | 2 | 5.00 |
DATA_OL | /dev/rndmis_4g_028 | 8,113 | 5 | 3.82 | 2.93 | 186 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_034 | 10,262 | 6 | 3.87 | 3.90 | 325 | 0 | 56 | 2.50 |
DATA_OL | /dev/rndmis_4g_035 | 9,026 | 5 | 4.10 | 4.35 | 363 | 0 | 108 | 2.59 |
DATA_OL | /dev/rndmis_4g_040 | 12,841 | 7 | 4.34 | 4.38 | 528 | 0 | 124 | 2.82 |
DATA_OL | /dev/rndmis_4g_041 | 12,444 | 7 | 4.44 | 4.42 | 483 | 0 | 9 | 1.11 |
DATA_OL | /dev/rndmis_4g_058 | 14,077 | 8 | 4.66 | 3.95 | 399 | 0 | 4 | 2.50 |
DATA_OL | /dev/rndmis_4g_059 | 13,702 | 8 | 4.50 | 4.04 | 541 | 0 | 106 | 2.64 |
DATA_OL | /dev/rndmis_4g_071 | 10,063 | 6 | 4.61 | 3.78 | 920 | 1 | 92 | 2.83 |
DATA_OL | /dev/rndmis_4g_072 | 8,927 | 5 | 4.66 | 3.95 | 762 | 0 | 32 | 2.81 |
DATA_OL | /dev/rndmis_4g_075 | 8,734 | 5 | 4.76 | 4.15 | 888 | 0 | 108 | 2.04 |
DATA_OL | /dev/rndmis_4g_079 | 5,076 | 3 | 5.97 | 2.11 | 598 | 0 | 74 | 1.89 |
DATA_OL | /dev/rndmis_4g_080 | 5,306 | 3 | 5.82 | 1.96 | 713 | 0 | 2 | 0.00 |
DATA_OL | /dev/rndmis_4g_083 | 4,729 | 3 | 5.34 | 1.94 | 514 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_084 | 4,357 | 2 | 5.87 | 2.03 | 415 | 0 | 10 | 8.00 |
DATA_OL | /dev/rndmis_4g_085 | 3,211 | 2 | 5.64 | 2.51 | 407 | 0 | 35 | 1.43 |
DATA_OL | /dev/rndmis_4g_086 | 3,861 | 2 | 5.51 | 2.29 | 457 | 0 | 13 | 14.62 |
DATA_OL | /dev/rndmis_4g_087 | 4,182 | 2 | 5.65 | 2.14 | 469 | 0 | 12 | 3.33 |
DATA_OL | /dev/rndmis_4g_088 | 4,189 | 2 | 5.18 | 2.35 | 416 | 0 | 12 | 2.50 |
DATA_OL | /dev/rndmis_4g_092 | 3,885 | 2 | 5.58 | 2.49 | 355 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_210 | 917 | 1 | 5.25 | 1.89 | 284 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_211 | 866 | 0 | 7.92 | 1.23 | 799 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_212 | 282 | 0 | 7.16 | 1.42 | 134 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_4g_213 | 1,808 | 1 | 2.88 | 1.32 | 661 | 0 | 0 | 0.00 |
DATA_OL | /dev/rndmis_8g_043 | 3,640 | 2 | 5.67 | 2.52 | 417 | 0 | 6 | 6.67 |
DATA_OL | /dev/rndmis_8g_044 | 3,848 | 2 | 5.56 | 2.42 | 352 | 0 | 15 | 12.00 |
DATA_P | /dev/rndmis_4g_004 | 199 | 0 | 4.62 | 2.56 | 86 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_027 | 126 | 0 | 4.29 | 1.06 | 50 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_031 | 3,978 | 2 | 1.69 | 1.00 | 32 | 0 | 3,717 | 1.07 |
DATA_P | /dev/rndmis_4g_032 | 4,805 | 3 | 2.10 | 1.00 | 37 | 0 | 4,540 | 1.37 |
DATA_P | /dev/rndmis_4g_033 | 3,758 | 2 | 1.66 | 1.00 | 9 | 0 | 3,693 | 0.96 |
DATA_P | /dev/rndmis_4g_064 | 1,014 | 1 | 2.45 | 1.00 | 7 | 0 | 994 | 1.48 |
DATA_P | /dev/rndmis_4g_065 | 1,040 | 1 | 2.11 | 1.00 | 6 | 0 | 938 | 1.26 |
DATA_P | /dev/rndmis_4g_074 | 1,005 | 1 | 1.45 | 1.00 | 13 | 0 | 1,006 | 0.79 |
DATA_P | /dev/rndmis_4g_099 | 4 | 0 | 5.00 | 2.25 | 18 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_104 | 1,004 | 1 | 5.12 | 1.00 | 2 | 0 | 1,080 | 4.19 |
DATA_P | /dev/rndmis_4g_109 | 1,013 | 1 | 4.76 | 1.00 | 1 | 0 | 1,009 | 3.66 |
DATA_P | /dev/rndmis_4g_121 | 6 | 0 | 3.33 | 1.00 | 3 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_122 | 1,014 | 1 | 4.95 | 1.00 | 0 | 0 | 998 | 3.99 |
DATA_P | /dev/rndmis_4g_123 | 7 | 0 | 4.29 | 1.00 | 1 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_124 | 3 | 0 | 36.67 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_125 | 993 | 1 | 4.51 | 1.00 | 1 | 0 | 1,046 | 3.39 |
DATA_P | /dev/rndmis_4g_128 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_136 | 2 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_137 | 994 | 1 | 5.40 | 1.00 | 0 | 0 | 1,019 | 4.78 |
DATA_P | /dev/rndmis_4g_138 | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_139 | 2 | 0 | 5.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_140 | 1 | 0 | 10.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_141 | 1,001 | 1 | 4.66 | 1.00 | 0 | 0 | 928 | 3.84 |
DATA_P | /dev/rndmis_4g_142 | 996 | 1 | 4.68 | 1.00 | 6 | 0 | 999 | 3.71 |
DATA_P | /dev/rndmis_4g_143 | 984 | 1 | 4.45 | 1.00 | 2 | 0 | 1,074 | 3.55 |
DATA_P | /dev/rndmis_4g_144 | 972 | 1 | 4.88 | 1.00 | 0 | 0 | 932 | 3.85 |
DATA_P | /dev/rndmis_4g_148 | 1,301 | 1 | 5.51 | 1.00 | 38 | 0 | 1,036 | 3.89 |
DATA_P | /dev/rndmis_4g_149 | 1,517 | 1 | 4.85 | 1.00 | 119 | 0 | 1,013 | 3.90 |
DATA_P | /dev/rndmis_4g_150 | 557 | 0 | 4.40 | 1.00 | 31 | 0 | 475 | 4.21 |
DATA_P | /dev/rndmis_4g_153 | 150 | 0 | 1.93 | 1.00 | 49 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_154 | 103 | 0 | 3.40 | 1.00 | 84 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_158 | 55 | 0 | 4.73 | 1.00 | 149 | 0 | 2 | 0.00 |
DATA_P | /dev/rndmis_4g_159 | 21 | 0 | 3.33 | 1.24 | 3 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_165 | 31 | 0 | 4.19 | 1.00 | 6 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_166 | 36 | 0 | 4.72 | 1.00 | 16 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_168 | 154 | 0 | 4.09 | 1.00 | 16 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_169 | 2 | 0 | 10.00 | 1.00 | 1 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_4g_170 | 103 | 0 | 6.02 | 1.01 | 9 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_8g_035 | 373 | 0 | 3.73 | 1.01 | 138 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_8g_038 | 87 | 0 | 5.98 | 1.00 | 35 | 0 | 0 | 0.00 |
DATA_P | /dev/rndmis_8g_061 | 26 | 0 | 7.31 | 1.00 | 72 | 0 | 2 | 0.00 |
DATA_P | /dev/rndmis_8g_062 | 30 | 0 | 6.67 | 1.00 | 0 | 0 | 0 | 0.00 |
DATA_SCA1 | /dev/rndmis_4g_176 | 3,796 | 2 | 1.71 | 13.33 | 39 | 0 | 2,936 | 2.10 |
DATA_SCA10 | /dev/rndmis_4g_187 | 43 | 0 | 5.81 | 1.00 | 60 | 0 | 0 | 0.00 |
DATA_SCA11 | /dev/rndmis_4g_188 | 64 | 0 | 5.16 | 1.00 | 58 | 0 | 0 | 0.00 |
DATA_SCA12 | /dev/rndmis_4g_189 | 30 | 0 | 6.67 | 1.00 | 50 | 0 | 0 | 0.00 |
DATA_SCA13 | /dev/rndmis_4g_190 | 42 | 0 | 5.71 | 1.00 | 66 | 0 | 0 | 0.00 |
DATA_SCA14 | /dev/rndmis_4g_191 | 61 | 0 | 7.38 | 1.00 | 52 | 0 | 0 | 0.00 |
DATA_SCA15 | /dev/rndmis_4g_192 | 65 | 0 | 6.62 | 1.00 | 73 | 0 | 0 | 0.00 |
DATA_SCA16 | /dev/rndmis_4g_193 | 45 | 0 | 4.89 | 1.00 | 66 | 0 | 0 | 0.00 |
DATA_SCA17 | /dev/rndmis_4g_194 | 42 | 0 | 6.19 | 1.00 | 61 | 0 | 0 | 0.00 |
DATA_SCA18 | /dev/rndmis_4g_195 | 47 | 0 | 4.68 | 1.00 | 63 | 0 | 0 | 0.00 |
DATA_SCA19 | /dev/rndmis_4g_196 | 61 | 0 | 5.74 | 1.00 | 68 | 0 | 0 | 0.00 |
DATA_SCA2 | /dev/rndmis_4g_177 | 3,968 | 2 | 1.52 | 12.76 | 44 | 0 | 2,913 | 2.22 |
DATA_SCA20 | /dev/rndmis_4g_197 | 63 | 0 | 5.24 | 1.00 | 60 | 0 | 0 | 0.00 |
DATA_SCA21 | /dev/rndmis_4g_198 | 58 | 0 | 5.86 | 1.00 | 63 | 0 | 0 | 0.00 |
DATA_SCA22 | /dev/rndmis_4g_199 | 63 | 0 | 5.87 | 1.00 | 59 | 0 | 0 | 0.00 |
DATA_SCA23 | /dev/rndmis_4g_200 | 64 | 0 | 6.72 | 1.00 | 58 | 0 | 0 | 0.00 |
DATA_SCA24 | /dev/rndmis_4g_201 | 31 | 0 | 7.10 | 1.00 | 59 | 0 | 0 | 0.00 |
DATA_SCA3 | /dev/rndmis_4g_178 | 4,022 | 2 | 1.42 | 12.53 | 32 | 0 | 3,000 | 2.15 |
DATA_SCA4 | /dev/rndmis_4g_179 | 9,402 | 5 | 3.05 | 5.22 | 34 | 0 | 4,078 | 2.90 |
DATA_SCA5 | /dev/rndmis_4g_180 | 6,737 | 4 | 3.59 | 6.10 | 41 | 0 | 4,042 | 2.74 |
DATA_SCA6 | /dev/rndmis_4g_181 | 3,464 | 2 | 1.53 | 10.99 | 36 | 0 | 3,977 | 2.14 |
DATA_SCA7 | /dev/rndmis_4g_182 | 2,898 | 2 | 1.39 | 12.90 | 41 | 0 | 3,977 | 2.02 |
DATA_SCA8 | /dev/rndmis_4g_183 | 3,059 | 2 | 1.96 | 12.34 | 44 | 0 | 3,994 | 2.17 |
DATA_SCA9 | /dev/rndmis_4g_186 | 62 | 0 | 6.77 | 1.00 | 57 | 0 | 1 | 0.00 |
DATA_SG | /dev/rndmis_4g_009 | 371 | 0 | 5.07 | 1.03 | 1,341 | 1 | 0 | 0.00 |
DATA_SG | /dev/rndmis_8g_013 | 17 | 0 | 5.29 | 1.00 | 70 | 0 | 0 | 0.00 |
DATA_SG | /dev/rndmis_8g_014 | 35 | 0 | 5.14 | 1.00 | 38 | 0 | 0 | 0.00 |
DATA_WF | /dev/rndmis_4g_005 | 9,571 | 5 | 4.14 | 1.55 | 2,526 | 1 | 1,320 | 1.18 |
DATA_WF | /dev/rndmis_4g_036 | 8,259 | 5 | 5.03 | 1.08 | 599 | 0 | 2,380 | 1.34 |
DATA_WF | /dev/rndmis_4g_107 | 5,721 | 3 | 4.99 | 1.03 | 634 | 0 | 1,416 | 1.74 |
DATA_YP | /dev/rndmis_4g_007 | 684 | 0 | 4.05 | 1.03 | 2,919 | 2 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_001 | 32 | 0 | 9.06 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_052 | 5 | 0 | 4.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_055 | 5 | 0 | 2.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI | /dev/rndmis_4g_056 | 6 | 0 | 5.00 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_BI1 | /dev/rndmis_8g_016 | 46 | 0 | 2.39 | 1.00 | 0 | 0 | 0 | 0.00 |
IDX_OL | /dev/rndmis_4g_011 | 18,316 | 10 | 3.27 | 1.00 | 396 | 0 | 236 | 0.81 |
IDX_OL | /dev/rndmis_4g_012 | 20,196 | 11 | 3.19 | 1.00 | 362 | 0 | 269 | 1.12 |
IDX_OL | /dev/rndmis_4g_013 | 18,719 | 10 | 3.23 | 1.00 | 361 | 0 | 138 | 1.52 |
IDX_OL | /dev/rndmis_4g_014 | 17,814 | 10 | 3.39 | 1.00 | 759 | 0 | 220 | 1.18 |
IDX_OL | /dev/rndmis_4g_029 | 12,068 | 7 | 4.29 | 1.00 | 1,309 | 1 | 40 | 1.25 |
IDX_OL | /dev/rndmis_4g_069 | 11,359 | 6 | 4.98 | 1.00 | 764 | 0 | 8 | 2.50 |
IDX_OL | /dev/rndmis_4g_070 | 11,698 | 6 | 5.32 | 1.00 | 647 | 0 | 9 | 4.44 |
IDX_OL | /dev/rndmis_4g_076 | 10,576 | 6 | 5.08 | 1.00 | 506 | 0 | 12 | 3.33 |
IDX_OL | /dev/rndmis_4g_077 | 7,121 | 4 | 6.17 | 1.00 | 1,662 | 1 | 5 | 4.00 |
IDX_OL | /dev/rndmis_4g_078 | 6,382 | 4 | 6.41 | 1.00 | 1,342 | 1 | 1 | 10.00 |
IDX_OL | /dev/rndmis_4g_089 | 6,144 | 3 | 6.35 | 1.00 | 1,339 | 1 | 5 | 4.00 |
IDX_OL | /dev/rndmis_4g_090 | 7,781 | 4 | 6.21 | 1.00 | 1,403 | 1 | 1 | 0.00 |
IDX_OL | /dev/rndmis_4g_091 | 6,288 | 3 | 6.28 | 1.00 | 1,519 | 1 | 0 | 0.00 |
IDX_OL | /dev/rndmis_4g_093 | 6,653 | 4 | 5.36 | 1.00 | 1,057 | 1 | 60 | 2.00 |
IDX_OL | /dev/rndmis_4g_094 | 6,349 | 4 | 5.67 | 1.00 | 1,491 | 1 | 36 | 3.61 |
IDX_OL | /dev/rndmis_4g_095 | 6,176 | 3 | 5.81 | 1.00 | 1,003 | 1 | 25 | 3.20 |
IDX_OL | /dev/rndmis_4g_096 | 5,941 | 3 | 5.92 | 1.00 | 696 | 0 | 9 | 5.56 |
IDX_OL | /dev/rndmis_4g_097 | 3,777 | 2 | 6.35 | 1.00 | 1,818 | 1 | 9 | 4.44 |
IDX_OL | /dev/rndmis_4g_098 | 3,817 | 2 | 6.35 | 1.00 | 2,706 | 2 | 10 | 1.00 |
IDX_OL | /dev/rndmis_4g_108 | 2,776 | 2 | 6.02 | 1.00 | 1,593 | 1 | 13 | 0.00 |
IDX_OL | /dev/rndmis_4g_110 | 1,958 | 1 | 6.32 | 1.00 | 790 | 0 | 0 | 0.00 |
IDX_OL | /dev/rndmis_4g_111 | 1,862 | 1 | 6.78 | 1.00 | 1,021 | 1 | 1 | 0.00 |
IDX_OL | /dev/rndmis_4g_112 | 1,649 | 1 | 6.09 | 1.00 | 680 | 0 | 2 | 10.00 |
IDX_OL | /dev/rndmis_8g_024 | 1,131 | 1 | 5.04 | 1.00 | 852 | 0 | 1 | 10.00 |
IDX_OL | /dev/rndmis_8g_025 | 955 | 1 | 5.20 | 1.00 | 790 | 0 | 0 | 0.00 |
IDX_P | /dev/rndmis_4g_002 | 774 | 0 | 2.30 | 1.00 | 230 | 0 | 411 | 0.51 |
IDX_P | /dev/rndmis_4g_130 | 1,182 | 1 | 4.56 | 1.00 | 338 | 0 | 840 | 2.98 |
IDX_P | /dev/rndmis_4g_131 | 1,074 | 1 | 4.93 | 1.00 | 250 | 0 | 871 | 3.64 |
IDX_P | /dev/rndmis_4g_173 | 1,122 | 1 | 5.29 | 1.00 | 426 | 0 | 846 | 4.47 |
IDX_P | /dev/rndmis_4g_217 | 353 | 0 | 5.98 | 1.00 | 339 | 0 | 1 | 0.00 |
IDX_P | /dev/rndmis_4g_218 | 285 | 0 | 7.12 | 1.00 | 273 | 0 | 0 | 0.00 |
IDX_SCA | /dev/rndmis_4g_208 | 3,115 | 2 | 2.67 | 13.64 | 326 | 0 | 0 | 0.00 |
IDX_SCA | /dev/rndmis_4g_219 | 168 | 0 | 5.06 | 9.27 | 40 | 0 | 0 | 0.00 |
IDX_SCA1 | /dev/rndmis_4g_184 | 14 | 0 | 5.00 | 1.00 | 32 | 0 | 0 | 0.00 |
IDX_SCA2 | /dev/rndmis_4g_185 | 14 | 0 | 5.71 | 1.00 | 29 | 0 | 0 | 0.00 |
IDX_SCA3 | /dev/rndmis_4g_202 | 139 | 0 | 5.32 | 1.00 | 87 | 0 | 0 | 0.00 |
IDX_SCA3 | /dev/rndmis_4g_220 | 175 | 0 | 5.94 | 1.00 | 105 | 0 | 0 | 0.00 |
IDX_SCA4 | /dev/rndmis_4g_203 | 159 | 0 | 3.96 | 1.00 | 79 | 0 | 0 | 0.00 |
IDX_SCA4 | /dev/rndmis_4g_221 | 166 | 0 | 5.72 | 1.00 | 104 | 0 | 0 | 0.00 |
IDX_SCA5 | /dev/rndmis_4g_204 | 164 | 0 | 6.22 | 1.00 | 88 | 0 | 0 | 0.00 |
IDX_SCA5 | /dev/rndmis_4g_222 | 151 | 0 | 4.83 | 1.00 | 111 | 0 | 0 | 0.00 |
IDX_SCA6 | /dev/rndmis_4g_205 | 170 | 0 | 5.41 | 1.00 | 102 | 0 | 0 | 0.00 |
IDX_SCA6 | /dev/rndmis_4g_223 | 151 | 0 | 6.42 | 1.00 | 103 | 0 | 0 | 0.00 |
IDX_SCA7 | /dev/rndmis_8g_011 | 15,091 | 8 | 5.53 | 1.00 | 14,062 | 8 | 0 | 0.00 |
IDX_SCA7 | /dev/rndmis_8g_034 | 3,729 | 2 | 5.89 | 1.00 | 3,540 | 2 | 1 | 0.00 |
IDX_SG | /dev/rndmis_4g_010 | 1,153 | 1 | 5.19 | 1.00 | 1,833 | 1 | 0 | 0.00 |
IDX_WF | /dev/rndmis_4g_006 | 6,178 | 3 | 4.97 | 1.00 | 3,632 | 2 | 442 | 2.04 |
IDX_WF | /dev/rndmis_4g_042 | 2,182 | 1 | 5.21 | 1.00 | 2,122 | 1 | 309 | 1.39 |
IDX_YP | /dev/rndmis_4g_008 | 6 | 0 | 5.00 | 1.00 | 19 | 0 | 0 | 0.00 |
LOB_SCA | /dev/rndmis_8g_006 | 0 | 0 | 4 | 0 | 0 | 0.00 | ||
LOB_SCA | /dev/rndmis_8g_026 | 0 | 0 | 525 | 0 | 0 | 0.00 | ||
LOB_SCA | /dev/rndmis_8g_039 | 0 | 0 | 262 | 0 | 0 | 0.00 | ||
LOB_SCA | /dev/rndmis_8g_040 | 0 | 0 | 1,063 | 1 | 0 | 0.00 | ||
SYSAUX | /dev/rndmis_4g_225 | 42 | 0 | 5.24 | 1.00 | 34 | 0 | 0 | 0.00 |
SYSAUX | /dev/rsysaux_4g | 1,385 | 1 | 4.05 | 1.06 | 398 | 0 | 0 | 0.00 |
SYSTEM | /dev/rsystem_4g | 6,266 | 3 | 3.92 | 1.00 | 122 | 0 | 0 | 0.00 |
TEMP | /dev/rndmis_8g_056 | 292 | 0 | 0.31 | 1.00 | 853 | 0 | 0 | |
TEMP | /dev/rtemp01_16g | 697 | 0 | 0.44 | 1.00 | 1,727 | 1 | 0 | |
TEMP | /dev/rtemp02_16g | 483 | 0 | 0.25 | 1.00 | 493 | 0 | 0 | |
UNDOTBS1 | /dev/rndmis_8g_030 | 0 | 0 | 34 | 0 | 0 | 0.00 | ||
UNDOTBS1 | /dev/rndmis_8g_036 | 1 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS1 | /dev/rundo_1a_16g | 273 | 0 | 3.70 | 1.00 | 565 | 0 | 3 | 0.00 |
UNDOTBS1 | /dev/rundo_1b_16g | 161 | 0 | 3.17 | 1.00 | 370 | 0 | 8 | 0.00 |
UNDOTBS2 | /dev/rndmis_8g_032 | 3 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/rndmis_8g_033 | 3 | 0 | 6.67 | 1.00 | 0 | 0 | 0 | 0.00 |
UNDOTBS2 | /dev/rundo_2b_16g | 1 | 0 | 10.00 | 1.00 | 0 | 0 | 0 | 0.00 |
USERS | /dev/rusers_4g | 2 | 0 | 15.00 | 1.00 | 0 | 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,749,842 | 99 | 195,416,088 | 1,806,161 | 101,292 | 0 | 0 | 66,622 |
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 | 8 | 11981 | 57820 | 477111 | 5640120 | 477111 | |
E | 0 | 9 | 14229 | 73222 | 515357 | 5640120 | 515357 |
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,288 | 0.10 | 274,131 | 1.88 | 13,923,101,168 |
D | 4,576 | 0.20 | 548,262 | 1.72 | 12,747,619,912 |
D | 6,864 | 0.30 | 822,393 | 1.59 | 11,736,348,933 |
D | 9,152 | 0.40 | 1,096,524 | 1.47 | 10,866,928,330 |
D | 11,440 | 0.50 | 1,370,655 | 1.37 | 10,112,458,775 |
D | 13,728 | 0.60 | 1,644,786 | 1.28 | 9,449,131,534 |
D | 16,016 | 0.70 | 1,918,917 | 1.20 | 8,860,272,631 |
D | 18,304 | 0.80 | 2,193,048 | 1.13 | 8,333,703,872 |
D | 20,592 | 0.90 | 2,467,179 | 1.06 | 7,856,871,110 |
D | 22,880 | 1.00 | 2,741,310 | 1.00 | 7,418,966,296 |
D | 22,960 | 1.00 | 2,750,895 | 1.00 | 7,404,751,518 |
D | 25,168 | 1.10 | 3,015,441 | 0.95 | 7,012,173,075 |
D | 27,456 | 1.20 | 3,289,572 | 0.90 | 6,630,650,010 |
D | 29,744 | 1.30 | 3,563,703 | 0.85 | 6,269,336,793 |
D | 32,032 | 1.40 | 3,837,834 | 0.80 | 5,924,074,580 |
D | 34,320 | 1.49 | 4,111,965 | 0.76 | 5,591,679,555 |
D | 36,608 | 1.59 | 4,386,096 | 0.71 | 5,269,381,484 |
D | 38,896 | 1.69 | 4,660,227 | 0.67 | 4,954,242,399 |
D | 41,184 | 1.79 | 4,934,358 | 0.63 | 4,643,500,788 |
D | 43,472 | 1.89 | 5,208,489 | 0.59 | 4,334,806,700 |
D | 45,760 | 1.99 | 5,482,620 | 0.54 | 4,026,397,718 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 23,545 | 0 |
PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
---|---|---|---|---|---|---|---|---|
B | 6,144 | 2,338 | 4,727.87 | 3.81 | 0.08 | 100.00 | 0.00 | 629,140 |
E | 6,144 | 2,306 | 4,756.07 | 14.08 | 0.30 | 100.00 | 0.00 | 629,140 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 244,234 | 244,234 | 0 | 0 |
64K | 128K | 4,923 | 4,923 | 0 | 0 |
128K | 256K | 3,491 | 3,491 | 0 | 0 |
256K | 512K | 5,721 | 5,721 | 0 | 0 |
512K | 1024K | 25,309 | 25,309 | 0 | 0 |
1M | 2M | 148 | 148 | 0 | 0 |
2M | 4M | 391 | 391 | 0 | 0 |
4M | 8M | 13 | 13 | 0 | 0 |
8M | 16M | 10 | 10 | 0 | 0 |
16M | 32M | 5 | 5 | 0 | 0 |
PGA Target Est (MB) | Size Factr | W/A MB Processed | Estd Extra W/A MB Read/ Written to Disk | Estd PGA Cache Hit % | Estd PGA Overalloc Count |
---|---|---|---|---|---|
768 | 0.13 | 55,271,478.97 | 28,929,064.38 | 66.00 | 641,226 |
1,536 | 0.25 | 55,271,478.97 | 28,178,848.31 | 66.00 | 621,776 |
3,072 | 0.50 | 55,271,478.97 | 17,583,981.23 | 76.00 | 340,891 |
4,608 | 0.75 | 55,271,478.97 | 6,311,252.89 | 90.00 | 51,037 |
6,144 | 1.00 | 55,271,478.97 | 1,599,166.42 | 97.00 | 1,828 |
7,373 | 1.20 | 55,271,478.97 | 1,210,768.73 | 98.00 | 1,652 |
8,602 | 1.40 | 55,271,478.97 | 1,210,478.86 | 98.00 | 1,040 |
9,830 | 1.60 | 55,271,478.97 | 1,210,021.78 | 98.00 | 528 |
11,059 | 1.80 | 55,271,478.97 | 1,210,003.44 | 98.00 | 220 |
12,288 | 2.00 | 55,271,478.97 | 1,209,857.67 | 98.00 | 14 |
18,432 | 3.00 | 55,271,478.97 | 1,209,802.66 | 98.00 | 0 |
24,576 | 4.00 | 55,271,478.97 | 1,209,802.66 | 98.00 | 0 |
36,864 | 6.00 | 55,271,478.97 | 1,209,802.66 | 98.00 | 0 |
49,152 | 8.00 | 55,271,478.97 | 1,209,802.66 | 98.00 | 0 |
Shared Pool Size(M) | SP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits (K) |
---|---|---|---|---|---|---|---|---|
2,768 | 0.80 | 398 | 31,987 | 282,649,246 | 1.00 | 776,453 | 1.11 | 3,163,811 |
3,120 | 0.90 | 742 | 53,499 | 282,687,745 | 1.00 | 737,954 | 1.05 | 3,173,294 |
3,472 | 1.00 | 1,093 | 74,486 | 282,725,394 | 1.00 | 700,305 | 1.00 | 3,182,709 |
3,824 | 1.10 | 1,444 | 97,281 | 282,762,257 | 1.00 | 663,442 | 0.95 | 3,192,050 |
4,176 | 1.20 | 1,795 | 119,375 | 282,798,117 | 1.00 | 627,582 | 0.90 | 3,201,278 |
4,528 | 1.30 | 2,144 | 141,220 | 282,833,179 | 1.00 | 592,520 | 0.85 | 3,210,381 |
4,880 | 1.41 | 2,495 | 162,752 | 282,867,490 | 1.00 | 558,209 | 0.80 | 3,219,336 |
5,232 | 1.51 | 2,846 | 185,405 | 282,901,096 | 1.00 | 524,603 | 0.75 | 3,228,130 |
5,584 | 1.61 | 3,196 | 207,773 | 282,934,052 | 1.00 | 491,647 | 0.70 | 3,236,764 |
5,936 | 1.71 | 3,544 | 229,966 | 282,966,412 | 1.00 | 459,287 | 0.66 | 3,245,238 |
6,288 | 1.81 | 3,895 | 251,515 | 282,998,216 | 1.00 | 427,483 | 0.61 | 3,253,547 |
6,640 | 1.91 | 4,246 | 272,304 | 283,029,532 | 1.00 | 396,167 | 0.57 | 3,261,702 |
6,992 | 2.01 | 4,597 | 293,675 | 283,060,433 | 1.00 | 365,266 | 0.52 | 3,269,727 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
6,656 | 0.25 | 37,799,273 | 13,923,144,161 |
13,312 | 0.50 | 29,686,567 | 10,867,205,431 |
19,968 | 0.75 | 24,323,794 | 8,860,519,228 |
26,624 | 1.00 | 20,460,794 | 7,404,746,137 |
33,280 | 1.25 | 17,446,921 | 6,269,598,554 |
39,936 | 1.50 | 16,947,677 | 5,591,323,808 |
46,592 | 1.75 | 16,939,493 | 4,643,516,303 |
53,248 | 2.00 | 16,933,355 | 4,026,700,949 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 0.50 | 17,748 | 33 | 19,466 | 30 |
32 | 1.00 | 0 | 0 | 0 | 0 |
48 | 1.50 | 0 | 0 | 0 | 0 |
64 | 2.00 | 0 | 0 | 0 | 0 |
80 | 2.50 | 0 | 0 | 0 | 0 |
96 | 3.00 | 0 | 0 | 0 | 0 |
112 | 3.50 | 0 | 0 | 0 | 0 |
128 | 4.00 | 0 | 0 | 0 | 0 |
144 | 4.50 | 0 | 0 | 0 | 0 |
160 | 5.00 | 0 | 0 | 0 | 0 |
176 | 5.50 | 0 | 0 | 0 | 0 |
192 | 6.00 | 0 | 0 | 0 | 0 |
208 | 6.50 | 0 | 0 | 0 | 0 |
224 | 7.00 | 0 | 0 | 0 | 0 |
240 | 7.50 | 0 | 0 | 0 | 0 |
256 | 8.00 | 0 | 0 | 0 | 0 |
272 | 8.50 | 0 | 0 | 0 | 0 |
288 | 9.00 | 0 | 0 | 0 | 0 |
304 | 9.50 | 0 | 0 | 0 | 0 |
320 | 10.00 | 0 | 0 | 0 | 0 |
Java Pool Size(M) | JP Size Factr | Est LC Size (M) | Est LC Mem Obj | Est LC Time Saved (s) | Est LC Time Saved Factr | Est LC Load Time (s) | Est LC Load Time Factr | Est LC Mem Obj Hits |
---|---|---|---|---|---|---|---|---|
32 | 0.29 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
48 | 0.43 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
64 | 0.57 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
80 | 0.71 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
96 | 0.86 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
112 | 1.00 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
128 | 1.14 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
144 | 1.29 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
160 | 1.43 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
176 | 1.57 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
192 | 1.71 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
208 | 1.86 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
224 | 2.00 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
240 | 2.14 | 4 | 82 | 3 | 1.00 | 700,306 | 1.00 | 82 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 66,441 | 153 | 2 |
segment header | 142 | 0 | 0 |
1st level bmb | 15 | 0 | 1 |
2nd level bmb | 13 | 0 | 1 |
undo header | 8 | 0 | 0 |
undo block | 3 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TX-Transaction (row lock contention) | 14 | 14 | 0 | 9 | 2 | 234.67 |
HW-Segment High Water Mark | 2,377 | 2,377 | 0 | 343 | 0 | 0.40 |
TX-Transaction (index contention) | 147 | 147 | 0 | 59 | 0 | 1.36 |
TT-Tablespace | 2,294 | 2,294 | 0 | 182 | 0 | 0.43 |
TO-Temp Object | 1,564 | 1,564 | 0 | 102 | 0 | 0.57 |
FB-Format Block | 211 | 211 | 0 | 101 | 0 | 0.54 |
CF-Controlfile Transaction | 36,509 | 36,509 | 0 | 98 | 0 | 0.51 |
PS-PX Process Reservation | 96 | 96 | 0 | 55 | 0 | 0.53 |
TM-DML | 105,921 | 105,920 | 0 | 24 | 0 | 0.75 |
TX-Transaction | 50,143 | 50,139 | 0 | 1 | 0 | 15.00 |
WF-AWR Flush | 20 | 20 | 0 | 9 | 0 | 0.89 |
RO-Multiple Object Reuse (fast object reuse) | 16 | 16 | 0 | 6 | 0 | 0.50 |
TD-KTF map table enqueue (KTF dump entries) | 6 | 6 | 0 | 6 | 0 | 0.50 |
TX-Transaction (allocate ITL entry) | 5 | 5 | 0 | 3 | 0 | 0.67 |
MS-Materialized View Refresh Log | 4 | 4 | 0 | 2 | 0 | 0.50 |
AF-Advisor Framework (task serialization) | 7 | 7 | 0 | 1 | 0 | 1.00 |
DR-Distributed Recovery | 1 | 1 | 0 | 1 | 0 | 0.00 |
JI-Materialized View | 2 | 2 | 0 | 1 | 0 | 0.00 |
JS-Job Scheduler (job run lock - synchronize) | 2 | 2 | 0 | 1 | 0 | 0.00 |
MW-MWIN Schedule | 1 | 1 | 0 | 1 | 0 | 0.00 |
UL-User-defined | 2 | 2 | 0 | 1 | 0 | 0.00 |
Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
1 | 7.68 | 39,975 | 198 | 14 | 10098.7/10101.4 | 0/0 | 0/0/0/0/0/0 |
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
27-Mar 16:19 | 3,521 | 22,144 | 198 | 11 | 10,099 | 0/0 | 0/0/0/0/0/0 |
27-Mar 16:09 | 4,160 | 17,831 | 135 | 14 | 10,101 | 0/0 | 0/0/0/0/0/0 |
Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
---|---|---|---|---|---|---|
ASM db client latch | 1,309 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 67,760 | 0.00 | 0 | 0 | ||
Consistent RBA | 44,969 | 0.00 | 0 | 0 | ||
FAL request queue | 36 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 36 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 3,273 | 0.00 | 0 | 0 | ||
JS broadcast add buf latch | 4,791 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 4,792 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 4,739 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 4 | 0.00 | 0 | 0 | ||
JS queue access latch | 4 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 227,514 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 40 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 17,146,316 | 0.05 | 0.01 | 0 | 7,814 | 0.01 |
KJC message pool free list | 229,314 | 9.17 | 0.00 | 0 | 67,125 | 0.02 |
KJCT flow control latch | 4,374,738 | 0.00 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 601 | 0.00 | 0 | 0 | ||
KSXR large replies | 122 | 0.00 | 0 | 0 | ||
KTF sga latch | 4,704 | 0.00 | 0 | 607 | 0.00 | |
KWQMN job cache list latch | 610 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 225 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 36 | 0.00 | ||
Memory Management Latch | 0 | 0 | 601 | 0.00 | ||
Memory Queue | 446 | 0.00 | 0 | 0 | ||
OS process | 333 | 0.00 | 0 | 0 | ||
OS process allocation | 832 | 0.00 | 0 | 0 | ||
OS process: request allocation | 172 | 0.00 | 0 | 0 | ||
PL/SQL warning settings | 40,108 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 72,469 | 0.01 | 0.00 | 0 | 72,469 | 0.01 |
SQL memory manager latch | 1 | 0.00 | 0 | 600 | 0.00 | |
SQL memory manager workarea list latch | 362,901 | 0.01 | 0.00 | 0 | 0 | |
Shared B-Tree | 1,607 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 53,466 | 0.33 | 0.00 | 0 | 0 | |
active service list | 49,063 | 0.00 | 1.00 | 0 | 249,061 | 0.00 |
archive control | 32 | 0.00 | 0 | 0 | ||
archive process latch | 672 | 0.00 | 0 | 0 | ||
begin backup scn array | 5,277 | 0.02 | 0.00 | 0 | 0 | |
bq:time manger info latch | 64 | 0.00 | 0 | 0 | ||
bufq statistics | 225 | 0.00 | 0 | 0 | ||
business card | 20 | 0.00 | 0 | 0 | ||
cache buffer handles | 41,100 | 0.00 | 0.00 | 0 | 0 | |
cache buffers chains | 350,902,638 | 0.26 | 0.03 | 1 | 10,737,394 | 0.02 |
cache buffers lru chain | 3,390,926 | 0.04 | 0.00 | 0 | 5,264,569 | 0.05 |
cache table scan latch | 0 | 0 | 94,543 | 0.03 | ||
channel handle pool latch | 189 | 0.00 | 0 | 0 | ||
channel operations parent latch | 5,209,000 | 0.00 | 0.00 | 0 | 0 | |
checkpoint queue latch | 1,183,722 | 0.01 | 0.00 | 0 | 127,283 | 0.00 |
client/application info | 1,659 | 0.00 | 0 | 0 | ||
commit callback allocation | 240 | 0.00 | 0 | 0 | ||
compile environment latch | 168 | 0.00 | 0 | 0 | ||
dml lock allocation | 211,818 | 0.03 | 0.00 | 0 | 0 | |
dummy allocation | 326 | 0.00 | 0 | 0 | ||
enqueue hash chains | 1,573,116 | 0.00 | 0.00 | 0 | 1,478 | 0.00 |
enqueues | 2,459,251 | 0.06 | 0.00 | 0 | 0 | |
error message lists | 44 | 0.00 | 0 | 0 | ||
event group latch | 91 | 0.00 | 0 | 0 | ||
file cache latch | 2,276 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 2,476,938 | 0.12 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 32,273,104 | 0.00 | 0 | 193,002 | 0.00 | |
gcs remastering latch | 2,328,450 | 0.00 | 0.50 | 0 | 5,977 | 0.00 |
gcs resource freelist | 2,542,156 | 0.01 | 0.00 | 0 | 1,075,587 | 0.00 |
gcs resource hash | 15,233,625 | 0.23 | 0.00 | 0 | 30 | 0.00 |
gcs resource scan list | 60 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 1,691,246 | 0.00 | 0.00 | 0 | 1,603,255 | 0.00 |
ges caches resource lists | 815,528 | 0.19 | 0.00 | 0 | 261,060 | 0.45 |
ges deadlock list | 16,210 | 0.01 | 0.00 | 0 | 1 | 0.00 |
ges domain table | 1,698,398 | 0.00 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 1,865,760 | 0.00 | 0.00 | 0 | 0 | |
ges group table | 2,542,166 | 0.00 | 0.00 | 0 | 0 | |
ges process hash list | 97,671 | 0.00 | 0 | 0 | ||
ges process parent latch | 4,068,193 | 0.00 | 0.00 | 0 | 0 | |
ges process table freelist | 172 | 0.00 | 0 | 0 | ||
ges resource hash list | 3,528,118 | 0.04 | 0.00 | 0 | 272,660 | 0.00 |
ges resource scan list | 48 | 0.00 | 0 | 0 | ||
ges resource table freelist | 401,114 | 0.01 | 0.00 | 0 | 1 | 0.00 |
ges synchronous data | 32 | 0.00 | 0 | 18,043 | 0.02 | |
ges timeout list | 121,964 | 0.01 | 0.00 | 0 | 63,250 | 0.00 |
global KZLD latch for mem in SGA | 76 | 0.00 | 0 | 0 | ||
global tx hash mapping | 5,900 | 0.00 | 0 | 3 | 0.00 | |
hash table column usage latch | 1,208 | 0.00 | 0 | 765,698 | 0.00 | |
hash table modification latch | 279 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latc | 45 | 0.00 | 0 | 0 | ||
interrupt manipulation | 321 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 64 | 0.00 | ||
job_queue_processes parameter latch | 62 | 0.00 | 0 | 0 | ||
kks stats | 573,947 | 0.05 | 0.00 | 0 | 0 | |
kokc descriptor allocation latch | 164,062 | 0.00 | 0 | 0 | ||
ksuosstats global area | 122 | 0.00 | 0 | 0 | ||
ktm global data | 372 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 1,101 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 45,055 | 0.02 | 0.00 | 0 | 0 | |
library cache | 11,775,739 | 0.05 | 0.00 | 0 | 457,647 | 0.05 |
library cache load lock | 34,588 | 0.00 | 0 | 0 | ||
library cache lock | 19,022,711 | 0.04 | 0.00 | 0 | 0 | |
library cache lock allocation | 29,687 | 0.00 | 0 | 0 | ||
library cache pin | 3,062,027 | 0.02 | 0.00 | 0 | 0 | |
library cache pin allocation | 74,902 | 0.00 | 0.00 | 0 | 0 | |
list of block allocation | 2,818 | 0.00 | 0 | 0 | ||
loader state object freelist | 15,030 | 0.00 | 0 | 0 | ||
logminer context allocation | 1 | 0.00 | 0 | 0 | ||
longop free list parent | 64 | 0.00 | 0 | 23 | 0.00 | |
message pool operations parent latch | 581 | 0.00 | 0 | 0 | ||
messages | 1,033,341 | 0.09 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 46,141 | 2.09 | 0.00 | 0 | 0 | |
multiblock read objects | 486,209 | 0.01 | 0.00 | 0 | 0 | |
name-service memory objects | 31,890 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 27,991 | 0.00 | 0 | 0 | ||
name-service pending queue | 16,110 | 0.00 | 0 | 0 | ||
name-service request queue | 59,336 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 40 | 0.00 | 0 | 0 | ||
object queue header heap | 63,337 | 0.00 | 0 | 69,001 | 0.00 | |
object queue header operation | 7,538,411 | 0.01 | 0.03 | 0 | 0 | |
object stats modification | 82 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 696 | 0.00 | 0 | 0 | ||
parallel query stats | 75 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 10,450 | 0.00 | 0 | 0 | ||
parameter list | 617 | 0.00 | 0 | 0 | ||
parameter table management | 438 | 0.00 | 0 | 0 | ||
post/wait queue | 96,460 | 0.05 | 0.00 | 0 | 42,352 | 0.00 |
process allocation | 12,030 | 0.00 | 0 | 91 | 0.00 | |
process group creation | 172 | 0.00 | 0 | 0 | ||
process queue | 200 | 0.00 | 0 | 0 | ||
process queue reference | 3,904 | 0.00 | 0 | 374 | 0.00 | |
qmn task queue latch | 1,972 | 25.46 | 0.07 | 0 | 0 | |
query server freelists | 154 | 0.00 | 0 | 0 | ||
queue sender's info. latch | 669 | 0.75 | 0.00 | 0 | 0 | |
queued dump request | 8,999 | 0.00 | 0 | 0 | ||
redo allocation | 225,870 | 0.01 | 0.00 | 0 | 513,543 | 0.12 |
redo copy | 0 | 0 | 513,779 | 0.10 | ||
redo writing | 190,086 | 0.07 | 0.00 | 0 | 0 | |
resmgr group change latch | 336 | 0.00 | 0 | 0 | ||
resmgr:active threads | 317 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 153 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 316 | 0.00 | 0 | 0 | ||
resmgr:resource group CPU method | 142 | 0.00 | 0 | 0 | ||
resmgr:schema config | 1 | 0.00 | 0 | 0 | ||
row cache objects | 19,670,774 | 0.28 | 0.00 | 0 | 40,369 | 0.61 |
rules engine rule set statistics | 100 | 0.00 | 0 | 0 | ||
sequence cache | 17,278 | 0.00 | 0 | 0 | ||
session allocation | 3,372,722 | 0.17 | 0.00 | 0 | 0 | |
session idle bit | 12,694,127 | 0.00 | 0.00 | 0 | 0 | |
session state list latch | 384 | 0.00 | 0 | 0 | ||
session switching | 447 | 0.00 | 0 | 0 | ||
session timer | 702 | 0.00 | 0 | 0 | ||
shared pool | 5,906,987 | 0.08 | 0.02 | 1 | 0 | |
shared pool simulator | 684,217 | 0.01 | 0.13 | 0 | 0 | |
simulator hash latch | 10,898,877 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 0 | 0 | 10,715,001 | 0.60 | ||
slave class | 5 | 0.00 | 0 | 0 | ||
slave class create | 20 | 5.00 | 1.00 | 0 | 0 | |
sort extent pool | 10,662 | 0.00 | 0 | 0 | ||
state object free list | 2 | 0.00 | 0 | 0 | ||
statistics aggregation | 21,504 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 7 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 25 | 0.00 | 0 | 0 | ||
threshold alerts latch | 828 | 0.00 | 0 | 0 | ||
transaction allocation | 1,641,548 | 0.00 | 0 | 0 | ||
transaction branch allocation | 6,020 | 0.00 | 0 | 0 | ||
undo global data | 196,857 | 0.01 | 0.00 | 0 | 0 | |
user lock | 483 | 0.00 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
cache buffers chains | 350,902,638 | 905,431 | 27,699 | 882,076 | 0 | 0 | 0 |
row cache objects | 19,670,774 | 55,214 | 4 | 55,210 | 0 | 0 | 0 |
gcs resource hash | 15,233,625 | 34,571 | 10 | 34,562 | 0 | 0 | 0 |
KJC message pool free list | 229,314 | 21,023 | 80 | 20,945 | 0 | 0 | 0 |
KCL gc element parent latch | 17,146,316 | 8,532 | 87 | 8,449 | 0 | 0 | 0 |
session allocation | 3,372,722 | 5,898 | 2 | 5,896 | 0 | 0 | 0 |
library cache | 11,775,739 | 5,800 | 15 | 5,785 | 0 | 0 | 0 |
shared pool | 5,906,987 | 4,572 | 109 | 4,467 | 0 | 0 | 0 |
cache buffers lru chain | 3,390,926 | 1,445 | 1 | 1,444 | 0 | 0 | 0 |
object queue header operation | 7,538,411 | 1,075 | 27 | 1,048 | 0 | 0 | 0 |
qmn task queue latch | 1,972 | 502 | 35 | 467 | 0 | 0 | 0 |
shared pool simulator | 684,217 | 48 | 6 | 42 | 0 | 0 | 0 |
gcs remastering latch | 2,328,450 | 2 | 1 | 1 | 0 | 0 | 0 |
active service list | 49,063 | 1 | 1 | 0 | 0 | 0 | 0 |
slave class create | 20 | 1 | 1 | 0 | 0 | 0 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
KCL gc element parent latch | kclnfndnewm | 0 | 420 | 60 |
KCL gc element parent latch | kclbla | 0 | 18 | 1 |
KCL gc element parent latch | kclplz | 0 | 16 | 98 |
KCL gc element parent latch | kclnfnd | 0 | 15 | 17 |
KCL gc element parent latch | kclzcl | 0 | 15 | 139 |
KCL gc element parent latch | kclrwrite | 0 | 11 | 5 |
KCL gc element parent latch | kclwrt | 0 | 9 | 2 |
KCL gc element parent latch | kclgcr | 0 | 7 | 1 |
KCL gc element parent latch | kclple_1 | 0 | 7 | 0 |
KCL gc element parent latch | kclfwrite1 | 0 | 5 | 7 |
KCL gc element parent latch | KCLUNLNK | 0 | 3 | 100 |
KCL gc element parent latch | kclulb | 0 | 3 | 76 |
KJC message pool free list | kjcsmpav: allocate a msg buffer | 0 | 80 | 80 |
active service list | kswssyis: find service entry 1 | 0 | 1 | 0 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 31,539 | 38,351 |
cache buffers chains | kclcls_3 | 0 | 11,000 | 12 |
cache buffers chains | kcbrls: kslbegin | 0 | 464 | 432 |
cache buffers chains | kcbgtcr: kslbegin shared | 0 | 117 | 72 |
cache buffers chains | kcbgtcr: fast path | 0 | 106 | 53 |
cache buffers chains | kclwrt | 0 | 45 | 0 |
cache buffers chains | kcbzwb | 0 | 18 | 4,359 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 17 | 9 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 17 | 0 |
cache buffers chains | kcbzib: multi-block read: nowait | 0 | 10 | 0 |
cache buffers chains | kclexpandlock | 0 | 10 | 0 |
cache buffers chains | kcbgcur: kslbegin | 0 | 3 | 5 |
cache buffers chains | kcbgtcr | 0 | 3 | 0 |
cache buffers chains | kcbbxsv | 0 | 2 | 46 |
cache buffers chains | kcbget: pin buffer | 0 | 2 | 2 |
cache buffers chains | kcbzib: finish free bufs | 0 | 2 | 0 |
cache buffers chains | kclbla | 0 | 1 | 0 |
cache buffers chains | kclebs_1 | 0 | 1 | 1 |
cache buffers lru chain | kcbzgb: wait - one set in buffer pool | 0 | 1 | 1 |
event range base latch | No latch | 0 | 35 | 35 |
gcs remastering latch | 43 | 0 | 1 | 0 |
gcs resource hash | kjbcropen:affinity | 0 | 6 | 2 |
gcs resource hash | kjbrrcfwst | 0 | 3 | 1 |
gcs resource hash | kjbcropen | 0 | 1 | 0 |
library cache | kgldte: child 0 | 0 | 3 | 6 |
library cache | kglic | 0 | 3 | 0 |
library cache | kglpndl: child: after processing | 0 | 3 | 0 |
library cache | kqlmbpil: parent | 0 | 1 | 0 |
library cache lock | kgllkdl: child: no lock handle | 0 | 2 | 0 |
object queue header operation | kclobj_1 | 0 | 23 | 12 |
object queue header operation | kcbw_unlink_q | 0 | 6 | 20 |
object queue header operation | kcbw_link_q | 0 | 4 | 0 |
object queue header operation | kcbo_switch_mq_bg | 0 | 3 | 4 |
object queue header operation | kcbo_switch_q_bg | 0 | 2 | 1 |
row cache objects | kqreqd: reget | 0 | 3 | 0 |
row cache objects | kqrpre: find obj | 0 | 1 | 4 |
session allocation | ksucri | 0 | 1 | 2 |
session allocation | ksufap: active sessions | 0 | 1 | 0 |
session idle bit | ksupuc: set busy | 0 | 1 | 0 |
shared pool | kghupr1 | 0 | 83 | 59 |
shared pool | kghalo | 0 | 22 | 22 |
shared pool | kghfrunp: clatch: nowait | 0 | 3 | 0 |
shared pool | kghfre | 0 | 2 | 18 |
shared pool | kghfrunp: alloc: wait | 0 | 2 | 0 |
shared pool simulator | kglsim_unpin_simhp | 0 | 5 | 1 |
shared pool simulator | kglsim_scan_lru: scan | 0 | 1 | 4 |
slave class create | ksvcreate | 0 | 1 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | PK_OL$_ATTR_DEFS | INDEX | 33,672,720 | 17.23 | |
OLIVE | DATA_OL | OL$_CLASSES | TABLE | 29,282,384 | 14.98 | |
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 19,709,472 | 10.08 | |
AMBER | IDX_WF | UK_USER_ACTION_BAK | INDEX | 10,141,376 | 5.19 | |
AMBER | IDX_WF | NDX_INDY_USER_PROFILE | INDEX | 7,363,488 | 3.77 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 107,876 | 5.92 | |
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 51,181 | 2.81 | |
OLIVE | IDX_OL | NK_OL$_REFS_URI_B | INDEX | 32,307 | 1.77 | |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340308 | TABLE PARTITION | 26,959 | 1.48 |
OLIVE | IDX_OL | OL$_ASSOCIATIONS_N1 | INDEX | 25,744 | 1.41 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | OL$_EVENT_LOG_D1 | INDEX | 43 | 29.66 | |
OLIVE | IDX_OL | OL$_EVENT_LOG_N1 | INDEX | 27 | 18.62 | |
SCADA | IDX_SCA6 | IDX_MEASURE_N2 | 201303_S12 | INDEX SUBPARTITION | 5 | 3.45 |
SCADA | IDX_SCA4 | IDX_MEASURE_N2 | 201303_S14 | INDEX SUBPARTITION | 5 | 3.45 |
** UNAVAILABLE ** | ** UNAVAILABLE ** | ** UNAVAILABLE ** | AILABLE ** | UNDEFINED | 4 | 2.76 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | OL$_EVENT_LOG_D1 | INDEX | 2 | 66.67 | |
SCADA | IDX_SCA6 | IDX_MEASURE_N2 | P201303_S8 | INDEX SUBPARTITION | 1 | 33.33 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
OLIVE | DATA_OL | OL$_OBJECTS | _134052003 | TABLE PARTITION | 46 | 55.42 |
** UNAVAILABLE ** | ** UNAVAILABLE ** | ** UNAVAILABLE ** | AILABLE ** | UNDEFINED | 16 | 19.28 |
OLIVE | IDX_OL | OL$_ASSOCIATIONS_N1 | INDEX | 11 | 13.25 | |
OLIVE | IDX_OL | OL$_EVENT_LOG_D1 | INDEX | 3 | 3.61 | |
OLIVE | IDX_OL | OL$_OBJECTS_N2 | _134052003 | INDEX PARTITION | 3 | 3.61 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
SCADA | DATA_SCA2 | SCADA_INTERFACE_DATA_BD | P201303_S2 | TABLE SUBPARTITION | 1,131 | 6.67 |
SCADA | DATA_SCA1 | SCADA_INTERFACE_DATA_BD | P201303_S1 | TABLE SUBPARTITION | 1,126 | 6.64 |
SCADA | DATA_SCA5 | SCADA_INTERFACE_DATA_BD | P201303_S5 | TABLE SUBPARTITION | 1,124 | 6.63 |
SCADA | DATA_SCA6 | SCADA_INTERFACE_DATA_BD | P201303_S6 | TABLE SUBPARTITION | 1,107 | 6.53 |
SCADA | DATA_SCA3 | SCADA_INTERFACE_DATA_BD | P201303_S3 | TABLE SUBPARTITION | 1,094 | 6.45 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 7,140 | 7.17 | |
OLIVE | IDX_OL | NK_OL$_REFS_URI_A | INDEX | 6,896 | 6.93 | |
SGPM | DATA_SG | P_TASK | TABLE | 6,238 | 6.26 | |
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 3,949 | 3.97 | |
OLIVE | IDX_OL | OL$_ASSOCIATIONS_N1 | INDEX | 2,649 | 2.66 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
OLIVE | IDX_OL | OL$_OBJECTS_U1 | INDEX | 78,277 | 5.67 | |
OLIVE | DATA_OL | OL$_ASSOCIATIONS | TABLE | 77,094 | 5.59 | |
AMBER | DATA_WF | INDY_USER_ACTION | P1340500 | TABLE PARTITION | 42,105 | 3.05 |
OLIVE | IDX_OL | OL$_ASSOCIATIONS_N1 | INDEX | 35,871 | 2.60 | |
OLIVE | DATA_OL | OL$_OBJECTS_R01 | P_1340308 | TABLE PARTITION | 33,007 | 2.39 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 34 | 20.59 | 0 | 2 | 1 | |
dc_database_links | 118,997 | 0.01 | 0 | 0 | 4 | |
dc_files | 2,232 | 25.00 | 0 | 0 | 0 | |
dc_global_oids | 83,531 | 0.45 | 0 | 0 | 6 | |
dc_histogram_data | 4,057,129 | 3.77 | 0 | 0 | 13,317 | |
dc_histogram_defs | 1,193,881 | 6.45 | 0 | 64 | 5,252 | |
dc_object_grants | 1,201 | 38.97 | 0 | 0 | 32 | |
dc_object_ids | 1,768,743 | 0.36 | 0 | 13 | 984 | |
dc_objects | 199,945 | 2.70 | 0 | 31 | 560 | |
dc_profiles | 110 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 22,331 | 0.00 | 0 | 0 | 953 | |
dc_segments | 217,413 | 23.40 | 0 | 34 | 1,161 | |
dc_sequences | 119 | 46.22 | 0 | 119 | 2 | |
dc_table_scns | 207 | 13.53 | 0 | 4 | 2 | |
dc_tablespace_quotas | 136 | 44.12 | 0 | 0 | 4 | |
dc_tablespaces | 223,603 | 0.14 | 0 | 0 | 40 | |
dc_usernames | 10,182 | 1.52 | 0 | 0 | 13 | |
dc_users | 988,380 | 0.02 | 0 | 0 | 36 | |
outstanding_alerts | 398 | 100.00 | 0 | 0 | 0 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 11 | 0 | 7 |
dc_database_links | 6 | 0 | 6 |
dc_files | 558 | 0 | 837 |
dc_global_oids | 377 | 0 | 451 |
dc_histogram_defs | 76,896 | 0 | 78,140 |
dc_object_ids | 6,400 | 0 | 6,789 |
dc_objects | 5,399 | 0 | 5,527 |
dc_segments | 50,922 | 8 | 51,617 |
dc_sequences | 238 | 9 | 46 |
dc_table_scns | 35 | 0 | 29 |
dc_tablespace_quotas | 128 | 5 | 54 |
dc_tablespaces | 311 | 0 | 338 |
dc_usernames | 155 | 0 | 162 |
dc_users | 130 | 0 | 134 |
outstanding_alerts | 794 | 0 | 398 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 703 | 7.25 | 256,853 | 0.11 | 230 | 0 |
CLUSTER | 308 | 3.25 | 504 | 3.77 | 9 | 0 |
INDEX | 13,040 | 0.30 | 178,181 | 0.08 | 100 | 0 |
JAVA DATA | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
JAVA RESOURCE | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
JAVA SOURCE | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
SQL AREA | 398,596 | 42.80 | 6,823,477 | 6.63 | 19,226 | 8,491 |
TABLE/PROCEDURE | 54,190 | 2.08 | 1,069,551 | 1.55 | 9,675 | 0 |
TRIGGER | 171 | 28.07 | 1,458 | 6.79 | 51 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
CLUSTER | 504 | 10 | 9 | 10 | 0 |
INDEX | 178,177 | 39 | 42 | 36 | 0 |
JAVA DATA | 3 | 3 | 5 | 0 | 0 |
JAVA RESOURCE | 3 | 3 | 4 | 0 | 0 |
JAVA SOURCE | 3 | 3 | 5 | 0 | 0 |
TABLE/PROCEDURE | 299,282 | 862 | 1,030 | 526 | 0 |
TRIGGER | 3 | 48 | 45 | 45 | 0 |
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 | 3,786.79 | 2.13 | 8.63 | 353 | 353 | 1,775 | 1,775 | |
Freeable | 769.56 | 0.00 | 0.73 | 0.27 | 2 | 1,057 | 1,057 | ||
PL/SQL | 188.10 | 44.41 | 0.11 | 3.00 | 126 | 126 | 1,774 | 1,774 | |
SQL | 109.31 | 8.36 | 0.06 | 0.09 | 2 | 210 | 1,741 | 1,733 | |
E | Other | 3,834.60 | 2.15 | 8.61 | 353 | 353 | 1,785 | 1,785 | |
Freeable | 737.94 | 0.00 | 0.69 | 0.28 | 2 | 1,070 | 1,070 | ||
PL/SQL | 188.42 | 44.59 | 0.11 | 2.99 | 126 | 126 | 1,784 | 1,784 | |
SQL | 125.49 | 22.42 | 0.07 | 0.28 | 10 | 210 | 1,751 | 1,743 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 24,075,304,960 | |
Fixed Size | 2,147,040 | |
Redo Buffers | 48,181,248 | |
Variable Size | 3,791,654,176 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 106.52 | 106.52 | 0.00 |
java | joxlod exec hp | 5.38 | 5.38 | 0.00 |
large | PX msg pool | 1.03 | 1.03 | 0.00 |
large | free memory | 14.97 | 14.97 | 0.00 |
shared | ASH buffers | 68.00 | 68.00 | 0.00 |
shared | CCursor | 70.08 | 72.17 | 3.00 |
shared | Checkpoint queue | 62.52 | 62.52 | 0.00 |
shared | KGH: NO ACCESS | 677.17 | 677.17 | 0.00 |
shared | PCursor | 50.61 | 51.09 | 0.95 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | event statistics per sess | 49.73 | 49.73 | 0.00 |
shared | free memory | 852.34 | 854.70 | 0.28 |
shared | gcs resources | 644.30 | 644.30 | 0.00 |
shared | gcs shadows | 298.64 | 298.64 | 0.00 |
shared | ges enqueues | 102.62 | 102.62 | 0.00 |
shared | ges resource | 63.12 | 62.56 | -0.88 |
shared | kglsim object batch | 68.52 | 68.52 | 0.00 |
shared | library cache | 104.29 | 104.17 | -0.11 |
shared | obj stat memo | 167.95 | 167.98 | 0.01 |
shared | sql area | 88.86 | 92.19 | 3.75 |
shared | trace buffer | 60.08 | 60.08 | 0.00 |
streams | KGH: NO ACCESS | 15.99 | 15.99 | 0.00 |
streams | Sender info | 4.50 | 4.50 | 0.00 |
streams | free memory | 31.20 | 31.20 | 0.00 |
streams | kwqbcqini:spilledovermsgs | 0.63 | 0.63 | 0.00 |
buffer_cache | 22,960.00 | 22,960.00 | 0.00 | |
fixed_sga | 2.05 | 2.05 | 0.00 | |
log_buffer | 45.95 | 45.95 | 0.00 |
Session Type | CPU Time | User I/O Time | Sys I/O Time |
---|---|---|---|
QMON Slaves | 270,000 | 42,435 | 0 |
QMON Coordinator | 190,000 | 0 | 0 |
Queue Schema and Name | Incoming per second | Outgoing per second | Spilled per second | Diff Pct Spilled |
---|---|---|---|---|
SYS.KUPC$S_1_20130323232332 | 0 | 0 | 0 | 0 |
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 0 | 0 | 0 | 0 | 0 |
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
gcs_resources | 1,885,132 | 3,367,550 | 3227533 | 3227533 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /oracle/product/admin/ndmis/adump | |
background_dump_dest | /oracle/product/admin/ndmis/bdump | |
cluster_database | TRUE | |
cluster_database_instances | 2 | |
compatible | 10.2.0.5.0 | |
control_files | /dev/rctrl_01_128m, /dev/rctrl_02_128m, /dev/rctrl_03_128m | |
core_dump_dest | /oracle/product/admin/ndmis/cdump | |
db_block_size | 8192 | |
db_domain | ||
db_file_multiblock_read_count | 16 | |
db_files | 2000 | |
db_name | ndmis | |
dispatchers | (PROTOCOL=TCP) (SERVICE=ndmisXDB) | |
instance_number | 1 | |
job_queue_processes | 20 | |
local_listener | (ADDRESS = (PROTOCOL = TCP)(HOST = 10.122.6.71)(PORT = 1521)) | |
log_archive_dest | /arch01 | |
log_archive_dest_1 | ||
nls_language | AMERICAN | |
nls_length_semantics | BYTE | |
open_cursors | 3000 | |
optimizer_index_cost_adj | 20 | |
optimizer_mode | ALL_ROWS | |
pga_aggregate_target | 6442450944 | |
processes | 5000 | |
remote_listener | LISTENERS_NDMIS | |
remote_login_passwordfile | EXCLUSIVE | |
service_names | SYS$SYS.KUPC$S_1_20130323232332.NDMIS, nd_mis, ndmis | |
sessions | 5505 | |
sga_target | 27917287424 | |
spfile | /dev/rspfile_128m | |
thread | 1 | |
undo_management | AUTO | |
undo_tablespace | UNDOTBS1 | |
user_dump_dest | /oracle/product/admin/ndmis/udump |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 26,643 | 14.78 | 0.62 |
acks for commit broadcast(logical) | 31,738 | 17.60 | 0.74 |
broadcast msgs on commit(actual) | 44,715 | 24.80 | 1.05 |
broadcast msgs on commit(logical) | 44,953 | 24.93 | 1.05 |
broadcast msgs on commit(wasted) | 7,522 | 4.17 | 0.18 |
broadcast on commit wait time(ms) | 7,159 | 3.97 | 0.17 |
broadcast on commit waits | 35,794 | 19.85 | 0.84 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 2 | 0.00 | 0.00 |
flow control messages received | 0 | 0.00 | 0.00 |
flow control messages sent | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 535,745 | 297.17 | 12.54 |
gcs ast xid | 6 | 0.00 | 0.00 |
gcs blocked converts | 48,058 | 26.66 | 1.12 |
gcs blocked cr converts | 88,183 | 48.91 | 2.06 |
gcs compatible basts | 1,363 | 0.76 | 0.03 |
gcs compatible cr basts (global) | 10,588 | 5.87 | 0.25 |
gcs compatible cr basts (local) | 1,183,673 | 656.57 | 27.70 |
gcs cr basts to PIs | 0 | 0.00 | 0.00 |
gcs cr serve without current lock | 0 | 0.00 | 0.00 |
gcs dbwr flush pi msgs | 14,722 | 8.17 | 0.34 |
gcs dbwr write request msgs | 11,739 | 6.51 | 0.27 |
gcs error msgs | 0 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 19,355 | 10.74 | 0.45 |
gcs immediate (null) converts | 121,517 | 67.40 | 2.84 |
gcs immediate cr (compatible) converts | 320 | 0.18 | 0.01 |
gcs immediate cr (null) converts | 1,725,108 | 956.89 | 40.37 |
gcs indirect ast | 278,355 | 154.40 | 6.51 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 5,353 | 2.97 | 0.13 |
gcs msgs process time(ms) | 208,069 | 115.41 | 4.87 |
gcs msgs received | 4,666,766 | 2,588.58 | 109.20 |
gcs out-of-order msgs | 0 | 0.00 | 0.00 |
gcs pings refused | 351 | 0.19 | 0.01 |
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 | 4 | 0.00 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 79 | 0.04 | 0.00 |
gcs side channel msgs actual | 87,581 | 48.58 | 2.05 |
gcs side channel msgs logical | 1,807,104 | 1,002.37 | 42.29 |
gcs stale cr | 294 | 0.16 | 0.01 |
gcs undo cr | 67 | 0.04 | 0.00 |
gcs write notification msgs | 1,015 | 0.56 | 0.02 |
gcs writes refused | 37 | 0.02 | 0.00 |
ges msgs process time(ms) | 2,145 | 1.19 | 0.05 |
ges msgs received | 242,071 | 134.27 | 5.66 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 0 | 0.00 | 0.00 |
global posts queued | 0 | 0.00 | 0.00 |
global posts requested | 0 | 0.00 | 0.00 |
global posts sent | 0 | 0.00 | 0.00 |
implicit batch messages received | 334,583 | 185.59 | 7.83 |
implicit batch messages sent | 323,793 | 179.60 | 7.58 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 125,202 | 69.45 | 2.93 |
messages queue sent actual | 805,834 | 446.98 | 18.86 |
messages queue sent logical | 2,016,868 | 1,118.73 | 47.19 |
messages received actual | 1,883,150 | 1,044.55 | 44.07 |
messages received logical | 4,908,897 | 2,722.89 | 114.87 |
messages sent directly | 883,522 | 490.08 | 20.67 |
messages sent indirectly | 1,775,946 | 985.09 | 41.56 |
messages sent not implicit batched | 482,071 | 267.40 | 11.28 |
messages sent pbatched | 2,628,159 | 1,457.80 | 61.50 |
msgs causing lmd to send msgs | 82,317 | 45.66 | 1.93 |
msgs causing lms(s) to send msgs | 134,437 | 74.57 | 3.15 |
msgs received queue time (ms) | 35,481 | 19.68 | 0.83 |
msgs received queued | 4,908,568 | 2,722.71 | 114.86 |
msgs sent queue time (ms) | 779,490 | 432.37 | 18.24 |
msgs sent queue time on ksxp (ms) | 614,759 | 341.00 | 14.39 |
msgs sent queued | 1,923,659 | 1,067.02 | 45.01 |
msgs sent queued on ksxp | 1,973,182 | 1,094.49 | 46.17 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 373,613 | 207.24 | 8.74 |
process batch messages sent | 449,999 | 249.61 | 10.53 |
Statistic | Total |
---|---|
CR Block Requests | 86,543 |
CURRENT Block Requests | 1,930 |
Data Block Requests | 86,543 |
Undo Block Requests | 65 |
TX Block Requests | 391 |
Current Results | 88,152 |
Private results | 83 |
Zero Results | 237 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 17,851 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 121 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 246 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 978,593 | 99.99 | 0.00 | 0.01 | 0.00 | 0.00 |
Flushes | 250 | 80.00 | 16.00 | 4.00 | 0.00 | 0.00 |
Writes | 17,781 | 53.28 | 40.63 | 4.86 | 0.42 | 0.82 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
2 | data block | 97,314 | 99.71 | 0.11 | 0.18 | 1,376,736 | 98.01 | 0.02 | 1.97 |
2 | Others | 1,635 | 99.94 | 0.06 | 0.00 | 2,755 | 99.89 | 0.04 | 0.07 |
2 | undo header | 553 | 97.65 | 2.35 | 0.00 | 171 | 96.49 | 3.51 | 0.00 |
2 | undo block | 97 | 97.94 | 2.06 | 0.00 | 0 |