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: | 554 | 25-2ÔÂ -13 10:43:49 | 1265 | .5 |
End Snap: | 559 | 25-2ÔÂ -13 17:03:27 | 1210 | .5 |
Elapsed: | 379.64 (mins) | |||
DB Time: | 7,821.99 (mins) |
Begin | End | |||
---|---|---|---|---|
Buffer Cache: | 29,344M | 29,344M | Std Block Size: | 8K |
Shared Pool Size: | 3,344M | 3,344M | Log Buffer: | 14,272K |
Per Second | Per Transaction | |
---|---|---|
Redo size: | 8,131.10 | 2,276.59 |
Logical reads: | 8,746.03 | 2,448.76 |
Block changes: | 25.53 | 7.15 |
Physical reads: | 7.91 | 2.21 |
Physical writes: | 3.09 | 0.87 |
User calls: | 209.57 | 58.68 |
Parses: | 96.27 | 26.95 |
Hard parses: | 0.58 | 0.16 |
Sorts: | 54.43 | 15.24 |
Logons: | 9.16 | 2.57 |
Executes: | 89.67 | 25.11 |
Transactions: | 3.57 |
% Blocks changed per Read: | 0.29 | Recursive Call %: | 66.81 |
Rollback per transaction %: | 22.24 | Rows per Sort: | 25.75 |
Buffer Nowait %: | 100.00 | Redo NoWait %: | 99.99 |
Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
Library Hit %: | 99.24 | Soft Parse %: | 99.39 |
Execute to Parse %: | -7.35 | Latch Hit %: | 99.80 |
Parse CPU to Parse Elapsd %: | 71.34 | % Non-Parse CPU: | 97.65 |
Begin | End | |
---|---|---|
Memory Usage %: | 78.64 | 81.16 |
% SQL with executions>1: | 75.35 | 99.21 |
% Memory for SQL w/exec>1: | 75.32 | 98.89 |
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
enq: TM - contention | 928,840 | 453,797 | 489 | 96.7 | Application |
CPU time | 17,115 | 3.6 | |||
enq: WF - contention | 14,830 | 7,178 | 484 | 1.5 | Other |
reliable message | 4,160 | 2,627 | 632 | .6 | Other |
enq: US - contention | 55,485 | 2,576 | 46 | .5 | Other |
Begin | End | |
---|---|---|
Number of Instances: | 2 | 2 |
Per Second | Per Transaction | |
---|---|---|
Global Cache blocks received: | 2.26 | 0.63 |
Global Cache blocks served: | 3.73 | 1.05 |
GCS/GES messages received: | 28.96 | 8.11 |
GCS/GES messages sent: | 26.91 | 7.53 |
DBWR Fusion writes: | 0.09 | 0.03 |
Estd Interconnect traffic (KB) | 58.83 |
Buffer access - local cache %: | 99.96 |
Buffer access - remote cache %: | 0.03 |
Buffer access - disk %: | 0.01 |
Avg global enqueue get time (ms): | 330.9 |
Avg global cache cr block receive time (ms): | 0.7 |
Avg global cache current block receive time (ms): | 0.8 |
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 %: | 1.8 |
Avg global cache cr block flush time (ms): | 7.9 |
Avg global cache current block pin time (ms): | 0.3 |
Avg global cache current block send time (ms): | 0.1 |
Global cache log flushes for current blocks served %: | 0.9 |
Avg global cache current block flush time (ms): | 11.3 |
Avg message sent queue time (ms): | 0.2 |
Avg message sent queue time on ksxp (ms): | 0.3 |
Avg message received queue time (ms): | 0.2 |
Avg GCS message process time (ms): | 0.1 |
Avg GES message process time (ms): | 0.0 |
% of direct sent messages: | 25.04 |
% of indirect sent messages: | 47.33 |
% of flow controlled messages: | 27.63 |
Statistic Name | Time (s) | % of DB Time |
---|---|---|
sql execute elapsed time | 462,187.89 | 98.48 |
DB CPU | 17,114.65 | 3.65 |
connection management call elapsed time | 1,564.40 | 0.33 |
parse time elapsed | 564.19 | 0.12 |
hard parse elapsed time | 53.21 | 0.01 |
sequence load elapsed time | 50.97 | 0.01 |
failed parse elapsed time | 13.00 | 0.00 |
PL/SQL execution elapsed time | 4.01 | 0.00 |
hard parse (sharing criteria) elapsed time | 0.45 | 0.00 |
PL/SQL compilation elapsed time | 0.35 | 0.00 |
hard parse (bind mismatch) elapsed time | 0.06 | 0.00 |
repeated bind elapsed time | 0.02 | 0.00 |
DB time | 469,319.24 | |
background elapsed time | 10,727.83 | |
background cpu time | 462.79 |
Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %Total Call Time |
---|---|---|---|---|---|
Application | 1,029,111 | 90 | 454,113 | 441 | 96.76 |
CPU time | 17,115 | 3.65 | |||
Other | 1,684,791 | 27 | 13,046 | 8 | 2.78 |
Concurrency | 128,010 | 0 | 1,497 | 12 | 0.32 |
System I/O | 394,177 | 148 | 0 | 0.03 | |
Cluster | 71,078 | 0 | 144 | 2 | 0.03 |
Commit | 66,024 | 0 | 106 | 2 | 0.02 |
User I/O | 93,246 | 60 | 1 | 0.01 | |
Network | 4,358,764 | 18 | 0 | 0.00 | |
Configuration | 388 | 1 | 17 | 45 | 0.00 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
enq: TM - contention | 928,840 | 100 | 453,797 | 489 | 11.42 |
enq: WF - contention | 14,830 | 98 | 7,178 | 484 | 0.18 |
reliable message | 4,160 | 64 | 2,627 | 632 | 0.05 |
enq: US - contention | 55,485 | 0 | 2,576 | 46 | 0.68 |
row cache lock | 89,962 | 466 | 5 | 1.11 | |
latch free | 29,090 | 0 | 418 | 14 | 0.36 |
latch: row cache objects | 25,937 | 319 | 12 | 0.32 | |
SQL*Net break/reset to client | 100,256 | 316 | 3 | 1.23 | |
latch: shared pool | 980 | 223 | 228 | 0.01 | |
latch: cache buffers chains | 7,593 | 162 | 21 | 0.09 | |
latch: ges resource hash list | 2,268 | 150 | 66 | 0.03 | |
latch: library cache | 664 | 132 | 198 | 0.01 | |
latch: library cache lock | 547 | 112 | 206 | 0.01 | |
log file sync | 66,024 | 0 | 106 | 2 | 0.81 |
control file sequential read | 312,478 | 97 | 0 | 3.84 | |
gc buffer busy | 1,495 | 3 | 80 | 54 | 0.02 |
os thread startup | 671 | 1 | 52 | 77 | 0.01 |
log file parallel write | 72,324 | 36 | 0 | 0.89 | |
latch: session allocation | 2,625 | 32 | 12 | 0.03 | |
buffer busy waits | 858 | 27 | 32 | 0.01 | |
db file scattered read | 6,287 | 22 | 4 | 0.08 | |
gc current block 2-way | 29,262 | 22 | 1 | 0.36 | |
direct path read | 66,459 | 21 | 0 | 0.82 | |
gc current block busy | 667 | 0 | 19 | 29 | 0.01 |
DFS lock handle | 35,831 | 0 | 18 | 0 | 0.44 |
db file sequential read | 19,862 | 16 | 1 | 0.24 | |
enq: SQ - contention | 248 | 15 | 62 | 0.00 | |
control file parallel write | 8,875 | 11 | 1 | 0.11 | |
SQL*Net more data to client | 281,543 | 9 | 0 | 3.46 | |
gc cr block 2-way | 15,805 | 9 | 1 | 0.19 | |
gcs log flush sync | 1,809 | 13 | 8 | 5 | 0.02 |
gc cr multi block request | 16,482 | 8 | 0 | 0.20 | |
SQL*Net message to client | 4,049,016 | 7 | 0 | 49.77 | |
Streams AQ: qmn coordinator waiting for slave to start | 1 | 100 | 6 | 6210 | 0.00 |
CGS wait for IPC msg | 307,418 | 100 | 4 | 0 | 3.78 |
LGWR wait for redo copy | 622 | 51 | 3 | 6 | 0.01 |
gc current grant busy | 3,185 | 3 | 1 | 0.04 | |
log file sequential read | 260 | 3 | 12 | 0.00 | |
enq: TX - contention | 890 | 0 | 3 | 3 | 0.01 |
ges lmd/lmses to freeze in rcfg - mrcvr | 377 | 51 | 2 | 6 | 0.00 |
enq: PR - contention | 5 | 2 | 453 | 0.00 | |
PX Deq Credit: send blkd | 4,532 | 57 | 2 | 0 | 0.06 |
SQL*Net more data from client | 27,438 | 2 | 0 | 0.34 | |
latch: object queue header operation | 14 | 2 | 139 | 0.00 | |
enq: TX - index contention | 124 | 2 | 15 | 0.00 | |
gc cr block busy | 492 | 2 | 4 | 0.01 | |
latch: checkpoint queue latch | 4 | 2 | 441 | 0.00 | |
PX Deq: reap credit | 38,745 | 89 | 2 | 0 | 0.48 |
cursor: pin S | 1,020,253 | 1 | 0 | 12.54 | |
ksxr poll remote instances | 113,136 | 49 | 1 | 0 | 1.39 |
enq: HW - contention | 78 | 3 | 1 | 16 | 0.00 |
name-service call wait | 25 | 1 | 48 | 0.00 | |
CSS operation: query | 126 | 1 | 9 | 0.00 | |
rdbms ipc reply | 2,787 | 1 | 0 | 0.03 | |
latch: redo allocation | 1 | 1 | 966 | 0.00 | |
Data file init write | 121 | 1 | 7 | 0.00 | |
enq: CF - contention | 435 | 0 | 1 | 2 | 0.01 |
SQL*Net message from dblink | 398 | 1 | 2 | 0.00 | |
enq: PS - contention | 1,238 | 1 | 1 | 0.02 | |
db file parallel read | 132 | 1 | 4 | 0.00 | |
log file switch completion | 20 | 0 | 23 | 0.00 | |
gc cr grant 2-way | 1,572 | 0 | 0 | 0.02 | |
wait list latch free | 35 | 0 | 11 | 0.00 | |
gc current multi block request | 1,701 | 0 | 0 | 0.02 | |
cursor: pin S wait on X | 26 | 96 | 0 | 10 | 0.00 |
IPC send completion sync | 895 | 100 | 0 | 0 | 0.01 |
enq: FB - contention | 343 | 0 | 1 | 0.00 | |
gcs drm freeze in enter server mode | 1 | 0 | 211 | 0.00 | |
kksfbc child completion | 4 | 100 | 0 | 50 | 0.00 |
undo segment extension | 2 | 100 | 0 | 99 | 0.00 |
PX Deq: Signal ACK | 1,218 | 32 | 0 | 0 | 0.01 |
gc current grant 2-way | 399 | 0 | 0 | 0.00 | |
library cache lock | 300 | 0 | 0 | 0.00 | |
library cache pin | 337 | 0 | 0 | 0.00 | |
Log archive I/O | 220 | 0 | 0 | 0.00 | |
CSS initialization | 42 | 0 | 2 | 0.00 | |
latch: enqueue hash chains | 144 | 0 | 1 | 0.00 | |
ksdxexeotherwait | 44,557 | 100 | 0 | 0 | 0.55 |
gc current retry | 4 | 0 | 15 | 0.00 | |
gc current split | 13 | 0 | 4 | 0.00 | |
local write wait | 19 | 0 | 3 | 0.00 | |
buffer deadlock | 382 | 96 | 0 | 0 | 0.00 |
enq: TA - contention | 75 | 0 | 0 | 0.00 | |
enq: TX - allocate ITL entry | 40 | 0 | 1 | 0.00 | |
CSS operation: action | 86 | 0 | 0 | 0.00 | |
enq: JQ - contention | 45 | 0 | 1 | 0.00 | |
global enqueue expand wait | 2 | 100 | 0 | 10 | 0.00 |
direct path write | 347 | 0 | 0 | 0.00 | |
latch: gcs resource hash | 96 | 0 | 0 | 0.00 | |
enq: RO - fast object reuse | 13 | 0 | 1 | 0.00 | |
latch: library cache pin | 9 | 0 | 1 | 0.00 | |
ges inquiry response | 12 | 0 | 1 | 0.00 | |
enq: MW - contention | 13 | 0 | 1 | 0.00 | |
enq: DR - contention | 13 | 0 | 0 | 0.00 | |
enq: JS - job run lock - synchronize | 12 | 0 | 0 | 0.00 | |
log file single write | 20 | 0 | 0 | 0.00 | |
latch: KCL gc element parent latch | 70 | 0 | 0 | 0.00 | |
db file single write | 12 | 0 | 0 | 0.00 | |
latch: messages | 10 | 0 | 0 | 0.00 | |
enq: TT - contention | 3 | 0 | 1 | 0.00 | |
latch: undo global data | 1 | 0 | 1 | 0.00 | |
enq: AF - task serialization | 2 | 0 | 1 | 0.00 | |
KJC: Wait for msg sends to complete | 10 | 0 | 0 | 0.00 | |
enq: TX - row lock contention | 1 | 0 | 1 | 0.00 | |
enq: WL - contention | 2 | 0 | 0 | 0.00 | |
read by other session | 7 | 0 | 0 | 0.00 | |
SQL*Net message to dblink | 369 | 0 | 0 | 0.00 | |
enq: PI - contention | 2 | 0 | 0 | 0.00 | |
enq: IR - contention | 1 | 0 | 0 | 0.00 | |
enq: UL - contention | 1 | 0 | 0 | 0.00 | |
enq: SW - contention | 1 | 0 | 0 | 0.00 | |
gc cr failure | 1 | 0 | 0 | 0.00 | |
wait for scn ack | 2 | 0 | 0 | 0.00 | |
lock escalate retry | 3 | 67 | 0 | 0 | 0.00 |
cursor: mutex X | 2 | 0 | 0 | 0.00 | |
cr request retry | 1 | 100 | 0 | 0 | 0.00 |
lock deadlock retry | 1 | 100 | 0 | 0 | 0.00 |
SQL*Net message from client | 4,255,188 | 26,134,432 | 6142 | 52.30 | |
gcs remote message | 6,323,614 | 94 | 177,664 | 28 | 77.73 |
jobq slave wait | 40,788 | 98 | 118,430 | 2904 | 0.50 |
PX Idle Wait | 10,890 | 92 | 25,563 | 2347 | 0.13 |
Streams AQ: qmn slave idle wait | 879 | 0 | 22,267 | 25332 | 0.01 |
DIAG idle wait | 113,761 | 22,236 | 195 | 1.40 | |
ASM background timer | 5,099 | 22,223 | 4358 | 0.06 | |
ges remote message | 598,518 | 63 | 22,217 | 37 | 7.36 |
Streams AQ: qmn coordinator idle wait | 1,646 | 50 | 22,202 | 13489 | 0.02 |
virtual circuit status | 760 | 100 | 22,190 | 29198 | 0.01 |
class slave wait | 2,473 | 86 | 21,912 | 8860 | 0.03 |
Streams AQ: waiting for time management or cleanup tasks | 85 | 21,849 | 257051 | 0.00 | |
PX Deq: Execution Msg | 3,804 | 24 | 986 | 259 | 0.05 |
i/o slave wait | 42,190 | 80 | 2 | 0.52 | |
KSV master wait | 187 | 7 | 39 | 0.00 | |
PX Deq: Join ACK | 1,347 | 35 | 1 | 1 | 0.02 |
single-task message | 29 | 1 | 48 | 0.00 | |
PX Deq: Parse Reply | 1,271 | 35 | 0 | 0 | 0.02 |
PX Deq: Msg Fragment | 1,353 | 21 | 0 | 0 | 0.02 |
PX Deq: Execute Reply | 1,187 | 35 | 0 | 0 | 0.01 |
Streams AQ: RAC qmn coordinator idle wait | 1,660 | 100 | 0 | 0 | 0.02 |
Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn |
---|---|---|---|---|---|
events in waitclass Other | 494,656 | 82 | 88 | 0 | 6.08 |
os thread startup | 669 | 1 | 52 | 77 | 0.01 |
log file parallel write | 72,324 | 36 | 0 | 0.89 | |
control file sequential read | 59,736 | 27 | 0 | 0.73 | |
control file parallel write | 8,841 | 11 | 1 | 0.11 | |
log file sequential read | 260 | 3 | 12 | 0.00 | |
latch: shared pool | 4 | 1 | 307 | 0.00 | |
gc cr block 2-way | 2,380 | 1 | 0 | 0.03 | |
latch: row cache objects | 155 | 1 | 7 | 0.00 | |
latch: cache buffers chains | 104 | 1 | 9 | 0.00 | |
latch: library cache lock | 1 | 0 | 492 | 0.00 | |
enq: TM - contention | 966 | 0 | 0 | 0.01 | |
gc current block 2-way | 865 | 0 | 0 | 0.01 | |
Log archive I/O | 220 | 0 | 0 | 0.00 | |
gc current grant busy | 74 | 0 | 0 | 0.00 | |
buffer busy waits | 28 | 0 | 1 | 0.00 | |
db file sequential read | 2 | 0 | 5 | 0.00 | |
log file single write | 20 | 0 | 0 | 0.00 | |
direct path write | 278 | 0 | 0 | 0.00 | |
direct path read | 380 | 0 | 0 | 0.00 | |
enq: RO - fast object reuse | 5 | 0 | 0 | 0.00 | |
rdbms ipc message | 617,936 | 53 | 376,220 | 609 | 7.60 |
gcs remote message | 6,323,636 | 94 | 177,664 | 28 | 77.73 |
DIAG idle wait | 113,761 | 22,236 | 195 | 1.40 | |
ASM background timer | 5,099 | 22,223 | 4358 | 0.06 | |
ges remote message | 598,487 | 63 | 22,217 | 37 | 7.36 |
Streams AQ: qmn coordinator idle wait | 1,646 | 50 | 22,202 | 13489 | 0.02 |
pmon timer | 21,793 | 100 | 22,151 | 1016 | 0.27 |
class slave wait | 2,285 | 93 | 21,912 | 9589 | 0.03 |
Streams AQ: waiting for time management or cleanup tasks | 85 | 21,849 | 257051 | 0.00 | |
smon timer | 95 | 21,530 | 226634 | 0.00 | |
KSV master wait | 101 | 3 | 29 | 0.00 | |
Streams AQ: RAC qmn coordinator idle wait | 1,660 | 100 | 0 | 0 | 0.02 |
Statistic | Total |
---|---|
BUSY_TIME | 2,460,875 |
IDLE_TIME | 70,411,270 |
IOWAIT_TIME | 19,373 |
NICE_TIME | 270 |
SYS_TIME | 1,310,209 |
USER_TIME | 1,106,287 |
LOAD | 2 |
RSRC_MGR_CPU_WAIT_TIME | 0 |
VM_IN_BYTES | 6,980,502,528 |
VM_OUT_BYTES | 4,341,166,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 | 469,050.80 | 16,847.10 | 178,140 | 198,653,965 |
SYS$USERS | 267.90 | 266.40 | 27 | 296,194 |
SYS$BACKGROUND | 0.30 | 0.50 | 2,007 | 274,463 |
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 | 73129 | 47 | 122478 | 1382 | 0 | 0 | 3510400 | 17 |
SYS$USERS | 17499 | 11 | 466 | 19 | 0 | 0 | 23605 | 0 |
SYS$BACKGROUND | 2619 | 3 | 5008 | 59 | 0 | 0 | 0 | 0 |
Elapsed Time (s) | CPU Time (s) | Executions | Elap per Exec (s) | % Total DB Time | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
457,627 | 178 | 24,529 | 18.66 | 97.51 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
491 | 439 | 178,818 | 0.00 | 0.10 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
269 | 274 | 1,050 | 0.26 | 0.06 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
243 | 194 | 171,543 | 0.00 | 0.05 | 0k8522rmdzg4k | select privilege# from sysauth... | |
225 | 140 | 23,962 | 0.01 | 0.05 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
189 | 192 | 1,050 | 0.18 | 0.04 | 9j3v93dcqd1ng | select count(*) from (select c... | |
173 | 177 | 7 | 24.78 | 0.04 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
170 | 116 | 170,577 | 0.00 | 0.04 | 5ur69atw3vfhj | select decode(failover_method,... | |
161 | 164 | 7 | 22.93 | 0.03 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
156 | 160 | 458 | 0.34 | 0.03 | 04v68mrc0ndtt | 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 |
---|---|---|---|---|---|---|---|---|
439 | 491 | 178,818 | 0.00 | 2.56 | 0.10 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
274 | 269 | 1,050 | 0.26 | 1.60 | 0.06 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
194 | 243 | 171,543 | 0.00 | 1.13 | 0.05 | 0k8522rmdzg4k | select privilege# from sysauth... | |
192 | 189 | 1,050 | 0.18 | 1.12 | 0.04 | 9j3v93dcqd1ng | select count(*) from (select c... | |
178 | 457,627 | 24,529 | 0.01 | 1.04 | 97.51 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
177 | 173 | 7 | 25.35 | 1.04 | 0.04 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
164 | 161 | 7 | 23.45 | 0.96 | 0.03 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
160 | 156 | 458 | 0.35 | 0.93 | 0.03 | 04v68mrc0ndtt | select * from ( select temp.* ... | |
153 | 149 | 6 | 25.45 | 0.89 | 0.03 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
153 | 149 | 6 | 25.45 | 0.89 | 0.03 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... |
Buffer Gets | Executions | Gets per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
13,403,828 | 458 | 29,266.00 | 6.73 | 159.76 | 156.38 | 04v68mrc0ndtt | select * from ( select temp.* ... | |
11,473,825 | 1,050 | 10,927.45 | 5.76 | 273.94 | 269.14 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
8,765,364 | 178,818 | 49.02 | 4.40 | 438.86 | 491.21 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
8,764,251 | 1,050 | 8,346.91 | 4.40 | 192.26 | 188.82 | 9j3v93dcqd1ng | select count(*) from (select c... | |
4,464,093 | 193 | 23,130.02 | 2.24 | 71.97 | 70.56 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
4,134,973 | 11 | 375,906.64 | 2.08 | 11.13 | 10.91 | abc0gp2snqgc6 | select * from ( select temp.* ... | |
4,134,909 | 11 | 375,900.82 | 2.08 | 11.33 | 11.08 | dvx2pht8zybj3 | select count(*) from tb_articl... | |
3,748,148 | 181 | 20,708.00 | 1.88 | 78.07 | 76.57 | b6sts095f7490 | select * from ( select temp.* ... | |
2,615,294 | 25,894 | 101.00 | 1.31 | 26.77 | 26.57 | chvsc0kcnaygf | select * from ( select t.adver... | |
2,607,206 | 7 | 372,458.00 | 1.31 | 177.43 | 173.47 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
2,607,171 | 7 | 372,453.00 | 1.31 | 164.15 | 160.52 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
2,399,558 | 23,758 | 101.00 | 1.20 | 25.86 | 25.61 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
2,234,835 | 6 | 372,472.50 | 1.12 | 152.70 | 149.39 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
2,234,829 | 6 | 372,471.50 | 1.12 | 152.69 | 149.38 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... |
Physical Reads | Executions | Reads per Exec | %Total | CPU Time (s) | Elapsed Time (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|
93,504 | 1 | 93,504.00 | 51.90 | 13.37 | 18.24 | dkpzqaa4b8vav | PL/SQL Developer | select * from tb_account_inter... |
4,167 | 1 | 4,167.00 | 2.31 | 1.73 | 2.24 | 11ww6q6bzqjtf | PL/SQL Developer | select count(1) from tb_portal... |
1,424 | 5 | 284.80 | 0.79 | 1.25 | 2.62 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
1,215 | 2 | 607.50 | 0.67 | 1.56 | 2.89 | d92h3rjp0y217 | begin prvt_hdm.auto_execute( :... | |
33 | 24,529 | 0.00 | 0.02 | 177.91 | 457627.24 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
7 | 23,962 | 0.00 | 0.00 | 140.05 | 224.66 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
1 | 1 | 1.00 | 0.00 | 0.04 | 0.05 | 0gkq5s6hqx8hy | insert into wrh$_sessmetric_hi... | |
1 | 1,697 | 0.00 | 0.00 | 1.57 | 1.65 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
1 | 17,140 | 0.00 | 0.00 | 14.53 | 18.37 | awq9n3jt2dwrt | JDBC Thin Client | select portaluser0_.ID as ID3_... |
1 | 1,162 | 0.00 | 0.00 | 0.47 | 0.48 | g4hsmh25tmwfh | update TW_ALARM_INFO set ALARM... |
Executions | Rows Processed | Rows per Exec | CPU per Exec (s) | Elap per Exec (s) | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
348,852 | 2,903 | 0.01 | 0.00 | 0.00 | 0h6b2sajwb74n | select privilege#, level from ... | |
178,818 | 0 | 0.00 | 0.00 | 0.00 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
171,543 | 348,850 | 2.03 | 0.00 | 0.00 | 0k8522rmdzg4k | select privilege# from sysauth... | |
171,205 | 171,203 | 1.00 | 0.00 | 0.00 | 459f3z9u4fb3u | select value$ from props$ wher... | |
171,204 | 171,204 | 1.00 | 0.00 | 0.00 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
170,577 | 170,578 | 1.00 | 0.00 | 0.00 | 5ur69atw3vfhj | select decode(failover_method,... | |
112,784 | 0 | 0.00 | 0.00 | 0.00 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... | |
45,378 | 408,402 | 9.00 | 0.00 | 0.00 | c77pa2g2u0rq9 | select tdict0_.ID as ID112_, t... | |
25,894 | 0 | 0.00 | 0.00 | 0.00 | chvsc0kcnaygf | select * from ( select t.adver... | |
24,529 | 24,529 | 1.00 | 0.00 | 0.00 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
24,529 | 24,529 | 1.00 | 0.01 | 18.66 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
23,962 | 23,962 | 1.00 | 0.01 | 0.01 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
23,758 | 23,751 | 1.00 | 0.00 | 0.00 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
23,433 | 23,433 | 1.00 | 0.00 | 0.00 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
23,391 | 136,131 | 5.82 | 0.00 | 0.00 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|
348,852 | 348,852 | 15.91 | 0h6b2sajwb74n | select privilege#, level from ... | |
178,833 | 178,818 | 8.16 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
171,543 | 171,543 | 7.82 | 0k8522rmdzg4k | select privilege# from sysauth... | |
171,205 | 171,204 | 7.81 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
171,205 | 171,205 | 7.81 | 459f3z9u4fb3u | select value$ from props$ wher... | |
170,579 | 170,577 | 7.78 | 5ur69atw3vfhj | select decode(failover_method,... | |
112,784 | 112,784 | 5.14 | bw2rqq1s3bzrd | select tbtestwhit0_.wl_id as w... | |
45,378 | 45,378 | 2.07 | c77pa2g2u0rq9 | select tdict0_.ID as ID112_, t... | |
25,894 | 25,894 | 1.18 | chvsc0kcnaygf | select * from ( select t.adver... | |
24,529 | 24,529 | 1.12 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
24,529 | 24,529 | 1.12 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
23,962 | 23,962 | 1.09 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
23,758 | 23,758 | 1.08 | 4bkajwhn01bf4 | select m.* from (select t.adve... | |
23,433 | 23,433 | 1.07 | c68x2drb8jh6f | SELECT T.LABEL_ID, T.LABEL_NAM... | |
23,391 | 23,391 | 1.07 | asycs9abcdt1k | JDBC Thin Client | SELECT TP.ID, TP.SP_ID, TP.SP_... |
Version Count | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|
22 | 1,162 | g4hsmh25tmwfh | update TW_ALARM_INFO set ALARM... | |
21 | 9,535 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
21 | 408 | aq8yqxyyb40nn | update sys.job$ set this_date=... |
Cluster Wait Time (s) | CWT % of Elapsd Time | Elapsed Time(s) | CPU Time(s) | Executions | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|
66.69 | 29.69 | 224.66 | 140.05 | 23,962 | 8g02qq5sb8gkk | JDBC Thin Client | INSERT INTO TB_AUTH_LOG(LOG_ID... |
52.24 | 0.01 | 457,627.24 | 177.91 | 24,529 | f7wycxzwr231m | JDBC Thin Client | insert into TB_ACCOUNT_INTERFA... |
6.49 | 35.60 | 18.24 | 13.37 | 1 | dkpzqaa4b8vav | PL/SQL Developer | select * from tb_account_inter... |
3.33 | 22.87 | 14.55 | 11.93 | 2,283 | axmdf8vq7k1rh | select increment$, minvalue, m... | |
2.80 | 6.72 | 41.71 | 22.81 | 320 | bcz7kcb5nhjfv | insert into tb_user_oper_log (... | |
2.11 | 57.85 | 3.64 | 1.71 | 2,599 | 7bd391hat42zk | select /*+ rule */ name, file#... | |
2.08 | 0.42 | 491.21 | 438.86 | 178,818 | az33m61ym46y4 | JDBC Thin Client | SELECT NULL AS table_cat, o.ow... |
2.05 | 22.80 | 9.01 | 7.05 | 9,535 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
1.36 | 53.16 | 2.57 | 1.20 | 719 | 5ansr7r9htpq3 | update undo$ set name=:2, file... | |
0.94 | 4.51 | 20.76 | 18.00 | 24,529 | dtrjpdn3fw6as | JDBC Thin Client | select TB_ACCOUNT_INTERFACE_LO... |
0.52 | 22.97 | 2.24 | 1.73 | 1 | 11ww6q6bzqjtf | PL/SQL Developer | select count(1) from tb_portal... |
0.51 | 0.27 | 188.82 | 192.26 | 1,050 | 9j3v93dcqd1ng | select count(*) from (select c... | |
0.40 | 26.66 | 1.51 | 1.09 | 408 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
0.40 | 15.27 | 2.62 | 1.25 | 5 | 0dwr2vd6vbqzs | SELECT count(*) over () as tot... | |
0.35 | 12.23 | 2.89 | 1.56 | 2 | d92h3rjp0y217 | begin prvt_hdm.auto_execute( :... | |
0.30 | 0.11 | 269.14 | 273.94 | 1,050 | d3rgr1ugyfy4v | select * from ( select temp.* ... | |
0.20 | 1.09 | 18.37 | 14.53 | 17,140 | awq9n3jt2dwrt | JDBC Thin Client | select portaluser0_.ID as ID3_... |
0.18 | 8.25 | 2.24 | 2.17 | 3 | 51kmqtgr5z85s | PL/SQL Developer | select * from tb_access_token ... |
0.13 | 0.19 | 70.56 | 71.97 | 193 | 8qk3ffrqfu5mj | select count(*) from (select a... | |
0.12 | 7.03 | 1.65 | 1.57 | 1,697 | 5kt6k7qwjz6fu | JDBC Thin Client | select * from (select t.*, row... |
0.09 | 0.12 | 76.57 | 78.07 | 181 | b6sts095f7490 | select * from ( select temp.* ... | |
0.06 | 0.50 | 12.82 | 10.49 | 14,960 | 9w01ztmr4569k | select count(*) from tb_articl... | |
0.06 | 0.04 | 149.38 | 152.69 | 6 | aucbhp050unfp | INSERT INTO TB_SERVER_KPI (SER... | |
0.06 | 0.04 | 149.39 | 152.70 | 6 | gtct3f6rqmt7k | BEGIN proc_tb_server_kpi(:1, :... | |
0.06 | 0.04 | 173.47 | 177.43 | 7 | 6p18ng82999p1 | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.06 | 0.43 | 13.96 | 11.91 | 15,038 | 4aa2pajm13day | select count(*) from tb_articl... | |
0.05 | 29.78 | 0.18 | 0.14 | 22 | 7cq8d0jqxzum1 | delete from smon_scn_time wher... | |
0.05 | 1.23 | 4.16 | 2.82 | 4,451 | cbvwasd557av2 | insert into tb_wap_visit_log (... | |
0.05 | 0.03 | 160.52 | 164.15 | 7 | 36pd7s33q8t3d | oracle@OMP_MS_DB1 (TNS V1-V3) | SELECT "A1"."COLLECT_TYPE", NV... |
0.03 | 0.36 | 9.52 | 8.91 | 14,960 | 3r189y4actbt2 | select * from ( select temp.* ... | |
0.03 | 15.42 | 0.21 | 0.17 | 263 | 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFOR... | |
0.03 | 0.18 | 17.20 | 17.50 | 15,036 | gxa2gs64zaq6p | select * from ( select temp.* ... | |
0.02 | 11.61 | 0.21 | 0.17 | 638 | g00cj285jmgsw | update sys.mon_mods$ set inser... | |
0.02 | 14.38 | 0.14 | 0.11 | 319 | 04xtrk7uyhknh | select obj#, type#, ctime, mti... | |
0.02 | 16.50 | 0.11 | 0.09 | 5 | 31a13pnjps7j3 | SELECT source, (case when time... | |
0.01 | 0.13 | 10.91 | 11.13 | 11 | abc0gp2snqgc6 | select * from ( select temp.* ... | |
0.01 | 0.13 | 11.08 | 11.33 | 11 | dvx2pht8zybj3 | select count(*) from tb_articl... | |
0.01 | 12.61 | 0.10 | 0.08 | 273 | 91h2x42zqagcm | UPDATE MGMT_CURRENT_METRICS SE... | |
0.01 | 0.29 | 3.73 | 3.78 | 678 | 2ug5va58ks6nc | select count(*) from tb_articl... | |
0.01 | 0.37 | 2.62 | 2.67 | 2 | 8823uk5zfv6d8 | JDBC Thin Client | select t1.CONTENT_ID, t1.IS_PR... |
0.01 | 12.69 | 0.07 | 0.07 | 12 | 0cfuq7q5cwvpb | select program_oid, schedule_e... | |
0.01 | 0.42 | 2.05 | 2.09 | 1 | 72pjn5ufnn75x | JDBC Thin Client | select t1.CONTENT_ID, t1.IS_PR... |
0.01 | 0.15 | 5.39 | 5.51 | 11 | gg14jykdjfk1v | select count(*) from (select a... | |
0.01 | 0.06 | 10.92 | 11.13 | 67 | g7558pad7w8pk | select * from ( select temp.* ... | |
0.01 | 5.81 | 0.10 | 0.10 | 1 | amrf492v0v82z | select * from (select t.orderi... | |
0.01 | 0.05 | 11.49 | 11.70 | 94 | 6x6f4n9yatry9 | select * from ( select temp.* ... |
Statistic | Total | per Second | per Trans |
---|---|---|---|
CPU used by this session | 586,042 | 25.73 | 7.20 |
CPU used when call started | 577,203 | 25.34 | 7.09 |
CR blocks created | 1,155 | 0.05 | 0.01 |
Cached Commit SCN referenced | 2,025,362 | 88.92 | 24.90 |
Commit SCN cached | 73 | 0.00 | 0.00 |
DB time | 59,627,162 | 2,617.73 | 732.93 |
DBWR checkpoint buffers written | 67,190 | 2.95 | 0.83 |
DBWR checkpoints | 9 | 0.00 | 0.00 |
DBWR fusion writes | 2,103 | 0.09 | 0.03 |
DBWR object drop buffers written | 13 | 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 | 17,576 | 0.77 | 0.22 |
DBWR undo block writes | 21,986 | 0.97 | 0.27 |
DFO trees parallelized | 466 | 0.02 | 0.01 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
PX local messages recv'd | 2,519 | 0.11 | 0.03 |
PX local messages sent | 2,519 | 0.11 | 0.03 |
PX remote messages recv'd | 2,362 | 0.10 | 0.03 |
PX remote messages sent | 6,696 | 0.29 | 0.08 |
Parallel operations not downgraded | 466 | 0.02 | 0.01 |
RowCR - row contention | 2 | 0.00 | 0.00 |
RowCR attempts | 885 | 0.04 | 0.01 |
RowCR hits | 880 | 0.04 | 0.01 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 11 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 3,224,232 | 141.55 | 39.63 |
SQL*Net roundtrips to/from dblink | 369 | 0.02 | 0.00 |
active txn count during cleanout | 22,360 | 0.98 | 0.27 |
application wait time | 45,407,466 | 1,993.46 | 558.14 |
background checkpoints completed | 5 | 0.00 | 0.00 |
background checkpoints started | 5 | 0.00 | 0.00 |
background timeouts | 110,819 | 4.87 | 1.36 |
branch node splits | 5 | 0.00 | 0.00 |
buffer is not pinned count | 51,389,391 | 2,256.08 | 631.67 |
buffer is pinned count | 131,356,911 | 5,766.78 | 1,614.61 |
bytes received via SQL*Net from client | 670,436,762 | 29,433.25 | 8,240.88 |
bytes received via SQL*Net from dblink | 123,235 | 5.41 | 1.51 |
bytes sent via SQL*Net to client | 1,400,297,924 | 61,475.34 | 17,212.19 |
bytes sent via SQL*Net to dblink | 122,203 | 5.36 | 1.50 |
calls to get snapshot scn: kcmgss | 6,617,244 | 290.51 | 81.34 |
calls to kcmgas | 177,135 | 7.78 | 2.18 |
calls to kcmgcs | 10,400 | 0.46 | 0.13 |
change write time | 3,284 | 0.14 | 0.04 |
cleanout - number of ktugct calls | 11,239 | 0.49 | 0.14 |
cleanouts and rollbacks - consistent read gets | 409 | 0.02 | 0.01 |
cleanouts only - consistent read gets | 260 | 0.01 | 0.00 |
cluster key scan block gets | 227,639 | 9.99 | 2.80 |
cluster key scans | 193,715 | 8.50 | 2.38 |
cluster wait time | 14,377 | 0.63 | 0.18 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 82 | 0.00 | 0.00 |
commit batch/immediate requested | 82 | 0.00 | 0.00 |
commit cleanout failures: block lost | 75 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 446 | 0.02 | 0.01 |
commit cleanout failures: cannot pin | 271 | 0.01 | 0.00 |
commit cleanouts | 153,502 | 6.74 | 1.89 |
commit cleanouts successfully completed | 152,710 | 6.70 | 1.88 |
commit immediate performed | 82 | 0.00 | 0.00 |
commit immediate requested | 82 | 0.00 | 0.00 |
commit txn count during cleanout | 20,940 | 0.92 | 0.26 |
concurrency wait time | 146,018 | 6.41 | 1.79 |
consistent changes | 2,268 | 0.10 | 0.03 |
consistent gets | 198,480,732 | 8,713.62 | 2,439.69 |
consistent gets - examination | 79,494,969 | 3,489.96 | 977.14 |
consistent gets direct | 79,795 | 3.50 | 0.98 |
consistent gets from cache | 198,400,937 | 8,710.12 | 2,438.71 |
current blocks converted for CR | 0 | 0.00 | 0.00 |
cursor authentications | 2,326 | 0.10 | 0.03 |
data blocks consistent reads - undo records applied | 1,079 | 0.05 | 0.01 |
db block changes | 581,432 | 25.53 | 7.15 |
db block gets | 738,141 | 32.41 | 9.07 |
db block gets direct | 1,305 | 0.06 | 0.02 |
db block gets from cache | 736,836 | 32.35 | 9.06 |
deferred (CURRENT) block cleanout applications | 77,814 | 3.42 | 0.96 |
dirty buffers inspected | 5 | 0.00 | 0.00 |
enqueue conversions | 6,750 | 0.30 | 0.08 |
enqueue releases | 758,979 | 33.32 | 9.33 |
enqueue requests | 759,147 | 33.33 | 9.33 |
enqueue timeouts | 167 | 0.01 | 0.00 |
enqueue waits | 59,772 | 2.62 | 0.73 |
exchange deadlocks | 431 | 0.02 | 0.01 |
execute count | 2,042,580 | 89.67 | 25.11 |
failed probes on index block reclamation | 0 | 0.00 | 0.00 |
free buffer inspected | 151,714 | 6.66 | 1.86 |
free buffer requested | 166,727 | 7.32 | 2.05 |
gc CPU used by this session | 18,470 | 0.81 | 0.23 |
gc blocks lost | 0 | 0.00 | 0.00 |
gc cr block build time | 114 | 0.01 | 0.00 |
gc cr block flush time | 397 | 0.02 | 0.00 |
gc cr block receive time | 1,417 | 0.06 | 0.02 |
gc cr block send time | 120 | 0.01 | 0.00 |
gc cr blocks received | 20,563 | 0.90 | 0.25 |
gc cr blocks served | 28,731 | 1.26 | 0.35 |
gc current block flush time | 568 | 0.02 | 0.01 |
gc current block pin time | 1,794 | 0.08 | 0.02 |
gc current block receive time | 2,393 | 0.11 | 0.03 |
gc current block send time | 749 | 0.03 | 0.01 |
gc current blocks received | 30,824 | 1.35 | 0.38 |
gc current blocks served | 56,313 | 2.47 | 0.69 |
gc local grants | 11,089 | 0.49 | 0.14 |
gc remote grants | 103,481 | 4.54 | 1.27 |
gcs messages sent | 445,619 | 19.56 | 5.48 |
ges messages sent | 167,268 | 7.34 | 2.06 |
global enqueue get time | 17,563,633 | 771.07 | 215.89 |
global enqueue gets async | 53,466 | 2.35 | 0.66 |
global enqueue gets sync | 477,278 | 20.95 | 5.87 |
global enqueue releases | 412,737 | 18.12 | 5.07 |
heap block compress | 206 | 0.01 | 0.00 |
hot buffers moved to head of LRU | 16,138 | 0.71 | 0.20 |
immediate (CR) block cleanout applications | 673 | 0.03 | 0.01 |
immediate (CURRENT) block cleanout applications | 3,063 | 0.13 | 0.04 |
index crx upgrade (found) | 70 | 0.00 | 0.00 |
index crx upgrade (positioned) | 20,812 | 0.91 | 0.26 |
index fast full scans (full) | 121 | 0.01 | 0.00 |
index fetch by key | 48,890,581 | 2,146.38 | 600.95 |
index scans kdiixs1 | 3,851,944 | 169.11 | 47.35 |
leaf node 90-10 splits | 466 | 0.02 | 0.01 |
leaf node splits | 796 | 0.03 | 0.01 |
lob reads | 16,472 | 0.72 | 0.20 |
lob writes | 27,164 | 1.19 | 0.33 |
lob writes unaligned | 27,159 | 1.19 | 0.33 |
logons cumulative | 208,714 | 9.16 | 2.57 |
messages received | 280,228 | 12.30 | 3.44 |
messages sent | 280,228 | 12.30 | 3.44 |
no buffer to keep pinned count | 0 | 0.00 | 0.00 |
no work - consistent read gets | 114,523,584 | 5,027.77 | 1,407.70 |
opened cursors cumulative | 2,197,174 | 96.46 | 27.01 |
parse count (failures) | 6,925 | 0.30 | 0.09 |
parse count (hard) | 13,287 | 0.58 | 0.16 |
parse count (total) | 2,192,804 | 96.27 | 26.95 |
parse time cpu | 40,234 | 1.77 | 0.49 |
parse time elapsed | 56,400 | 2.48 | 0.69 |
physical read IO requests | 75,923 | 3.33 | 0.93 |
physical read bytes | 1,475,960,832 | 64,797.06 | 18,142.23 |
physical read total IO requests | 406,435 | 17.84 | 5.00 |
physical read total bytes | 6,968,312,832 | 305,920.16 | 85,653.16 |
physical read total multi block requests | 13,348 | 0.59 | 0.16 |
physical reads | 180,171 | 7.91 | 2.21 |
physical reads cache | 99,996 | 4.39 | 1.23 |
physical reads cache prefetch | 91,531 | 4.02 | 1.13 |
physical reads direct | 80,175 | 3.52 | 0.99 |
physical reads direct (lob) | 79,757 | 3.50 | 0.98 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 53,173 | 2.33 | 0.65 |
physical write bytes | 577,363,968 | 25,347.21 | 7,096.85 |
physical write total IO requests | 216,366 | 9.50 | 2.66 |
physical write total bytes | 1,602,214,912 | 70,339.82 | 19,694.12 |
physical write total multi block requests | 145,232 | 6.38 | 1.79 |
physical writes | 70,479 | 3.09 | 0.87 |
physical writes direct | 1,585 | 0.07 | 0.02 |
physical writes direct (lob) | 61 | 0.00 | 0.00 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 68,894 | 3.02 | 0.85 |
physical writes non checkpoint | 21,711 | 0.95 | 0.27 |
pinned buffers inspected | 21 | 0.00 | 0.00 |
pinned cursors current | 8 | 0.00 | 0.00 |
prefetch clients - default | 1 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 58 | 0.00 | 0.00 |
process last non-idle time | 22,780 | 1.00 | 0.28 |
queries parallelized | 466 | 0.02 | 0.01 |
recursive calls | 9,608,339 | 421.82 | 118.10 |
recursive cpu usage | 108,738 | 4.77 | 1.34 |
redo blocks written | 410,816 | 18.04 | 5.05 |
redo buffer allocation retries | 18 | 0.00 | 0.00 |
redo entries | 377,387 | 16.57 | 4.64 |
redo log space requests | 20 | 0.00 | 0.00 |
redo log space wait time | 47 | 0.00 | 0.00 |
redo ordering marks | 4,916 | 0.22 | 0.06 |
redo size | 185,211,944 | 8,131.10 | 2,276.59 |
redo subscn max counts | 7,299 | 0.32 | 0.09 |
redo synch time | 11,240 | 0.49 | 0.14 |
redo synch writes | 63,704 | 2.80 | 0.78 |
redo wastage | 18,449,612 | 809.97 | 226.78 |
redo write broadcast ack time | 2,279 | 0.10 | 0.03 |
redo write time | 5,648 | 0.25 | 0.07 |
redo writer latching time | 355 | 0.02 | 0.00 |
redo writes | 72,324 | 3.18 | 0.89 |
rollback changes - undo records applied | 158 | 0.01 | 0.00 |
rollbacks only - consistent read gets | 623 | 0.03 | 0.01 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 19,582,599 | 859.71 | 240.71 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 876,051 | 38.46 | 10.77 |
session logical reads | 199,218,873 | 8,746.03 | 2,448.76 |
shared hash latch upgrades - no wait | 88,181 | 3.87 | 1.08 |
shared hash latch upgrades - wait | 143 | 0.01 | 0.00 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 1,239,854 | 54.43 | 15.24 |
sorts (rows) | 31,921,416 | 1,401.40 | 392.37 |
sql area evicted | 4,561 | 0.20 | 0.06 |
sql area purged | 6,909 | 0.30 | 0.08 |
summed dirty queue length | 4 | 0.00 | 0.00 |
switch current to new buffer | 118 | 0.01 | 0.00 |
table fetch by rowid | 54,212,198 | 2,380.00 | 666.37 |
table fetch continued row | 65,346 | 2.87 | 0.80 |
table scan blocks gotten | 93,237,162 | 4,093.26 | 1,146.05 |
table scan rows gotten | 12,839,946,762 | 563,694.36 | 157,826.15 |
table scans (long tables) | 4 | 0.00 | 0.00 |
table scans (short tables) | 1,736,572 | 76.24 | 21.35 |
total number of times SMON posted | 95 | 0.00 | 0.00 |
transaction lock background get time | 3 | 0.00 | 0.00 |
transaction lock background gets | 716 | 0.03 | 0.01 |
transaction lock foreground requests | 716 | 0.03 | 0.01 |
transaction lock foreground wait time | 68 | 0.00 | 0.00 |
transaction rollbacks | 82 | 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 | 29,311,808 | 1,286.84 | 360.30 |
user I/O wait time | 6,004 | 0.26 | 0.07 |
user calls | 4,773,651 | 209.57 | 58.68 |
user commits | 63,260 | 2.78 | 0.78 |
user rollbacks | 18,095 | 0.79 | 0.22 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 358,774 | 15.75 | 4.41 |
write clones created in background | 19 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |
Statistic | Begin Value | End Value |
---|---|---|
session pga memory max | 1.0E+12 | 1.0E+12 |
session cursor cache count | 202,583,990 | 203,825,876 |
session uga memory | 6.6E+14 | 6.7E+14 |
opened cursors current | 598 | 604 |
workarea memory allocated | 265 | 265 |
logons current | 1,265 | 1,210 |
session uga memory max | 1.7E+13 | 1.7E+13 |
session pga memory | 6.0E+11 | 6.1E+11 |
Statistic | Total | per Hour |
---|---|---|
log switches (derived) | 5 | 0.79 |
Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
---|---|---|---|---|---|---|---|---|
USERS | 63,873 | 3 | 0.00 | 1.21 | 5 | 0 | 0 | 0.00 |
UNDOTBS2 | 35 | 0 | 9.71 | 1.00 | 35,625 | 2 | 13 | 0.77 |
WCITY2_DATA | 8,676 | 0 | 2.73 | 11.12 | 11,681 | 1 | 448 | 55.74 |
SYSAUX | 1,634 | 0 | 1.49 | 1.00 | 1,999 | 0 | 0 | 0.00 |
WCITY2_INDEX | 1,346 | 0 | 1.22 | 3.12 | 1,527 | 0 | 994 | 73.00 |
WCITY_GNMS | 64 | 0 | 5.47 | 1.00 | 1,477 | 0 | 5 | 0.00 |
SYSTEM | 18 | 0 | 1.11 | 1.00 | 605 | 0 | 685 | 6.41 |
WCITY | 180 | 0 | 0.00 | 1.00 | 105 | 0 | 0 | 0.00 |
TS_APP_DATA | 10 | 0 | 0.00 | 1.00 | 73 | 0 | 0 | 0.00 |
TBS_ITS | 10 | 0 | 0.00 | 1.00 | 10 | 0 | 0 | 0.00 |
TS_APP_INDEX | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY_BC | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
HQDB_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
INMS01 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
ISS | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
NETM_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMAE_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMP01 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMS01 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
REPORT_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
SSB_DATA_JWF | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
UNDOTBS1 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 3 | 0.00 |
ZXDBM_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
ZXINJOS_DATA | 5 | 0 | 0.00 | 1.00 | 5 | 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 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
INMS01 | +DATA/acsdb/datafile/inms01.279.762122141 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
ISS | +DATA/acsdb/datafile/iss01.bdf | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
NETM_DATA | +DATA/acsdb/datafile/netm_data.295.762368247 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMAE_DATA | +DATA/acsdb/datafile/omae_data.297.762368277 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMP01 | +DATA/acsdb/datafile/omp01.280.762122149 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
OMS01 | +DATA/acsdb/datafile/oms01.281.762122175 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
REPORT_DATA | +DATA/acsdb/datafile/report_data.291.762359943 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
SSB_DATA_JWF | +DATA/acsdb/datafile/ssb_data_jwf.292.762359949 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
SYSAUX | +DATA/acsdb/datafile/sysaux.257.762113905 | 1,634 | 0 | 1.49 | 1.00 | 1,999 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.1634.787070407 | 10 | 0 | 0.00 | 1.00 | 85 | 0 | 0 | 0.00 |
SYSTEM | +DATA/acsdb/datafile/system.256.762113905 | 8 | 0 | 2.50 | 1.00 | 520 | 0 | 685 | 6.41 |
TBS_ITS | +DATA/acsdb/datafile/tbs_its.305.762449727 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
TBS_ITS | +DATA/acsdb/datafile/tbs_its01.dbf | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
TS_APP_DATA | +DATA/acsdb/datafile/ts_app_data01.dbf | 10 | 0 | 0.00 | 1.00 | 73 | 0 | 0 | 0.00 |
TS_APP_INDEX | +DATA/acsdb/datafile/ts_app_index01.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
UNDOTBS1 | +DATA/acsdb/datafile/undotbs1.258.762113905 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 3 | 0.00 |
UNDOTBS2 | +DATA/acsdb/datafile/undotbs2.269.762113985 | 35 | 0 | 9.71 | 1.00 | 35,625 | 2 | 13 | 0.77 |
USERS | +DATA/acsdb/datafile/users.259.762113905 | 63,873 | 3 | 0.00 | 1.21 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1031.787073439 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1146.787070545 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.1297.787074783 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.2249.787070711 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.287.762346721 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.2995.787070437 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3189.787070649 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3202.787070683 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.3261.787070351 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.370.787070423 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4594.787070635 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.4822.787075205 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5264.787070521 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5495.787070583 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.5810.787070597 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity.6430.787070489 | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity1.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity2.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity3.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity4.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY | +DATA/acsdb/datafile/wcity5.dbf | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data01.dbf | 279 | 0 | 0.82 | 2.41 | 246 | 0 | 4 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data02.dbf | 206 | 0 | 0.97 | 2.33 | 207 | 0 | 5 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data03.dbf | 235 | 0 | 0.89 | 2.11 | 346 | 0 | 11 | 0.91 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data04.dbf | 5,391 | 0 | 3.41 | 14.60 | 53 | 0 | 0 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data05.dbf | 1,722 | 0 | 2.26 | 8.79 | 2,508 | 0 | 381 | 65.46 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data06.dbf | 377 | 0 | 0.77 | 1.10 | 835 | 0 | 3 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data07.dbf | 144 | 0 | 1.39 | 1.49 | 2,621 | 0 | 21 | 0.95 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data08.dbf | 218 | 0 | 0.73 | 1.12 | 4,088 | 0 | 18 | 0.00 |
WCITY2_DATA | +DATA/acsdb/datafile/wcity2_data09.dbf | 104 | 0 | 0.77 | 1.03 | 777 | 0 | 5 | 0.00 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index01.dbf | 712 | 0 | 1.22 | 2.94 | 632 | 0 | 151 | 27.95 |
WCITY2_INDEX | +DATA/acsdb/datafile/wcity2_index02.dbf | 634 | 0 | 1.21 | 3.31 | 895 | 0 | 843 | 81.07 |
WCITY_BC | +DATA/acsdb/datafile/wcity_bc01.dbf | 10 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms01.dbf | 26 | 0 | 4.62 | 1.00 | 660 | 0 | 5 | 0.00 |
WCITY_GNMS | +DATA/acsdb/datafile/wcity_gnms02.dbf | 38 | 0 | 6.05 | 1.00 | 817 | 0 | 0 | 0.00 |
ZXDBM_DATA | +DATA/acsdb/datafile/zxdbm_data.290.762359941 | 5 | 0 | 0.00 | 1.00 | 5 | 0 | 0 | 0.00 |
ZXINJOS_DATA | +DATA/acsdb/datafile/zxinjos_data.289.762359941 | 5 | 0 | 0.00 | 1.00 | 5 | 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,515,778 | 100 | 199,135,146 | 99,996 | 68,894 | 0 | 0 | 2,148 |
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 | 0 | 626 | 8459 | 20522 | 184320 | 20522 | |
E | 0 | 3 | 1852 | 12153 | 70282 | 184320 | 70282 |
P | Size for Est (M) | Size Factor | Buffers for Estimate | Est Phys Read Factor | Estimated Physical Reads |
---|---|---|---|---|---|
D | 2,928 | 0.10 | 350,811 | 33.51 | 874,265,986 |
D | 5,856 | 0.20 | 701,622 | 1.45 | 37,733,045 |
D | 8,784 | 0.30 | 1,052,433 | 1.13 | 29,449,144 |
D | 11,712 | 0.40 | 1,403,244 | 1.08 | 28,110,997 |
D | 14,640 | 0.50 | 1,754,055 | 1.03 | 26,875,663 |
D | 17,568 | 0.60 | 2,104,866 | 1.02 | 26,713,377 |
D | 20,496 | 0.70 | 2,455,677 | 1.02 | 26,632,731 |
D | 23,424 | 0.80 | 2,806,488 | 1.01 | 26,481,388 |
D | 26,352 | 0.90 | 3,157,299 | 1.01 | 26,409,826 |
D | 29,280 | 1.00 | 3,508,110 | 1.00 | 26,103,604 |
D | 29,344 | 1.00 | 3,515,778 | 1.00 | 26,093,569 |
D | 32,208 | 1.10 | 3,858,921 | 0.98 | 25,497,183 |
D | 35,136 | 1.20 | 4,209,732 | 0.97 | 25,430,032 |
D | 38,064 | 1.30 | 4,560,543 | 0.97 | 25,238,117 |
D | 40,992 | 1.40 | 4,911,354 | 0.96 | 25,165,906 |
D | 43,920 | 1.50 | 5,262,165 | 0.96 | 24,920,131 |
D | 46,848 | 1.60 | 5,612,976 | 0.94 | 24,615,833 |
D | 49,776 | 1.70 | 5,963,787 | 0.93 | 24,307,092 |
D | 52,704 | 1.80 | 6,314,598 | 0.84 | 21,855,531 |
D | 55,632 | 1.90 | 6,665,409 | 0.82 | 21,390,851 |
D | 58,560 | 2.00 | 7,016,220 | 0.81 | 21,078,671 |
PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
---|---|---|
100.00 | 35,328 | 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,648 | 869.85 | 0.00 | 0.00 | 0.00 | 0.00 | 823,700 |
E | 8,044 | 6,636 | 884.94 | 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 | 326,556 | 326,556 | 0 | 0 |
64K | 128K | 1,352 | 1,352 | 0 | 0 |
128K | 256K | 1,506 | 1,506 | 0 | 0 |
256K | 512K | 1,998 | 1,998 | 0 | 0 |
512K | 1024K | 6,196 | 6,196 | 0 | 0 |
1M | 2M | 21,066 | 21,066 | 0 | 0 |
2M | 4M | 26 | 26 | 0 | 0 |
4M | 8M | 82 | 82 | 0 | 0 |
8M | 16M | 16 | 16 | 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,301,297.68 | 2,377.98 | 100.00 | 0 |
2,011 | 0.25 | 2,301,297.68 | 2,108.66 | 100.00 | 0 |
4,022 | 0.50 | 2,301,297.68 | 1,025.99 | 100.00 | 0 |
6,033 | 0.75 | 2,301,297.68 | 1,025.99 | 100.00 | 0 |
8,044 | 1.00 | 2,301,297.68 | 1,025.99 | 100.00 | 0 |
9,653 | 1.20 | 2,301,297.68 | 0.00 | 100.00 | 0 |
11,262 | 1.40 | 2,301,297.68 | 0.00 | 100.00 | 0 |
12,870 | 1.60 | 2,301,297.68 | 0.00 | 100.00 | 0 |
14,479 | 1.80 | 2,301,297.68 | 0.00 | 100.00 | 0 |
16,088 | 2.00 | 2,301,297.68 | 0.00 | 100.00 | 0 |
24,132 | 3.00 | 2,301,297.68 | 0.00 | 100.00 | 0 |
32,176 | 4.00 | 2,301,297.68 | 0.00 | 100.00 | 0 |
48,264 | 6.00 | 2,301,297.68 | 0.00 | 100.00 | 0 |
64,352 | 8.00 | 2,301,297.68 | 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 | 378 | 27,418 | 14,021,193 | 1.00 | 68,952 | 1.07 | 610,500 |
2,352 | 0.70 | 700 | 46,291 | 14,024,460 | 1.00 | 65,685 | 1.02 | 610,822 |
2,688 | 0.80 | 1,034 | 65,080 | 14,025,331 | 1.00 | 64,814 | 1.01 | 610,945 |
3,024 | 0.90 | 1,369 | 83,115 | 14,025,698 | 1.00 | 64,447 | 1.00 | 611,009 |
3,360 | 1.00 | 1,703 | 99,852 | 14,025,910 | 1.00 | 64,235 | 1.00 | 611,052 |
3,696 | 1.10 | 2,038 | 118,886 | 14,026,057 | 1.00 | 64,088 | 1.00 | 611,085 |
4,032 | 1.20 | 2,373 | 136,856 | 14,026,183 | 1.00 | 63,962 | 1.00 | 611,113 |
4,368 | 1.30 | 2,708 | 153,940 | 14,026,281 | 1.00 | 63,864 | 0.99 | 611,138 |
4,704 | 1.40 | 3,043 | 170,560 | 14,026,369 | 1.00 | 63,776 | 0.99 | 611,160 |
5,040 | 1.50 | 3,378 | 187,663 | 14,026,445 | 1.00 | 63,700 | 0.99 | 611,179 |
5,376 | 1.60 | 3,713 | 202,248 | 14,026,509 | 1.00 | 63,636 | 0.99 | 611,195 |
5,712 | 1.70 | 4,048 | 220,092 | 14,026,568 | 1.00 | 63,577 | 0.99 | 611,211 |
6,048 | 1.80 | 4,383 | 238,782 | 14,026,618 | 1.00 | 63,527 | 0.99 | 611,224 |
6,384 | 1.90 | 4,718 | 258,081 | 14,026,663 | 1.00 | 63,482 | 0.99 | 611,236 |
6,720 | 2.00 | 5,053 | 276,617 | 14,026,700 | 1.00 | 63,445 | 0.99 | 611,246 |
SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
---|---|---|---|
8,192 | 0.25 | 3,628,607 | 37,733,907 |
16,384 | 0.50 | 3,605,197 | 26,876,374 |
24,576 | 0.75 | 3,602,675 | 26,714,594 |
32,768 | 1.00 | 3,601,594 | 26,093,567 |
40,960 | 1.25 | 3,599,794 | 25,430,790 |
49,152 | 1.50 | 3,598,714 | 24,616,671 |
57,344 | 1.75 | 3,598,354 | 21,855,972 |
65,536 | 2.00 | 3,598,354 | 21,078,383 |
Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
---|---|---|---|---|---|
16 | 1.00 | 0 | 0 | 0 | 0 |
32 | 2.00 | 0 | 0 | 0 | 0 |
48 | 3.00 | 0 | 0 | 0 | 0 |
64 | 4.00 | 0 | 0 | 0 | 0 |
80 | 5.00 | 0 | 0 | 0 | 0 |
96 | 6.00 | 0 | 0 | 0 | 0 |
112 | 7.00 | 0 | 0 | 0 | 0 |
128 | 8.00 | 0 | 0 | 0 | 0 |
144 | 9.00 | 0 | 0 | 0 | 0 |
160 | 10.00 | 0 | 0 | 0 | 0 |
176 | 11.00 | 0 | 0 | 0 | 0 |
192 | 12.00 | 0 | 0 | 0 | 0 |
208 | 13.00 | 0 | 0 | 0 | 0 |
224 | 14.00 | 0 | 0 | 0 | 0 |
240 | 15.00 | 0 | 0 | 0 | 0 |
256 | 16.00 | 0 | 0 | 0 | 0 |
272 | 17.00 | 0 | 0 | 0 | 0 |
288 | 18.00 | 0 | 0 | 0 | 0 |
304 | 19.00 | 0 | 0 | 0 | 0 |
320 | 20.00 | 0 | 0 | 0 | 0 |
Class | Waits | Total Wait Time (s) | Avg Time (ms) |
---|---|---|---|
data block | 1,875 | 99 | 53 |
1st level bmb | 51 | 3 | 53 |
system undo header | 177 | 0 | 1 |
system undo block | 20 | 0 | 1 |
undo header | 16 | 0 | 1 |
segment header | 6 | 0 | 2 |
2nd level bmb | 3 | 0 | 0 |
Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
---|---|---|---|---|---|---|
TM-DML | 89,690 | 89,690 | 0 | 1,393 | 464,703 | 333,598.51 |
WF-AWR Flush | 244 | 120 | 124 | 186 | 7,350 | 39,515.91 |
US-Undo Segment | 55,061 | 55,063 | 0 | 54,739 | 2,796 | 51.07 |
SQ-Sequence Cache | 12,475 | 12,475 | 0 | 237 | 16 | 65.74 |
TX-Transaction | 80,288 | 80,288 | 0 | 866 | 3 | 3.26 |
PR-Process Startup | 653 | 653 | 0 | 5 | 2 | 466.00 |
TX-Transaction (index contention) | 153 | 151 | 0 | 121 | 2 | 16.86 |
HW-Segment High Water Mark | 14,014 | 14,014 | 0 | 65 | 1 | 19.69 |
CF-Controlfile Transaction | 53,063 | 53,063 | 0 | 422 | 1 | 2.20 |
PS-PX Process Reservation | 3,473 | 3,431 | 42 | 1,231 | 1 | 0.60 |
FB-Format Block | 538 | 538 | 0 | 287 | 0 | 0.77 |
TA-Instance Undo | 76 | 76 | 0 | 75 | 0 | 0.67 |
JQ-Job Queue | 444 | 443 | 1 | 44 | 0 | 1.14 |
TX-Transaction (allocate ITL entry) | 40 | 40 | 0 | 40 | 0 | 0.75 |
JS-Job Scheduler (job run lock - synchronize) | 12 | 12 | 0 | 12 | 0 | 0.83 |
RO-Multiple Object Reuse (fast object reuse) | 36 | 36 | 0 | 12 | 0 | 0.83 |
DR-Distributed Recovery | 13 | 13 | 0 | 13 | 0 | 0.00 |
MW-MWIN Schedule | 13 | 13 | 0 | 13 | 0 | 0.00 |
TT-Tablespace | 2,251 | 2,251 | 0 | 3 | 0 | 0.00 |
AF-Advisor Framework (task serialization) | 35 | 35 | 0 | 2 | 0 | 0.00 |
PI-Remote PX Process Spawn Status | 10 | 10 | 0 | 2 | 0 | 0.00 |
WL-Being Written Redo Log | 5 | 5 | 0 | 2 | 0 | 0.00 |
IR-Instance Recovery | 60 | 60 | 0 | 1 | 0 | 0.00 |
SW-Suspend Writes | 12 | 12 | 0 | 1 | 0 | 0.00 |
TX-Transaction (row lock contention) | 1 | 1 | 0 | 1 | 0 | 0.00 |
UL-User-defined | 6 | 6 | 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 | 4.79 | 77,608 | 1,474 | 18 | 75/197.9 | 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 |
---|---|---|---|---|---|---|---|
25-2ÔÂ 16:59 | 272 | 5,721 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 16:49 | 300 | 6,594 | 0 | 14 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 16:39 | 239 | 5,388 | 0 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 16:29 | 271 | 6,353 | 933 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 16:19 | 161 | 3,894 | 930 | 18 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 16:09 | 90 | 1,872 | 326 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:59 | 114 | 2,566 | 326 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:49 | 75 | 1,581 | 1,266 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:39 | 46 | 1,412 | 664 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:29 | 83 | 1,408 | 319 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:19 | 56 | 1,336 | 918 | 2 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 15:09 | 95 | 2,158 | 915 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:59 | 110 | 1,111 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:49 | 39 | 925 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:39 | 149 | 2,005 | 910 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:29 | 158 | 3,076 | 1,057 | 6 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:19 | 234 | 5,609 | 455 | 8 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 14:09 | 339 | 6,501 | 0 | 6 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:59 | 170 | 735 | 898 | 3 | 198 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:49 | 35 | 781 | 555 | 3 | 188 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:39 | 12 | 516 | 835 | 3 | 178 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:29 | 18 | 649 | 0 | 4 | 168 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:19 | 39 | 1,451 | 892 | 4 | 158 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 13:09 | 70 | 1,849 | 886 | 4 | 148 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:59 | 81 | 707 | 285 | 5 | 138 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:49 | 31 | 677 | 0 | 4 | 128 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:39 | 8 | 585 | 0 | 3 | 118 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:29 | 15 | 612 | 0 | 3 | 108 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:19 | 12 | 602 | 0 | 3 | 97 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 12:09 | 99 | 912 | 1,474 | 3 | 87 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 11:59 | 23 | 750 | 870 | 2 | 77 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 11:49 | 17 | 914 | 0 | 3 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 11:39 | 549 | 1,238 | 77 | 4 | 75 | 0/0 | 0/0/0/0/0/0 |
25-2ÔÂ 11:29 | 210 | 524 | 864 | 2 | 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 | 430 | 0.00 | 0 | 0 | ||
ASM db client latch | 15,873 | 0.00 | 0 | 0 | ||
ASM map headers | 902 | 0.00 | 0 | 0 | ||
ASM map load waiting list | 300 | 0.00 | 0 | 0 | ||
ASM map operation freelist | 7,160 | 0.00 | 0 | 0 | ||
ASM map operation hash table | 2,027,564 | 0.00 | 0.02 | 0 | 0 | |
ASM network background latch | 10,226 | 0.00 | 0 | 0 | ||
AWR Alerted Metric Element list | 345,157 | 0.00 | 0 | 0 | ||
Consistent RBA | 72,333 | 0.00 | 0 | 0 | ||
FAL request queue | 465 | 0.00 | 0 | 0 | ||
FAL subheap alocation | 465 | 0.00 | 0 | 0 | ||
FIB s.o chain latch | 98 | 0.00 | 0 | 0 | ||
FOB s.o list latch | 102,987 | 0.01 | 0.00 | 0 | 0 | |
JS broadcast add buf latch | 5,205 | 0.00 | 0 | 0 | ||
JS broadcast drop buf latch | 5,205 | 0.00 | 0 | 0 | ||
JS broadcast load blnc latch | 4,543 | 0.00 | 0 | 0 | ||
JS mem alloc latch | 35 | 0.00 | 0 | 0 | ||
JS queue access latch | 35 | 0.00 | 0 | 0 | ||
JS queue state obj latch | 164,218 | 0.00 | 0 | 0 | ||
JS slv state obj latch | 10,469 | 0.00 | 0 | 0 | ||
KCL gc element parent latch | 831,541 | 0.10 | 0.08 | 0 | 955 | 0.00 |
KFK SGA context latch | 13,756 | 0.00 | 0 | 0 | ||
KFMD SGA | 5,732 | 0.02 | 1.00 | 0 | 0 | |
KJC message pool free list | 152,408 | 0.23 | 0.00 | 0 | 8,368 | 0.04 |
KJCT flow control latch | 891,517 | 0.01 | 0.00 | 0 | 0 | |
KMG MMAN ready and startup request latch | 7,590 | 0.00 | 0 | 0 | ||
KSXR large replies | 3 | 0.00 | 0 | 0 | ||
KTF sga latch | 27,731 | 0.00 | 0 | 6,391 | 0.00 | |
KWQMN job cache list latch | 1,830 | 0.00 | 0 | 0 | ||
KWQP Prop Status | 10 | 0.00 | 0 | 0 | ||
MQL Tracking Latch | 0 | 0 | 454 | 0.00 | ||
Memory Management Latch | 0 | 0 | 7,590 | 0.00 | ||
OS process | 626,502 | 0.00 | 0 | 0 | ||
OS process allocation | 425,253 | 0.08 | 0.04 | 3 | 0 | |
OS process: request allocation | 415,052 | 0.13 | 0.21 | 38 | 0 | |
PL/SQL warning settings | 210,728 | 0.00 | 0 | 0 | ||
SGA IO buffer pool latch | 648 | 0.00 | 0 | 648 | 0.00 | |
SQL memory manager latch | 5 | 0.00 | 0 | 7,577 | 0.00 | |
SQL memory manager workarea list latch | 720,880 | 0.00 | 0.00 | 0 | 0 | |
Shared B-Tree | 817 | 0.00 | 0 | 0 | ||
active checkpoint queue latch | 85,004 | 0.00 | 0.00 | 0 | 0 | |
active service list | 1,023,358 | 0.36 | 0.09 | 0 | 26,106 | 0.10 |
alert log latch | 10 | 0.00 | 0 | 0 | ||
archive control | 773 | 0.00 | 0 | 0 | ||
archive process latch | 8,517 | 0.00 | 0 | 0 | ||
begin backup scn array | 106 | 0.00 | 0 | 0 | ||
business card | 932 | 0.00 | 0 | 0 | ||
cache buffer handles | 12,808 | 0.00 | 0 | 0 | ||
cache buffers chains | 320,499,801 | 0.09 | 0.03 | 162 | 767,305 | 0.01 |
cache buffers lru chain | 264,337 | 0.00 | 0.00 | 0 | 380,053 | 0.01 |
cache table scan latch | 0 | 0 | 6,287 | 0.00 | ||
channel handle pool latch | 415,158 | 0.02 | 0.08 | 0 | 0 | |
channel operations parent latch | 3,751,327 | 0.01 | 0.03 | 0 | 0 | |
checkpoint queue latch | 3,113,914 | 0.00 | 0.57 | 2 | 89,463 | 0.00 |
client/application info | 968,803 | 0.00 | 0.00 | 0 | 0 | |
commit callback allocation | 492 | 0.00 | 0 | 0 | ||
compile environment latch | 208,717 | 0.00 | 0 | 0 | ||
dictionary lookup | 4 | 0.00 | 0 | 0 | ||
dml lock allocation | 180,822 | 0.02 | 0.00 | 0 | 0 | |
dummy allocation | 417,435 | 0.08 | 0.08 | 0 | 0 | |
enqueue hash chains | 1,871,315 | 0.32 | 0.02 | 0 | 481,035 | 0.01 |
enqueues | 2,161,584 | 0.31 | 0.00 | 0 | 0 | |
error message lists | 2,254 | 0.00 | 0 | 0 | ||
event group latch | 207,524 | 0.00 | 1.13 | 4 | 0 | |
file cache latch | 7,588 | 0.00 | 0 | 0 | ||
gcs opaque info freelist | 58,336 | 0.00 | 0.00 | 0 | 0 | |
gcs partitioned table hash | 5,652,638 | 0.00 | 0.00 | 0 | 4,688 | 0.00 |
gcs remastering latch | 1,813,249 | 0.00 | 0.02 | 0 | 0 | |
gcs resource freelist | 106,502 | 0.00 | 0 | 53,189 | 0.00 | |
gcs resource hash | 1,525,771 | 0.02 | 0.28 | 0 | 52 | 0.00 |
gcs resource scan list | 104 | 0.00 | 0 | 0 | ||
gcs shadows freelist | 106,457 | 0.00 | 0 | 64,702 | 0.00 | |
ges caches resource lists | 108,468 | 0.03 | 0.00 | 0 | 286,874 | 0.01 |
ges deadlock list | 1,636 | 0.00 | 0 | 18,319 | 0.00 | |
ges domain table | 458,107 | 0.00 | 0.00 | 0 | 0 | |
ges enqueue table freelist | 931,067 | 0.01 | 0.02 | 0 | 0 | |
ges group table | 600,899 | 0.03 | 0.00 | 0 | 0 | |
ges process hash list | 879,535 | 0.00 | 0 | 0 | ||
ges process parent latch | 2,050,521 | 0.00 | 0.00 | 0 | 6 | 0.00 |
ges process table freelist | 415,052 | 0.03 | 0.05 | 0 | 0 | |
ges resource hash list | 1,699,527 | 1.17 | 0.11 | 150 | 122,393 | 0.71 |
ges resource scan list | 127,252 | 0.73 | 0.00 | 0 | 0 | |
ges resource table freelist | 44,846 | 0.02 | 0.00 | 0 | 0 | |
ges synchronous data | 32 | 0.00 | 0 | 91,961 | 0.00 | |
ges timeout list | 18,610 | 0.03 | 0.00 | 0 | 28,988 | 0.00 |
global KZLD latch for mem in SGA | 241,205 | 0.00 | 0 | 0 | ||
global tx hash mapping | 309 | 0.00 | 0 | 0 | ||
hash table column usage latch | 1,287 | 0.00 | 0 | 461,915 | 0.00 | |
hash table modification latch | 430 | 0.00 | 0 | 0 | ||
interrupt manipulation | 5,515 | 0.00 | 0 | 0 | ||
job workq parent latch | 0 | 0 | 917 | 0.22 | ||
job_queue_processes parameter latch | 787 | 0.00 | 0 | 0 | ||
kks stats | 28,151 | 0.00 | 0 | 0 | ||
kmcptab latch | 2 | 0.00 | 0 | 0 | ||
kmcpvec latch | 0 | 0 | 2 | 0.00 | ||
kokc descriptor allocation latch | 27,886 | 0.00 | 0 | 0 | ||
ksuosstats global area | 1,528 | 0.13 | 1.00 | 0 | 0 | |
ksv instance | 18 | 0.00 | 0 | 0 | ||
ktm global data | 117 | 0.00 | 0 | 0 | ||
kwqbsn:qsga | 812 | 0.00 | 0 | 0 | ||
lgwr LWN SCN | 72,882 | 0.00 | 0 | 0 | ||
library cache | 9,395,720 | 0.19 | 0.04 | 132 | 17,278 | 0.02 |
library cache load lock | 1,722 | 0.00 | 0 | 0 | ||
library cache lock | 15,101,522 | 0.27 | 0.01 | 112 | 0 | |
library cache lock allocation | 502,075 | 0.01 | 0.04 | 0 | 0 | |
library cache pin | 2,505,361 | 0.05 | 0.01 | 0 | 0 | |
library cache pin allocation | 1,442 | 0.00 | 0 | 0 | ||
list of block allocation | 104,007 | 0.04 | 0.20 | 5 | 0 | |
loader state object freelist | 32,604 | 0.01 | 0.00 | 0 | 0 | |
logminer context allocation | 5 | 0.00 | 0 | 0 | ||
longop free list parent | 33 | 0.00 | 0 | 1 | 0.00 | |
message pool operations parent latch | 8,121 | 0.00 | 0 | 0 | ||
messages | 1,800,395 | 0.18 | 0.00 | 0 | 0 | |
mostly latch-free SCN | 73,583 | 0.21 | 0.00 | 0 | 0 | |
msg queue | 158 | 0.00 | 0 | 158 | 0.00 | |
multiblock read objects | 22,558 | 0.00 | 0 | 0 | ||
name-service memory objects | 103,450 | 0.00 | 0 | 0 | ||
name-service namespace bucket | 249,139 | 0.00 | 0 | 0 | ||
name-service pending queue | 47,654 | 0.00 | 0 | 0 | ||
name-service request | 48 | 0.00 | 0 | 0 | ||
name-service request queue | 289,467 | 0.00 | 0 | 0 | ||
ncodef allocation latch | 1,038 | 0.00 | 0 | 0 | ||
object queue header heap | 342,204 | 0.00 | 0 | 2,173 | 0.00 | |
object queue header operation | 916,010 | 0.00 | 0.45 | 2 | 0 | |
object stats modification | 11 | 0.00 | 0 | 0 | ||
parallel query alloc buffer | 14,208 | 0.00 | 0 | 0 | ||
parallel query stats | 2,132 | 0.00 | 0 | 0 | ||
parallel txn reco latch | 48,420 | 0.00 | 0 | 0 | ||
parameter list | 1,652,349 | 0.04 | 0.03 | 11 | 0 | |
parameter table management | 418,123 | 0.00 | 1.00 | 0 | 0 | |
post/wait queue | 162,320 | 0.05 | 0.00 | 0 | 67,873 | 0.00 |
process allocation | 608,407 | 3.15 | 1.48 | 308 | 206,592 | 0.45 |
process group creation | 415,052 | 0.03 | 0.03 | 0 | 0 | |
process queue | 5,756 | 0.00 | 0 | 0 | ||
process queue reference | 131,515 | 0.00 | 0.00 | 0 | 14,125 | 0.00 |
qmn state object latch | 2 | 0.00 | 0 | 0 | ||
qmn task queue latch | 3,328 | 0.00 | 0 | 0 | ||
query server freelists | 4,670 | 0.00 | 0 | 0 | ||
query server process | 8 | 0.00 | 0 | 8 | 0.00 | |
queued dump request | 112,265 | 0.00 | 0 | 0 | ||
redo allocation | 218,478 | 0.04 | 0.01 | 1 | 377,288 | 0.07 |
redo copy | 0 | 0 | 377,411 | 0.35 | ||
redo writing | 318,130 | 0.00 | 0.00 | 0 | 0 | |
resmgr group change latch | 174,818 | 0.00 | 0 | 0 | ||
resmgr:active threads | 417,101 | 0.00 | 0 | 0 | ||
resmgr:actses change group | 173,100 | 0.00 | 0 | 0 | ||
resmgr:free threads list | 417,096 | 0.21 | 0.08 | 25 | 0 | |
resmgr:resource group CPU method | 173,100 | 0.01 | 0.28 | 0 | 0 | |
resmgr:schema config | 5 | 0.00 | 0 | 0 | ||
row cache objects | 16,634,631 | 2.47 | 0.06 | 319 | 2,478 | 11.22 |
rules engine aggregate statistics | 44 | 0.00 | 0 | 0 | ||
rules engine rule set statistics | 588 | 0.00 | 0 | 0 | ||
segmented array pool | 98 | 0.00 | 0 | 0 | ||
sequence cache | 1,638,538 | 0.12 | 0.01 | 1 | 0 | |
session allocation | 3,271,713 | 1.05 | 0.08 | 32 | 0 | |
session idle bit | 10,763,814 | 0.00 | 0.01 | 0 | 0 | |
session state list latch | 417,553 | 0.04 | 0.02 | 0 | 0 | |
session switching | 1,038,677 | 0.03 | 0.01 | 0 | 0 | |
session timer | 21,791 | 0.00 | 0 | 0 | ||
shared pool | 5,740,224 | 0.35 | 0.05 | 223 | 0 | |
shared pool sim alloc | 11 | 0.00 | 0 | 0 | ||
shared pool simulator | 43,438 | 0.00 | 0.00 | 0 | 0 | |
simulator hash latch | 10,649,491 | 0.00 | 0.00 | 0 | 0 | |
simulator lru latch | 0 | 0 | 10,635,093 | 0.12 | ||
slave class | 713 | 0.00 | 0 | 0 | ||
slave class create | 4,998 | 0.18 | 1.00 | 1 | 0 | |
sort extent pool | 1,381 | 0.00 | 0 | 0 | ||
state object free list | 10 | 0.00 | 0 | 0 | ||
statistics aggregation | 2,800 | 0.00 | 0 | 0 | ||
temp lob duration state obj allocation | 6 | 0.00 | 0 | 0 | ||
threshold alerts latch | 4,142 | 0.00 | 0 | 0 | ||
transaction allocation | 6,918,095 | 0.00 | 0.00 | 0 | 0 | |
transaction branch allocation | 22,030 | 0.00 | 0 | 0 | ||
undo global data | 576,474 | 0.04 | 0.00 | 0 | 0 | |
user lock | 686,305 | 0.96 | 0.03 | 22 | 0 |
Latch Name | Get Requests | Misses | Sleeps | Spin Gets | Sleep1 | Sleep2 | Sleep3 |
---|---|---|---|---|---|---|---|
row cache objects | 16,634,631 | 411,523 | 25,937 | 386,363 | 0 | 0 | 0 |
cache buffers chains | 320,499,801 | 301,880 | 7,593 | 294,705 | 0 | 0 | 0 |
library cache lock | 15,101,522 | 40,197 | 547 | 39,734 | 0 | 0 | 0 |
session allocation | 3,271,713 | 34,453 | 2,625 | 31,983 | 0 | 0 | 0 |
shared pool | 5,740,224 | 19,975 | 980 | 19,090 | 0 | 0 | 0 |
ges resource hash list | 1,699,527 | 19,896 | 2,268 | 17,827 | 0 | 0 | 0 |
process allocation | 608,407 | 19,139 | 28,322 | 1,575 | 0 | 0 | 0 |
library cache | 9,395,720 | 17,916 | 664 | 17,320 | 0 | 0 | 0 |
enqueues | 2,161,584 | 6,743 | 18 | 6,727 | 0 | 0 | 0 |
user lock | 686,305 | 6,562 | 179 | 6,401 | 0 | 0 | 0 |
enqueue hash chains | 1,871,315 | 5,965 | 144 | 5,828 | 0 | 0 | 0 |
active service list | 1,023,358 | 3,637 | 323 | 3,336 | 0 | 0 | 0 |
messages | 1,800,395 | 3,251 | 10 | 3,242 | 0 | 0 | 0 |
sequence cache | 1,638,538 | 2,037 | 15 | 2,024 | 0 | 0 | 0 |
library cache pin | 2,505,361 | 1,292 | 9 | 1,283 | 0 | 0 | 0 |
ges resource scan list | 127,252 | 924 | 2 | 922 | 0 | 0 | 0 |
resmgr:free threads list | 417,096 | 871 | 71 | 808 | 0 | 0 | 0 |
KCL gc element parent latch | 831,541 | 866 | 70 | 804 | 0 | 0 | 0 |
parameter list | 1,652,349 | 671 | 19 | 654 | 0 | 0 | 0 |
OS process: request allocation | 415,052 | 542 | 114 | 442 | 0 | 0 | 0 |
channel operations parent latch | 3,751,327 | 513 | 14 | 499 | 0 | 0 | 0 |
OS process allocation | 425,253 | 355 | 15 | 340 | 0 | 0 | 0 |
gcs resource hash | 1,525,771 | 337 | 96 | 298 | 0 | 0 | 0 |
session switching | 1,038,677 | 335 | 2 | 333 | 0 | 0 | 0 |
dummy allocation | 417,435 | 332 | 26 | 308 | 0 | 0 | 0 |
undo global data | 576,474 | 214 | 1 | 213 | 0 | 0 | 0 |
session idle bit | 10,763,814 | 211 | 2 | 209 | 0 | 0 | 0 |
session state list latch | 417,553 | 167 | 3 | 164 | 0 | 0 | 0 |
ges enqueue table freelist | 931,067 | 113 | 2 | 111 | 0 | 0 | 0 |
process group creation | 415,052 | 109 | 3 | 107 | 0 | 0 | 0 |
ges process table freelist | 415,052 | 104 | 5 | 100 | 0 | 0 | 0 |
channel handle pool latch | 415,158 | 100 | 8 | 93 | 0 | 0 | 0 |
redo allocation | 218,478 | 79 | 1 | 78 | 0 | 0 | 0 |
gcs remastering latch | 1,813,249 | 59 | 1 | 58 | 0 | 0 | 0 |
ASM map operation hash table | 2,027,564 | 51 | 1 | 50 | 0 | 0 | 0 |
list of block allocation | 104,007 | 40 | 8 | 33 | 0 | 0 | 0 |
object queue header operation | 916,010 | 31 | 14 | 17 | 0 | 0 | 0 |
library cache lock allocation | 502,075 | 27 | 1 | 26 | 0 | 0 | 0 |
resmgr:resource group CPU method | 173,100 | 18 | 5 | 14 | 0 | 0 | 0 |
slave class create | 4,998 | 9 | 9 | 0 | 0 | 0 | 0 |
event group latch | 207,524 | 8 | 9 | 0 | 0 | 0 | 0 |
checkpoint queue latch | 3,113,914 | 7 | 4 | 3 | 0 | 0 | 0 |
ksuosstats global area | 1,528 | 2 | 2 | 0 | 0 | 0 | 0 |
KFMD SGA | 5,732 | 1 | 1 | 0 | 0 | 0 | 0 |
parameter table management | 418,123 | 1 | 1 | 0 | 0 | 0 | 0 |
Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
---|---|---|---|---|
ASM map operation hash table | kffmTranslate | 0 | 1 | 0 |
KCL gc element parent latch | kclnfndnewm | 0 | 43 | 1 |
KCL gc element parent latch | kclchkping | 0 | 41 | 0 |
KCL gc element parent latch | kclplz | 0 | 3 | 17 |
KCL gc element parent latch | KCLUNLNK | 0 | 2 | 3 |
KCL gc element parent latch | kclbla | 0 | 1 | 0 |
KCL gc element parent latch | kclzcl | 0 | 1 | 12 |
KFMD SGA | kfmdSlvJoinFetch | 0 | 1 | 0 |
OS process allocation | kso_new_process:2 | 0 | 7 | 7 |
OS process allocation | kso_delete_process:1 | 0 | 6 | 6 |
OS process allocation | ksosp_scrub:1 | 0 | 2 | 2 |
OS process: request allocation | kso_new_process | 0 | 83 | 72 |
OS process: request allocation | ksoreqholder_delete | 0 | 31 | 42 |
active service list | kswslogon: session logout | 0 | 1,542 | 1,430 |
active service list | kswslogon: session login | 0 | 158 | 98 |
active service list | kswsgsnp: get service name ptr | 0 | 15 | 186 |
active service list | kswssyis: find service entry 1 | 0 | 10 | 4 |
cache buffers chains | kcbgtcr: kslbegin excl | 0 | 21,571 | 9,432 |
cache buffers chains | kcbrls: kslbegin | 0 | 1,171 | 14,082 |
cache buffers chains | kcbgcur: kslbegin | 0 | 737 | 407 |
cache buffers chains | kcbgtcr: fast path | 0 | 624 | 66 |
cache buffers chains | kcbzwb | 0 | 261 | 219 |
cache buffers chains | kcbget: pin buffer | 0 | 127 | 98 |
cache buffers chains | kcbchg: kslbegin: bufs not pinned | 0 | 78 | 84 |
cache buffers chains | kcbchg: kslbegin: call CR func | 0 | 50 | 64 |
cache buffers chains | kcbsod1 | 0 | 32 | 68 |
cache buffers chains | kcbso1: set no access | 0 | 28 | 10 |
cache buffers chains | kcbgtcr | 0 | 26 | 27 |
cache buffers chains | kclbla | 0 | 24 | 3 |
cache buffers chains | kcbgcur: buf pinned | 0 | 19 | 18 |
cache buffers chains | kcbesc: escalate | 0 | 7 | 9 |
cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 6 | 0 |
cache buffers chains | kcbnlc | 0 | 5 | 39 |
cache buffers chains | kcbget: exchange | 0 | 1 | 25 |
cache buffers chains | kcbzib: finish free bufs | 0 | 1 | 11 |
cache buffers chains | kclebs_1 | 0 | 1 | 1 |
cache buffers chains | kclpto | 0 | 1 | 0 |
cache buffers chains | kclwcrs | 0 | 1 | 7 |
channel handle pool latch | ksrchconnect() | 0 | 9 | 2 |
channel handle pool latch | ksrchdelete() | 0 | 4 | 11 |
channel operations parent latch | ksrchdelete() | 0 | 40 | 37 |
channel operations parent latch | ksrsubscribe() | 0 | 1 | 2 |
checkpoint queue latch | kcbklbc: Link buffer into ckpt queue | 0 | 2 | 0 |
checkpoint queue latch | kcbbwthc: thread checkpoint buffers | 0 | 1 | 2 |
checkpoint queue latch | kcbkllrba: compute lowest lrba | 0 | 1 | 2 |
cost function | kzulrl | 0 | 103 | 116 |
cost function | kzulgt: find user res | 0 | 76 | 63 |
dummy allocation | ktcscnfy | 0 | 16 | 13 |
dummy allocation | ktcdod | 0 | 10 | 13 |
enqueue hash chains | ksqgtl3 | 0 | 137 | 138 |
enqueue hash chains | ksqrcl | 0 | 5 | 2 |
enqueue hash chains | ksqcmi: if lk mode requested | 0 | 2 | 3 |
enqueues | ksqgel: create enqueue | 0 | 10 | 1 |
enqueues | ksqdel | 0 | 5 | 6 |
enqueues | ksqies | 0 | 3 | 11 |
event group latch | ksdegi | 0 | 9 | 9 |
event range base latch | No latch | 0 | 99 | 38 |
gcs remastering latch | 69 | 0 | 1 | 0 |
gcs resource hash | kjbopen | 0 | 77 | 29 |
gcs resource hash | kjbcropen:affinity | 0 | 12 | 0 |
gcs resource hash | kjblocalfile_nolock | 0 | 2 | 0 |
gcs resource hash | kjbmpcreatepi | 0 | 2 | 0 |
gcs resource hash | kclzcl | 0 | 1 | 58 |
gcs resource hash | kjbassume | 0 | 1 | 0 |
gcs resource hash | kjbopen:affinity | 0 | 1 | 0 |
ges enqueue table freelist | kjlalc: lock allocation | 0 | 2 | 2 |
ges process table freelist | kjpfr: free process | 0 | 4 | 5 |
ges process table freelist | kjpalc: process allocation | 0 | 1 | 0 |
ges resource hash list | kjrmas1: lookup master node | 0 | 1,568 | 487 |
ges resource hash list | kjrref: find matched resource | 0 | 440 | 1,523 |
ges resource hash list | kjcvscn: remove from scan queue | 0 | 179 | 0 |
ges resource hash list | kjakcai: search for resp by resname | 0 | 30 | 24 |
ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 27 | 210 |
ges resource hash list | kjucvl: lock convert request | 0 | 16 | 24 |
ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 8 | 0 |
ges resource scan list | kjcvscn: traverse scan_q | 0 | 2 | 1 |
ksuosstats global area | ksugetosstat | 0 | 2 | 2 |
library cache | kglpndl: child: after processing | 0 | 172 | 24 |
library cache | kgldte: child 0 | 0 | 146 | 148 |
library cache | kglLockCursor | 0 | 102 | 15 |
library cache | kglhdgn: child: | 0 | 93 | 261 |
library cache | kglobpn: child: | 0 | 87 | 170 |
library cache | kglpndl: child: before processing | 0 | 49 | 43 |
library cache | kgldti: 2child | 0 | 6 | 0 |
library cache | kglati | 0 | 2 | 0 |
library cache lock | kgllkdl: child: cleanup | 0 | 356 | 318 |
library cache lock | kgllkal: child: multiinstance | 0 | 92 | 191 |
library cache lock | kgllkdl: child: no lock handle | 0 | 7 | 3 |
library cache lock allocation | kgllkget | 0 | 1 | 1 |
library cache pin | kglpndl | 0 | 6 | 5 |
library cache pin | kglpnal: child: alloc space | 0 | 3 | 4 |
list of block allocation | ktlabl | 0 | 8 | 8 |
messages | ksaamb: after wakeup | 0 | 6 | 7 |
messages | ksarcv | 0 | 3 | 2 |
messages | ksaclr | 0 | 1 | 0 |
object queue header operation | kcbo_switch_cq | 0 | 14 | 11 |
object queue header operation | kcbw_link_q | 0 | 2 | 1 |
object queue header operation | kcbw_unlink_q | 0 | 2 | 3 |
object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 0 |
parameter list | kmmsvcl | 0 | 19 | 19 |
parameter table management | kspcpy | 0 | 1 | 0 |
process allocation | ksucrp | 0 | 11,762 | 0 |
process allocation | ksuapc | 0 | 10,700 | 11,417 |
process allocation | ksudlp | 0 | 5,032 | 12,481 |
process allocation | ksufap: active procs | 0 | 828 | 4,424 |
process group creation | ksupgprem | 0 | 3 | 3 |
redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 1 | 0 |
resmgr:free threads list | kgskthrsod | 0 | 41 | 31 |
resmgr:free threads list | kgskthrcreate | 0 | 30 | 40 |
resmgr:resource group CPU method | kgkprrrem | 0 | 5 | 5 |
row cache objects | kqreqd: reget | 0 | 8,113 | 1,251 |
row cache objects | kqrigt | 0 | 7,425 | 20,641 |
row cache objects | kqrpre: find obj | 0 | 6,808 | 1,760 |
row cache objects | kqreqd | 0 | 3,380 | 2,120 |
row cache objects | kqrbgl | 0 | 78 | 100 |
row cache objects | kqrpre: init complete | 0 | 43 | 4 |
row cache objects | kqrbtm: pop parent | 0 | 24 | 29 |
row cache objects | kqrbip | 0 | 21 | 0 |
row cache objects | kqrso | 0 | 13 | 0 |
row cache objects | ksucallcbksafely: kqrhngc | 0 | 13 | 0 |
row cache objects | kqrbpr: got immediately | 0 | 9 | 4 |
row cache objects | kqrcmt: while loop | 0 | 5 | 4 |
row cache objects | kqrpup | 0 | 4 | 0 |
row cache objects | kqrbpr: KQRRSNRL | 0 | 1 | 16 |
sequence cache | kdnnxt: cached seq | 0 | 10 | 0 |
sequence cache | kdnssd | 0 | 3 | 0 |
sequence cache | kdnss | 0 | 2 | 15 |
session allocation | ksuxds: KSUSFCLC not set | 0 | 1,947 | 605 |
session allocation | ksucri | 0 | 269 | 838 |
session allocation | ksudlp | 0 | 227 | 599 |
session allocation | ksuxds: not user session | 0 | 129 | 319 |
session allocation | ksucrp | 0 | 34 | 263 |
session allocation | ksufap: active sessions | 0 | 19 | 0 |
session idle bit | ksupuc: clear busy | 0 | 1 | 1 |
session idle bit | ksupuc: set busy | 0 | 1 | 1 |
session state list latch | kpseqa | 0 | 3 | 3 |
session switching | kskexeall | 0 | 2 | 2 |
shared pool | kghalo | 0 | 727 | 659 |
shared pool | kghfre | 0 | 207 | 282 |
shared pool | kghupr1 | 0 | 38 | 32 |
shared pool | kghalp | 0 | 4 | 4 |
shared pool | kghfrunp: alloc: cursor dur | 0 | 3 | 0 |
shared pool | kghfree_extents: scan | 0 | 1 | 3 |
slave class create | ksvcreate | 0 | 8 | 0 |
slave class create | ksvgetwork1 | 0 | 1 | 1 |
undo global data | ktusmofu: KSLBEGIN | 0 | 1 | 1 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE_CONTENT_RELATION | TABLE | 33,296,656 | 16.71 | |
WCITY2 | WCITY2_INDEX | PK_TB_ARTICLE_DESC | INDEX | 31,433,648 | 15.78 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE_DESC | TABLE | 30,033,952 | 15.08 | |
WCITY2 | WCITY2_INDEX | PK_TB_ARTICLE | INDEX | 18,294,528 | 9.18 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 15,270,256 | 7.67 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 93,517 | 51.90 | |
WCITY2 | WCITY2_INDEX | PK_TB_PORTAL_USER | INDEX | 4,167 | 2.31 | |
SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | 263338_538 | TABLE PARTITION | 1,412 | 0.78 |
WCITY2 | WCITY2_DATA | TB_ACCESS_TOKEN | TABLE | 553 | 0.31 | |
SYS | SYSAUX | WRH$_SQL_PLAN | TABLE | 76 | 0.04 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 73 | 60.83 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 41 | 34.17 | |
WCITY2 | WCITY2_INDEX | INDEX_TB_A_C_R_COLUMN_ID | INDEX | 2 | 1.67 | |
WCITY2 | WCITY2_INDEX | PK_TB_ACCESS_TOKEN | INDEX | 2 | 1.67 | |
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 2 | 1.67 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 21 | 52.50 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 19 | 47.50 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 322 | 46.20 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 146 | 20.95 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 113 | 16.21 | |
SYS | SYSTEM | SEG$ | TABLE | 34 | 4.88 | |
WCITY2 | WCITY2_DATA | TB_AUTH_LOG | TABLE | 17 | 2.44 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 427 | 34.91 | |
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 302 | 24.69 | |
SYS | SYSTEM | UNDO$ | TABLE | 196 | 16.03 | |
SYS | SYSTEM | I_UNDO1 | INDEX | 159 | 13.00 | |
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 60 | 4.91 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_DATA | TB_ARTICLE | TABLE | 3,656 | 17.78 | |
WCITY2 | WCITY2_DATA | TB_ACCESS_TOKEN | TABLE | 2,147 | 10.44 | |
SYS | SYSTEM | JOB$ | TABLE | 1,987 | 9.66 | |
WCITY2 | WCITY2_INDEX | PK_TB_PORTAL_USER | INDEX | 1,914 | 9.31 | |
SYS | SYSTEM | SEQ$ | TABLE | 1,618 | 7.87 |
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
---|---|---|---|---|---|---|
WCITY2 | WCITY2_INDEX | ACCOUNT_INTERFACE_LOG_ID | INDEX | 8,748 | 28.38 | |
WCITY2 | WCITY2_INDEX | PK_TB_AUTH_LOG2 | INDEX | 8,177 | 26.53 | |
WCITY2 | WCITY2_DATA | TB_ACCOUNT_INTERFACE_LOG | TABLE | 1,997 | 6.48 | |
SYS | SYSTEM | SEQ$ | TABLE | 1,994 | 6.47 | |
WCITY2 | WCITY2_DATA | TB_ACCESS_TOKEN | TABLE | 1,098 | 3.56 |
Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
---|---|---|---|---|---|---|
dc_awr_control | 421 | 0.71 | 0 | 6 | 1 | |
dc_database_links | 413,307 | 0.00 | 0 | 0 | 4 | |
dc_global_oids | 20,006 | 0.05 | 0 | 0 | 123 | |
dc_histogram_data | 180,351 | 0.29 | 0 | 0 | 2,259 | |
dc_histogram_defs | 86,751 | 1.88 | 0 | 0 | 2,259 | |
dc_object_grants | 254 | 10.63 | 0 | 0 | 33 | |
dc_object_ids | 165,697 | 0.17 | 0 | 0 | 1,437 | |
dc_objects | 262,997 | 0.17 | 0 | 10 | 804 | |
dc_profiles | 171,746 | 0.00 | 0 | 0 | 1 | |
dc_rollback_segments | 562,662 | 0.46 | 0 | 921 | 688 | |
dc_segments | 69,299 | 0.79 | 0 | 661 | 3,635 | |
dc_sequences | 12,238 | 18.64 | 0 | 12,238 | 17 | |
dc_tablespace_quotas | 32 | 21.88 | 0 | 32 | 0 | |
dc_tablespaces | 180,283 | 0.00 | 0 | 0 | 25 | |
dc_usernames | 763,064 | 0.00 | 0 | 0 | 57 | |
dc_users | 3,496,814 | 0.00 | 0 | 0 | 74 | |
outstanding_alerts | 1,898 | 93.73 | 0 | 44 | 48 |
Cache | GES Requests | GES Conflicts | GES Releases |
---|---|---|---|
dc_awr_control | 15 | 3 | 0 |
dc_global_oids | 10 | 0 | 0 |
dc_histogram_defs | 1,628 | 0 | 1,909 |
dc_object_ids | 300 | 0 | 11 |
dc_objects | 474 | 5 | 311 |
dc_rollback_segments | 69,192 | 2,296 | 0 |
dc_segments | 1,865 | 28 | 0 |
dc_sequences | 24,466 | 2,277 | 0 |
dc_tablespace_quotas | 64 | 8 | 0 |
dc_usernames | 2 | 0 | 0 |
outstanding_alerts | 3,724 | 1,761 | 0 |
Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
---|---|---|---|---|---|---|
BODY | 3,315 | 0.15 | 5,378 | 0.13 | 2 | 0 |
CLUSTER | 67 | 1.49 | 101 | 0.99 | 0 | 0 |
INDEX | 44 | 40.91 | 119 | 15.97 | 1 | 0 |
JAVA DATA | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
JAVA RESOURCE | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
JAVA SOURCE | 3 | 100.00 | 3 | 100.00 | 0 | 0 |
SQL AREA | 1,322,284 | 0.84 | 3,539,484 | 0.92 | 7,662 | 9 |
TABLE/PROCEDURE | 83,120 | 0.31 | 880,970 | 0.09 | 177 | 0 |
TRIGGER | 381 | 1.57 | 627 | 0.96 | 0 | 0 |
Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
---|---|---|---|---|---|
CLUSTER | 101 | 1 | 0 | 1 | 0 |
INDEX | 119 | 27 | 4 | 21 | 0 |
JAVA DATA | 3 | 3 | 0 | 0 | 0 |
JAVA RESOURCE | 3 | 3 | 0 | 0 | 0 |
JAVA SOURCE | 3 | 3 | 0 | 0 | 0 |
TABLE/PROCEDURE | 44,296 | 266 | 68 | 124 | 0 |
TRIGGER | 3 | 6 | 1 | 3 | 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 | 824.40 | 0.65 | 1.14 | 13 | 13 | 1,270 | 1,270 | |
Freeable | 41.06 | 0.00 | 0.95 | 0.81 | 5 | 43 | 43 | ||
SQL | 2.86 | 1.75 | 0.00 | 0.01 | 0 | 4 | 1,233 | 534 | |
PL/SQL | 2.69 | 0.41 | 0.00 | 0.00 | 0 | 0 | 1,268 | 1,266 | |
E | Other | 815.38 | 0.67 | 1.17 | 13 | 13 | 1,218 | 1,218 | |
Freeable | 60.06 | 0.00 | 0.92 | 0.63 | 5 | 65 | 65 | ||
PL/SQL | 2.63 | 0.45 | 0.00 | 0.00 | 0 | 0 | 1,216 | 1,214 | |
SQL | 2.45 | 1.44 | 0.00 | 0.01 | 0 | 5 | 1,181 | 536 |
SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
---|---|---|
Database Buffers | 30,769,414,144 | |
Fixed Size | 2,159,376 | |
Redo Buffers | 14,614,528 | |
Variable Size | 3,573,550,320 |
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 | 128.42 | 134.20 | 4.50 |
shared | PCursor | 105.52 | 106.67 | 1.09 |
shared | db_block_hash_buckets | 180.00 | 180.00 | 0.00 |
shared | free memory | 714.22 | 630.00 | -11.79 |
shared | gcs resources | 690.04 | 690.04 | 0.00 |
shared | gcs shadows | 370.55 | 370.55 | 0.00 |
shared | kglsim object batch | 50.14 | 50.16 | 0.04 |
shared | library cache | 89.53 | 89.68 | 0.17 |
shared | sql area | 606.12 | 680.13 | 12.21 |
streams | free memory | 16.00 | 16.00 | 0.00 |
buffer_cache | 29,344.00 | 29,344.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 Coordinator | 69,990 | 0 | 0 |
QMON Slaves | 12,998 | 0 | 0 |
Ruleset Name | Evals | Fast Evals | SQL Execs | CPU Time | Elapsed Time |
---|---|---|---|---|---|
SYS.ALERT_QUE_R | 44 | 0 | 0 | 1 | 0 |
Resource Name | Current Utilization | Maximum Utilization | Initial Allocation | Limit |
---|---|---|---|---|
ges_procs | 1,227 | 1,657 | 2001 | 2001 |
processes | 1,228 | 1,659 | 2000 | 2000 |
sessions | 1,236 | 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 | |
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) | 62,749 | 2.75 | 0.77 |
acks for commit broadcast(logical) | 63,948 | 2.81 | 0.79 |
broadcast msgs on commit(actual) | 72,247 | 3.17 | 0.89 |
broadcast msgs on commit(logical) | 72,322 | 3.18 | 0.89 |
broadcast msgs on commit(wasted) | 2,463 | 0.11 | 0.03 |
broadcast on commit wait time(ms) | 17,873 | 0.78 | 0.22 |
broadcast on commit waits | 69,747 | 3.06 | 0.86 |
dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
false posts waiting for scn acks | 1 | 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 | 17,682 | 0.78 | 0.22 |
gcs ast xid | 12 | 0.00 | 0.00 |
gcs blocked converts | 19,982 | 0.88 | 0.25 |
gcs blocked cr converts | 19,943 | 0.88 | 0.25 |
gcs compatible basts | 9 | 0.00 | 0.00 |
gcs compatible cr basts (global) | 1,312 | 0.06 | 0.02 |
gcs compatible cr basts (local) | 9,460 | 0.42 | 0.12 |
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,610 | 0.07 | 0.02 |
gcs dbwr write request msgs | 1,458 | 0.06 | 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 | 3,241 | 0.14 | 0.04 |
gcs immediate (null) converts | 13,876 | 0.61 | 0.17 |
gcs immediate cr (compatible) converts | 0 | 0.00 | 0.00 |
gcs immediate cr (null) converts | 45,788 | 2.01 | 0.56 |
gcs indirect ast | 61,686 | 2.71 | 0.76 |
gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
gcs lms write request msgs | 522 | 0.02 | 0.01 |
gcs msgs process time(ms) | 25,483 | 1.12 | 0.31 |
gcs msgs received | 473,744 | 20.80 | 5.82 |
gcs out-of-order msgs | 0 | 0.00 | 0.00 |
gcs pings refused | 29 | 0.00 | 0.00 |
gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
gcs queued converts | 34 | 0.00 | 0.00 |
gcs recovery claim msgs | 0 | 0.00 | 0.00 |
gcs refuse xid | 7 | 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 | 26,404 | 1.16 | 0.32 |
gcs side channel msgs logical | 54,762 | 2.40 | 0.67 |
gcs stale cr | 9,672 | 0.42 | 0.12 |
gcs undo cr | 4,462 | 0.20 | 0.05 |
gcs write notification msgs | 77 | 0.00 | 0.00 |
gcs writes refused | 15 | 0.00 | 0.00 |
ges msgs process time(ms) | 3,313 | 0.15 | 0.04 |
ges msgs received | 185,827 | 8.16 | 2.28 |
global posts dropped | 0 | 0.00 | 0.00 |
global posts queue time | 57 | 0.00 | 0.00 |
global posts queued | 44 | 0.00 | 0.00 |
global posts requested | 44 | 0.00 | 0.00 |
global posts sent | 44 | 0.00 | 0.00 |
implicit batch messages received | 25,862 | 1.14 | 0.32 |
implicit batch messages sent | 22,634 | 0.99 | 0.28 |
lmd msg send time(ms) | 0 | 0.00 | 0.00 |
lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
messages flow controlled | 92,976 | 4.08 | 1.14 |
messages queue sent actual | 278,711 | 12.24 | 3.43 |
messages queue sent logical | 337,103 | 14.80 | 4.14 |
messages received actual | 481,470 | 21.14 | 5.92 |
messages received logical | 659,571 | 28.96 | 8.11 |
messages sent directly | 84,253 | 3.70 | 1.04 |
messages sent indirectly | 159,253 | 6.99 | 1.96 |
messages sent not implicit batched | 256,076 | 11.24 | 3.15 |
messages sent pbatched | 307,611 | 13.50 | 3.78 |
msgs causing lmd to send msgs | 75,389 | 3.31 | 0.93 |
msgs causing lms(s) to send msgs | 13,631 | 0.60 | 0.17 |
msgs received queue time (ms) | 144,298 | 6.33 | 1.77 |
msgs received queued | 659,571 | 28.96 | 8.11 |
msgs sent queue time (ms) | 57,266 | 2.51 | 0.70 |
msgs sent queue time on ksxp (ms) | 116,532 | 5.12 | 1.43 |
msgs sent queued | 336,231 | 14.76 | 4.13 |
msgs sent queued on ksxp | 432,816 | 19.00 | 5.32 |
number of ges deadlock detected | 0 | 0.00 | 0.00 |
process batch messages received | 136,837 | 6.01 | 1.68 |
process batch messages sent | 185,161 | 8.13 | 2.28 |
Statistic | Total |
---|---|
CR Block Requests | 22,357 |
CURRENT Block Requests | 6,338 |
Data Block Requests | 22,357 |
Undo Block Requests | 22 |
TX Block Requests | 5,600 |
Current Results | 28,390 |
Private results | 1 |
Zero Results | 303 |
Disk Read Results | 0 |
Fail Results | 0 |
Fairness Down Converts | 2,129 |
Fairness Clears | 0 |
Free GC Elements | 0 |
Flushes | 505 |
Flushes Queued | 0 |
Flush Queue Full | 0 |
Flush Max Time (us) | 0 |
Light Works | 32 |
Errors | 0 |
Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
---|---|---|---|---|---|---|
Pins | 56,288 | 99.25 | 0.14 | 0.60 | 0.01 | 0.00 |
Flushes | 501 | 80.04 | 13.97 | 3.79 | 2.00 | 0.20 |
Writes | 2,103 | 71.28 | 26.58 | 0.57 | 0.67 | 0.90 |
CR | Current | ||||||||
---|---|---|---|---|---|---|---|---|---|
Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
1 | data block | 15,872 | 95.55 | 2.87 | 1.59 | 29,350 | 98.05 | 1.88 | 0.07 |
1 | undo header | 4,274 | 99.46 | 0.54 | 0.00 | 664 | 85.39 | 14.61 | 0.00 |
1 | Others | 385 | 97.14 | 2.86 | 0.00 | 354 | 97.18 | 2.82 | 0.00 |
1 | undo block | 29 | 100.00 | 0.00 | 0.00 | 459 | 100.00 | 0.00 | 0.00 |