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: | 581 | 14-3ÔÂ -13 15:00:37 | 1206 | .5 |
End Snap: | 583 | 14-3ÔÂ -13 17:27:59 | 1145 | .5 |
Elapsed: | 147.37 (mins) | |||
DB Time: | 53.57 (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: | 9,886.93 | 1,880.01 |
Logical reads: | 8,794.59 | 1,672.31 |
Block changes: | 67.52 | 12.84 |
Physical reads: | 4.06 | 0.77 |
Physical writes: | 1.89 | 0.36 |
User calls: | 203.05 | 38.61 |
Parses: | 73.04 | 13.89 |
Hard parses: | 0.80 | 0.15 |
Sorts: | 41.49 | 7.89 |
Logons: | 3.42 | 0.65 |
Executes: | 71.13 | 13.53 |
Transactions: | 5.26 |
% Blocks changed per Read: | 0.77 | Recursive Call %: | 52.91 |
Rollback per transaction %: | 2.50 | Rows per Sort: | 26.77 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 100.05 | In-memory Sort %: | 100.00 |
Library Hit %: | 98.32 | Soft Parse %: | 98.90 |
Execute to Parse %: | -2.69 | Latch Hit %: | 99.85 |
Parse CPU to Parse Elapsd %: | 80.39 | % Non-Parse CPU: | 96.97 |
Begin | End | |
---|---|---|
Memory Usage %: | 82.63 | 85.12 |
% SQL with executions>1: | 91.57 | 99.63 |
% Memory for SQL w/exec>1: | 91.03 | 99.37 |
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
enq: WF - contention | 10,930 | 5,319 | 487 | 165.5 | Other |
CPU time | 3,956 | 123.1 | |||
log file sync | 46,457 | 49 | 1 | 1.5 | Commit |
latch free | 3,506 | 48 | 14 | 1.5 | Other |
latch: library cache lock | 154 | 41 | 263 | 1.3 | Concurrency |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 1.39 | 0.27 |
Global Cache blocks served: | 2.26 | 0.43 |
GCS/GES messages received: | 15.64 | 2.97 |
GCS/GES messages sent: | 16.20 | 3.08 |
DBWR Fusion writes: | 0.18 | 0.03 |
Estd Interconnect traffic (KB) | 35.42 |
Buffer access - local cache %: | 100.03 |
Buffer access - remote cache %: | 0.02 |
Buffer access - disk %: | -0.05 |
Avg global enqueue get time (ms): | 5.4 |
Avg global cache cr block receive time (ms): | 0.4 |
Avg global cache current block receive time (ms): | 0.4 |
Avg global cache cr block build time (ms): | 0.1 |
Avg global cache cr block send time (ms): | 0.0 |
Global cache log flushes for cr blocks served %: | 3.8 |
Avg global cache cr block flush time (ms): | 1.0 |
Avg global cache current block pin time (ms): | 0.1 |
Avg global cache current block send time (ms): | 0.5 |
Global cache log flushes for current blocks served %: | 1.0 |
Avg global cache current block flush time (ms): | 2.4 |
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: | 16.38 |
% of indirect sent messages: | 23.32 |
% of flow controlled messages: | 60.30 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
DB CPU | 3,955.72 | 123.07 |
sql execute elapsed time | 1,822.24 | 56.69 |
connection management call elapsed time | 215.60 | 6.71 |
parse time elapsed | 148.33 | 4.61 |
hard parse elapsed time | 43.99 | 1.37 |
sequence load elapsed time | 9.09 | 0.28 |
PL/SQL execution elapsed time | 8.65 | 0.27 |
failed parse elapsed time | 0.21 | 0.01 |
PL/SQL compilation elapsed time | 0.14 | 0.00 |
hard parse (sharing criteria) elapsed time | 0.11 | 0.00 |
repeated bind elapsed time | 0.01 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.01 | 0.00 |
DB time | 3,214.13 | |
background elapsed time | 5,621.52 | |
background cpu time | 163.96 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %Total Call Time |
---|---|---|---|---|---|
Other | 613,661 | 20 | 5,400 | 9 | 168.00 |
CPU time | 3,956 | 123.07 | |||
Concurrency | 10,803 | 0 | 98 | 9 | 3.04 |
System I/O | 193,089 | 61 | 0 | 1.89 | |
Commit | 46,457 | 0 | 49 | 1 | 1.52 |
User I/O | 38,266 | 15 | 0 | 0.46 | |
Cluster | 15,201 | 0 | 10 | 1 | 0.33 |
Network | 1,546,222 | 8 | 0 | 0.26 | |
Application | 3,447 | 3 | 1 | 0.09 | |
Configuration | 3,082 | 0 | 2 | 1 | 0.06 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
enq: WF - contention | 10,930 | 99 | 5,319 | 487 | 0.24 |
log file sync | 46,457 | 0 | 49 | 1 | 1.00 |
latch free | 3,506 | 48 | 14 | 0.08 | |
latch: library cache lock | 154 | 41 | 263 | 0.00 | |
control file sequential read | 140,664 | 40 | 0 | 3.03 | |
latch: cache buffers chains | 3,216 | 34 | 11 | 0.07 | |
log file parallel write | 49,150 | 16 | 0 | 1.06 | |
latch: session allocation | 714 | 13 | 19 | 0.02 | |
DFS lock handle | 10,456 | 11 | 1 | 0.22 | |
os thread startup | 199 | 10 | 49 | 0.00 | |
direct path read | 29,547 | 9 | 0 | 0.64 | |
db file sequential read | 8,545 | 5 | 1 | 0.18 | |
latch: library cache | 44 | 5 | 122 | 0.00 | |
gc current block 2-way | 7,193 | 4 | 1 | 0.15 | |
control file parallel write | 3,075 | 4 | 1 | 0.07 | |
SQL*Net more data to client | 125,569 | 4 | 0 | 2.70 | |
latch: shared pool | 83 | 3 | 35 | 0.00 | |
SQL*Net break/reset to client | 2,998 | 3 | 1 | 0.06 | |
enq: TX - index contention | 49 | 8 | 3 | 52 | 0.00 |
gc cr block 2-way | 4,550 | 2 | 1 | 0.10 | |
row cache lock | 6,656 | 2 | 0 | 0.14 | |
SQL*Net message to client | 1,410,371 | 2 | 0 | 30.33 | |
enq: TX - contention | 10 | 10 | 2 | 197 | 0.00 |
enq: HW - contention | 3,066 | 0 | 2 | 1 | 0.07 |
SQL*Net message from dblink | 942 | 1 | 1 | 0.02 | |
gc current grant busy | 2,042 | 1 | 1 | 0.04 | |
CGS wait for IPC msg | 85,029 | 100 | 1 | 0 | 1.83 |
gc current block busy | 136 | 1 | 9 | 0.00 | |
log file sequential read | 104 | 1 | 10 | 0.00 | |
enq: PS - contention | 456 | 0 | 1 | 2 | 0.01 |
SQL*Net more data from client | 8,440 | 1 | 0 | 0.18 | |
name-service call wait | 10 | 1 | 59 | 0.00 | |
gcs log flush sync | 603 | 1 | 1 | 1 | 0.01 |
cursor: pin S | 462,826 | 1 | 0 | 9.95 | |
gc buffer busy | 102 | 1 | 0 | 5 | 0.00 |
gc cr block busy | 307 | 0 | 2 | 0.01 | |
PX Deq Credit: send blkd | 1,114 | 61 | 0 | 0 | 0.02 |
ksxr poll remote instances | 23,293 | 63 | 0 | 0 | 0.50 |
enq: TM - contention | 445 | 0 | 1 | 0.01 | |
reliable message | 570 | 0 | 0 | 0.01 | |
PX Deq: reap credit | 12,327 | 92 | 0 | 0 | 0.27 |
rdbms ipc reply | 668 | 0 | 0 | 0.01 | |
undo segment extension | 1 | 100 | 0 | 99 | 0.00 |
gc current multi block request | 499 | 0 | 0 | 0.01 | |
log file switch completion | 4 | 0 | 22 | 0.00 | |
gc current grant 2-way | 218 | 0 | 0 | 0.00 | |
PX Deq: Signal ACK | 498 | 32 | 0 | 0 | 0.01 |
IPC send completion sync | 207 | 100 | 0 | 0 | 0.00 |
CSS operation: query | 18 | 0 | 3 | 0.00 | |
gc cr multi block request | 123 | 0 | 0 | 0.00 | |
library cache lock | 110 | 0 | 0 | 0.00 | |
buffer busy waits | 168 | 0 | 0 | 0.00 | |
library cache pin | 101 | 0 | 0 | 0.00 | |
enq: FB - contention | 81 | 0 | 0 | 0.00 | |
Log archive I/O | 88 | 0 | 0 | 0.00 | |
Data file init write | 42 | 0 | 1 | 0.00 | |
enq: TA - contention | 58 | 0 | 1 | 0.00 | |
enq: SQ - contention | 5 | 0 | 6 | 0.00 | |
cursor: pin S wait on X | 2 | 100 | 0 | 11 | 0.00 |
enq: CF - contention | 43 | 0 | 0 | 0.00 | |
gc cr grant 2-way | 22 | 0 | 1 | 0.00 | |
enq: TD - KTF dump entries | 29 | 0 | 1 | 0.00 | |
latch: row cache objects | 20 | 0 | 1 | 0.00 | |
direct path write | 126 | 0 | 0 | 0.00 | |
global enqueue expand wait | 1 | 100 | 0 | 12 | 0.00 |
CSS initialization | 6 | 0 | 2 | 0.00 | |
wait list latch free | 1 | 0 | 10 | 0.00 | |
enq: JQ - contention | 13 | 0 | 0 | 0.00 | |
gc current split | 9 | 0 | 0 | 0.00 | |
LGWR wait for redo copy | 124 | 0 | 0 | 0.00 | |
enq: TX - allocate ITL entry | 6 | 0 | 1 | 0.00 | |
CSS operation: action | 12 | 0 | 0 | 0.00 | |
read by other session | 2 | 0 | 1 | 0.00 | |
enq: DR - contention | 4 | 0 | 1 | 0.00 | |
latch: ges resource hash list | 27 | 0 | 0 | 0.00 | |
enq: JS - job run lock - synchronize | 5 | 0 | 0 | 0.00 | |
log file single write | 8 | 0 | 0 | 0.00 | |
enq: TX - row lock contention | 2 | 0 | 1 | 0.00 | |
SQL*Net message to dblink | 900 | 0 | 0 | 0.02 | |
db file single write | 4 | 0 | 0 | 0.00 | |
enq: TT - contention | 2 | 0 | 1 | 0.00 | |
enq: PI - contention | 2 | 0 | 0 | 0.00 | |
enq: PW - flush prewarm buffers | 2 | 0 | 0 | 0.00 | |
enq: AF - task serialization | 1 | 0 | 0 | 0.00 | |
enq: WL - contention | 1 | 0 | 0 | 0.00 | |
buffer deadlock | 9 | 100 | 0 | 0 | 0.00 |
latch: enqueue hash chains | 1 | 0 | 0 | 0.00 | |
latch: KCL gc element parent latch | 3 | 0 | 0 | 0.00 | |
latch: object queue header operation | 1 | 0 | 0 | 0.00 | |
cursor: mutex S | 1 | 0 | 0 | 0.00 | |
latch: messages | 1 | 0 | 0 | 0.00 | |
PX qref latch | 1 | 100 | 0 | 0 | 0.00 |
SQL*Net message from client | 1,439,633 | 9,252,925 | 6427 | 30.96 | |
gcs remote message | 2,455,814 | 94 | 68,978 | 28 | 52.81 |
jobq slave wait | 13,769 | 96 | 39,512 | 2870 | 0.30 |
Streams AQ: qmn slave idle wait | 940 | 17,191 | 18288 | 0.02 | |
PX Idle Wait | 4,323 | 93 | 10,165 | 2351 | 0.09 |
DIAG idle wait | 44,170 | 8,632 | 195 | 0.95 | |
ASM background timer | 1,949 | 8,628 | 4427 | 0.04 | |
Streams AQ: waiting for time management or cleanup tasks | 832 | 68 | 8,628 | 10370 | 0.02 |
ges remote message | 152,919 | 70 | 8,628 | 56 | 3.29 |
Streams AQ: qmn coordinator idle wait | 802 | 40 | 8,623 | 10752 | 0.02 |
virtual circuit status | 295 | 100 | 8,608 | 29180 | 0.01 |
class slave wait | 879 | 86 | 8,530 | 9705 | 0.02 |
i/o slave wait | 15,879 | 27 | 2 | 0.34 | |
PX Deq: Execution Msg | 1,098 | 12 | 6 | 6 | 0.02 |
single-task message | 42 | 2 | 48 | 0.00 | |
KSV master wait | 67 | 2 | 30 | 0.00 | |
PX Deq: Join ACK | 541 | 34 | 1 | 2 | 0.01 |
PX Deq: Parse Reply | 512 | 34 | 0 | 0 | 0.01 |
PX Deq: Execute Reply | 457 | 33 | 0 | 0 | 0.01 |
PX Deq: Msg Fragment | 414 | 10 | 0 | 0 | 0.01 |
Streams AQ: RAC qmn coordinator idle wait | 802 | 95 | 0 | 0 | 0.02 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
log file parallel write | 49,150 | 16 | 0 | 1.06 | |
events in waitclass Other | 112,055 | 89 | 13 | 0 | 2.41 |
control file sequential read | 23,518 | 10 | 0 | 0.51 | |
os thread startup | 199 | 10 | 49 | 0.00 | |
control file parallel write | 3,063 | 4 | 1 | 0.07 | |
log file sequential read | 104 | 1 | 10 | 0.00 | |
enq: HW - contention | 3,030 | 1 | 0 | 0.07 | |
latch: cache buffers chains | 7 | 1 | 73 | 0.00 | |
gc cr block 2-way | 740 | 0 | 0 | 0.02 | |
gc current block 2-way | 373 | 0 | 1 | 0.01 | |
enq: TM - contention | 443 | 0 | 0 | 0.01 | |
db file sequential read | 8 | 0 | 7 | 0.00 | |
Log archive I/O | 88 | 0 | 0 | 0.00 | |
direct path write | 112 | 0 | 0 | 0.00 | |
gc current grant busy | 20 | 0 | 0 | 0.00 | |
log file single write | 8 | 0 | 0 | 0.00 | |
library cache lock | 3 | 0 | 0 | 0.00 | |
direct path read | 144 | 0 | 0 | 0.00 | |
gc cr grant 2-way | 1 | 0 | 0 | 0.00 | |
gc current grant 2-way | 1 | 0 | 0 | 0.00 | |
buffer busy waits | 2 | 0 | 0 | 0.00 | |
rdbms ipc message | 262,340 | 49 | 145,836 | 556 | 5.64 |
gcs remote message | 2,455,834 | 94 | 68,978 | 28 | 52.81 |
Streams AQ: qmn slave idle wait | 940 | 17,191 | 18288 | 0.02 | |
DIAG idle wait | 44,171 | 8,632 | 195 | 0.95 | |
ASM background timer | 1,949 | 8,628 | 4427 | 0.04 | |
Streams AQ: waiting for time management or cleanup tasks | 832 | 68 | 8,628 | 10370 | 0.02 |
ges remote message | 152,925 | 70 | 8,628 | 56 | 3.29 |
smon timer | 1,806 | 8,625 | 4776 | 0.04 | |
Streams AQ: qmn coordinator idle wait | 802 | 40 | 8,623 | 10752 | 0.02 |
pmon timer | 7,988 | 100 | 8,605 | 1077 | 0.17 |
class slave wait | 819 | 92 | 8,530 | 10415 | 0.02 |
KSV master wait | 39 | 1 | 21 | 0.00 | |
Streams AQ: RAC qmn coordinator idle wait | 802 | 95 | 0 | 0 | 0.02 |
Statistic | Total |
---|---|
BUSY_TIME | 622,643 |
IDLE_TIME | 27,667,135 |
IOWAIT_TIME | 6,301 |
NICE_TIME | 779 |
SYS_TIME | 315,649 |
USER_TIME | 293,596 |
LOAD | 0 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 2,761,657,344 |
VM_OUT_BYTES | 1,642,057,728 |
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 | 3,115.50 | 3,856.20 | 35,681 | 77,479,175 |
SYS$USERS | 97.70 | 99.10 | 54 | 124,352 |
SYS$BACKGROUND | 0.80 | 0.20 | 180 | 159,518 |
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 | 29674 | 11 | 9661 | 81 | 0 | 0 | 1420737 | 8 |
SYS$USERS | 8174 | 3 | 153 | 6 | 0 | 0 | 8746 | 0 |
SYS$BACKGROUND | 418 | 0 | 986 | 11 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
203 | 171 | 62,299 | 0.00 | 6.31 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
130 | 133 | 513 | 0.25 | 4.05 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
87 | 89 | 513 | 0.17 | 2.72 | 9j3v93dcqd1ng | select count(*) from (select c... | |
74 | 75 | 3 | 24.61 | 2.30 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
71 | 72 | 3 | 23.51 | 2.19 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
70 | 71 | 201 | 0.35 | 2.17 | 04v68mrc0ndtt | select * from ( select temp.* ... | |
49 | 50 | 2 | 24.38 | 1.52 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
49 | 50 | 2 | 24.38 | 1.52 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
37 | 14 | 142 | 0.26 | 1.14 | 0s07s16dca7m1 | sqlplus@OMP-ACS-DB2 (TNS V1-V3) | select STATUS from v$datafile |
35 | 36 | 81 | 0.44 | 1.10 | b6sts095f7490 | select * from ( select temp.* ... | |
33 | 30 | 29,054 | 0.00 | 1.01 | 0k8522rmdzg4k | select privilege# from sysauth... |
CPU Time (s) | Elapsed Time (s) | Executions | CPU per Exec (s) | % Total | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
171 | 203 | 62,299 | 0.00 | 4.31 | 6.31 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
133 | 130 | 513 | 0.26 | 3.36 | 4.05 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
89 | 87 | 513 | 0.17 | 2.24 | 2.72 | 9j3v93dcqd1ng | select count(*) from (select c... | |
75 | 74 | 3 | 25.02 | 1.90 | 2.30 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
72 | 71 | 3 | 24.01 | 1.82 | 2.19 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
71 | 70 | 201 | 0.35 | 1.80 | 2.17 | 04v68mrc0ndtt | select * from ( select temp.* ... | |
50 | 49 | 2 | 24.93 | 1.26 | 1.52 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
50 | 49 | 2 | 24.93 | 1.26 | 1.52 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
36 | 35 | 81 | 0.45 | 0.91 | 1.10 | b6sts095f7490 | select * from ( select temp.* ... | |
33 | 32 | 84 | 0.39 | 0.83 | 1.00 | 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 |
---|---|---|---|---|---|---|---|---|
5,882,466 | 201 | 29,266.00 | 7.56 | 71.33 | 69.84 | 04v68mrc0ndtt | select * from ( select temp.* ... | |
5,562,376 | 513 | 10,842.84 | 7.15 | 132.73 | 130.22 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
4,195,133 | 513 | 8,177.65 | 5.39 | 88.64 | 87.35 | 9j3v93dcqd1ng | select count(*) from (select c... | |
3,398,736 | 62,299 | 54.56 | 4.37 | 170.56 | 202.65 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
1,989,183 | 84 | 23,680.75 | 2.56 | 32.67 | 32.05 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
1,677,348 | 81 | 20,708.00 | 2.16 | 36.10 | 35.44 | b6sts095f7490 | select * from ( select temp.* ... | |
1,293,709 | 12,809 | 101.00 | 1.66 | 13.84 | 13.68 | chvsc0kcnaygf | select * from ( select t.adver... | |
1,144,800 | 10,800 | 106.00 | 1.47 | 11.25 | 10.79 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
1,119,016 | 3 | 373,005.33 | 1.44 | 72.02 | 70.52 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
1,119,015 | 3 | 373,005.00 | 1.44 | 75.05 | 73.84 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
1,088,881 | 10,781 | 101.00 | 1.40 | 9.60 | 9.62 | fkwdf31hccvwp | select * from ( select t.adver... | |
1,087,871 | 10,771 | 101.00 | 1.40 | 9.83 | 9.72 | 10rj3nwvwud4n | select * from ( select t.adver... | |
945,158 | 9,358 | 101.00 | 1.22 | 9.84 | 9.72 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
939,600 | 10,800 | 87.00 | 1.21 | 8.96 | 10.33 | 4aa2pajm13day | select count(*) from tb_articl... | |
842,951 | 627 | 1,344.42 | 1.08 | 2.96 | 2.91 | d5vargfkqu6jk | select * from ( select temp.* ... |
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
71 | 18,112 | 0.00 | 0.20 | 7.41 | 8.73 | 1dm5vg7s11jyj | insert into TB_MAP_SERVICE_REC... | |
63 | 10,833 | 0.01 | 0.18 | 13.88 | 18.63 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
9 | 2 | 4.50 | 0.03 | 0.11 | 0.12 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
9 | 1 | 9.00 | 0.03 | 0.27 | 0.32 | d92h3rjp0y217 | begin prvt_hdm.auto_execute( :... | |
4 | 1 | 4.00 | 0.01 | 9.19 | 9.18 | 572fbaj0fdw2b | sqlplus.exe | select output from table(dbms_... |
2 | 13 | 0.15 | 0.01 | 0.00 | 0.02 | 1yyh2fdqqguz8 | INSERT INTO sys.wri$_adv_findi... | |
2 | 86 | 0.02 | 0.01 | 0.02 | 0.05 | 3m8smr0v7v1m6 | INSERT INTO sys.wri$_adv_messa... | |
1 | 53 | 0.02 | 0.00 | 0.01 | 0.01 | 5h7w8ykwtb2xt | INSERT INTO SYS.WRI$_ADV_PARAM... | |
0 | 10 | 0.00 | 0.00 | 0.00 | 0.00 | 04p9rnacfgfsn | INSERT INTO sys.wri$_adv_objec... | |
0 | 201 | 0.00 | 0.00 | 71.33 | 69.84 | 04v68mrc0ndtt | select * from ( select temp.* ... |
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
62,299 | 0 | 0.00 | 0.00 | 0.00 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
59,391 | 2,176 | 0.04 | 0.00 | 0.00 | 0h6b2sajwb74n | select privilege#, level from ... | |
29,054 | 59,391 | 2.04 | 0.00 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
28,653 | 28,653 | 1.00 | 0.00 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
28,653 | 28,653 | 1.00 | 0.00 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
28,366 | 28,366 | 1.00 | 0.00 | 0.00 | 5ur69atw3vfhj | select decode(failover_method,... | |
20,293 | 0 | 0.00 | 0.00 | 0.00 | a4m2hmf2qhtv7 | select tbtestwhit0_.wl_id as w... | |
18,112 | 18,112 | 1.00 | 0.00 | 0.00 | 1dm5vg7s11jyj | insert into TB_MAP_SERVICE_REC... | |
18,112 | 18,112 | 1.00 | 0.00 | 0.00 | d5y11r44hs4cv | select TB_MAP_SERVICE_RECORD_S... | |
12,809 | 0 | 0.00 | 0.00 | 0.00 | chvsc0kcnaygf | select * from ( select t.adver... | |
11,131 | 11,131 | 1.00 | 0.00 | 0.00 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
10,833 | 10,833 | 1.00 | 0.00 | 0.00 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
10,833 | 10,833 | 1.00 | 0.00 | 0.00 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
10,800 | 10,800 | 1.00 | 0.00 | 0.00 | 4aa2pajm13day | select count(*) from tb_articl... | |
10,800 | 75,600 | 7.00 | 0.00 | 0.00 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
10,793 | 68,763 | 6.37 | 0.00 | 0.00 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
10,781 | 0 | 0.00 | 0.00 | 0.00 | fkwdf31hccvwp | select * from ( select t.adver... | |
10,780 | 10,780 | 1.00 | 0.00 | 0.00 | 9w01ztmr4569k | select count(*) from tb_articl... | |
10,779 | 32,337 | 3.00 | 0.00 | 0.00 | 3r189y4actbt2 | select * from ( select temp.* ... | |
10,772 | 10,772 | 1.00 | 0.00 | 0.00 | 6n4k1dy5nbu1y | select decode(t.content_flag, ... | |
10,771 | 0 | 0.00 | 0.00 | 0.00 | 10rj3nwvwud4n | select * from ( select t.adver... | |
9,794 | 287 | 0.03 | 0.00 | 0.00 | 3ccv18hhd0w69 | select this_.COLUMN_ID as COLU... | |
9,358 | 9,349 | 1.00 | 0.00 | 0.00 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
9,349 | 9,349 | 1.00 | 0.00 | 0.00 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
9,103 | 8,446 | 0.93 | 0.00 | 0.00 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
8,129 | 8,129 | 1.00 | 0.00 | 0.00 | apxtnc1vs9dqu | select tdict0_.ID as ID156_, t... | |
6,489 | 0 | 0.00 | 0.00 | 0.00 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
62,300 | 62,299 | 9.65 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
59,391 | 59,391 | 9.20 | 0h6b2sajwb74n | select privilege#, level from ... | |
29,054 | 29,054 | 4.50 | 0k8522rmdzg4k | select privilege# from sysauth... | |
28,653 | 28,653 | 4.44 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
28,653 | 28,653 | 4.44 | 459f3z9u4fb3u | select value$ from props$ wher... | |
28,366 | 28,366 | 4.39 | 5ur69atw3vfhj | select decode(failover_method,... | |
20,293 | 20,293 | 3.14 | a4m2hmf2qhtv7 | select tbtestwhit0_.wl_id as w... | |
18,112 | 18,112 | 2.80 | 1dm5vg7s11jyj | insert into TB_MAP_SERVICE_REC... | |
18,112 | 18,112 | 2.80 | d5y11r44hs4cv | select TB_MAP_SERVICE_RECORD_S... | |
12,809 | 12,809 | 1.98 | chvsc0kcnaygf | select * from ( select t.adver... | |
11,131 | 11,131 | 1.72 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
10,833 | 10,833 | 1.68 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
10,833 | 10,833 | 1.68 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
10,800 | 10,800 | 1.67 | 4aa2pajm13day | select count(*) from tb_articl... | |
10,800 | 10,800 | 1.67 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
10,793 | 10,793 | 1.67 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
10,781 | 10,781 | 1.67 | fkwdf31hccvwp | select * from ( select t.adver... | |
10,780 | 10,780 | 1.67 | 9w01ztmr4569k | select count(*) from tb_articl... | |
10,779 | 10,779 | 1.67 | 3r189y4actbt2 | select * from ( select temp.* ... | |
10,772 | 10,772 | 1.67 | 6n4k1dy5nbu1y | select decode(t.content_flag, ... | |
10,771 | 10,771 | 1.67 | 10rj3nwvwud4n | select * from ( select t.adver... | |
9,794 | 9,794 | 1.52 | 3ccv18hhd0w69 | select this_.COLUMN_ID as COLU... | |
9,358 | 9,358 | 1.45 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
9,349 | 9,349 | 1.45 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
9,103 | 9,103 | 1.41 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
8,129 | 8,129 | 1.26 | apxtnc1vs9dqu | select tdict0_.ID as ID156_, t... | |
6,489 | 6,489 | 1.00 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
21 | 5,198 | 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 |
---|---|---|---|---|---|---|---|
2.05 | 10.98 | 18.63 | 13.88 | 10,833 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
1.57 | 7.98 | 19.73 | 17.90 | 11,131 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
1.17 | 5.34 | 21.95 | 8.35 | 247 | bcz7kcb5nhjfv | insert into tb_user_oper_log (... | |
0.69 | 19.62 | 3.51 | 2.95 | 5,198 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
0.42 | 4.84 | 8.73 | 7.41 | 18,112 | 1dm5vg7s11jyj | insert into TB_MAP_SERVICE_REC... | |
0.23 | 6.91 | 3.39 | 3.25 | 9,103 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
0.16 | 0.18 | 87.35 | 88.64 | 513 | 9j3v93dcqd1ng | select count(*) from (select c... | |
0.13 | 0.86 | 14.93 | 15.15 | 627 | 2ug5va58ks6nc | select count(*) from tb_articl... | |
0.11 | 4.31 | 2.59 | 2.33 | 10,833 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
0.10 | 0.08 | 130.22 | 132.73 | 513 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
0.04 | 0.13 | 32.05 | 32.67 | 84 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
0.04 | 0.41 | 9.18 | 9.19 | 1 | 572fbaj0fdw2b | sqlplus.exe | select output from table(dbms_... |
0.03 | 0.02 | 202.65 | 170.56 | 62,299 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
0.03 | 0.74 | 4.63 | 4.44 | 18,112 | d5y11r44hs4cv | select TB_MAP_SERVICE_RECORD_S... | |
0.03 | 0.32 | 10.33 | 8.96 | 10,800 | 4aa2pajm13day | select count(*) from tb_articl... | |
0.03 | 0.08 | 35.44 | 36.10 | 81 | b6sts095f7490 | select * from ( select temp.* ... | |
0.02 | 0.03 | 73.84 | 75.05 | 3 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.02 | 0.18 | 10.79 | 11.25 | 10,800 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
0.02 | 0.37 | 4.92 | 4.91 | 10,780 | 9w01ztmr4569k | select count(*) from tb_articl... | |
0.02 | 5.07 | 0.32 | 0.27 | 1 | d92h3rjp0y217 | begin prvt_hdm.auto_execute( :... | |
0.02 | 0.03 | 48.76 | 49.86 | 2 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
0.02 | 0.03 | 48.76 | 49.86 | 2 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
0.01 | 0.02 | 70.52 | 72.02 | 3 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.01 | 0.15 | 6.85 | 5.63 | 10,779 | 3r189y4actbt2 | select * from ( select temp.* ... | |
0.01 | 2.63 | 0.36 | 0.35 | 3 | 5f4v2996x0tqf | PL/SQL Developer | select /*+rule*/ * from sys.al... |
0.01 | 26.15 | 0.03 | 0.03 | 2 | 31a13pnjps7j3 | SELECT source, (case when time... | |
0.01 | 4.15 | 0.12 | 0.11 | 2 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
0.01 | 0.17 | 2.91 | 2.96 | 627 | d5vargfkqu6jk | select * from ( select temp.* ... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 213,206 | 24.11 | 4.59 |
CPU used when call started | 209,684 | 23.71 | 4.51 |
CR blocks created | 240 | 0.03 | 0.01 |
Cached Commit SCN referenced | 740,318 | 83.73 | 15.92 |
Commit SCN cached | 27 | 0.00 | 0.00 |
DB time | 4,398,724 | 497.48 | 94.60 |
DBWR checkpoint buffers written | 15,409 | 1.74 | 0.33 |
DBWR checkpoints | 2 | 0.00 | 0.00 |
DBWR fusion writes | 1,617 | 0.18 | 0.03 |
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 | 989 | 0.11 | 0.02 |
DBWR undo block writes | 3,799 | 0.43 | 0.08 |
DFO trees parallelized | 186 | 0.02 | 0.00 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
PX local messages recv'd | 1,003 | 0.11 | 0.02 |
PX local messages sent | 1,003 | 0.11 | 0.02 |
PX remote messages recv'd | 687 | 0.08 | 0.01 |
PX remote messages sent | 1,670 | 0.19 | 0.04 |
Parallel operations not downgraded | 186 | 0.02 | 0.00 |
RowCR - row contention | 0 | 0.00 | 0.00 |
RowCR attempts | 557 | 0.06 | 0.01 |
RowCR hits | 557 | 0.06 | 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 | 4 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 1,293,603 | 146.30 | 27.82 |
SQL*Net roundtrips to/from dblink | 900 | 0.10 | 0.02 |
active txn count during cleanout | 6,403 | 0.72 | 0.14 |
application wait time | 294 | 0.03 | 0.01 |
background checkpoints completed | 2 | 0.00 | 0.00 |
background checkpoints started | 2 | 0.00 | 0.00 |
background timeouts | 43,076 | 4.87 | 0.93 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 17,304,158 | 1,957.03 | 372.13 |
buffer is pinned count | 39,656,808 | 4,485.02 | 852.83 |
bytes received via SQL*Net from client | 240,822,072 | 27,236.00 | 5,178.97 |
bytes received via SQL*Net from dblink | 310,206 | 35.08 | 6.67 |
bytes sent via SQL*Net to client | 556,843,829 | 62,976.78 | 11,975.14 |
bytes sent via SQL*Net to dblink | 275,803 | 31.19 | 5.93 |
calls to get snapshot scn: kcmgss | 2,712,013 | 306.72 | 58.32 |
calls to kcmgas | 83,317 | 9.42 | 1.79 |
calls to kcmgcs | 2,893 | 0.33 | 0.06 |
change write time | 737 | 0.08 | 0.02 |
cleanout - number of ktugct calls | 3,681 | 0.42 | 0.08 |
cleanouts and rollbacks - consistent read gets | 123 | 0.01 | 0.00 |
cleanouts only - consistent read gets | 82 | 0.01 | 0.00 |
cluster key scan block gets | 108,641 | 12.29 | 2.34 |
cluster key scans | 87,492 | 9.89 | 1.88 |
cluster wait time | 1,047 | 0.12 | 0.02 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 31 | 0.00 | 0.00 |
commit batch/immediate requested | 31 | 0.00 | 0.00 |
commit cleanout failures: block lost | 9 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 22 | 0.00 | 0.00 |
commit cleanout failures: cannot pin | 123 | 0.01 | 0.00 |
commit cleanouts | 123,814 | 14.00 | 2.66 |
commit cleanouts successfully completed | 123,660 | 13.99 | 2.66 |
commit immediate performed | 31 | 0.00 | 0.00 |
commit immediate requested | 31 | 0.00 | 0.00 |
commit txn count during cleanout | 16,077 | 1.82 | 0.35 |
concurrency wait time | 9,780 | 1.11 | 0.21 |
consistent changes | 198,070 | 22.40 | 4.26 |
consistent gets | 76,674,960 | 8,671.63 | 1,648.92 |
consistent gets - examination | 29,184,614 | 3,300.66 | 627.63 |
consistent gets direct | 35,476 | 4.01 | 0.76 |
consistent gets from cache | 76,639,484 | 8,667.61 | 1,648.16 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 3,118 | 0.35 | 0.07 |
data blocks consistent reads - undo records applied | 251 | 0.03 | 0.01 |
db block changes | 597,002 | 67.52 | 12.84 |
db block gets | 1,087,228 | 122.96 | 23.38 |
db block gets direct | 37 | 0.00 | 0.00 |
db block gets from cache | 1,087,191 | 122.96 | 23.38 |
deferred (CURRENT) block cleanout applications | 51,179 | 5.79 | 1.10 |
dirty buffers inspected | 0 | 0.00 | 0.00 |
enqueue conversions | 2,913 | 0.33 | 0.06 |
enqueue releases | 262,035 | 29.64 | 5.64 |
enqueue requests | 262,067 | 29.64 | 5.64 |
enqueue timeouts | 32 | 0.00 | 0.00 |
enqueue waits | 4,293 | 0.49 | 0.09 |
exchange deadlocks | 16 | 0.00 | 0.00 |
execute count | 628,927 | 71.13 | 13.53 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
free buffer inspected | 14,955 | 1.69 | 0.32 |
free buffer requested | 63,498 | 7.18 | 1.37 |
gc CPU used by this session | 4,737 | 0.54 | 0.10 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 71 | 0.01 | 0.00 |
gc cr block flush time | 28 | 0.00 | 0.00 |
gc cr block receive time | 185 | 0.02 | 0.00 |
gc cr block send time | 34 | 0.00 | 0.00 |
gc cr blocks received | 5,019 | 0.57 | 0.11 |
gc cr blocks served | 7,026 | 0.79 | 0.15 |
gc current block flush time | 32 | 0.00 | 0.00 |
gc current block pin time | 140 | 0.02 | 0.00 |
gc current block receive time | 306 | 0.03 | 0.01 |
gc current block send time | 680 | 0.08 | 0.01 |
gc current blocks received | 7,305 | 0.83 | 0.16 |
gc current blocks served | 12,925 | 1.46 | 0.28 |
gc local grants | 2,957 | 0.33 | 0.06 |
gc remote grants | 2,292 | 0.26 | 0.05 |
gcs messages sent | 111,749 | 12.64 | 2.40 |
ges messages sent | 31,512 | 3.56 | 0.68 |
global enqueue get time | 104,785 | 11.85 | 2.25 |
global enqueue gets async | 7,130 | 0.81 | 0.15 |
global enqueue gets sync | 185,885 | 21.02 | 4.00 |
global enqueue releases | 179,528 | 20.30 | 3.86 |
heap block compress | 141 | 0.02 | 0.00 |
hot buffers moved to head of LRU | 6,628 | 0.75 | 0.14 |
immediate (CR) block cleanout applications | 205 | 0.02 | 0.00 |
immediate (CURRENT) block cleanout applications | 1,763 | 0.20 | 0.04 |
index crx upgrade (found) | 60 | 0.01 | 0.00 |
index crx upgrade (positioned) | 12,939 | 1.46 | 0.28 |
index fast full scans (full) | 104 | 0.01 | 0.00 |
index fetch by key | 18,115,455 | 2,048.78 | 389.58 |
index scans kdiixs1 | 527,663 | 59.68 | 11.35 |
leaf node 90-10 splits | 353 | 0.04 | 0.01 |
leaf node splits | 448 | 0.05 | 0.01 |
lob reads | 84,582 | 9.57 | 1.82 |
lob writes | 72,072 | 8.15 | 1.55 |
lob writes unaligned | 72,072 | 8.15 | 1.55 |
logons cumulative | 30,230 | 3.42 | 0.65 |
messages received | 121,257 | 13.71 | 2.61 |
messages sent | 121,257 | 13.71 | 2.61 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 45,604,116 | 5,157.64 | 980.73 |
opened cursors cumulative | 647,826 | 73.27 | 13.93 |
parse count (failures) | 115 | 0.01 | 0.00 |
parse count (hard) | 7,097 | 0.80 | 0.15 |
parse count (total) | 645,828 | 73.04 | 13.89 |
parse time cpu | 11,990 | 1.36 | 0.26 |
parse time elapsed | 14,915 | 1.69 | 0.32 |
physical read IO requests | 29,852 | 3.38 | 0.64 |
physical read bytes | 294,215,680 | 33,274.60 | 6,327.22 |
physical read total IO requests | 178,861 | 20.23 | 3.85 |
physical read total bytes | 2,757,059,584 | 311,812.26 | 59,291.60 |
physical read total multi block requests | 3,132 | 0.35 | 0.07 |
physical reads | 35,915 | 4.06 | 0.77 |
physical reads cache | 295 | 0.03 | 0.01 |
physical reads cache prefetch | 0 | 0.00 | 0.00 |
physical reads direct | 35,620 | 4.03 | 0.77 |
physical reads direct (lob) | 35,466 | 4.01 | 0.76 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 10,067 | 1.14 | 0.22 |
physical write bytes | 136,650,752 | 15,454.65 | 2,938.73 |
physical write total IO requests | 114,880 | 12.99 | 2.47 |
physical write total bytes | 557,284,352 | 63,026.60 | 11,984.61 |
physical write total multi block requests | 98,664 | 11.16 | 2.12 |
physical writes | 16,681 | 1.89 | 0.36 |
physical writes direct | 149 | 0.02 | 0.00 |
physical writes direct (lob) | 15 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 16,532 | 1.87 | 0.36 |
physical writes non checkpoint | 7,384 | 0.84 | 0.16 |
pinned buffers inspected | 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 | 8,842 | 1.00 | 0.19 |
queries parallelized | 186 | 0.02 | 0.00 |
recovery blocks read | 0 | 0.00 | 0.00 |
recursive calls | 2,017,457 | 228.17 | 43.39 |
recursive cpu usage | 24,795 | 2.80 | 0.53 |
redo blocks read for recovery | 0 | 0.00 | 0.00 |
redo blocks written | 198,187 | 22.41 | 4.26 |
redo buffer allocation retries | 4 | 0.00 | 0.00 |
redo entries | 222,651 | 25.18 | 4.79 |
redo log space requests | 4 | 0.00 | 0.00 |
redo log space wait time | 9 | 0.00 | 0.00 |
redo ordering marks | 2,839 | 0.32 | 0.06 |
redo size | 87,420,688 | 9,886.93 | 1,880.01 |
redo subscn max counts | 2,647 | 0.30 | 0.06 |
redo synch time | 5,116 | 0.58 | 0.11 |
redo synch writes | 45,909 | 5.19 | 0.99 |
redo wastage | 10,615,408 | 1,200.56 | 228.29 |
redo write broadcast ack time | 1,448 | 0.16 | 0.03 |
redo write time | 2,761 | 0.31 | 0.06 |
redo writer latching time | 0 | 0.00 | 0.00 |
redo writes | 49,152 | 5.56 | 1.06 |
rollback changes - undo records applied | 70 | 0.01 | 0.00 |
rollbacks only - consistent read gets | 107 | 0.01 | 0.00 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 7,573,436 | 856.52 | 162.87 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 384,022 | 43.43 | 8.26 |
session logical reads | 77,762,188 | 8,794.59 | 1,672.31 |
shared hash latch upgrades - no wait | 43,477 | 4.92 | 0.93 |
shared hash latch upgrades - wait | 60 | 0.01 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 366,836 | 41.49 | 7.89 |
sorts (rows) | 9,820,132 | 1,110.62 | 211.19 |
sql area evicted | 4,816 | 0.54 | 0.10 |
sql area purged | 115 | 0.01 | 0.00 |
summed dirty queue length | 0 | 0.00 | 0.00 |
switch current to new buffer | 188 | 0.02 | 0.00 |
table fetch by rowid | 14,461,592 | 1,635.55 | 311.00 |
table fetch continued row | 32,039 | 3.62 | 0.69 |
table scan blocks gotten | 40,180,317 | 4,544.23 | 864.09 |
table scan rows gotten | 6,040,806,951 | 683,190.77 | 129,909.83 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (short tables) | 659,814 | 74.62 | 14.19 |
total number of times SMON posted | 1,806 | 0.20 | 0.04 |
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 | 31 | 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 | 18,723,692 | 2,117.57 | 402.66 |
user I/O wait time | 1,465 | 0.17 | 0.03 |
user calls | 1,795,412 | 203.05 | 38.61 |
user commits | 45,337 | 5.13 | 0.97 |
user rollbacks | 1,163 | 0.13 | 0.03 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 170,842 | 19.32 | 3.67 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 1.3E+12 | 1.3E+12 |
session cursor cache count | 240,337,894 | 240,559,541 |
session uga memory | 8.6E+14 | 8.7E+14 |
opened cursors current | 658 | 558 |
workarea memory allocated | 265 | 265 |
logons current | 1,206 | 1,145 |
session uga memory max | 1.8E+13 | 1.8E+13 |
session pga memory | 7.9E+11 | 7.9E+11 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 2 | 0.81 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
USERS | 28,415 | 3 | 0.00 | 1.21 | 2 | 0 | 0 | 0.00 |
WCITY2_DATA | 1,141 | 0 | 0.72 | 1.00 | 5,307 | 1 | 30 | 2.33 |
UNDOTBS2 | 2 | 0 | 0.00 | 1.00 | 2,201 | 0 | 10 | 1.00 |
SYSAUX | 41 | 0 | 4.63 | 1.00 | 998 | 0 | 0 | 0.00 |
WCITY2_INDEX | 86 | 0 | 15.47 | 1.00 | 895 | 0 | 40 | 2.25 |
TS_APP_DATA | 73 | 0 | 5.48 | 1.00 | 232 | 0 | 138 | 0.51 |
SYSTEM | 5 | 0 | 2.00 | 1.00 | 293 | 0 | 22 | 4.09 |
WCITY | 50 | 0 | 0.00 | 1.00 | 42 | 0 | 0 | 0.00 |
WCITY_GNMS | 6 | 0 | 0.00 | 1.00 | 67 | 0 | 8 | 11.25 |
TBS_ITS | 4 | 0 | 0.00 | 1.00 | 4 | 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 |
TS_APP_INDEX | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
UNDOTBS1 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 1 | 10.00 |
WCITY_BC | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 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 | 41 | 0 | 4.63 | 1.00 | 998 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.1634.787070407 | 2 | 0 | 0.00 | 1.00 | 60 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.256.762113905 | 3 | 0 | 3.33 | 1.00 | 233 | 0 | 22 | 4.09 |
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 | 73 | 0 | 5.48 | 1.00 | 232 | 0 | 138 | 0.51 |
TS_APP_INDEX | +DATA/acsdb/datafile/ts_app_index01.dbf | 2 | 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 | 1 | 10.00 |
UNDOTBS2 | +DATA/acsdb/datafile/undotbs2.269.762113985 | 2 | 0 | 0.00 | 1.00 | 2,201 | 0 | 10 | 1.00 |
USERS | +DATA/acsdb/datafile/users.259.762113905 | 28,415 | 3 | 0.00 | 1.21 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1031.787073439 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1146.787070545 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1297.787074783 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.2249.787070711 | 2 | 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 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3189.787070649 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3202.787070683 | 2 | 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 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4594.787070635 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4822.787075205 | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5264.787070521 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5495.787070583 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5810.787070597 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.6430.787070489 | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity1.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity2.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity3.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity4.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity5.dbf | 4 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data01.dbf | 174 | 0 | 0.06 | 1.00 | 207 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data02.dbf | 152 | 0 | 0.39 | 1.00 | 198 | 0 | 4 | 17.50 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data03.dbf | 187 | 0 | 0.16 | 1.00 | 398 | 0 | 5 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data04.dbf | 362 | 0 | 0.33 | 1.00 | 24 | 0 | 1 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data05.dbf | 85 | 0 | 0.35 | 1.00 | 74 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data06.dbf | 95 | 0 | 2.11 | 1.00 | 1,234 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data07.dbf | 25 | 0 | 0.80 | 1.00 | 2,355 | 0 | 10 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data08.dbf | 18 | 0 | 3.33 | 1.00 | 371 | 0 | 4 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data09.dbf | 43 | 0 | 6.74 | 1.00 | 446 | 0 | 6 | 0.00 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index01.dbf | 42 | 0 | 23.81 | 1.00 | 439 | 0 | 17 | 1.18 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index02.dbf | 44 | 0 | 7.50 | 1.00 | 456 | 0 | 23 | 3.04 |
WCITY_BC | +DATA/acsdb/datafile/wcity_bc01.dbf | 2 | 0 | 0.00 | 1.00 | 2 | 0 | 0 | 0.00 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms01.dbf | 2 | 0 | 0.00 | 1.00 | 58 | 0 | 8 | 11.25 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms02.dbf | 4 | 0 | 0.00 | 1.00 | 9 | 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 | 77,726,105 | 295 | 16,532 | 0 | 0 | 249 |
Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual Redo Blks | Target Redo Blks | Log File Size Redo Blks | Log Ckpt Timeout Redo Blks | Log Ckpt Interval Redo Blks | |
---|---|---|---|---|---|---|---|---|
B | 0 | 1 | 610 | 6349 | 29590 | 184320 | 29590 | |
E | 0 | 1 | 818 | 10055 | 45958 | 184320 | 45958 |
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,928 | 0.10 | 350,811 | 41.41 | 1,223,599,611 |
D | 5,856 | 0.20 | 701,622 | 1.52 | 44,789,582 |
D | 8,784 | 0.30 | 1,052,433 | 1.19 | 35,259,648 |
D | 11,712 | 0.40 | 1,403,244 | 1.12 | 33,111,152 |
D | 14,640 | 0.50 | 1,754,055 | 1.07 | 31,531,023 |
D | 17,568 | 0.60 | 2,104,866 | 1.05 | 30,952,244 |
D | 20,496 | 0.70 | 2,455,677 | 1.04 | 30,791,945 |
D | 23,424 | 0.80 | 2,806,488 | 1.03 | 30,522,686 |
D | 26,352 | 0.90 | 3,157,299 | 1.02 | 30,148,504 |
D | 29,280 | 1.00 | 3,508,110 | 1.00 | 29,564,100 |
D | 29,328 | 1.00 | 3,513,861 | 1.00 | 29,547,463 |
D | 32,208 | 1.10 | 3,858,921 | 0.97 | 28,625,673 |
D | 35,136 | 1.20 | 4,209,732 | 0.96 | 28,380,587 |
D | 38,064 | 1.30 | 4,560,543 | 0.95 | 28,138,056 |
D | 40,992 | 1.40 | 4,911,354 | 0.95 | 28,039,315 |
D | 43,920 | 1.50 | 5,262,165 | 0.94 | 27,773,352 |
D | 46,848 | 1.60 | 5,612,976 | 0.93 | 27,461,094 |
D | 49,776 | 1.70 | 5,963,787 | 0.92 | 27,144,027 |
D | 52,704 | 1.80 | 6,314,598 | 0.84 | 24,699,352 |
D | 55,632 | 1.90 | 6,665,409 | 0.82 | 24,237,185 |
D | 58,560 | 2.00 | 7,016,220 | 0.81 | 23,885,104 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 15,055 | 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,602 | 961.54 | 0.00 | 0.00 | 0.00 | 0.00 | 823,700 |
E | 8,044 | 6,628 | 928.74 | 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 | 157,384 | 157,384 | 0 | 0 |
64K | 128K | 530 | 530 | 0 | 0 |
128K | 256K | 312 | 312 | 0 | 0 |
256K | 512K | 166 | 166 | 0 | 0 |
512K | 1024K | 3,175 | 3,175 | 0 | 0 |
1M | 2M | 9,123 | 9,123 | 0 | 0 |
2M | 4M | 120 | 120 | 0 | 0 |
4M | 8M | 22 | 22 | 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 | 3,659,101.40 | 3,545.07 | 100.00 | 0 |
2,011 | 0.25 | 3,659,101.40 | 3,275.75 | 100.00 | 0 |
4,022 | 0.50 | 3,659,101.40 | 2,193.08 | 100.00 | 0 |
6,033 | 0.75 | 3,659,101.40 | 2,193.08 | 100.00 | 0 |
8,044 | 1.00 | 3,659,101.40 | 1,344.74 | 100.00 | 0 |
9,653 | 1.20 | 3,659,101.40 | 0.00 | 100.00 | 0 |
11,262 | 1.40 | 3,659,101.40 | 0.00 | 100.00 | 0 |
12,870 | 1.60 | 3,659,101.40 | 0.00 | 100.00 | 0 |
14,479 | 1.80 | 3,659,101.40 | 0.00 | 100.00 | 0 |
16,088 | 2.00 | 3,659,101.40 | 0.00 | 100.00 | 0 |
24,132 | 3.00 | 3,659,101.40 | 0.00 | 100.00 | 0 |
32,176 | 4.00 | 3,659,101.40 | 0.00 | 100.00 | 0 |
48,264 | 6.00 | 3,659,101.40 | 0.00 | 100.00 | 0 |
64,352 | 8.00 | 3,659,101.40 | 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 | 396 | 30,604 | 16,480,985 | 1.00 | 86,875 | 1.08 | 738,814 |
2,352 | 0.70 | 721 | 48,142 | 16,485,647 | 1.00 | 82,213 | 1.02 | 739,255 |
2,688 | 0.80 | 1,054 | 63,883 | 16,486,822 | 1.00 | 81,038 | 1.01 | 739,422 |
3,024 | 0.90 | 1,388 | 81,413 | 16,487,315 | 1.00 | 80,545 | 1.00 | 739,507 |
3,360 | 1.00 | 1,723 | 99,873 | 16,487,604 | 1.00 | 80,256 | 1.00 | 739,566 |
3,696 | 1.10 | 2,058 | 119,383 | 16,487,807 | 1.00 | 80,053 | 1.00 | 739,613 |
4,032 | 1.20 | 2,392 | 136,688 | 16,487,980 | 1.00 | 79,880 | 1.00 | 739,652 |
4,368 | 1.30 | 2,727 | 154,278 | 16,488,119 | 1.00 | 79,741 | 0.99 | 739,686 |
4,704 | 1.40 | 3,062 | 170,974 | 16,488,239 | 1.00 | 79,621 | 0.99 | 739,717 |
5,040 | 1.50 | 3,397 | 186,216 | 16,488,351 | 1.00 | 79,509 | 0.99 | 739,745 |
5,376 | 1.60 | 3,732 | 203,005 | 16,488,445 | 1.00 | 79,415 | 0.99 | 739,769 |
5,712 | 1.70 | 4,067 | 220,846 | 16,488,538 | 1.00 | 79,322 | 0.99 | 739,792 |
6,048 | 1.80 | 4,402 | 238,199 | 16,488,618 | 1.00 | 79,242 | 0.99 | 739,812 |
6,384 | 1.90 | 4,737 | 256,279 | 16,488,687 | 1.00 | 79,173 | 0.99 | 739,830 |
6,720 | 2.00 | 5,072 | 273,425 | 16,488,749 | 1.00 | 79,111 | 0.99 | 739,847 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
8,192 | 0.25 | 5,591,136 | 44,790,981 |
16,384 | 0.50 | 5,552,879 | 31,530,085 |
24,576 | 0.75 | 5,547,889 | 30,950,955 |
32,768 | 1.00 | 5,544,562 | 29,547,451 |
40,960 | 1.25 | 5,540,681 | 28,138,038 |
49,152 | 1.50 | 5,539,017 | 27,461,401 |
57,344 | 1.75 | 5,537,909 | 24,698,714 |
65,536 | 2.00 | 5,537,909 | 23,886,159 |
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 | 219 | 0 | 2 |
undo header | 11 | 0 | 2 |
1st level bmb | 12 | 0 | 0 |
2nd level bmb | 4 | 0 | 0 |
segment header | 3 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
WF-AWR Flush | 72 | 42 | 30 | 51 | 5,447 | 106,797.06 |
TX-Transaction (index contention) | 58 | 57 | 0 | 44 | 3 | 58.86 |
TX-Transaction | 52,204 | 52,204 | 0 | 6 | 2 | 335.00 |
HW-Segment High Water Mark | 5,851 | 5,851 | 0 | 3,057 | 2 | 0.57 |
PS-PX Process Reservation | 1,320 | 1,320 | 0 | 449 | 1 | 2.25 |
TM-DML | 54,536 | 54,536 | 0 | 444 | 0 | 0.97 |
FB-Format Block | 158 | 158 | 0 | 75 | 0 | 0.80 |
CF-Controlfile Transaction | 20,678 | 20,678 | 0 | 38 | 0 | 1.58 |
TD-KTF map table enqueue (KTF dump entries) | 29 | 29 | 0 | 29 | 0 | 1.03 |
SQ-Sequence Cache | 5,229 | 5,229 | 0 | 5 | 0 | 6.00 |
TA-Instance Undo | 58 | 58 | 0 | 58 | 0 | 0.34 |
JQ-Job Queue | 283 | 283 | 0 | 13 | 0 | 0.00 |
JS-Job Scheduler (job run lock - synchronize) | 5 | 5 | 0 | 5 | 0 | 0.00 |
TX-Transaction (allocate ITL entry) | 5 | 5 | 0 | 5 | 0 | 0.00 |
DR-Distributed Recovery | 4 | 4 | 0 | 4 | 0 | 0.00 |
PI-Remote PX Process Spawn Status | 2 | 2 | 0 | 2 | 0 | 0.00 |
PW-Buffer Cache PreWarm (flush prewarm buffers) | 2 | 0 | 2 | 2 | 0 | 0.00 |
TT-Tablespace | 478 | 478 | 0 | 2 | 0 | 0.00 |
TX-Transaction (row lock contention) | 2 | 2 | 0 | 2 | 0 | 0.00 |
AF-Advisor Framework (task serialization) | 14 | 14 | 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 | 2.69 | 49,410 | 1,849 | 4 | 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 |
---|---|---|---|---|---|---|---|
14-3ÔÂ 17:19 | 88 | 1,934 | 108 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 17:09 | 270 | 6,232 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:59 | 89 | 1,699 | 694 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:49 | 124 | 1,702 | 405 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:39 | 155 | 2,451 | 1,058 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:29 | 231 | 3,885 | 774 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:19 | 310 | 6,460 | 642 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 16:09 | 238 | 3,685 | 774 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:59 | 381 | 8,654 | 1,849 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:49 | 105 | 1,896 | 1,246 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:39 | 128 | 2,428 | 644 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:29 | 150 | 2,598 | 990 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:19 | 142 | 2,373 | 389 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
14-3ÔÂ 15:09 | 275 | 3,413 | 265 | 4 | 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 | 154 | 0.00 | 0 | 0 | ||
ASM db client latch | 6,167 | 0.00 | 0 | 0 | ||
ASM map headers | 311 | 0.00 | 0 | 0 | ||
ASM map load waiting list | 93 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 4,382 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 862,172 | 0.00 | 0.00 | 0 | 0 | |
ASM network background latch | 3,907 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 145,023 | 0.00 | 0 | 0 | ||
Consistent RBA | 49,151 | 0.00 | 0 | 0 | ||
FAL request queue | 180 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 180 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 40 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 30,914 | 0.02 | 0.00 | 0 | 0 | |
JS broadcast add buf latch | 2,023 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 2,023 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 1,765 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 14 | 0.00 | 0 | 0 | ||
JS queue access latch | 14 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 63,842 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 124,678 | 0.02 | 0.12 | 0 | 769 | 0.00 |
KFK SGA context latch | 5,987 | 0.00 | 0 | 0 | ||
KFMD SGA | 3,318 | 0.00 | 0 | 0 | ||
KJC message pool free list | 75,002 | 0.06 | 0.00 | 0 | 3,330 | 0.06 |
KJCT flow control latch | 265,814 | 0.05 | 0.03 | 0 | 0 | |
KMG MMAN ready and startup request latch | 2,946 | 0.00 | 0 | 0 | ||
KTF sga latch | 9,274 | 0.00 | 0 | 2,644 | 0.00 | |
KWQMN job cache list latch | 2,179 | 0.18 | 0.50 | 0 | 0 | |
KWQP Prop Status | 4 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 176 | 0.00 | ||
Memory Management Latch | 0 | 0 | 2,946 | 0.00 | ||
OS process | 90,465 | 0.00 | 0 | 0 | ||
OS process allocation | 63,188 | 0.09 | 0.04 | 1 | 0 | |
OS process: request allocation | 59,459 | 0.15 | 0.12 | 4 | 0 | |
PL/SQL warning settings | 31,474 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 233 | 0.00 | 0 | 233 | 0.00 | |
SQL memory manager latch | 2 | 0.00 | 0 | 2,943 | 0.00 | |
SQL memory manager workarea list latch | 280,291 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 318 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 22,750 | 0.00 | 0.00 | 0 | 0 | |
active service list | 169,792 | 0.65 | 0.11 | 0 | 9,581 | 0.01 |
alert log latch | 4 | 0.00 | 0 | 0 | ||
archive control | 323 | 0.00 | 0 | 0 | ||
archive process latch | 3,307 | 0.00 | 0 | 0 | ||
begin backup scn array | 16 | 0.00 | 0 | 0 | ||
business card | 372 | 0.00 | 0 | 0 | ||
cache buffer handles | 3,840 | 0.03 | 0.00 | 0 | 0 | |
cache buffers chains | 127,631,643 | 0.15 | 0.02 | 34 | 72,594 | 0.01 |
cache buffers lru chain | 95,637 | 0.00 | 0 | 107,954 | 0.00 | |
channel handle pool latch | 59,506 | 0.01 | 0.00 | 0 | 0 | |
channel operations parent latch | 791,955 | 0.02 | 0.03 | 0 | 0 | |
checkpoint queue latch | 1,096,202 | 0.00 | 0.00 | 0 | 21,256 | 0.00 |
client/application info | 156,892 | 0.00 | 0 | 0 | ||
commit callback allocation | 254 | 0.00 | 0 | 0 | ||
compile environment latch | 30,234 | 0.00 | 0 | 0 | ||
dml lock allocation | 109,456 | 0.02 | 0.00 | 0 | 0 | |
dummy allocation | 60,529 | 0.08 | 0.18 | 2 | 0 | |
enqueue hash chains | 657,049 | 0.02 | 0.01 | 0 | 5,980 | 0.00 |
enqueues | 704,876 | 0.01 | 0.04 | 0 | 0 | |
error message lists | 900 | 0.00 | 0 | 0 | ||
event group latch | 29,696 | 0.00 | 0 | 0 | ||
file cache latch | 2,724 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 19,454 | 0.00 | 0 | 0 | ||
gcs partitioned table hash | 145,272 | 0.00 | 0 | 1,710 | 0.00 | |
gcs remastering latch | 1,461 | 0.00 | 0 | 0 | ||
gcs resource freelist | 3,772 | 0.00 | 0 | 2,046 | 0.00 | |
gcs resource hash | 110,249 | 0.07 | 0.00 | 0 | 14 | 0.00 |
gcs resource scan list | 28 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 2,765 | 0.00 | 0 | 3,947 | 0.00 | |
ges caches resource lists | 71,516 | 0.00 | 0.00 | 0 | 105,186 | 0.00 |
ges deadlock list | 308 | 0.00 | 0 | 1 | 0.00 | |
ges domain table | 205,824 | 0.00 | 0 | 0 | ||
ges enqueue table freelist | 371,657 | 0.00 | 0.50 | 0 | 0 | |
ges group table | 294,553 | 0.00 | 0.00 | 0 | 0 | |
ges process hash list | 123,665 | 0.00 | 0 | 0 | ||
ges process parent latch | 718,310 | 0.00 | 0 | 1 | 0.00 | |
ges process table freelist | 59,459 | 0.04 | 0.00 | 0 | 0 | |
ges resource hash list | 541,943 | 0.11 | 0.04 | 0 | 9,525 | 0.41 |
ges resource scan list | 2,970 | 0.00 | 0 | 0 | ||
ges resource table freelist | 7,516 | 0.00 | 0 | 0 | ||
ges timeout list | 4,046 | 0.00 | 0 | 5,140 | 0.00 | |
global KZLD latch for mem in SGA | 29,212 | 0.00 | 0 | 0 | ||
global tx hash mapping | 366 | 0.00 | 0 | 0 | ||
hash table column usage latch | 647 | 0.00 | 0 | 457,120 | 0.00 | |
hash table modification latch | 188 | 0.00 | 0 | 0 | ||
internal temp table object number allocation latc | 20 | 0.00 | 0 | 0 | ||
interrupt manipulation | 1,864 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 576 | 0.00 | ||
job_queue_processes parameter latch | 426 | 0.00 | 0 | 0 | ||
kks stats | 34,425 | 0.00 | 0 | 0 | ||
kmcptab latch | 1 | 0.00 | 0 | 0 | ||
kmcpvec latch | 0 | 0 | 1 | 0.00 | ||
kokc descriptor allocation latch | 9,360 | 0.00 | 0 | 0 | ||
ksuosstats global area | 594 | 0.00 | 0 | 0 | ||
ksv instance | 2 | 0.00 | 0 | 0 | ||
ktm global data | 1,814 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 316 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 49,311 | 0.00 | 0.00 | 0 | 0 | |
library cache | 2,412,429 | 0.15 | 0.01 | 5 | 16,264 | 0.02 |
library cache load lock | 568 | 0.00 | 0 | 0 | ||
library cache lock | 3,449,003 | 0.49 | 0.01 | 41 | 0 | |
library cache lock allocation | 85,298 | 0.01 | 0.00 | 0 | 0 | |
library cache pin | 664,338 | 0.02 | 0.00 | 0 | 0 | |
library cache pin allocation | 872 | 0.00 | 0 | 0 | ||
list of block allocation | 5,566 | 0.00 | 0 | 0 | ||
loader state object freelist | 14,838 | 0.00 | 0 | 0 | ||
logminer context allocation | 2 | 0.00 | 0 | 0 | ||
message pool operations parent latch | 2,914 | 0.00 | 0 | 0 | ||
messages | 691,717 | 0.03 | 0.01 | 0 | 0 | |
mostly latch-free SCN | 49,677 | 0.16 | 0.00 | 0 | 0 | |
msg queue | 57 | 0.00 | 0 | 57 | 0.00 | |
multiblock read objects | 4,280 | 0.00 | 0 | 0 | ||
name-service memory objects | 33,364 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 90,974 | 0.00 | 0 | 0 | ||
name-service pending queue | 19,560 | 0.00 | 0 | 0 | ||
name-service request | 20 | 0.00 | 0 | 0 | ||
name-service request queue | 111,263 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 380 | 0.00 | 0 | 0 | ||
object queue header heap | 66,084 | 0.00 | 0 | 600 | 0.00 | |
object queue header operation | 250,387 | 0.00 | 0.25 | 0 | 0 | |
object stats modification | 2 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 5,254 | 0.00 | 0 | 0 | ||
parallel query stats | 803 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 39,102 | 0.00 | 0 | 0 | ||
parameter list | 263,648 | 0.04 | 0.00 | 0 | 0 | |
parameter table management | 60,652 | 0.00 | 0 | 0 | ||
post/wait queue | 116,252 | 0.06 | 0.00 | 0 | 47,064 | 0.00 |
process allocation | 132,182 | 1.03 | 2.43 | 36 | 29,621 | 0.25 |
process group creation | 59,458 | 0.04 | 0.00 | 0 | 0 | |
process queue | 2,154 | 0.00 | 0 | 0 | ||
process queue reference | 42,981 | 0.01 | 0.00 | 0 | 4,381 | 0.02 |
qmn task queue latch | 2,533 | 20.69 | 0.01 | 0 | 0 | |
query server freelists | 1,768 | 0.00 | 0 | 0 | ||
query server process | 2 | 0.00 | 0 | 4 | 0.00 | |
queued dump request | 44,171 | 0.00 | 0 | 0 | ||
redo allocation | 147,978 | 0.04 | 0.00 | 0 | 222,614 | 0.08 |
redo copy | 0 | 0 | 222,697 | 0.09 | ||
redo writing | 176,506 | 0.00 | 0.00 | 0 | 0 | |
resmgr group change latch | 30,872 | 0.00 | 0 | 0 | ||
resmgr:active threads | 60,439 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 30,033 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 60,437 | 0.35 | 0.05 | 6 | 0 | |
resmgr:resource group CPU method | 30,085 | 0.01 | 0.00 | 0 | 0 | |
resmgr:schema config | 2 | 0.00 | 0 | 0 | ||
row cache objects | 4,365,350 | 0.08 | 0.01 | 0 | 500 | 0.00 |
rules engine aggregate statistics | 5 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 210 | 0.00 | 0 | 0 | ||
segmented array pool | 36 | 0.00 | 0 | 0 | ||
sequence cache | 493,801 | 0.09 | 0.00 | 0 | 0 | |
session allocation | 991,863 | 1.00 | 0.07 | 13 | 0 | |
session idle bit | 4,025,806 | 0.00 | 0.03 | 0 | 0 | |
session state list latch | 60,501 | 0.03 | 0.00 | 0 | 0 | |
session switching | 149,190 | 0.06 | 0.05 | 0 | 0 | |
session timer | 7,985 | 0.00 | 0 | 0 | ||
shared pool | 1,191,039 | 0.41 | 0.02 | 3 | 0 | |
shared pool simulator | 43,596 | 0.00 | 0 | 0 | ||
simulator hash latch | 4,383,584 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 0 | 0 | 4,382,972 | 0.13 | ||
slave class | 242 | 0.00 | 0 | 0 | ||
slave class create | 1,717 | 0.12 | 1.00 | 0 | 0 | |
sort extent pool | 2,284 | 0.00 | 0 | 0 | ||
state object free list | 4 | 0.00 | 0 | 0 | ||
statistics aggregation | 1,344 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 2 | 0.00 | 0 | 0 | ||
threshold alerts latch | 1,622 | 0.00 | 0 | 0 | ||
transaction allocation | 1,327,656 | 0.00 | 0 | 0 | ||
transaction branch allocation | 8,240 | 0.00 | 0 | 0 | ||
undo global data | 247,474 | 0.00 | 0.00 | 0 | 0 | |
user lock | 117,694 | 1.90 | 0.01 | 0 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
cache buffers chains | 127,631,643 | 194,716 | 3,217 | 191,664 | 0 | 0 | 0 |
library cache lock | 3,449,003 | 16,845 | 154 | 16,721 | 0 | 0 | 0 |
session allocation | 991,863 | 9,886 | 714 | 9,217 | 0 | 0 | 0 |
shared pool | 1,191,039 | 4,931 | 83 | 4,862 | 0 | 0 | 0 |
library cache | 2,412,429 | 3,591 | 44 | 3,553 | 0 | 0 | 0 |
row cache objects | 4,365,350 | 3,456 | 20 | 3,440 | 0 | 0 | 0 |
user lock | 117,694 | 2,236 | 20 | 2,218 | 0 | 0 | 0 |
process allocation | 132,182 | 1,368 | 3,320 | 143 | 0 | 0 | 0 |
active service list | 169,792 | 1,112 | 118 | 999 | 0 | 0 | 0 |
ges resource hash list | 541,943 | 622 | 27 | 595 | 0 | 0 | 0 |
qmn task queue latch | 2,533 | 524 | 3 | 521 | 0 | 0 | 0 |
sequence cache | 493,801 | 445 | 2 | 443 | 0 | 0 | 0 |
resmgr:free threads list | 60,437 | 212 | 10 | 203 | 0 | 0 | 0 |
messages | 691,717 | 186 | 1 | 185 | 0 | 0 | 0 |
enqueue hash chains | 657,049 | 162 | 1 | 161 | 0 | 0 | 0 |
channel operations parent latch | 791,955 | 154 | 4 | 151 | 0 | 0 | 0 |
KJCT flow control latch | 265,814 | 120 | 3 | 117 | 0 | 0 | 0 |
session switching | 149,190 | 92 | 5 | 88 | 0 | 0 | 0 |
OS process: request allocation | 59,459 | 91 | 11 | 84 | 0 | 0 | 0 |
enqueues | 704,876 | 68 | 3 | 66 | 0 | 0 | 0 |
session idle bit | 4,025,806 | 58 | 2 | 56 | 0 | 0 | 0 |
OS process allocation | 63,188 | 55 | 2 | 53 | 0 | 0 | 0 |
dummy allocation | 60,529 | 50 | 9 | 43 | 0 | 0 | 0 |
KCL gc element parent latch | 124,678 | 25 | 3 | 22 | 0 | 0 | 0 |
KWQMN job cache list latch | 2,179 | 4 | 2 | 2 | 0 | 0 | 0 |
object queue header operation | 250,387 | 4 | 1 | 3 | 0 | 0 | 0 |
ges enqueue table freelist | 371,657 | 2 | 1 | 1 | 0 | 0 | 0 |
slave class create | 1,717 | 2 | 2 | 0 | 0 | 0 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
KCL gc element parent latch | kclchkping | 0 | 2 | 0 |
KCL gc element parent latch | kclnfndnewm | 0 | 1 | 1 |
KCL gc element parent latch | kclpto_1 | 0 | 1 | 0 |
KJCT flow control latch | kjcts_sqenq: queue a message | 0 | 3 | 2 |
KWQMN job cache list latch | kwqmnprsc: loop | 0 | 2 | 0 |
OS process allocation | kso_new_process:2 | 0 | 2 | 2 |
OS process: request allocation | kso_new_process | 0 | 9 | 6 |
OS process: request allocation | ksoreqholder_delete | 0 | 2 | 5 |
active service list | kswslogon: session logout | 0 | 609 | 608 |
active service list | kswslogon: session login | 0 | 30 | 13 |
active service list | kswsgsnp: get service name ptr | 0 | 3 | 21 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 9,398 | 4,384 |
cache buffers chains | kcbrls: kslbegin | 0 | 923 | 6,027 |
cache buffers chains | kcbgtcr: fast path | 0 | 107 | 14 |
cache buffers chains | kcbget: pin buffer | 0 | 12 | 6 |
cache buffers chains | kcbgcur: kslbegin | 0 | 10 | 4 |
cache buffers chains | kclbla | 0 | 3 | 0 |
cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 2 | 7 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 1 | 6 |
cache buffers chains | kcbzwb | 0 | 1 | 0 |
cache buffers chains | kclebs_1 | 0 | 1 | 0 |
cache buffers chains | kclpto | 0 | 1 | 0 |
channel operations parent latch | ksrchdelete() | 0 | 10 | 10 |
cost function | kzulrl | 0 | 14 | 15 |
cost function | kzulgt: find user res | 0 | 6 | 5 |
dummy allocation | ktcscnfy | 0 | 5 | 5 |
dummy allocation | ktcdod | 0 | 4 | 4 |
enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 1 | 0 |
enqueues | ksqies | 0 | 2 | 2 |
enqueues | ksqgel: create enqueue | 0 | 1 | 0 |
event range base latch | No latch | 0 | 29 | 22 |
ges enqueue table freelist | kjlalc: lock allocation | 0 | 1 | 0 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 17 | 2 |
ges resource hash list | kjrmas1: lookup master node | 0 | 7 | 0 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 2 | 20 |
ges resource hash list | kjcvscn: remove from scan queue | 0 | 1 | 0 |
library cache | kglLockCursor | 0 | 11 | 3 |
library cache | kglhdgn: child: | 0 | 11 | 19 |
library cache | kgldte: child 0 | 0 | 10 | 12 |
library cache | kglobpn: child: | 0 | 6 | 10 |
library cache | kglpndl: child: before processing | 0 | 3 | 0 |
library cache | kgldti: 2child | 0 | 1 | 0 |
library cache | kglpndl: child: after processing | 0 | 1 | 0 |
library cache lock | kgllkdl: child: cleanup | 0 | 111 | 103 |
library cache lock | kgllkal: child: multiinstance | 0 | 17 | 32 |
messages | ksarcv | 0 | 1 | 0 |
object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 0 |
object queue header operation | kcbw_link_q | 0 | 1 | 0 |
process allocation | ksuapc | 0 | 2,097 | 1,759 |
process allocation | ksucrp | 0 | 954 | 0 |
process allocation | ksudlp | 0 | 220 | 646 |
process allocation | ksufap: active procs | 0 | 49 | 915 |
resmgr:free threads list | kgskthrcreate | 0 | 5 | 5 |
resmgr:free threads list | kgskthrsod | 0 | 5 | 5 |
row cache objects | kqrpre: find obj | 0 | 9 | 20 |
row cache objects | kqreqd: reget | 0 | 6 | 0 |
row cache objects | kqrso | 0 | 5 | 0 |
sequence cache | kdnnxt: cached seq | 0 | 2 | 0 |
session allocation | ksuxds: KSUSFCLC not set | 0 | 521 | 228 |
session allocation | ksudlp | 0 | 77 | 215 |
session allocation | ksucri | 0 | 55 | 167 |
session allocation | ksuxds: not user session | 0 | 36 | 86 |
session allocation | ksucrp | 0 | 15 | 18 |
session allocation | ksufap: active sessions | 0 | 10 | 0 |
session idle bit | ksupuc: clear busy | 0 | 2 | 2 |
session idle bit | ksupuc: set busy | 0 | 1 | 1 |
session switching | kskexeall | 0 | 5 | 5 |
shared pool | kghalo | 0 | 47 | 32 |
shared pool | kghfre | 0 | 27 | 43 |
shared pool | kghupr1 | 0 | 6 | 7 |
shared pool | kghalp | 0 | 2 | 1 |
shared pool | kghfrunp: alloc: cursor dur | 0 | 1 | 0 |
shared pool | kghfrunp: clatch: nowait | 0 | 1 | 0 |
slave class create | ksvcreate | 0 | 2 | 0 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE_CONTENT_RELATION | TABLE | 13,508,032 | 17.37 | |
WCITY2 | WCITY2_INDEX | PK_TB_ARTICLE_DESC | INDEX | 13,283,664 | 17.08 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE_DESC | TABLE | 10,438,832 | 13.42 | |
WCITY2 | WCITY2_DATA | TB_EILLEGAL_REASON_INFO | TABLE | 5,854,784 | 7.53 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 5,526,848 | 7.11 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
WCITYAPP | TS_APP_DATA | PK_TB_MAP_SERVICE_RECORD | INDEX | 71 | 0.20 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 64 | 0.18 | |
WCITY2 | WCITY2_DATA | TB_API_REQUEST_LOG | TABLE | 54 | 0.15 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE_CONTENT | TABLE | 33 | 0.09 | |
WCITY2 | WCITY2_DATA | TB_USER_PHONE_INFO | TABLE | 13 | 0.04 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
WCITYAPP | TS_APP_DATA | PK_TB_MAP_SERVICE_RECORD | INDEX | 20 | 37.74 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 9 | 16.98 | |
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 8 | 15.09 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 6 | 11.32 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 4 | 7.55 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 2 | 40.00 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 2 | 40.00 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 1 | 20.00 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
WCITYAPP | TS_APP_DATA | PK_TB_MAP_SERVICE_RECORD | INDEX | 121 | 76.58 | |
WCITYAPP | TS_APP_DATA | TB_MAP_SERVICE_RECORD | TABLE | 14 | 8.86 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 5 | 3.16 | |
SYS | SYSTEM | SEQ$ | TABLE | 4 | 2.53 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 3 | 1.90 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 9 | 14.29 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 7 | 11.11 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 6 | 9.52 | |
WCITY2 | WCITY2_DATA | TB_ACCESS_TOKEN | TABLE | 5 | 7.94 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 5 | 7.94 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 1,914 | 38.14 | |
SYS | SYSTEM | SEQ$ | TABLE | 560 | 11.16 | |
SYS | SYSTEM | JOB$ | TABLE | 522 | 10.40 | |
WCITY2 | WCITY2_INDEX | INDEX_TB_P_U_MOBILE | INDEX | 347 | 6.91 | |
WCITY2 | WCITY2_DATA | TB_PORTAL_USER | TABLE | 162 | 3.23 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 988 | 13.52 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 774 | 10.60 | |
WCITY2 | WCITY2_INDEX | IDX_TB_AUTH_LOG_3 | INDEX | 760 | 10.40 | |
WCITY2 | WCITY2_INDEX | IDX_TB_ACCOUNT_INTERFACE_LOG_2 | INDEX | 745 | 10.20 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 711 | 9.73 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 159 | 0.63 | 0 | 1 | 1 | |
dc_database_links | 59,314 | 0.00 | 0 | 0 | 2 | |
dc_global_oids | 7,364 | 0.03 | 0 | 0 | 85 | |
dc_histogram_data | 189,705 | 0.21 | 0 | 0 | 2,332 | |
dc_histogram_defs | 81,946 | 0.72 | 0 | 0 | 2,829 | |
dc_object_grants | 52 | 3.85 | 0 | 0 | 17 | |
dc_object_ids | 207,558 | 0.02 | 0 | 0 | 1,237 | |
dc_objects | 53,975 | 0.27 | 0 | 2 | 750 | |
dc_profiles | 29,499 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 59,077 | 0.00 | 0 | 0 | 688 | |
dc_segments | 70,999 | 0.04 | 0 | 15 | 2,818 | |
dc_sequences | 5,224 | 14.53 | 0 | 5,224 | 15 | |
dc_tablespace_quotas | 6 | 83.33 | 0 | 6 | 2 | |
dc_tablespaces | 123,153 | 0.00 | 0 | 0 | 25 | |
dc_usernames | 119,068 | 0.00 | 0 | 0 | 46 | |
dc_users | 706,638 | 0.00 | 0 | 0 | 72 | |
outstanding_alerts | 733 | 94.82 | 0 | 5 | 5 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 3 | 1 | 0 |
dc_global_oids | 2 | 0 | 7 |
dc_histogram_defs | 594 | 0 | 4 |
dc_object_ids | 37 | 0 | 205 |
dc_objects | 149 | 3 | 1 |
dc_segments | 76 | 5 | 206 |
dc_sequences | 10,427 | 762 | 0 |
dc_tablespace_quotas | 12 | 3 | 1 |
dc_usernames | 1 | 0 | 2 |
dc_users | 1 | 0 | 1 |
outstanding_alerts | 1,450 | 690 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 2,068 | 0.19 | 4,790 | 0.13 | 2 | 0 |
CLUSTER | 32 | 0.00 | 59 | 0.00 | 0 | 0 |
INDEX | 42 | 9.52 | 135 | 5.19 | 3 | 0 |
SQL AREA | 266,819 | 4.60 | 926,300 | 2.18 | 887 | 1 |
TABLE/PROCEDURE | 7,679 | 1.30 | 287,350 | 0.09 | 77 | 0 |
TRIGGER | 257 | 0.00 | 582 | 0.00 | 0 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
CLUSTER | 59 | 0 | 0 | 0 | 0 |
INDEX | 135 | 4 | 0 | 4 | 0 |
TABLE/PROCEDURE | 31,475 | 97 | 17 | 95 | 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 | 880.51 | 0.73 | 1.40 | 21 | 21 | 1,211 | 1,211 | |
Freeable | 76.69 | 0.00 | 1.42 | 2.80 | 21 | 54 | 54 | ||
SQL | 2.89 | 1.74 | 0.00 | 0.01 | 0 | 5 | 1,172 | 566 | |
PL/SQL | 2.54 | 0.38 | 0.00 | 0.00 | 0 | 0 | 1,209 | 1,207 | |
E | Other | 848.23 | 0.74 | 1.43 | 21 | 21 | 1,148 | 1,148 | |
Freeable | 76.38 | 0.00 | 1.34 | 2.75 | 21 | 57 | 57 | ||
SQL | 2.62 | 1.55 | 0.00 | 0.01 | 0 | 6 | 1,119 | 467 | |
PL/SQL | 2.55 | 0.47 | 0.00 | 0.00 | 0 | 0 | 1,146 | 1,146 |
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 | 142.06 | 148.38 | 4.45 |
shared | PCursor | 116.58 | 121.68 | 4.37 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | free memory | 580.97 | 497.60 | -14.35 |
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 | 92.20 | 94.75 | 2.77 |
shared | sql area | 703.28 | 773.10 | 9.93 |
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 | 1,857,716 | 53,213 | 0 |
QMON Coordinator | 108,984 | 0 | 0 |
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 5 | 0 | 0 | 0 | 0 |
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
gcs_resources | 1,503,369 | 3,979,876 | 4005095 | 4005095 |
ges_procs | 1,148 | 1,657 | 2001 | 2001 |
processes | 1,149 | 1,659 | 2000 | 2000 |
sessions | 1,163 | 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) | 20,599 | 2.33 | 0.44 |
acks for commit broadcast(logical) | 20,726 | 2.34 | 0.45 |
broadcast msgs on commit(actual) | 49,129 | 5.56 | 1.06 |
broadcast msgs on commit(logical) | 49,152 | 5.56 | 1.06 |
broadcast msgs on commit(wasted) | 649 | 0.07 | 0.01 |
broadcast on commit wait time(ms) | 12,000 | 1.36 | 0.26 |
broadcast on commit waits | 47,820 | 5.41 | 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 | 0 | 0.00 | 0.00 |
gcs assume cvt | 0 | 0.00 | 0.00 |
gcs assume no cvt | 4,329 | 0.49 | 0.09 |
gcs ast xid | 8 | 0.00 | 0.00 |
gcs blocked converts | 9,567 | 1.08 | 0.21 |
gcs blocked cr converts | 6,363 | 0.72 | 0.14 |
gcs compatible basts | 2 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 846 | 0.10 | 0.02 |
gcs compatible cr basts (local) | 436 | 0.05 | 0.01 |
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,176 | 0.13 | 0.03 |
gcs dbwr write request msgs | 881 | 0.10 | 0.02 |
gcs error msgs | 0 | 0.00 | 0.00 |
gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
gcs immediate (compatible) converts | 98 | 0.01 | 0.00 |
gcs immediate (null) converts | 3,259 | 0.37 | 0.07 |
gcs immediate cr (compatible) converts | 2 | 0.00 | 0.00 |
gcs immediate cr (null) converts | 55 | 0.01 | 0.00 |
gcs indirect ast | 3,927 | 0.44 | 0.08 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 313 | 0.04 | 0.01 |
gcs msgs process time(ms) | 10,428 | 1.18 | 0.22 |
gcs msgs received | 110,777 | 12.53 | 2.38 |
gcs out-of-order msgs | 8 | 0.00 | 0.00 |
gcs pings refused | 13 | 0.00 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs queued converts | 9 | 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 | 0 | 0.00 | 0.00 |
gcs side channel msgs actual | 8,250 | 0.93 | 0.18 |
gcs side channel msgs logical | 13,383 | 1.51 | 0.29 |
gcs stale cr | 4,088 | 0.46 | 0.09 |
gcs undo cr | 0 | 0.00 | 0.00 |
gcs write notification msgs | 104 | 0.01 | 0.00 |
gcs writes refused | 10 | 0.00 | 0.00 |
ges msgs process time(ms) | 617 | 0.07 | 0.01 |
ges msgs received | 27,539 | 3.11 | 0.59 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 2,933 | 0.33 | 0.06 |
global posts queued | 126 | 0.01 | 0.00 |
global posts requested | 127 | 0.01 | 0.00 |
global posts sent | 126 | 0.01 | 0.00 |
implicit batch messages received | 1,503 | 0.17 | 0.03 |
implicit batch messages sent | 5,010 | 0.57 | 0.11 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 68,026 | 7.69 | 1.46 |
messages queue sent actual | 95,194 | 10.77 | 2.05 |
messages queue sent logical | 100,724 | 11.39 | 2.17 |
messages received actual | 132,768 | 15.02 | 2.86 |
messages received logical | 138,316 | 15.64 | 2.97 |
messages sent directly | 18,484 | 2.09 | 0.40 |
messages sent indirectly | 26,309 | 2.98 | 0.57 |
messages sent not implicit batched | 90,184 | 10.20 | 1.94 |
messages sent pbatched | 36,659 | 4.15 | 0.79 |
msgs causing lmd to send msgs | 6,270 | 0.71 | 0.13 |
msgs causing lms(s) to send msgs | 5,847 | 0.66 | 0.13 |
msgs received queue time (ms) | 4,847 | 0.55 | 0.10 |
msgs received queued | 138,316 | 15.64 | 2.97 |
msgs sent queue time (ms) | 10,290 | 1.16 | 0.22 |
msgs sent queue time on ksxp (ms) | 29,124 | 3.29 | 0.63 |
msgs sent queued | 100,683 | 11.39 | 2.17 |
msgs sent queued on ksxp | 134,052 | 15.16 | 2.88 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 65,807 | 7.44 | 1.42 |
process batch messages sent | 32,953 | 3.73 | 0.71 |
Statistic | Total |
---|---|
CR Block Requests | 6,475 |
CURRENT Block Requests | 550 |
Data Block Requests | 6,475 |
Undo Block Requests | 0 |
TX Block Requests | 341 |
Current Results | 7,006 |
Private results | 0 |
Zero Results | 19 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 1,419 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 267 |
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 | 12,923 | 99.72 | 0.01 | 0.27 | 0.00 | 0.00 |
Flushes | 132 | 81.82 | 15.15 | 2.27 | 0.76 | 0.00 |
Writes | 1,617 | 69.39 | 27.52 | 0.12 | 1.05 | 1.92 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 4,503 | 93.67 | 6.33 | 0.00 | 7,130 | 98.19 | 1.81 | 0.00 |
1 | undo header | 320 | 97.81 | 2.19 | 0.00 | 23 | 100.00 | 0.00 | 0.00 |
1 | Others | 194 | 95.88 | 4.12 | 0.00 | 137 | 96.35 | 3.65 | 0.00 |
1 | undo block | 1 | 100.00 | 0.00 | 0.00 | 0 |