| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| CC | 2038674490 | cc1 | 1 | 02-Sep-15 02:09 | 11.2.0.4.0 | YES |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| PRQMRAC01 | Linux x86 64-bit | 32 | 16 | 2 | 126.00 |
| Snap Id | Snap Time | Sessions | Cursors/Session | Instances | |
|---|---|---|---|---|---|
| Begin Snap: | 16465 | 08-Sep-15 18:00:54 | 131 | 4.1 | 2 |
| End Snap: | 16466 | 08-Sep-15 19:00:01 | 124 | 4.2 | 2 |
| Elapsed: | 59.11 (mins) | ||||
| DB Time: | 435.38 (mins) |
| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 7.4 | 0.2 | 0.01 | 0.01 |
| DB CPU(s): | 5.0 | 0.1 | 0.01 | 0.01 |
| Redo size (bytes): | 595,257.9 | 13,090.6 | ||
| Logical read (blocks): | 1,810,934.4 | 39,825.2 | ||
| Block changes: | 4,026.4 | 88.6 | ||
| Physical read (blocks): | 141,569.7 | 3,113.3 | ||
| Physical write (blocks): | 266.6 | 5.9 | ||
| Read IO requests: | 1,410.6 | 31.0 | ||
| Write IO requests: | 103.4 | 2.3 | ||
| Read IO (MB): | 1,106.0 | 24.3 | ||
| Write IO (MB): | 2.1 | 0.1 | ||
| Global Cache blocks received: | 30.3 | 0.7 | ||
| Global Cache blocks served: | 4.2 | 0.1 | ||
| User calls: | 687.4 | 15.1 | ||
| Parses (SQL): | 475.4 | 10.5 | ||
| Hard parses (SQL): | 50.7 | 1.1 | ||
| SQL Work Area (MB): | 3.2 | 0.1 | ||
| Logons: | 0.2 | 0.0 | ||
| Executes (SQL): | 554.3 | 12.2 | ||
| Rollbacks: | 0.0 | 0.0 | ||
| Transactions: | 45.5 |
| Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
| Library Hit %: | 80.74 | Soft Parse %: | 89.35 |
| Execute to Parse %: | 14.24 | Latch Hit %: | 99.29 |
| Parse CPU to Parse Elapsd %: | 67.80 | % Non-Parse CPU: | 99.19 |
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| DB CPU | 17.8K | 68.0 | |||
| db file sequential read | 585,941 | 4154.9 | 7 | 15.9 | User I/O |
| direct path read | 2,693,533 | 2935 | 1 | 11.2 | User I/O |
| log file sync | 161,114 | 897.8 | 6 | 3.4 | Commit |
| gc cr block busy | 17,714 | 70.3 | 4 | .3 | Cluster |
| gc buffer busy acquire | 8,725 | 27.5 | 3 | .1 | Cluster |
| reliable message | 8,764 | 19.6 | 2 | .1 | Other |
| gc current block 2-way | 46,009 | 18.4 | 0 | .1 | Cluster |
| gc cr block 2-way | 35,906 | 16.3 | 0 | .1 | Cluster |
| enq: KO - fast object checkpoint | 19,372 | 10.2 | 1 | .0 | Application |
| Wait Class | Waits | Total Wait Time (sec) | Avg Wait (ms) | % DB time | Avg Active Sessions |
|---|---|---|---|---|---|
| DB CPU | 17,752 | 68.0 | 5.0 | ||
| User I/O | 3,667,584 | 7,315 | 2 | 28.0 | 2.1 |
| System I/O | 835,061 | 1,174 | 1 | 4.5 | 0.3 |
| Commit | 161,121 | 898 | 6 | 3.4 | 0.3 |
| Cluster | 119,668 | 138 | 1 | .5 | 0.0 |
| Other | 191,352 | 41 | 0 | .2 | 0.0 |
| Application | 24,580 | 15 | 1 | .1 | 0.0 |
| Network | 2,408,860 | 3 | 0 | .0 | 0.0 |
| Concurrency | 45,419 | 3 | 0 | .0 | 0.0 |
| Configuration | 22 | 0 | 17 | .0 | 0.0 |
| CPUs | Cores | Sockets | Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|---|---|---|
| 32 | 16 | 2 | 7.07 | 4.24 | 16.0 | 1.2 | 4.4 | 82.6 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 16.0 | 92.0 | 0.0 |
| Read+Write Per Second | Read per Second | Write Per Second | |
|---|---|---|---|
| Total Requests: | 1,626.2 | 1,414.5 | 211.7 |
| Database Requests: | 1,514.0 | 1,410.6 | 103.4 |
| Optimized Requests: | 0.0 | 0.0 | 0.0 |
| Redo Requests: | 97.8 | 0.7 | 97.2 |
| Total (MB): | 1,112.9 | 1,106.7 | 6.2 |
| Database (MB): | 1,108.1 | 1,106.0 | 2.1 |
| Optimized Total (MB): | 0.0 | 0.0 | 0.0 |
| Redo (MB): | 1.9 | 0.7 | 1.2 |
| Database (blocks): | 141,836.4 | 141,569.7 | 266.6 |
| Via Buffer Cache (blocks): | 438.0 | 171.7 | 266.3 |
| Direct (blocks): | 141,398.4 | 141,398.1 | 0.3 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 129,024.0 | 129,024.0 |
| SGA use (MB): | 18,160.3 | 18,160.3 |
| PGA use (MB): | 693.5 | 677.1 |
| % Host Mem used for SGA+PGA: | 14.61 | 14.60 |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 12,288M | 12,288M | Std Block Size: | 8K |
| Shared Pool Size: | 3,688M | 3,687M | Log Buffer: | 309,368K |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 92.89 | 92.87 |
| % SQL with executions>1: | 66.93 | 66.59 |
| % Memory for SQL w/exec>1: | 62.53 | 54.78 |
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| sql execute elapsed time | 24,997.74 | 95.69 |
| DB CPU | 17,752.16 | 67.96 |
| parse time elapsed | 223.15 | 0.85 |
| hard parse elapsed time | 140.34 | 0.54 |
| PL/SQL execution elapsed time | 13.47 | 0.05 |
| sequence load elapsed time | 1.06 | 0.00 |
| repeated bind elapsed time | 0.66 | 0.00 |
| connection management call elapsed time | 0.35 | 0.00 |
| failed parse elapsed time | 0.11 | 0.00 |
| hard parse (sharing criteria) elapsed time | 0.05 | 0.00 |
| DB time | 26,122.53 | |
| background elapsed time | 1,769.28 | |
| background cpu time | 348.08 |
| Statistic | Value | End Value |
|---|---|---|
| BUSY_TIME | 1,967,975 | |
| IDLE_TIME | 9,332,176 | |
| IOWAIT_TIME | 493,445 | |
| NICE_TIME | 1 | |
| SYS_TIME | 135,824 | |
| USER_TIME | 1,813,103 | |
| LOAD | 7 | 4 |
| RSRC_MGR_CPU_WAIT_TIME | 0 | |
| PHYSICAL_MEMORY_BYTES | 135,291,449,344 | |
| NUM_CPUS | 32 | |
| NUM_CPU_CORES | 16 | |
| NUM_CPU_SOCKETS | 2 | |
| GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
| GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
| TCP_RECEIVE_SIZE_DEFAULT | 262,144 | |
| TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
| TCP_RECEIVE_SIZE_MIN | 4,096 | |
| TCP_SEND_SIZE_DEFAULT | 262,144 | |
| TCP_SEND_SIZE_MAX | 262,144 | |
| TCP_SEND_SIZE_MIN | 4,096 |
| Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
|---|---|---|---|---|---|---|
| 08-Sep 18:00:54 | 7.07 | |||||
| 08-Sep 19:00:01 | 4.24 | 17.42 | 16.04 | 1.20 | 82.58 | 4.37 |
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
|---|---|---|---|---|---|
| DB CPU | 17,752 | 67.96 | |||
| User I/O | 3,280,445 | 0 | 7,094 | 2 | 27.15 |
| Commit | 161,114 | 0 | 898 | 6 | 3.44 |
| Cluster | 116,577 | 0 | 136 | 1 | 0.52 |
| Other | 32,584 | 39 | 25 | 1 | 0.10 |
| Application | 20,565 | 0 | 10 | 1 | 0.04 |
| Network | 2,408,647 | 0 | 3 | 0 | 0.01 |
| Concurrency | 6,507 | 0 | 1 | 0 | 0.00 |
| Configuration | 19 | 63 | 0 | 20 | 0.00 |
| System I/O | 332 | 0 | 0 | 0 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| db file sequential read | 585,941 | 0 | 4,155 | 7 | 3.63 | 15.91 |
| direct path read | 2,693,533 | 0 | 2,935 | 1 | 16.70 | 11.24 |
| log file sync | 161,114 | 0 | 898 | 6 | 1.00 | 3.44 |
| gc cr block busy | 17,714 | 0 | 70 | 4 | 0.11 | 0.27 |
| gc buffer busy acquire | 8,725 | 0 | 27 | 3 | 0.05 | 0.11 |
| reliable message | 8,764 | 0 | 20 | 2 | 0.05 | 0.08 |
| gc current block 2-way | 46,009 | 0 | 18 | 0 | 0.29 | 0.07 |
| gc cr block 2-way | 35,906 | 0 | 16 | 0 | 0.22 | 0.06 |
| enq: KO - fast object checkpoint | 19,372 | 0 | 10 | 1 | 0.12 | 0.04 |
| db file scattered read | 335 | 0 | 3 | 8 | 0.00 | 0.01 |
| SQL*Net message to client | 2,387,203 | 0 | 2 | 0 | 14.80 | 0.01 |
| enq: PS - contention | 536 | 2 | 2 | 4 | 0.00 | 0.01 |
| gc current grant busy | 3,451 | 0 | 1 | 0 | 0.02 | 0.01 |
| name-service call wait | 15 | 0 | 1 | 74 | 0.00 | 0.00 |
| read by other session | 123 | 0 | 1 | 6 | 0.00 | 0.00 |
| rdbms ipc reply | 4,431 | 0 | 1 | 0 | 0.03 | 0.00 |
| gc cr grant 2-way | 1,949 | 0 | 1 | 0 | 0.01 | 0.00 |
| DFS lock handle | 602 | 0 | 1 | 1 | 0.00 | 0.00 |
| gc current block busy | 137 | 0 | 1 | 4 | 0.00 | 0.00 |
| SQL*Net more data from client | 21,407 | 0 | 0 | 0 | 0.13 | 0.00 |
| row cache lock | 1,840 | 0 | 0 | 0 | 0.01 | 0.00 |
| PX Deq: Slave Session Stats | 1,412 | 0 | 0 | 0 | 0.01 | 0.00 |
| log file switch completion | 7 | 0 | 0 | 51 | 0.00 | 0.00 |
| gc current block congested | 830 | 0 | 0 | 0 | 0.01 | 0.00 |
| gc buffer busy release | 29 | 0 | 0 | 12 | 0.00 | 0.00 |
| gc cr multi block request | 355 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc cr block congested | 636 | 0 | 0 | 0 | 0.00 | 0.00 |
| os thread startup | 5 | 0 | 0 | 49 | 0.00 | 0.00 |
| gc current grant 2-way | 746 | 0 | 0 | 0 | 0.00 | 0.00 |
| buffer busy waits | 1,913 | 0 | 0 | 0 | 0.01 | 0.00 |
| kupp process wait | 2 | 100 | 0 | 101 | 0.00 | 0.00 |
| enq: IV - contention | 297 | 7 | 0 | 1 | 0.00 | 0.00 |
| SQL*Net message from dblink | 19 | 0 | 0 | 9 | 0.00 | 0.00 |
| library cache pin | 418 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: SV - contention | 377 | 0 | 0 | 0 | 0.00 | 0.00 |
| control file sequential read | 332 | 0 | 0 | 0 | 0.00 | 0.00 |
| IPC send completion sync | 551 | 0 | 0 | 0 | 0.00 | 0.00 |
| db file parallel read | 2 | 0 | 0 | 56 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 1,004 | 0 | 0 | 0 | 0.01 | 0.00 |
| enq: CR - block range reuse ckpt | 7 | 0 | 0 | 14 | 0.00 | 0.00 |
| PX Deq: reap credit | 12,707 | 100 | 0 | 0 | 0.08 | 0.00 |
| enq: UL - contention | 3 | 0 | 0 | 30 | 0.00 | 0.00 |
| library cache lock | 189 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch free | 89 | 0 | 0 | 1 | 0.00 | 0.00 |
| SQL*Net break/reset to client | 1,156 | 0 | 0 | 0 | 0.01 | 0.00 |
| enq: TX - row lock contention | 16 | 0 | 0 | 4 | 0.00 | 0.00 |
| latch: cache buffers chains | 1,883 | 0 | 0 | 0 | 0.01 | 0.00 |
| direct path write | 20 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: TQ - DDL contention | 2 | 0 | 0 | 21 | 0.00 | 0.00 |
| PX Deq: Signal ACK EXT | 908 | 0 | 0 | 0 | 0.01 | 0.00 |
| enq: RO - fast object reuse | 13 | 0 | 0 | 2 | 0.00 | 0.00 |
| undo segment extension | 4 | 100 | 0 | 5 | 0.00 | 0.00 |
| gc current multi block request | 51 | 0 | 0 | 0 | 0.00 | 0.00 |
| Disk file operations I/O | 138 | 0 | 0 | 0 | 0.00 | 0.00 |
| CRS call completion | 4 | 0 | 0 | 3 | 0.00 | 0.00 |
| cursor: pin S | 25 | 0 | 0 | 0 | 0.00 | 0.00 |
| KJC: Wait for msg sends to complete | 664 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr grant congested | 27 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: FB - contention | 16 | 0 | 0 | 0 | 0.00 | 0.00 |
| library cache: mutex X | 172 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: shared pool | 39 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS initialization | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: HW - contention | 8 | 100 | 0 | 0 | 0.00 | 0.00 |
| gc current grant congested | 9 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TS - contention | 6 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: ges resource hash list | 27 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS operation: action | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
| utl_file I/O | 345 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 19 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: TX - index contention | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TM - contention | 5 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: row cache objects | 17 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr disk read | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: PI - contention | 3 | 100 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message from client | 2,387,208 | 0 | 207,964 | 87 | 14.80 | |
| wait for unread message on broadcast channel | 959 | 45 | 578 | 603 | 0.01 | |
| jobq slave wait | 720 | 100 | 361 | 501 | 0.00 | |
| PL/SQL lock timer | 32 | 100 | 3 | 106 | 0.00 | |
| PX Deq: Execution Msg | 2,208 | 0 | 2 | 1 | 0.01 | |
| PX Deq: Join ACK | 1,004 | 0 | 1 | 1 | 0.01 | |
| PX Deq: Parse Reply | 1,004 | 0 | 1 | 1 | 0.01 | |
| PX Deq: Execute Reply | 1,004 | 0 | 0 | 0 | 0.01 | |
| single-task message | 1 | 0 | 0 | 108 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| db file parallel write | 336,238 | 0 | 649 | 2 | 2.09 | 36.67 |
| log file parallel write | 151,483 | 0 | 505 | 3 | 0.94 | 28.52 |
| db file sequential read | 340,137 | 0 | 165 | 0 | 2.11 | 9.35 |
| direct path read | 14,372 | 0 | 44 | 3 | 0.09 | 2.48 |
| Datapump dump file I/O | 31,782 | 0 | 9 | 0 | 0.20 | 0.53 |
| log file sequential read | 1,087 | 0 | 7 | 6 | 0.01 | 0.39 |
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100 | 7 | 6600 | 0.00 | 0.37 |
| control file sequential read | 11,287 | 0 | 5 | 0 | 0.07 | 0.29 |
| enq: KO - fast object checkpoint | 4,013 | 0 | 5 | 1 | 0.02 | 0.27 |
| control file parallel write | 1,810 | 0 | 5 | 3 | 0.01 | 0.27 |
| Log archive I/O | 1,740 | 0 | 3 | 2 | 0.01 | 0.20 |
| reliable message | 294 | 1 | 2 | 8 | 0.00 | 0.13 |
| gcs log flush sync | 579 | 2 | 2 | 3 | 0.00 | 0.11 |
| db file scattered read | 302 | 0 | 2 | 6 | 0.00 | 0.10 |
| ges inquiry response | 3,677 | 0 | 2 | 0 | 0.02 | 0.09 |
| ASM file metadata operation | 1,986 | 0 | 1 | 1 | 0.01 | 0.07 |
| os thread startup | 40 | 0 | 1 | 22 | 0.00 | 0.05 |
| library cache lock | 108 | 0 | 1 | 6 | 0.00 | 0.04 |
| direct path sync | 2 | 0 | 0 | 231 | 0.00 | 0.03 |
| gc current block 2-way | 1,168 | 0 | 0 | 0 | 0.01 | 0.02 |
| DFS lock handle | 868 | 100 | 0 | 0 | 0.01 | 0.02 |
| name-service call wait | 8 | 0 | 0 | 46 | 0.00 | 0.02 |
| gc cr multi block request | 506 | 0 | 0 | 1 | 0.00 | 0.02 |
| CGS wait for IPC msg | 32,605 | 100 | 0 | 0 | 0.20 | 0.02 |
| enq: TQ - TM contention | 1 | 0 | 0 | 303 | 0.00 | 0.02 |
| direct path write | 321 | 0 | 0 | 1 | 0.00 | 0.02 |
| db file async I/O submit | 331,059 | 0 | 0 | 0 | 2.05 | 0.01 |
| ksxr poll remote instances | 23,754 | 100 | 0 | 0 | 0.15 | 0.01 |
| row cache cleanup | 41,933 | 0 | 0 | 0 | 0.26 | 0.01 |
| gc cr block 2-way | 414 | 0 | 0 | 0 | 0.00 | 0.01 |
| gc cr grant 2-way | 506 | 0 | 0 | 0 | 0.00 | 0.01 |
| enq: PS - contention | 41 | 20 | 0 | 3 | 0.00 | 0.01 |
| row cache process | 47,823 | 0 | 0 | 0 | 0.30 | 0.01 |
| db file parallel read | 9 | 0 | 0 | 13 | 0.00 | 0.01 |
| gc current block busy | 23 | 0 | 0 | 5 | 0.00 | 0.01 |
| library cache pin | 267 | 0 | 0 | 0 | 0.00 | 0.01 |
| gc current grant 2-way | 300 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr block busy | 14 | 0 | 0 | 4 | 0.00 | 0.00 |
| log file sync | 7 | 0 | 0 | 7 | 0.00 | 0.00 |
| enq: CF - contention | 122 | 87 | 0 | 0 | 0.00 | 0.00 |
| LGWR wait for redo copy | 867 | 0 | 0 | 0 | 0.01 | 0.00 |
| log file single write | 16 | 0 | 0 | 2 | 0.00 | 0.00 |
| libcache interrupt action by LCK | 38,315 | 0 | 0 | 0 | 0.24 | 0.00 |
| row cache lock | 88 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: WF - contention | 21 | 0 | 0 | 1 | 0.00 | 0.00 |
| kfk: async disk IO | 12 | 0 | 0 | 3 | 0.00 | 0.00 |
| gc current grant busy | 80 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: IV - contention | 42 | 14 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: reap credit | 3,316 | 100 | 0 | 0 | 0.02 | 0.00 |
| CSS initialization | 14 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: TM - contention | 2 | 0 | 0 | 10 | 0.00 | 0.00 |
| CSS operation: action | 30 | 0 | 0 | 1 | 0.00 | 0.00 |
| CRS call completion | 4 | 0 | 0 | 4 | 0.00 | 0.00 |
| Disk file operations I/O | 221 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current block congested | 23 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 60 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 25 | 56 | 0 | 0 | 0.00 | 0.00 |
| latch: ges resource hash list | 71 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr disk read | 28 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 60 | 0 | 0 | 0 | 0.00 | 0.00 |
| IPC send completion sync | 34 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr grant congested | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: object queue header operation | 44 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TD - KTF dump entries | 11 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current multi block request | 9 | 0 | 0 | 1 | 0.00 | 0.00 |
| CSS group registration | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
| rdbms ipc reply | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TA - contention | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch free | 68 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 30 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr block congested | 9 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: gc element | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Signal ACK EXT | 60 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS operation: query | 42 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: shared pool | 48 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: messages | 16 | 0 | 0 | 0 | 0.00 | 0.00 |
| ADR block file read | 16 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc message | 352,705 | 18 | 90,940 | 258 | 2.19 | |
| Streams AQ: waiting for time management or cleanup tasks | 2 | 50 | 14,415 | 7207381 | 0.00 | |
| class slave wait | 551 | 0 | 10,638 | 19306 | 0.00 | |
| gcs remote message | 568,675 | 45 | 10,614 | 19 | 3.53 | |
| wait for unread message on broadcast channel | 7,249 | 88 | 7,092 | 978 | 0.04 | |
| DIAG idle wait | 46,530 | 81 | 7,082 | 152 | 0.29 | |
| Streams AQ: qmn slave idle wait | 313 | 0 | 7,040 | 22492 | 0.00 | |
| Space Manager: slave idle wait | 1,144 | 98 | 5,650 | 4939 | 0.01 | |
| PX Idle Wait | 560 | 0 | 3,946 | 7047 | 0.00 | |
| PING | 1,457 | 19 | 3,549 | 2436 | 0.01 | |
| GCR sleep | 709 | 100 | 3,546 | 5001 | 0.00 | |
| ASM background timer | 825 | 0 | 3,545 | 4296 | 0.01 | |
| pmon timer | 1,182 | 100 | 3,544 | 2998 | 0.01 | |
| smon timer | 767 | 0 | 3,544 | 4620 | 0.00 | |
| ges remote message | 92,779 | 30 | 3,541 | 38 | 0.58 | |
| Streams AQ: qmn coordinator idle wait | 325 | 49 | 3,522 | 10837 | 0.00 | |
| KSV master wait | 2,398 | 89 | 1 | 0 | 0.01 | |
| SQL*Net message from client | 282 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Join ACK | 60 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Parse Reply | 60 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Execute Reply | 60 | 0 | 0 | 0 | 0.00 | |
| Streams AQ: RAC qmn coordinator idle wait | 339 | 100 | 0 | 0 | 0.00 |
| % of Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
| ADR block file read | 16 | 100.0 | |||||||
| ADR block file write | 5 | 100.0 | |||||||
| ADR file lock | 6 | 100.0 | |||||||
| ARCH wait for archivelog lock | 4 | 100.0 | |||||||
| ASM file metadata operation | 1984 | 98.3 | .4 | .5 | .5 | .1 | .3 | ||
| CGS wait for IPC msg | 32.6K | 100.0 | |||||||
| CRS call completion | 8 | 50.0 | 25.0 | 25.0 | |||||
| CSS group membership query | 2 | 100.0 | |||||||
| CSS group registration | 2 | 50.0 | 50.0 | ||||||
| CSS initialization | 16 | 50.0 | 43.8 | 6.3 | |||||
| CSS operation: action | 32 | 87.5 | 12.5 | ||||||
| CSS operation: query | 48 | 100.0 | |||||||
| DFS lock handle | 1469 | 98.2 | 1.5 | .1 | .2 | ||||
| Data Pump slave startup | 1 | 100.0 | |||||||
| Datapump dump file I/O | 31.8K | 99.3 | .7 | .0 | .0 | .0 | |||
| Disk file operations I/O | 341 | 99.7 | .3 | ||||||
| IPC send completion sync | 585 | 99.3 | .5 | .2 | |||||
| KJC: Wait for msg sends to complete | 697 | 100.0 | |||||||
| LGWR wait for redo copy | 868 | 99.7 | .2 | .1 | |||||
| Log archive I/O | 1740 | 21.4 | 38.9 | 33.3 | 5.9 | .4 | .1 | ||
| PX Deq: Signal ACK EXT | 968 | 100.0 | |||||||
| PX Deq: Signal ACK RSG | 1064 | 99.6 | .4 | ||||||
| PX Deq: Slave Session Stats | 1472 | 98.4 | 1.5 | .1 | |||||
| PX Deq: reap credit | 16K | 100.0 | .0 | ||||||
| PX qref latch | 3 | 100.0 | |||||||
| SQL*Net break/reset to client | 1156 | 99.8 | .1 | .1 | |||||
| SQL*Net message from dblink | 19 | 10.5 | 10.5 | 21.1 | 21.1 | 10.5 | 26.3 | ||
| SQL*Net message to client | 2386.8K | 100.0 | .0 | ||||||
| SQL*Net message to dblink | 18 | 100.0 | |||||||
| SQL*Net more data from client | 21.4K | 100.0 | |||||||
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100.0 | |||||||
| asynch descriptor resize | 114 | 100.0 | |||||||
| buffer busy waits | 1910 | 99.7 | .2 | .1 | |||||
| control file parallel write | 1810 | 4.9 | 46.2 | 45.2 | 2.5 | .3 | .2 | .7 | |
| control file sequential read | 11.6K | 96.2 | 3.1 | .3 | .2 | .2 | .0 | .0 | |
| cursor: mutex S | 1 | 100.0 | |||||||
| cursor: pin S | 25 | 96.0 | 4.0 | ||||||
| db file async I/O submit | 330.5K | 100.0 | |||||||
| db file parallel read | 11 | 27.3 | 45.5 | 9.1 | 18.2 | ||||
| db file parallel write | 335.7K | 18.3 | 47.2 | 32.1 | 2.2 | .1 | .1 | .1 | |
| db file scattered read | 637 | 21.5 | 6.9 | 16.5 | 22.4 | 26.5 | 4.4 | 1.7 | |
| db file sequential read | 925.7K | 41.2 | 3.1 | 7.8 | 29.6 | 15.8 | 1.9 | .6 | |
| direct path read | 2707.8K | 55.8 | 33.4 | 9.9 | .6 | .2 | .1 | .0 | |
| direct path sync | 2 | 50.0 | 50.0 | ||||||
| direct path write | 341 | 66.0 | 21.1 | 12.6 | .3 | ||||
| enq: AE - lock | 2 | 100.0 | |||||||
| enq: AF - task serialization | 1 | 100.0 | |||||||
| enq: AS - service activation | 2 | 100.0 | |||||||
| enq: CF - contention | 122 | 100.0 | |||||||
| enq: CR - block range reuse ckpt | 9 | 33.3 | 55.6 | 11.1 | |||||
| enq: DR - contention | 2 | 100.0 | |||||||
| enq: FB - contention | 16 | 100.0 | |||||||
| enq: HW - contention | 8 | 100.0 | |||||||
| enq: IV - contention | 339 | 90.0 | 9.4 | .6 | |||||
| enq: JQ - contention | 1 | 100.0 | |||||||
| enq: KO - fast object checkpoint | 23.4K | 93.2 | 3.1 | 2.9 | .6 | .1 | .0 | .1 | |
| enq: MW - contention | 2 | 100.0 | |||||||
| enq: PE - contention | 2 | 100.0 | |||||||
| enq: PI - contention | 3 | 100.0 | |||||||
| enq: PS - contention | 577 | 87.0 | 5.7 | 1.7 | .5 | 1.0 | .7 | 3.3 | |
| enq: RO - fast object reuse | 13 | 46.2 | 7.7 | 46.2 | |||||
| enq: SR - contention | 2 | 100.0 | |||||||
| enq: SV - contention | 377 | 98.9 | 1.1 | ||||||
| enq: TA - contention | 10 | 100.0 | |||||||
| enq: TD - KTF dump entries | 11 | 90.9 | 9.1 | ||||||
| enq: TM - contention | 7 | 85.7 | 14.3 | ||||||
| enq: TO - contention | 1 | 100.0 | |||||||
| enq: TQ - DDL contention | 3 | 66.7 | 33.3 | ||||||
| enq: TQ - TM contention | 1 | 100.0 | |||||||
| enq: TS - contention | 6 | 100.0 | |||||||
| enq: TT - contention | 28 | 100.0 | |||||||
| enq: TX - index contention | 5 | 100.0 | |||||||
| enq: TX - row lock contention | 16 | 25.0 | 18.8 | 18.8 | 31.3 | 6.3 | |||
| enq: UL - contention | 3 | 66.7 | 33.3 | ||||||
| enq: US - contention | 1 | 100.0 | |||||||
| enq: WF - contention | 21 | 95.2 | 4.8 | ||||||
| enq: WL - contention | 2 | 100.0 | |||||||
| enq: ZH - compression analysis | 2 | 100.0 | |||||||
| gc buffer busy acquire | 8725 | 29.0 | 9.9 | 37.2 | 21.1 | 1.8 | .5 | .5 | |
| gc buffer busy release | 30 | 13.3 | 10.0 | 30.0 | 20.0 | 6.7 | 13.3 | 6.7 | |
| gc cr block 2-way | 36.3K | 98.3 | 1.6 | .1 | .0 | .0 | |||
| gc cr block busy | 17.7K | .1 | 7.4 | 59.2 | 31.7 | 1.0 | .3 | .3 | |
| gc cr block congested | 643 | 98.9 | 1.1 | ||||||
| gc cr disk read | 31 | 100.0 | |||||||
| gc cr grant 2-way | 2452 | 99.1 | .8 | .0 | |||||
| gc cr grant congested | 41 | 97.6 | 2.4 | ||||||
| gc cr multi block request | 861 | 87.2 | 8.2 | 2.9 | 1.6 | ||||
| gc current block 2-way | 47.2K | 98.6 | 1.3 | .1 | .0 | .0 | |||
| gc current block busy | 153 | 9.2 | 17.0 | 48.4 | 22.2 | 2.0 | .7 | .7 | |
| gc current block congested | 852 | 98.0 | 2.0 | ||||||
| gc current grant 2-way | 1043 | 99.5 | .5 | ||||||
| gc current grant busy | 3529 | 99.0 | .9 | .0 | .0 | .1 | |||
| gc current grant congested | 13 | 100.0 | |||||||
| gc current multi block request | 60 | 98.3 | 1.7 | ||||||
| gcs log flush sync | 578 | 29.1 | 19.9 | 32.5 | 11.6 | 2.4 | 4.5 | ||
| ges inquiry response | 3677 | 97.6 | 2.4 | ||||||
| kfk: async disk IO | 12 | 33.3 | 58.3 | 8.3 | |||||
| ksxr poll remote instances | 23.8K | 100.0 | |||||||
| kupp process wait | 2 | 100.0 | |||||||
| latch free | 157 | 96.2 | 1.9 | .6 | .6 | .6 | |||
| latch: cache buffers chains | 1889 | 99.9 | .1 | .1 | |||||
| latch: cache buffers lru chain | 12 | 100.0 | |||||||
| latch: call allocation | 2 | 100.0 | |||||||
| latch: checkpoint queue latch | 10 | 100.0 | |||||||
| latch: enqueue hash chains | 8 | 100.0 | |||||||
| latch: gc element | 112 | 100.0 | |||||||
| latch: gcs resource hash | 5 | 100.0 | |||||||
| latch: ges resource hash list | 98 | 100.0 | |||||||
| latch: messages | 17 | 100.0 | |||||||
| latch: object queue header operation | 48 | 100.0 | |||||||
| latch: redo allocation | 49 | 98.0 | 2.0 | ||||||
| latch: redo writing | 3 | 100.0 | |||||||
| latch: row cache objects | 22 | 100.0 | |||||||
| latch: shared pool | 87 | 100.0 | |||||||
| latch: undo global data | 1 | 100.0 | |||||||
| libcache interrupt action by LCK | 38.3K | 100.0 | |||||||
| library cache lock | 297 | 97.6 | 1.3 | .3 | .7 | ||||
| library cache pin | 685 | 97.5 | 2.3 | .1 | |||||
| library cache: mutex X | 206 | 99.0 | 1.0 | ||||||
| log file parallel write | 151.5K | 6.8 | 25.3 | 57.7 | 7.8 | .9 | .6 | .9 | |
| log file sequential read | 1087 | 21.8 | 22.1 | 23.2 | 16.5 | 9.7 | 3.2 | 3.6 | |
| log file single write | 16 | 6.3 | 37.5 | 56.3 | |||||
| log file switch completion | 7 | 14.3 | 85.7 | ||||||
| log file sync | 161K | .1 | 12.2 | 46.9 | 34.4 | 3.3 | 1.1 | 2.1 | |
| name-service call wait | 23 | 4.3 | 4.3 | 4.3 | 8.7 | 78.3 | |||
| os thread startup | 45 | 46.7 | 37.8 | 15.6 | |||||
| rdbms ipc reply | 4437 | 99.1 | .8 | .1 | |||||
| read by other session | 123 | 16.3 | 2.4 | 11.4 | 42.3 | 24.4 | 3.3 | ||
| reliable message | 9057 | 13.3 | 67.4 | 19.0 | .1 | .0 | .0 | .1 | |
| row cache cleanup | 41.9K | 100.0 | |||||||
| row cache lock | 1928 | 99.2 | .7 | .1 | |||||
| row cache process | 47.8K | 100.0 | .0 | ||||||
| undo segment extension | 4 | 50.0 | 50.0 | ||||||
| utl_file I/O | 345 | 100.0 | |||||||
| ASM background timer | 826 | 10.0 | .1 | .5 | 1.2 | .5 | .1 | 1.2 | 86.3 |
| DIAG idle wait | 46.6K | 17.3 | .4 | .3 | .0 | 3.2 | 4.8 | 73.9 | |
| GCR sleep | 709 | 100.0 | |||||||
| KSV master wait | 2401 | 98.6 | .3 | .4 | .4 | .0 | .2 | ||
| PING | 1453 | 80.7 | 19.3 | ||||||
| PL/SQL lock timer | 32 | 100.0 | |||||||
| PX Deq: Execute Reply | 1064 | 99.6 | .4 | ||||||
| PX Deq: Execution Msg | 2208 | 75.2 | 19.8 | 2.6 | 1.2 | 1.1 | .0 | ||
| PX Deq: Join ACK | 1064 | 68.0 | 29.1 | 2.8 | .1 | ||||
| PX Deq: Parse Reply | 1064 | 86.5 | 12.8 | .7 | .1 | ||||
| PX Idle Wait | 552 | 2.7 | 14.5 | 26.3 | 5.4 | 1.8 | 3.8 | 29.9 | 15.6 |
| SQL*Net message from client | 2387.6K | 39.8 | 37.7 | 17.4 | 1.0 | .7 | .5 | 2.4 | .4 |
| Space Manager: slave idle wait | 1143 | 1.0 | 99.0 | ||||||
| Streams AQ: RAC qmn coordinator idle wait | 339 | 100.0 | |||||||
| Streams AQ: qmn coordinator idle wait | 325 | 50.5 | .3 | .3 | 48.9 | ||||
| Streams AQ: qmn slave idle wait | 312 | 100.0 | |||||||
| Streams AQ: waiting for time management or cleanup tasks | 2 | 50.0 | 50.0 | ||||||
| class slave wait | 584 | 40.4 | 1.5 | .3 | .9 | 19.3 | 5.3 | 3.9 | 28.3 |
| gcs remote message | 568.6K | 9.1 | 4.4 | 9.1 | 10.5 | 11.1 | 55.7 | .1 | |
| ges remote message | 92.8K | 48.7 | 3.1 | 2.3 | 1.5 | 1.7 | 3.5 | 39.3 | |
| jobq slave wait | 720 | 100.0 | |||||||
| pmon timer | 1183 | .1 | .1 | 99.8 | |||||
| rdbms ipc message | 352.5K | 46.9 | 6.8 | 5.1 | 1.9 | 2.1 | 3.0 | 29.2 | 5.0 |
| single-task message | 1 | 100.0 | |||||||
| smon timer | 767 | .1 | .1 | 6.4 | .5 | 92.8 | |||
| wait for unread message on broadcast channel | 8209 | .9 | 1.6 | .5 | .1 | .9 | .5 | 95.4 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
| ASM file metadata operation | 5 | 99.7 | .1 | .2 | |||||
| DFS lock handle | 3 | 99.8 | .2 | ||||||
| Datapump dump file I/O | 1 | 100.0 | .0 | ||||||
| control file parallel write | 12 | 99.3 | .4 | .2 | |||||
| control file sequential read | 1 | 100.0 | .0 | ||||||
| db file parallel read | 2 | 81.8 | 9.1 | 9.1 | |||||
| db file parallel write | 257 | 99.9 | .1 | .0 | .0 | ||||
| db file scattered read | 11 | 98.3 | 1.1 | .6 | |||||
| db file sequential read | 5743 | 99.4 | .4 | .2 | .0 | ||||
| direct path read | 810 | 100.0 | .0 | .0 | .0 | .0 | |||
| direct path sync | 1 | 50.0 | 50.0 | ||||||
| enq: CR - block range reuse ckpt | 1 | 88.9 | 11.1 | ||||||
| enq: KO - fast object checkpoint | 23 | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
| enq: PS - contention | 19 | 96.7 | .9 | 2.4 | |||||
| enq: TQ - DDL contention | 1 | 66.7 | 33.3 | ||||||
| enq: TQ - TM contention | 1 | 100.0 | |||||||
| enq: UL - contention | 1 | 66.7 | 33.3 | ||||||
| gc buffer busy acquire | 41 | 99.5 | .3 | .1 | .0 | ||||
| gc buffer busy release | 2 | 93.3 | 3.3 | 3.3 | |||||
| gc cr block busy | 58 | 99.7 | .2 | .1 | .0 | ||||
| gc current block busy | 1 | 99.3 | .7 | ||||||
| kupp process wait | 2 | 100.0 | |||||||
| latch free | 1 | 99.4 | .6 | ||||||
| library cache lock | 2 | 99.3 | .7 | ||||||
| log file parallel write | 1401 | 99.1 | .6 | .3 | .0 | .0 | |||
| log file sequential read | 39 | 96.4 | 2.2 | 1.1 | .3 | ||||
| log file switch completion | 6 | 14.3 | 42.9 | 42.9 | |||||
| log file sync | 3381 | 97.9 | 1.2 | .7 | .1 | .0 | |||
| name-service call wait | 18 | 21.7 | 30.4 | 47.8 | |||||
| os thread startup | 7 | 84.4 | 8.9 | 6.7 | |||||
| reliable message | 13 | 99.9 | .0 | .0 | .0 | .1 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100.0 |
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|---|---|---|---|
| cc | 26,122 | 17,750 | 499,522 | 6,413,509 |
| SYS$USERS | 6 | 3 | 2,496 | 7,966 |
| SYS$BACKGROUND | 0 | 0 | 1 | 79 |
| 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 |
|---|---|---|---|---|---|---|---|---|
| cc | 3279670 | 7093 | 6186 | 1 | 0 | 0 | 2407930 | 3 |
| SYS$USERS | 847 | 1 | 321 | 0 | 0 | 0 | 727 | 0 |
| SYS$BACKGROUND | 387139 | 221 | 38907 | 2 | 0 | 0 | 0 | 0 |
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 2,914.33 | 7,627 | 0.38 | 11.16 | 99.46 | 0.00 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 2,887.42 | 3,865 | 0.75 | 11.05 | 4.04 | 96.50 | 6zjmjz9827m02 | mdbOraRep@PRQMOCS01 (TNS V1-V3) | update IMSI_ACCT_ACM_DAILY set... |
| 1,548.92 | 1,774 | 0.87 | 5.93 | 53.89 | 44.58 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 1,542.27 | 1,765 | 0.87 | 5.90 | 53.84 | 44.61 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 1,523.40 | 1,774 | 0.86 | 5.83 | 51.42 | 47.13 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 1,517.75 | 1,765 | 0.86 | 5.81 | 51.39 | 47.10 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 1,287.51 | 1 | 1,287.51 | 4.93 | 19.61 | 79.75 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 1,250.98 | 7,609 | 0.16 | 4.79 | 90.98 | 7.07 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 291.06 | 1 | 291.06 | 1.11 | 30.68 | 74.24 | fna89152yus9t | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 276.17 | 7,609 | 0.04 | 1.06 | 95.59 | 0.00 | g53t4d0hcrp7f | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select count(1) COUNTS from o... |
| CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 2,898.52 | 7,627 | 0.38 | 16.33 | 2,914.33 | 99.46 | 0.00 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 1,138.15 | 7,609 | 0.15 | 6.41 | 1,250.98 | 90.98 | 7.07 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 834.74 | 1,774 | 0.47 | 4.70 | 1,548.92 | 53.89 | 44.58 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 830.39 | 1,765 | 0.47 | 4.68 | 1,542.27 | 53.84 | 44.61 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 783.37 | 1,774 | 0.44 | 4.41 | 1,523.40 | 51.42 | 47.13 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 779.91 | 1,765 | 0.44 | 4.39 | 1,517.75 | 51.39 | 47.10 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 264.00 | 7,609 | 0.03 | 1.49 | 276.17 | 95.59 | 0.00 | g53t4d0hcrp7f | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select count(1) COUNTS from o... |
| 252.46 | 1 | 252.46 | 1.42 | 1,287.51 | 19.61 | 79.75 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 186.61 | 3,840 | 0.05 | 1.05 | 192.37 | 97.01 | 0.00 | c3cf0fm3qbmuc | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.77 | 3,839 | 0.05 | 1.04 | 190.72 | 96.88 | 0.00 | 11c8zb3zn369r | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.66 | 3,839 | 0.05 | 1.04 | 191.38 | 96.49 | 0.00 | 3xxb4bb5dhy1w | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.49 | 7,612 | 0.02 | 1.04 | 187.57 | 98.36 | 0.00 | 0f8kn3gzxt22r | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_ID, A.PREFIX || ... |
| 184.48 | 3,839 | 0.05 | 1.04 | 191.38 | 96.39 | 0.00 | 6fsv3z9s263sz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.35 | 3,839 | 0.05 | 1.04 | 191.19 | 96.42 | 0.00 | fv2xbczcmsmvv | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.33 | 3,839 | 0.05 | 1.04 | 191.34 | 96.34 | 0.00 | 7kuxswuvfja1b | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.31 | 3,838 | 0.05 | 1.04 | 191.15 | 96.42 | 0.00 | fpst8g6ksvnzm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.30 | 3,839 | 0.05 | 1.04 | 190.96 | 96.51 | 0.00 | c02twqwuqz9ju | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.25 | 3,839 | 0.05 | 1.04 | 190.74 | 96.60 | 0.00 | carud411m6zbb | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.15 | 3,840 | 0.05 | 1.04 | 191.19 | 96.32 | 0.00 | bpnddxdzk2qqz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.10 | 3,839 | 0.05 | 1.04 | 190.85 | 96.47 | 0.00 | 5nhvn2thy8ftj | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.08 | 3,839 | 0.05 | 1.04 | 191.13 | 96.31 | 0.00 | bh6f7thha16um | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.07 | 3,840 | 0.05 | 1.04 | 191.04 | 96.35 | 0.00 | 0vhvf9k5g7b7r | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.06 | 3,840 | 0.05 | 1.04 | 191.01 | 96.36 | 0.00 | gtv5j365jyuwu | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.05 | 3,839 | 0.05 | 1.04 | 191.26 | 96.23 | 0.00 | 4dub9ujxd8057 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.03 | 3,839 | 0.05 | 1.04 | 190.67 | 96.51 | 0.00 | gr96mj0sw34sw | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 184.02 | 3,839 | 0.05 | 1.04 | 190.76 | 96.47 | 0.00 | ffzx77pz0pa4g | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 183.98 | 3,839 | 0.05 | 1.04 | 190.83 | 96.41 | 0.00 | 76hh9gbu2b6nm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 183.91 | 3,839 | 0.05 | 1.04 | 190.86 | 96.36 | 0.00 | cmc6tmpazrxwx | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 183.87 | 3,839 | 0.05 | 1.04 | 190.65 | 96.45 | 0.00 | ak8y9gtrd96nk | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 183.84 | 3,840 | 0.05 | 1.04 | 190.55 | 96.48 | 0.00 | 49hj7h4jpaqmr | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 183.80 | 3,839 | 0.05 | 1.04 | 190.80 | 96.33 | 0.00 | bh6hcvvvqydqy | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 2,786.50 | 3,865 | 0.72 | 38.10 | 2,887.42 | 4.04 | 96.50 | 6zjmjz9827m02 | mdbOraRep@PRQMOCS01 (TNS V1-V3) | update IMSI_ACCT_ACM_DAILY set... |
| 1,026.75 | 1 | 1,026.75 | 14.04 | 1,287.51 | 19.61 | 79.75 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 717.98 | 1,774 | 0.40 | 9.82 | 1,523.40 | 51.42 | 47.13 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 714.89 | 1,765 | 0.41 | 9.77 | 1,517.75 | 51.39 | 47.10 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 690.56 | 1,774 | 0.39 | 9.44 | 1,548.92 | 53.89 | 44.58 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 688.00 | 1,765 | 0.39 | 9.41 | 1,542.27 | 53.84 | 44.61 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 216.09 | 1 | 216.09 | 2.95 | 291.06 | 30.68 | 74.24 | fna89152yus9t | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 88.50 | 7,609 | 0.01 | 1.21 | 1,250.98 | 90.98 | 7.07 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 0.73 | 1 | 0.73 | 0.01 | 1.38 | 42.78 | 53.12 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 0.62 | 1 | 0.62 | 0.01 | 1.20 | 44.61 | 51.37 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 133,584,178 | 7,627 | 17,514.64 | 2.08 | 2,914.33 | 99.5 | 0 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 124,957,220 | 3,839 | 32,549.42 | 1.95 | 190.85 | 96.5 | 0 | 5nhvn2thy8ftj | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,957,189 | 3,840 | 32,540.93 | 1.95 | 191.01 | 96.4 | 0 | gtv5j365jyuwu | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,262 | 3,839 | 32,532.50 | 1.94 | 190.96 | 96.5 | 0 | c02twqwuqz9ju | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,222 | 3,839 | 32,532.49 | 1.94 | 191.38 | 96.5 | 0 | 3xxb4bb5dhy1w | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,177 | 3,839 | 32,532.48 | 1.94 | 191.13 | 96.3 | 0 | bh6f7thha16um | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,158 | 3,839 | 32,532.47 | 1.94 | 190.80 | 96.3 | 0 | bh6hcvvvqydqy | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,084 | 3,839 | 32,532.45 | 1.94 | 190.76 | 96.5 | 0 | ffzx77pz0pa4g | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,892,065 | 3,839 | 32,532.45 | 1.94 | 191.34 | 96.3 | 0 | 7kuxswuvfja1b | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,687 | 3,840 | 32,515.54 | 1.94 | 191.19 | 96.3 | 0 | bpnddxdzk2qqz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,671 | 3,840 | 32,515.54 | 1.94 | 191.04 | 96.3 | 0 | 0vhvf9k5g7b7r | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,616 | 3,839 | 32,523.99 | 1.94 | 190.83 | 96.4 | 0 | 76hh9gbu2b6nm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,580 | 3,840 | 32,515.52 | 1.94 | 192.37 | 97 | 0 | c3cf0fm3qbmuc | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,551 | 3,839 | 32,523.98 | 1.94 | 190.74 | 96.6 | 0 | carud411m6zbb | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,859,469 | 3,839 | 32,523.96 | 1.94 | 191.19 | 96.4 | 0 | fv2xbczcmsmvv | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,827,278 | 3,839 | 32,515.57 | 1.94 | 190.67 | 96.5 | 0 | gr96mj0sw34sw | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,827,046 | 3,838 | 32,523.98 | 1.94 | 191.15 | 96.4 | 0 | fpst8g6ksvnzm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,827,027 | 3,839 | 32,515.51 | 1.94 | 191.26 | 96.2 | 0 | 4dub9ujxd8057 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,827,006 | 3,839 | 32,515.50 | 1.94 | 191.38 | 96.4 | 0 | 6fsv3z9s263sz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,794,425 | 3,839 | 32,507.01 | 1.94 | 190.72 | 96.9 | 0 | 11c8zb3zn369r | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,729,611 | 3,839 | 32,490.13 | 1.94 | 190.65 | 96.4 | 0 | ak8y9gtrd96nk | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,696,887 | 3,839 | 32,481.61 | 1.94 | 190.86 | 96.4 | 0 | cmc6tmpazrxwx | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 124,696,851 | 3,840 | 32,473.14 | 1.94 | 190.55 | 96.5 | 0 | 49hj7h4jpaqmr | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 115,824,641 | 1,774 | 65,290.10 | 1.80 | 1,548.92 | 53.9 | 44.6 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 115,759,999 | 1,774 | 65,253.66 | 1.80 | 1,523.40 | 51.4 | 47.1 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 115,172,851 | 1,765 | 65,253.74 | 1.79 | 1,517.75 | 51.4 | 47.1 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 115,172,135 | 1,765 | 65,253.33 | 1.79 | 1,542.27 | 53.8 | 44.6 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 99,510,065 | 7,609 | 13,077.94 | 1.55 | 276.17 | 95.6 | 0 | g53t4d0hcrp7f | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select count(1) COUNTS from o... |
| 68,262,140 | 9,106 | 7,496.39 | 1.06 | 137.92 | 95.5 | .2 | 1x7hp5cbvz2un | mdbClean@GRQMOCS01 (TNS V1-V3) | delete from CC_MDB_CHANGE_NOTI... |
| Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 115,797,450 | 1,774 | 65,274.77 | 23.06 | 1,548.92 | 53.89 | 44.58 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 115,732,331 | 1,774 | 65,238.07 | 23.05 | 1,523.40 | 51.42 | 47.13 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 115,145,283 | 1,765 | 65,238.12 | 22.93 | 1,517.75 | 51.39 | 47.10 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 115,145,070 | 1,765 | 65,238.00 | 22.93 | 1,542.27 | 53.84 | 44.61 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 34,471,405 | 7,609 | 4,530.35 | 6.87 | 1,250.98 | 90.98 | 7.07 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 2,495,435 | 1 | 2,495,435.00 | 0.50 | 291.06 | 30.68 | 74.24 | fna89152yus9t | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 1,411,822 | 1 | 1,411,822.00 | 0.28 | 1,287.51 | 19.61 | 79.75 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 386,046 | 3,865 | 99.88 | 0.08 | 2,887.42 | 4.04 | 96.50 | 6zjmjz9827m02 | mdbOraRep@PRQMOCS01 (TNS V1-V3) | update IMSI_ACCT_ACM_DAILY set... |
| 1,156 | 1 | 1,156.00 | 0.00 | 1.20 | 44.61 | 51.37 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 158 | 1 | 158.00 | 0.00 | 1.38 | 42.78 | 53.12 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 937,200 | 937,200 | 1,774 | 528.30 | 0.00 | 18.73 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 936,791 | 936,791 | 1,774 | 528.07 | 0.00 | 18.73 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 932,133 | 932,133 | 1,765 | 528.12 | 0.00 | 18.63 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 931,920 | 931,920 | 1,765 | 528.00 | 0.00 | 18.63 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 386,046 | 386,046 | 3,865 | 99.88 | 0.00 | 7.72 | 6zjmjz9827m02 | mdbOraRep@PRQMOCS01 (TNS V1-V3) | update IMSI_ACCT_ACM_DAILY set... |
| 374,800 | 374,800 | 1 | 374,800.00 | 0.00 | 7.49 | fna89152yus9t | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 280,313 | 280,313 | 7,609 | 36.84 | 0.00 | 5.60 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 161,978 | 161,978 | 1 | 161,978.00 | 0.00 | 3.24 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 143 | 143 | 1 | 143.00 | 0.00 | 0.00 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 116 | 116 | 1 | 116.00 | 0.00 | 0.00 | 5y20dfyav3thr | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 241,473 | 1,244 | 0.01 | 32.94 | 16.3 | 0 | 08r5ykvtcd7h4 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | SELECT /*+ FIRST_ROWS ORDERED*... |
| 241,472 | 0 | 0.00 | 24.32 | 12.1 | 0 | 7vyp6n0sbbb9q | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, key2, TABLE_SEQUE... |
| 14,170 | 1,044 | 0.07 | 3.91 | 16.7 | 0 | ch338uf97vvy7 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select A.SUBS_PRICE_BAL_ID, A.... |
| 14,073 | 0 | 0.00 | 3.75 | 15.6 | 0 | a4bmr3j35n6fh | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 11,448 | 11,447 | 1.00 | 0.65 | 22.2 | 0 | bunvx480ynf57 | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | SELECT 1 FROM DUAL |
| 9,106 | 8,404 | 0.92 | 137.92 | 95.5 | .2 | 1x7hp5cbvz2un | mdbClean@GRQMOCS01 (TNS V1-V3) | delete from CC_MDB_CHANGE_NOTI... |
| 7,627 | 8,386 | 1.10 | 2,914.33 | 99.5 | 0 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 7,612 | 783 | 0.10 | 187.57 | 98.4 | 0 | 0f8kn3gzxt22r | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_ID, A.PREFIX || ... |
| 7,611 | 0 | 0.00 | 0.42 | 15.8 | 0 | g3uysr6u3f4ff | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 7,610 | 0 | 0.00 | 0.72 | 20.8 | 0 | 02v9yqq5d6xc6 | mdbFlushFromOra@PRQMOLC01 (TNS V1-V3) | select A.ROUTING_ID, A.C_SERVE... |
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 241,467 | 241,473 | 14.32 | 08r5ykvtcd7h4 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | SELECT /*+ FIRST_ROWS ORDERED*... |
| 241,467 | 241,472 | 14.32 | 7vyp6n0sbbb9q | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, key2, TABLE_SEQUE... |
| 14,168 | 14,170 | 0.84 | ch338uf97vvy7 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select A.SUBS_PRICE_BAL_ID, A.... |
| 14,072 | 14,073 | 0.83 | a4bmr3j35n6fh | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 11,446 | 11,448 | 0.68 | bunvx480ynf57 | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | SELECT 1 FROM DUAL |
| 9,106 | 9,106 | 0.54 | 1x7hp5cbvz2un | mdbClean@GRQMOCS01 (TNS V1-V3) | delete from CC_MDB_CHANGE_NOTI... |
| 7,620 | 7,627 | 0.45 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 7,611 | 7,612 | 0.45 | 0f8kn3gzxt22r | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_ID, A.PREFIX || ... |
| 7,611 | 7,611 | 0.45 | g3uysr6u3f4ff | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 7,610 | 7,609 | 0.45 | 1v9n0p75gxcby | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 32,916,426 | 1 | 0.85 | 62jfzru1s1mz1 | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 12,349,491 | 1 | 0.32 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 8,307,086 | 1 | 0.21 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 8,270,438 | 1 | 0.21 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 5,366,617 | 1 | 0.14 | 5y20dfyav3thr | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 5,334,025 | 1 | 0.14 | 5y20dfyav3thr | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 3,772,811 | 1 | 0.10 | 1fzj71h9hfw0c | Data Pump Worker | SELECT /*+rule*/ SYS_XMLGEN(VA... |
| 3,642,086 | 1 | 0.09 | bd502nbh9abbs | plsqldev.exe | select s.synonym_name object_n... |
| 3,629,847 | 1 | 0.09 | fqmpmkfr6pqyk | plsqldev.exe | select s.synonym_name object_n... |
| 3,090,075 | 1 | 0.08 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 3,090,075 | 1 | 0.08 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,270,324 | 1 | 0.06 | 5v07w9mp91u5j | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,241,859 | 1 | 0.06 | dvyrmgz9nstyw | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,241,817 | 1 | 0.06 | 5gvzpfp2401u8 | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,237,732 | 1 | 0.06 | 5v07w9mp91u5j | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,232,288 | 0.06 | 2wf9jj138a1h8 | SELECT /*+ OPT_PARAM('_fix_con... | ||
| 2,209,267 | 1 | 0.06 | dvyrmgz9nstyw | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,209,225 | 1 | 0.06 | 5gvzpfp2401u8 | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 2,002,496 | 1 | 0.05 | djzgjjtzjy7yz | Data Pump Master | INSERT INTO "MDB"."SYS_EXPORT_... |
| 1,376,335 | 6 | 0.04 | 8f1sjvfxuup9w | PL/SQL Developer | select t.*, o.*, m.comments fr... |
| 1,310,122 | 1 | 0.03 | bbp15m71mdgfa | Data Pump Worker | SELECT /*+rule*/ SYS_XMLGEN(VA... |
| Version Count | Executions | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|
| 224 | 2wf9jj138a1h8 | SELECT /*+ OPT_PARAM('_fix_con... | ||
| 41 | 1 | djzgjjtzjy7yz | Data Pump Master | INSERT INTO "MDB"."SYS_EXPORT_... |
| Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 10.69 | 241,473 | 7.76 | 32.94 | 32.47 | 16.33 | 0.00 | 08r5ykvtcd7h4 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | SELECT /*+ FIRST_ROWS ORDERED*... |
| 10.05 | 241,472 | 7.29 | 24.32 | 41.30 | 12.15 | 0.00 | 7vyp6n0sbbb9q | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, key2, TABLE_SEQUE... |
| 6.70 | 1 | 4.86 | 1,287.51 | 0.52 | 19.61 | 79.75 | au110hq5b8fjs | PL/SQL Developer | begin P_DELETE_ACCTACM_DAILY_B... |
| 4.34 | 3,865 | 3.15 | 2,887.42 | 0.15 | 4.04 | 96.50 | 6zjmjz9827m02 | mdbOraRep@PRQMOCS01 (TNS V1-V3) | update IMSI_ACCT_ACM_DAILY set... |
| 3.29 | 7,609 | 2.39 | 276.17 | 1.19 | 95.59 | 0.00 | g53t4d0hcrp7f | mdbFlushFromOra@PRQMOLC02 (TNS V1-V3) | select count(1) COUNTS from o... |
| 2.58 | 14,170 | 1.87 | 3.91 | 66.06 | 16.71 | 0.00 | ch338uf97vvy7 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select A.SUBS_PRICE_BAL_ID, A.... |
| 2.38 | 14,073 | 1.73 | 3.75 | 63.52 | 15.55 | 0.00 | a4bmr3j35n6fh | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 1.72 | 3,839 | 1.25 | 191.26 | 0.90 | 96.23 | 0.00 | 4dub9ujxd8057 | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.51 | 3,839 | 1.09 | 191.13 | 0.79 | 96.31 | 0.00 | bh6f7thha16um | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.51 | 3,840 | 1.09 | 191.19 | 0.79 | 96.32 | 0.00 | bpnddxdzk2qqz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.50 | 3,840 | 1.09 | 191.04 | 0.79 | 96.35 | 0.00 | 0vhvf9k5g7b7r | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.50 | 3,840 | 1.09 | 191.01 | 0.79 | 96.36 | 0.00 | gtv5j365jyuwu | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.49 | 3,839 | 1.08 | 190.80 | 0.78 | 96.33 | 0.00 | bh6hcvvvqydqy | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.42 | 3,839 | 1.03 | 191.38 | 0.74 | 96.39 | 0.00 | 6fsv3z9s263sz | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.42 | 3,839 | 1.03 | 190.86 | 0.74 | 96.36 | 0.00 | cmc6tmpazrxwx | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.42 | 9,106 | 1.03 | 137.92 | 1.03 | 95.51 | 0.15 | 1x7hp5cbvz2un | mdbClean@GRQMOCS01 (TNS V1-V3) | delete from CC_MDB_CHANGE_NOTI... |
| 1.41 | 3,839 | 1.03 | 191.19 | 0.74 | 96.42 | 0.00 | fv2xbczcmsmvv | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.41 | 3,839 | 1.02 | 191.34 | 0.74 | 96.34 | 0.00 | 7kuxswuvfja1b | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.33 | 3,838 | 0.96 | 191.15 | 0.70 | 96.42 | 0.00 | fpst8g6ksvnzm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.32 | 3,839 | 0.96 | 190.76 | 0.69 | 96.47 | 0.00 | ffzx77pz0pa4g | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.32 | 3,840 | 0.96 | 190.55 | 0.69 | 96.48 | 0.00 | 49hj7h4jpaqmr | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.30 | 3,839 | 0.94 | 190.83 | 0.68 | 96.41 | 0.00 | 76hh9gbu2b6nm | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.27 | 3,839 | 0.92 | 190.85 | 0.67 | 96.47 | 0.00 | 5nhvn2thy8ftj | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.26 | 7,610 | 0.92 | 152.82 | 0.83 | 93.25 | 0.00 | b7hxpn8tr2qq7 | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.26 | 3,839 | 0.91 | 190.65 | 0.66 | 96.45 | 0.00 | ak8y9gtrd96nk | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.25 | 3,839 | 0.91 | 191.38 | 0.65 | 96.49 | 0.00 | 3xxb4bb5dhy1w | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.25 | 3,839 | 0.91 | 190.74 | 0.65 | 96.60 | 0.00 | carud411m6zbb | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.21 | 7,609 | 0.88 | 153.17 | 0.79 | 93.36 | 0.00 | 8qajgd2m8bb0v | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.20 | 3,839 | 0.87 | 190.96 | 0.63 | 96.51 | 0.00 | c02twqwuqz9ju | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.19 | 7,610 | 0.86 | 152.91 | 0.78 | 93.39 | 0.00 | 2xyr6pbvjdaj1 | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.18 | 3,839 | 0.86 | 190.67 | 0.62 | 96.51 | 0.00 | gr96mj0sw34sw | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.14 | 7,627 | 0.83 | 2,914.33 | 0.04 | 99.46 | 0.00 | 4ys3bk35us8fb | mdbFlushFromOra@GRQMOLC02 (TNS V1-V3) | select A.PROD_ID, A.PROD_STATE... |
| 1.11 | 7,610 | 0.80 | 152.73 | 0.73 | 93.40 | 0.00 | 8dsqhv3r3b3uf | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.08 | 7,610 | 0.79 | 152.70 | 0.71 | 93.53 | 0.00 | fqqjvv2d4tcdm | mdbFlushFromOra@PRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.02 | 7,609 | 0.74 | 153.05 | 0.67 | 93.48 | 0.00 | 1v9n0p75gxcby | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 1.00 | 7,610 | 0.72 | 152.26 | 0.65 | 93.55 | 0.00 | 6bw3s3a1599qq | mdbFlushFromOra@PRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 0.95 | 7,609 | 0.69 | 152.65 | 0.63 | 93.57 | 0.00 | 49t3f8bfvyjxq | mdbFlushFromOra@PRQMOLC01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 0.88 | 3,839 | 0.64 | 190.72 | 0.46 | 96.88 | 0.00 | 11c8zb3zn369r | mdbFlushFromOra@PRQMOCS01 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 0.71 | 3,840 | 0.52 | 192.37 | 0.37 | 97.01 | 0.00 | c3cf0fm3qbmuc | mdbFlushFromOra@PRQMOCS02 (TNS V1-V3) | select nvl(max(TABLE_SEQUENCE)... |
| 0.68 | 7,609 | 0.49 | 1.20 | 56.44 | 11.35 | 0.00 | f3q1qqk988yau | mdbFlushFromOra@PRQMOLC01 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 0.61 | 1 | 0.45 | 291.06 | 0.21 | 30.68 | 74.24 | fna89152yus9t | BEGIN SYS.KUPW$WORKER.MAIN('S... | |
| 0.42 | 7,609 | 0.30 | 1,250.98 | 0.03 | 90.98 | 7.07 | 9z2bgzb3f3w0t | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_IDENTIFY_ID, A.S... |
| 0.39 | 7,612 | 0.28 | 187.57 | 0.21 | 98.36 | 0.00 | 0f8kn3gzxt22r | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select A.SUBS_ID, A.PREFIX || ... |
| 0.22 | 7,610 | 0.16 | 0.72 | 30.42 | 12.81 | 0.00 | 5qcx8wxbkz28k | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 0.19 | 1,774 | 0.14 | 1,523.40 | 0.01 | 51.42 | 47.13 | 32qcsvb5ztykv | oracle@PRQMRAC02 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 0.19 | 7,610 | 0.14 | 0.71 | 26.66 | 14.45 | 0.00 | a9c3bscw69zjm | mdbFlushFromOra@GRQMOLC01 (TNS V1-V3) | select key1, TABLE_SEQUENCE, U... |
| 0.17 | 1,765 | 0.13 | 1,517.75 | 0.01 | 51.39 | 47.10 | du23z1k3mjhmq | oracle@PRQMRAC01 (TNS V1-V3) | SELECT NVL("A1"."SUBS_ID", (-1... |
| 0.11 | 1,774 | 0.08 | 1,548.92 | 0.01 | 53.89 | 44.58 | 5z6tmnc9tgx7r | oracle@PRQMRAC02 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 0.10 | 1,765 | 0.07 | 1,542.27 | 0.01 | 53.84 | 44.61 | 1d7cpg658cgu5 | oracle@PRQMRAC01 (TNS V1-V3) | SELECT "A1"."SUBS_ID", "A1"."R... |
| 0.06 | 1 | 0.04 | 1.20 | 5.11 | 44.61 | 51.37 | 89wvk8xxw6zjg | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 0.06 | 1 | 0.04 | 1.38 | 3.98 | 42.78 | 53.12 | dgdfxu9ram2mj | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 0.04 | 1 | 0.03 | 0.69 | 6.53 | 93.83 | 0.79 | 5v07w9mp91u5j | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 0.03 | 1 | 0.02 | 0.90 | 2.99 | 28.80 | 68.10 | 1fzj71h9hfw0c | Data Pump Worker | SELECT /*+rule*/ SYS_XMLGEN(VA... |
| 0.02 | 1 | 0.01 | 1.02 | 1.74 | 42.57 | 55.08 | 5y20dfyav3thr | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| 0.01 | 1 | 0.01 | 2.92 | 0.36 | 90.42 | 7.75 | 62jfzru1s1mz1 | Data Pump Worker | SELECT /*+all_rows*/ SYS_XMLGE... |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| db block changes | 14,279,288 | 4,026.44 | 88.55 |
| execute count | 1,965,836 | 554.32 | 12.19 |
| gc cr block receive time | 8,732 | 2.46 | 0.05 |
| gc cr blocks received | 55,062 | 15.53 | 0.34 |
| gc current block receive time | 2,313 | 0.65 | 0.01 |
| gc current blocks received | 52,462 | 14.79 | 0.33 |
| logons cumulative | 663 | 0.19 | 0.00 |
| opened cursors cumulative | 280,683 | 79.15 | 1.74 |
| parse count (total) | 1,685,827 | 475.37 | 10.45 |
| parse time elapsed | 21,148 | 5.96 | 0.13 |
| physical reads | 502,059,621 | 141,569.73 | 3,113.34 |
| physical writes | 945,544 | 266.62 | 5.86 |
| redo size | 2,111,008,864 | 595,257.88 | 13,090.63 |
| session cursor cache hits | 5,309 | 1.50 | 0.03 |
| session logical reads | 6,422,256,130 | 1,810,934.41 | 39,825.23 |
| user calls | 2,437,887 | 687.43 | 15.12 |
| user commits | 161,260 | 45.47 | 1.00 |
| user rollbacks | 1 | 0.00 | 0.00 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 43,911 | 12.38 | 0.27 |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| Batched IO (bound) vector count | 82 | 0.02 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 1,227 | 0.35 | 0.01 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 285 | 0.08 | 0.00 |
| Batched IO same unit count | 373 | 0.11 | 0.00 |
| Batched IO single block count | 183 | 0.05 | 0.00 |
| Batched IO slow jump count | 1 | 0.00 | 0.00 |
| Batched IO vector block count | 576 | 0.16 | 0.00 |
| Batched IO vector read count | 164 | 0.05 | 0.00 |
| Block Cleanout Optim referenced | 431 | 0.12 | 0.00 |
| CCursor + sql area evicted | 24 | 0.01 | 0.00 |
| CPU used by this session | 1,749,846 | 493.42 | 10.85 |
| CPU used when call started | 1,704,956 | 480.76 | 10.57 |
| CR blocks created | 40,787 | 11.50 | 0.25 |
| Cached Commit SCN referenced | 5,061 | 1.43 | 0.03 |
| Clusterwide global transactions | 1,134 | 0.32 | 0.01 |
| Commit SCN cached | 265,057 | 74.74 | 1.64 |
| DBWR checkpoint buffers written | 934,091 | 263.39 | 5.79 |
| DBWR checkpoints | 2,421 | 0.68 | 0.02 |
| DBWR fusion writes | 3,779 | 1.07 | 0.02 |
| DBWR object drop buffers written | 85 | 0.02 | 0.00 |
| DBWR parallel query checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 76,292 | 21.51 | 0.47 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 386 | 0.11 | 0.00 |
| DBWR undo block writes | 98,753 | 27.85 | 0.61 |
| DFO trees parallelized | 535 | 0.15 | 0.00 |
| DML statements parallelized | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock background get time | 28 | 0.01 | 0.00 |
| DX/BB enqueue lock background gets | 2,268 | 0.64 | 0.01 |
| DX/BB enqueue lock foreground requests | 37,451 | 10.56 | 0.23 |
| Effective IO time | 2,978,726,439 | 839,935.08 | 18,471.46 |
| GTX processes spawned by autotune | 0 | 0.00 | 0.00 |
| GTX processes stopped by autotune | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 6,508,683 | 1,835.30 | 40.36 |
| Heap Segment Array Inserts | 3,386 | 0.95 | 0.02 |
| Heap Segment Array Updates | 145,260 | 40.96 | 0.90 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 4,075,637 | 1,149.24 | 25.27 |
| PX local messages recv'd | 2,116 | 0.60 | 0.01 |
| PX local messages sent | 2,116 | 0.60 | 0.01 |
| PX remote messages recv'd | 1,116 | 0.31 | 0.01 |
| PX remote messages sent | 1,116 | 0.31 | 0.01 |
| Parallel operations not downgraded | 535 | 0.15 | 0.00 |
| Requests to/from client | 2,387,434 | 673.20 | 14.80 |
| RowCR - row contention | 129 | 0.04 | 0.00 |
| RowCR attempts | 34,983 | 9.86 | 0.22 |
| RowCR hits | 34,891 | 9.84 | 0.22 |
| SMON posted for instance recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 2 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 2,387,424 | 673.20 | 14.80 |
| SQL*Net roundtrips to/from dblink | 18 | 0.01 | 0.00 |
| active txn count during cleanout | 182,395 | 51.43 | 1.13 |
| background checkpoints completed | 4 | 0.00 | 0.00 |
| background checkpoints started | 4 | 0.00 | 0.00 |
| background timeouts | 27,896 | 7.87 | 0.17 |
| branch node splits | 2 | 0.00 | 0.00 |
| buffer is not pinned count | 19,432,969 | 5,479.67 | 120.51 |
| buffer is pinned count | 70,971,737 | 20,012.46 | 440.10 |
| bytes received via SQL*Net from client | 1,626,896,996 | 458,749.03 | 10,088.60 |
| bytes received via SQL*Net from dblink | 5,702 | 1.61 | 0.04 |
| bytes sent via SQL*Net to client | 1,439,845,354 | 406,004.59 | 8,928.66 |
| bytes sent via SQL*Net to dblink | 4,103 | 1.16 | 0.03 |
| calls to get snapshot scn: kcmgss | 8,285,173 | 2,336.24 | 51.38 |
| calls to kcmgas | 551,862 | 155.61 | 3.42 |
| calls to kcmgcs | 4,596,536 | 1,296.12 | 28.50 |
| cell physical IO interconnect bytes | 4,138,470,495,232 | 1,166,957,290.56 | 25,663,182.64 |
| change write time | 4,305 | 1.21 | 0.03 |
| cleanout - number of ktugct calls | 2,123,042 | 598.65 | 13.17 |
| cleanouts and rollbacks - consistent read gets | 40,222 | 11.34 | 0.25 |
| cleanouts only - consistent read gets | 1,924,844 | 542.76 | 11.94 |
| cluster key scan block gets | 207,201 | 58.43 | 1.28 |
| cluster key scans | 171,633 | 48.40 | 1.06 |
| commit batch performed | 1 | 0.00 | 0.00 |
| commit batch requested | 1 | 0.00 | 0.00 |
| commit batch/immediate performed | 51 | 0.01 | 0.00 |
| commit batch/immediate requested | 51 | 0.01 | 0.00 |
| commit cleanout failures: block lost | 566 | 0.16 | 0.00 |
| commit cleanout failures: buffer being written | 64 | 0.02 | 0.00 |
| commit cleanout failures: callback failure | 690 | 0.19 | 0.00 |
| commit cleanout failures: cannot pin | 372 | 0.10 | 0.00 |
| commit cleanouts | 3,978,038 | 1,121.72 | 24.67 |
| commit cleanouts successfully completed | 3,976,346 | 1,121.24 | 24.66 |
| commit immediate performed | 50 | 0.01 | 0.00 |
| commit immediate requested | 50 | 0.01 | 0.00 |
| commit txn count during cleanout | 16,128,686 | 4,547.93 | 100.02 |
| consistent changes | 376,309 | 106.11 | 2.33 |
| consistent gets | 6,414,158,314 | 1,808,651.00 | 39,775.01 |
| consistent gets - examination | 27,397,273 | 7,725.43 | 169.89 |
| consistent gets direct | 502,000,941 | 141,553.18 | 3,112.97 |
| consistent gets from cache | 5,912,157,421 | 1,667,097.84 | 36,662.04 |
| consistent gets from cache (fastpath) | 5,883,859,811 | 1,659,118.53 | 36,486.56 |
| cursor authentications | 108 | 0.03 | 0.00 |
| data blocks consistent reads - undo records applied | 1,488,515 | 419.73 | 9.23 |
| db block gets | 8,099,822 | 2,283.97 | 50.23 |
| db block gets direct | 1,131 | 0.32 | 0.01 |
| db block gets from cache | 8,098,691 | 2,283.65 | 50.22 |
| db block gets from cache (fastpath) | 300,749 | 84.80 | 1.86 |
| deferred (CURRENT) block cleanout applications | 1,148,949 | 323.98 | 7.12 |
| dirty buffers inspected | 6,156 | 1.74 | 0.04 |
| enqueue conversions | 57,476 | 16.21 | 0.36 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 627,623 | 176.98 | 3.89 |
| enqueue requests | 627,676 | 176.99 | 3.89 |
| enqueue timeouts | 66 | 0.02 | 0.00 |
| enqueue waits | 24,267 | 6.84 | 0.15 |
| exchange deadlocks | 1 | 0.00 | 0.00 |
| failed probes on index block reclamation | 2 | 0.00 | 0.00 |
| file io service time | 13,935,545 | 3,929.52 | 86.42 |
| free buffer inspected | 951,533 | 268.31 | 5.90 |
| free buffer requested | 1,118,881 | 315.50 | 6.94 |
| gc blocks compressed | 10,459 | 2.95 | 0.06 |
| gc blocks lost | 0 | 0.00 | 0.00 |
| gc cr block flush time | 35 | 0.01 | 0.00 |
| gc cr blocks served | 4,594 | 1.30 | 0.03 |
| gc current block flush time | 166 | 0.05 | 0.00 |
| gc current block pin time | 0 | 0.00 | 0.00 |
| gc current blocks served | 10,243 | 2.89 | 0.06 |
| gc force cr disk read | 105 | 0.03 | 0.00 |
| gc kbytes saved | 35,654 | 10.05 | 0.22 |
| gc kbytes sent | 83,042 | 23.42 | 0.51 |
| gc local grants | 746,526 | 210.50 | 4.63 |
| gc read waits | 0 | 0.00 | 0.00 |
| gc remote grants | 10,554 | 2.98 | 0.07 |
| gcs messages sent | 324,073 | 91.38 | 2.01 |
| ges messages sent | 67,252 | 18.96 | 0.42 |
| global enqueue get time | 3,620 | 1.02 | 0.02 |
| global enqueue gets async | 2,156 | 0.61 | 0.01 |
| global enqueue gets sync | 1,020,528 | 287.77 | 6.33 |
| global enqueue releases | 952,862 | 268.69 | 5.91 |
| global undo segment hints helped | 0 | 0.00 | 0.00 |
| heap block compress | 35,020 | 9.87 | 0.22 |
| hot buffers moved to head of LRU | 901,385 | 254.17 | 5.59 |
| immediate (CR) block cleanout applications | 1,965,066 | 554.11 | 12.19 |
| immediate (CURRENT) block cleanout applications | 198,996 | 56.11 | 1.23 |
| index crx upgrade (positioned) | 3,635 | 1.02 | 0.02 |
| index fast full scans (direct read) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 83,994 | 23.68 | 0.52 |
| index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
| index fetch by key | 109,332,684 | 30,829.40 | 677.99 |
| index scans kdiixs1 | 2,080,531 | 586.66 | 12.90 |
| leaf node 90-10 splits | 38 | 0.01 | 0.00 |
| leaf node splits | 258 | 0.07 | 0.00 |
| lob reads | 9,565 | 2.70 | 0.06 |
| lob writes | 6,242 | 1.76 | 0.04 |
| lob writes unaligned | 6,234 | 1.76 | 0.04 |
| logical read bytes from cache | 48,498,738,847,744 | 13,675,573,366.21 | 300,746,856.63 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 529,471 | 149.30 | 3.28 |
| messages sent | 529,471 | 149.30 | 3.28 |
| min active SCN optimization applied on CR | 71,506 | 20.16 | 0.44 |
| no buffer to keep pinned count | 150 | 0.04 | 0.00 |
| no work - consistent read gets | 6,379,872,530 | 1,798,983.17 | 39,562.40 |
| non-idle wait count | 7,911,041 | 2,230.74 | 49.06 |
| parse count (describe) | 2 | 0.00 | 0.00 |
| parse count (failures) | 225 | 0.06 | 0.00 |
| parse count (hard) | 179,624 | 50.65 | 1.11 |
| parse time cpu | 14,339 | 4.04 | 0.09 |
| physical read IO requests | 5,002,403 | 1,410.57 | 31.02 |
| physical read bytes | 4,112,872,415,232 | 1,159,739,197.28 | 25,504,445.68 |
| physical read total IO requests | 5,016,426 | 1,414.52 | 31.11 |
| physical read total bytes | 4,115,524,131,328 | 1,160,486,922.66 | 25,520,889.31 |
| physical read total multi block requests | 3,935,031 | 1,109.59 | 24.40 |
| physical reads cache | 608,827 | 171.68 | 3.78 |
| physical reads cache prefetch | 20,789 | 5.86 | 0.13 |
| physical reads direct | 501,450,794 | 141,398.05 | 3,109.56 |
| physical reads direct (lob) | 20,492 | 5.78 | 0.13 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 366,742 | 103.41 | 2.27 |
| physical write bytes | 7,745,896,448 | 2,184,171.75 | 48,033.29 |
| physical write total IO requests | 750,635 | 211.66 | 4.65 |
| physical write total bytes | 22,946,363,904 | 6,470,367.90 | 142,293.33 |
| physical write total multi block requests | 60,590 | 17.09 | 0.38 |
| physical writes direct | 1,177 | 0.33 | 0.01 |
| physical writes direct (lob) | 1,008 | 0.28 | 0.01 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 944,367 | 266.29 | 5.86 |
| physical writes non checkpoint | 411,336 | 115.99 | 2.55 |
| pinned buffers inspected | 125 | 0.04 | 0.00 |
| pinned cursors current | 2 | 0.00 | 0.00 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 231 | 0.07 | 0.00 |
| process last non-idle time | 3,611 | 1.02 | 0.02 |
| queries parallelized | 487 | 0.14 | 0.00 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 1,252,654 | 353.22 | 7.77 |
| recursive cpu usage | 35,900 | 10.12 | 0.22 |
| redo KB read | 2,393,696 | 674.97 | 14.84 |
| redo blocks checksummed by FG (exclusive) | 35,656 | 10.05 | 0.22 |
| redo blocks written | 4,360,676 | 1,229.61 | 27.04 |
| redo buffer allocation retries | 7 | 0.00 | 0.00 |
| redo entries | 7,557,633 | 2,131.09 | 46.87 |
| redo log space requests | 9 | 0.00 | 0.00 |
| redo ordering marks | 92,991 | 26.22 | 0.58 |
| redo size for direct writes | 9,306,308 | 2,624.17 | 57.71 |
| redo subscn max counts | 22,415 | 6.32 | 0.14 |
| redo synch long waits | 445 | 0.13 | 0.00 |
| redo synch time | 89,896 | 25.35 | 0.56 |
| redo synch time (usec) | 898,996,029 | 253,497.03 | 5,574.79 |
| redo synch time overhead (usec) | 13,287,578 | 3,746.80 | 82.40 |
| redo synch time overhead count (<128 msec) | 2 | 0.00 | 0.00 |
| redo synch time overhead count (<2 msec) | 161,237 | 45.47 | 1.00 |
| redo synch time overhead count (<32 msec) | 14 | 0.00 | 0.00 |
| redo synch time overhead count (<8 msec) | 265 | 0.07 | 0.00 |
| redo synch time overhead count (>=128 msec) | 2 | 0.00 | 0.00 |
| redo synch writes | 161,702 | 45.60 | 1.00 |
| redo wastage | 48,748,344 | 13,745.96 | 302.29 |
| redo write broadcast ack count | 52 | 0.01 | 0.00 |
| redo write broadcast ack time | 222,705 | 62.80 | 1.38 |
| redo write broadcast lgwr post count | 0 | 0.00 | 0.00 |
| redo write info find | 161,522 | 45.55 | 1.00 |
| redo write info find fail | 2 | 0.00 | 0.00 |
| redo write time | 57,688 | 16.27 | 0.36 |
| redo writes | 151,490 | 42.72 | 0.94 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 407 | 0.11 | 0.00 |
| rollbacks only - consistent read gets | 10,619 | 2.99 | 0.07 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 378,457 | 106.72 | 2.35 |
| session connect time | 0 | 0.00 | 0.00 |
| shared hash latch upgrades - no wait | 741,091 | 208.97 | 4.60 |
| shared hash latch upgrades - wait | 965 | 0.27 | 0.01 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 177,548 | 50.06 | 1.10 |
| sorts (rows) | 80,856,515 | 22,799.75 | 501.40 |
| sql area evicted | 179,668 | 50.66 | 1.11 |
| sql area purged | 228 | 0.06 | 0.00 |
| summed dirty queue length | 120,361 | 33.94 | 0.75 |
| switch current to new buffer | 261,134 | 73.63 | 1.62 |
| table fetch by rowid | 36,051,661 | 10,165.77 | 223.56 |
| table fetch continued row | 37,011 | 10.44 | 0.23 |
| table scan blocks gotten | 5,650,466,995 | 1,593,306.91 | 35,039.27 |
| table scan rows gotten | 384,864,478,250 | 108,523,283.97 | 2,386,593.65 |
| table scans (cache partitions) | 0 | 0.00 | 0.00 |
| table scans (direct read) | 7,861 | 2.22 | 0.05 |
| table scans (long tables) | 106 | 0.03 | 0.00 |
| table scans (rowid ranges) | 96 | 0.03 | 0.00 |
| table scans (short tables) | 261,966 | 73.87 | 1.62 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 2,900 | 0.82 | 0.02 |
| total number of cf enq holders | 154 | 0.04 | 0.00 |
| total number of times SMON posted | 767 | 0.22 | 0.00 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction rollbacks | 50 | 0.01 | 0.00 |
| transaction tables consistent read rollbacks | 111 | 0.03 | 0.00 |
| transaction tables consistent reads - undo records applied | 291,727 | 82.26 | 1.81 |
| undo change vector size | 767,197,792 | 216,332.84 | 4,757.49 |
| user logons cumulative | 69 | 0.02 | 0.00 |
| user logouts cumulative | 77 | 0.02 | 0.00 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 40 | 0.01 | 0.00 |
| Statistic | Begin Value | End Value |
|---|---|---|
| logons current | 131 | 124 |
| opened cursors current | 539 | 525 |
| session cursor cache count | 387,238 | 388,938 |
| session pga memory | 2,024,430,480 | 2,016,575,536 |
| session pga memory max | 2,313,774,608 | 2,298,251,952 |
| session uga memory | 7,459,296,200 | 7,490,421,008 |
| session uga memory max | 68,758,642,904 | 69,022,367,088 |
| workarea memory allocated | 870 | 1,297 |
| Statistic | Total | per Hour |
|---|---|---|
| log switches (derived) | 4 | 4.06 |
| Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 3.7T | 1139.20 | 1.1G | 0M | 0.01 | 0M | 0 | |
| Data Pump | 18.9G | 105.56 | 5.453M | 7.6G | 9.14 | 2.206M | 370.6K | 0.14 |
| DBWR | 0M | 0.00 | 0M | 7.2G | 103.04 | 2.079M | 0 | |
| Others | 2.5G | 3.93 | .713M | 2.4G | 2.16 | .682M | 13.4K | 0.45 |
| Buffer Cache Reads | 4.6G | 165.59 | 1.335M | 0M | 0.00 | 0M | 587K | 6.63 |
| LGWR | 1M | 0.02 | 0M | 4.2G | 97.21 | 1.201M | 151.6K | 3.29 |
| Direct Writes | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 0 | |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 2 | 7.50 |
| TOTAL: | 3.7T | 1414.29 | 1.1G | 21.4G | 211.57 | 6.169M | 1122.6K | 3.96 |
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|---|---|---|---|---|---|---|---|
| Data File | 3.7T | 1410.44 | 1.1G | 7.2G | 103.34 | 2.082M | 3.70 | 2.62 |
| Data Pump Dump File | 0M | 0.00 | 0M | 7.6G | 8.88 | 2.204M | ||
| Log File | 2.3G | 0.67 | .659M | 4.2G | 97.17 | 1.201M | 2.09 | 6.31 |
| Archive Log | 0M | 0.00 | 0M | 2.3G | 0.66 | .659M | ||
| Control File | 189M | 3.27 | .053M | 84M | 1.53 | .024M | 0.08 | 7.78 |
| TOTAL: | 3.7T | 1414.38 | 1.1G | 21.4G | 211.58 | 6.17M | 3.67 | 2.62 |
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 3.7T | 1139.24 | 1.1G | 0M | 0.01 | 0M | 0 | |
| Direct Reads (Data File) | 3.7T | 1139.24 | 1.1G | 0M | 0.01 | 0M | 0 | |
| Data Pump | 18.9G | 105.56 | 5.453M | 7.6G | 9.14 | 2.206M | 339.2K | 0.15 |
| Data Pump (Data File) | 18.9G | 105.55 | 5.453M | 8M | 0.26 | .002M | 339.1K | 0.15 |
| Data Pump (Data Pump Dump File) | 0M | 0.00 | 0M | 7.6G | 8.88 | 2.204M | 0 | |
| Data Pump (Control File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 14 | 0.14 |
| DBWR | 0M | 0.00 | 0M | 7.2G | 103.04 | 2.079M | 0 | |
| DBWR (Data File) | 0M | 0.00 | 0M | 7.2G | 103.04 | 2.079M | 0 | |
| Others | 2.5G | 3.93 | .713M | 2.4G | 2.16 | .682M | 11.6K | 0.10 |
| Others (Archive Log) | 0M | 0.00 | 0M | 2.3G | 0.66 | .659M | 0 | |
| Others (Log File) | 2.3G | 0.67 | .659M | 0M | 0.00 | 0M | 28 | 1.93 |
| Others (Control File) | 189M | 3.25 | .053M | 83M | 1.50 | .023M | 11.5K | 0.08 |
| Others (Data File) | 2M | 0.01 | .001M | 0M | 0.01 | 0M | 19 | 4.32 |
| Buffer Cache Reads | 4.6G | 165.61 | 1.335M | 0M | 0.00 | 0M | 587.1K | 6.63 |
| Buffer Cache Reads (Data File) | 4.6G | 165.61 | 1.335M | 0M | 0.00 | 0M | 587.1K | 6.63 |
| LGWR | 1M | 0.02 | 0M | 4.2G | 97.20 | 1.202M | 92 | 0.99 |
| LGWR (Log File) | 0M | 0.00 | 0M | 4.2G | 97.17 | 1.202M | 32 | 2.19 |
| LGWR (Control File) | 1M | 0.02 | 0M | 2M | 0.03 | .001M | 60 | 0.35 |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 2 | 7.50 |
| Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 2 | 7.50 |
| Direct Writes | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 0 | |
| Direct Writes (Data File) | 0M | 0.00 | 0M | 0M | 0.01 | 0M | 0 | |
| TOTAL: | 3.7T | 1414.36 | 1.1G | 21.4G | 211.56 | 6.17M | 937.9K | 4.21 |
| Tablespace | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|---|---|
| TAB_CC | 4,031,306 | 1,137 | 0.00 | 123.45 | 3,956 | 0.39 | 4 | 1 | 13,154 | 1.91 |
| IDX_MDB | 538,932 | 152 | 7.33 | 1.00 | 223,452 | 151.98 | 7 | 63 | 1 | 10.00 |
| TAB_MDB | 415,692 | 117 | 0.67 | 9.11 | 127,904 | 109.11 | 1 | 36 | 654 | 0.09 |
| UNDOTBS1 | 10,200 | 3 | 4.60 | 1.00 | 7,852 | 2.88 | 5 | 2 | 85 | 0.00 |
| IDX_CC | 3,408 | 1 | 8.03 | 1.00 | 2,541 | 0.96 | 8 | 1 | 1,145 | 3.27 |
| SYSTEM | 1,733 | 0 | 4.13 | 1.96 | 202 | 0.44 | 4 | 0 | 0 | 0.00 |
| SYSAUX | 860 | 0 | 5.38 | 1.00 | 772 | 0.24 | 5 | 0 | 0 | 0.00 |
| TAB_DEF | 225 | 0 | 8.36 | 1.00 | 265 | 0.06 | 8 | 0 | 0 | 0.00 |
| UNDOTBS2 | 6 | 0 | 0.00 | 1.00 | 6 | 0.00 | 0 | 0 | 442 | 0.70 |
| USERS | 2 | 0 | 0.00 | 1.00 | 2 | 0.00 | 0 | 0 | 0 | 0.00 |
| Tablespace | Filename | Reads | Av Rds/s | Av Rd(ms) | Av Blks/Rd | 1-bk Rds/s | Av 1-bk Rd(ms) | Writes | Writes avg/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| IDX_CC | +CCDATA/cc/datafile/idx_cc.288.827290787 | 2,649 | 1 | 8.03 | 1.00 | 1 | 8.03 | 1,797 | 1 | 883 | 3.19 |
| IDX_CC | +CCDATA/cc/datafile/idx_cc.303.863480949 | 759 | 0 | 8.05 | 1.00 | 0 | 8.05 | 744 | 0 | 262 | 3.51 |
| IDX_MDB | +CCDATA/cc/datafile/idx_mdb.287.827290715 | 538,932 | 152 | 7.33 | 1.00 | 152 | 7.33 | 223,452 | 63 | 1 | 10.00 |
| SYSAUX | +CCDATA/cc/datafile/sysaux.262.827177095 | 860 | 0 | 5.38 | 1.00 | 0 | 5.36 | 772 | 0 | 0 | 0.00 |
| SYSTEM | +CCDATA/cc/datafile/system.261.827177089 | 1,733 | 0 | 4.13 | 1.96 | 0 | 3.90 | 202 | 0 | 0 | 0.00 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.283.827290385 | 625,307 | 176 | 0.00 | 115.71 | 0 | 5.70 | 988 | 0 | 11,104 | 1.83 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.284.827290419 | 494,623 | 139 | 0.00 | 114.35 | 0 | 5.30 | 440 | 0 | 27 | 1.11 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.289.832417847 | 477,766 | 135 | 0.00 | 127.05 | 0 | 4.62 | 351 | 0 | 1,267 | 2.21 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.290.832418099 | 421,053 | 119 | 0.00 | 126.97 | 0 | 4.17 | 309 | 0 | 450 | 2.98 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.291.832418381 | 516,684 | 146 | 0.00 | 126.88 | 0 | 2.53 | 315 | 0 | 180 | 1.39 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.292.832418601 | 580,481 | 164 | 0.00 | 124.65 | 0 | 1.95 | 963 | 0 | 103 | 2.91 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.297.842570797 | 450,669 | 127 | 0.00 | 127.46 | 0 | 7.96 | 329 | 0 | 7 | 0.00 |
| TAB_CC | +CCDATA/cc/datafile/tab_cc.298.842570883 | 464,723 | 131 | 0.00 | 127.48 | 0 | 5.82 | 261 | 0 | 16 | 1.88 |
| TAB_DEF | +CCDATA/cc/datafile/tab_def.282.827290295 | 225 | 0 | 8.36 | 1.00 | 0 | 8.36 | 265 | 0 | 0 | 0.00 |
| TAB_MDB | +CCDATA/cc/datafile/tab_mdb.285.827290631 | 195,736 | 55 | 0.70 | 9.66 | 51 | 0.75 | 65,610 | 19 | 582 | 0.10 |
| TAB_MDB | +CCDATA/cc/datafile/tab_mdb.286.827290665 | 219,956 | 62 | 0.65 | 8.62 | 58 | 0.69 | 62,294 | 18 | 72 | 0.00 |
| UNDOTBS1 | +CCDATA/cc/datafile/undotbs1.263.827177101 | 3,656 | 1 | 4.78 | 1.00 | 1 | 4.78 | 2,626 | 1 | 75 | 0.00 |
| UNDOTBS1 | +CCDATA/cc/datafile/undotbs1.299.842575589 | 3,731 | 1 | 4.45 | 1.00 | 1 | 4.45 | 2,728 | 1 | 6 | 0.00 |
| UNDOTBS1 | +CCDATA/cc/datafile/undotbs1.300.842577267 | 2,813 | 1 | 4.58 | 1.00 | 1 | 4.58 | 2,498 | 1 | 4 | 0.00 |
| UNDOTBS2 | +CCDATA/cc/datafile/undotbs2.265.827177121 | 2 | 0 | 0.00 | 1.00 | 0 | 0.00 | 2 | 0 | 410 | 0.71 |
| UNDOTBS2 | +CCDATA/cc/datafile/undotbs2.301.842577449 | 2 | 0 | 0.00 | 1.00 | 0 | 0.00 | 2 | 0 | 21 | 0.48 |
| UNDOTBS2 | +CCDATA/cc/datafile/undotbs2.302.842577561 | 2 | 0 | 0.00 | 1.00 | 0 | 0.00 | 2 | 0 | 11 | 0.91 |
| USERS | +CCDATA/cc/datafile/users.266.827177135 | 2 | 0 | 0.00 | 1.00 | 0 | 0.00 | 2 | 0 | 0 | 0.00 |
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|---|---|---|---|---|---|---|---|
| D | 1,439,424 | 100 | -2,758,310,389 | 608,857 | 944,367 | 0 | 0 | 15,485 |
| MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 857,705 | 0 |
| Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
|---|---|---|---|---|---|---|---|---|---|---|
| B | 0 | 16 | 100158 | 394254 | 2520759 | 5096034 | 2520759 | 4 | ||
| E | 0 | 9 | 39702 | 321524 | 2057977 | 5096034 | 2057977 | 2 |
| P | Size for Est (M) | Size Factor | Buffers (thousands) | Est Phys Read Factor | Estimated Phys Reads (thousands) | Est Phys Read Time | Est %DBtime for Rds |
|---|---|---|---|---|---|---|---|
| D | 1,216 | 0.10 | 142 | 97.77 | 4,598,437 | 1 | 33700074.00 |
| D | 2,432 | 0.20 | 285 | 29.65 | 1,394,595 | 1 | 10185582.00 |
| D | 3,648 | 0.30 | 427 | 6.82 | 320,885 | 1 | 2305124.00 |
| D | 4,864 | 0.40 | 570 | 4.07 | 191,614 | 1 | 1356345.00 |
| D | 6,080 | 0.49 | 712 | 2.99 | 140,558 | 1 | 981622.00 |
| D | 7,296 | 0.59 | 855 | 2.35 | 110,326 | 1 | 759731.00 |
| D | 8,512 | 0.69 | 997 | 1.88 | 88,296 | 1 | 598049.00 |
| D | 9,728 | 0.79 | 1,140 | 1.51 | 70,887 | 1 | 470272.00 |
| D | 10,944 | 0.89 | 1,282 | 1.20 | 56,570 | 1 | 365197.00 |
| D | 12,160 | 0.99 | 1,424 | 1.01 | 47,678 | 1 | 299928.00 |
| D | 12,288 | 1.00 | 1,439 | 1.00 | 47,033 | 1 | 295198.00 |
| D | 13,376 | 1.09 | 1,567 | 0.91 | 42,644 | 1 | 262981.00 |
| D | 14,592 | 1.19 | 1,709 | 0.84 | 39,274 | 1 | 238249.00 |
| D | 15,808 | 1.29 | 1,852 | 0.78 | 36,915 | 1 | 220938.00 |
| D | 17,024 | 1.39 | 1,994 | 0.75 | 35,109 | 1 | 207683.00 |
| D | 18,240 | 1.48 | 2,137 | 0.72 | 33,727 | 1 | 197539.00 |
| D | 19,456 | 1.58 | 2,279 | 0.70 | 32,765 | 1 | 190479.00 |
| D | 20,672 | 1.68 | 2,422 | 0.68 | 31,975 | 1 | 184678.00 |
| D | 21,888 | 1.78 | 2,564 | 0.66 | 31,122 | 1 | 178422.00 |
| D | 23,104 | 1.88 | 2,706 | 0.65 | 30,469 | 1 | 173626.00 |
| D | 24,320 | 1.98 | 2,849 | 0.51 | 24,122 | 1 | 127044.00 |
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|---|---|
| 100.00 | 11,478 | 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 | 4,096 | 3,195 | 693.47 | 0.85 | 0.12 | 100.00 | 0.00 | 419,430 |
| E | 4,096 | 3,208 | 677.09 | 1.27 | 0.19 | 100.00 | 0.00 | 419,430 |
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|---|---|---|---|---|
| 2K | 4K | 39,311 | 39,311 | 0 | 0 |
| 64K | 128K | 246 | 246 | 0 | 0 |
| 128K | 256K | 34 | 34 | 0 | 0 |
| 256K | 512K | 12 | 12 | 0 | 0 |
| 512K | 1024K | 1,012 | 1,012 | 0 | 0 |
| 1M | 2M | 1,234 | 1,234 | 0 | 0 |
| 2M | 4M | 2 | 2 | 0 | 0 |
| 4M | 8M | 2,058 | 2,058 | 0 | 0 |
| 8M | 16M | 2 | 2 | 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 | Estd Time |
|---|---|---|---|---|---|---|
| 512 | 0.13 | 3,538,060.55 | 113,456.59 | 97.00 | 3,338 | 720,604,914 |
| 1,024 | 0.25 | 3,538,060.55 | 8,506.96 | 100.00 | 0 | 699,893,737 |
| 2,048 | 0.50 | 3,538,060.55 | 5,446.03 | 100.00 | 0 | 699,289,681 |
| 3,072 | 0.75 | 3,538,060.55 | 5,446.03 | 100.00 | 0 | 699,289,681 |
| 4,096 | 1.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 4,915 | 1.20 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 5,734 | 1.40 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 6,554 | 1.60 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 7,373 | 1.80 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 8,192 | 2.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 12,288 | 3.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 16,384 | 4.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 24,576 | 6.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 32,768 | 8.00 | 3,538,060.55 | 1,350.04 | 100.00 | 0 | 698,481,360 |
| 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,752 | 0.67 | 251 | 52,250 | 2,069,202 | 1.00 | 11,956 | 1.06 | 179,216 |
| 3,200 | 0.78 | 699 | 86,994 | 2,069,432 | 1.00 | 11,726 | 1.04 | 179,244 |
| 3,456 | 0.84 | 955 | 106,921 | 2,069,479 | 1.00 | 11,679 | 1.04 | 179,250 |
| 3,520 | 0.86 | 1,019 | 111,906 | 2,069,486 | 1.00 | 11,672 | 1.04 | 179,251 |
| 3,584 | 0.88 | 1,083 | 116,868 | 2,069,495 | 1.00 | 11,663 | 1.04 | 179,252 |
| 3,648 | 0.89 | 1,147 | 121,857 | 2,069,499 | 1.00 | 11,659 | 1.04 | 179,253 |
| 3,712 | 0.91 | 1,211 | 126,828 | 2,069,503 | 1.00 | 11,655 | 1.04 | 179,253 |
| 3,776 | 0.92 | 1,275 | 131,821 | 2,069,505 | 1.00 | 11,653 | 1.04 | 179,254 |
| 3,840 | 0.94 | 1,339 | 136,806 | 2,069,508 | 1.00 | 11,650 | 1.04 | 179,255 |
| 3,904 | 0.95 | 1,403 | 141,820 | 2,069,512 | 1.00 | 11,646 | 1.04 | 179,255 |
| 3,968 | 0.97 | 1,467 | 146,803 | 2,069,514 | 1.00 | 11,644 | 1.04 | 179,255 |
| 4,032 | 0.98 | 1,531 | 151,811 | 2,069,518 | 1.00 | 11,640 | 1.04 | 179,256 |
| 4,096 | 1.00 | 1,595 | 156,667 | 2,069,918 | 1.00 | 11,240 | 1.00 | 179,300 |
| 4,160 | 1.02 | 1,659 | 161,615 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,224 | 1.03 | 1,723 | 166,564 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,288 | 1.05 | 1,786 | 171,552 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,352 | 1.06 | 1,850 | 176,084 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,416 | 1.08 | 1,913 | 180,947 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,480 | 1.09 | 1,977 | 185,928 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,544 | 1.11 | 2,041 | 190,894 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,608 | 1.13 | 2,105 | 195,886 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,672 | 1.14 | 2,150 | 199,455 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 4,992 | 1.22 | 2,488 | 225,722 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 5,440 | 1.33 | 2,936 | 259,958 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 5,888 | 1.44 | 3,383 | 294,860 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 6,336 | 1.55 | 3,829 | 325,868 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 6,784 | 1.66 | 4,277 | 360,581 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 7,232 | 1.77 | 4,725 | 395,036 | 2,069,922 | 1.00 | 11,236 | 1.00 | 179,301 |
| 7,680 | 1.88 | 5,173 | 429,822 | 2,069,923 | 1.00 | 11,235 | 1.00 | 179,301 |
| 8,128 | 1.98 | 5,621 | 464,759 | 2,069,923 | 1.00 | 11,235 | 1.00 | 179,301 |
| 8,576 | 2.09 | 6,069 | 499,543 | 2,069,923 | 1.00 | 11,235 | 1.00 | 179,301 |
| Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
|---|---|---|---|---|---|
| 64 | 0.13 | 0 | 0 | 0 | 0 |
| 128 | 0.25 | 0 | 0 | 0 | 0 |
| 192 | 0.38 | 0 | 0 | 0 | 0 |
| 256 | 0.50 | 0 | 0 | 0 | 0 |
| 320 | 0.63 | 0 | 0 | 0 | 0 |
| 384 | 0.75 | 0 | 0 | 0 | 0 |
| 448 | 0.88 | 0 | 0 | 0 | 0 |
| 512 | 1.00 | 0 | 0 | 0 | 0 |
| 576 | 1.13 | 0 | 0 | 0 | 0 |
| 640 | 1.25 | 0 | 0 | 0 | 0 |
| 704 | 1.38 | 0 | 0 | 0 | 0 |
| 768 | 1.50 | 0 | 0 | 0 | 0 |
| 832 | 1.63 | 0 | 0 | 0 | 0 |
| 896 | 1.75 | 0 | 0 | 0 | 0 |
| 960 | 1.88 | 0 | 0 | 0 | 0 |
| 1,024 | 2.00 | 0 | 0 | 0 | 0 |
| 1,088 | 2.13 | 0 | 0 | 0 | 0 |
| 1,152 | 2.25 | 0 | 0 | 0 | 0 |
| 1,216 | 2.38 | 0 | 0 | 0 | 0 |
| 1,280 | 2.50 | 0 | 0 | 0 | 0 |
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|---|---|---|
| data block | 14,953 | 29 | 2 |
| undo header | 457 | 0 | 1 |
| undo block | 70 | 0 | 1 |
| 1st level bmb | 6 | 0 | 0 |
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|---|---|---|---|---|---|
| KO-Multiple Object Checkpoint (fast object checkpoint) | 93,299 | 93,300 | 0 | 23,385 | 16 | 0.68 |
| PS-PX Process Reservation | 3,815 | 3,751 | 64 | 577 | 2 | 3.59 |
| TQ-Queue table enqueue (TM contention) | 1 | 1 | 0 | 1 | 0 | 300.00 |
| CR-Reuse Block Range (block range reuse ckpt) | 96 | 96 | 0 | 9 | 0 | 11.11 |
| CF-Controlfile Transaction | 7,944 | 7,944 | 0 | 122 | 0 | 0.74 |
| UL-User-defined | 6 | 6 | 0 | 3 | 0 | 30.00 |
| TX-Transaction (row lock contention) | 21 | 21 | 0 | 16 | 0 | 3.13 |
| TQ-Queue table enqueue (DDL contention) | 18 | 17 | 1 | 3 | 0 | 13.33 |
| WF-AWR Flush | 22 | 22 | 0 | 21 | 0 | 1.43 |
| RO-Multiple Object Reuse (fast object reuse) | 60 | 60 | 0 | 13 | 0 | 2.31 |
| TM-DML | 195,353 | 195,223 | 0 | 7 | 0 | 4.29 |
| FB-Format Block | 34 | 34 | 0 | 16 | 0 | 0.63 |
| HW-Segment High Water Mark | 759 | 759 | 0 | 8 | 0 | 1.25 |
| TS-Temporary Segment | 18 | 18 | 0 | 6 | 0 | 1.67 |
| TT-Tablespace | 571 | 571 | 0 | 28 | 0 | 0.00 |
| TD-KTF map table enqueue (KTF dump entries) | 12 | 12 | 0 | 11 | 0 | 0.00 |
| TA-Instance Undo | 23 | 23 | 0 | 10 | 0 | 0.00 |
| TX-Transaction (index contention) | 57 | 57 | 0 | 5 | 0 | 0.00 |
| PI-Remote PX Process Spawn Status | 11 | 11 | 0 | 3 | 0 | 0.00 |
| AE-Edition Lock (lock) | 109 | 109 | 0 | 2 | 0 | 0.00 |
| SR-Synchronized Replication | 67 | 67 | 0 | 2 | 0 | 0.00 |
| AS-Service Operations (service activation) | 8 | 8 | 0 | 2 | 0 | 0.00 |
| PE-Parameter | 8 | 8 | 0 | 2 | 0 | 0.00 |
| WL-Being Written Redo Log | 4 | 4 | 0 | 2 | 0 | 0.00 |
| ZH-Compression Analyzer (compression analysis) | 4 | 4 | 0 | 2 | 0 | 0.00 |
| DR-Distributed Recovery | 2 | 2 | 0 | 2 | 0 | 0.00 |
| MW-MWIN Schedule | 2 | 2 | 0 | 2 | 0 | 0.00 |
| AF-Advisor Framework (task serialization) | 13 | 13 | 0 | 1 | 0 | 0.00 |
| JQ-Job Queue | 6 | 5 | 1 | 1 | 0 | 0.00 |
| TO-Temp Object | 2 | 2 | 0 | 1 | 0 | 0.00 |
| US-Undo Segment | 2 | 2 | 0 | 1 | 0 | 0.00 |
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 2 | 84.12 | 139,054 | 4,597 | 11 | 2186/2237.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 |
|---|---|---|---|---|---|---|---|
| 08-Sep 18:49 | 15,164 | 27,518 | 4,597 | 8 | 2,186 | 0/0 | 0/0/0/0/0/0 |
| 08-Sep 18:39 | 15,661 | 27,944 | 3,996 | 10 | 2,197 | 0/0 | 0/0/0/0/0/0 |
| 08-Sep 18:29 | 15,629 | 27,859 | 3,395 | 9 | 2,208 | 0/0 | 0/0/0/0/0/0 |
| 08-Sep 18:19 | 18,720 | 27,269 | 2,795 | 10 | 2,219 | 0/0 | 0/0/0/0/0/0 |
| 08-Sep 18:09 | 18,943 | 28,464 | 2,193 | 11 | 2,238 | 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 |
|---|---|---|---|---|---|---|
| AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
| AQ dequeue txn counter latch | 946 | 0.00 | 0 | 0 | ||
| ASM Keyed state latch | 234 | 0.43 | 0.00 | 0 | 0 | |
| ASM allocation | 574 | 0.00 | 0 | 0 | ||
| ASM db client latch | 26,140 | 0.00 | 0 | 0 | ||
| ASM map headers | 156 | 0.00 | 0 | 0 | ||
| ASM map load waiting list | 40 | 0.00 | 0 | 0 | ||
| ASM map operation freelist | 275 | 0.00 | 0 | 0 | ||
| ASM map operation hash table | 11,562,791 | 0.00 | 0.01 | 0 | 0 | |
| ASM network SGA latch | 12 | 0.00 | 0 | 0 | ||
| ASM network background latch | 1,806 | 0.00 | 0 | 0 | ||
| ASM network state latch | 407 | 0.00 | 0 | 0 | ||
| ASM scan context latch | 16 | 0.00 | 0 | 0 | ||
| AWR Alerted Metric Element list | 31,937 | 0.00 | 0 | 0 | ||
| Change Notification Hash table latch | 1,187 | 0.00 | 0 | 0 | ||
| Consistent RBA | 151,499 | 0.00 | 0 | 0 | ||
| DML lock allocation | 390,826 | 0.01 | 0.00 | 0 | 0 | |
| Event Group Locks | 785 | 0.00 | 0 | 0 | ||
| FAL Queue | 150 | 0.00 | 0 | 0 | ||
| FIB s.o chain latch | 50 | 0.00 | 0 | 0 | ||
| FOB s.o list latch | 686 | 0.00 | 0 | 0 | ||
| File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
| I/O Staticstics latch | 1 | 0.00 | 0 | 0 | ||
| IPC other latch | 31 | 0.00 | 0 | 0 | ||
| IPC stats buffer allocation latch | 1,484 | 0.00 | 0 | 1,467 | 0.00 | |
| In memory undo latch | 1 | 0.00 | 0 | 0 | ||
| JS Sh mem access | 9 | 0.00 | 0 | 0 | ||
| JS broadcast add buf latch | 814 | 0.00 | 0 | 0 | ||
| JS broadcast drop buf latch | 814 | 0.00 | 0 | 0 | ||
| JS broadcast load blnc latch | 713 | 0.00 | 0 | 0 | ||
| JS mem alloc latch | 8 | 0.00 | 0 | 0 | ||
| JS queue access latch | 5 | 0.00 | 0 | 0 | ||
| JS queue state obj latch | 22,108 | 0.00 | 0 | 0 | ||
| JS slv state obj latch | 25 | 0.00 | 0 | 0 | ||
| KFC FX Hash Latch | 1 | 0.00 | 0 | 0 | ||
| KFC Hash Latch | 1 | 0.00 | 0 | 0 | ||
| KFCL LE Freelist | 1 | 0.00 | 0 | 0 | ||
| KFK SGA Libload latch | 236 | 0.00 | 0 | 0 | ||
| KFMD SGA | 8 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SHM structure | 1 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SVR LIST | 1 | 0.00 | 0 | 0 | ||
| KJC message pool free list | 58,469 | 0.08 | 0.00 | 0 | 9,179 | 0.01 |
| KJCT flow control latch | 708,616 | 0.00 | 0.00 | 0 | 0 | |
| KMG MMAN ready and startup request latch | 1,182 | 0.00 | 0 | 0 | ||
| KSXR large replies | 248 | 0.00 | 0 | 0 | ||
| KTF sga latch | 35 | 2.86 | 0.00 | 0 | 1,194 | 0.00 |
| KWQMN job cache list latch | 352 | 0.00 | 0 | 0 | ||
| KWQP Prop Status | 41 | 0.00 | 0 | 0 | ||
| KWQS pqsubs latch | 5 | 0.00 | 0 | 0 | ||
| KWQS pqueue ctx latch | 7 | 0.00 | 0 | 0 | ||
| Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
| Lsod array latch | 139 | 0.00 | 0 | 0 | ||
| MQL Tracking Latch | 0 | 0 | 71 | 0.00 | ||
| Memory Management Latch | 1 | 0.00 | 0 | 1,182 | 0.00 | |
| Memory Queue | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #1 | 865 | 0.12 | 0.00 | 0 | 0 | |
| Memory Queue Message Subscriber #2 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #3 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #4 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Subscriber | 1 | 0.00 | 0 | 0 | ||
| MinActiveScn Latch | 2,442 | 0.00 | 0 | 0 | ||
| Mutex | 1 | 0.00 | 0 | 0 | ||
| Mutex Stats | 1 | 0.00 | 0 | 0 | ||
| OS process | 700 | 0.00 | 0 | 0 | ||
| OS process allocation | 7,472 | 0.00 | 0 | 0 | ||
| OS process: request allocation | 234 | 0.43 | 0.00 | 0 | 0 | |
| PL/SQL warning settings | 2,754 | 0.00 | 0 | 0 | ||
| PX hash array latch | 1 | 0.00 | 0 | 0 | ||
| QMT | 1 | 0.00 | 0 | 0 | ||
| Real-time plan statistics latch | 22,488 | 0.00 | 0 | 0 | ||
| SGA IO buffer pool latch | 187 | 0.00 | 0 | 187 | 2.67 | |
| SGA blob parent | 1 | 0.00 | 0 | 0 | ||
| SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
| SGA heap locks | 1 | 0.00 | 0 | 0 | ||
| SGA pool locks | 1 | 0.00 | 0 | 0 | ||
| SQL memory manager latch | 1 | 0.00 | 0 | 1,180 | 0.00 | |
| SQL memory manager workarea list latch | 169,507 | 0.00 | 0.00 | 0 | 0 | |
| STREAMS Pool Advisor | 0 | 0 | 13 | 0.00 | ||
| Shared B-Tree | 438 | 0.00 | 0 | 0 | ||
| Streams Generic | 1 | 0.00 | 0 | 0 | ||
| Testing | 1 | 0.00 | 0 | 0 | ||
| Token Manager | 1 | 0.00 | 0 | 0 | ||
| WCR: sync | 1 | 0.00 | 0 | 0 | ||
| Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
| X$KSFQP | 3,294 | 0.00 | 0 | 0 | ||
| XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
| XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
| XDB used session pool | 1 | 0.00 | 0 | 0 | ||
| active checkpoint queue latch | 439,849 | 0.90 | 0.00 | 0 | 0 | |
| active service list | 13,295 | 0.01 | 0.00 | 0 | 9,501 | 0.00 |
| alert log latch | 8 | 0.00 | 0 | 0 | ||
| archive control | 71 | 0.00 | 0 | 0 | ||
| archive process latch | 454 | 0.00 | 0 | 0 | ||
| begin backup scn array | 967 | 0.00 | 0 | 0 | ||
| bq:time manger info latch | 20 | 0.00 | 0 | 0 | ||
| buffer pool | 1 | 0.00 | 0 | 0 | ||
| bufq statistics | 1,506 | 0.00 | 0 | 0 | ||
| business card | 1,071 | 0.00 | 0 | 0 | ||
| cache buffer handles | 13,024 | 0.00 | 0 | 0 | ||
| cache buffers chains | 11,705,588,838 | 0.74 | 0.00 | 0 | 3,420,675 | 0.02 |
| cache buffers lru chain | 1,590,548 | 0.01 | 0.09 | 0 | 4,651,040 | 0.06 |
| cache table scan latch | 637 | 0.00 | 0 | 637 | 0.00 | |
| call allocation | 3,695 | 0.14 | 0.40 | 0 | 0 | |
| cas latch | 1 | 0.00 | 0 | 0 | ||
| change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
| channel handle pool latch | 288 | 0.00 | 0 | 0 | ||
| channel operations parent latch | 2,506,488 | 0.02 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 11,035,038 | 0.00 | 0.03 | 0 | 890,304 | 0.00 |
| client/application info | 4,455 | 0.00 | 0 | 0 | ||
| compile environment latch | 670 | 0.00 | 0 | 0 | ||
| corrupted undo seg latch | 1,271 | 0.00 | 0 | 0 | ||
| cp cmon/server latch | 1 | 0.00 | 0 | 0 | ||
| cp pool latch | 1 | 0.00 | 0 | 0 | ||
| cp server hash latch | 1 | 0.00 | 0 | 0 | ||
| cp sga latch | 59 | 0.00 | 0 | 0 | ||
| cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
| datapump attach fixed tables latch | 538 | 0.00 | 0 | 0 | ||
| datapump job fixed tables latch | 540 | 0.00 | 0 | 0 | ||
| deferred cleanup latch | 59 | 0.00 | 0 | 0 | ||
| dml lock allocation | 71 | 0.00 | 0 | 0 | ||
| done queue latch | 1 | 0.00 | 0 | 0 | ||
| dummy allocation | 1,348 | 0.00 | 0 | 0 | ||
| eighth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
| eleventh spare latch - children | 1 | 0.00 | 0 | 0 | ||
| enqueue freelist latch | 1 | 0.00 | 0 | 535,274 | 0.00 | |
| enqueue hash chains | 1,845,568 | 0.08 | 0.01 | 0 | 35 | 0.00 |
| enqueue sob latch | 7 | 0.00 | 0 | 0 | ||
| enqueues | 1 | 0.00 | 0 | 0 | ||
| error message lists | 2,423 | 0.00 | 0 | 0 | ||
| fifteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
| file cache latch | 495 | 0.00 | 0 | 0 | ||
| first Audit Vault latch | 66 | 0.00 | 0 | 0 | ||
| flashback copy | 1 | 0.00 | 0 | 0 | ||
| fourteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
| fourth Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
| gc element | 1,658,222 | 0.10 | 0.07 | 0 | 4,992 | 0.02 |
| gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
| gcs opaque info freelist | 105,766 | 0.00 | 0.00 | 0 | 0 | |
| gcs partitioned table hash | 6,496,520 | 0.00 | 0.00 | 0 | 750,541 | 0.01 |
| gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
| gcs remaster request queue | 35 | 0.00 | 0 | 0 | ||
| gcs resource freelist | 37,209 | 0.00 | 0 | 13,381 | 0.00 | |
| gcs resource hash | 2,173,099 | 0.04 | 0.01 | 0 | 16 | 0.00 |
| gcs resource scan list | 38 | 0.00 | 0 | 0 | ||
| gcs resource validate list | 1 | 0.00 | 0 | 0 | ||
| gcs shadows freelist | 16,785 | 0.01 | 0.00 | 0 | 15,966 | 0.00 |
| ges caches resource lists | 661,993 | 0.10 | 0.00 | 0 | 98,325 | 0.00 |
| ges deadlock list | 2,028 | 0.00 | 0 | 0 | ||
| ges domain table | 1,843,051 | 0.00 | 0 | 0 | ||
| ges enqueue table freelist | 1,909,251 | 0.00 | 0.05 | 0 | 0 | |
| ges group table | 2,033,512 | 0.00 | 0.00 | 0 | 0 | |
| ges process hash list | 469,901 | 0.00 | 0.00 | 0 | 0 | |
| ges process parent latch | 3,943,091 | 0.00 | 0.98 | 0 | 0 | |
| ges process table freelist | 234 | 0.43 | 0.00 | 0 | 0 | |
| ges resource hash list | 3,845,556 | 0.04 | 0.07 | 0 | 6,187 | 0.05 |
| ges resource scan list | 39 | 0.00 | 0 | 0 | ||
| ges resource table freelist | 11,020 | 0.00 | 0 | 0 | ||
| ges timeout list | 4,938 | 0.00 | 0 | 681 | 0.00 | |
| ges value block free list | 60,284 | 0.03 | 0.11 | 0 | 0 | |
| global KZLD latch for mem in SGA | 66 | 0.00 | 0 | 0 | ||
| global tx hash mapping | 32,125 | 0.00 | 0 | 0 | ||
| granule operation | 1 | 0.00 | 0 | 0 | ||
| hash table column usage latch | 203 | 0.00 | 0 | 182,421 | 0.00 | |
| hash table modification latch | 138 | 0.00 | 0 | 0 | ||
| heartbeat check | 1 | 0.00 | 0 | 1,185 | 0.00 | |
| heartbeat structure management | 0 | 0 | 709 | 0.00 | ||
| image handles of buffered messages latch | 864 | 0.00 | 0 | 0 | ||
| interrupt manipulation | 4,968 | 0.00 | 0 | 0 | ||
| intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
| io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
| job workq parent latch | 7 | 0.00 | 0 | 6 | 0.00 | |
| job_queue_processes free list latch | 12 | 0.00 | 0 | 0 | ||
| job_queue_processes parameter latch | 777 | 0.00 | 0 | 0 | ||
| k2q global data latch | 7,490 | 0.00 | 0 | 0 | ||
| k2q lock allocation | 55,179 | 0.00 | 0 | 0 | ||
| kcbtsemkid latch | 4 | 0.00 | 0 | 0 | ||
| kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
| kgb parent | 1 | 0.00 | 0 | 0 | ||
| kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
| kokc descriptor allocation latch | 217,462 | 0.01 | 0.00 | 0 | 0 | |
| krbmrosl | 2 | 0.00 | 0 | 0 | ||
| ksbxic instance latch | 21 | 0.00 | 0 | 0 | ||
| ksfv messages | 1 | 0.00 | 0 | 0 | ||
| ksim group membership cache | 1,090 | 0.00 | 0 | 0 | ||
| ksim membership request latch | 24 | 0.00 | 0 | 3,542 | 0.00 | |
| kss move lock | 49 | 0.00 | 0 | 0 | ||
| ksuosstats global area | 358 | 0.00 | 0 | 0 | ||
| ksv allocation latch | 154 | 0.00 | 0 | 0 | ||
| ksv class latch | 8,322 | 0.05 | 0.00 | 0 | 0 | |
| ksv instance latch | 2 | 0.00 | 0 | 0 | ||
| ksv msg queue latch | 33 | 0.00 | 0 | 32 | 0.00 | |
| ksxp shared latch | 234 | 0.00 | 0 | 0 | ||
| ksxp so latch | 234 | 0.43 | 0.00 | 0 | 0 | |
| ksz_so allocation latch | 234 | 0.00 | 0 | 0 | ||
| ktm global data | 1,582 | 0.00 | 0 | 0 | ||
| kupp process latch | 26 | 0.00 | 0 | 0 | ||
| kwqbsgn:msghdr | 1,296 | 0.00 | 0 | 0 | ||
| kwqbsn:qsga | 375 | 0.53 | 0.00 | 0 | 13 | 0.00 |
| kwqbsn:qxl | 22 | 0.00 | 0 | 0 | ||
| kwqi:kchunk latch | 2 | 0.00 | 0 | 0 | ||
| lgwr LWN SCN | 155,123 | 0.01 | 0.00 | 0 | 0 | |
| list of block allocation | 371,013 | 0.02 | 0.00 | 0 | 0 | |
| loader state object freelist | 24,595 | 0.00 | 0 | 0 | ||
| lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
| lob segment hash table latch | 13 | 0.00 | 0 | 0 | ||
| lob segment query latch | 1 | 0.00 | 0 | 0 | ||
| lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
| logical standby cache | 1 | 0.00 | 0 | 0 | ||
| logminer context allocation | 2 | 0.00 | 0 | 0 | ||
| logminer local | 1 | 0.00 | 0 | 0 | ||
| logminer work area | 1 | 0.00 | 0 | 0 | ||
| longop free list parent | 439 | 0.00 | 0 | 4 | 0.00 | |
| managed standby latch | 146 | 0.00 | 0 | 0 | ||
| mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
| message pool operations parent latch | 43,417 | 0.00 | 0 | 0 | ||
| messages | 1,660,462 | 0.50 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 157,391 | 0.51 | 0.01 | 0 | 0 | |
| msg queue latch | 1 | 0.00 | 0 | 0 | ||
| multiblock read objects | 42,554 | 0.03 | 0.00 | 0 | 0 | |
| name-service memory objects | 34,701 | 0.00 | 0 | 0 | ||
| name-service namespace bucket | 38,703 | 0.00 | 0 | 0 | ||
| name-service namespace objects | 11 | 0.00 | 0 | 0 | ||
| name-service pending queue | 24,356 | 0.00 | 0 | 0 | ||
| name-service request | 44 | 0.00 | 0 | 0 | ||
| name-service request queue | 63,881 | 0.00 | 0 | 0 | ||
| ncodef allocation latch | 59 | 0.00 | 0 | 0 | ||
| nineth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
| object queue header heap | 18,875 | 0.00 | 0 | 18,510 | 0.00 | |
| object queue header operation | 6,304,716 | 0.01 | 0.06 | 0 | 0 | |
| object stats modification | 888 | 0.00 | 0 | 0 | ||
| parallel query alloc buffer | 11,664 | 0.00 | 0 | 0 | ||
| parallel query stats | 2,038 | 0.00 | 0 | 0 | ||
| parallel txn reco latch | 3,680 | 0.00 | 0 | 0 | ||
| parameter list | 788 | 0.00 | 0 | 0 | ||
| parameter table management | 3,515 | 0.03 | 0.00 | 0 | 0 | |
| pass worker exception to master | 8 | 0.00 | 0 | 0 | ||
| peshm | 1 | 0.00 | 0 | 0 | ||
| pesom_free_list | 1 | 0.00 | 0 | 0 | ||
| pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
| post/wait queue | 330,101 | 0.01 | 0.00 | 0 | 257,331 | 0.21 |
| process allocation | 17,484 | 0.00 | 0 | 114 | 0.00 | |
| process group creation | 234 | 0.00 | 0 | 0 | ||
| process queue | 5,934 | 0.00 | 0 | 0 | ||
| process queue reference | 97,226 | 0.00 | 0.00 | 0 | 8,860 | 0.03 |
| qmn state object latch | 1 | 0.00 | 0 | 0 | ||
| qmn task queue latch | 1,118 | 1.88 | 0.10 | 0 | 0 | |
| query server freelists | 4,853 | 0.00 | 0 | 0 | ||
| query server process | 541 | 0.37 | 0.50 | 0 | 7 | 0.00 |
| queue sender's info. latch | 1,566 | 0.13 | 0.00 | 0 | 0 | |
| queued dump request | 12 | 0.00 | 0 | 0 | ||
| queuing load statistics | 1 | 0.00 | 0 | 0 | ||
| recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
| redo allocation | 486,419 | 0.39 | 0.03 | 0 | 7,557,266 | 0.20 |
| redo copy | 1 | 0.00 | 0 | 7,561,272 | 0.01 | |
| redo writing | 848,062 | 0.28 | 0.00 | 0 | 0 | |
| resmgr group change latch | 641 | 0.00 | 0 | 0 | ||
| resmgr:active threads | 1,348 | 0.00 | 0 | 0 | ||
| resmgr:actses change group | 651 | 0.00 | 0 | 0 | ||
| resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
| resmgr:free threads list | 1,347 | 0.00 | 0 | 0 | ||
| resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
| resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
| resmgr:schema config | 61 | 0.00 | 0 | 0 | ||
| resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
| resumable state object | 468 | 0.00 | 0 | 0 | ||
| rm cas latch | 1 | 0.00 | 0 | 0 | ||
| row cache objects | 40,962,509 | 0.01 | 0.00 | 0 | 56 | 0.00 |
| rules engine aggregate statistics | 958 | 0.00 | 0 | 0 | ||
| rules engine evaluation context statistics | 4 | 0.00 | 0 | 0 | ||
| rules engine rule set statistics | 2,464 | 0.00 | 0 | 0 | ||
| rules engine rule statistics | 436 | 0.00 | 0 | 0 | ||
| second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
| segmented array pool | 40 | 0.00 | 0 | 0 | ||
| sequence cache | 15,270 | 0.00 | 0 | 0 | ||
| session allocation | 181,175 | 0.00 | 0.00 | 0 | 179,735 | 0.00 |
| session idle bit | 5,054,339 | 0.00 | 0.03 | 0 | 0 | |
| session queue latch | 1 | 0.00 | 0 | 0 | ||
| session state list latch | 1,247 | 0.00 | 0 | 0 | ||
| session switching | 180 | 0.00 | 0 | 0 | ||
| session timer | 1,184 | 0.00 | 0 | 0 | ||
| seventh spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
| shared pool | 8,805,909 | 0.01 | 0.20 | 0 | 11 | 0.00 |
| shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
| shared pool simulator | 717,129 | 0.00 | 0 | 0 | ||
| shared server configuration | 12 | 0.00 | 0 | 0 | ||
| sim partition latch | 1 | 0.00 | 0 | 0 | ||
| simulator hash latch | 330,167,355 | 0.00 | 0.01 | 0 | 0 | |
| simulator lru latch | 1 | 0.00 | 0 | 330,146,558 | 12.38 | |
| sixth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
| sort extent pool | 898 | 0.00 | 0 | 0 | ||
| space background state object latch | 14 | 0.00 | 0 | 0 | ||
| space background task latch | 4,689 | 0.73 | 0.00 | 0 | 2,368 | 0.04 |
| spilled messages latch | 6 | 0.00 | 0 | 0 | ||
| state object free list | 2 | 0.00 | 0 | 0 | ||
| statistics aggregation | 6,053 | 0.00 | 0 | 0 | ||
| tablespace key chain | 1 | 0.00 | 0 | 0 | ||
| temp lob duration state obj allocation | 8 | 0.00 | 0 | 0 | ||
| temporary table state object allocation | 2 | 0.00 | 0 | 0 | ||
| tenth spare latch - X parent | 1 | 0.00 | 0 | 0 | ||
| test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
| test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
| thirteenth spare latch - children | 1 | 0.00 | 0 | 0 | ||
| threshold alerts latch | 177 | 0.00 | 0 | 0 | ||
| transaction allocation | 4,338 | 0.00 | 0 | 0 | ||
| transaction branch allocation | 29,906 | 0.00 | 0 | 0 | ||
| twelfth spare latch - children | 1 | 0.00 | 0 | 0 | ||
| twenty-fifth spare latch - S par | 1 | 0.00 | 0 | 0 | ||
| twenty-first spare latch - S par | 1 | 0.00 | 0 | 0 | ||
| twenty-fourth spare latch - S par | 1 | 0.00 | 0 | 0 | ||
| twenty-second spare latch - S par | 1 | 0.00 | 0 | 0 | ||
| twenty-third spare latch - S par | 1 | 0.00 | 0 | 0 | ||
| undo global data | 15,012,223 | 0.00 | 0.00 | 0 | 0 | |
| virtual circuit buffers | 1 | 0.00 | 0 | 0 | ||
| virtual circuit holder | 1 | 0.00 | 0 | 0 | ||
| virtual circuit queues | 1 | 0.00 | 0 | 0 | ||
| write info latch | 0 | 0 | 151,558 | 0.02 |
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
|---|---|---|---|---|
| cache buffers chains | 11,705,588,838 | 86,065,473 | 1,911 | 86,110,532 |
| simulator hash latch | 330,167,355 | 14,507 | 78 | 14,431 |
| messages | 1,660,462 | 8,321 | 17 | 8,304 |
| row cache objects | 40,962,509 | 5,797 | 24 | 5,775 |
| active checkpoint queue latch | 439,849 | 3,969 | 11 | 3,958 |
| redo writing | 848,062 | 2,371 | 3 | 2,368 |
| redo allocation | 486,419 | 1,897 | 49 | 1,848 |
| gc element | 1,658,222 | 1,616 | 112 | 1,504 |
| ges resource hash list | 3,845,556 | 1,469 | 99 | 1,371 |
| enqueue hash chains | 1,845,568 | 1,391 | 8 | 1,383 |
| gcs resource hash | 2,173,099 | 959 | 6 | 954 |
| object queue header operation | 6,304,716 | 869 | 49 | 821 |
| mostly latch-free SCN | 157,391 | 798 | 7 | 791 |
| ges caches resource lists | 661,993 | 637 | 2 | 635 |
| undo global data | 15,012,223 | 499 | 1 | 498 |
| channel operations parent latch | 2,506,488 | 458 | 1 | 457 |
| shared pool | 8,805,909 | 451 | 88 | 365 |
| checkpoint queue latch | 11,035,038 | 334 | 10 | 324 |
| ASM map operation hash table | 11,562,791 | 156 | 1 | 155 |
| cache buffers lru chain | 1,590,548 | 128 | 12 | 116 |
| ges process parent latch | 3,943,091 | 52 | 51 | 1 |
| ges enqueue table freelist | 1,909,251 | 41 | 2 | 39 |
| session idle bit | 5,054,339 | 31 | 1 | 30 |
| qmn task queue latch | 1,118 | 21 | 2 | 19 |
| ges value block free list | 60,284 | 18 | 2 | 16 |
| call allocation | 3,695 | 5 | 2 | 3 |
| query server process | 541 | 2 | 1 | 1 |
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|---|---|---|---|
| ASM map operation hash table | kffmTranslate | 0 | 1 | 1 |
| active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 11 | 11 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 1,080 | 1,494 |
| cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 845 | 533 |
| cache buffers chains | kcbgcur_2 | 0 | 198 | 81 |
| cache buffers chains | kcbchg1: mod cr pin | 0 | 135 | 82 |
| cache buffers chains | kcbgtcr: fast path | 0 | 119 | 24 |
| cache buffers chains | kcbzwb | 0 | 111 | 52 |
| cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 75 | 0 |
| cache buffers chains | kcbgtcr_2 | 0 | 66 | 120 |
| cache buffers chains | kcbgtcr: kslbegin shared | 0 | 19 | 2 |
| cache buffers chains | kcbrls_2 | 0 | 14 | 86 |
| cache buffers chains | kcbget: fast exchange | 0 | 10 | 0 |
| cache buffers chains | kcbbxsv | 0 | 6 | 0 |
| cache buffers chains | kcbchg1: clear MS bit | 0 | 6 | 32 |
| cache buffers chains | kcbnew: new latch again | 0 | 6 | 0 |
| cache buffers chains | kcbnlc | 0 | 6 | 5 |
| cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 4 | 0 |
| cache buffers chains | kcbgtcr_1 | 0 | 3 | 0 |
| cache buffers chains | kclcqchk | 0 | 3 | 0 |
| cache buffers chains | kclcls_3 | 0 | 2 | 5 |
| cache buffers chains | kcbchg1: aux pin | 0 | 1 | 1 |
| cache buffers chains | kcbgcur_4 | 0 | 1 | 0 |
| cache buffers chains | kcbget: fast path | 0 | 1 | 0 |
| cache buffers chains | kcbzib: finish processing buffer | 0 | 1 | 0 |
| cache buffers chains | kcllkopesc | 0 | 1 | 0 |
| cache buffers lru chain | kcbzgws | 0 | 11 | 0 |
| cache buffers lru chain | kcbzgb | 0 | 1 | 3 |
| call allocation | ksuxds | 0 | 2 | 2 |
| channel operations parent latch | ksrwait() | 0 | 1 | 1 |
| checkpoint queue latch | kcbkubc_4 | 0 | 6 | 6 |
| checkpoint queue latch | kcbswcu: Switch buffers | 0 | 3 | 0 |
| checkpoint queue latch | kcbklbc_cql | 0 | 1 | 0 |
| enqueue hash chains | ksqgtl3 | 0 | 4 | 3 |
| enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 2 | 2 |
| enqueue hash chains | ksqrcl | 0 | 2 | 3 |
| gc element | kclnfndnewm | 0 | 280 | 0 |
| gc element | kclrwrite | 0 | 7 | 7 |
| gc element | kclchkping | 0 | 4 | 0 |
| gc element | kclfwrite1 | 0 | 3 | 3 |
| gc element | kclplz_1 | 0 | 1 | 0 |
| gc element | kclulb | 0 | 1 | 0 |
| gcs resource hash | kjbcrcomplete | 0 | 3 | 2 |
| gcs resource hash | kjbmpcreatepi | 0 | 2 | 1 |
| gcs resource hash | kjbmdowncvt | 0 | 1 | 2 |
| ges caches resource lists | kjchc: clean resource cache | 0 | 2 | 0 |
| ges enqueue table freelist | kjlalc: lock allocation | 0 | 1 | 0 |
| ges enqueue table freelist | kjlfr: remove lock from parent object | 0 | 1 | 2 |
| ges process parent latch | kjata_fg | 0 | 51 | 0 |
| ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 45 | 10 |
| ges resource hash list | kjrmas1: lookup master node | 0 | 18 | 1 |
| ges resource hash list | kjakcai: search for resp by resname | 0 | 15 | 22 |
| ges resource hash list | kjucvl: lock convert request | 0 | 9 | 15 |
| ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 6 | 25 |
| ges resource hash list | kjrref: find matched resource | 0 | 4 | 5 |
| ges resource hash list | kjakoca: search for resp by resname | 0 | 1 | 20 |
| ges resource hash list | kjuinq: inquire resource held mode | 0 | 1 | 0 |
| ges value block free list | kjvblkfr: free | 0 | 2 | 1 |
| lgwr LWN SCN | kcs023 | 0 | 3 | 0 |
| messages | ksarcv | 0 | 8 | 5 |
| messages | ksaamb: after wakeup | 0 | 7 | 10 |
| messages | ksarcv: after wait | 0 | 2 | 2 |
| mostly latch-free SCN | kcslcu3 | 0 | 4 | 7 |
| object queue header operation | kcbo_write_q | 0 | 29 | 0 |
| object queue header operation | kcbo_service_ockpt | 0 | 7 | 0 |
| object queue header operation | kcbo_switch_q_bg | 0 | 7 | 32 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 6 | 16 |
| object queue header operation | kcbo_lbufcnt | 0 | 1 | 1 |
| object queue header operation | kcbo_link_q | 0 | 1 | 0 |
| object queue header operation | kcbo_switch_cq | 0 | 1 | 2 |
| object queue header operation | kcbo_unlink_q | 0 | 1 | 2 |
| qmn task queue latch | kwqmngettsk: get task | 0 | 1 | 2 |
| qmn task queue latch | kwqmnmvtsks: delay to ready list | 0 | 1 | 0 |
| query server process | kxfpg1srv | 0 | 1 | 1 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 47 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 2 | 29 |
| redo writing | kcrfwcr | 0 | 3 | 2 |
| row cache objects | kqreqd: reget | 0 | 12 | 0 |
| row cache objects | kqrpre: find obj | 0 | 8 | 22 |
| row cache objects | kqreqd | 0 | 3 | 1 |
| row cache objects | kqrigt | 0 | 1 | 1 |
| session idle bit | ksupuc: set busy | 0 | 1 | 0 |
| shared pool | kghalo | 0 | 73 | 21 |
| shared pool | kghalp | 0 | 8 | 5 |
| shared pool | kghasp | 0 | 4 | 0 |
| shared pool | kghupr1 | 0 | 2 | 54 |
| shared pool | kghfre | 0 | 1 | 7 |
| simulator hash latch | kcbsacc: lookup dba | 0 | 78 | 78 |
| undo global data | ktudba: KSLBEGIN | 0 | 1 | 1 |
| Mutex Type | Location | Sleeps | Wait Time (ms) |
|---|---|---|---|
| Library Cache | kglhdgn1 62 | 58 | 0 |
| Library Cache | kglhdgn2 106 | 52 | 0 |
| Library Cache | kgllkdl1 85 | 38 | 0 |
| Library Cache | kgllkc1 57 | 32 | 0 |
| Library Cache | kglpnal2 91 | 15 | 0 |
| Cursor Pin | kksfbc [KKSCHLPIN1] | 10 | 0 |
| Cursor Pin | kksLockDelete [KKSCHLPIN6] | 9 | 0 |
| Cursor Pin | kksfbc [KKSCHLFSP2] | 9 | 0 |
| Library Cache | kglpnal1 90 | 4 | 0 |
| Library Cache | kgllkal1 80 | 3 | 0 |
| Library Cache | kglpin1 4 | 3 | 0 |
| Library Cache | kglhdgh1 64 | 1 | 0 |
| hash table | kkscsSearchChildList [KKSHBKLOC2] | 1 | 0 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | CC_MDB_CHANGE_NOTIF | TABLE | 4,975,391,728 | 77.47 | |
| CC | TAB_CC | IDX_OLC_SEQUENCE_TNAME | INDEX | 576,644,464 | 8.98 | |
| CC | TAB_CC | RTQM_RERATING_SUBS | TABLE | 462,068,624 | 7.19 | |
| CC | TAB_CC | PROD | TABLE | 143,894,160 | 2.24 | |
| CC | TAB_CC | IDX_CC_TNAME_SEQUENCE | INDEX | 72,312,352 | 1.13 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | RTQM_RERATING_SUBS | TABLE | 462,019,679 | 92.02 | |
| CC | TAB_CC | SUBS_IDENTIFY | TABLE | 34,921,059 | 6.96 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 2,847,015 | 0.57 | |
| CC | TAB_CC | ADVICE_HIS | TABLE | 724,883 | 0.14 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 513,993 | 0.10 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | RTQM_RERATING_SUBS | TABLE | 3,739,669 | 74.76 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 513,981 | 10.27 | |
| CC | TAB_CC | SUBS_IDENTIFY | TABLE | 284,546 | 5.69 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 41,158 | 0.82 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_UPP_ACM_CYCLE | INDEX | 15,980 | 0.32 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | RTQM_RERATING_SUBS | TABLE | 3,739,669 | 74.76 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 513,981 | 10.27 | |
| CC | TAB_CC | SUBS_IDENTIFY | TABLE | 284,546 | 5.69 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 41,158 | 0.82 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_UPP_ACM_CYCLE | INDEX | 15,980 | 0.32 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | RTQM_RERATING_SUBS | TABLE | 462,012,705 | 92.14 | |
| CC | TAB_CC | SUBS_IDENTIFY | TABLE | 34,920,628 | 6.96 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 2,827,993 | 0.56 | |
| CC | TAB_CC | ADVICE_HIS | TABLE | 724,875 | 0.14 | |
| MDB | TAB_MDB | BAL | TABLE | 292,477 | 0.06 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
|---|---|---|---|---|---|---|
| MDB | TAB_MDB | BAL | TABLE | 260,784 | 27.58 | |
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 235,014 | 24.85 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 107,001 | 11.32 | |
| MDB | TAB_MDB | BAL_USED_RECORD | TABLE | 79,922 | 8.45 | |
| MDB | TAB_MDB | SUBS_ACCT_UPP_ACM_CYCLE | TABLE | 63,312 | 6.70 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
|---|---|---|---|---|---|---|
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 221,089 | 60.28 | |
| MDB | TAB_MDB | BAL | TABLE | 42,517 | 11.59 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 32,853 | 8.96 | |
| MDB | TAB_MDB | IMSI_ACCT_UPP_ACM_CYCLE | TABLE | 16,282 | 4.44 | |
| MDB | TAB_MDB | SUBS_ACCT_UPP_ACM_CYCLE | TABLE | 14,431 | 3.93 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
|---|---|---|---|---|---|---|
| ** MISSING ** | TAB_MDB | ** MISSING: 577860/577860 | ** MISSING ** | UNDEFINED | 988 | 83.94 |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_2038674490_7996 | TABLE PARTITION | 114 | 9.69 |
| ** MISSING ** | TAB_MDB | ** MISSING: 577875/577875 | ** MISSING ** | UNDEFINED | 6 | 0.51 |
| ** MISSING ** | TAB_MDB | ** MISSING: 577874/577874 | ** MISSING ** | UNDEFINED | 3 | 0.25 |
| CC | TAB_CC | SYS_LOB0000021931C00035$$ | LOB | 1 | 0.08 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | IDX_OLC_SEQUENCE_TNAME | INDEX | 76,315 | 90.74 | |
| CC | TAB_CC | IDX_OLC_UPDATE_TIME | INDEX | 7,612 | 9.05 | |
| CC | TAB_CC | PROD | TABLE | 3 | 0.00 | |
| MDB | TAB_MDB | BAL | TABLE | 2 | 0.00 | |
| MDB | TAB_MDB | BAL_USED_RECORD | TABLE | 2 | 0.00 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
|---|---|---|---|---|---|---|
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 1,920,176 | 28.37 | |
| MDB | TAB_MDB | BAL | TABLE | 1,579,600 | 23.34 | |
| MDB | TAB_MDB | SUBS_ACCT_UPP_ACM_CYCLE | TABLE | 975,840 | 14.42 | |
| MDB | TAB_MDB | IMSI_ACCT_UPP_ACM_CYCLE | TABLE | 913,024 | 13.49 | |
| MDB | TAB_MDB | BAL_USED_RECORD | TABLE | 703,248 | 10.39 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
|---|---|---|---|---|---|---|
| CC | IDX_CC | IDX_CLTCONVT_FILEID | INDEX | 14 | 18.42 | |
| CC | IDX_CC | IDX_CLTCONVT_DFILE | INDEX | 11 | 14.47 | |
| CC | TAB_CC | OLC_MDB_CHANGE_NOTIF | TABLE | 8 | 10.53 | |
| CC | TAB_CC | POLL_LOCKS | TABLE | 8 | 10.53 | |
| CC | IDX_CC | IDX_CLT_FILELIST_NAME | INDEX | 6 | 7.89 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
|---|---|---|---|---|---|---|
| CC | TAB_CC | OLC_MDB_SEQUENCE | TABLE | 873 | 46.56 | |
| MDB | TAB_MDB | TT_MDB_SEQUENCE | TABLE | 561 | 29.92 | |
| CC | TAB_CC | CC_MDB_SEQUENCE | TABLE | 313 | 16.69 | |
| MDB | TAB_MDB | BAL | TABLE | 66 | 3.52 | |
| CC | TAB_CC | CC_MDB_CHANGE_NOTIF | TABLE | 23 | 1.23 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
|---|---|---|---|---|---|---|
| CC | TAB_CC | CC_MDB_CHANGE_NOTIF | TABLE | 9,787 | 81.17 | |
| CC | TAB_CC | IDX_CC_TNAME_SEQUENCE | INDEX | 1,301 | 10.79 | |
| CC | TAB_CC | IDX_OLC_SEQUENCE_TNAME | INDEX | 605 | 5.02 | |
| CC | IDX_CC | PK_SUBS_IDENTIFY_HIS | P9 | INDEX PARTITION | 110 | 0.91 |
| CC | TAB_CC | OLC_MDB_CHANGE_NOTIF | TABLE | 51 | 0.42 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
|---|---|---|---|---|---|---|
| CC | TAB_CC | CC_MDB_CHANGE_NOTIF | TABLE | 14,159 | 25.71 | |
| CC | TAB_CC | IDX_CC_TNAME_SEQUENCE | INDEX | 8,320 | 15.11 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 4,030 | 7.32 | |
| CC | TAB_CC | IDX_OLC_SEQUENCE_TNAME | INDEX | 3,833 | 6.96 | |
| CC | TAB_CC | PROD | TABLE | 1,241 | 2.25 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
|---|---|---|---|---|---|---|
| MDB | IDX_MDB | PK_IMSI_ACCT_ACM_DAILY | INDEX | 12,051 | 22.97 | |
| MDB | TAB_MDB | IMSI_ACCT_ACM_DAILY | TABLE | 4,073 | 7.76 | |
| SYS | SYSTEM | IND$ | TABLE | 2,127 | 4.05 | |
| CC | TAB_CC | SUBS_IDENTIFY | TABLE | 1,837 | 3.50 | |
| CC | TAB_CC | SUBS_UPP_INST | TABLE | 1,753 | 3.34 |
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|---|---|---|---|---|---|
| dc_awr_control | 72 | 1.39 | 0 | 1 | 1 | |
| dc_constraints | 15 | 53.33 | 0 | 15 | 1 | |
| dc_files | 23 | 0.00 | 0 | 0 | 23 | |
| dc_global_oids | 110,437 | 0.01 | 0 | 4 | 302 | |
| dc_histogram_data | 8,500 | 0.00 | 0 | 0 | 4,435 | |
| dc_histogram_defs | 934,978 | 0.01 | 0 | 0 | 10,031 | |
| dc_object_grants | 13 | 0.00 | 0 | 0 | 436 | |
| dc_objects | 1,018,008 | 0.01 | 0 | 96 | 8,313 | |
| dc_profiles | 137 | 0.00 | 0 | 0 | 2 | |
| dc_rollback_segments | 10,122,741 | 0.00 | 0 | 0 | 162 | |
| dc_segments | 722,167 | 0.00 | 0 | 37 | 5,244 | |
| dc_sequences | 1,529 | 7.98 | 0 | 1,529 | 7 | |
| dc_table_scns | 1 | 100.00 | 0 | 0 | 0 | |
| dc_tablespaces | 46,098 | 0.00 | 0 | 0 | 12 | |
| dc_users | 803,696 | 0.00 | 0 | 0 | 284 | |
| global database name | 4,409 | 0.00 | 0 | 0 | 2 | |
| outstanding_alerts | 48 | 100.00 | 0 | 0 | 8 | |
| rule_info | 8 | 100.00 | 0 | 0 | 0 |
| Cache | GES Requests | GES Conflicts | GES Releases |
|---|---|---|---|
| dc_awr_control | 3 | 1 | 0 |
| dc_constraints | 25 | 0 | 3 |
| dc_global_oids | 10 | 0 | 4 |
| dc_histogram_defs | 193 | 0 | 0 |
| dc_objects | 153 | 0 | 23 |
| dc_segments | 86 | 0 | 8 |
| dc_sequences | 3,056 | 120 | 1 |
| dc_table_scns | 1 | 0 | 0 |
| dc_users | 14 | 0 | 10 |
| outstanding_alerts | 96 | 24 | 16 |
| rule_info | 8 | 0 | 0 |
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|---|---|---|---|---|---|
| ACCOUNT_STATUS | 198 | 0.51 | 0 | 0 | 0 | |
| APP CONTEXT | 1 | 100.00 | 2 | 50.00 | 0 | 0 |
| BODY | 409 | 0.00 | 4,763 | 0.08 | 4 | 0 |
| CLUSTER | 6 | 0.00 | 6 | 0.00 | 0 | 0 |
| DBLINK | 214 | 0.47 | 0 | 0 | 0 | |
| DIRECTORY | 1 | 100.00 | 2 | 100.00 | 0 | 0 |
| EDITION | 91 | 0.00 | 164 | 0.00 | 0 | 0 |
| INDEX | 21 | 38.10 | 21 | 57.14 | 4 | 0 |
| OBJECT ID | 20 | 100.00 | 0 | 0 | 0 | |
| QUEUE | 899 | 0.33 | 3,409 | 0.26 | 2 | 0 |
| RULE | 11 | 72.73 | 11 | 72.73 | 0 | 0 |
| RULESET | 32 | 37.50 | 997 | 1.60 | 0 | 0 |
| SCHEMA | 150 | 0.00 | 0 | 0 | 0 | |
| SQL AREA | 802,012 | 22.35 | 2,336,638 | 23.03 | 344 | 321 |
| SQL AREA BUILD | 179,620 | 99.85 | 0 | 0 | 0 | |
| SQL AREA STATS | 179,563 | 99.86 | 179,563 | 99.86 | 0 | 0 |
| SUBSCRIPTION | 5 | 80.00 | 5 | 80.00 | 0 | 0 |
| TABLE/PROCEDURE | 279,356 | 0.01 | 1,202,566 | 0.05 | 551 | 0 |
| TRANSFORMATION | 354 | 0.00 | 354 | 0.00 | 0 | 0 |
| TRIGGER | 27 | 22.22 | 822 | 0.73 | 0 | 0 |
| Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
|---|---|---|---|---|---|
| ACCOUNT_STATUS | 198 | 0 | 0 | 0 | 0 |
| BODY | 0 | 4,663 | 4,663 | 0 | 0 |
| CLUSTER | 6 | 6 | 6 | 0 | 0 |
| DBLINK | 214 | 0 | 0 | 0 | 0 |
| DIRECTORY | 0 | 2 | 2 | 0 | 0 |
| EDITION | 91 | 91 | 91 | 0 | 0 |
| INDEX | 21 | 21 | 21 | 0 | 0 |
| QUEUE | 2,122 | 3,406 | 3,406 | 0 | 0 |
| RULE | 11 | 11 | 11 | 0 | 0 |
| RULESET | 35 | 993 | 993 | 0 | 0 |
| SCHEMA | 83 | 0 | 0 | 0 | 0 |
| SUBSCRIPTION | 0 | 5 | 5 | 0 | 0 |
| TABLE/PROCEDURE | 183,378 | 484,702 | 484,702 | 0 | 0 |
| TRANSFORMATION | 354 | 354 | 354 | 0 | 0 |
| TRIGGER | 0 | 822 | 822 | 0 | 0 |
| Component | Begin Snap Size (Mb) | Current Size (Mb) | Min Size (Mb) | Max Size (Mb) | Oper Count | Last Op Typ/Mod |
|---|---|---|---|---|---|---|
| ASM Buffer Cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 16K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 2K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 32K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 4K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT 8K buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| DEFAULT buffer cache | 12,288.00 | 12,288.00 | 12,288.00 | 12,288.00 | 0 | INI/ |
| KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| PGA Target | 4,096.00 | 4,096.00 | 4,096.00 | 4,096.00 | 0 | STA/ |
| RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| SGA Target | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| java pool | 448.00 | 448.00 | 448.00 | 448.00 | 0 | STA/ |
| large pool | 512.00 | 512.00 | 512.00 | 512.00 | 0 | STA/ |
| shared pool | 4,096.00 | 4,096.00 | 4,096.00 | 4,096.00 | 0 | STA/ |
| streams pool | 512.00 | 512.00 | 512.00 | 512.00 | 0 | STA/ |
| 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 | 614.61 | 4.69 | 7.24 | 44 | 44 | 131 | 131 | |
B | Freeable | 66.94 | 0.00 | 0.74 | 0.57 | 3 | 91 | 91 | |
B | SQL | 14.14 | 9.27 | 0.14 | 0.62 | 5 | 22 | 98 | 89 |
B | PL/SQL | 1.60 | 1.14 | 0.01 | 0.02 | 0 | 0 | 131 | 131 |
| E | Other | 601.83 | 4.81 | 7.39 | 44 | 44 | 125 | 125 | |
E | Freeable | 64.63 | 0.00 | 0.73 | 0.57 | 3 | 88 | 88 | |
E | SQL | 7.23 | 5.79 | 0.08 | 0.32 | 2 | 22 | 92 | 82 |
E | PL/SQL | 1.34 | 0.91 | 0.01 | 0.02 | 0 | 0 | 125 | 124 |
| SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
|---|---|---|
| Database Buffers | 12,884,901,888 | |
| Fixed Size | 2,261,008 | |
| Redo Buffers | 316,792,832 | |
| Variable Size | 5,838,475,248 |
| Pool | Name | Begin MB | End MB | % Diff |
|---|---|---|---|---|
| java | free memory | 448.00 | 448.00 | 0.00 |
| large | free memory | 511.63 | 511.63 | 0.00 |
| shared | ASH buffers | 64.00 | 64.00 | 0.00 |
| shared | KGLDA | 58.27 | 58.19 | -0.13 |
| shared | KGLH0 | 1,131.13 | 1,130.01 | -0.10 |
| shared | KGLHD | 181.89 | 181.71 | -0.10 |
| shared | SQLA | 1,181.34 | 1,181.43 | 0.01 |
| shared | db_block_hash_buckets | 89.00 | 89.00 | 0.00 |
| shared | free memory | 262.28 | 262.89 | 0.23 |
| shared | gcs resources | 345.49 | 345.49 | 0.00 |
| shared | gcs shadows | 239.19 | 239.19 | 0.00 |
| shared | kglsim heap | 49.64 | 49.64 | 0.00 |
| shared | kglsim object batch | 85.83 | 85.83 | 0.00 |
| streams | free memory | 511.95 | 511.95 | 0.00 |
| buffer_cache | 12,288.00 | 12,288.00 | 0.00 | |
| fixed_sga | 2.16 | 2.16 | 0.00 | |
| log_buffer | 302.12 | 302.12 | 0.00 |
| Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
|---|---|---|---|---|
| QMON Slaves | 0902 02:49:47 | 0.42 | 0.02 | 0.00 |
| QMON Coordinator | 0902 02:49:46 | 0.14 | 0.00 | 0.00 |
| Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 | 0 |
| Common Queue Per Sec | Disp Queue Per Sec | Server Msgs/Sec | Server KB/Sec | Common Queue Total | Disp Queue Total | Server Total Msgs | Server Total(KB) |
|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| audit_file_dest | /oracle/app/admin/cc/adump | |
| audit_trail | NONE | |
| cluster_database | TRUE | |
| compatible | 11.2.0.0.0 | |
| control_files | +CCDATA/cc/controlfile/current.293.831683181, +CCDATA/cc/controlfile/current.294.831683181, +CCDATA/cc/controlfile/current.295.831683181 | |
| db_block_size | 8192 | |
| db_cache_size | 12884901888 | |
| db_create_file_dest | +CCDATA | |
| db_domain | ||
| db_name | cc | |
| diagnostic_dest | /oracle/app | |
| event | ||
| instance_number | 1 | |
| java_pool_size | 469762048 | |
| large_pool_size | 536870912 | |
| local_listener | (ADDRESS=(PROTOCOL=TCP)(HOST=10.205.6.133)(PORT=1521)) | |
| log_archive_dest_1 | LOCATION=+CCARCH | |
| log_archive_format | %t_%s_%r.arc | |
| log_buffer | 268435456 | |
| open_cursors | 300 | |
| pga_aggregate_target | 4294967296 | |
| plsql_warnings | DISABLE:ALL | |
| processes | 500 | |
| remote_listener | PRQMRAC-scan:1521 | |
| remote_login_passwordfile | EXCLUSIVE | |
| resource_limit | TRUE | |
| service_names | cc | |
| sessions | 800 | |
| shared_pool_size | 4294967296 | |
| spfile | +CCDATA/cc/spfilecc.ora | |
| streams_pool_size | 536870912 | |
| thread | 1 | |
| undo_tablespace | UNDOTBS1 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| control_files | +CCDATA/cc/controlfile/current.293.831683181 | |
control_files | +CCDATA/cc/controlfile/current.294.831683181 | |
control_files | +CCDATA/cc/controlfile/current.295.831683181 |
| Begin | End | |
|---|---|---|
| Number of Instances: | 2 | 2 |
| Per Second | Per Transaction | |
|---|---|---|
| Global Cache blocks received: | 30.32 | 0.67 |
| Global Cache blocks served: | 4.18 | 0.09 |
| GCS/GES messages received: | 95.45 | 2.10 |
| GCS/GES messages sent: | 110.35 | 2.43 |
| DBWR Fusion writes: | 1.07 | 0.02 |
| Estd Interconnect traffic (KB) | 316.22 |
| Buffer access - local cache %: | 99.99 |
| Buffer access - remote cache %: | 0.00 |
| Buffer access - disk %: | 0.01 |
| Avg global enqueue get time (ms): | 0.0 |
| Avg global cache cr block receive time (ms): | 1.6 |
| Avg global cache current block receive time (ms): | 0.4 |
| 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): | 4.3 |
| Avg global cache current block pin time (ms): | 0.0 |
| Avg global cache current block send time (ms): | 0.0 |
| Global cache log flushes for current blocks served %: | 2.6 |
| Avg global cache current block flush time (ms): | 6.2 |
| Avg message sent queue time (ms): | 0.1 |
| Avg message sent queue time on ksxp (ms): | 3.2 |
| Avg message received queue time (ms): | 0.0 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.0 |
| % of direct sent messages: | 73.27 |
| % of indirect sent messages: | 26.39 |
| % of flow controlled messages: | 0.34 |
| Begin | End | ||||
|---|---|---|---|---|---|
| Interface | IP Address | Pub | Source | Pub | Src |
| bond2:1 | 169.254.143.86 | N | |||
| bond2:2 | 169.254.114.87 | N |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| acks for commit broadcast(actual) | 27,646 | 7.80 | 0.17 |
| acks for commit broadcast(logical) | 28,505 | 8.04 | 0.18 |
| broadcast msgs on commit(actual) | 143,406 | 40.44 | 0.89 |
| broadcast msgs on commit(logical) | 151,288 | 42.66 | 0.94 |
| broadcast msgs on commit(wasted) | 2,486 | 0.70 | 0.02 |
| dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
| dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
| flow control messages received | 0 | 0.00 | 0.00 |
| flow control messages sent | 0 | 0.00 | 0.00 |
| gcs apply delta | 0 | 0.00 | 0.00 |
| gcs assume cvt | 0 | 0.00 | 0.00 |
| gcs assume no cvt | 7,568 | 2.13 | 0.05 |
| gcs ast xid | 0 | 0.00 | 0.00 |
| gcs blocked converts | 23,431 | 6.61 | 0.15 |
| gcs blocked cr converts | 43,198 | 12.18 | 0.27 |
| gcs compatible basts | 438 | 0.12 | 0.00 |
| gcs compatible cr basts (global) | 14,298 | 4.03 | 0.09 |
| gcs compatible cr basts (local) | 17,534 | 4.94 | 0.11 |
| 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 | 3,612 | 1.02 | 0.02 |
| gcs dbwr write request msgs | 669 | 0.19 | 0.00 |
| gcs delta msgs sent | 0 | 0.00 | 0.00 |
| gcs delta push aborted by cancel | 0 | 0.00 | 0.00 |
| gcs delta push aborted by remastering | 0 | 0.00 | 0.00 |
| gcs delta push cancelled | 0 | 0.00 | 0.00 |
| gcs delta push cancelled at master | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by close | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by consign | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by cvt ping | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by dwncvt | 0 | 0.00 | 0.00 |
| gcs delta push create pi | 0 | 0.00 | 0.00 |
| gcs delta update master msgs sent | 0 | 0.00 | 0.00 |
| gcs delta wait aborted by remastering | 0 | 0.00 | 0.00 |
| gcs delta wait cancelled | 0 | 0.00 | 0.00 |
| gcs error msgs | 0 | 0.00 | 0.00 |
| gcs force cr block only | 24 | 0.01 | 0.00 |
| gcs force cr grant | 29 | 0.01 | 0.00 |
| gcs force cr no current | 0 | 0.00 | 0.00 |
| gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
| gcs immediate (compatible) converts | 2,849 | 0.80 | 0.02 |
| gcs immediate (null) converts | 5,911 | 1.67 | 0.04 |
| gcs immediate cr (compatible) converts | 1 | 0.00 | 0.00 |
| gcs immediate cr (null) converts | 14,889 | 4.20 | 0.09 |
| gcs indirect ast | 19,064 | 5.38 | 0.12 |
| gcs indirect bidless ast | 0 | 0.00 | 0.00 |
| gcs indirect fg ast | 19,018 | 5.36 | 0.12 |
| gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
| gcs lms write request msgs | 2,834 | 0.80 | 0.02 |
| gcs msgs process time(ms) | 3,952 | 1.11 | 0.02 |
| gcs msgs received | 272,485 | 76.83 | 1.69 |
| gcs new served by master | 463 | 0.13 | 0.00 |
| gcs out-of-order msgs | 1 | 0.00 | 0.00 |
| gcs pings refused | 9 | 0.00 | 0.00 |
| gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
| gcs push delta | 0 | 0.00 | 0.00 |
| gcs queued converts | 6 | 0.00 | 0.00 |
| gcs reader bypass N->Xw ping local | 0 | 0.00 | 0.00 |
| gcs reader bypass N->Xw ping remote | 0 | 0.00 | 0.00 |
| gcs reader bypass grant X on assume | 0 | 0.00 | 0.00 |
| gcs reader bypass grant ast | 0 | 0.00 | 0.00 |
| gcs reader bypass grant fg ast | 0 | 0.00 | 0.00 |
| gcs reader bypass grant immediate | 0 | 0.00 | 0.00 |
| gcs recovery claim msgs | 0 | 0.00 | 0.00 |
| gcs refuse xid | 4 | 0.00 | 0.00 |
| gcs regular cr | 0 | 0.00 | 0.00 |
| gcs retry convert request | 48 | 0.01 | 0.00 |
| gcs share recovery bast | 0 | 0.00 | 0.00 |
| gcs side channel msgs actual | 18,144 | 5.12 | 0.11 |
| gcs side channel msgs logical | 111,926 | 31.56 | 0.69 |
| gcs stale cr | 9,043 | 2.55 | 0.06 |
| gcs undo cr | 408 | 0.12 | 0.00 |
| gcs write notification msgs | 189 | 0.05 | 0.00 |
| gcs writes refused | 115 | 0.03 | 0.00 |
| ges msgs process time(ms) | 1,378 | 0.39 | 0.01 |
| ges msgs received | 66,030 | 18.62 | 0.41 |
| global posts dropped | 0 | 0.00 | 0.00 |
| global posts queue time | 851 | 0.24 | 0.01 |
| global posts queued | 332 | 0.09 | 0.00 |
| global posts requested | 434 | 0.12 | 0.00 |
| global posts sent | 332 | 0.09 | 0.00 |
| implicit batch messages received | 6,418 | 1.81 | 0.04 |
| implicit batch messages sent | 3,888 | 1.10 | 0.02 |
| lmd msg send time(ms) | 26 | 0.01 | 0.00 |
| lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
| messages flow controlled | 1,114 | 0.31 | 0.01 |
| messages queue sent actual | 112,110 | 31.61 | 0.70 |
| messages queue sent logical | 10,070 | 2.84 | 0.06 |
| messages received actual | 326,945 | 92.19 | 2.03 |
| messages received logical | 338,515 | 95.45 | 2.10 |
| messages sent directly | 238,077 | 67.13 | 1.48 |
| messages sent indirectly | 85,740 | 24.18 | 0.53 |
| messages sent not implicit batched | 10 | 0.00 | 0.00 |
| messages sent pbatched | 73,999 | 20.87 | 0.46 |
| msgs causing lmd to send msgs | 32,773 | 9.24 | 0.20 |
| msgs causing lms(s) to send msgs | 5,978 | 1.69 | 0.04 |
| msgs received queue time (ms) | 4,176 | 1.18 | 0.03 |
| msgs received queued | 338,515 | 95.45 | 2.10 |
| msgs sent queue time (ms) | 6,153 | 1.74 | 0.04 |
| msgs sent queue time on ksxp (ms) | 1,189,747 | 335.48 | 7.38 |
| msgs sent queued | 117,714 | 33.19 | 0.73 |
| msgs sent queued on ksxp | 377,587 | 106.47 | 2.34 |
| number of broadcasted resources | 0 | 0.00 | 0.00 |
| number of ges deadlock detected | 0 | 0.00 | 0.00 |
| process batch messages received | 180,978 | 51.03 | 1.12 |
| process batch messages sent | 65,850 | 18.57 | 0.41 |
| Statistic | Total |
|---|---|
| CR Block Requests | 3,785 |
| CURRENT Block Requests | 9,783 |
| Data Block Requests | 3,785 |
| Undo Block Requests | 360 |
| TX Block Requests | 354 |
| Current Results | 4,577 |
| Private results | 3 |
| Zero Results | 16 |
| Disk Read Results | 8,972 |
| Fail Results | 0 |
| Fairness Down Converts | 1,648 |
| Fairness Clears | 243 |
| Free GC Elements | 0 |
| Flushes | 82 |
| Flushes Queued | 0 |
| Flush Queue Full | 0 |
| Flush Max Time (us) | 0 |
| Light Works | 62 |
| Errors | 0 |
| Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
|---|---|---|---|---|---|---|
| Pins | 7 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Flushes | 269 | 2.23 | 89.59 | 8.18 | 0.00 | 0.00 |
| Writes | 3,779 | 1.22 | 92.99 | 1.64 | 3.65 | 0.50 |
| CR | Current | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
| 2 | data block | 48,690 | 62.64 | 36.18 | 1.17 | 51,031 | 96.37 | 0.29 | 3.33 |
| 2 | undo header | 3,782 | 95.69 | 2.88 | 1.43 | 20 | 90.00 | 10.00 | 0.00 |
| 2 | undo block | 2,089 | 96.74 | 1.77 | 1.48 | 0 | |||
| 2 | Others | 493 | 96.96 | 0.81 | 2.23 | 1,445 | 98.27 | 0.07 | 1.66 |
| CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
| 2 | data block | 1.74 | 0.47 | 3.97 | 0.48 | 0.44 | 0.42 | 3.87 | 0.76 |
| 2 | undo header | 0.45 | 0.35 | 3.85 | 0.36 | 0.66 | 0.41 | 2.87 | |
| 2 | undo block | 0.43 | 0.37 | 3.36 | 0.42 | ||||
| 2 | others | 0.43 | 0.40 | 3.81 | 0.44 | 0.34 | 0.34 | 3.75 | 0.35 |
| CR | Current | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
| 2 | data block | 0 | 30,501 | 100.00 | 0.00 | 49,180 | 100.00 | 0.00 |
| 2 | undo header | 0 | 3,619 | 100.00 | 0.00 | 18 | 100.00 | 0.00 |
| 2 | undo block | 0 | 2,021 | 100.00 | 0.00 | 0 | ||
| 2 | others | 0 | 478 | 100.00 | 0.00 | 1,420 | 100.00 | 0.00 |
| CR Avg Time (ms) | Current Avg Time (ms) | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
| 2 | data block | 0.47 | 0.47 | 0.42 | 0.42 | |||
| 2 | undo header | 0.35 | 0.35 | 0.41 | 0.41 | |||
| 2 | undo block | 0.37 | 0.37 | |||||
| 2 | others | 0.40 | 0.40 | 0.34 | 0.34 |
| Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
|---|---|---|---|---|---|---|
| 1 | 281 | 0.15 | 0.07 | 281 | 0.14 | 0.06 |
| 2 | 281 | 0.30 | 0.12 | 281 | 0.43 | 0.17 |
| Used By | Send Mbytes/sec | Receive Mbytes/sec |
|---|---|---|
| Global Cache | 0.02 | 0.18 |
| Parallel Query | 0.00 | 0.00 |
| DB Locks | 0.02 | 0.02 |
| DB Streams | 0.00 | 0.00 |
| Other | 0.00 | 0.00 |
| Device Name | IP Address | Public | Source | Send Mbytes/sec | Send Errors | Send Dropped | Send Buffer Overrun | Send Carrier Lost | Receive Mbytes/sec | Receive Errors | Receive Dropped | Receive Buffer Overrun | Receive Frame Errors |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bond2:1 | 169.254.143.86 | NO | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| bond2:2 | 169.254.114.87 | NO | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |