DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
---|---|---|---|---|---|---|
ACSDB | 3302263338 | acsdb2 | 2 | 10.2.0.5.0 | YES | OMP-ACS-DB2 |
Snap Id | Snap Time | Sessions | Cursors/Session | |
---|---|---|---|---|
Begin Snap: | 572 | 07-3ÔÂ -13 10:54:50 | 1200 | .3 |
End Snap: | 574 | 07-3ÔÂ -13 15:23:55 | 1195 | .4 |
Elapsed: | 269.08 (mins) | |||
DB Time: | 74.89 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 29,328M | 29,328M | Std Block Size: | 8K |
Shared Pool Size: | 3,344M | 3,344M | Log Buffer: | 14,272K |
Per Second | Per Transaction | |
---|---|---|
Redo size: | 6,206.76 | 2,896.73 |
Logical reads: | 3,707.35 | 1,730.24 |
Block changes: | 23.07 | 10.77 |
Physical reads: | 6.30 | 2.94 |
Physical writes: | 2.32 | 1.08 |
User calls: | 143.73 | 67.08 |
Parses: | 57.40 | 26.79 |
Hard parses: | 0.44 | 0.21 |
Sorts: | 32.04 | 14.95 |
Logons: | 3.48 | 1.63 |
Executes: | 55.13 | 25.73 |
Transactions: | 2.14 |
% Blocks changed per Read: | 0.62 | Recursive Call %: | 58.77 |
Rollback per transaction %: | 6.82 | Rows per Sort: | 11.73 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 100.16 | In-memory Sort %: | 100.00 |
Library Hit %: | 98.84 | Soft Parse %: | 99.23 |
Execute to Parse %: | -4.13 | Latch Hit %: | 99.89 |
Parse CPU to Parse Elapsd %: | 87.70 | % Non-Parse CPU: | 97.43 |
Begin | End | |
---|---|---|
Memory Usage %: | 80.92 | 82.86 |
% SQL with executions>1: | 72.54 | 88.16 |
% Memory for SQL w/exec>1: | 75.70 | 88.42 |
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
CPU time | 5,956 | 132.6 | |||
reliable message | 2,154 | 876 | 407 | 19.5 | Other |
enq: WF - contention | 1,277 | 577 | 452 | 12.8 | Other |
latch free | 4,687 | 89 | 19 | 2.0 | Other |
control file sequential read | 257,162 | 71 | 0 | 1.6 | System I/O |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 1.16 | 0.54 |
Global Cache blocks served: | 3.37 | 1.57 |
GCS/GES messages received: | 15.13 | 7.06 |
GCS/GES messages sent: | 14.21 | 6.63 |
DBWR Fusion writes: | 0.11 | 0.05 |
Estd Interconnect traffic (KB) | 41.91 |
Buffer access - local cache %: | 100.13 |
Buffer access - remote cache %: | 0.03 |
Buffer access - disk %: | -0.16 |
Avg global enqueue get time (ms): | 2.5 |
Avg global cache cr block receive time (ms): | 0.5 |
Avg global cache current block receive time (ms): | 0.3 |
Avg global cache cr block build time (ms): | 0.0 |
Avg global cache cr block send time (ms): | 0.0 |
Global cache log flushes for cr blocks served %: | 5.2 |
Avg global cache cr block flush time (ms): | 1.2 |
Avg global cache current block pin time (ms): | 0.1 |
Avg global cache current block send time (ms): | 0.2 |
Global cache log flushes for current blocks served %: | 0.8 |
Avg global cache current block flush time (ms): | 0.8 |
Avg message sent queue time (ms): | 0.1 |
Avg message sent queue time on ksxp (ms): | 0.2 |
Avg message received queue time (ms): | 0.0 |
Avg GCS message process time (ms): | 0.1 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 19.99 |
% of indirect sent messages: | 36.75 |
% of flow controlled messages: | 43.25 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
DB CPU | 5,956.47 | 132.56 |
sql execute elapsed time | 2,039.35 | 45.38 |
connection management call elapsed time | 386.75 | 8.61 |
parse time elapsed | 174.81 | 3.89 |
hard parse elapsed time | 35.24 | 0.78 |
sequence load elapsed time | 11.83 | 0.26 |
PL/SQL execution elapsed time | 4.92 | 0.11 |
failed parse elapsed time | 0.24 | 0.01 |
hard parse (sharing criteria) elapsed time | 0.06 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.05 | 0.00 |
repeated bind elapsed time | 0.01 | 0.00 |
PL/SQL compilation elapsed time | 0.01 | 0.00 |
DB time | 4,493.57 | |
background elapsed time | 1,996.65 | |
background cpu time | 258.39 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %Total Call Time |
---|---|---|---|---|---|
CPU time | 5,956 | 132.56 | |||
Other | 378,023 | 54 | 1,578 | 4 | 35.12 |
Concurrency | 13,069 | 0 | 127 | 10 | 2.82 |
System I/O | 300,568 | 102 | 0 | 2.27 | |
User I/O | 99,970 | 51 | 1 | 1.14 | |
Commit | 31,670 | 0 | 41 | 1 | 0.90 |
Cluster | 23,693 | 0 | 17 | 1 | 0.38 |
Network | 2,224,329 | 15 | 0 | 0.33 | |
Configuration | 5,676 | 0 | 6 | 1 | 0.12 |
Application | 1,907 | 3 | 2 | 0.07 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
reliable message | 2,154 | 42 | 876 | 407 | 0.06 |
enq: WF - contention | 1,277 | 87 | 577 | 452 | 0.04 |
latch free | 4,687 | 0 | 89 | 19 | 0.14 |
control file sequential read | 257,162 | 71 | 0 | 7.43 | |
log file sync | 31,670 | 0 | 41 | 1 | 0.92 |
os thread startup | 440 | 1 | 35 | 81 | 0.01 |
latch: cache buffers chains | 2,801 | 34 | 12 | 0.08 | |
db file sequential read | 17,608 | 26 | 1 | 0.51 | |
latch: shared pool | 204 | 25 | 122 | 0.01 | |
direct path read | 82,084 | 25 | 0 | 2.37 | |
log file parallel write | 37,583 | 21 | 1 | 1.09 | |
DFS lock handle | 22,226 | 18 | 1 | 0.64 | |
latch: library cache lock | 141 | 17 | 123 | 0.00 | |
SQL*Net more data to client | 343,599 | 10 | 0 | 9.93 | |
control file parallel write | 5,623 | 9 | 2 | 0.16 | |
latch: library cache | 82 | 7 | 86 | 0.00 | |
gc current block 2-way | 11,242 | 7 | 1 | 0.32 | |
enq: HW - contention | 5,650 | 0 | 5 | 1 | 0.16 |
name-service call wait | 135 | 5 | 38 | 0.00 | |
latch: session allocation | 1,153 | 4 | 4 | 0.03 | |
latch: row cache objects | 28 | 4 | 131 | 0.00 | |
gc cr block 2-way | 6,484 | 4 | 1 | 0.19 | |
row cache lock | 9,151 | 3 | 0 | 0.26 | |
SQL*Net message to client | 1,865,589 | 3 | 0 | 53.93 | |
SQL*Net break/reset to client | 1,250 | 3 | 2 | 0.04 | |
enq: TX - contention | 14 | 2 | 170 | 0.00 | |
CGS wait for IPC msg | 155,833 | 100 | 2 | 0 | 4.50 |
gc buffer busy | 158 | 1 | 2 | 11 | 0.00 |
gc cr block busy | 481 | 2 | 3 | 0.01 | |
gc current grant busy | 2,325 | 1 | 1 | 0.07 | |
gc current block busy | 326 | 1 | 4 | 0.01 | |
log file sequential read | 104 | 1 | 13 | 0.00 | |
SQL*Net message from dblink | 1,006 | 1 | 1 | 0.03 | |
gcs log flush sync | 1,354 | 1 | 1 | 1 | 0.04 |
enq: TX - index contention | 37 | 3 | 1 | 22 | 0.00 |
SQL*Net more data from client | 13,162 | 1 | 0 | 0.38 | |
enq: PS - contention | 914 | 1 | 1 | 0.03 | |
latch: gcs resource hash | 4 | 1 | 134 | 0.00 | |
ksxr poll remote instances | 35,707 | 66 | 0 | 0 | 1.03 |
buffer busy waits | 41 | 0 | 11 | 0.00 | |
gc current grant 2-way | 1,054 | 0 | 0 | 0.03 | |
PX Deq: reap credit | 21,264 | 96 | 0 | 0 | 0.61 |
enq: TM - contention | 655 | 0 | 0 | 0.02 | |
latch: cache buffers lru chain | 2 | 0 | 123 | 0.00 | |
cursor: pin S | 126,329 | 0 | 0 | 3.65 | |
enq: US - contention | 682 | 0 | 0 | 0.02 | |
gc current multi block request | 1,241 | 0 | 0 | 0.04 | |
undo segment extension | 2 | 100 | 0 | 98 | 0.00 |
rdbms ipc reply | 1,257 | 0 | 0 | 0.04 | |
enq: CF - contention | 233 | 0 | 1 | 0.01 | |
PX Deq Credit: send blkd | 1,040 | 66 | 0 | 0 | 0.03 |
PX Deq: Signal ACK | 1,078 | 33 | 0 | 0 | 0.03 |
CSS operation: query | 36 | 0 | 3 | 0.00 | |
log file switch completion | 4 | 0 | 28 | 0.00 | |
Data file init write | 92 | 0 | 1 | 0.00 | |
cursor: pin S wait on X | 10 | 90 | 0 | 10 | 0.00 |
enq: FB - contention | 193 | 0 | 0 | 0.01 | |
gc cr grant 2-way | 206 | 0 | 0 | 0.01 | |
gc cr multi block request | 149 | 0 | 0 | 0.00 | |
enq: SQ - contention | 8 | 0 | 6 | 0.00 | |
IPC send completion sync | 159 | 100 | 0 | 0 | 0.00 |
library cache lock | 82 | 0 | 0 | 0.00 | |
Log archive I/O | 88 | 0 | 0 | 0.00 | |
enq: TA - contention | 54 | 0 | 1 | 0.00 | |
enq: TD - KTF dump entries | 53 | 0 | 1 | 0.00 | |
CSS initialization | 12 | 0 | 2 | 0.00 | |
library cache pin | 52 | 0 | 0 | 0.00 | |
enq: JQ - contention | 25 | 0 | 0 | 0.00 | |
read by other session | 2 | 0 | 6 | 0.00 | |
gc cr disk read | 26 | 0 | 0 | 0.00 | |
db file single write | 21 | 0 | 0 | 0.00 | |
CSS operation: action | 24 | 0 | 0 | 0.00 | |
local write wait | 6 | 0 | 1 | 0.00 | |
direct path write | 157 | 0 | 0 | 0.00 | |
enq: TX - allocate ITL entry | 12 | 0 | 1 | 0.00 | |
enq: DR - contention | 9 | 0 | 1 | 0.00 | |
enq: JS - job run lock - synchronize | 9 | 0 | 0 | 0.00 | |
enq: TT - contention | 13 | 0 | 0 | 0.00 | |
LGWR wait for redo copy | 56 | 0 | 0 | 0.00 | |
buffer deadlock | 5 | 100 | 0 | 0 | 0.00 |
log file single write | 8 | 0 | 0 | 0.00 | |
SQL*Net message to dblink | 970 | 0 | 0 | 0.03 | |
latch: ges resource hash list | 22 | 0 | 0 | 0.00 | |
enq: TX - row lock contention | 1 | 0 | 1 | 0.00 | |
enq: AF - task serialization | 1 | 0 | 1 | 0.00 | |
enq: RS - prevent aging list update | 1 | 0 | 1 | 0.00 | |
gc current split | 1 | 0 | 1 | 0.00 | |
enq: WL - contention | 1 | 0 | 0 | 0.00 | |
enq: CT - state | 1 | 0 | 0 | 0.00 | |
enq: PW - flush prewarm buffers | 1 | 0 | 0 | 0.00 | |
latch: KCL gc element parent latch | 6 | 0 | 0 | 0.00 | |
SQL*Net more data from dblink | 3 | 0 | 0 | 0.00 | |
SQL*Net message from client | 1,919,777 | 17,682,532 | 9211 | 55.50 | |
gcs remote message | 4,433,499 | 95 | 125,950 | 28 | 128.16 |
jobq slave wait | 19,064 | 94 | 54,212 | 2844 | 0.55 |
PX Idle Wait | 9,744 | 95 | 23,227 | 2384 | 0.28 |
Streams AQ: qmn slave idle wait | 598 | 15,766 | 26365 | 0.02 | |
Streams AQ: qmn coordinator idle wait | 1,765 | 34 | 15,766 | 8933 | 0.05 |
Streams AQ: waiting for time management or cleanup tasks | 1,839 | 69 | 15,762 | 8571 | 0.05 |
DIAG idle wait | 80,642 | 15,761 | 195 | 2.33 | |
ASM background timer | 4,253 | 15,758 | 3705 | 0.12 | |
ges remote message | 282,633 | 70 | 15,754 | 56 | 8.17 |
virtual circuit status | 538 | 100 | 15,701 | 29184 | 0.02 |
class slave wait | 3,090 | 85 | 15,685 | 5076 | 0.09 |
i/o slave wait | 38,658 | 86 | 2 | 1.12 | |
KSV master wait | 273 | 16 | 57 | 0.01 | |
PX Deq: Execution Msg | 1,861 | 6 | 2 | 1 | 0.05 |
single-task message | 36 | 2 | 49 | 0.00 | |
PX Deq: Join ACK | 1,162 | 34 | 1 | 1 | 0.03 |
PX Deq: Parse Reply | 1,132 | 34 | 0 | 0 | 0.03 |
PX Deq: Execute Reply | 877 | 34 | 0 | 0 | 0.03 |
PX Deq: Msg Fragment | 680 | 1 | 0 | 0 | 0.02 |
Streams AQ: RAC qmn coordinator idle wait | 2,220 | 100 | 0 | 0 | 0.06 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
os thread startup | 440 | 1 | 35 | 81 | 0.01 |
log file parallel write | 37,584 | 21 | 1 | 1.09 | |
control file sequential read | 43,071 | 19 | 0 | 1.25 | |
control file parallel write | 5,560 | 8 | 1 | 0.16 | |
enq: HW - contention | 5,454 | 2 | 0 | 0.16 | |
log file sequential read | 104 | 1 | 13 | 0.00 | |
gc cr block 2-way | 1,116 | 1 | 0 | 0.03 | |
gc current block 2-way | 345 | 0 | 1 | 0.01 | |
latch: library cache | 1 | 0 | 137 | 0.00 | |
Log archive I/O | 88 | 0 | 0 | 0.00 | |
latch: shared pool | 18 | 0 | 1 | 0.00 | |
log file single write | 8 | 0 | 0 | 0.00 | |
direct path write | 111 | 0 | 0 | 0.00 | |
direct path read | 152 | 0 | 0 | 0.00 | |
gc current multi block request | 1 | 0 | 0 | 0.00 | |
buffer busy waits | 3 | 0 | 0 | 0.00 | |
latch: cache buffers chains | 8 | 0 | 0 | 0.00 | |
latch: row cache objects | 2 | 0 | 0 | 0.00 | |
enq: TM - contention | 624 | -0 | -0 | -0 | 0.02 |
events in waitclass Other | 111,222 | 79 | -44,725 | -402 | 3.22 |
rdbms ipc message | 366,473 | 64 | 266,802 | 728 | 10.59 |
gcs remote message | 4,433,497 | 95 | 125,949 | 28 | 128.16 |
Streams AQ: qmn slave idle wait | 598 | 15,766 | 26365 | 0.02 | |
Streams AQ: qmn coordinator idle wait | 1,765 | 34 | 15,766 | 8933 | 0.05 |
Streams AQ: waiting for time management or cleanup tasks | 1,839 | 69 | 15,762 | 8571 | 0.05 |
DIAG idle wait | 80,641 | 15,761 | 195 | 2.33 | |
ASM background timer | 4,253 | 15,758 | 3705 | 0.12 | |
ges remote message | 282,643 | 70 | 15,754 | 56 | 8.17 |
smon timer | 3,304 | 15,750 | 4767 | 0.10 | |
pmon timer | 14,794 | 100 | 15,707 | 1062 | 0.43 |
class slave wait | 2,863 | 91 | 15,685 | 5478 | 0.08 |
KSV master wait | 124 | 7 | 54 | 0.00 | |
Streams AQ: RAC qmn coordinator idle wait | 2,220 | 100 | 0 | 0 | 0.06 |
Statistic | Total |
---|---|
BUSY_TIME | 950,451 |
IDLE_TIME | 50,700,026 |
IOWAIT_TIME | 13,970 |
NICE_TIME | 1,459 |
SYS_TIME | 532,440 |
USER_TIME | 397,313 |
LOAD | 1 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 5,269,565,440 |
VM_OUT_BYTES | 2,860,846,080 |
PHYSICAL_MEMORY_BYTES | 67,561,590,784 |
NUM_CPUS | 32 |
NUM_CPU_SOCKETS | 4 |
Service Name | DB Time (s) | DB CPU (s) | Physical Reads | Logical Reads |
---|---|---|---|---|
acsdb | 4,274.00 | 5,729.10 | 101,099 | 59,394,459 |
SYS$USERS | 221.20 | 228.70 | 97 | 248,071 |
SYS$BACKGROUND | 0.20 | 0.30 | 523 | 270,005 |
acsdbXDB | 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 |
---|---|---|---|---|---|---|---|---|
acsdb | 84254 | 45 | 10921 | 85 | 0 | 0 | 1992084 | 14 |
SYS$USERS | 14937 | 6 | 160 | 3 | 0 | 0 | 15474 | 0 |
SYS$BACKGROUND | 779 | 1 | 1984 | 37 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
324 | 293 | 113,049 | 0.00 | 7.22 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
203 | 207 | 802 | 0.25 | 4.51 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
175 | 179 | 7 | 25.04 | 3.90 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
175 | 179 | 7 | 25.04 | 3.90 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
153 | 154 | 802 | 0.19 | 3.40 | 9j3v93dcqd1ng | select count(*) from (select c... | |
125 | 127 | 5 | 24.91 | 2.77 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
116 | 118 | 5 | 23.13 | 2.57 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
68 | 29 | 263 | 0.26 | 1.50 | 0s07s16dca7m1 | sqlplus@OMP-ACS-DB2 (TNS V1-V3) | select STATUS from v$datafile |
67 | 64 | 54,309 | 0.00 | 1.50 | 0k8522rmdzg4k | select privilege# from sysauth... | |
48 | 49 | 106 | 0.45 | 1.06 | b6sts095f7490 | select * from ( select temp.* ... |
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
293 | 324 | 113,049 | 0.00 | 4.93 | 7.22 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
207 | 203 | 802 | 0.26 | 3.47 | 4.51 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
179 | 175 | 7 | 25.61 | 3.01 | 3.90 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
179 | 175 | 7 | 25.61 | 3.01 | 3.90 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
154 | 153 | 802 | 0.19 | 2.59 | 3.40 | 9j3v93dcqd1ng | select count(*) from (select c... | |
127 | 125 | 5 | 25.47 | 2.14 | 2.77 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
118 | 116 | 5 | 23.66 | 1.99 | 2.57 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
64 | 67 | 54,309 | 0.00 | 1.08 | 1.50 | 0k8522rmdzg4k | select privilege# from sysauth... | |
49 | 48 | 106 | 0.46 | 0.82 | 1.06 | b6sts095f7490 | select * from ( select temp.* ... | |
44 | 44 | 108 | 0.41 | 0.74 | 0.98 | 8qk3ffrqfu5mj | select count(*) from (select a... |
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
8,811,909 | 802 | 10,987.42 | 14.72 | 206.81 | 202.71 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
6,790,391 | 802 | 8,466.82 | 11.34 | 154.27 | 152.70 | 9j3v93dcqd1ng | select count(*) from (select c... | |
5,877,447 | 113,049 | 51.99 | 9.82 | 293.49 | 324.24 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
2,609,587 | 7 | 372,798.14 | 4.36 | 179.29 | 175.29 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
2,609,580 | 7 | 372,797.14 | 4.36 | 179.27 | 175.28 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
2,498,041 | 108 | 23,130.01 | 4.17 | 44.34 | 43.99 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
2,195,048 | 106 | 20,708.00 | 3.67 | 48.58 | 47.72 | b6sts095f7490 | select * from ( select temp.* ... | |
1,863,940 | 5 | 372,788.00 | 3.11 | 127.34 | 124.54 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
1,863,915 | 5 | 372,783.00 | 3.11 | 118.28 | 115.67 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
1,666,904 | 16,504 | 101.00 | 2.78 | 17.84 | 17.67 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
817,494 | 8,094 | 101.00 | 1.37 | 8.26 | 8.20 | chvsc0kcnaygf | select * from ( select t.adver... | |
758,112 | 7,152 | 106.00 | 1.27 | 7.77 | 7.38 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
722,453 | 7,153 | 101.00 | 1.21 | 6.53 | 6.44 | fkwdf31hccvwp | select * from ( select t.adver... | |
720,433 | 7,133 | 101.00 | 1.20 | 6.61 | 6.50 | 10rj3nwvwud4n | select * from ( select t.adver... | |
707,070 | 1,295 | 546.00 | 1.18 | 16.86 | 16.54 | 55mrvd0ujdavz | select count(*) from( select c... | |
622,224 | 7,152 | 87.00 | 1.04 | 7.38 | 7.82 | 4aa2pajm13day | select count(*) from tb_articl... |
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
830 | 12,624 | 0.07 | 0.82 | 25.91 | 34.45 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
730 | 13,057 | 0.06 | 0.72 | 29.82 | 39.36 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
292 | 2 | 146.00 | 0.29 | 0.30 | 0.35 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
11 | 10,730 | 0.00 | 0.01 | 3.03 | 3.25 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
6 | 5 | 1.20 | 0.01 | 0.01 | 0.03 | 2yk6kghmsqydw | JDBC Thin Client | update TB_ARTICLE_CONTENT set ... |
6 | 4 | 1.50 | 0.01 | 0.02 | 0.06 | 4mu05x7kzn7pw | JDBC Thin Client | insert into TB_API_REQUEST_LOG... |
6 | 5 | 1.20 | 0.01 | 0.04 | 0.08 | b00t2yvxh2vvm | JDBC Thin Client | insert into TB_ARTICLE_CONTENT... |
2 | 1 | 2.00 | 0.00 | 0.03 | 0.04 | 663z4d9phs0up | PL/SQL Developer | select col.*, com.Comments fro... |
1 | 189 | 0.01 | 0.00 | 6.58 | 6.64 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0 | 58 | 0.00 | 0.00 | 0.04 | 0.04 | 04xtrk7uyhknh | select obj#, type#, ctime, mti... |
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
113,049 | 0 | 0.00 | 0.00 | 0.00 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
110,696 | 4,877 | 0.04 | 0.00 | 0.00 | 0h6b2sajwb74n | select privilege#, level from ... | |
54,309 | 110,696 | 2.04 | 0.00 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
53,642 | 53,641 | 1.00 | 0.00 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
53,642 | 53,642 | 1.00 | 0.00 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
53,115 | 53,115 | 1.00 | 0.00 | 0.00 | 5ur69atw3vfhj | select decode(failover_method,... | |
51,839 | 0 | 0.00 | 0.00 | 0.00 | a4m2hmf2qhtv7 | select tbtestwhit0_.wl_id as w... | |
26,145 | 0 | 0.00 | 0.00 | 0.00 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... | |
16,504 | 16,491 | 1.00 | 0.00 | 0.00 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
16,391 | 16,391 | 1.00 | 0.00 | 0.00 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
16,305 | 146,745 | 9.00 | 0.00 | 0.00 | 4mx8yjy0y5n5g | select tdict0_.ID as ID156_, t... | |
13,057 | 13,057 | 1.00 | 0.00 | 0.00 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
12,624 | 12,624 | 1.00 | 0.00 | 0.00 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
12,624 | 12,624 | 1.00 | 0.00 | 0.00 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
12,620 | 80,652 | 6.39 | 0.00 | 0.00 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
11,164 | 11,164 | 1.00 | 0.00 | 0.00 | bh9d2wk667paf | select tdict0_.ID as ID112_, t... | |
10,730 | 10,287 | 0.96 | 0.00 | 0.00 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
113,049 | 113,049 | 12.20 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
110,696 | 110,696 | 11.94 | 0h6b2sajwb74n | select privilege#, level from ... | |
54,309 | 54,309 | 5.86 | 0k8522rmdzg4k | select privilege# from sysauth... | |
53,642 | 53,642 | 5.79 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
53,642 | 53,642 | 5.79 | 459f3z9u4fb3u | select value$ from props$ wher... | |
53,115 | 53,115 | 5.73 | 5ur69atw3vfhj | select decode(failover_method,... | |
51,839 | 51,839 | 5.59 | a4m2hmf2qhtv7 | select tbtestwhit0_.wl_id as w... | |
26,145 | 26,145 | 2.82 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... | |
16,504 | 16,504 | 1.78 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
16,391 | 16,391 | 1.77 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
16,305 | 16,305 | 1.76 | 4mx8yjy0y5n5g | select tdict0_.ID as ID156_, t... | |
13,057 | 13,057 | 1.41 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
12,624 | 12,624 | 1.36 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
12,624 | 12,624 | 1.36 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
12,620 | 12,620 | 1.36 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
11,164 | 11,164 | 1.20 | bh9d2wk667paf | select tdict0_.ID as ID112_, t... | |
10,730 | 10,730 | 1.16 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
35 | 10 | 3qsmy8ybvwt3n | insert into WRI$_ALERT_OUTSTAN... | |
26 | 443 | bcz7kcb5nhjfv | insert into tb_user_oper_log (... | |
21 | 6,860 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... |
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
4.14 | 10.51 | 39.36 | 29.82 | 13,057 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
3.62 | 10.51 | 34.45 | 25.91 | 12,624 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
2.46 | 7.05 | 34.82 | 12.11 | 443 | bcz7kcb5nhjfv | insert into tb_user_oper_log (... | |
1.20 | 28.20 | 4.27 | 3.20 | 6,860 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
0.43 | 0.28 | 152.70 | 154.27 | 802 | 9j3v93dcqd1ng | select count(*) from (select c... | |
0.24 | 0.12 | 202.71 | 206.81 | 802 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
0.21 | 5.77 | 3.68 | 3.15 | 12,624 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
0.21 | 0.06 | 324.24 | 293.49 | 113,049 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
0.18 | 5.55 | 3.25 | 3.03 | 10,730 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
0.13 | 0.30 | 43.99 | 44.34 | 108 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
0.09 | 1.37 | 6.64 | 6.58 | 189 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
0.08 | 0.18 | 47.72 | 48.58 | 106 | b6sts095f7490 | select * from ( select temp.* ... | |
0.05 | 0.03 | 175.28 | 179.27 | 7 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
0.05 | 0.03 | 175.29 | 179.29 | 7 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
0.04 | 44.08 | 0.10 | 0.06 | 20 | 2v2hwkp94jdny | JDBC Thin Client | insert into TB_SSO_APP_TICKET ... |
0.04 | 0.03 | 124.54 | 127.34 | 5 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.04 | 10.68 | 0.35 | 0.30 | 2 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
0.02 | 0.02 | 115.67 | 118.28 | 5 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.01 | 40.48 | 0.03 | 0.02 | 3 | 6jmd41c7nuvf5 | JDBC Thin Client | insert into TB_SSO_USER_LOGIN_... |
0.01 | 0.34 | 3.50 | 3.27 | 7,145 | 9w01ztmr4569k | select count(*) from tb_articl... | |
0.01 | 0.15 | 7.82 | 7.38 | 7,152 | 4aa2pajm13day | select count(*) from tb_articl... | |
0.01 | 39.38 | 0.02 | 0.01 | 10 | 3qsmy8ybvwt3n | insert into WRI$_ALERT_OUTSTAN... | |
0.01 | 0.08 | 7.38 | 7.77 | 7,152 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
0.01 | 24.08 | 0.02 | 0.02 | 2 | 31a13pnjps7j3 | SELECT source, (case when time... | |
0.01 | 0.12 | 4.67 | 4.73 | 7,145 | 3r189y4actbt2 | select * from ( select temp.* ... | |
0.01 | 0.31 | 1.78 | 1.82 | 1 | gktbxssxarhdq | select count(*) from (select a... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 249,546 | 15.46 | 7.21 |
CPU used when call started | 242,246 | 15.00 | 7.00 |
CR blocks created | 325 | 0.02 | 0.01 |
Cached Commit SCN referenced | 1,643,609 | 101.80 | 47.51 |
Commit SCN cached | 61 | 0.00 | 0.00 |
DB time | 5,728,099 | 354.80 | 165.59 |
DBWR checkpoint buffers written | 36,040 | 2.23 | 1.04 |
DBWR checkpoints | 2 | 0.00 | 0.00 |
DBWR fusion writes | 1,696 | 0.11 | 0.05 |
DBWR object drop 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 | 1,959 | 0.12 | 0.06 |
DBWR undo block writes | 7,929 | 0.49 | 0.23 |
DFO trees parallelized | 399 | 0.02 | 0.01 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
PX local messages recv'd | 2,188 | 0.14 | 0.06 |
PX local messages sent | 2,188 | 0.14 | 0.06 |
PX remote messages recv'd | 1,012 | 0.06 | 0.03 |
PX remote messages sent | 1,676 | 0.10 | 0.05 |
Parallel operations not downgraded | 399 | 0.02 | 0.01 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 377 | 0.02 | 0.01 |
RowCR hits | 377 | 0.02 | 0.01 |
SMON posted for instance recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 10 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 1,648,816 | 102.13 | 47.66 |
SQL*Net roundtrips to/from dblink | 970 | 0.06 | 0.03 |
active txn count during cleanout | 10,320 | 0.64 | 0.30 |
application wait time | 326 | 0.02 | 0.01 |
background checkpoints completed | 3 | 0.00 | 0.00 |
background checkpoints started | 2 | 0.00 | 0.00 |
background timeouts | 78,547 | 4.87 | 2.27 |
branch node splits | 2 | 0.00 | 0.00 |
buffer is not pinned count | 13,689,254 | 847.91 | 395.72 |
buffer is pinned count | 24,704,117 | 1,530.16 | 714.14 |
bytes received via SQL*Net from client | 309,931,995 | 19,197.06 | 8,959.38 |
bytes received via SQL*Net from dblink | 326,961 | 20.25 | 9.45 |
bytes sent via SQL*Net to client | 1,099,702,205 | 68,115.10 | 31,789.73 |
bytes sent via SQL*Net to dblink | 295,365 | 18.29 | 8.54 |
calls to get snapshot scn: kcmgss | 2,407,697 | 149.13 | 69.60 |
calls to kcmgas | 98,819 | 6.12 | 2.86 |
calls to kcmgcs | 4,318 | 0.27 | 0.12 |
change write time | 790 | 0.05 | 0.02 |
cleanout - number of ktugct calls | 5,157 | 0.32 | 0.15 |
cleanouts and rollbacks - consistent read gets | 229 | 0.01 | 0.01 |
cleanouts only - consistent read gets | 115 | 0.01 | 0.00 |
cluster key scan block gets | 503,025 | 31.16 | 14.54 |
cluster key scans | 463,295 | 28.70 | 13.39 |
cluster wait time | 1,703 | 0.11 | 0.05 |
commit batch performed | 3 | 0.00 | 0.00 |
commit batch requested | 3 | 0.00 | 0.00 |
commit batch/immediate performed | 66 | 0.00 | 0.00 |
commit batch/immediate requested | 66 | 0.00 | 0.00 |
commit cleanout failures: block lost | 25 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 49 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 35 | 0.00 | 0.00 |
commit cleanouts | 107,266 | 6.64 | 3.10 |
commit cleanouts successfully completed | 107,157 | 6.64 | 3.10 |
commit immediate performed | 63 | 0.00 | 0.00 |
commit immediate requested | 63 | 0.00 | 0.00 |
commit txn count during cleanout | 11,296 | 0.70 | 0.33 |
concurrency wait time | 12,408 | 0.77 | 0.36 |
consistent changes | 331 | 0.02 | 0.01 |
consistent gets | 59,388,548 | 3,678.50 | 1,716.78 |
consistent gets - examination | 21,632,583 | 1,339.91 | 625.35 |
consistent gets direct | 98,987 | 6.13 | 2.86 |
consistent gets from cache | 59,289,541 | 3,672.37 | 1,713.92 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 4,351 | 0.27 | 0.13 |
data blocks consistent reads - undo records applied | 308 | 0.02 | 0.01 |
db block changes | 372,485 | 23.07 | 10.77 |
db block gets | 465,127 | 28.81 | 13.45 |
db block gets direct | 57 | 0.00 | 0.00 |
db block gets from cache | 465,070 | 28.81 | 13.44 |
deferred (CURRENT) block cleanout applications | 40,464 | 2.51 | 1.17 |
dirty buffers inspected | 6 | 0.00 | 0.00 |
enqueue conversions | 5,421 | 0.34 | 0.16 |
enqueue releases | 366,524 | 22.70 | 10.60 |
enqueue requests | 366,666 | 22.71 | 10.60 |
enqueue timeouts | 145 | 0.01 | 0.00 |
enqueue waits | 8,547 | 0.53 | 0.25 |
exchange deadlocks | 6 | 0.00 | 0.00 |
execute count | 889,991 | 55.13 | 25.73 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
free buffer inspected | 8,054 | 0.50 | 0.23 |
free buffer requested | 29,721 | 1.84 | 0.86 |
gc CPU used by this session | 7,178 | 0.44 | 0.21 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 29 | 0.00 | 0.00 |
gc cr block flush time | 58 | 0.00 | 0.00 |
gc cr block receive time | 344 | 0.02 | 0.01 |
gc cr block send time | 44 | 0.00 | 0.00 |
gc cr blocks received | 7,108 | 0.44 | 0.21 |
gc cr blocks served | 9,324 | 0.58 | 0.27 |
gc current block flush time | 28 | 0.00 | 0.00 |
gc current block pin time | 247 | 0.02 | 0.01 |
gc current block receive time | 402 | 0.02 | 0.01 |
gc current block send time | 700 | 0.04 | 0.02 |
gc current blocks received | 11,578 | 0.72 | 0.33 |
gc current blocks served | 45,007 | 2.79 | 1.30 |
gc local grants | 5,616 | 0.35 | 0.16 |
gc remote grants | 5,604 | 0.35 | 0.16 |
gcs messages sent | 162,759 | 10.08 | 4.70 |
ges messages sent | 66,678 | 4.13 | 1.93 |
global enqueue get time | 55,600 | 3.44 | 1.61 |
global enqueue gets async | 10,140 | 0.63 | 0.29 |
global enqueue gets sync | 214,970 | 13.32 | 6.21 |
global enqueue releases | 203,212 | 12.59 | 5.87 |
heap block compress | 294 | 0.02 | 0.01 |
hot buffers moved to head of LRU | 746 | 0.05 | 0.02 |
immediate (CR) block cleanout applications | 344 | 0.02 | 0.01 |
immediate (CURRENT) block cleanout applications | 2,934 | 0.18 | 0.08 |
index crx upgrade (found) | 77 | 0.00 | 0.00 |
index crx upgrade (positioned) | 18,097 | 1.12 | 0.52 |
index fast full scans (full) | 37 | 0.00 | 0.00 |
index fetch by key | 12,302,782 | 762.03 | 355.64 |
index scans kdiixs1 | 839,124 | 51.97 | 24.26 |
leaf node 90-10 splits | 429 | 0.03 | 0.01 |
leaf node splits | 728 | 0.05 | 0.02 |
lob reads | 19,958 | 1.24 | 0.58 |
lob writes | 13,669 | 0.85 | 0.40 |
lob writes unaligned | 13,663 | 0.85 | 0.39 |
logons cumulative | 56,253 | 3.48 | 1.63 |
messages received | 104,968 | 6.50 | 3.03 |
messages sent | 104,968 | 6.50 | 3.03 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 36,303,429 | 2,248.62 | 1,049.44 |
opened cursors cumulative | 928,901 | 57.54 | 26.85 |
parse count (failures) | 114 | 0.01 | 0.00 |
parse count (hard) | 7,093 | 0.44 | 0.21 |
parse count (total) | 926,716 | 57.40 | 26.79 |
parse time cpu | 15,281 | 0.95 | 0.44 |
parse time elapsed | 17,424 | 1.08 | 0.50 |
physical read IO requests | 84,698 | 5.25 | 2.45 |
physical read bytes | 833,282,048 | 51,613.15 | 24,088.17 |
physical read total IO requests | 356,960 | 22.11 | 10.32 |
physical read total bytes | 5,260,785,152 | 325,850.85 | 152,076.58 |
physical read total multi block requests | 8,627 | 0.53 | 0.25 |
physical reads | 101,719 | 6.30 | 2.94 |
physical reads cache | 2,585 | 0.16 | 0.07 |
physical reads cache prefetch | 0 | 0.00 | 0.00 |
physical reads direct | 99,134 | 6.14 | 2.87 |
physical reads direct (lob) | 98,953 | 6.13 | 2.86 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 18,286 | 1.13 | 0.53 |
physical write bytes | 307,355,648 | 19,037.48 | 8,884.91 |
physical write total IO requests | 104,981 | 6.50 | 3.03 |
physical write total bytes | 853,828,096 | 52,885.76 | 24,682.11 |
physical write total multi block requests | 76,481 | 4.74 | 2.21 |
physical writes | 37,519 | 2.32 | 1.08 |
physical writes direct | 169 | 0.01 | 0.00 |
physical writes direct (lob) | 47 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 37,350 | 2.31 | 1.08 |
physical writes non checkpoint | 13,290 | 0.82 | 0.38 |
pinned buffers inspected | 2 | 0.00 | 0.00 |
pinned cursors current | 2 | 0.00 | 0.00 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
process last non-idle time | 16,144 | 1.00 | 0.47 |
queries parallelized | 399 | 0.02 | 0.01 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 3,307,455 | 204.86 | 95.61 |
recursive cpu usage | 48,260 | 2.99 | 1.40 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 221,368 | 13.71 | 6.40 |
redo buffer allocation retries | 4 | 0.00 | 0.00 |
redo entries | 218,789 | 13.55 | 6.32 |
redo log space requests | 4 | 0.00 | 0.00 |
redo log space wait time | 11 | 0.00 | 0.00 |
redo ordering marks | 3,480 | 0.22 | 0.10 |
redo size | 100,206,748 | 6,206.76 | 2,896.73 |
redo subscn max counts | 5,017 | 0.31 | 0.15 |
redo synch time | 4,299 | 0.27 | 0.12 |
redo synch writes | 30,716 | 1.90 | 0.89 |
redo wastage | 9,531,568 | 590.38 | 275.53 |
redo write broadcast ack time | 1,121 | 0.07 | 0.03 |
redo write time | 3,035 | 0.19 | 0.09 |
redo writer latching time | 0 | 0.00 | 0.00 |
redo writes | 37,591 | 2.33 | 1.09 |
rollback changes - undo records applied | 76 | 0.00 | 0.00 |
rollbacks only - consistent read gets | 64 | 0.00 | 0.00 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 5,775,019 | 357.70 | 166.94 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 484,985 | 30.04 | 14.02 |
session logical reads | 59,854,301 | 3,707.35 | 1,730.24 |
shared hash latch upgrades - no wait | 40,614 | 2.52 | 1.17 |
shared hash latch upgrades - wait | 77 | 0.00 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 517,256 | 32.04 | 14.95 |
sorts (rows) | 6,068,317 | 375.87 | 175.42 |
sql area evicted | 4,645 | 0.29 | 0.13 |
sql area purged | 113 | 0.01 | 0.00 |
summed dirty queue length | 6 | 0.00 | 0.00 |
switch current to new buffer | 377 | 0.02 | 0.01 |
table fetch by rowid | 9,335,306 | 578.22 | 269.86 |
table fetch continued row | 24,252 | 1.50 | 0.70 |
table scan blocks gotten | 28,479,637 | 1,764.02 | 823.28 |
table scan rows gotten | 3,552,596,862 | 220,046.38 | 102,696.99 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 541,074 | 33.51 | 15.64 |
total number of times SMON posted | 3,304 | 0.20 | 0.10 |
transaction lock background get time | 0 | 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 | 66 | 0.00 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 20,668,252 | 1,280.18 | 597.47 |
user I/O wait time | 5,126 | 0.32 | 0.15 |
user calls | 2,320,514 | 143.73 | 67.08 |
user commits | 32,233 | 2.00 | 0.93 |
user rollbacks | 2,360 | 0.15 | 0.07 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 208,314 | 12.90 | 6.02 |
write clones created in background | 6 | 0.00 | 0.00 |
write clones created in foreground | 1 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 1.2E+12 | 1.2E+12 |
session cursor cache count | 225,028,637 | 225,435,068 |
session uga memory | 7.8E+14 | 7.8E+14 |
opened cursors current | 401 | 471 |
workarea memory allocated | 2,877 | 265 |
logons current | 1,200 | 1,195 |
session uga memory max | 1.8E+13 | 1.8E+13 |
session pga memory | 7.1E+11 | 7.1E+11 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 2 | 0.45 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
USERS | 79,956 | 5 | 0.00 | 1.21 | 2 | 0 | 0 | 0.00 |
WCITY2_DATA | 3,938 | 0 | 4.39 | 1.00 | 9,301 | 1 | 23 | 0.43 |
UNDOTBS2 | 2 | 0 | 0.00 | 1.00 | 4,408 | 0 | 7 | 0.00 |
SYSAUX | 374 | 0 | 1.60 | 1.00 | 2,523 | 0 | 0 | 0.00 |
WCITY2_INDEX | 287 | 0 | 10.49 | 1.00 | 1,201 | 0 | 38 | 13.16 |
SYSTEM | 17 | 0 | 3.53 | 1.00 | 582 | 0 | 72 | 2.78 |
WCITY_GNMS | 13 | 0 | 3.85 | 1.00 | 148 | 0 | 3 | 16.67 |
WCITY | 72 | 0 | 0.00 | 1.00 | 42 | 0 | 0 | 0.00 |
TS_APP_DATA | 4 | 0 | 0.00 | 1.00 | 44 | 0 | 0 | 0.00 |
TBS_ITS | 4 | 0 | 0.00 | 1.00 | 4 | 0 | 0 | 0.00 |
TS_APP_INDEX | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY_BC | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
HQDB_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
INMS01 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
ISS | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
NETM_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMAE_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMP01 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMS01 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
REPORT_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SSB_DATA_JWF | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 2 | 0.00 |
ZXDBM_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
ZXINJOS_DATA | 2 | 0 | 0.00 | 1.00 | 2 | 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) |
---|---|---|---|---|---|---|---|---|---|
HQDB_DATA | +DATA/acsdb/datafile/hqdb_data.296.762368267 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
INMS01 | +DATA/acsdb/datafile/inms01.279.762122141 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
ISS | +DATA/acsdb/datafile/iss01.bdf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
NETM_DATA | +DATA/acsdb/datafile/netm_data.295.762368247 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMAE_DATA | +DATA/acsdb/datafile/omae_data.297.762368277 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMP01 | +DATA/acsdb/datafile/omp01.280.762122149 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
OMS01 | +DATA/acsdb/datafile/oms01.281.762122175 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
REPORT_DATA | +DATA/acsdb/datafile/report_data.291.762359943 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SSB_DATA_JWF | +DATA/acsdb/datafile/ssb_data_jwf.292.762359949 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
SYSAUX | +DATA/acsdb/datafile/sysaux.257.762113905 | 374 | 0 | 1.60 | 1.00 | 2,523 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.1634.787070407 | 4 | 0 | 0.00 | 1.00 | 75 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.256.762113905 | 13 | 0 | 4.62 | 1.00 | 507 | 0 | 72 | 2.78 |
TBS_ITS | +DATA/acsdb/datafile/tbs_its.305.762449727 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TBS_ITS | +DATA/acsdb/datafile/tbs_its01.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
TS_APP_DATA | +DATA/acsdb/datafile/ts_app_data01.dbf | 4 | 0 | 0.00 | 1.00 | 44 | 0 | 0 | 0.00 |
TS_APP_INDEX | +DATA/acsdb/datafile/ts_app_index01.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATA/acsdb/datafile/undotbs1.258.762113905 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 2 | 0.00 |
UNDOTBS2 | +DATA/acsdb/datafile/undotbs2.269.762113985 | 2 | 0 | 0.00 | 1.00 | 4,408 | 0 | 7 | 0.00 |
USERS | +DATA/acsdb/datafile/users.259.762113905 | 79,956 | 5 | 0.00 | 1.21 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1031.787073439 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1146.787070545 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1297.787074783 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.2249.787070711 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.287.762346721 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.2995.787070437 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3189.787070649 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3202.787070683 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3261.787070351 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.370.787070423 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4594.787070635 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4822.787075205 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5264.787070521 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5495.787070583 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5810.787070597 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.6430.787070489 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity1.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity2.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity3.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity4.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity5.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data01.dbf | 229 | 0 | 1.09 | 1.00 | 183 | 0 | 1 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data02.dbf | 137 | 0 | 1.53 | 1.00 | 201 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data03.dbf | 137 | 0 | 1.17 | 1.00 | 341 | 0 | 2 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data04.dbf | 903 | 0 | 0.17 | 1.00 | 37 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data05.dbf | 610 | 0 | 0.51 | 1.00 | 234 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data06.dbf | 133 | 0 | 5.94 | 1.02 | 1,028 | 0 | 15 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data07.dbf | 218 | 0 | 6.97 | 1.00 | 1,634 | 0 | 4 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data08.dbf | 644 | 0 | 8.82 | 1.00 | 2,679 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data09.dbf | 927 | 0 | 8.87 | 1.00 | 2,964 | 0 | 1 | 10.00 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index01.dbf | 207 | 0 | 8.16 | 1.00 | 617 | 0 | 13 | 36.92 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index02.dbf | 80 | 0 | 16.50 | 1.00 | 584 | 0 | 25 | 0.80 |
WCITY_BC | +DATA/acsdb/datafile/wcity_bc01.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms01.dbf | 9 | 0 | 4.44 | 1.00 | 123 | 0 | 3 | 16.67 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms02.dbf | 4 | 0 | 2.50 | 1.00 | 25 | 0 | 0 | 0.00 |
ZXDBM_DATA | +DATA/acsdb/datafile/zxdbm_data.290.762359941 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
ZXINJOS_DATA | +DATA/acsdb/datafile/zxinjos_data.289.762359941 | 2 | 0 | 0.00 | 1.00 | 2 | 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 | 3,513,861 | 100 | 59,761,969 | 2,585 | 37,350 | 0 | 0 | 145 |
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 | 12 | 11377 | 92643 | 99888 | 184320 | 99888 | |
E | 0 | 1 | 806 | 8686 | 28349 | 184320 | 28349 |
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,928 | 0.10 | 350,811 | 37.15 | 1,075,494,610 |
D | 5,856 | 0.20 | 701,622 | 1.50 | 43,467,262 |
D | 8,784 | 0.30 | 1,052,433 | 1.18 | 34,287,459 |
D | 11,712 | 0.40 | 1,403,244 | 1.11 | 32,207,291 |
D | 14,640 | 0.50 | 1,754,055 | 1.06 | 30,687,546 |
D | 17,568 | 0.60 | 2,104,866 | 1.04 | 30,113,723 |
D | 20,496 | 0.70 | 2,455,677 | 1.03 | 29,953,831 |
D | 23,424 | 0.80 | 2,806,488 | 1.03 | 29,684,050 |
D | 26,352 | 0.90 | 3,157,299 | 1.01 | 29,337,400 |
D | 29,280 | 1.00 | 3,508,110 | 1.00 | 28,962,029 |
D | 29,328 | 1.00 | 3,513,861 | 1.00 | 28,948,186 |
D | 32,208 | 1.10 | 3,858,921 | 0.97 | 28,086,777 |
D | 35,136 | 1.20 | 4,209,732 | 0.96 | 27,860,824 |
D | 38,064 | 1.30 | 4,560,543 | 0.95 | 27,637,895 |
D | 40,992 | 1.40 | 4,911,354 | 0.95 | 27,540,672 |
D | 43,920 | 1.50 | 5,262,165 | 0.94 | 27,274,843 |
D | 46,848 | 1.60 | 5,612,976 | 0.93 | 26,963,502 |
D | 49,776 | 1.70 | 5,963,787 | 0.92 | 26,648,576 |
D | 52,704 | 1.80 | 6,314,598 | 0.84 | 24,193,350 |
D | 55,632 | 1.90 | 6,665,409 | 0.82 | 23,729,199 |
D | 58,560 | 2.00 | 7,016,220 | 0.81 | 23,392,429 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 9,984 | 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 | 8,044 | 6,644 | 939.28 | 4.93 | 0.53 | 100.00 | 0.00 | 823,700 |
E | 8,044 | 6,616 | 943.51 | 0.00 | 0.00 | 0.00 | 0.00 | 823,700 |
Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
---|---|---|---|---|---|
2K | 4K | 198,967 | 198,967 | 0 | 0 |
64K | 128K | 274 | 274 | 0 | 0 |
128K | 256K | 346 | 346 | 0 | 0 |
256K | 512K | 136 | 136 | 0 | 0 |
512K | 1024K | 3,758 | 3,758 | 0 | 0 |
1M | 2M | 4,787 | 4,787 | 0 | 0 |
2M | 4M | 16 | 16 | 0 | 0 |
4M | 8M | 32 | 32 | 0 | 0 |
8M | 16M | 8 | 8 | 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 |
---|---|---|---|---|---|
1,006 | 0.13 | 2,912,568.92 | 3,432.18 | 100.00 | 0 |
2,011 | 0.25 | 2,912,568.92 | 3,162.87 | 100.00 | 0 |
4,022 | 0.50 | 2,912,568.92 | 2,080.19 | 100.00 | 0 |
6,033 | 0.75 | 2,912,568.92 | 2,080.19 | 100.00 | 0 |
8,044 | 1.00 | 2,912,568.92 | 1,231.86 | 100.00 | 0 |
9,653 | 1.20 | 2,912,568.92 | 0.00 | 100.00 | 0 |
11,262 | 1.40 | 2,912,568.92 | 0.00 | 100.00 | 0 |
12,870 | 1.60 | 2,912,568.92 | 0.00 | 100.00 | 0 |
14,479 | 1.80 | 2,912,568.92 | 0.00 | 100.00 | 0 |
16,088 | 2.00 | 2,912,568.92 | 0.00 | 100.00 | 0 |
24,132 | 3.00 | 2,912,568.92 | 0.00 | 100.00 | 0 |
32,176 | 4.00 | 2,912,568.92 | 0.00 | 100.00 | 0 |
48,264 | 6.00 | 2,912,568.92 | 0.00 | 100.00 | 0 |
64,352 | 8.00 | 2,912,568.92 | 0.00 | 100.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,016 | 0.60 | 385 | 30,127 | 15,632,930 | 1.00 | 79,523 | 1.08 | 682,642 |
2,352 | 0.70 | 710 | 48,289 | 15,637,018 | 1.00 | 75,435 | 1.02 | 683,033 |
2,688 | 0.80 | 1,042 | 65,626 | 15,638,058 | 1.00 | 74,395 | 1.01 | 683,181 |
3,024 | 0.90 | 1,377 | 80,954 | 15,638,505 | 1.00 | 73,948 | 1.00 | 683,256 |
3,360 | 1.00 | 1,711 | 98,270 | 15,638,763 | 1.00 | 73,690 | 1.00 | 683,309 |
3,696 | 1.10 | 2,045 | 116,107 | 15,638,941 | 1.00 | 73,512 | 1.00 | 683,350 |
4,032 | 1.20 | 2,380 | 134,556 | 15,639,092 | 1.00 | 73,361 | 1.00 | 683,385 |
4,368 | 1.30 | 2,715 | 153,483 | 15,639,213 | 1.00 | 73,240 | 0.99 | 683,415 |
4,704 | 1.40 | 3,050 | 172,514 | 15,639,318 | 1.00 | 73,135 | 0.99 | 683,442 |
5,040 | 1.50 | 3,385 | 191,950 | 15,639,415 | 1.00 | 73,038 | 0.99 | 683,466 |
5,376 | 1.60 | 3,720 | 211,338 | 15,639,496 | 1.00 | 72,957 | 0.99 | 683,487 |
5,712 | 1.70 | 4,055 | 228,890 | 15,639,573 | 1.00 | 72,880 | 0.99 | 683,506 |
6,048 | 1.80 | 4,390 | 245,536 | 15,639,642 | 1.00 | 72,811 | 0.99 | 683,524 |
6,384 | 1.90 | 4,725 | 264,033 | 15,639,703 | 1.00 | 72,750 | 0.99 | 683,540 |
6,720 | 2.00 | 5,060 | 280,762 | 15,639,755 | 1.00 | 72,698 | 0.99 | 683,554 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
8,192 | 0.25 | 5,403,173 | 43,468,581 |
16,384 | 0.50 | 5,366,727 | 30,687,961 |
24,576 | 0.75 | 5,362,439 | 29,952,678 |
32,768 | 1.00 | 5,359,759 | 28,948,176 |
40,960 | 1.25 | 5,356,007 | 27,636,824 |
49,152 | 1.50 | 5,354,399 | 26,962,331 |
57,344 | 1.75 | 5,353,863 | 24,191,991 |
65,536 | 2.00 | 5,353,863 | 23,393,021 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 0.50 | 0 | 0 | 0 | 0 |
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 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 120 | 1 | 6 |
segment header | 9 | 0 | 0 |
undo header | 9 | 0 | 0 |
1st level bmb | 6 | 0 | 0 |
2nd level bmb | 1 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
WF-AWR Flush | 193 | 50 | 143 | 166 | 533 | 3,211.39 |
HW-Segment High Water Mark | 10,508 | 10,508 | 0 | 5,590 | 6 | 1.00 |
TX-Transaction | 41,839 | 41,839 | 0 | 11 | 2 | 224.55 |
TX-Transaction (index contention) | 53 | 53 | 0 | 33 | 1 | 25.76 |
PS-PX Process Reservation | 2,819 | 2,818 | 1 | 895 | 1 | 0.74 |
TM-DML | 46,923 | 46,923 | 0 | 644 | 0 | 0.54 |
US-Undo Segment | 701 | 701 | 0 | 681 | 0 | 0.34 |
CF-Controlfile Transaction | 37,953 | 37,953 | 0 | 177 | 0 | 1.02 |
FB-Format Block | 351 | 351 | 0 | 166 | 0 | 0.54 |
SQ-Sequence Cache | 6,870 | 6,870 | 0 | 7 | 0 | 8.57 |
TD-KTF map table enqueue (KTF dump entries) | 53 | 53 | 0 | 53 | 0 | 0.75 |
TA-Instance Undo | 106 | 106 | 0 | 54 | 0 | 0.37 |
JQ-Job Queue | 633 | 633 | 0 | 24 | 0 | 0.83 |
TT-Tablespace | 900 | 900 | 0 | 13 | 0 | 0.77 |
DR-Distributed Recovery | 9 | 9 | 0 | 9 | 0 | 1.11 |
JS-Job Scheduler (job run lock - synchronize) | 9 | 9 | 0 | 9 | 0 | 1.11 |
RS-Reclaimable Space (prevent aging list update) | 18 | 18 | 0 | 1 | 0 | 10.00 |
TX-Transaction (allocate ITL entry) | 12 | 12 | 0 | 11 | 0 | 0.00 |
AF-Advisor Framework (task serialization) | 14 | 14 | 0 | 1 | 0 | 0.00 |
CT-Block Change Tracking (state) | 21 | 21 | 0 | 1 | 0 | 0.00 |
PW-Buffer Cache PreWarm (flush prewarm buffers) | 1 | 0 | 1 | 1 | 0 | 0.00 |
TX-Transaction (row lock contention) | 1 | 1 | 0 | 1 | 0 | 0.00 |
WL-Being Written Redo Log | 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 |
---|---|---|---|---|---|---|---|
5 | 5.34 | 41,474 | 1,011 | 5 | 75/75 | 0/0 | 0/0/0/0/0/0 |
End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
---|---|---|---|---|---|---|---|
07-3ÔÂ 15:19 | 139 | 1,953 | 726 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 15:09 | 150 | 1,617 | 559 | 5 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:59 | 90 | 1,546 | 0 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:49 | 123 | 1,722 | 0 | 5 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:39 | 160 | 1,831 | 0 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:29 | 125 | 1,746 | 1,011 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:19 | 119 | 1,835 | 408 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 14:09 | 104 | 1,045 | 407 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:59 | 173 | 2,055 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:49 | 172 | 2,096 | 998 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:39 | 177 | 2,192 | 741 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:29 | 160 | 1,980 | 738 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:19 | 97 | 1,695 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 13:09 | 151 | 1,812 | 393 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:59 | 138 | 1,722 | 0 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:49 | 100 | 1,561 | 387 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:39 | 113 | 1,348 | 387 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:29 | 78 | 1,277 | 984 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:19 | 172 | 2,197 | 382 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 12:09 | 150 | 1,701 | 0 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:59 | 153 | 1,495 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:49 | 88 | 1,392 | 258 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:39 | 31 | 554 | 0 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:29 | 77 | 750 | 361 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:19 | 32 | 675 | 370 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 11:09 | 44 | 646 | 448 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
07-3ÔÂ 10:59 | 2,223 | 1,031 | 0 | 3 | 75 | 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 allocation | 426 | 0.00 | 0 | 0 | ||
ASM db client latch | 11,357 | 0.00 | 0 | 0 | ||
ASM map headers | 1,622 | 0.00 | 0 | 0 | ||
ASM map load waiting list | 588 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 11,792 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 2,639,510 | 0.01 | 0.00 | 0 | 0 | |
ASM network background latch | 8,532 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 157,360 | 0.00 | 0 | 0 | ||
Consistent RBA | 37,586 | 0.00 | 0 | 0 | ||
FAL request queue | 327 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 327 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 108 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 58,863 | 0.03 | 0.00 | 0 | 0 | |
JS broadcast add buf latch | 3,692 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 3,692 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 3,220 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 24 | 0.00 | 0 | 0 | ||
JS queue access latch | 24 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 116,470 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 2,271,423 | 0.01 | 0.00 | 0 | 0 | |
KCL gc element parent latch | 244,325 | 0.01 | 0.25 | 0 | 670 | 0.00 |
KFK SGA context latch | 12,616 | 0.00 | 0 | 0 | ||
KFMD SGA | 8,562 | 0.00 | 0 | 0 | ||
KJC message pool free list | 86,416 | 0.10 | 0.00 | 0 | 3,785 | 0.16 |
KJCT flow control latch | 406,010 | 0.06 | 0.01 | 0 | 0 | |
KMG MMAN ready and startup request latch | 5,379 | 0.00 | 0 | 0 | ||
KSXR large replies | 1 | 0.00 | 0 | 0 | ||
KTF sga latch | 106 | 0.00 | 0 | 4,478 | 0.00 | |
KWQMN job cache list latch | 5,213 | 0.12 | 0.50 | 0 | 0 | |
KWQP Prop Status | 4 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 322 | 0.00 | ||
Memory Management Latch | 0 | 0 | 5,379 | 0.00 | ||
OS process | 168,348 | 0.00 | 0 | 0 | ||
OS process allocation | 117,531 | 0.11 | 0.20 | 6 | 0 | |
OS process: request allocation | 110,421 | 0.16 | 0.35 | 25 | 0 | |
PL/SQL warning settings | 58,870 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 116 | 0.00 | 0 | 116 | 0.00 | |
SQL memory manager latch | 2 | 0.00 | 0 | 5,373 | 0.00 | |
SQL memory manager workarea list latch | 497,545 | 0.00 | 0 | 0 | ||
Shared B-Tree | 575 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 35,575 | 0.00 | 0 | 0 | ||
active service list | 315,339 | 0.58 | 0.09 | 3 | 16,871 | 0.01 |
alert log latch | 4 | 0.00 | 0 | 0 | ||
archive control | 580 | 0.00 | 0 | 0 | ||
archive process latch | 6,031 | 0.00 | 0 | 0 | ||
begin backup scn array | 47 | 0.00 | 0 | 0 | ||
business card | 798 | 0.00 | 0 | 0 | ||
cache buffer handles | 7,556 | 0.05 | 0.00 | 0 | 0 | |
cache buffers chains | 98,975,850 | 0.09 | 0.03 | 34 | 103,684 | 0.02 |
cache buffers lru chain | 95,442 | 0.00 | 0.50 | 0 | 111,445 | 0.01 |
channel handle pool latch | 110,517 | 0.02 | 0.00 | 0 | 0 | |
channel operations parent latch | 1,278,784 | 0.02 | 0.03 | 0 | 0 | |
checkpoint queue latch | 1,981,208 | 0.00 | 0.00 | 0 | 36,395 | 0.00 |
client/application info | 290,733 | 0.00 | 0 | 0 | ||
commit callback allocation | 498 | 0.00 | 0 | 0 | ||
compile environment latch | 56,317 | 0.00 | 0 | 0 | ||
dml lock allocation | 94,563 | 0.00 | 0.00 | 0 | 0 | |
dummy allocation | 112,639 | 0.08 | 0.00 | 0 | 0 | |
enqueue hash chains | 868,522 | 0.00 | 0.00 | 0 | 1,297 | 0.00 |
enqueues | 951,932 | 0.01 | 0.03 | 0 | 0 | |
error message lists | 1,941 | 0.00 | 0 | 0 | ||
event group latch | 55,170 | 0.00 | 0 | 0 | ||
file cache latch | 4,993 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 56,022 | 0.00 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 356,857 | 0.00 | 0 | 2,160 | 0.00 | |
gcs remastering latch | 1,974 | 0.00 | 0 | 0 | ||
gcs resource freelist | 5,365 | 0.02 | 0.00 | 0 | 7,447 | 0.00 |
gcs resource hash | 252,127 | 0.03 | 0.05 | 1 | 27 | 0.00 |
gcs resource scan list | 54 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 17,637 | 0.00 | 0 | 26,673 | 0.00 | |
ges caches resource lists | 72,735 | 0.02 | 0.00 | 0 | 190,786 | 0.00 |
ges deadlock list | 242 | 0.00 | 0 | 0 | ||
ges domain table | 229,360 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 432,594 | 0.00 | 0 | 0 | ||
ges group table | 319,186 | 0.00 | 0.00 | 0 | 0 | |
ges process hash list | 228,744 | 0.00 | 0 | 0 | ||
ges process parent latch | 870,151 | 0.00 | 0 | 0 | ||
ges process table freelist | 110,421 | 0.03 | 0.03 | 0 | 0 | |
ges resource hash list | 668,684 | 0.11 | 0.03 | 0 | 23,448 | 0.43 |
ges resource scan list | 3,132 | 0.00 | 0 | 0 | ||
ges resource table freelist | 15,364 | 0.00 | 0 | 2 | 0.00 | |
ges timeout list | 7,001 | 0.00 | 0 | 14,394 | 0.00 | |
global KZLD latch for mem in SGA | 54,212 | 0.00 | 0 | 0 | ||
global hanganlyze operation | 2 | 0.00 | 0 | 0 | ||
global tx hash mapping | 513 | 0.00 | 0 | 0 | ||
hash table column usage latch | 939 | 0.00 | 0 | 189,713 | 0.00 | |
hash table modification latch | 258 | 0.00 | 0 | 0 | ||
interrupt manipulation | 3,492 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 1,284 | 0.08 | ||
job_queue_processes parameter latch | 882 | 0.00 | 0 | 0 | ||
kks stats | 34,895 | 0.00 | 0 | 0 | ||
kmcptab latch | 1 | 0.00 | 0 | 0 | ||
kmcpvec latch | 0 | 0 | 1 | 0.00 | ||
kokc descriptor allocation latch | 308 | 0.00 | 0 | 0 | ||
ksuosstats global area | 1,080 | 0.00 | 0 | 0 | ||
ksv instance | 2 | 0.00 | 0 | 0 | ||
ktm global data | 3,324 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 573 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 37,901 | 0.00 | 0 | 0 | ||
library cache | 3,393,578 | 0.16 | 0.01 | 7 | 18,369 | 0.01 |
library cache load lock | 220 | 0.00 | 0 | 0 | ||
library cache lock | 5,555,487 | 0.50 | 0.01 | 17 | 0 | |
library cache lock allocation | 157,182 | 0.01 | 0.18 | 0 | 0 | |
library cache pin | 933,802 | 0.01 | 0.00 | 0 | 1 | 0.00 |
library cache pin allocation | 1,460 | 0.00 | 0 | 0 | ||
list of block allocation | 10,002 | 0.00 | 0 | 0 | ||
loader state object freelist | 40,074 | 0.02 | 0.00 | 0 | 0 | |
logminer context allocation | 2 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 5,240 | 0.00 | 0 | 0 | ||
messages | 912,850 | 0.02 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 38,068 | 0.08 | 0.03 | 0 | 0 | |
msg queue | 244 | 0.00 | 0 | 244 | 0.00 | |
multiblock read objects | 5,350 | 0.00 | 0 | 0 | ||
name-service memory objects | 54,614 | 0.01 | 0.00 | 0 | 0 | |
name-service namespace bucket | 165,548 | 0.00 | 0 | 0 | ||
name-service pending queue | 32,542 | 0.00 | 0 | 0 | ||
name-service request | 256 | 1.95 | 0.00 | 0 | 0 | |
name-service request queue | 198,942 | 0.00 | 0.00 | 0 | 0 | |
ncodef allocation latch | 705 | 0.00 | 0 | 0 | ||
object queue header heap | 100,802 | 0.00 | 0 | 1,056 | 0.00 | |
object queue header operation | 274,744 | 0.00 | 0.00 | 0 | 0 | |
object stats modification | 5 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 10,256 | 0.00 | 0 | 0 | ||
parallel query stats | 1,631 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 72,030 | 0.00 | 0 | 0 | ||
parameter list | 489,952 | 0.02 | 0.00 | 0 | 0 | |
parameter table management | 112,831 | 0.00 | 0 | 0 | ||
post/wait queue | 77,816 | 0.02 | 0.00 | 0 | 33,028 | 0.00 |
process allocation | 245,764 | 1.02 | 1.73 | 47 | 55,026 | 0.26 |
process group creation | 110,420 | 0.05 | 0.02 | 0 | 0 | |
process queue | 4,423 | 0.00 | 0 | 0 | ||
process queue reference | 75,169 | 0.01 | 0.00 | 0 | 7,142 | 0.00 |
qmn task queue latch | 3,517 | 15.81 | 0.00 | 0 | 0 | |
query server freelists | 3,671 | 0.14 | 0.00 | 0 | 0 | |
query server process | 0 | 0 | 64 | 0.00 | ||
queued dump request | 80,633 | 0.00 | 0 | 0 | ||
redo allocation | 113,541 | 0.03 | 0.00 | 0 | 218,723 | 0.03 |
redo copy | 0 | 0 | 218,745 | 0.05 | ||
redo writing | 159,704 | 0.00 | 0.00 | 0 | 0 | |
resmgr group change latch | 57,497 | 0.00 | 0 | 0 | ||
resmgr:active threads | 112,292 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 55,815 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 112,290 | 0.31 | 0.08 | 4 | 0 | |
resmgr:resource group CPU method | 55,826 | 0.00 | 0.00 | 0 | 0 | |
resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
row cache objects | 6,008,028 | 0.10 | 0.00 | 4 | 4,296 | 7.17 |
rules engine aggregate statistics | 21 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 242 | 0.00 | 0 | 0 | ||
segmented array pool | 104 | 0.00 | 0 | 0 | ||
sequence cache | 681,141 | 0.10 | 0.01 | 0 | 0 | |
session allocation | 1,158,991 | 1.44 | 0.07 | 4 | 0 | |
session idle bit | 5,107,141 | 0.00 | 0.00 | 0 | 0 | |
session state list latch | 112,666 | 0.02 | 0.00 | 0 | 0 | |
session switching | 276,955 | 0.06 | 0.04 | 0 | 0 | |
session timer | 14,800 | 0.00 | 0 | 0 | ||
shared pool | 1,866,539 | 0.43 | 0.03 | 25 | 0 | |
shared pool simulator | 40,059 | 0.00 | 0.00 | 0 | 0 | |
simulator hash latch | 3,479,169 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 0 | 0 | 3,478,218 | 0.20 | ||
slave class | 932 | 0.00 | 0 | 0 | ||
slave class create | 6,329 | 0.05 | 1.00 | 0 | 0 | |
sort extent pool | 4,177 | 0.00 | 0 | 0 | ||
state object free list | 4 | 0.00 | 0 | 0 | ||
statistics aggregation | 1,344 | 0.00 | 0 | 0 | ||
temporary table state object allocation | 1 | 0.00 | 0 | 0 | ||
threshold alerts latch | 2,932 | 0.00 | 0 | 0 | ||
transaction allocation | 11,090 | 0.00 | 0 | 0 | ||
transaction branch allocation | 15,166 | 0.00 | 0 | 0 | ||
undo global data | 283,561 | 0.00 | 0.00 | 0 | 0 | |
user lock | 218,509 | 1.67 | 0.01 | 3 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
cache buffers chains | 98,975,850 | 88,878 | 2,801 | 86,180 | 0 | 0 | 0 |
library cache lock | 5,555,487 | 27,870 | 141 | 27,747 | 0 | 0 | 0 |
session allocation | 1,158,991 | 16,672 | 1,153 | 15,595 | 0 | 0 | 0 |
shared pool | 1,866,539 | 8,060 | 204 | 7,886 | 0 | 0 | 0 |
row cache objects | 6,008,028 | 5,792 | 28 | 5,771 | 0 | 0 | 0 |
library cache | 3,393,578 | 5,549 | 82 | 5,479 | 0 | 0 | 0 |
user lock | 218,509 | 3,658 | 33 | 3,633 | 0 | 0 | 0 |
process allocation | 245,764 | 2,511 | 4,353 | 246 | 0 | 0 | 0 |
active service list | 315,339 | 1,834 | 161 | 1,681 | 0 | 0 | 0 |
ges resource hash list | 668,684 | 768 | 22 | 746 | 0 | 0 | 0 |
sequence cache | 681,141 | 656 | 5 | 651 | 0 | 0 | 0 |
qmn task queue latch | 3,517 | 556 | 1 | 555 | 0 | 0 | 0 |
resmgr:free threads list | 112,290 | 351 | 28 | 327 | 0 | 0 | 0 |
KJCT flow control latch | 406,010 | 259 | 2 | 257 | 0 | 0 | 0 |
channel operations parent latch | 1,278,784 | 249 | 8 | 243 | 0 | 0 | 0 |
OS process: request allocation | 110,421 | 177 | 62 | 136 | 0 | 0 | 0 |
session switching | 276,955 | 166 | 6 | 162 | 0 | 0 | 0 |
OS process allocation | 117,531 | 134 | 27 | 111 | 0 | 0 | 0 |
enqueues | 951,932 | 111 | 3 | 108 | 0 | 0 | 0 |
gcs resource hash | 252,127 | 80 | 4 | 77 | 0 | 0 | 0 |
process group creation | 110,420 | 52 | 1 | 51 | 0 | 0 | 0 |
ges process table freelist | 110,421 | 34 | 1 | 33 | 0 | 0 | 0 |
mostly latch-free SCN | 38,068 | 32 | 1 | 31 | 0 | 0 | 0 |
KCL gc element parent latch | 244,325 | 24 | 6 | 19 | 0 | 0 | 0 |
library cache lock allocation | 157,182 | 11 | 2 | 10 | 0 | 0 | 0 |
KWQMN job cache list latch | 5,213 | 6 | 3 | 3 | 0 | 0 | 0 |
cache buffers lru chain | 95,442 | 4 | 2 | 2 | 0 | 0 | 0 |
slave class create | 6,329 | 3 | 3 | 0 | 0 | 0 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
KCL gc element parent latch | kclchkping | 0 | 4 | 0 |
KCL gc element parent latch | kclpto | 0 | 1 | 4 |
KCL gc element parent latch | kclpto_1 | 0 | 1 | 0 |
KJCT flow control latch | kjcts_sqenq: queue a message | 0 | 2 | 1 |
KWQMN job cache list latch | kwqmnprsc: loop | 0 | 3 | 0 |
OS process allocation | kso_new_process:2 | 0 | 17 | 16 |
OS process allocation | kso_delete_process:1 | 0 | 10 | 11 |
OS process: request allocation | kso_new_process | 0 | 34 | 19 |
OS process: request allocation | ksoreqholder_delete | 0 | 28 | 43 |
active service list | kswslogon: session logout | 0 | 979 | 968 |
active service list | kswslogon: session login | 0 | 20 | 7 |
active service list | kswsgsnp: get service name ptr | 0 | 7 | 26 |
active service list | kswssyis: find service entry 1 | 0 | 3 | 3 |
active service list | kswsclstabc: scan list to return rows | 0 | 1 | 1 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 13,033 | 4,905 |
cache buffers chains | kcbrls: kslbegin | 0 | 291 | 8,555 |
cache buffers chains | kcbgtcr: fast path | 0 | 145 | 8 |
cache buffers chains | kcbzwb | 0 | 21 | 10 |
cache buffers chains | kclbla | 0 | 15 | 0 |
cache buffers chains | kcbgcur: kslbegin | 0 | 12 | 7 |
cache buffers chains | kcbget: pin buffer | 0 | 7 | 5 |
cache buffers chains | kclwrt | 0 | 4 | 0 |
cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 3 | 4 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 1 | 2 |
cache buffers lru chain | kcbzgb: posted for free bufs | 0 | 1 | 1 |
cache buffers lru chain | kcbzgws | 0 | 1 | 0 |
channel handle pool latch | ksrchdelete() | 0 | 1 | 1 |
channel operations parent latch | ksrchdelete() | 0 | 24 | 23 |
cost function | kzulrl | 0 | 24 | 27 |
cost function | kzulgt: find user res | 0 | 9 | 6 |
enqueues | ksqies | 0 | 3 | 3 |
event range base latch | No latch | 0 | 7 | 8 |
gcs resource hash | kjbassume | 0 | 2 | 0 |
gcs resource hash | kjblocalfile_nolock | 0 | 2 | 0 |
ges process table freelist | kjpfr: free process | 0 | 1 | 1 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 19 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 2 | 0 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 1 | 19 |
lgwr LWN SCN | kcs023 | 0 | 1 | 0 |
library cache | kglhdgn: child: | 0 | 27 | 39 |
library cache | kgldte: child 0 | 0 | 26 | 30 |
library cache | kglLockCursor | 0 | 13 | 3 |
library cache | kglobpn: child: | 0 | 5 | 7 |
library cache | kglpndl: child: after processing | 0 | 2 | 0 |
library cache | kglpndl: child: before processing | 0 | 2 | 0 |
library cache lock | kgllkdl: child: cleanup | 0 | 121 | 115 |
library cache lock | kgllkal: child: multiinstance | 0 | 14 | 19 |
library cache lock allocation | kgllkget | 0 | 2 | 2 |
object queue header operation | kcbo_switch_mq_bg | 0 | 2 | 0 |
process allocation | ksuapc | 0 | 2,085 | 1,614 |
process allocation | ksucrp | 0 | 1,708 | 0 |
process allocation | ksudlp | 0 | 463 | 1,301 |
process allocation | ksufap: active procs | 0 | 99 | 1,440 |
process group creation | ksupgprem | 0 | 1 | 1 |
resmgr:free threads list | kgskthrsod | 0 | 24 | 21 |
resmgr:free threads list | kgskthrcreate | 0 | 4 | 7 |
row cache objects | kqrpre: find obj | 0 | 15 | 23 |
row cache objects | kqreqd: reget | 0 | 7 | 0 |
row cache objects | kqrbip | 0 | 2 | 0 |
row cache objects | kqreqd | 0 | 2 | 3 |
row cache objects | kqrso | 0 | 2 | 0 |
sequence cache | kdnnxt: cached seq | 0 | 4 | 0 |
sequence cache | kdnssd | 0 | 1 | 0 |
session allocation | ksuxds: KSUSFCLC not set | 0 | 881 | 305 |
session allocation | ksudlp | 0 | 117 | 386 |
session allocation | ksucri | 0 | 96 | 300 |
session allocation | ksuxds: not user session | 0 | 43 | 155 |
session allocation | ksufap: active sessions | 0 | 13 | 0 |
session allocation | ksucrp | 0 | 3 | 7 |
session switching | kskexeall | 0 | 6 | 6 |
shared pool | kghalo | 0 | 95 | 78 |
shared pool | kghfre | 0 | 83 | 112 |
shared pool | kghfrunp: alloc: session dur | 0 | 17 | 0 |
shared pool | kghfrunp: clatch: nowait | 0 | 7 | 0 |
shared pool | kghupr1 | 0 | 7 | 12 |
shared pool | kghfrunp: alloc: cursor dur | 0 | 2 | 0 |
slave class create | ksvcreate | 0 | 3 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE_CONTENT_RELATION | TABLE | 8,490,720 | 14.19 | |
WCITY2 | WCITY2_INDEX | PK_TB_ARTICLE_DESC | INDEX | 8,358,736 | 13.97 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE_DESC | TABLE | 6,426,080 | 10.74 | |
SYS | SYSTEM | I_OBJ2 | INDEX | 5,515,856 | 9.22 | |
WCITY2 | WCITY2_INDEX | PK_TB_ARTICLE_CONTENT | INDEX | 4,927,504 | 8.23 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 740 | 0.73 | |
WCITY2 | WCITY2_DATA | TB_AUTH_LOG | TABLE | 594 | 0.58 | |
WCITY2 | WCITY2_DATA | INDEX_LOGIN_LOG_CA | INDEX | 150 | 0.15 | |
WCITY2 | WCITY2_DATA | SYS_LOB0000126366C00002$$ | LOB | 110 | 0.11 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 107 | 0.11 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 18 | 33.33 | |
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 17 | 31.48 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 8 | 14.81 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 8 | 14.81 | |
WCITY2 | WCITY2_DATA | TB_ACCESS_TOKEN | TABLE | 2 | 3.70 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 6 | 50.00 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 4 | 33.33 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 1 | 8.33 | |
WCITY2 | WCITY2_INDEX | PK_TB_ACCESS_TOKEN | INDEX | 1 | 8.33 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
SYS | SYSTEM | SEQ$ | TABLE | 16 | 47.06 | |
WCITY2 | WCITY2_DATA | TB_USER_OPER_LOG | P_20130307 | TABLE PARTITION | 7 | 20.59 |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 5 | 14.71 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 1 | 2.94 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 1 | 2.94 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
SYS | SYSTEM | USER$ | TABLE | 47 | 48.45 | |
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 12 | 12.37 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 11 | 11.34 | |
WCITY2 | WCITY2_DATA | TB_USER_OPER_LOG | P_20130307 | TABLE PARTITION | 9 | 9.28 |
SYS | SYSTEM | SEQ$ | TABLE | 5 | 5.15 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 2,107 | 29.64 | |
SYS | SYSTEM | JOB$ | TABLE | 930 | 13.08 | |
SYS | SYSTEM | SEQ$ | TABLE | 899 | 12.65 | |
WCITY2 | WCITY2_DATA | TB_PORTAL_USER | TABLE | 259 | 3.64 | |
WCITY2 | WCITY2_INDEX | INDEX_TB_P_U_MOBILE | INDEX | 229 | 3.22 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 1,901 | 16.42 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 1,893 | 16.35 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 1,717 | 14.83 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 1,679 | 14.50 | |
SYS | SYSTEM | SEQ$ | TABLE | 1,290 | 11.14 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 284 | 0.00 | 0 | 3 | 1 | |
dc_database_links | 109,643 | 0.00 | 0 | 0 | 4 | |
dc_global_oids | 5,096 | 0.00 | 0 | 0 | 97 | |
dc_histogram_data | 189,887 | 0.07 | 0 | 0 | 2,400 | |
dc_histogram_defs | 54,915 | 0.46 | 0 | 0 | 2,944 | |
dc_object_ids | 244,239 | 0.02 | 0 | 0 | 1,239 | |
dc_objects | 77,299 | 0.11 | 0 | 4 | 762 | |
dc_profiles | 54,853 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 110,552 | 0.00 | 0 | 0 | 688 | |
dc_segments | 78,581 | 0.76 | 0 | 24 | 4,364 | |
dc_sequences | 6,863 | 17.53 | 0 | 6,863 | 19 | |
dc_tablespace_quotas | 21 | 57.14 | 0 | 21 | 0 | |
dc_tablespaces | 84,292 | 0.00 | 0 | 0 | 25 | |
dc_usernames | 220,832 | 0.00 | 0 | 0 | 52 | |
dc_users | 1,149,364 | 0.00 | 0 | 0 | 73 | |
outstanding_alerts | 1,328 | 94.28 | 0 | 21 | 4 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 6 | 0 | 0 |
dc_histogram_defs | 250 | 0 | 1,423 |
dc_object_ids | 41 | 0 | 515 |
dc_objects | 91 | 5 | 262 |
dc_segments | 734 | 22 | 42 |
dc_sequences | 13,714 | 1,198 | 0 |
dc_tablespace_quotas | 42 | 13 | 1 |
dc_usernames | 1 | 0 | 1 |
outstanding_alerts | 2,623 | 1,243 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 4,413 | 0.00 | 9,273 | 0.00 | 0 | 0 |
CLUSTER | 6 | 0.00 | 8 | 0.00 | 0 | 0 |
INDEX | 23 | 26.09 | 83 | 7.23 | 0 | 0 |
JAVA DATA | 4 | 75.00 | 4 | 75.00 | 0 | 0 |
JAVA RESOURCE | 4 | 75.00 | 4 | 75.00 | 0 | 0 |
JAVA SOURCE | 4 | 75.00 | 4 | 75.00 | 0 | 0 |
SQL AREA | 442,926 | 2.90 | 1,420,605 | 1.45 | 629 | 1 |
TABLE/PROCEDURE | 11,420 | 0.11 | 362,509 | 0.03 | 51 | 0 |
TRIGGER | 252 | 1.19 | 777 | 0.39 | 0 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
CLUSTER | 8 | 0 | 1 | 0 | 0 |
INDEX | 83 | 6 | 6 | 3 | 0 |
JAVA DATA | 4 | 3 | 1 | 0 | 0 |
JAVA RESOURCE | 4 | 3 | 1 | 0 | 0 |
JAVA SOURCE | 4 | 3 | 0 | 0 | 0 |
TABLE/PROCEDURE | 36,483 | 43 | 44 | 34 | 0 |
TRIGGER | 4 | 3 | 2 | 0 | 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 | 859.42 | 0.68 | 1.37 | 21 | 21 | 1,267 | 1,267 | |
Freeable | 71.75 | 0.00 | 1.49 | 2.96 | 21 | 48 | 48 | ||
SQL | 4.74 | 3.90 | 0.00 | 0.08 | 3 | 12 | 1,175 | 296 | |
PL/SQL | 3.02 | 0.82 | 0.00 | 0.00 | 0 | 0 | 1,265 | 1,201 | |
E | Other | 866.02 | 0.72 | 1.42 | 21 | 21 | 1,198 | 1,198 | |
Freeable | 73.75 | 0.00 | 1.34 | 2.79 | 21 | 55 | 55 | ||
PL/SQL | 2.55 | 0.40 | 0.00 | 0.00 | 0 | 0 | 1,196 | 1,196 | |
SQL | 2.28 | 1.36 | 0.00 | 0.01 | 0 | 5 | 1,162 | 377 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 30,752,636,928 | |
Fixed Size | 2,159,376 | |
Redo Buffers | 14,614,528 | |
Variable Size | 3,590,327,536 |
Pool | Name | Begin MB | End MB | % Diff |
---|---|---|---|---|
java | free memory | 32.00 | 32.00 | 0.00 |
large | ASM map operations hashta | 0.38 | 0.38 | 0.00 |
large | PX msg pool | 1.03 | 1.03 | 0.00 |
large | free memory | 14.60 | 14.60 | 0.00 |
shared | ASH buffers | 50.00 | 50.00 | 0.00 |
shared | CCursor | 131.69 | 141.09 | 7.13 |
shared | PCursor | 103.94 | 112.03 | 7.78 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | free memory | 638.01 | 573.10 | -10.17 |
shared | gcs resources | 690.04 | 690.04 | 0.00 |
shared | gcs shadows | 370.55 | 370.55 | 0.00 |
shared | kglsim object batch | 50.77 | 50.77 | 0.00 |
shared | library cache | 88.90 | 90.81 | 2.15 |
shared | sql area | 664.90 | 713.41 | 7.30 |
streams | free memory | 32.00 | 32.00 | 0.00 |
buffer_cache | 29,328.00 | 29,328.00 | 0.00 | |
fixed_sga | 2.06 | 2.06 | 0.00 | |
log_buffer | 13.94 | 13.94 | 0.00 |
Session Type | CPU Time | User I/O Time | Sys I/O Time |
---|---|---|---|
QMON Slaves | 3,237,507 | 176,452 | 0 |
QMON Coordinator | 60,991 | 0 | 0 |
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 21 | 0 | 0 | 1 | 0 |
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
gcs_resources | 1,347,973 | 3,979,876 | 4005095 | 4005095 |
ges_procs | 1,198 | 1,657 | 2001 | 2001 |
processes | 1,199 | 1,659 | 2000 | 2000 |
sessions | 1,212 | 1,989 | 2205 | 2205 |
Parameter Name | Begin value | End value (if different) |
---|---|---|
audit_file_dest | /oracle/app/oracle/admin/acsdb/adump | |
background_dump_dest | /oracle/app/oracle/admin/acsdb/bdump | |
cluster_database | TRUE | |
cluster_database_instances | 2 | |
compatible | 10.2.0.5.0 | |
control_files | +DATA/acsdb/controlfile/current.261.762113963, +DATA/acsdb/controlfile/current.260.762113963 | |
core_dump_dest | /oracle/app/oracle/admin/acsdb/cdump | |
db_block_size | 8192 | |
db_create_file_dest | +DATA | |
db_domain | ||
db_file_multiblock_read_count | 16 | |
db_name | acsdb | |
db_recovery_file_dest | +DATA | |
db_recovery_file_dest_size | 209715200000 | |
dispatchers | (PROTOCOL=TCP) (SERVICE=acsdbXDB) | |
instance_number | 2 | |
job_queue_processes | 10 | |
local_listener | (ADDRESS = (PROTOCOL = TCP)(HOST = 10.46.51.198)(PORT = 1521)) | |
log_archive_dest_1 | LOCATION=+DATA/ | |
log_archive_format | %t_%s_%r.dbf | |
open_cursors | 300 | |
pga_aggregate_target | 8434745344 | |
processes | 2000 | |
remote_listener | LISTENERS_ACSDB | |
remote_login_passwordfile | EXCLUSIVE | |
service_names | acsdb | |
sessions | 2205 | |
sga_max_size | 34359738368 | |
sga_target | 34359738368 | |
spfile | +DATA/acsdb/spfileacsdb.ora | |
statistics_level | TYPICAL | |
thread | 2 | |
undo_management | AUTO | |
undo_retention | 4500 | |
undo_tablespace | UNDOTBS2 | |
user_dump_dest | /oracle/app/oracle/admin/acsdb/udump |
Statistic | Total | per Second | per Trans |
---|---|---|---|
acks for commit broadcast(actual) | 33,114 | 2.05 | 0.96 |
acks for commit broadcast(logical) | 33,298 | 2.06 | 0.96 |
broadcast msgs on commit(actual) | 37,577 | 2.33 | 1.09 |
broadcast msgs on commit(logical) | 37,591 | 2.33 | 1.09 |
broadcast msgs on commit(wasted) | 871 | 0.05 | 0.03 |
broadcast on commit wait time(ms) | 8,738 | 0.54 | 0.25 |
broadcast on commit waits | 35,477 | 2.20 | 1.03 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 0 | 0.00 | 0.00 |
flow control messages received | 0 | 0.00 | 0.00 |
flow control messages sent | 1 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 21,142 | 1.31 | 0.61 |
gcs ast xid | 1 | 0.00 | 0.00 |
gcs blocked converts | 14,068 | 0.87 | 0.41 |
gcs blocked cr converts | 7,308 | 0.45 | 0.21 |
gcs compatible basts | 5 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 555 | 0.03 | 0.02 |
gcs compatible cr basts (local) | 14,213 | 0.88 | 0.41 |
gcs cr basts to PIs | 0 | 0.00 | 0.00 |
gcs cr serve without current lock | 0 | 0.00 | 0.00 |
gcs dbwr flush pi msgs | 1,364 | 0.08 | 0.04 |
gcs dbwr write request msgs | 1,295 | 0.08 | 0.04 |
gcs error msgs | 0 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 202 | 0.01 | 0.01 |
gcs immediate (null) converts | 10,794 | 0.67 | 0.31 |
gcs immediate cr (compatible) converts | 0 | 0.00 | 0.00 |
gcs immediate cr (null) converts | 465 | 0.03 | 0.01 |
gcs indirect ast | 9,975 | 0.62 | 0.29 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 406 | 0.03 | 0.01 |
gcs msgs process time(ms) | 14,104 | 0.87 | 0.41 |
gcs msgs received | 191,857 | 11.88 | 5.55 |
gcs out-of-order msgs | 8 | 0.00 | 0.00 |
gcs pings refused | 14 | 0.00 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs queued converts | 14 | 0.00 | 0.00 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 3 | 0.00 | 0.00 |
gcs regular cr | 0 | 0.00 | 0.00 |
gcs retry convert request | 2,681 | 0.17 | 0.08 |
gcs side channel msgs actual | 12,810 | 0.79 | 0.37 |
gcs side channel msgs logical | 21,323 | 1.32 | 0.62 |
gcs stale cr | 7,439 | 0.46 | 0.22 |
gcs undo cr | 0 | 0.00 | 0.00 |
gcs write notification msgs | 129 | 0.01 | 0.00 |
gcs writes refused | 7 | 0.00 | 0.00 |
ges msgs process time(ms) | 1,112 | 0.07 | 0.03 |
ges msgs received | 52,472 | 3.25 | 1.52 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 823,172 | 50.99 | 23.80 |
global posts queued | 248 | 0.02 | 0.01 |
global posts requested | 248 | 0.02 | 0.01 |
global posts sent | 249 | 0.02 | 0.01 |
implicit batch messages received | 15,186 | 0.94 | 0.44 |
implicit batch messages sent | 10,098 | 0.63 | 0.29 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 74,884 | 4.64 | 2.16 |
messages queue sent actual | 136,334 | 8.44 | 3.94 |
messages queue sent logical | 147,250 | 9.12 | 4.26 |
messages received actual | 216,322 | 13.40 | 6.25 |
messages received logical | 244,329 | 15.13 | 7.06 |
messages sent directly | 34,610 | 2.14 | 1.00 |
messages sent indirectly | 63,631 | 3.94 | 1.84 |
messages sent not implicit batched | 126,236 | 7.82 | 3.65 |
messages sent pbatched | 70,128 | 4.34 | 2.03 |
msgs causing lmd to send msgs | 10,487 | 0.65 | 0.30 |
msgs causing lms(s) to send msgs | 11,783 | 0.73 | 0.34 |
msgs received queue time (ms) | 5,362 | 0.33 | 0.16 |
msgs received queued | 244,329 | 15.13 | 7.06 |
msgs sent queue time (ms) | 8,754 | 0.54 | 0.25 |
msgs sent queue time on ksxp (ms) | 43,405 | 2.69 | 1.25 |
msgs sent queued | 147,091 | 9.11 | 4.25 |
msgs sent queued on ksxp | 204,837 | 12.69 | 5.92 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 73,629 | 4.56 | 2.13 |
process batch messages sent | 56,288 | 3.49 | 1.63 |
Statistic | Total |
---|---|
CR Block Requests | 8,136 |
CURRENT Block Requests | 1,190 |
Data Block Requests | 8,136 |
Undo Block Requests | 0 |
TX Block Requests | 822 |
Current Results | 9,318 |
Private results | 0 |
Zero Results | 8 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 1,685 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 481 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 0 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 45,011 | 99.92 | 0.00 | 0.07 | 0.00 | 0.00 |
Flushes | 364 | 84.07 | 15.66 | 0.27 | 0.00 | 0.00 |
Writes | 1,696 | 66.86 | 31.54 | 0.35 | 0.47 | 0.77 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 5,737 | 92.14 | 7.86 | 0.00 | 11,080 | 97.36 | 2.64 | 0.00 |
1 | undo header | 1,015 | 99.90 | 0.10 | 0.00 | 57 | 94.74 | 5.26 | 0.00 |
1 | Others | 355 | 93.24 | 6.76 | 0.00 | 432 | 93.98 | 6.02 | 0.00 |