| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| BILLDB | 1725412641 | billdb2 | 2 | 10-Sep-13 12:09 | 11.2.0.3.0 | YES |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| xjocsdb2 | AIX-Based Systems (64-bit) | 12 | 6 | 61.00 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 7480 | 10-Sep-13 15:00:21 | 80 | 1.0 |
| End Snap: | 7484 | 10-Sep-13 19:00:34 | 179 | 1.2 |
| Elapsed: | 240.22 (mins) | |||
| DB Time: | 48,603.10 (mins) |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 20,288M | 20,288M | Std Block Size: | 8K |
| Shared Pool Size: | 2,816M | 2,816M | Log Buffer: | 22,088K |
| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 202.3 | 54.0 | 8.88 | 3.97 |
| DB CPU(s): | 0.2 | 0.0 | 0.01 | 0.00 |
| Redo size: | 557,625.6 | 148,814.8 | ||
| Logical reads: | 2,569.7 | 685.8 | ||
| Block changes: | 70.4 | 18.8 | ||
| Physical reads: | 820.9 | 219.1 | ||
| Physical writes: | 69.0 | 18.4 | ||
| User calls: | 51.0 | 13.6 | ||
| Parses: | 4.0 | 1.1 | ||
| Hard parses: | 0.8 | 0.2 | ||
| W/A MB processed: | 0.2 | 0.1 | ||
| Logons: | 0.3 | 0.1 | ||
| Executes: | 22.8 | 6.1 | ||
| Rollbacks: | 1.7 | 0.4 | ||
| Transactions: | 3.8 |
| Buffer Nowait %: | 99.99 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 69.45 | In-memory Sort %: | 100.00 |
| Library Hit %: | 93.52 | Soft Parse %: | 79.64 |
| Execute to Parse %: | 82.66 | Latch Hit %: | 99.96 |
| Parse CPU to Parse Elapsd %: | 73.31 | % Non-Parse CPU: | 99.09 |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 76.22 | 86.39 |
| % SQL with executions>1: | 84.05 | 41.86 |
| % Memory for SQL w/exec>1: | 85.39 | 42.71 |
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| library cache lock | 4,244 | 2,899,582 | 683219 | 99.43 | Concurrency |
| DB CPU | 2,274 | 0.08 | |||
| db file scattered read | 88,231 | 1,325 | 15 | 0.05 | User I/O |
| db file sequential read | 14,830 | 99 | 7 | 0.00 | User I/O |
| direct path read | 1,958 | 48 | 24 | 0.00 | User I/O |
| Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|
| 0.67 | 1.33 | 6.5 | 2.3 | 0.8 | 91.1 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 6.7 | 75.8 | 0.0 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 62,464.0 | 62,464.0 |
| SGA use (MB): | 23,360.0 | 23,360.0 |
| PGA use (MB): | 334.4 | 607.0 |
| % Host Mem used for SGA+PGA: | 37.93 | 38.37 |
| Begin | End | |
|---|---|---|
| Number of Instances: | 2 | 2 |
| Per Second | Per Transaction | |
|---|---|---|
| Global Cache blocks received: | 1.56 | 0.42 |
| Global Cache blocks served: | 2.03 | 0.54 |
| GCS/GES messages received: | 422.29 | 112.70 |
| GCS/GES messages sent: | 485.15 | 129.47 |
| DBWR Fusion writes: | 0.14 | 0.04 |
| Estd Interconnect traffic (KB) | 206.01 |
| Buffer access - local cache %: | 69.39 |
| Buffer access - remote cache %: | 0.06 |
| Buffer access - disk %: | 30.55 |
| Avg global enqueue get time (ms): | 5,164.3 |
| Avg global cache cr block receive time (ms): | 0.4 |
| Avg global cache current block receive time (ms): | 0.3 |
| Avg global cache cr block build time (ms): | 0.0 |
| Avg global cache cr block send time (ms): | 0.0 |
| Global cache log flushes for cr blocks served %: | 1.8 |
| Avg global cache cr block flush time (ms): | 0.5 |
| 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.8 |
| Avg global cache current block flush time (ms): | 0.9 |
| Avg message sent queue time (ms): | 0.0 |
| Avg message sent queue time on ksxp (ms): | 0.3 |
| Avg message received queue time (ms): | 0.1 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.3 |
| % of direct sent messages: | 8.96 |
| % of indirect sent messages: | 90.90 |
| % of flow controlled messages: | 0.13 |
| Begin | End | |||||
|---|---|---|---|---|---|---|
| Interface | IP Address | Pub | Source | IP | Pub | Src |
| en5 | 169.254.75.89 | N |
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| connection management call elapsed time | 2,912,465.49 | 99.87 |
| sql execute elapsed time | 3,615.66 | 0.12 |
| DB CPU | 2,274.26 | 0.08 |
| parse time elapsed | 31.98 | 0.00 |
| hard parse elapsed time | 19.59 | 0.00 |
| sequence load elapsed time | 3.44 | 0.00 |
| hard parse (sharing criteria) elapsed time | 2.61 | 0.00 |
| PL/SQL execution elapsed time | 1.67 | 0.00 |
| PL/SQL compilation elapsed time | 0.40 | 0.00 |
| repeated bind elapsed time | 0.04 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.01 | 0.00 |
| failed parse elapsed time | 0.00 | 0.00 |
| DB time | 2,916,186.13 | |
| background cpu time | 9,386.77 | |
| background elapsed time | 6,008.92 |
| Statistic | Value | End Value |
|---|---|---|
| AVG_BUSY_TIME | 127,624 | |
| AVG_IDLE_TIME | 1,315,396 | |
| AVG_IOWAIT_TIME | 11,287 | |
| AVG_SYS_TIME | 33,228 | |
| AVG_USER_TIME | 93,746 | |
| BUSY_TIME | 1,539,349 | |
| IDLE_TIME | 15,792,989 | |
| IOWAIT_TIME | 140,618 | |
| SYS_TIME | 406,654 | |
| USER_TIME | 1,132,695 | |
| LOAD | 1 | 1 |
| OS_CPU_WAIT_TIME | 1,874,300 | |
| VM_IN_BYTES | 39,219,204 | |
| VM_OUT_BYTES | 9,077,403,648 | |
| PHYSICAL_MEMORY_BYTES | 65,498,251,264 | |
| NUM_CPUS | 12 | |
| NUM_CPU_CORES | 6 | |
| NUM_LCPUS | 12 | |
| NUM_VCPUS | 6 | |
| GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
| GLOBAL_SEND_SIZE_MAX | 4,194,304 | |
| TCP_RECEIVE_SIZE_DEFAULT | 16,384 | |
| TCP_RECEIVE_SIZE_MAX | 9,223,372,036,854,775,807 | |
| TCP_RECEIVE_SIZE_MIN | 4,096 | |
| TCP_SEND_SIZE_DEFAULT | 16,384 | |
| TCP_SEND_SIZE_MAX | 9,223,372,036,854,775,807 | |
| TCP_SEND_SIZE_MIN | 4,096 |
| Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
|---|---|---|---|---|---|---|
| 10-Sep 15:00:21 | 0.67 | |||||
| 10-Sep 16:00:25 | 0.34 | 2.33 | 1.27 | 1.07 | 97.67 | 0.07 |
| 10-Sep 17:00:28 | 1.35 | 8.01 | 5.70 | 2.31 | 91.99 | 0.03 |
| 10-Sep 18:00:31 | 2.18 | 10.68 | 8.05 | 2.64 | 89.32 | 0.29 |
| 10-Sep 19:00:34 | 1.33 | 14.50 | 11.14 | 3.36 | 85.50 | 2.86 |
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
|---|---|---|---|---|---|
| Concurrency | 18,301 | 0 | 2,899,592 | 158439 | 99.43 |
| DB CPU | 2,274 | 0.08 | |||
| User I/O | 112,888 | 0 | 1,500 | 13 | 0.05 |
| Other | 11,712 | 17 | 51 | 4 | 0.00 |
| Cluster | 54,054 | 0 | 46 | 1 | 0.00 |
| Commit | 34,111 | 0 | 24 | 1 | 0.00 |
| Application | 465 | 16 | 4 | 9 | 0.00 |
| Network | 551,233 | 0 | 1 | 0 | 0.00 |
| Configuration | 83 | 0 | 0 | 2 | 0.00 |
| System I/O | 12 | 0 | 0 | 2 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| library cache lock | 4,244 | 0 | 2,899,582 | 683219 | 0.08 | 99.43 |
| db file scattered read | 88,231 | 0 | 1,325 | 15 | 1.63 | 0.05 |
| db file sequential read | 14,830 | 0 | 99 | 7 | 0.27 | 0.00 |
| direct path read | 1,958 | 0 | 48 | 24 | 0.04 | 0.00 |
| gc cr multi block request | 28,148 | 0 | 28 | 1 | 0.52 | 0.00 |
| latch: ges resource hash list | 2,787 | 0 | 24 | 9 | 0.05 | 0.00 |
| log file sync | 34,111 | 0 | 24 | 1 | 0.63 | 0.00 |
| direct path write | 1,930 | 0 | 21 | 11 | 0.04 | 0.00 |
| gcs drm freeze in enter server mode | 57 | 16 | 12 | 219 | 0.00 | 0.00 |
| DFS lock handle | 4,535 | 2 | 10 | 2 | 0.08 | 0.00 |
| gc current block 2-way | 7,247 | 0 | 4 | 1 | 0.13 | 0.00 |
| enq: RO - fast object reuse | 241 | 0 | 4 | 16 | 0.00 | 0.00 |
| row cache lock | 10,001 | 0 | 3 | 0 | 0.19 | 0.00 |
| library cache load lock | 1,037 | 0 | 3 | 3 | 0.02 | 0.00 |
| gc cr block 2-way | 6,486 | 0 | 3 | 0 | 0.12 | 0.00 |
| Disk file operations I/O | 5,678 | 0 | 3 | 1 | 0.11 | 0.00 |
| gc remaster | 35 | 0 | 3 | 73 | 0.00 | 0.00 |
| cursor: pin S wait on X | 46 | 0 | 2 | 53 | 0.00 | 0.00 |
| gc buffer busy acquire | 663 | 0 | 2 | 3 | 0.01 | 0.00 |
| gc current grant 2-way | 4,475 | 0 | 2 | 0 | 0.08 | 0.00 |
| gc current grant busy | 3,336 | 0 | 1 | 0 | 0.06 | 0.00 |
| name-service call wait | 16 | 0 | 1 | 89 | 0.00 | 0.00 |
| gc current multi block request | 1,642 | 0 | 1 | 1 | 0.03 | 0.00 |
| read by other session | 163 | 0 | 1 | 8 | 0.00 | 0.00 |
| local write wait | 48 | 0 | 1 | 22 | 0.00 | 0.00 |
| db file parallel read | 50 | 0 | 1 | 20 | 0.00 | 0.00 |
| library cache: mutex X | 1,463 | 0 | 1 | 0 | 0.03 | 0.00 |
| gc current block busy | 544 | 0 | 1 | 1 | 0.01 | 0.00 |
| enq: JQ - contention | 211 | 100 | 1 | 3 | 0.00 | 0.00 |
| SQL*Net message to client | 551,116 | 0 | 0 | 0 | 10.20 | 0.00 |
| latch: object queue header operation | 235 | 0 | 0 | 2 | 0.00 | 0.00 |
| gc buffer busy release | 214 | 0 | 0 | 2 | 0.00 | 0.00 |
| gc cr grant 2-way | 1,035 | 0 | 0 | 0 | 0.02 | 0.00 |
| CSS initialization | 44 | 0 | 0 | 7 | 0.00 | 0.00 |
| enq: PS - contention | 152 | 5 | 0 | 2 | 0.00 | 0.00 |
| reliable message | 230 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: FB - contention | 106 | 0 | 0 | 2 | 0.00 | 0.00 |
| os thread startup | 3 | 0 | 0 | 73 | 0.00 | 0.00 |
| IPC send completion sync | 531 | 0 | 0 | 0 | 0.01 | 0.00 |
| library cache pin | 366 | 0 | 0 | 1 | 0.01 | 0.00 |
| CSS operation: action | 44 | 0 | 0 | 4 | 0.00 | 0.00 |
| enq: TM - contention | 133 | 54 | 0 | 1 | 0.00 | 0.00 |
| gc cr block busy | 145 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: TX - index contention | 26 | 0 | 0 | 6 | 0.00 | 0.00 |
| buffer busy waits | 912 | 0 | 0 | 0 | 0.02 | 0.00 |
| log file switch completion | 10 | 0 | 0 | 9 | 0.00 | 0.00 |
| CSS operation: query | 132 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: CR - block range reuse ckpt | 42 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: gc element | 139 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TS - contention | 71 | 25 | 0 | 0 | 0.00 | 0.00 |
| enq: KO - fast object checkpoint | 53 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: TX - allocate ITL entry | 4 | 0 | 0 | 7 | 0.00 | 0.00 |
| enq: HW - contention | 35 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 203 | 0 | 0 | 0 | 0.00 | 0.00 |
| control file sequential read | 12 | 0 | 0 | 2 | 0.00 | 0.00 |
| SQL*Net break/reset to client | 30 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: cache buffers chains | 172 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: MD - contention | 50 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr disk read | 55 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: SQ - contention | 29 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: JS - job run lock - synchronize | 10 | 100 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: reap credit | 1,668 | 100 | 0 | 0 | 0.03 | 0.00 |
| gc current block congested | 12 | 0 | 0 | 1 | 0.00 | 0.00 |
| SQL*Net more data from client | 6 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch free | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current grant congested | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
| write complete waits | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc cr block congested | 5 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 34 | 0 | 0 | 0 | 0.00 | 0.00 |
| KJC: Wait for msg sends to complete | 326 | 0 | 0 | 0 | 0.01 | 0.00 |
| latch: shared pool | 29 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: UL - contention | 4 | 100 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net more data to client | 111 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TX - row lock contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message from client | 551,052 | 0 | 414,490 | 752 | 10.20 | |
| jobq slave wait | 29,671 | 100 | 14,829 | 500 | 0.55 | |
| PX Deq: Execution Msg | 676 | 0 | 0 | 1 | 0.01 | |
| KSV master wait | 14 | 0 | 0 | 19 | 0.00 | |
| PX Deq: Execute Reply | 34 | 0 | 0 | 3 | 0.00 | |
| PX Deq: Join ACK | 34 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Parse Reply | 34 | 0 | 0 | 1 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| os thread startup | 608 | 0 | 44 | 72 | 0.01 | 0.73 |
| log file parallel write | 53,520 | 0 | 42 | 1 | 0.99 | 0.70 |
| log file sequential read | 3,264 | 0 | 26 | 8 | 0.06 | 0.43 |
| Streams AQ: qmn coordinator waiting for slave to start | 3 | 100 | 17 | 5503 | 0.00 | 0.27 |
| control file sequential read | 39,369 | 0 | 15 | 0 | 0.73 | 0.24 |
| ges lms sync during dynamic remastering and reconfig | 132 | 98 | 14 | 108 | 0.00 | 0.24 |
| db file sequential read | 6,896 | 0 | 12 | 2 | 0.13 | 0.20 |
| enq: CO - master slave det | 4,798 | 100 | 8 | 2 | 0.09 | 0.14 |
| db file parallel write | 18,123 | 0 | 5 | 0 | 0.34 | 0.08 |
| Log archive I/O | 66 | 0 | 4 | 61 | 0.00 | 0.07 |
| control file parallel write | 5,309 | 0 | 3 | 0 | 0.10 | 0.04 |
| SQL*Net break/reset to client | 2,574 | 0 | 2 | 1 | 0.05 | 0.04 |
| gc current block 2-way | 3,798 | 0 | 1 | 0 | 0.07 | 0.02 |
| CSS operation: data query | 707 | 0 | 1 | 2 | 0.01 | 0.02 |
| gc cr block busy | 1,619 | 0 | 1 | 1 | 0.03 | 0.02 |
| kjbdrmcvtq lmon drm quiesce: ping completion | 40 | 0 | 1 | 24 | 0.00 | 0.02 |
| CGS wait for IPC msg | 132,133 | 100 | 1 | 0 | 2.45 | 0.01 |
| ASM file metadata operation | 3,438 | 0 | 1 | 0 | 0.06 | 0.01 |
| enq: WF - contention | 75 | 0 | 1 | 8 | 0.00 | 0.01 |
| gc cr block 2-way | 1,387 | 0 | 1 | 0 | 0.03 | 0.01 |
| DFS lock handle | 920 | 55 | 1 | 1 | 0.02 | 0.01 |
| gcs log flush sync | 999 | 2 | 1 | 1 | 0.02 | 0.01 |
| CSS initialization | 91 | 0 | 0 | 5 | 0.00 | 0.01 |
| row cache process | 103,244 | 0 | 0 | 0 | 1.91 | 0.01 |
| row cache lock | 443 | 0 | 0 | 1 | 0.01 | 0.01 |
| ksxr poll remote instances | 52,847 | 100 | 0 | 0 | 0.98 | 0.01 |
| ADR block file read | 60 | 0 | 0 | 6 | 0.00 | 0.01 |
| CSS operation: action | 218 | 0 | 0 | 2 | 0.00 | 0.01 |
| latch: gc element | 9,984 | 0 | 0 | 0 | 0.18 | 0.01 |
| gc cr grant 2-way | 1,356 | 0 | 0 | 0 | 0.03 | 0.01 |
| process diagnostic dump | 7 | 0 | 0 | 46 | 0.00 | 0.01 |
| enq: TM - contention | 128 | 67 | 0 | 2 | 0.00 | 0.00 |
| name-service call wait | 8 | 0 | 0 | 34 | 0.00 | 0.00 |
| latch: object queue header operation | 156 | 0 | 0 | 2 | 0.00 | 0.00 |
| ges generic event | 22 | 95 | 0 | 11 | 0.00 | 0.00 |
| gc current grant busy | 674 | 0 | 0 | 0 | 0.01 | 0.00 |
| gc object scan | 39,804 | 100 | 0 | 0 | 0.74 | 0.00 |
| libcache interrupt action by LCK | 56,444 | 0 | 0 | 0 | 1.05 | 0.00 |
| CSS group membership query | 235 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: CF - contention | 87 | 94 | 0 | 2 | 0.00 | 0.00 |
| row cache cleanup | 73,197 | 0 | 0 | 0 | 1.36 | 0.00 |
| wait for scn ack | 8 | 0 | 0 | 21 | 0.00 | 0.00 |
| Disk file operations I/O | 1,150 | 0 | 0 | 0 | 0.02 | 0.00 |
| gc current grant 2-way | 413 | 0 | 0 | 0 | 0.01 | 0.00 |
| latch: ges resource hash list | 938 | 0 | 0 | 0 | 0.02 | 0.00 |
| reliable message | 273 | 0 | 0 | 0 | 0.01 | 0.00 |
| enq: HW - contention | 38 | 3 | 0 | 2 | 0.00 | 0.00 |
| latch free | 25 | 0 | 0 | 4 | 0.00 | 0.00 |
| enq: CR - block range reuse ckpt | 46 | 0 | 0 | 2 | 0.00 | 0.00 |
| gc current block busy | 73 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: PS - contention | 96 | 50 | 0 | 1 | 0.00 | 0.00 |
| log file sync | 45 | 0 | 0 | 2 | 0.00 | 0.00 |
| CSS operation: query | 507 | 0 | 0 | 0 | 0.01 | 0.00 |
| LGWR wait for redo copy | 2,276 | 0 | 0 | 0 | 0.04 | 0.00 |
| PX Deq: reap credit | 6,706 | 100 | 0 | 0 | 0.12 | 0.00 |
| enq: TX - index contention | 2 | 0 | 0 | 20 | 0.00 | 0.00 |
| direct path write | 62 | 0 | 0 | 1 | 0.00 | 0.00 |
| ges inquiry response | 61 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: FB - contention | 69 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TD - KTF dump entries | 27 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc current multi block request | 57 | 0 | 0 | 0 | 0.00 | 0.00 |
| direct path read | 2 | 0 | 0 | 13 | 0.00 | 0.00 |
| ksdxexeotherwait | 7 | 0 | 0 | 4 | 0.00 | 0.00 |
| SQL*Net more data to client | 1,325 | 0 | 0 | 0 | 0.02 | 0.00 |
| enq: RO - fast object reuse | 52 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message to client | 14,071 | 0 | 0 | 0 | 0.26 | 0.00 |
| enq: TA - contention | 43 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: call allocation | 81 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 72 | 0 | 0 | 0 | 0.00 | 0.00 |
| db file async I/O submit | 18,124 | 0 | 0 | 0 | 0.34 | 0.00 |
| ges DFS hang analysis phase 2 acks | 1 | 0 | 0 | 11 | 0.00 | 0.00 |
| IPC send completion sync | 51 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 72 | 0 | 0 | 0 | 0.00 | 0.00 |
| asynch descriptor resize | 4,653 | 100 | 0 | 0 | 0.09 | 0.00 |
| enq: KO - fast object checkpoint | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net more data from client | 1,325 | 0 | 0 | 0 | 0.02 | 0.00 |
| enq: DR - contention | 8 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc cr multi block request | 7 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: AF - task serialization | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
| ADR block file write | 20 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: WL - contention | 8 | 100 | 0 | 0 | 0.00 | 0.00 |
| CSS group registration | 1 | 0 | 0 | 4 | 0.00 | 0.00 |
| log file single write | 16 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc buffer busy acquire | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: MW - contention | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
| buffer busy waits | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffers chains | 18 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
| ARCH wait for archivelog lock | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: gcs resource hash | 27 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc message | 382,373 | 61 | 345,469 | 903 | 7.08 | |
| Space Manager: slave idle wait | 7,279 | 95 | 35,175 | 4832 | 0.13 | |
| wait for unread message on broadcast channel | 28,831 | 100 | 28,825 | 1000 | 0.53 | |
| gcs remote message | 2,510,744 | 89 | 28,736 | 11 | 46.49 | |
| DIAG idle wait | 304,089 | 59 | 28,527 | 94 | 5.63 | |
| smon timer | 123 | 27 | 14,709 | 119587 | 0.00 | |
| Streams AQ: qmn slave idle wait | 513 | 1 | 14,674 | 28604 | 0.01 | |
| shared server idle wait | 481 | 100 | 14,430 | 30001 | 0.01 | |
| PING | 5,738 | 20 | 14,414 | 2512 | 0.11 | |
| ASM background timer | 2,954 | 0 | 14,411 | 4879 | 0.05 | |
| GCR sleep | 2,882 | 100 | 14,410 | 5000 | 0.05 | |
| pmon timer | 4,807 | 100 | 14,406 | 2997 | 0.09 | |
| dispatcher timer | 240 | 100 | 14,400 | 60001 | 0.00 | |
| Streams AQ: qmn coordinator idle wait | 999 | 50 | 14,392 | 14407 | 0.02 | |
| PX Idle Wait | 177 | 0 | 14,352 | 81083 | 0.00 | |
| ges remote message | 745,843,862 | 100 | 9,004 | 0 | 13,810.13 | |
| class slave wait | 540 | 0 | 5,144 | 9526 | 0.01 | |
| SQL*Net message from client | 18,115 | 0 | 11 | 1 | 0.34 | |
| KSV master wait | 8,827 | 98 | 0 | 0 | 0.16 | |
| PX Deq: Join ACK | 72 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Parse Reply | 72 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Execute Reply | 72 | 0 | 0 | 0 | 0.00 | |
| Streams AQ: RAC qmn coordinator idle wait | 1,014 | 100 | 0 | 0 | 0.02 |
| % of Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
| ADR block file read | 60 | 26.7 | 6.7 | 10.0 | 21.7 | 30.0 | 3.3 | 1.7 | |
| ADR block file write | 20 | 100.0 | |||||||
| ADR file lock | 24 | 100.0 | |||||||
| ARCH wait for archivelog lock | 8 | 100.0 | |||||||
| ASM file metadata operation | 3445 | 98.2 | .6 | .8 | .2 | .0 | .1 | ||
| CGS wait for IPC msg | 132.1K | 100.0 | .0 | .0 | |||||
| CSS group membership query | 235 | 84.3 | 13.2 | 1.7 | .9 | ||||
| CSS group registration | 1 | 100.0 | |||||||
| CSS initialization | 135 | 49.6 | 48.1 | 1.5 | .7 | ||||
| CSS operation: action | 262 | 41.6 | 5.7 | 45.4 | 7.3 | ||||
| CSS operation: data query | 707 | 1.7 | 94.5 | 3.5 | .3 | ||||
| CSS operation: query | 639 | 90.9 | 7.5 | 1.4 | .2 | ||||
| DFS lock handle | 5447 | 69.9 | 20.0 | 3.2 | 2.1 | 2.2 | 1.6 | 1.0 | |
| Disk file operations I/O | 6824 | 87.9 | 10.8 | 1.3 | .0 | ||||
| IPC send completion sync | 582 | 98.8 | .3 | .7 | .2 | ||||
| KJC: Wait for msg sends to complete | 340 | 100.0 | |||||||
| LGWR wait for redo copy | 2276 | 99.9 | .0 | .0 | |||||
| Log archive I/O | 66 | 3.0 | 4.5 | 3.0 | 1.5 | 87.9 | |||
| PX Deq: Signal ACK EXT | 106 | 100.0 | |||||||
| PX Deq: Signal ACK RSG | 106 | 100.0 | |||||||
| PX Deq: Slave Session Stats | 275 | 100.0 | |||||||
| PX Deq: reap credit | 8374 | 100.0 | |||||||
| PX qref latch | 1 | 100.0 | |||||||
| SQL*Net break/reset to client | 2606 | 51.2 | 43.4 | 5.3 | .2 | ||||
| SQL*Net message to client | 565.3K | 100.0 | |||||||
| SQL*Net more data from client | 1331 | 99.7 | .3 | ||||||
| SQL*Net more data to client | 1436 | 100.0 | |||||||
| Streams AQ: qmn coordinator waiting for slave to start | 3 | 100.0 | |||||||
| asynch descriptor resize | 4654 | 100.0 | |||||||
| buffer busy waits | 934 | 98.0 | .9 | .2 | 1.0 | ||||
| buffer deadlock | 14 | 100.0 | |||||||
| control file parallel write | 5309 | 96.8 | 1.7 | .6 | .5 | .1 | .3 | .1 | |
| control file sequential read | 39.4K | 97.4 | 1.0 | .5 | .4 | .4 | .2 | .0 | |
| cursor: mutex X | 1 | 100.0 | |||||||
| cursor: pin S | 2 | 100.0 | |||||||
| cursor: pin S wait on X | 46 | 6.5 | 10.9 | 4.3 | 15.2 | 21.7 | 13.0 | 28.3 | |
| db file async I/O submit | 18.1K | 100.0 | |||||||
| db file parallel read | 50 | 12.0 | 2.0 | 12.0 | 24.0 | 34.0 | 16.0 | ||
| db file parallel write | 18.1K | 98.4 | .8 | .4 | .2 | .1 | .1 | .0 | |
| db file scattered read | 88.2K | 1.6 | .2 | 20.5 | 5.1 | 43.3 | 24.0 | 5.3 | |
| db file sequential read | 21.7K | 34.1 | 2.4 | 10.2 | 35.5 | 15.6 | 1.4 | .8 | |
| direct path read | 1960 | .1 | .9 | 3.9 | 55.0 | 18.1 | 22.1 | ||
| direct path write | 1992 | 10.4 | 13.6 | 15.3 | 21.8 | 21.9 | 9.5 | 7.5 | |
| enq: AF - task serialization | 4 | 50.0 | 25.0 | 25.0 | |||||
| enq: CF - contention | 87 | 93.1 | 1.1 | 5.7 | |||||
| enq: CO - master slave det | 4798 | 83.8 | 3.4 | 3.5 | 3.9 | 3.4 | 1.5 | .5 | |
| enq: CR - block range reuse ckpt | 88 | 80.7 | 9.1 | 4.5 | 2.3 | 1.1 | 2.3 | ||
| enq: DL - contention | 3 | 100.0 | |||||||
| enq: DR - contention | 8 | 87.5 | 12.5 | ||||||
| enq: FB - contention | 175 | 88.6 | 3.4 | 1.1 | 3.4 | .6 | 2.3 | .6 | |
| enq: HW - contention | 73 | 80.8 | 6.8 | 4.1 | 2.7 | 2.7 | 2.7 | ||
| enq: JQ - contention | 211 | 60.2 | 15.2 | 8.1 | 5.7 | 7.6 | 2.4 | .9 | |
| enq: JS - job run lock - synchronize | 10 | 70.0 | 20.0 | 10.0 | |||||
| enq: KO - fast object checkpoint | 74 | 95.9 | 1.4 | 1.4 | 1.4 | ||||
| enq: MD - contention | 50 | 100.0 | |||||||
| enq: MW - contention | 8 | 100.0 | |||||||
| enq: PS - contention | 248 | 83.9 | 7.7 | 2.8 | .8 | 3.2 | 1.6 | ||
| enq: RO - fast object reuse | 293 | 94.9 | 1.4 | .7 | .7 | .3 | .3 | 1.4 | .3 |
| enq: SQ - contention | 29 | 93.1 | 3.4 | 3.4 | |||||
| enq: TA - contention | 42 | 100.0 | |||||||
| enq: TD - KTF dump entries | 27 | 92.6 | 3.7 | 3.7 | |||||
| enq: TM - contention | 261 | 93.1 | 1.9 | 1.5 | .4 | .4 | 1.1 | 1.5 | |
| enq: TQ - DDL contention | 1 | 100.0 | |||||||
| enq: TS - contention | 71 | 98.6 | 1.4 | ||||||
| enq: TX - allocate ITL entry | 4 | 50.0 | 25.0 | 25.0 | |||||
| enq: TX - index contention | 29 | 44.8 | 3.4 | 17.2 | 17.2 | 13.8 | 3.4 | ||
| enq: TX - row lock contention | 4 | 100.0 | |||||||
| enq: UL - contention | 4 | 100.0 | |||||||
| enq: WF - contention | 75 | 76.0 | 2.7 | 6.7 | 1.3 | 2.7 | 5.3 | 5.3 | |
| enq: WL - contention | 8 | 100.0 | |||||||
| gc buffer busy acquire | 665 | 55.0 | 21.5 | 7.5 | 6.8 | 7.2 | 1.7 | .3 | |
| gc buffer busy release | 216 | 56.5 | 38.4 | 2.8 | .5 | .9 | .9 | ||
| gc cr block 2-way | 7871 | 98.1 | 1.2 | .5 | .2 | .0 | .0 | .1 | |
| gc cr block busy | 1763 | 94.7 | 3.6 | 1.0 | .3 | .3 | .1 | ||
| gc cr block congested | 6 | 83.3 | 16.7 | ||||||
| gc cr disk read | 55 | 100.0 | |||||||
| gc cr failure | 1 | 100.0 | |||||||
| gc cr grant 2-way | 2392 | 99.1 | .5 | .3 | .0 | .0 | |||
| gc cr grant congested | 3 | 100.0 | |||||||
| gc cr multi block request | 28.2K | 75.5 | 23.0 | .9 | .4 | .1 | .0 | .0 | |
| gc current block 2-way | 11.1K | 98.4 | 1.0 | .4 | .2 | .0 | .0 | ||
| gc current block busy | 628 | 71.0 | 20.5 | 5.4 | 1.3 | 1.1 | .5 | .2 | |
| gc current block congested | 13 | 76.9 | 15.4 | 7.7 | |||||
| gc current grant 2-way | 4865 | 98.3 | 1.1 | .4 | .2 | .0 | |||
| gc current grant busy | 4010 | 98.2 | 1.2 | .4 | .1 | .1 | .0 | .0 | |
| gc current grant congested | 5 | 80.0 | 20.0 | ||||||
| gc current multi block request | 1695 | 96.7 | 2.0 | .5 | .2 | .4 | .1 | .1 | |
| gc current retry | 3 | 100.0 | |||||||
| gc current split | 3 | 100.0 | |||||||
| gc object scan | 39.8K | 100.0 | .0 | ||||||
| gc quiesce | 1 | 100.0 | |||||||
| gc remaster | 35 | 11.4 | 11.4 | 77.1 | |||||
| gcs drm freeze in enter server mode | 57 | 28.1 | 1.8 | 1.8 | 1.8 | 66.7 | |||
| gcs log flush sync | 1007 | 94.4 | 1.5 | 1.9 | .8 | 1.2 | .2 | ||
| ges DFS hang analysis phase 2 acks | 1 | 100.0 | |||||||
| ges generic event | 22 | 4.5 | 81.8 | 13.6 | |||||
| ges inquiry response | 61 | 93.4 | 3.3 | 1.6 | 1.6 | ||||
| ges lms sync during dynamic remastering and reconfig | 132 | .8 | 1.5 | .8 | 97.0 | ||||
| kjbdrmcvtq lmon drm quiesce: ping completion | 40 | 35.0 | 2.5 | 2.5 | 2.5 | 22.5 | 35.0 | ||
| ksdxexeotherwait | 7 | 85.7 | 14.3 | ||||||
| ksxr poll remote instances | 52.8K | 100.0 | .0 | .0 | |||||
| latch free | 47 | 72.3 | 2.1 | 2.1 | 21.3 | 2.1 | |||
| latch: active service list | 6 | 100.0 | |||||||
| latch: cache buffers chains | 190 | 96.8 | 3.2 | ||||||
| latch: cache buffers lru chain | 1 | 100.0 | |||||||
| latch: call allocation | 83 | 96.4 | 1.2 | 2.4 | |||||
| latch: enqueue hash chains | 4 | 100.0 | |||||||
| latch: gc element | 10.1K | 99.8 | .1 | .1 | .0 | .0 | |||
| latch: gcs resource hash | 27 | 100.0 | |||||||
| latch: ges resource hash list | 3726 | 43.3 | 6.5 | 7.4 | 13.3 | 12.6 | 17.0 | ||
| latch: object queue header operation | 391 | 16.9 | 49.6 | 31.5 | 1.0 | .8 | .3 | ||
| latch: redo allocation | 21 | 100.0 | |||||||
| latch: redo writing | 1 | 100.0 | |||||||
| latch: row cache objects | 4 | 100.0 | |||||||
| latch: shared pool | 29 | 100.0 | |||||||
| libcache interrupt action by LCK | 56.4K | 100.0 | |||||||
| library cache load lock | 1037 | 17.9 | 17.6 | 49.4 | 9.6 | 5.0 | .4 | ||
| library cache lock | 4206 | 6.4 | .2 | .2 | .1 | .1 | .1 | 92.8 | |
| library cache pin | 368 | 96.2 | .5 | 1.9 | .5 | .8 | |||
| library cache: mutex X | 1465 | 90.0 | 5.1 | 2.2 | .9 | 1.7 | .1 | ||
| local write wait | 48 | 83.3 | 4.2 | 2.1 | 10.4 | ||||
| lock escalate retry | 1 | 100.0 | |||||||
| log file parallel write | 53.5K | 82.0 | 4.4 | 11.0 | 1.9 | .4 | .3 | .0 | |
| log file sequential read | 3264 | 2.1 | .1 | 1.3 | 86.9 | 5.4 | 2.0 | 2.3 | |
| log file single write | 16 | 100.0 | |||||||
| log file switch completion | 10 | 10.0 | 60.0 | 20.0 | 10.0 | ||||
| log file sync | 34.2K | 92.5 | 3.5 | 2.3 | .9 | .4 | .3 | .1 | |
| name-service call wait | 24 | 4.2 | 4.2 | 4.2 | 8.3 | 79.2 | |||
| os thread startup | 611 | 100.0 | |||||||
| process diagnostic dump | 7 | 100.0 | |||||||
| read by other session | 163 | 3.7 | 5.5 | 16.6 | 35.6 | 35.6 | 1.8 | 1.2 | |
| reliable message | 503 | 78.3 | 17.5 | 2.8 | .8 | .6 | |||
| row cache cleanup | 73.2K | 100.0 | .0 | .0 | |||||
| row cache lock | 10.4K | 97.0 | 1.5 | .7 | .4 | .2 | .1 | .1 | |
| row cache process | 103.2K | 100.0 | |||||||
| wait for scn ack | 8 | 12.5 | 12.5 | 50.0 | 12.5 | 12.5 | |||
| write complete waits | 5 | 80.0 | 20.0 | ||||||
| ASM background timer | 2954 | 1.5 | .2 | .2 | .1 | .1 | .3 | 97.7 | |
| DIAG idle wait | 304K | 37.7 | .3 | .5 | 1.4 | 2.9 | 4.5 | 52.7 | |
| GCR sleep | 2883 | 100.0 | |||||||
| KSV master wait | 8841 | 99.7 | .1 | .1 | .1 | .0 | .1 | ||
| PING | 5738 | 79.2 | 1.2 | .1 | .1 | .0 | 19.6 | ||
| PX Deq: Execute Reply | 106 | 81.1 | 2.8 | 14.2 | 1.9 | ||||
| PX Deq: Execution Msg | 676 | 88.5 | 7.5 | 2.5 | 1.0 | .4 | |||
| PX Deq: Join ACK | 106 | 38.7 | 37.7 | 22.6 | .9 | ||||
| PX Deq: Parse Reply | 106 | 81.1 | 17.0 | 1.9 | |||||
| PX Idle Wait | 169 | 5.9 | 14.8 | 7.7 | 1.2 | 8.9 | 3.6 | 19.5 | 38.5 |
| SQL*Net message from client | 569.3K | 57.3 | 8.3 | 2.7 | .5 | 21.3 | 1.1 | 6.4 | 2.4 |
| Space Manager: slave idle wait | 7276 | .1 | .0 | .0 | .1 | .0 | .0 | 1.8 | 97.9 |
| Streams AQ: RAC qmn coordinator idle wait | 1014 | 100.0 | |||||||
| Streams AQ: qmn coordinator idle wait | 999 | 48.6 | .6 | .4 | .2 | 50.2 | |||
| Streams AQ: qmn slave idle wait | 513 | 100.0 | |||||||
| class slave wait | 540 | 49.4 | 2.6 | 14.1 | 3.3 | 2.6 | 2.4 | 3.3 | 22.2 |
| dispatcher timer | 240 | 100.0 | |||||||
| gcs remote message | 2510.4K | 6.5 | 1.2 | 1.3 | 1.9 | 66.3 | 22.9 | .0 | |
| ges remote message | 746.1M | 100.0 | .0 | .0 | .0 | .0 | .0 | .0 | |
| jobq slave wait | 29.7K | .0 | .0 | .0 | .0 | .0 | 100.0 | ||
| pmon timer | 4806 | .1 | 99.9 | ||||||
| rdbms ipc message | 382.4K | 21.0 | 1.1 | 2.6 | 2.2 | 1.1 | 1.3 | 51.1 | 19.6 |
| shared server idle wait | 481 | 100.0 | |||||||
| smon timer | 119 | .8 | 5.0 | .8 | 23.5 | 69.7 | |||
| wait for unread message on broadcast channel | 28.8K | .0 | 100.0 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
| ADR block file read | 1 | 98.3 | 1.7 | ||||||
| ASM file metadata operation | 5 | 99.9 | .1 | ||||||
| CSS initialization | 1 | 99.3 | .7 | ||||||
| DFS lock handle | 55 | 99.0 | .8 | .1 | .1 | ||||
| Log archive I/O | 58 | 12.1 | 48.5 | 36.4 | 3.0 | ||||
| control file parallel write | 4 | 99.9 | .0 | .1 | |||||
| control file sequential read | 11 | 100.0 | .0 | .0 | |||||
| cursor: pin S wait on X | 13 | 71.7 | 13.0 | 2.2 | 4.3 | 8.7 | |||
| db file parallel read | 8 | 84.0 | 12.0 | 4.0 | |||||
| db file parallel write | 1 | 100.0 | .0 | ||||||
| db file scattered read | 4678 | 94.7 | 3.7 | 1.1 | .4 | .1 | .0 | ||
| db file sequential read | 179 | 99.2 | .5 | .2 | .1 | .0 | .0 | ||
| direct path read | 433 | 77.9 | 16.4 | 4.8 | .7 | .2 | |||
| direct path write | 150 | 92.5 | 6.0 | 1.6 | |||||
| enq: CO - master slave det | 23 | 99.5 | .4 | .1 | |||||
| enq: FB - contention | 1 | 99.4 | .6 | ||||||
| enq: JQ - contention | 2 | 99.1 | .9 | ||||||
| enq: RO - fast object reuse | 5 | 98.3 | 1.0 | .3 | .3 | ||||
| enq: TM - contention | 4 | 98.5 | .8 | .8 | |||||
| enq: TX - index contention | 1 | 96.6 | 3.4 | ||||||
| enq: WF - contention | 4 | 94.7 | 1.3 | 2.7 | 1.3 | ||||
| gc buffer busy acquire | 2 | 99.7 | .2 | .2 | |||||
| gc buffer busy release | 2 | 99.1 | .5 | .5 | |||||
| gc cr block 2-way | 4 | 99.9 | .0 | .0 | |||||
| gc cr grant 2-way | 1 | 100.0 | .0 | ||||||
| gc cr multi block request | 1 | 100.0 | .0 | ||||||
| gc current block 2-way | 4 | 100.0 | .0 | .0 | |||||
| gc current block busy | 1 | 99.8 | .2 | ||||||
| gc current grant busy | 1 | 100.0 | .0 | ||||||
| gc current multi block request | 2 | 99.9 | .1 | ||||||
| gc remaster | 27 | 22.9 | 31.4 | 31.4 | 14.3 | ||||
| gcs drm freeze in enter server mode | 38 | 33.3 | 1.8 | 35.1 | 29.8 | ||||
| ges lms sync during dynamic remastering and reconfig | 128 | 3.0 | 24.2 | 59.8 | 9.8 | 1.5 | 1.5 | ||
| kjbdrmcvtq lmon drm quiesce: ping completion | 14 | 65.0 | 27.5 | 7.5 | |||||
| library cache lock | 12 | 7.1 | .0 | .0 | .0 | .0 | .2 | 92.7 | |
| local write wait | 5 | 89.6 | 2.1 | 6.3 | 2.1 | ||||
| log file parallel write | 25 | 100.0 | .0 | .0 | .0 | ||||
| log file sequential read | 76 | 97.7 | 1.9 | .4 | .0 | ||||
| log file sync | 50 | 99.9 | .1 | .0 | .0 | ||||
| name-service call wait | 19 | 20.8 | 20.8 | 58.3 | |||||
| os thread startup | 611 | .2 | 99.7 | .2 | |||||
| process diagnostic dump | 7 | 100.0 | |||||||
| read by other session | 2 | 98.8 | .6 | .6 | |||||
| row cache lock | 8 | 99.9 | .1 | ||||||
| wait for scn ack | 1 | 87.5 | 12.5 |
| % 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 | 3 | 100.0 | |||||||
| library cache lock | 632 | 7.3 | .2 | .4 | 1.5 | 2.5 | 3.1 | 7.3 | 77.6 |
| % of Total Waits | ||||||||
|---|---|---|---|---|---|---|---|---|
| Event | Waits 4m to 1h | <2m | <4m | <8m | <1/4h | <1/2h | < 1h | >=1h |
| library cache lock | 3265 | 22.4 | 12.6 | 23.6 | 21.1 | 14.2 | 6.1 |
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|---|---|---|---|
| billdb | 2,912,451 | 141 | 0 | 14 |
| serv_taf_billdb | 3,711 | 2,119 | 11,824 | 36,774 |
| SYS$USERS | 11 | 14 | 0 | 53 |
| SYS$BACKGROUND | 1 | 0 | 7 | 196 |
| billdbXDB | 0 | 0 | 0 | 0 |
| Service Name | User I/O Total Wts | User I/O Wt Time | Concurcy Total Wts | Concurcy Wt Time | Admin Total Wts | Admin Wt Time | Network Total Wts | Network Wt Time |
|---|---|---|---|---|---|---|---|---|
| serv_taf_billdb | 112127 | 1498 | 12028 | 7 | 0 | 0 | 549830 | 1 |
| SYS$USERS | 319 | 1 | 191 | 0 | 0 | 0 | 78 | 0 |
| SYS$BACKGROUND | 8110 | 12 | 57545 | 45 | 0 | 0 | 0 | 0 |
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 2,529.25 | 4 | 632.31 | 0.09 | 52.02 | 46.35 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 468.29 | 4,322 | 0.11 | 0.02 | 94.62 | 0.22 | 0nwhja3d24zna | JDBC Thin Client | select long_code from h1h2h3_c... |
| 232.93 | 1 | 232.93 | 0.01 | 33.76 | 65.91 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 229.18 | 1 | 229.18 | 0.01 | 34.26 | 65.72 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 226.63 | 1 | 226.63 | 0.01 | 31.18 | 68.79 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 224.66 | 1 | 224.66 | 0.01 | 31.21 | 65.37 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 222.09 | 1 | 222.09 | 0.01 | 26.95 | 71.21 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 194.67 | 1 | 194.67 | 0.01 | 41.07 | 56.09 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 168.23 | 4 | 42.06 | 0.01 | 41.87 | 53.41 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 144.54 | 1 | 144.54 | 0.00 | 36.18 | 58.29 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 1,315.76 | 4 | 328.94 | 57.85 | 2,529.25 | 52.02 | 46.35 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 443.08 | 4,322 | 0.10 | 19.48 | 468.29 | 94.62 | 0.22 | 0nwhja3d24zna | JDBC Thin Client | select long_code from h1h2h3_c... |
| 102.19 | 1 | 102.19 | 4.49 | 104.27 | 98.00 | 0.00 | 2bhsyfrtryurs | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 101.30 | 1 | 101.30 | 4.45 | 103.29 | 98.07 | 0.00 | 8890c7sc3d79v | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 87.98 | 1 | 87.98 | 3.87 | 89.59 | 98.20 | 0.00 | gfwntbr4srn32 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 79.95 | 1 | 79.95 | 3.52 | 194.67 | 41.07 | 56.09 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 78.63 | 1 | 78.63 | 3.46 | 232.93 | 33.76 | 65.91 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 78.51 | 1 | 78.51 | 3.45 | 229.18 | 34.26 | 65.72 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 70.67 | 1 | 70.67 | 3.11 | 226.63 | 31.18 | 68.79 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 70.44 | 4 | 17.61 | 3.10 | 168.23 | 41.87 | 53.41 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 70.11 | 1 | 70.11 | 3.08 | 224.66 | 31.21 | 65.37 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 66.79 | 1 | 66.79 | 2.94 | 138.99 | 48.05 | 51.31 | 4r5cwzvx5x6da | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 66.30 | 1 | 66.30 | 2.92 | 129.83 | 51.06 | 48.13 | 2b6st92uvbrm2 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 59.85 | 1 | 59.85 | 2.63 | 222.09 | 26.95 | 71.21 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 57.69 | 1 | 57.69 | 2.54 | 125.25 | 46.06 | 51.89 | b1x50gyk9aga4 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 52.29 | 1 | 52.29 | 2.30 | 144.54 | 36.18 | 58.29 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 51.42 | 3 | 17.14 | 2.26 | 54.62 | 94.14 | 3.56 | 4n9qbagp365rm | JDBC Thin Client | select acc_nbr, ACCT_ID, sum(S... |
| 40.65 | 1 | 40.65 | 1.79 | 99.21 | 40.97 | 56.57 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 31.66 | 1 | 31.66 | 1.39 | 32.16 | 98.42 | 0.00 | 4qgy7hb50s7zu | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 31.13 | 1 | 31.13 | 1.37 | 31.77 | 97.97 | 0.00 | ckxn93uv68kjn | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 31.09 | 1 | 31.09 | 1.37 | 31.84 | 97.65 | 0.00 | f1vk1uzbqwt9u | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 1,172.35 | 4 | 293.09 | 77.53 | 2,529.25 | 52.02 | 46.35 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 158.16 | 1 | 158.16 | 10.46 | 222.09 | 26.95 | 71.21 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 155.91 | 1 | 155.91 | 10.31 | 226.63 | 31.18 | 68.79 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 153.52 | 1 | 153.52 | 10.15 | 232.93 | 33.76 | 65.91 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 150.61 | 1 | 150.61 | 9.96 | 229.18 | 34.26 | 65.72 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 146.85 | 1 | 146.85 | 9.71 | 224.66 | 31.21 | 65.37 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 109.20 | 1 | 109.20 | 7.22 | 194.67 | 41.07 | 56.09 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 89.85 | 4 | 22.46 | 5.94 | 168.23 | 41.87 | 53.41 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 84.25 | 1 | 84.25 | 5.57 | 144.54 | 36.18 | 58.29 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 71.31 | 1 | 71.31 | 4.72 | 138.99 | 48.05 | 51.31 | 4r5cwzvx5x6da | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 65.00 | 1 | 65.00 | 4.30 | 125.25 | 46.06 | 51.89 | b1x50gyk9aga4 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 62.48 | 1 | 62.48 | 4.13 | 129.83 | 51.06 | 48.13 | 2b6st92uvbrm2 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 56.12 | 1 | 56.12 | 3.71 | 99.21 | 40.97 | 56.57 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 20.52 | 1 | 20.52 | 1.36 | 35.89 | 41.23 | 57.17 | gkft43dwfr4xy | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 19.90 | 1 | 19.90 | 1.32 | 33.44 | 38.98 | 59.50 | 0ybr0kuvpzhka | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 18.79 | 1 | 18.79 | 1.24 | 31.26 | 36.41 | 60.13 | 20c20vxxua4tj | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 18.19 | 4,320 | 0.00 | 1.20 | 19.37 | 4.53 | 93.91 | 9h2u19172qhpr | JDBC Thin Client | INSERT INTO SERV_STATE_ATTR( S... |
| 16.21 | 35,059 | 0.00 | 1.07 | 20.15 | 16.21 | 80.44 | duq051av3gh2n | JDBC Thin Client | INSERT INTO SERV_PRODUCT( SERV... |
| 16.14 | 1 | 16.14 | 1.07 | 30.20 | 44.55 | 53.46 | abd43x58bcyf0 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 19,660,350 | 4 | 4,915,087.50 | 53.08 | 2,529.25 | 52 | 46.4 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 11,667,432 | 4,322 | 2,699.54 | 31.50 | 468.29 | 94.6 | .2 | 0nwhja3d24zna | JDBC Thin Client | select long_code from h1h2h3_c... |
| 2,090,047 | 4 | 522,511.75 | 5.64 | 168.23 | 41.9 | 53.4 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 1,335,200 | 1 | 1,335,200.00 | 3.61 | 222.09 | 26.9 | 71.2 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,335,094 | 1 | 1,335,094.00 | 3.60 | 232.93 | 33.8 | 65.9 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,335,094 | 1 | 1,335,094.00 | 3.60 | 229.18 | 34.3 | 65.7 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,335,094 | 1 | 1,335,094.00 | 3.60 | 226.63 | 31.2 | 68.8 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,076,740 | 1 | 1,076,740.00 | 2.91 | 194.67 | 41.1 | 56.1 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,076,640 | 1 | 1,076,640.00 | 2.91 | 104.27 | 98 | 0 | 2bhsyfrtryurs | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,076,640 | 1 | 1,076,640.00 | 2.91 | 103.29 | 98.1 | 0 | 8890c7sc3d79v | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,076,640 | 1 | 1,076,640.00 | 2.91 | 89.59 | 98.2 | 0 | gfwntbr4srn32 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,066,895 | 1 | 1,066,895.00 | 2.88 | 224.66 | 31.2 | 65.4 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 665,236 | 1 | 665,236.00 | 1.80 | 144.54 | 36.2 | 58.3 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 665,132 | 1 | 665,132.00 | 1.80 | 129.83 | 51.1 | 48.1 | 2b6st92uvbrm2 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 665,132 | 1 | 665,132.00 | 1.80 | 138.99 | 48.1 | 51.3 | 4r5cwzvx5x6da | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 665,132 | 1 | 665,132.00 | 1.80 | 125.25 | 46.1 | 51.9 | b1x50gyk9aga4 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 529,053 | 1 | 529,053.00 | 1.43 | 99.21 | 41 | 56.6 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 528,776 | 1 | 528,776.00 | 1.43 | 32.16 | 98.4 | 0 | 4qgy7hb50s7zu | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 513,099 | 1 | 513,099.00 | 1.39 | 31.77 | 98 | 0 | ckxn93uv68kjn | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 513,099 | 1 | 513,099.00 | 1.39 | 31.84 | 97.7 | 0 | f1vk1uzbqwt9u | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 9,473,759 | 4 | 2,368,439.75 | 80.07 | 2,529.25 | 52.02 | 46.35 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 1,321,319 | 1 | 1,321,319.00 | 11.17 | 222.09 | 26.95 | 71.21 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,320,636 | 1 | 1,320,636.00 | 11.16 | 232.93 | 33.76 | 65.91 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,320,633 | 1 | 1,320,633.00 | 11.16 | 229.18 | 34.26 | 65.72 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,320,633 | 1 | 1,320,633.00 | 11.16 | 226.63 | 31.18 | 68.79 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,061,071 | 1 | 1,061,071.00 | 8.97 | 194.67 | 41.07 | 56.09 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 1,061,063 | 1 | 1,061,063.00 | 8.97 | 224.66 | 31.21 | 65.37 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 947,035 | 4 | 236,758.75 | 8.00 | 168.23 | 41.87 | 53.41 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 653,128 | 1 | 653,128.00 | 5.52 | 144.54 | 36.18 | 58.29 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 512,766 | 1 | 512,766.00 | 4.33 | 99.21 | 40.97 | 56.57 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 501,311 | 1 | 501,311.00 | 4.24 | 138.99 | 48.05 | 51.31 | 4r5cwzvx5x6da | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 431,261 | 1 | 431,261.00 | 3.65 | 129.83 | 51.06 | 48.13 | 2b6st92uvbrm2 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 377,160 | 1 | 377,160.00 | 3.19 | 125.25 | 46.06 | 51.89 | b1x50gyk9aga4 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 318,369 | 3 | 106,123.00 | 2.69 | 54.62 | 94.14 | 3.56 | 4n9qbagp365rm | JDBC Thin Client | select acc_nbr, ACCT_ID, sum(S... |
| 171,936 | 1 | 171,936.00 | 1.45 | 24.83 | 46.68 | 47.60 | 0bpdxssyng6pr | SQL*Plus | create table dd_ocs_trans_log... |
| 152,257 | 1 | 152,257.00 | 1.29 | 26.05 | 39.85 | 56.45 | 08qz2ujc68ct8 | SQL*Plus | create table dd_ocs_trans_log... |
| 126,033 | 1 | 126,033.00 | 1.07 | 18.46 | 48.13 | 48.29 | 8nf2jk7pvj1u7 | SQL*Plus | create table dd_ocs_payment_A... |
| 125,761 | 1 | 125,761.00 | 1.06 | 21.56 | 39.85 | 56.56 | bmdy8jctg3nfv | SQL*Plus | create table dd_ocs_trans_log... |
| 125,404 | 1 | 125,404.00 | 1.06 | 35.89 | 41.23 | 57.17 | gkft43dwfr4xy | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 125,399 | 1 | 125,399.00 | 1.06 | 33.44 | 38.98 | 59.50 | 0ybr0kuvpzhka | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 12,052 | 12,052 | 1 | 12,052.00 | 0.00 | 9.74 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 10,364 | 10,364 | 1 | 10,364.00 | 0.00 | 8.38 | 8mmvp2794hzg8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 10,363 | 10,363 | 1 | 10,363.00 | 0.00 | 8.38 | 9njd665pxz13c | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 10,361 | 10,361 | 1 | 10,361.00 | 0.00 | 8.38 | 1tnhyjvfdy4bw | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 9,360 | 9,360 | 1 | 9,360.00 | 0.00 | 7.57 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 9,354 | 9,354 | 1 | 9,354.00 | 0.00 | 7.56 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 6,844 | 6,844 | 1 | 6,844.00 | 0.00 | 5.53 | 4r5cwzvx5x6da | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 5,913 | 5,913 | 1 | 5,913.00 | 0.00 | 4.78 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 5,586 | 5,586 | 1 | 5,586.00 | 0.00 | 4.52 | b1x50gyk9aga4 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 5,303 | 5,303 | 1 | 5,303.00 | 0.00 | 4.29 | 2b6st92uvbrm2 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 4,903 | 4,903 | 4 | 1,225.75 | 0.00 | 3.96 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 4,061 | 4,061 | 1 | 4,061.00 | 0.00 | 3.28 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 2,481 | 2,481 | 3 | 827.00 | 0.00 | 2.01 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
| 1,459 | 1,459 | 4 | 364.75 | 0.00 | 1.18 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 1,451 | 1,451 | 1 | 1,451.00 | 0.00 | 1.17 | 0bpdxssyng6pr | SQL*Plus | create table dd_ocs_trans_log... |
| 1,279 | 1,279 | 1 | 1,279.00 | 0.00 | 1.03 | 08qz2ujc68ct8 | SQL*Plus | create table dd_ocs_trans_log... |
| Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 35,059 | 35,059 | 1.00 | 3.37 | 80.7 | 0 | dhhkjcwj5hdqs | JDBC Thin Client | SELECT serv_product_SEQ.NEXTVA... |
| 35,059 | 35,059 | 1.00 | 20.15 | 16.2 | 80.4 | duq051av3gh2n | JDBC Thin Client | INSERT INTO SERV_PRODUCT( SERV... |
| 23,608 | 23,608 | 1.00 | 1.98 | 93.1 | 0 | a5ks9fhw2v9s1 | JDBC Thin Client | select * from dual |
| 8,455 | 8,550 | 1.01 | 0.63 | 92 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
| 5,886 | 5,886 | 1.00 | 0.40 | 66.2 | 8.3 | 21pub7j93z0dw | JDBC Thin Client | select count(*) from t_bss_log... |
| 5,886 | 5,886 | 1.00 | 4.44 | 30.4 | 53.8 | dky3swb1whdab | JDBC Thin Client | insert into t_bss_log (id, lin... |
| 5,815 | 5,815 | 1.00 | 2.57 | 22 | 74.5 | dxk06nx0rudyy | JDBC Thin Client | INSERT INTO START_BALANCE( DAT... |
| 5,220 | 5,220 | 1.00 | 6.69 | 8.2 | 90.4 | 2thzh37kd68zh | JDBC Thin Client | SELECT COUNT(*) FROM CUST WHER... |
| 5,220 | 5,220 | 1.00 | 3.10 | 40.1 | 44.1 | 3tjwxfb56fg6w | JDBC Thin Client | INSERT INTO T_OCS_REPORT( ID, ... |
| 4,322 | 4,318 | 1.00 | 468.29 | 94.6 | .2 | 0nwhja3d24zna | JDBC Thin Client | select long_code from h1h2h3_c... |
| 4,320 | 4,320 | 1.00 | 0.80 | 40.6 | 52.6 | 0x7hnctjscg38 | JDBC Thin Client | INSERT INTO SERV_IDENTIFICATIO... |
| 4,320 | 4,320 | 1.00 | 7.35 | 14 | 82.9 | 81s7xuu20q5tj | JDBC Thin Client | INSERT INTO SERV_BILLING_MODE(... |
| 4,320 | 4,320 | 1.00 | 19.37 | 4.5 | 93.9 | 9h2u19172qhpr | JDBC Thin Client | INSERT INTO SERV_STATE_ATTR( S... |
| 4,320 | 4,320 | 1.00 | 5.16 | 8 | 88 | akuaap5fzxz36 | JDBC Thin Client | SELECT COUNT(*) FROM ACCT WHER... |
| 4,320 | 4,320 | 1.00 | 2.21 | 25.1 | 67.8 | cray4dawh5vsd | JDBC Thin Client | INSERT INTO SERV_ATTR( SERV_ID... |
| 4,320 | 4,320 | 1.00 | 16.55 | 7.1 | 89 | fa93th133ft9s | JDBC Thin Client | INSERT INTO PRODUCT_OFFER_INST... |
| 3,532 | 3,532 | 1.00 | 1.35 | 63 | 32 | 0vttswnff2ub6 | AM_Server_B12@xjocsapp1 (TNS V1-V3) | INSERT INTO PAYMENT ( PAYMENT_... |
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 2,774 | 2,774 | 4.87 | 0k8522rmdzg4k | select privilege# from sysauth... | |
| 2,774 | 8,455 | 4.87 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
| 2,713 | 2,713 | 4.76 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
| 2,713 | 2,713 | 4.76 | 459f3z9u4fb3u | select value$ from props$ wher... | |
| 2,708 | 2,709 | 4.75 | 5ur69atw3vfhj | select decode(failover_method,... | |
| 2,653 | 2,653 | 4.66 | f711myt0q6cma | plsqldev-2.exe | insert into sys.aud$( sessioni... |
| 1,288 | 1,288 | 2.26 | b84cknyvnyq25 | update user$ set exptime=DECOD... | |
| 1,262 | 1,293 | 2.22 | 38t3pnrp90uxy | select exptime, ltime, astatus... | |
| 965 | 965 | 1.69 | 350f5yrnnmshs | lock table sys.mon_mods$ in ex... | |
| 586 | 586 | 1.03 | 1uzhrfn574t12 | sqlplus@xjocsapp1 (TNS V1-V3) | SELECT ATTRIBUTE, SCOPE, NUMER... |
| 586 | 586 | 1.03 | 5qgz1p0cut7mx | sqlplus@xjocsapp1 (TNS V1-V3) | BEGIN DBMS_OUTPUT.DISABLE; END... |
| 586 | 586 | 1.03 | dyk4dprp70d74 | SQL*Plus | SELECT DECODE('A', 'A', '1', '... |
| Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 24.49 | 4 | 49.28 | 2,529.25 | 0.97 | 52.02 | 46.35 | fy69aczq0g4jw | SQL*Plus | declare ret varchar2(2) :='1';... |
| 6.47 | 1 | 13.01 | 144.54 | 4.48 | 36.18 | 58.29 | 2pd3jp7fwdt04 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 5.18 | 1 | 10.42 | 194.67 | 2.66 | 41.07 | 56.09 | 1bf6tp5cjuvay | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 4.72 | 1 | 9.49 | 224.66 | 2.10 | 31.21 | 65.37 | fk1a5dugnjw30 | SQL*Plus | INSERT INTO dd_ocs_balance_pay... |
| 3.99 | 1 | 8.03 | 99.21 | 4.02 | 40.97 | 56.57 | 67bsjr0bg7udk | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 3.81 | 1 | 7.66 | 222.09 | 1.71 | 26.95 | 71.21 | 1tr7bnksv3an8 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 2.28 | 4 | 4.59 | 168.23 | 1.36 | 41.87 | 53.41 | 6x5hq36g35h2v | SQL*Plus | declare ret varchar2(2) :='1';... |
| 1.50 | 2,653 | 3.01 | 3.00 | 49.85 | 44.54 | 9.73 | f711myt0q6cma | plsqldev-2.exe | insert into sys.aud$( sessioni... |
| 1.08 | 3 | 2.17 | 7.94 | 13.60 | 18.23 | 70.29 | 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :... | |
| 1.07 | 2,873 | 2.15 | 3.08 | 34.62 | 64.61 | 1.81 | fbzsh1af230p6 | sms_tpl_A11@xjocsapp1 (TNS V1-V3) | select PRICING_PLAN_ID, DETAIL... |
| 0.91 | 1 | 1.83 | 30.20 | 3.00 | 44.55 | 53.46 | abd43x58bcyf0 | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.88 | 1 | 1.76 | 31.26 | 2.81 | 36.41 | 60.13 | 20c20vxxua4tj | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.85 | 1 | 1.71 | 35.89 | 2.37 | 41.23 | 57.17 | gkft43dwfr4xy | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.83 | 1 | 1.66 | 33.44 | 2.47 | 38.98 | 59.50 | 0ybr0kuvpzhka | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.80 | 1 | 1.61 | 21.31 | 3.76 | 28.63 | 69.51 | 9bguru637a32y | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.72 | 2 | 1.44 | 6.25 | 11.49 | 7.48 | 83.18 | 47mm81hm9sggy | SELECT sum(case when a.sessio... | |
| 0.65 | 1 | 1.30 | 21.30 | 3.04 | 34.48 | 63.77 | duwm2g5c766qs | SQL*Plus | MERGE INTO ocs_user_cnt c USI... |
| 0.63 | 1 | 1.27 | 24.83 | 2.53 | 46.68 | 47.60 | 0bpdxssyng6pr | SQL*Plus | create table dd_ocs_trans_log... |
| 0.60 | 1 | 1.21 | 14.53 | 4.14 | 31.73 | 63.79 | 7u1us1y40540r | SQL*Plus | create table dd_ocs_payment_A... |
| 0.50 | 2,732 | 1.01 | 1.08 | 46.69 | 41.66 | 0.00 | 0kkhhb2w93cx0 | update seg$ set type#=:4, bloc... | |
| 0.48 | 4,320 | 0.97 | 16.55 | 2.91 | 7.12 | 89.04 | fa93th133ft9s | JDBC Thin Client | INSERT INTO PRODUCT_OFFER_INST... |
| 0.44 | 35,059 | 0.89 | 20.15 | 2.19 | 16.21 | 80.44 | duq051av3gh2n | JDBC Thin Client | INSERT INTO SERV_PRODUCT( SERV... |
| 0.44 | 5,886 | 0.88 | 4.44 | 9.91 | 30.36 | 53.81 | dky3swb1whdab | JDBC Thin Client | insert into t_bss_log (id, lin... |
| 0.38 | 4,320 | 0.76 | 19.37 | 1.96 | 4.53 | 93.91 | 9h2u19172qhpr | JDBC Thin Client | INSERT INTO SERV_STATE_ATTR( S... |
| 0.34 | 31 | 0.69 | 6.28 | 5.45 | 78.07 | 1.49 | b4qw7n9wg64mh | INSERT /*+ APPEND LEADING(@"SE... | |
| 0.18 | 4,320 | 0.36 | 7.35 | 2.43 | 14.03 | 82.93 | 81s7xuu20q5tj | JDBC Thin Client | INSERT INTO SERV_BILLING_MODE(... |
| 0.16 | 4,320 | 0.31 | 5.16 | 3.02 | 8.03 | 87.95 | akuaap5fzxz36 | JDBC Thin Client | SELECT COUNT(*) FROM ACCT WHER... |
| 0.15 | 1,288 | 0.30 | 1.29 | 11.61 | 84.87 | 2.26 | b84cknyvnyq25 | update user$ set exptime=DECOD... | |
| 0.14 | 5,220 | 0.28 | 3.10 | 4.50 | 40.10 | 44.14 | 3tjwxfb56fg6w | JDBC Thin Client | INSERT INTO T_OCS_REPORT( ID, ... |
| 0.13 | 1,438 | 0.27 | 0.47 | 28.25 | 74.85 | 0.00 | 5ms6rbzdnq16t | select job, nvl2(last_date, 1,... | |
| 0.11 | 5,220 | 0.23 | 6.69 | 1.72 | 8.23 | 90.38 | 2thzh37kd68zh | JDBC Thin Client | SELECT COUNT(*) FROM CUST WHER... |
| 0.11 | 4,320 | 0.22 | 2.21 | 4.89 | 25.13 | 67.77 | cray4dawh5vsd | JDBC Thin Client | INSERT INTO SERV_ATTR( SERV_ID... |
| 0.11 | 5,886 | 0.22 | 0.40 | 26.69 | 66.19 | 8.29 | 21pub7j93z0dw | JDBC Thin Client | select count(*) from t_bss_log... |
| 0.10 | 2,062 | 0.20 | 0.77 | 13.17 | 31.49 | 54.29 | 9b0zsq55t0f51 | JDBC Thin Client | INSERT INTO ACCT ( ACCT_ID , C... |
| 0.09 | 30 | 0.18 | 1.01 | 8.94 | 79.95 | 6.77 | 6gvch1xu9ca3g | DECLARE job BINARY_INTEGER := ... | |
| 0.08 | 2,727 | 0.17 | 0.61 | 13.93 | 82.15 | 0.50 | 4m7m0t6fjcs5x | update seq$ set increment$=:2,... | |
| 0.07 | 4,322 | 0.13 | 468.29 | 0.01 | 94.62 | 0.22 | 0nwhja3d24zna | JDBC Thin Client | select long_code from h1h2h3_c... |
| 0.06 | 1 | 0.12 | 16.54 | 0.36 | 48.90 | 46.77 | 4w6cnzcncw2uw | SQL*Plus | create table dd_ocs_payment_B... |
| 0.06 | 1 | 0.12 | 26.05 | 0.22 | 39.85 | 56.45 | 08qz2ujc68ct8 | SQL*Plus | create table dd_ocs_trans_log... |
| 0.06 | 2,873 | 0.11 | 1.84 | 3.07 | 36.02 | 53.16 | 3h2pzu63d08xb | sms_tpl_A11@xjocsapp1 (TNS V1-V3) | insert into sms_cf_mid_his(SMS... |
| 0.06 | 707 | 0.11 | 0.12 | 47.21 | 47.03 | 14.56 | 3nkd3g3ju5ph1 | select obj#, type#, ctime, mti... | |
| 0.06 | 780 | 0.11 | 0.64 | 8.66 | 35.15 | 55.49 | fxyuv4hzcr86p | JDBC Thin Client | INSERT INTO CUST( CUST_ID , CU... |
| 0.05 | 1 | 0.10 | 18.46 | 0.28 | 48.13 | 48.29 | 8nf2jk7pvj1u7 | SQL*Plus | create table dd_ocs_payment_A... |
| 0.05 | 5,815 | 0.10 | 2.57 | 2.00 | 22.02 | 74.54 | dxk06nx0rudyy | JDBC Thin Client | INSERT INTO START_BALANCE( DAT... |
| 0.05 | 212 | 0.10 | 0.08 | 61.32 | 46.70 | 3.56 | axmdf8vq7k1rh | select increment$, minvalue, m... | |
| 0.05 | 1 | 0.10 | 21.56 | 0.22 | 39.85 | 56.56 | bmdy8jctg3nfv | SQL*Plus | create table dd_ocs_trans_log... |
| 0.04 | 35,059 | 0.07 | 3.37 | 1.08 | 80.70 | 0.00 | dhhkjcwj5hdqs | JDBC Thin Client | SELECT serv_product_SEQ.NEXTVA... |
| 0.03 | 1,293 | 0.07 | 0.43 | 7.99 | 85.15 | 7.03 | 38t3pnrp90uxy | select exptime, ltime, astatus... | |
| 0.03 | 5 | 0.07 | 0.81 | 4.04 | 14.08 | 80.97 | g162gqkkzyp5z | JDBC Thin Client | select msisdn, divert, brand, ... |
| 0.03 | 33 | 0.05 | 0.05 | 55.95 | 51.71 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
| 0.03 | 55 | 0.05 | 0.08 | 33.92 | 68.41 | 29.54 | cumjq42201t37 | select u1.user#, u2.user#, u3.... | |
| 0.02 | 1 | 0.05 | 0.09 | 27.67 | 75.98 | 0.00 | 6cp74g22fzahf | WITH ash as (SELECT ash.event... | |
| 0.02 | 249 | 0.05 | 0.36 | 6.76 | 41.78 | 51.32 | 7ng34ruy5awxq | select i.obj#, i.ts#, i.file#,... | |
| 0.02 | 398 | 0.05 | 0.06 | 39.14 | 56.81 | 1.71 | 9tgj4g8y4rwy8 | select type#, blocks, extents,... | |
| 0.02 | 170 | 0.04 | 0.13 | 16.46 | 14.86 | 70.52 | db78fxqxwxt7r | select /*+ rule */ bucket, end... | |
| 0.02 | 4,320 | 0.04 | 0.80 | 2.33 | 40.63 | 52.62 | 0x7hnctjscg38 | JDBC Thin Client | INSERT INTO SERV_IDENTIFICATIO... |
| 0.02 | 3,532 | 0.04 | 1.35 | 1.34 | 62.96 | 32.05 | 0vttswnff2ub6 | AM_Server_B12@xjocsapp1 (TNS V1-V3) | INSERT INTO PAYMENT ( PAYMENT_... |
| 0.02 | 3 | 0.03 | 0.22 | 7.66 | 18.19 | 75.48 | fnk7155mk2jq6 | insert into wrh$_sysmetric_his... | |
| 0.02 | 6 | 0.03 | 0.96 | 1.69 | 33.16 | 3.72 | bjstq78pprd24 | SQL Loader Direct Path Load | SELECT DECODE(ELEMENT_SUBSTITU... |
| 0.02 | 6 | 0.03 | 0.04 | 41.16 | 63.72 | 0.00 | 4tg8mr2bvy6gr | select smontabv.cnt, smontab.t... | |
| 0.01 | 165 | 0.03 | 0.22 | 6.15 | 15.16 | 79.66 | 3ktacv9r56b51 | select owner#, name, namespace... | |
| 0.01 | 247 | 0.02 | 0.20 | 6.00 | 18.21 | 77.88 | gx4mv66pvj3xz | select con#, type#, condlength... | |
| 0.01 | 2 | 0.02 | 0.15 | 6.01 | 93.53 | 0.00 | 586b2udq6dbng | insert into wrh$_sysstat (snap... | |
| 0.01 | 1 | 0.02 | 2.58 | 0.31 | 97.46 | 0.02 | f5yun5dynkskv | plsqldev-2.exe | select s.synonym_name as obje... |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 9 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 2 | 0.00 | 0.00 |
| Batched IO same unit count | 2 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 6 | 0.00 | 0.00 |
| Batched IO vector read count | 2 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 1,656 | 0.11 | 0.03 |
| CCursor + sql area evicted | 5 | 0.00 | 0.00 |
| CPU used by this session | 1,141,040 | 79.17 | 21.13 |
| CPU used when call started | 216,550 | 15.02 | 4.01 |
| CR blocks created | 1,229 | 0.09 | 0.02 |
| Cached Commit SCN referenced | 17,300,443 | 1,200.34 | 320.34 |
| Commit SCN cached | 2,373 | 0.16 | 0.04 |
| DB time | 280,725,396 | 19,477.28 | 5,197.94 |
| DBWR checkpoint buffers written | 39,199 | 2.72 | 0.73 |
| DBWR checkpoints | 137 | 0.01 | 0.00 |
| DBWR fusion writes | 2,013 | 0.14 | 0.04 |
| DBWR object drop buffers written | 81 | 0.01 | 0.00 |
| DBWR tablespace checkpoint buffers written | 475 | 0.03 | 0.01 |
| DBWR thread checkpoint buffers written | 4,930 | 0.34 | 0.09 |
| DBWR transaction table writes | 459 | 0.03 | 0.01 |
| DBWR undo block writes | 10,758 | 0.75 | 0.20 |
| DFO trees parallelized | 65 | 0.00 | 0.00 |
| Effective IO time | 47,939,960 | 3,326.17 | 887.66 |
| HSC Heap Segment Block Changes | 139,528 | 9.68 | 2.58 |
| Heap Segment Array Inserts | 1,217 | 0.08 | 0.02 |
| Heap Segment Array Updates | 2,583 | 0.18 | 0.05 |
| Number of read IOs issued | 9,404 | 0.65 | 0.17 |
| PX local messages recv'd | 164 | 0.01 | 0.00 |
| PX local messages sent | 164 | 0.01 | 0.00 |
| PX remote messages recv'd | 386 | 0.03 | 0.01 |
| PX remote messages sent | 386 | 0.03 | 0.01 |
| Parallel operations not downgraded | 65 | 0.00 | 0.00 |
| Requests to/from client | 550,983 | 38.23 | 10.20 |
| RowCR - row contention | 1 | 0.00 | 0.00 |
| RowCR attempts | 449 | 0.03 | 0.01 |
| RowCR hits | 570 | 0.04 | 0.01 |
| SQL*Net roundtrips to/from client | 551,160 | 38.24 | 10.21 |
| active txn count during cleanout | 4,843 | 0.34 | 0.09 |
| application wait time | 441 | 0.03 | 0.01 |
| background checkpoints completed | 8 | 0.00 | 0.00 |
| background checkpoints started | 8 | 0.00 | 0.00 |
| background timeouts | 122,323 | 8.49 | 2.26 |
| branch node splits | 9 | 0.00 | 0.00 |
| buffer is not pinned count | 240,359 | 16.68 | 4.45 |
| buffer is pinned count | 1,845,867 | 128.07 | 34.18 |
| bytes received via SQL*Net from client | 122,677,036 | 8,511.57 | 2,271.50 |
| bytes sent via SQL*Net to client | 62,579,107 | 4,341.86 | 1,158.72 |
| calls to get snapshot scn: kcmgss | 260,025 | 18.04 | 4.81 |
| calls to kcmgas | 121,431 | 8.43 | 2.25 |
| calls to kcmgcs | 770,383 | 53.45 | 14.26 |
| cell physical IO interconnect bytes | 130,568,832,512 | 9,059,122.42 | 2,417,627.95 |
| change write time | 1,487 | 0.10 | 0.03 |
| cleanout - number of ktugct calls | 10,617 | 0.74 | 0.20 |
| cleanouts and rollbacks - consistent read gets | 881 | 0.06 | 0.02 |
| cleanouts only - consistent read gets | 1,931 | 0.13 | 0.04 |
| cluster key scan block gets | 33,984 | 2.36 | 0.63 |
| cluster key scans | 23,738 | 1.65 | 0.44 |
| cluster wait time | 4,971 | 0.34 | 0.09 |
| commit batch/immediate performed | 2,275 | 0.16 | 0.04 |
| commit batch/immediate requested | 2,275 | 0.16 | 0.04 |
| commit cleanout failures: block lost | 288 | 0.02 | 0.01 |
| commit cleanout failures: callback failure | 5,128 | 0.36 | 0.09 |
| commit cleanout failures: cannot pin | 566 | 0.04 | 0.01 |
| commit cleanouts | 225,433 | 15.64 | 4.17 |
| commit cleanouts successfully completed | 219,451 | 15.23 | 4.06 |
| commit immediate performed | 2,275 | 0.16 | 0.04 |
| commit immediate requested | 2,275 | 0.16 | 0.04 |
| commit txn count during cleanout | 27,809 | 1.93 | 0.51 |
| concurrency wait time | 289,966,611 | 20,118.45 | 5,369.06 |
| consistent changes | 3,453 | 0.24 | 0.06 |
| consistent gets | 34,725,767 | 2,409.34 | 642.99 |
| consistent gets - examination | 168,298 | 11.68 | 3.12 |
| consistent gets direct | 1,162,982 | 80.69 | 21.53 |
| consistent gets from cache | 33,562,785 | 2,328.65 | 621.45 |
| consistent gets from cache (fastpath) | 33,258,075 | 2,307.51 | 615.81 |
| cursor authentications | 477 | 0.03 | 0.01 |
| data blocks consistent reads - undo records applied | 2,749 | 0.19 | 0.05 |
| db block changes | 1,014,552 | 70.39 | 18.79 |
| db block gets | 2,311,584 | 160.38 | 42.80 |
| db block gets direct | 952,387 | 66.08 | 17.63 |
| db block gets from cache | 1,359,197 | 94.30 | 25.17 |
| db block gets from cache (fastpath) | 494,338 | 34.30 | 9.15 |
| deferred (CURRENT) block cleanout applications | 158,262 | 10.98 | 2.93 |
| dirty buffers inspected | 399 | 0.03 | 0.01 |
| enqueue conversions | 23,070 | 1.60 | 0.43 |
| enqueue releases | 1,178,508 | 81.77 | 21.82 |
| enqueue requests | 1,183,818 | 82.14 | 21.92 |
| enqueue timeouts | 5,245 | 0.36 | 0.10 |
| enqueue waits | 6,685 | 0.46 | 0.12 |
| exchange deadlocks | 18 | 0.00 | 0.00 |
| execute count | 328,479 | 22.79 | 6.08 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io wait time | 1,450,472,464 | 100,636.63 | 26,857.12 |
| free buffer inspected | 7,479,162 | 518.92 | 138.49 |
| free buffer requested | 10,722,413 | 743.94 | 198.54 |
| gc blocks compressed | 9,629 | 0.67 | 0.18 |
| gc cr block flush time | 9 | 0.00 | 0.00 |
| gc cr block receive time | 425 | 0.03 | 0.01 |
| gc cr blocks received | 9,773 | 0.68 | 0.18 |
| gc cr blocks served | 10,669 | 0.74 | 0.20 |
| gc current block flush time | 46 | 0.00 | 0.00 |
| gc current block pin time | 11 | 0.00 | 0.00 |
| gc current block receive time | 445 | 0.03 | 0.01 |
| gc current blocks received | 12,734 | 0.88 | 0.24 |
| gc current blocks served | 18,661 | 1.29 | 0.35 |
| gc kbytes saved | 42,559 | 2.95 | 0.79 |
| gc kbytes sent | 192,081 | 13.33 | 3.56 |
| gc local grants | 8,925,517 | 619.27 | 165.27 |
| gc read wait time | 14 | 0.00 | 0.00 |
| gc read waits | 24 | 0.00 | 0.00 |
| gc remote grants | 1,772,392 | 122.97 | 32.82 |
| gcs messages sent | 3,464,098 | 240.35 | 64.14 |
| ges messages sent | 3,528,347 | 244.80 | 65.33 |
| global enqueue get time | 252,318,804 | 17,506.37 | 4,671.96 |
| global enqueue gets async | 13,271 | 0.92 | 0.25 |
| global enqueue gets sync | 475,315 | 32.98 | 8.80 |
| global enqueue releases | 460,245 | 31.93 | 8.52 |
| heap block compress | 170 | 0.01 | 0.00 |
| hot buffers moved to head of LRU | 361 | 0.03 | 0.01 |
| immediate (CR) block cleanout applications | 2,812 | 0.20 | 0.05 |
| immediate (CURRENT) block cleanout applications | 7,028 | 0.49 | 0.13 |
| in call idle wait time | 59,683,245 | 4,140.94 | 1,105.10 |
| index crx upgrade (positioned) | 283 | 0.02 | 0.01 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 4,338 | 0.30 | 0.08 |
| index fetch by key | 67,591 | 4.69 | 1.25 |
| index scans kdiixs1 | 137,176 | 9.52 | 2.54 |
| leaf node 90-10 splits | 1,496 | 0.10 | 0.03 |
| leaf node splits | 2,267 | 0.16 | 0.04 |
| lob reads | 6 | 0.00 | 0.00 |
| lob writes | 75 | 0.01 | 0.00 |
| lob writes unaligned | 75 | 0.01 | 0.00 |
| logical read bytes from cache | 286,080,729,088 | 19,848,843.69 | 5,297,104.62 |
| logons cumulative | 4,936 | 0.34 | 0.09 |
| max cf enq hold time | 562 | 0.04 | 0.01 |
| messages received | 93,421 | 6.48 | 1.73 |
| messages sent | 93,421 | 6.48 | 1.73 |
| min active SCN optimization applied on CR | 948 | 0.07 | 0.02 |
| no work - consistent read gets | 33,806,188 | 2,345.54 | 625.96 |
| non-idle wait count | 8,292,338 | 575.34 | 153.54 |
| non-idle wait time | 290,145,214 | 20,130.85 | 5,372.36 |
| opened cursors cumulative | 249,265 | 17.29 | 4.62 |
| parse count (describe) | 14 | 0.00 | 0.00 |
| parse count (failures) | 3 | 0.00 | 0.00 |
| parse count (hard) | 11,595 | 0.80 | 0.21 |
| parse count (total) | 56,954 | 3.95 | 1.05 |
| parse time cpu | 2,079 | 0.14 | 0.04 |
| parse time elapsed | 2,836 | 0.20 | 0.05 |
| physical read IO requests | 123,689 | 8.58 | 2.29 |
| physical read bytes | 96,920,911,872 | 6,724,563.50 | 1,794,599.07 |
| physical read total IO requests | 170,921 | 11.86 | 3.16 |
| physical read total bytes | 105,763,948,032 | 7,338,110.75 | 1,958,337.77 |
| physical read total multi block requests | 100,387 | 6.97 | 1.86 |
| physical reads | 11,831,166 | 820.87 | 219.07 |
| physical reads cache | 10,668,112 | 740.17 | 197.53 |
| physical reads cache prefetch | 10,558,144 | 732.54 | 195.50 |
| physical reads direct | 1,163,054 | 80.69 | 21.54 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 7,690 | 0.53 | 0.14 |
| physical write IO requests | 51,636 | 3.58 | 0.96 |
| physical write bytes | 8,142,995,456 | 564,977.04 | 150,776.67 |
| physical write total IO requests | 130,573 | 9.06 | 2.42 |
| physical write total bytes | 24,804,884,480 | 1,721,011.68 | 459,290.17 |
| physical write total multi block requests | 48,547 | 3.37 | 0.90 |
| physical writes | 994,018 | 68.97 | 18.41 |
| physical writes direct | 952,459 | 66.08 | 17.64 |
| physical writes direct (lob) | 28 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 41,559 | 2.88 | 0.77 |
| physical writes non checkpoint | 987,882 | 68.54 | 18.29 |
| pinned buffers inspected | 19 | 0.00 | 0.00 |
| pinned cursors current | 8 | 0.00 | 0.00 |
| process last non-idle time | 15,131 | 1.05 | 0.28 |
| queries parallelized | 65 | 0.00 | 0.00 |
| recursive calls | 887,568 | 61.58 | 16.43 |
| recursive cpu usage | 143,920 | 9.99 | 2.66 |
| redo KB read | 7,986,391 | 554.11 | 147.88 |
| redo blocks checksummed by FG (exclusive) | 14,961,499 | 1,038.06 | 277.03 |
| redo blocks written | 16,230,165 | 1,126.08 | 300.52 |
| redo buffer allocation retries | 10 | 0.00 | 0.00 |
| redo entries | 1,519,064 | 105.40 | 28.13 |
| redo log space requests | 16 | 0.00 | 0.00 |
| redo log space wait time | 9 | 0.00 | 0.00 |
| redo ordering marks | 12,512 | 0.87 | 0.23 |
| redo size | 8,037,039,176 | 557,625.59 | 148,814.77 |
| redo size for direct writes | 7,836,617,536 | 543,719.94 | 145,103.74 |
| redo subscn max counts | 1,709 | 0.12 | 0.03 |
| redo synch long waits | 27 | 0.00 | 0.00 |
| redo synch time | 2,183 | 0.15 | 0.04 |
| redo synch time (usec) | 24,297,970 | 1,685.84 | 449.90 |
| redo synch writes | 36,745 | 2.55 | 0.68 |
| redo wastage | 12,500,752 | 867.33 | 231.47 |
| redo write broadcast ack count | 26,411 | 1.83 | 0.49 |
| redo write broadcast ack time | 11,977,023 | 830.99 | 221.77 |
| redo write broadcast lgwr post count | 3 | 0.00 | 0.00 |
| redo write time | 4,631 | 0.32 | 0.09 |
| redo writes | 53,526 | 3.71 | 0.99 |
| remote Oradebug requests | 7 | 0.00 | 0.00 |
| rollback changes - undo records applied | 146 | 0.01 | 0.00 |
| rollbacks only - consistent read gets | 309 | 0.02 | 0.01 |
| rows fetched via callback | 8,711 | 0.60 | 0.16 |
| session connect time | 17 | 0.00 | 0.00 |
| session cursor cache hits | 259,850 | 18.03 | 4.81 |
| session logical reads | 37,037,356 | 2,569.72 | 685.79 |
| shared hash latch upgrades - no wait | 20,917 | 1.45 | 0.39 |
| shared hash latch upgrades - wait | 26 | 0.00 | 0.00 |
| sorts (memory) | 38,602 | 2.68 | 0.71 |
| sorts (rows) | 37,049,506 | 2,570.57 | 686.01 |
| sql area evicted | 1,306 | 0.09 | 0.02 |
| sql area purged | 199 | 0.01 | 0.00 |
| summed dirty queue length | 390 | 0.03 | 0.01 |
| switch current to new buffer | 3,571 | 0.25 | 0.07 |
| table fetch by rowid | 966,391 | 67.05 | 17.89 |
| table fetch continued row | 151 | 0.01 | 0.00 |
| table scan blocks gotten | 22,344,295 | 1,550.29 | 413.73 |
| table scan rows gotten | 1,454,645,103 | 100,926.14 | 26,934.38 |
| table scans (direct read) | 15 | 0.00 | 0.00 |
| table scans (long tables) | 40 | 0.00 | 0.00 |
| table scans (short tables) | 57,443 | 3.99 | 1.06 |
| temp space allocated (bytes) | 1,048,576 | 72.75 | 19.42 |
| total cf enq hold time | 1,497 | 0.10 | 0.03 |
| total number of cf enq holders | 121 | 0.01 | 0.00 |
| total number of times SMON posted | 88 | 0.01 | 0.00 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction lock foreground wait time | 0 | 0.00 | 0.00 |
| transaction rollbacks | 92 | 0.01 | 0.00 |
| undo change vector size | 65,428,848 | 4,539.58 | 1,211.49 |
| user I/O wait time | 151,205 | 10.49 | 2.80 |
| user calls | 734,546 | 50.96 | 13.60 |
| user commits | 30,222 | 2.10 | 0.56 |
| user rollbacks | 23,785 | 1.65 | 0.44 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 9,331 | 0.65 | 0.17 |
| write clones created in background | 48 | 0.00 | 0.00 |
| write clones created in foreground | 5 | 0.00 | 0.00 |
| Statistic | Begin Value | End Value |
|---|---|---|
| session pga memory max | 775,541,872 | 1,269,221,104 |
| session cursor cache count | 12,051 | 46,073 |
| session uga memory | 519,755,007,408 | 807,792,462,640 |
| opened cursors current | 83 | 208 |
| logons current | 80 | 179 |
| session uga memory max | 1,132,539,800 | 3,029,907,512 |
| session pga memory | 715,624,912 | 1,178,861,328 |
| Statistic | Total | per Hour |
|---|---|---|
| log switches (derived) | 8 | 2.00 |
| Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Buffer Cache Reads | 81.4G | 7.92 | 5.78264 | 0M | 0.00 | 0M | 110K | 12.60 |
| Others | 8.3G | 3.27 | .588983 | 8.3G | 1.41 | .587873 | 44.6K | 0.16 |
| Direct Writes | 3.9G | 0.28 | .274405 | 6.3G | 1.82 | .447513 | 0 | |
| LGWR | 2M | 0.01 | .000138 | 7.7G | 4.21 | .549990 | 53.7K | 0.56 |
| Direct Reads | 5G | 0.38 | .352044 | 479M | 0.14 | .033233 | 0 | |
| DBWR | 0M | 0.00 | 0M | 325M | 1.48 | .022549 | 0 | |
| TOTAL: | 98.5G | 11.86 | 6.99821 | 23.1G | 9.06 | 1.64116 | 208.2K | 6.83 |
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|---|---|---|---|---|---|---|---|
| Data File | 90.3G | 8.58 | 6.41318 | 7.6G | 3.58 | .538889 | 4.34 | 15.96 |
| Log File | 7.6G | 0.54 | .541109 | 7.7G | 4.19 | .549782 | 0.71 | 16.52 |
| Archive Log | 0M | 0.00 | 0M | 7.6G | 0.54 | .541109 | ||
| Control File | 634M | 2.73 | .043988 | 166M | 0.74 | .011517 | 0.14 | 19.11 |
| TOTAL: | 98.5G | 11.86 | 6.99828 | 23.1G | 9.06 | 1.64129 | 1.99 | 16.01 |
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Buffer Cache Reads | 81.4G | 7.92 | 5.78264 | 0M | 0.00 | 0M | 109.9K | 12.60 |
| Buffer Cache Reads (Data File) | 81.4G | 7.92 | 5.78264 | 0M | 0.00 | 0M | 109.9K | 12.60 |
| Direct Writes | 3.9G | 0.28 | .274405 | 6.3G | 1.82 | .447513 | 0 | |
| Direct Writes (Data File) | 3.9G | 0.28 | .274405 | 6.3G | 1.82 | .447513 | 0 | |
| LGWR | 0M | 0.00 | 0M | 7.7G | 4.19 | .549852 | 32 | 0.22 |
| LGWR (Log File) | 0M | 0.00 | 0M | 7.7G | 4.19 | .549852 | 32 | 0.22 |
| Direct Reads | 5G | 0.38 | .352044 | 479M | 0.14 | .033233 | 0 | |
| Direct Reads (Data File) | 5G | 0.38 | .352044 | 479M | 0.14 | .033233 | 0 | |
| Others | 690M | 2.73 | .047873 | 674M | 0.87 | .046763 | 39.3K | 0.15 |
| Others (Control File) | 632M | 2.73 | .043849 | 163M | 0.73 | .011309 | 39.3K | 0.15 |
| Others (Data File) | 58M | 0.01 | .004024 | 511M | 0.15 | .035454 | 20 | 5.30 |
| DBWR | 0M | 0.00 | 0M | 325M | 1.48 | .022549 | 0 | |
| DBWR (Data File) | 0M | 0.00 | 0M | 325M | 1.48 | .022549 | 0 | |
| TOTAL: | 90.9G | 11.31 | 6.45696 | 15.5G | 8.50 | 1.09991 | 149.2K | 9.32 |
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|
| RPT | 93,247 | 6 | 13.70 | 110.29 | 32,880 | 2 | 235 | 0.89 |
| USER_DATA | 21,474 | 1 | 6.14 | 71.43 | 10,733 | 1 | 193 | 4.87 |
| SYSAUX | 6,926 | 0 | 1.78 | 1.00 | 3,591 | 0 | 0 | 0.00 |
| SYSTEM | 769 | 0 | 6.46 | 1.00 | 973 | 0 | 1,222 | 1.14 |
| UNDOTBS2 | 3 | 0 | 0.00 | 1.00 | 1,554 | 0 | 134 | 0.00 |
| CFG | 636 | 0 | 8.02 | 2.61 | 636 | 0 | 5 | 6.00 |
| BNMS_DATA01 | 402 | 0 | 7.39 | 1.37 | 596 | 0 | 30 | 6.33 |
| USER_DATA_INX | 90 | 0 | 7.89 | 1.11 | 333 | 0 | 0 | 0.00 |
| RPT_INX | 51 | 0 | 8.24 | 1.39 | 328 | 0 | 0 | 0.00 |
| CFG_INX | 100 | 0 | 4.70 | 26.43 | 3 | 0 | 68 | 8.68 |
| BNMS_IDX_01 | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| UNDOTBS1 | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 57 | 0.18 |
| USERS | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|---|
| BNMS_DATA01 | +DG_BILLDB_DATA/billdb/bnms_data01_1.dbf | 166 | 0 | 7.89 | 1.11 | 259 | 0 | 20 | 4.50 |
| BNMS_DATA01 | +DG_BILLDB_DATA/billdb/bnms_data01_2.dbf | 236 | 0 | 7.03 | 1.56 | 337 | 0 | 10 | 10.00 |
| BNMS_IDX_01 | +DG_BILLDB_DATA/billdb/bnms_idx_01_1.dbf | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| CFG | +DG_BILLDB_DATA/billdb/cfg01.dbf | 636 | 0 | 8.02 | 2.61 | 636 | 0 | 5 | 6.00 |
| CFG_INX | +DG_BILLDB_DATA/billdb/cfg_inx01.dbf | 100 | 0 | 4.70 | 26.43 | 3 | 0 | 68 | 8.68 |
| RPT | +DG_BILLDB_DATA/billdb/rpt01.dbf | 23,268 | 2 | 13.59 | 110.72 | 8,855 | 1 | 59 | 0.68 |
| RPT | +DG_BILLDB_DATA/billdb/rpt02.dbf | 23,587 | 2 | 13.78 | 104.05 | 6,952 | 0 | 60 | 1.33 |
| RPT | +DG_BILLDB_DATA/billdb/rpt03.dbf | 22,945 | 2 | 14.28 | 110.69 | 8,648 | 1 | 56 | 0.18 |
| RPT | +DG_BILLDB_DATA/billdb/rpt04.dbf | 23,447 | 2 | 13.18 | 115.77 | 8,425 | 1 | 60 | 1.33 |
| RPT_INX | +DG_BILLDB_DATA/billdb/rpt_inx01.dbf | 51 | 0 | 8.24 | 1.39 | 328 | 0 | 0 | 0.00 |
| SYSAUX | +DG_BILLDB_DATA/billdb/sysaux01.dbf | 6,926 | 0 | 1.78 | 1.00 | 3,591 | 0 | 0 | 0.00 |
| SYSTEM | +DG_BILLDB_DATA/billdb/system01.dbf | 769 | 0 | 6.46 | 1.00 | 973 | 0 | 1,222 | 1.14 |
| UNDOTBS1 | +DG_BILLDB_DATA/billdb/undotbs01.dbf | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 57 | 0.18 |
| UNDOTBS2 | +DG_BILLDB_DATA/billdb/undotbs02.dbf | 3 | 0 | 0.00 | 1.00 | 1,554 | 0 | 134 | 0.00 |
| USERS | +DG_BILLDB_DATA/billdb/users01.dbf | 3 | 0 | 0.00 | 1.00 | 3 | 0 | 0 | 0.00 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data01.dbf | 2,565 | 0 | 5.90 | 76.54 | 1,232 | 0 | 14 | 5.00 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data02.dbf | 2,712 | 0 | 6.50 | 78.10 | 1,332 | 0 | 15 | 4.00 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data03.dbf | 3,238 | 0 | 7.28 | 68.34 | 1,521 | 0 | 30 | 7.33 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data04.dbf | 2,704 | 0 | 5.67 | 63.85 | 1,405 | 0 | 37 | 5.41 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data05.dbf | 2,688 | 0 | 6.34 | 70.73 | 1,210 | 0 | 48 | 3.33 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data06.dbf | 2,613 | 0 | 5.66 | 71.51 | 1,304 | 0 | 5 | 10.00 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data07.dbf | 2,504 | 0 | 5.78 | 67.81 | 1,606 | 0 | 28 | 2.86 |
| USER_DATA | +DG_BILLDB_DATA/billdb/user_data08.dbf | 2,450 | 0 | 5.66 | 75.51 | 1,123 | 0 | 16 | 6.25 |
| USER_DATA_INX | +DG_BILLDB_DATA/billdb/user_data_inx01.dbf | 90 | 0 | 7.89 | 1.11 | 333 | 0 | 0 | 0.00 |
| P | Number of Buffers | Pool Hit% | Buffer Gets | Physical Reads | Physical Writes | Free Buff Wait | Writ Comp Wait | Buffer Busy Waits |
|---|---|---|---|---|---|---|---|---|
| D | 2,396,520 | 69 | 34,921,179 | 10,668,130 | 41,559 | 0 | 0 | 1,944 |
| MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
|---|---|---|---|---|---|
| 0 | 4,930 | 0 | 0 | 33,794 | 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 | 0 | 429 | 2239 | 1220 | 5096034 | 1220 | 0 | ||
| E | 0 | 0 | 938 | 31672 | 96068 | 5096034 | 96068 | 0 |
| 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,984 | 0.10 | 234 | 1.00 | 10,780 | 1 | 1643.00 |
| D | 3,968 | 0.20 | 469 | 1.00 | 10,758 | 1 | 1557.00 |
| D | 5,952 | 0.29 | 703 | 1.00 | 10,746 | 1 | 1508.00 |
| D | 7,936 | 0.39 | 937 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 9,920 | 0.49 | 1,172 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 11,904 | 0.59 | 1,406 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 13,888 | 0.68 | 1,641 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 15,872 | 0.78 | 1,875 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 17,856 | 0.88 | 2,109 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 19,840 | 0.98 | 2,344 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 20,288 | 1.00 | 2,397 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 21,824 | 1.08 | 2,578 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 23,808 | 1.17 | 2,812 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 25,792 | 1.27 | 3,047 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 27,776 | 1.37 | 3,281 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 29,760 | 1.47 | 3,515 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 31,744 | 1.56 | 3,750 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 33,728 | 1.66 | 3,984 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 35,712 | 1.76 | 4,218 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 37,696 | 1.86 | 4,453 | 1.00 | 10,746 | 1 | 1507.00 |
| D | 39,680 | 1.96 | 4,687 | 1.00 | 10,746 | 1 | 1507.00 |
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|---|---|
| 100.00 | 2,704 | 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 | 7,768 | 6,737 | 334.44 | 0.00 | 0.00 | 0.00 | 0.00 | 795,440 |
| E | 7,768 | 6,532 | 607.01 | 0.00 | 0.00 | 0.00 | 0.00 | 795,440 |
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|---|---|---|---|---|
| 2K | 4K | 8,596 | 8,596 | 0 | 0 |
| 64K | 128K | 77 | 77 | 0 | 0 |
| 128K | 256K | 2 | 2 | 0 | 0 |
| 256K | 512K | 11 | 11 | 0 | 0 |
| 512K | 1024K | 481 | 481 | 0 | 0 |
| 1M | 2M | 86 | 86 | 0 | 0 |
| 2M | 4M | 12 | 12 | 0 | 0 |
| 4M | 8M | 8 | 8 | 0 | 0 |
| 16M | 32M | 16 | 16 | 0 | 0 |
| 32M | 64M | 42 | 42 | 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 |
|---|---|---|---|---|---|---|
| 971 | 0.13 | 4,025.31 | 507.97 | 89.00 | 1 | 1,513,757 |
| 1,942 | 0.25 | 4,025.31 | 507.97 | 89.00 | 1 | 1,513,757 |
| 3,884 | 0.50 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 5,826 | 0.75 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 7,768 | 1.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 9,322 | 1.20 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 10,875 | 1.40 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 12,429 | 1.60 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 13,982 | 1.80 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 15,536 | 2.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 23,304 | 3.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 31,072 | 4.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 46,608 | 6.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 62,144 | 8.00 | 4,025.31 | 503.75 | 89.00 | 0 | 1,512,349 |
| 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,816 | 1.00 | 236 | 20,468 | 4,772 | 1.00 | 53 | 1.00 | 488 |
| 2,880 | 1.02 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 2,944 | 1.05 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,008 | 1.07 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,072 | 1.09 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,136 | 1.11 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,200 | 1.14 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,264 | 1.16 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,328 | 1.18 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,392 | 1.20 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,456 | 1.23 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 3,776 | 1.34 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 4,096 | 1.45 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 4,416 | 1.57 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 4,736 | 1.68 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 5,056 | 1.80 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 5,376 | 1.91 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| 5,696 | 2.02 | 283 | 22,963 | 4,773 | 1.00 | 52 | 0.98 | 488 |
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|---|---|---|
| 5,840 | 0.25 | 2,916,789 | 10,779,981 |
| 8,760 | 0.38 | 2,916,497 | 10,745,595 |
| 11,680 | 0.50 | 2,916,497 | 10,745,595 |
| 14,600 | 0.63 | 2,916,497 | 10,745,595 |
| 17,520 | 0.75 | 2,916,497 | 10,745,595 |
| 20,440 | 0.88 | 2,916,497 | 10,745,595 |
| 23,360 | 1.00 | 2,916,425 | 10,745,595 |
| 26,280 | 1.13 | 2,916,497 | 10,745,595 |
| 29,200 | 1.25 | 2,916,497 | 10,745,595 |
| 32,120 | 1.38 | 2,916,497 | 10,745,595 |
| 35,040 | 1.50 | 2,916,497 | 10,745,595 |
| 37,960 | 1.63 | 2,916,497 | 10,745,595 |
| 40,880 | 1.75 | 2,916,497 | 10,745,595 |
| 43,800 | 1.88 | 2,916,497 | 10,745,595 |
| 46,720 | 2.00 | 2,916,519 | 10,745,595 |
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|---|---|---|
| data block | 1,391 | 3 | 2 |
| file header block | 231 | 0 | 1 |
| segment header | 82 | 0 | 2 |
| 2nd level bmb | 20 | 0 | 7 |
| 1st level bmb | 29 | 0 | 4 |
| undo header | 118 | 0 | 0 |
| undo block | 73 | 0 | 0 |
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|---|---|---|---|---|---|
| CO-KTUCLO Master Slave enq (master slave det) | 4,798 | 0 | 4,798 | 4,798 | 9 | 1.81 |
| RO-Multiple Object Reuse (fast object reuse) | 940 | 940 | 0 | 293 | 4 | 13.28 |
| JQ-Job Queue | 243 | 110 | 133 | 211 | 1 | 3.77 |
| WF-AWR Flush | 84 | 84 | 0 | 75 | 1 | 8.24 |
| TM-DML | 89,203 | 88,944 | 259 | 261 | 0 | 1.84 |
| PS-PX Process Reservation | 495 | 495 | 0 | 248 | 0 | 1.56 |
| FB-Format Block | 482 | 482 | 0 | 175 | 0 | 1.55 |
| TX-Transaction (index contention) | 30 | 30 | 0 | 28 | 0 | 6.93 |
| CF-Controlfile Transaction | 29,736 | 29,736 | 0 | 87 | 0 | 2.06 |
| CR-Reuse Block Range (block range reuse ckpt) | 682 | 682 | 0 | 88 | 0 | 1.47 |
| HW-Segment High Water Mark | 3,463 | 3,463 | 0 | 73 | 0 | 1.70 |
| KO-Multiple Object Checkpoint (fast object checkpoint) | 198 | 198 | 0 | 74 | 0 | 0.64 |
| TS-Temporary Segment | 197 | 184 | 13 | 71 | 0 | 0.54 |
| TD-KTF map table enqueue (KTF dump entries) | 30 | 30 | 0 | 27 | 0 | 1.00 |
| TX-Transaction (allocate ITL entry) | 4 | 4 | 0 | 4 | 0 | 6.75 |
| MD-Materialized View Log DDL | 87 | 87 | 0 | 50 | 0 | 0.38 |
| TA-Instance Undo | 51 | 51 | 0 | 43 | 0 | 0.44 |
| SQ-Sequence Cache | 3,051 | 3,051 | 0 | 29 | 0 | 0.55 |
| JS-Job Scheduler (job run lock - synchronize) | 10 | 10 | 0 | 10 | 0 | 1.40 |
| DR-Distributed Recovery | 8 | 8 | 0 | 8 | 0 | 0.75 |
| WL-Being Written Redo Log | 8 | 8 | 0 | 8 | 0 | 0.75 |
| AF-Advisor Framework (task serialization) | 28 | 28 | 0 | 4 | 0 | 1.25 |
| MW-MWIN Schedule | 8 | 8 | 0 | 8 | 0 | 0.50 |
| UL-User-defined | 13 | 13 | 0 | 4 | 0 | 0.75 |
| DL-Direct Loader Index Creation | 6 | 6 | 0 | 3 | 0 | 0.33 |
| TX-Transaction (row lock contention) | 4 | 4 | 0 | 4 | 0 | 0.00 |
| TQ-Queue table enqueue (DDL contention) | 2 | 2 | 0 | 1 | 0 | 0.00 |
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 5 | 10.42 | 50,152 | 1,295 | 7 | 33618.9/303458.1 | 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 |
|---|---|---|---|---|---|---|---|
| 10-Sep 18:59 | 461 | 4,837 | 925 | 5 | 33,619 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 18:49 | 412 | 4,454 | 322 | 7 | 34,217 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 18:39 | 358 | 3,580 | 925 | 6 | 34,700 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 18:29 | 386 | 2,856 | 319 | 3 | 35,025 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 18:19 | 827 | 5,894 | 1,295 | 4 | 35,482 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 18:09 | 518 | 2,355 | 687 | 3 | 37,842 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:59 | 1,853 | 8,400 | 911 | 5 | 39,252 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:49 | 2,637 | 10,963 | 302 | 5 | 49,620 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:39 | 839 | 3,137 | 902 | 5 | 84,544 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:29 | 287 | 343 | 294 | 3 | 107,882 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:19 | 197 | 217 | 894 | 3 | 117,085 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 17:09 | 360 | 423 | 288 | 3 | 123,475 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:59 | 207 | 315 | 888 | 3 | 143,055 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:49 | 211 | 390 | 283 | 3 | 155,851 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:39 | 198 | 257 | 887 | 3 | 172,988 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:29 | 95 | 172 | 283 | 2 | 194,947 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:19 | 197 | 300 | 884 | 2 | 203,496 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 16:09 | 142 | 278 | 281 | 3 | 238,200 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:59 | 110 | 227 | 884 | 3 | 271,116 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:49 | 6 | 184 | 281 | 1 | 303,458 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:39 | 1 | 152 | 887 | 1 | 291,755 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:29 | 4 | 135 | 285 | 1 | 277,581 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:19 | 0 | 2 | 0 | 0 | 264,650 | 0/0 | 0/0/0/0/0/0 |
| 10-Sep 15:09 | 114 | 281 | 291 | 3 | 249,969 | 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 | 4 | 0.00 | 0 | 0 | ||
| ASM Keyed state latch | 9,209 | 0.02 | 0.00 | 0 | 0 | |
| ASM allocation | 325 | 0.00 | 0 | 0 | ||
| ASM db client latch | 10,148 | 0.00 | 0 | 0 | ||
| ASM map headers | 119 | 0.00 | 0 | 0 | ||
| ASM map load waiting list | 39 | 0.00 | 0 | 0 | ||
| ASM map operation freelist | 4,063 | 0.12 | 0.00 | 0 | 0 | |
| ASM map operation hash table | 795,543 | 0.00 | 0.00 | 0 | 0 | |
| ASM network background latch | 6,034 | 0.00 | 0 | 0 | ||
| ASM network state latch | 509 | 0.00 | 0 | 0 | ||
| AWR Alerted Metric Element list | 172,536 | 0.00 | 0 | 0 | ||
| Change Notification Hash table latch | 4,885 | 0.00 | 0 | 0 | ||
| Consistent RBA | 53,531 | 0.00 | 0.00 | 0 | 0 | |
| DML lock allocation | 178,482 | 0.00 | 0 | 0 | ||
| Event Group Locks | 9,603 | 0.00 | 0 | 0 | ||
| FAL Queue | 401 | 0.00 | 0 | 0 | ||
| FIB s.o chain latch | 48 | 0.00 | 0 | 0 | ||
| FOB s.o list latch | 12,711 | 0.19 | 0.00 | 0 | 0 | |
| File State Object Pool Parent Latch | 4 | 0.00 | 0 | 0 | ||
| I/O Staticstics latch | 4 | 0.00 | 0 | 0 | ||
| IPC other latch | 120 | 0.00 | 0 | 0 | ||
| IPC stats buffer allocation latch | 14,368 | 0.00 | 0 | 14,665 | 0.00 | |
| In memory undo latch | 4 | 0.00 | 0 | 0 | ||
| JS Sh mem access | 30 | 0.00 | 0 | 0 | ||
| JS broadcast add buf latch | 22,150 | 0.00 | 0 | 0 | ||
| JS broadcast drop buf latch | 22,154 | 0.00 | 0 | 0 | ||
| JS broadcast load blnc latch | 21,739 | 0.00 | 0 | 0 | ||
| JS mem alloc latch | 24 | 0.00 | 0 | 2 | 0.00 | |
| JS queue access latch | 28 | 0.00 | 0 | 0 | ||
| JS queue state obj latch | 913,224 | 0.00 | 0 | 0 | ||
| JS slv state obj latch | 956 | 0.00 | 0 | 0 | ||
| KFC FX Hash Latch | 4 | 0.00 | 0 | 0 | ||
| KFC Hash Latch | 4 | 0.00 | 0 | 0 | ||
| KFCL LE Freelist | 4 | 0.00 | 0 | 0 | ||
| KFK SGA Libload latch | 9,082 | 0.00 | 0 | 0 | ||
| KFMD SGA | 67 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SHM structure | 4 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SVR LIST | 4 | 0.00 | 0 | 0 | ||
| KJC destination ctx free list | 0 | 0 | 2 | 0.00 | ||
| KJC message pool free list | 114,984 | 0.02 | 0.04 | 0 | 30,635 | 0.00 |
| KJC receiver ctx free list | 0 | 0 | 2 | 0.00 | ||
| KJCT flow control latch | 11,935,393 | 0.00 | 0.00 | 0 | 0 | |
| KMG MMAN ready and startup request latch | 4,804 | 0.00 | 0 | 0 | ||
| KTF sga latch | 107 | 0.00 | 0 | 4,152 | 0.00 | |
| KWQMN job cache list latch | 1,031 | 0.00 | 0 | 0 | ||
| KWQS pqsubs latch | 16 | 0.00 | 0 | 0 | ||
| KWQS pqueue ctx latch | 60 | 0.00 | 0 | 0 | ||
| Locator state objects pool parent latch | 4 | 0.00 | 0 | 0 | ||
| Lsod array latch | 61,042 | 0.38 | 0.00 | 0 | 0 | |
| MQL Tracking Latch | 0 | 0 | 286 | 0.00 | ||
| Memory Management Latch | 4 | 0.00 | 0 | 4,804 | 0.00 | |
| Memory Queue | 4 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #1 | 4 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #2 | 4 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #3 | 4 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #4 | 4 | 0.00 | 0 | 0 | ||
| Memory Queue Subscriber | 4 | 0.00 | 0 | 0 | ||
| MinActiveScn Latch | 5,118 | 0.00 | 0 | 0 | ||
| Mutex | 4 | 0.00 | 0 | 0 | ||
| Mutex Stats | 4 | 0.00 | 0 | 0 | ||
| OS process | 21,379 | 0.00 | 0 | 0 | ||
| OS process allocation | 40,360 | 0.14 | 0.02 | 0 | 0 | |
| OS process: request allocation | 9,210 | 0.38 | 0.00 | 0 | 0 | |
| PL/SQL warning settings | 7,519 | 0.00 | 0 | 0 | ||
| PX hash array latch | 4 | 0.00 | 0 | 0 | ||
| QMT | 4 | 0.00 | 0 | 0 | ||
| Real-time plan statistics latch | 4,485 | 0.00 | 0 | 4 | 0.00 | |
| SGA IO buffer pool latch | 35 | 0.00 | 0 | 35 | 0.00 | |
| SGA blob parent | 4 | 0.00 | 0 | 0 | ||
| SGA bucket locks | 4 | 0.00 | 0 | 0 | ||
| SGA heap locks | 4 | 0.00 | 0 | 0 | ||
| SGA pool locks | 4 | 0.00 | 0 | 0 | ||
| SQL memory manager latch | 4 | 0.00 | 0 | 4,798 | 0.00 | |
| SQL memory manager workarea list latch | 429,258 | 0.00 | 0 | 0 | ||
| Shared B-Tree | 685 | 0.00 | 0 | 0 | ||
| Streams Generic | 4 | 0.00 | 0 | 0 | ||
| Testing | 4 | 0.00 | 0 | 0 | ||
| Token Manager | 4 | 0.00 | 0 | 0 | ||
| WCR: sync | 4 | 0.00 | 0 | 0 | ||
| Write State Object Pool Parent Latch | 4 | 0.00 | 0 | 0 | ||
| X$KSFQP | 4 | 0.00 | 0 | 0 | ||
| XDB NFS Security Latch | 4 | 0.00 | 0 | 0 | ||
| XDB unused session pool | 4 | 0.00 | 0 | 0 | ||
| XDB used session pool | 4 | 0.00 | 0 | 0 | ||
| active checkpoint queue latch | 30,804 | 0.12 | 0.00 | 0 | 2 | 0.00 |
| active service list | 606,334 | 0.01 | 0.10 | 0 | 8,250 | 0.00 |
| alert log latch | 16 | 0.00 | 0 | 2 | 0.00 | |
| archive control | 265 | 0.00 | 0 | 0 | ||
| archive process latch | 1,211 | 0.08 | 1.00 | 0 | 0 | |
| begin backup scn array | 30,269 | 0.00 | 0 | 0 | ||
| buffer pool | 4 | 0.00 | 0 | 0 | ||
| business card | 134 | 0.00 | 0 | 0 | ||
| cache buffer handles | 9,067 | 0.02 | 0.00 | 0 | 0 | |
| cache buffers chains | 96,072,798 | 0.02 | 0.01 | 0 | 28,774,001 | 0.14 |
| cache buffers lru chain | 1,427,843 | 0.01 | 0.01 | 0 | 29,707,377 | 0.00 |
| cache table scan latch | 86,278 | 0.00 | 0 | 86,278 | 0.00 | |
| call allocation | 26,155 | 0.56 | 0.60 | 0 | 2 | 0.00 |
| cas latch | 4 | 0.00 | 0 | 0 | ||
| change notification client cache latch | 4 | 0.00 | 0 | 0 | ||
| channel handle pool latch | 9,482 | 0.25 | 0.00 | 0 | 0 | |
| channel operations parent latch | 3,751,561 | 0.00 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 1,988,645 | 0.00 | 0.00 | 0 | 48,299 | 0.00 |
| client/application info | 22,627 | 0.00 | 0 | 0 | ||
| compile environment latch | 4,944 | 0.00 | 0 | 0 | ||
| corrupted undo seg latch | 530 | 0.00 | 0 | 0 | ||
| cp cmon/server latch | 4 | 0.00 | 0 | 0 | ||
| cp pool latch | 4 | 0.00 | 0 | 0 | ||
| cp server hash latch | 4 | 0.00 | 0 | 0 | ||
| cp sga latch | 235 | 0.00 | 0 | 0 | ||
| cvmap freelist lock | 4 | 0.00 | 0 | 0 | ||
| deferred cleanup latch | 235 | 0.00 | 0 | 0 | ||
| dml lock allocation | 313 | 0.00 | 0 | 0 | ||
| done queue latch | 4 | 0.00 | 0 | 0 | ||
| dummy allocation | 9,792 | 0.06 | 0.00 | 0 | 0 | |
| enqueue freelist latch | 4 | 0.00 | 0 | 2,073,332 | 0.00 | |
| enqueue hash chains | 2,601,279 | 0.01 | 0.02 | 0 | 23 | 0.00 |
| enqueues | 10,784 | 0.00 | 0 | 0 | ||
| error message lists | 277 | 0.00 | 0 | 0 | ||
| fifth spare latch | 4 | 0.00 | 0 | 0 | ||
| file cache latch | 9,531 | 0.01 | 0.00 | 0 | 0 | |
| flashback copy | 4 | 0.00 | 0 | 0 | ||
| fourth Audit Vault latch | 4 | 0.00 | 0 | 0 | ||
| gc element | 12,103,422 | 0.35 | 0.24 | 0 | 10,324 | 0.00 |
| gc persistent rm | 3 | 0.00 | 0 | 0 | ||
| gcs commit scn state | 4 | 0.00 | 0 | 0 | ||
| gcs opaque info freelist | 46,854 | 0.01 | 0.00 | 0 | 0 | |
| gcs partitioned table hash | 68,379,696 | 1.43 | 0.00 | 0 | 7,265,081 | 0.00 |
| gcs pcm hashed value bucket hash | 4 | 0.00 | 0 | 0 | ||
| gcs remaster request queue | 98 | 2.04 | 0.50 | 0 | 0 | |
| gcs remastering latch | 11,829,087 | 2.43 | 0.00 | 0 | 147 | 6.80 |
| gcs resource freelist | 5,053,182 | 0.02 | 0.00 | 0 | 2,254,298 | 0.01 |
| gcs resource hash | 46,166,979 | 0.03 | 0.00 | 0 | 13 | 0.00 |
| gcs resource scan list | 33 | 0.00 | 0 | 0 | ||
| gcs shadows freelist | 656,582 | 0.00 | 0 | 658,318 | 0.00 | |
| ges DFS wait callback info | 6 | 0.00 | 0 | 1 | 0.00 | |
| ges caches resource lists | 304,465 | 3.41 | 0.00 | 0 | 749,277,308 | 0.00 |
| ges deadlock list | 9,415 | 0.00 | 0 | 159,430 | 0.00 | |
| ges domain table | 517,338,729 | 0.00 | 0.00 | 0 | 0 | |
| ges enqueue table freelist | 927,676 | 0.00 | 0.00 | 0 | 0 | |
| ges group table | 905,449 | 0.00 | 0.00 | 0 | 0 | |
| ges process hash list | 167,270 | 0.00 | 0.00 | 0 | 0 | |
| ges process parent latch | 2,038,368 | 0.00 | 0.00 | 0 | 10 | 0.00 |
| ges process table freelist | 9,210 | 0.40 | 0.00 | 0 | 0 | |
| ges resource hash list | 1,554,646,317 | 0.00 | 0.67 | 24 | 111,168 | 0.39 |
| ges resource scan list | 7,403 | 0.16 | 0.00 | 0 | 0 | |
| ges resource table freelist | 7,109 | 0.00 | 0 | 24 | 0.00 | |
| ges timeout list | 6,366 | 0.30 | 0.00 | 0 | 37,551 | 0.00 |
| ges value block free list | 2,245 | 0.00 | 0 | 0 | ||
| global KZLD latch for mem in SGA | 4,040 | 0.00 | 0 | 0 | ||
| global tx hash mapping | 4 | 0.00 | 0 | 0 | ||
| granule operation | 4 | 0.00 | 0 | 0 | ||
| hash table column usage latch | 657 | 0.15 | 0.00 | 0 | 290,294 | 0.02 |
| hash table modification latch | 475 | 0.42 | 0.00 | 0 | 2 | 0.00 |
| heartbeat check | 4 | 0.00 | 0 | 4,081 | 0.00 | |
| heartbeat structure management | 2 | 0.00 | 0 | 2,884 | 0.00 | |
| internal temp table object number allocation latch | 12 | 0.00 | 0 | 0 | ||
| interrupt manipulation | 1,434 | 0.00 | 0 | 0 | ||
| intra txn parallel recovery | 4 | 0.00 | 0 | 0 | ||
| io pool granule metadata list | 4 | 0.00 | 0 | 0 | ||
| job workq parent latch | 257 | 0.00 | 0 | 253 | 0.40 | |
| job_queue_processes free list latch | 526 | 0.00 | 0 | 2 | 0.00 | |
| job_queue_processes parameter latch | 22,036 | 0.00 | 0 | 0 | ||
| k2q global data latch | 9,610 | 0.00 | 0 | 0 | ||
| k2q lock allocation | 4 | 0.00 | 0 | 0 | ||
| kcbtsemkid latch | 8 | 0.00 | 0 | 0 | ||
| kdlx hb parent latch | 4 | 0.00 | 0 | 0 | ||
| kgb parent | 4 | 0.00 | 0 | 0 | ||
| kgnfs mount latch | 4 | 0.00 | 0 | 0 | ||
| kokc descriptor allocation latch | 324 | 0.00 | 0 | 0 | ||
| ksfv messages | 4 | 0.00 | 0 | 0 | ||
| ksim group membership cache | 2,512 | 0.00 | 0 | 0 | ||
| ksim membership request latch | 0 | 0 | 9,116 | 0.00 | ||
| kss move lock | 252 | 0.00 | 0 | 0 | ||
| ksuosstats global area | 1,453 | 0.00 | 0 | 0 | ||
| ksv allocation latch | 730 | 0.00 | 0 | 0 | ||
| ksv class latch | 27,855 | 0.01 | 0.00 | 0 | 2 | 0.00 |
| ksv instance latch | 20 | 0.00 | 0 | 0 | ||
| ksv msg queue latch | 19 | 0.00 | 0 | 15 | 0.00 | |
| ksxp shared latch | 9,210 | 0.29 | 0.00 | 0 | 0 | |
| ksxp so latch | 9,210 | 0.05 | 0.00 | 0 | 0 | |
| ksz_so allocation latch | 9,210 | 0.51 | 0.00 | 0 | 0 | |
| ktm global data | 469 | 0.00 | 0 | 0 | ||
| kwqbsn:qsga | 501 | 0.00 | 0 | 0 | ||
| lgwr LWN SCN | 55,546 | 0.07 | 0.00 | 0 | 0 | |
| list of block allocation | 8,962 | 0.01 | 0.00 | 0 | 0 | |
| loader state object freelist | 348 | 0.00 | 0 | 0 | ||
| lob segment dispenser latch | 4 | 0.00 | 0 | 0 | ||
| lob segment hash table latch | 52 | 0.00 | 0 | 0 | ||
| lob segment query latch | 4 | 0.00 | 0 | 0 | ||
| lock DBA buffer during media recovery | 4 | 0.00 | 0 | 0 | ||
| logical standby cache | 4 | 0.00 | 0 | 0 | ||
| logminer context allocation | 4 | 0.00 | 0 | 0 | ||
| logminer work area | 4 | 0.00 | 0 | 0 | ||
| longop free list parent | 44 | 0.00 | 0 | 40 | 0.00 | |
| managed standby latch | 393 | 0.00 | 0 | 0 | ||
| mapped buffers lru chain | 4 | 0.00 | 0 | 0 | ||
| message pool operations parent latch | 21,248 | 0.00 | 0 | 0 | ||
| messages | 887,886 | 0.04 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 55,820 | 0.54 | 0.00 | 0 | 0 | |
| msg queue latch | 4 | 0.00 | 0 | 0 | ||
| multiblock read objects | 189,778 | 0.00 | 0.00 | 0 | 2 | 0.00 |
| name-service memory objects | 8,874 | 0.00 | 0 | 4 | 0.00 | |
| name-service namespace bucket | 506,784,837 | 0.00 | 0 | 0 | ||
| name-service namespace objects | 16 | 0.00 | 0 | 2 | 0.00 | |
| name-service pending queue | 5,894 | 0.00 | 0 | 0 | ||
| name-service request | 48 | 0.00 | 0 | 0 | ||
| name-service request queue | 137,184 | 0.00 | 0 | 0 | ||
| ncodef allocation latch | 235 | 0.00 | 0 | 0 | ||
| object queue header heap | 183,892 | 0.00 | 0.00 | 0 | 2,398 | 0.13 |
| object queue header operation | 21,041,619 | 0.00 | 0.70 | 1 | 0 | |
| object stats modification | 2,442 | 0.00 | 0 | 0 | ||
| parallel query alloc buffer | 3,924 | 0.00 | 0 | 0 | ||
| parallel query stats | 368 | 0.00 | 0 | 0 | ||
| parallel txn reco latch | 3,621 | 0.00 | 0 | 0 | ||
| parameter list | 39,413 | 0.00 | 0 | 0 | ||
| parameter table management | 25,240 | 0.00 | 1.00 | 0 | 0 | |
| peshm | 4 | 0.00 | 0 | 0 | ||
| pesom_free_list | 4 | 0.00 | 0 | 0 | ||
| pesom_hash_node | 4 | 0.00 | 0 | 0 | ||
| post/wait queue | 745,964,012 | 0.00 | 0.05 | 0 | 745,915,257 | 0.00 |
| process allocation | 75,027 | 0.09 | 0.16 | 0 | 4,652 | 0.06 |
| process group creation | 9,210 | 0.10 | 0.00 | 0 | 0 | |
| process queue | 975 | 0.00 | 0 | 0 | ||
| process queue reference | 16,149 | 0.00 | 0 | 1,481 | 0.07 | |
| qmn state object latch | 7 | 0.00 | 0 | 0 | ||
| qmn task queue latch | 2,064 | 0.00 | 0 | 0 | ||
| query server freelists | 765 | 0.00 | 0 | 0 | ||
| query server process | 57 | 0.00 | 0 | 8 | 0.00 | |
| queued dump request | 59 | 0.00 | 0 | 0 | ||
| queuing load statistics | 4 | 0.00 | 0 | 0 | ||
| recovery domain hash list | 4 | 0.00 | 0 | 0 | ||
| redo allocation | 165,478 | 0.68 | 0.02 | 0 | 1,518,944 | 0.04 |
| redo copy | 4 | 0.00 | 0 | 1,519,182 | 0.18 | |
| redo writing | 201,146 | 0.01 | 0.09 | 0 | 0 | |
| resmgr group change latch | 3,114 | 0.00 | 0 | 0 | ||
| resmgr:active threads | 9,792 | 0.00 | 0 | 0 | ||
| resmgr:actses change group | 3,084 | 0.00 | 0 | 0 | ||
| resmgr:actses change state | 4 | 0.00 | 0 | 0 | ||
| resmgr:free threads list | 9,788 | 0.12 | 0.00 | 0 | 0 | |
| resmgr:plan CPU method | 4 | 0.00 | 0 | 0 | ||
| resmgr:resource group CPU method | 4 | 0.00 | 0 | 0 | ||
| resmgr:schema config | 4 | 0.00 | 0 | 0 | ||
| resmgr:session queuing | 4 | 0.00 | 0 | 0 | ||
| rm cas latch | 4 | 0.00 | 0 | 0 | ||
| row cache objects | 2,234,932 | 0.14 | 0.00 | 0 | 683 | 0.29 |
| rules engine aggregate statistics | 8 | 0.00 | 0 | 0 | ||
| rules engine evaluation context statistics | 0 | 0 | 2 | 0.00 | ||
| rules engine rule set statistics | 16 | 0.00 | 0 | 0 | ||
| second Audit Vault latch | 4 | 0.00 | 0 | 0 | ||
| second spare latch | 4 | 0.00 | 0 | 0 | ||
| segmented array pool | 32 | 0.00 | 0 | 0 | ||
| sequence cache | 199,672 | 0.01 | 0.00 | 0 | 0 | |
| session allocation | 225,897 | 0.00 | 0.00 | 0 | 216,461 | 0.00 |
| session idle bit | 1,680,536 | 0.00 | 0.00 | 0 | 0 | |
| session queue latch | 4 | 0.00 | 0 | 0 | ||
| session state list latch | 8,696 | 0.00 | 0 | 0 | ||
| session switching | 4,793 | 0.81 | 0.00 | 0 | 2 | 0.00 |
| session timer | 4,806 | 0.00 | 0 | 0 | ||
| shared pool | 994,421 | 0.16 | 0.02 | 0 | 394 | 0.00 |
| shared pool sim alloc | 952 | 0.00 | 0 | 0 | ||
| shared pool simulator | 23,901 | 0.00 | 0 | 0 | ||
| shared server configuration | 1 | 0.00 | 0 | 1 | 0.00 | |
| sim partition latch | 4 | 0.00 | 0 | 0 | ||
| simulator hash latch | 5,916,612 | 0.00 | 0 | 0 | ||
| simulator lru latch | 4 | 0.00 | 0 | 3,882,926 | 0.02 | |
| sort extent pool | 692 | 0.00 | 0 | 0 | ||
| space background state object latch | 67 | 0.00 | 0 | 0 | ||
| space background task latch | 24,447 | 0.46 | 0.02 | 0 | 9,684 | 0.00 |
| state object free list | 8 | 0.00 | 0 | 0 | ||
| statistics aggregation | 3,360 | 0.00 | 0 | 0 | ||
| tablespace key chain | 57 | 0.00 | 0 | 0 | ||
| temp lob duration state obj allocation | 8 | 0.00 | 0 | 0 | ||
| temporary table state object allocation | 55 | 0.00 | 0 | 0 | ||
| test excl. parent l0 | 4 | 0.00 | 0 | 0 | ||
| test excl. parent2 l0 | 4 | 0.00 | 0 | 0 | ||
| third spare latch | 4 | 0.00 | 0 | 0 | ||
| threshold alerts latch | 949 | 0.00 | 0 | 0 | ||
| trace latch | 479 | 0.00 | 0 | 0 | ||
| transaction allocation | 11,513 | 0.00 | 0 | 0 | ||
| undo global data | 191,830 | 0.00 | 0.00 | 0 | 0 | |
| virtual circuit buffers | 4 | 0.00 | 0 | 0 | ||
| virtual circuit holder | 4 | 0.00 | 0 | 0 | ||
| virtual circuit queues | 4 | 0.00 | 0 | 0 |
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
|---|---|---|---|---|
| gcs remastering latch | 11,829,087 | 287,090 | 3 | 287,087 |
| gc element | 12,103,422 | 42,751 | 10,390 | 32,628 |
| cache buffers chains | 96,072,798 | 14,873 | 191 | 14,683 |
| gcs resource hash | 46,166,979 | 11,695 | 27 | 11,668 |
| ges caches resource lists | 304,465 | 10,387 | 17 | 10,370 |
| ges resource hash list | 1,554,646,317 | 7,163 | 4,785 | 3,480 |
| row cache objects | 2,234,932 | 3,173 | 4 | 3,169 |
| shared pool | 994,421 | 1,560 | 29 | 1,531 |
| gcs resource freelist | 5,053,182 | 1,117 | 4 | 1,113 |
| redo allocation | 165,478 | 1,117 | 21 | 1,096 |
| object queue header operation | 21,041,619 | 634 | 442 | 243 |
| mostly latch-free SCN | 55,820 | 303 | 1 | 302 |
| KJCT flow control latch | 11,935,393 | 243 | 1 | 242 |
| enqueue hash chains | 2,601,279 | 167 | 4 | 163 |
| cache buffers lru chain | 1,427,843 | 165 | 1 | 164 |
| call allocation | 26,155 | 147 | 88 | 64 |
| space background task latch | 24,447 | 113 | 2 | 111 |
| post/wait queue | 745,964,012 | 84 | 4 | 81 |
| process allocation | 75,027 | 69 | 11 | 58 |
| active service list | 606,334 | 59 | 6 | 53 |
| OS process allocation | 40,360 | 56 | 1 | 55 |
| KJC message pool free list | 114,984 | 25 | 1 | 24 |
| redo writing | 201,146 | 11 | 1 | 10 |
| gcs remaster request queue | 98 | 2 | 1 | 1 |
| archive process latch | 1,211 | 1 | 1 | 0 |
| parameter table management | 25,240 | 1 | 1 | 0 |
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|---|---|---|---|
| KJC message pool free list | kjcspfmbq: free vector of msg buffers | 0 | 1 | 0 |
| KJCT flow control latch | kjctr_updatetkt: update ticket info | 0 | 1 | 0 |
| OS process allocation | kso_delete_process:1 | 0 | 1 | 1 |
| active service list | kswslogon: session logout | 0 | 18 | 17 |
| archive process latch | kcrrsarc | 0 | 1 | 1 |
| cache buffers chains | kcbgcur_2 | 0 | 69 | 56 |
| cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 59 | 16 |
| cache buffers chains | kcbgtcr: fast path | 0 | 39 | 4 |
| cache buffers chains | kcbchg1: mod cr pin | 0 | 20 | 14 |
| cache buffers chains | kcbzwb | 0 | 7 | 4 |
| cache buffers chains | kcbchg1: clear MS bit | 0 | 6 | 55 |
| cache buffers chains | kcbgtcr_2 | 0 | 6 | 13 |
| cache buffers chains | kclbla | 0 | 5 | 0 |
| cache buffers chains | kcbbxsv | 0 | 4 | 5 |
| cache buffers chains | kcbAdoptBuffers_vhl | 0 | 3 | 3 |
| cache buffers chains | kcbgcur_4 | 0 | 3 | 3 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 3 | 9 |
| cache buffers chains | kcbget: pin buffer | 0 | 2 | 2 |
| cache buffers chains | kclcqchk | 0 | 2 | 0 |
| cache buffers chains | kcbnlc | 0 | 1 | 7 |
| cache buffers chains | kclcqchk_1 | 0 | 1 | 12 |
| cache buffers chains | kcllkopesc | 0 | 1 | 0 |
| cache buffers chains | kclwrt | 0 | 1 | 0 |
| cache buffers lru chain | kcbzgm | 0 | 1 | 0 |
| call allocation | ksuxds | 0 | 86 | 84 |
| call allocation | ksudlc : rec call | 0 | 1 | 1 |
| call allocation | ksudlp: top call | 0 | 1 | 1 |
| enqueue hash chains | ksqcmi: if lk mode requested | 0 | 2 | 0 |
| enqueue hash chains | ksqgtl3 | 0 | 2 | 3 |
| gc element | kclplz | 0 | 10,947 | 32 |
| gc element | kclulb | 0 | 152 | 11,161 |
| gc element | kclollnumiter_4 | 0 | 82 | 0 |
| gc element | kclplz_1 | 0 | 60 | 12 |
| gc element | kclnfndnewm | 0 | 39 | 48 |
| gc element | kclbla | 0 | 26 | 0 |
| gc element | kclclose_1 | 0 | 22 | 0 |
| gc element | kclchkping | 0 | 6 | 1 |
| gc element | kclcqchk | 0 | 2 | 10 |
| gc element | kclrlstp | 0 | 2 | 0 |
| gc element | kcl_fairness | 0 | 1 | 0 |
| gc element | kclfwrite1 | 0 | 1 | 2 |
| gc element | kclwrt | 0 | 1 | 0 |
| gcs remaster request queue | kjdrchkdrm | 0 | 1 | 0 |
| gcs remastering latch | kjfcdrmrfg beginning | 0 | 3 | 0 |
| gcs resource freelist | kjbralc add resource | 0 | 3 | 1 |
| gcs resource freelist | kjbrfr_bg2 | 0 | 1 | 3 |
| gcs resource hash | kjbcropen | 0 | 8 | 1 |
| gcs resource hash | kjblocalobj_nolock | 0 | 8 | 0 |
| gcs resource hash | kjbrdrmcvtq_98 | 0 | 5 | 4 |
| gcs resource hash | kjbassume | 0 | 3 | 0 |
| gcs resource hash | kjbclose | 0 | 3 | 18 |
| ges resource hash list | kjrmas1: lookup master node | 0 | 1,267 | 19 |
| ges resource hash list | kjddopr: validate resource | 0 | 1,091 | 6 |
| ges resource hash list | kjakoca: search for resp by resname | 0 | 719 | 2,909 |
| ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 617 | 2 |
| ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 538 | 792 |
| ges resource hash list | kjcvscn: remove from scan queue | 0 | 302 | 0 |
| ges resource hash list | kjucvl: lock convert request | 0 | 67 | 285 |
| ges resource hash list | kjakcai: search for resp by resname | 0 | 46 | 6 |
| ges resource hash list | kjrddgpop: set dd state | 0 | 42 | 41 |
| ges resource hash list | kjddopt: check grouplock | 0 | 41 | 24 |
| ges resource hash list | kjrref: find matched resource | 0 | 24 | 665 |
| ges resource hash list | kjddgmak | 0 | 18 | 70 |
| ges resource hash list | kjddmr: send mesg to remote node | 0 | 12 | 1 |
| ges resource hash list | kjddscn: scan deadlock queue | 0 | 1 | 0 |
| ges resource table freelist | kjchc: clean resource cache | 0 | 17 | 0 |
| lgwr LWN SCN | kcs023 | 0 | 1 | 0 |
| object queue header operation | kclobj_2 | 0 | 226 | 118 |
| object queue header operation | kclobj_5 | 0 | 180 | 31 |
| object queue header operation | kclobj_1 | 0 | 23 | 2 |
| object queue header operation | kcbo_service_ockpt | 0 | 8 | 0 |
| object queue header operation | kcbo_write_q | 0 | 2 | 0 |
| object queue header operation | kclbufs | 0 | 2 | 5 |
| object queue header operation | kcbo_unlink_q | 0 | 1 | 256 |
| parameter table management | kspcpy | 0 | 1 | 0 |
| post/wait queue | kslpstevent:get | 0 | 3 | 4 |
| post/wait queue | ksliwat:add:nowait | 0 | 1 | 0 |
| process allocation | ksufap: active procs | 0 | 9 | 1 |
| process allocation | ksucrp:1 | 0 | 1 | 0 |
| process allocation | ksudlp | 0 | 1 | 6 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 21 | 0 |
| redo writing | kcrfwcr | 0 | 1 | 1 |
| row cache objects | ksucallcbksafely: kqrhngc | 0 | 2 | 0 |
| row cache objects | kqrigt | 0 | 1 | 0 |
| row cache objects | kqrpre: find obj | 0 | 1 | 2 |
| shared pool | kghalo | 0 | 26 | 11 |
| shared pool | kghalp | 0 | 2 | 10 |
| shared pool | kghupr1 | 0 | 1 | 7 |
| space background task latch | ktsj_grab_task | 0 | 2 | 2 |
| Mutex Type | Location | Sleeps | Wait Time (ms) |
|---|---|---|---|
| Cursor Pin | kkslce [KKSCHLPIN2] | 1,543 | 0 |
| Library Cache | kgllkdl1 85 | 361 | 0 |
| Library Cache | kgllkal1 80 | 335 | 0 |
| Library Cache | kglhdgn2 106 | 297 | 0 |
| Library Cache | kglllal3 111 | 260 | 0 |
| Library Cache | kglhdgn1 62 | 108 | 0 |
| Library Cache | kgllldl2 112 | 92 | 0 |
| Library Cache | kgllkc1 57 | 34 | 0 |
| Library Cache | kglpnal2 91 | 33 | 0 |
| Library Cache | kglpndl1 95 | 26 | 0 |
| Library Cache | kglpin1 4 | 19 | 0 |
| Library Cache | kglpnal1 90 | 17 | 0 |
| Library Cache | kglget2 2 | 12 | 0 |
| Library Cache | kglini1 32 | 4 | 0 |
| Library Cache | kglnti1 46 | 4 | 0 |
| Library Cache | kglhdgh1 64 | 3 | 0 |
| Library Cache | kglivl2 35 | 3 | 0 |
| Library Cache | kglUpgradeLock 119 | 2 | 0 |
| Library Cache | kglhbh1 63 | 2 | 0 |
| Library Cache | kgllkal3 82 | 2 | 0 |
| Library Cache | kglget1 1 | 1 | 0 |
| Library Cache | kglobld1 75 | 1 | 0 |
| Cursor Parent | kkscsAddChildNode [KKSPRTLOC34] | 1 | 0 |
| Cursor Pin | kksfbc [KKSCHLFSP2] | 1 | 0 |
| Cursor Pin | kksfbc [KKSCHLPIN1] | 1 | 0 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
|---|---|---|---|---|---|---|
| OCSA11 | CFG_INX | H1H2H3H4_PK | INDEX | 11,677,360 | 31.53 | |
| OCSB22 | RPT | DD_OCS_BALANCE_PAYOUT_B2_STD | TABLE | 5,285,456 | 14.27 | |
| OCSA12 | RPT | DD_OCS_BALANCE_PAYOUT_A2_STD | TABLE | 4,244,496 | 11.46 | |
| OCSB21 | RPT | DD_OCS_BALANCE_PAYOUT_B1_STD | TABLE | 2,612,624 | 7.05 | |
| OCSA11 | RPT | DD_OCS_BALANCE_PAYOUT_A1_STD | TABLE | 2,051,072 | 5.54 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
|---|---|---|---|---|---|---|
| OCSB22 | RPT | DD_OCS_BALANCE_PAYOUT_B2_STD | TABLE | 5,283,353 | 44.66 | |
| OCSB21 | RPT | DD_OCS_BALANCE_PAYOUT_B1_STD | TABLE | 1,962,952 | 16.59 | |
| OCSA12 | RPT | DD_OCS_BALANCE_PAYOUT_A2_STD | TABLE | 1,061,200 | 8.97 | |
| OCSA12 | RPT | TMP_BALANCE_PAYOUT_A | TABLE | 1,061,180 | 8.97 | |
| OCSA11 | RPT | DD_OCS_BALANCE_PAYOUT_A1_STD | TABLE | 512,738 | 4.33 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
|---|---|---|---|---|---|---|
| OCSB22 | RPT | DD_OCS_BALANCE_PAYOUT_B2_STD | TABLE | 43,272 | 34.98 | |
| OCSB21 | RPT | DD_OCS_BALANCE_PAYOUT_B1_STD | TABLE | 23,738 | 19.19 | |
| OCSA12 | RPT | DD_OCS_BALANCE_PAYOUT_A2_STD | TABLE | 9,483 | 7.67 | |
| OCSA12 | RPT | TMP_BALANCE_PAYOUT_A | TABLE | 9,481 | 7.67 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1725412641_7476 | TABLE PARTITION | 6,265 | 5.07 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
|---|---|---|---|---|---|---|
| OCSB22 | RPT | DD_OCS_BALANCE_PAYOUT_B2_STD | TABLE | 43,272 | 34.98 | |
| OCSB21 | RPT | DD_OCS_BALANCE_PAYOUT_B1_STD | TABLE | 23,738 | 19.19 | |
| OCSA12 | RPT | DD_OCS_BALANCE_PAYOUT_A2_STD | TABLE | 9,483 | 7.67 | |
| OCSA12 | RPT | TMP_BALANCE_PAYOUT_A | TABLE | 9,481 | 7.67 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1725412641_7476 | TABLE PARTITION | 6,265 | 5.07 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
|---|---|---|---|---|---|---|
| OCSA12 | USER_DATA | TRANS_LOG | TABLE | 171,903 | 14.78 | |
| OCSB22 | USER_DATA | TRANS_LOG | TABLE | 152,226 | 13.09 | |
| OCSA12 | USER_DATA | PAYMENT | TABLE | 125,993 | 10.83 | |
| OCSB21 | USER_DATA | TRANS_LOG | TABLE | 125,738 | 10.81 | |
| OCSA12 | USER_DATA | ACCT_ITEM | TABLE | 119,919 | 10.31 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
|---|---|---|---|---|---|---|
| OCSA12 | RPT | DD_OCS_TRANS_LOG_A2_STD | TABLE | 171,522 | 17.26 | |
| OCSB22 | RPT | DD_OCS_TRANS_LOG_B2_STD | TABLE | 152,222 | 15.31 | |
| OCSA12 | RPT | DD_OCS_PAYMENT_A2_STD | TABLE | 126,972 | 12.77 | |
| OCSB21 | RPT | DD_OCS_TRANS_LOG_B1_STD | TABLE | 126,065 | 12.68 | |
| OCSB22 | RPT | DD_OCS_PAYMENT_B2_STD | TABLE | 106,244 | 10.69 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
|---|---|---|---|---|---|---|
| OCSA12 | RPT | DD_OCS_TRANS_LOG_A2_STD | TABLE | 5,590 | 10.83 | |
| OCSB22 | RPT | DD_OCS_TRANS_LOG_B2_STD | TABLE | 4,966 | 9.62 | |
| OCSA12 | RPT | DD_OCS_PAYMENT_A2_STD | TABLE | 4,179 | 8.09 | |
| OCSB21 | RPT | DD_OCS_TRANS_LOG_B1_STD | TABLE | 4,154 | 8.04 | |
| OCSB22 | RPT | DD_OCS_PAYMENT_B2_STD | TABLE | 3,513 | 6.80 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
|---|---|---|---|---|---|---|
| OCSA12 | RPT | DD_OCS_TRANS_LOG_A2_STD | TABLE | 170,860 | 17.94 | |
| OCSB22 | RPT | DD_OCS_TRANS_LOG_B2_STD | TABLE | 151,583 | 15.91 | |
| OCSA12 | RPT | DD_OCS_PAYMENT_A2_STD | TABLE | 126,367 | 13.27 | |
| OCSB21 | RPT | DD_OCS_TRANS_LOG_B1_STD | TABLE | 125,463 | 13.17 | |
| OCSB22 | RPT | DD_OCS_PAYMENT_B2_STD | TABLE | 105,715 | 11.10 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
|---|---|---|---|---|---|---|
| OCSA11 | CFG_INX | H1H2H3H4_PK | INDEX | 4,322 | 98.72 | |
| SYS | SYSTEM | I_OBJ2 | INDEX | 5 | 0.11 | |
| OCSA11 | RPT | DD_OCS_BALANCE_PAYOUT_A1_STD | TABLE | 4 | 0.09 | |
| OCSA12 | RPT | DD_OCS_BALANCE_PAYOUT_A2_STD | TABLE | 4 | 0.09 | |
| OCSB21 | RPT | DD_OCS_BALANCE_PAYOUT_B1_STD | TABLE | 4 | 0.09 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | AUD$ | TABLE | 64,544 | 16.14 | |
| SYS | SYSTEM | USER$ | TABLE | 14,864 | 3.72 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_1725412641_7476 | INDEX PARTITION | 14,768 | 3.69 |
| OCSA12 | USER_DATA | SERV_PRODUCT | TABLE | 11,296 | 2.82 | |
| OCSA12 | USER_DATA | PK_SERV_PRODUCT | INDEX | 11,040 | 2.76 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
|---|---|---|---|---|---|---|
| OMC30 | BNMS_DATA01 | IDX4_BSS_LOG201308011 | INDEX | 6 | 18.75 | |
| SYS | SYSTEM | I_COBJ# | INDEX | 4 | 12.50 | |
| SYS | SYSTEM | I_COL3 | INDEX | 4 | 12.50 | |
| OCSA12 | USER_DATA | PK_SERV_PRODUCT | INDEX | 3 | 9.38 | |
| OMC30 | BNMS_DATA01 | IDX2_T_OCS_REPORT | INDEX | 2 | 6.25 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | TAB$ | TABLE | 4 | 100.00 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | SEG$ | TABLE | 465 | 56.30 | |
| SYS | SYSTEM | AUD$ | TABLE | 146 | 17.68 | |
| SYS | SYSTEM | I_COL3 | INDEX | 42 | 5.08 | |
| SYS | SYSTEM | I_COL1 | INDEX | 39 | 4.72 | |
| SYS | SYSTEM | I_CON2 | INDEX | 23 | 2.78 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | AUD$ | TABLE | 224 | 46.28 | |
| SYS | SYSTEM | SEG$ | TABLE | 175 | 36.16 | |
| OCSA11 | USER_DATA | BSS_PRICING_COMBINE | TABLE | 15 | 3.10 | |
| SYS | SYSTEM | TAB$ | TABLE | 7 | 1.45 | |
| OCSA11 | USER_DATA | PK_PRODUCT_OFFER_INSTANCE | INDEX | 6 | 1.24 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
|---|---|---|---|---|---|---|
| OCSA11 | USER_DATA | BSS_PRICING_COMBINE | TABLE | 4,655 | 47.63 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_1725412641_7476 | INDEX PARTITION | 2,012 | 20.59 |
| SYS | SYSTEM | JOB$ | TABLE | 422 | 4.32 | |
| SYS | SYSTEM | SEQ$ | TABLE | 353 | 3.61 | |
| SYS | SYSTEM | AUD$ | TABLE | 261 | 2.67 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | AUD$ | TABLE | 2,685 | 21.09 | |
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY_PK | WRH$_ACTIVE_1725412641_7476 | INDEX PARTITION | 2,294 | 18.01 |
| OCSA11 | USER_DATA | BSS_PRICING_COMBINE | TABLE | 2,054 | 16.13 | |
| SYS | SYSTEM | SEQ$ | TABLE | 442 | 3.47 | |
| OCSA11 | RPT | T_OCS_REPORT_A_DAYBAK | TABLE | 427 | 3.35 |
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|---|---|---|---|---|---|
| dc_awr_control | 330 | 2.42 | 0 | 0 | 1 | |
| dc_constraints | 790 | 77.85 | 0 | 790 | 317 | |
| dc_files | 24 | 0.00 | 0 | 0 | 24 | |
| dc_global_oids | 882 | 0.23 | 0 | 0 | 51 | |
| dc_histogram_data | 45,351 | 1.14 | 0 | 0 | 3,044 | |
| dc_histogram_defs | 98,419 | 2.09 | 0 | 0 | 3,071 | |
| dc_object_grants | 95 | 14.74 | 0 | 0 | 48 | |
| dc_objects | 63,617 | 1.54 | 0 | 392 | 2,494 | |
| dc_profiles | 4,117 | 0.00 | 0 | 0 | 1 | |
| dc_rollback_segments | 8,965 | 0.00 | 0 | 0 | 73 | |
| dc_segments | 44,214 | 0.98 | 0 | 2,871 | 799 | |
| dc_sequences | 3,022 | 14.82 | 0 | 3,022 | 6 | |
| dc_table_scns | 43 | 100.00 | 0 | 0 | 0 | |
| dc_tablespaces | 117,437 | 0.00 | 0 | 0 | 14 | |
| dc_users | 417,188 | 0.02 | 0 | 0 | 195 | |
| global database name | 16,039 | 0.00 | 0 | 0 | 1 | |
| outstanding_alerts | 311 | 87.14 | 0 | 8 | 15 | |
| sch_lj_oids | 22 | 9.09 | 0 | 0 | 6 |
| Cache | GES Requests | GES Conflicts | GES Releases |
|---|---|---|---|
| dc_awr_control | 8 | 8 | 0 |
| dc_constraints | 1,272 | 8 | 0 |
| dc_global_oids | 2 | 0 | 11 |
| dc_histogram_defs | 2,056 | 0 | 2,864 |
| dc_objects | 1,306 | 19 | 383 |
| dc_segments | 5,892 | 49 | 628 |
| dc_sequences | 6,044 | 443 | 0 |
| dc_table_scns | 43 | 0 | 0 |
| dc_users | 97 | 0 | 3 |
| outstanding_alerts | 551 | 266 | 0 |
| sch_lj_oids | 2 | 0 | 0 |
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|---|---|---|---|---|---|
| ACCOUNT_STATUS | 9,405 | 0.01 | 0 | 0 | 0 | |
| BODY | 9,759 | 0.08 | 13,980 | 0.09 | 0 | 0 |
| CLUSTER | 275 | 0.36 | 275 | 0.36 | 0 | 0 |
| DBLINK | 8,092 | 0.00 | 0 | 0 | 0 | |
| EDITION | 2,868 | 0.00 | 5,648 | 0.00 | 0 | 0 |
| INDEX | 40 | 20.00 | 48 | 20.83 | 0 | 0 |
| OBJECT ID | 56 | 100.00 | 0 | 0 | 0 | |
| QUEUE | 48 | 0.00 | 423 | 0.00 | 0 | 0 |
| RULESET | 0 | 8 | 0.00 | 0 | 0 | |
| SCHEMA | 4,917 | 0.02 | 0 | 0 | 0 | |
| SQL AREA | 54,642 | 19.60 | 396,872 | 8.21 | 4 | 502 |
| SQL AREA BUILD | 10,933 | 96.70 | 0 | 0 | 0 | |
| SQL AREA STATS | 10,941 | 99.96 | 10,941 | 99.96 | 0 | 0 |
| SUBSCRIPTION | 12 | 0.00 | 12 | 0.00 | 0 | 0 |
| TABLE/PROCEDURE | 19,666 | 2.97 | 263,390 | 0.56 | 63 | 0 |
| TRIGGER | 3,160 | 0.44 | 3,197 | 0.44 | 0 | 0 |
| Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
|---|---|---|---|---|---|
| ACCOUNT_STATUS | 9,405 | 0 | 0 | 0 | 0 |
| BODY | 0 | 13,860 | 13,860 | 0 | 0 |
| CLUSTER | 275 | 275 | 275 | 0 | 0 |
| DBLINK | 8,092 | 0 | 0 | 0 | 0 |
| EDITION | 2,868 | 2,876 | 2,876 | 0 | 0 |
| INDEX | 40 | 40 | 40 | 0 | 0 |
| QUEUE | 0 | 423 | 423 | 0 | 0 |
| RULESET | 0 | 8 | 8 | 0 | 0 |
| SCHEMA | 4,160 | 0 | 0 | 0 | 0 |
| SUBSCRIPTION | 0 | 12 | 12 | 0 | 0 |
| TABLE/PROCEDURE | 50,529 | 198,530 | 198,530 | 0 | 0 |
| TRIGGER | 0 | 3,197 | 3,197 | 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 | 20,288.00 | 20,288.00 | 20,288.00 | 20,288.00 | 0 | INI/IMM |
| KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| PGA Target | 7,808.00 | 7,808.00 | 7,808.00 | 7,808.00 | 0 | STA/ |
| RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| SGA Target | 23,360.00 | 23,360.00 | 23,360.00 | 23,360.00 | 0 | STA/ |
| Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| java pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
| large pool | 64.00 | 64.00 | 64.00 | 64.00 | 0 | STA/ |
| shared pool | 2,816.00 | 2,816.00 | 2,496.00 | 2,816.00 | 0 | GRO/IMM |
| streams pool | 0.00 | 0.00 | 0.00 | 0.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 | 310.75 | 3.74 | 5.29 | 28 | 28 | 83 | 83 | |
B | Freeable | 22.25 | 0.00 | 1.39 | 2.37 | 10 | 16 | 16 | |
B | SQL | 0.94 | 0.44 | 0.02 | 0.03 | 0 | 9 | 49 | 41 |
B | PL/SQL | 0.55 | 0.36 | 0.01 | 0.02 | 0 | 1 | 81 | 80 |
| E | Other | 561.72 | 3.09 | 6.22 | 44 | 44 | 182 | 182 | |
E | Freeable | 41.44 | 0.00 | 0.88 | 1.59 | 10 | 47 | 47 | |
E | SQL | 1.96 | 0.69 | 0.02 | 0.02 | 0 | 9 | 117 | 107 |
E | PL/SQL | 0.92 | 0.53 | 0.01 | 0.01 | 0 | 0 | 180 | 179 |
| SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
|---|---|---|
| Database Buffers | 21,273,509,888 | |
| Fixed Size | 2,232,712 | |
| Redo Buffers | 22,618,112 | |
| Variable Size | 3,087,011,448 |
| Pool | Name | Begin MB | End MB | % Diff |
|---|---|---|---|---|
| java | free memory | 64.00 | 64.00 | 0.00 |
| large | PX msg pool | 7.81 | 7.81 | 0.00 |
| large | free memory | 55.81 | 55.81 | 0.00 |
| shared | FileOpenBlock | 60.80 | 60.80 | 0.00 |
| shared | KGLH0 | 154.89 | ||
| shared | SQLA | 36.68 | 166.07 | 352.71 |
| shared | db_block_hash_buckets | 178.00 | 178.00 | 0.00 |
| shared | dbktb: trace buffer | 78.13 | 78.13 | 0.00 |
| shared | event statistics per sess | 93.91 | 93.91 | 0.00 |
| shared | free memory | 669.54 | 383.36 | -42.74 |
| shared | gc name table | 48.00 | 48.00 | 0.00 |
| shared | gcs resources | 539.35 | 539.35 | 0.00 |
| shared | gcs shadows | 314.62 | 314.62 | 0.00 |
| shared | ges big msg buffers | 60.79 | 60.79 | 0.00 |
| shared | ges enqueues | 96.44 | 96.44 | 0.00 |
| shared | ges resource | 47.27 | 47.27 | 0.00 |
| shared | ksunfy : SSO free list | 87.54 | 87.54 | 0.00 |
| buffer_cache | 20,288.00 | 20,288.00 | 0.00 | |
| fixed_sga | 2.13 | 2.13 | 0.00 | |
| log_buffer | 21.57 | 21.57 | 0.00 |
| Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
|---|---|---|---|---|---|
| 0 | 0 | 1 | 0 | 1 | 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 |
| Total Server Time (s) | %Busy | %Idle | Incoming Net % | Outgoing Net % |
|---|---|---|---|---|
| 14,413 | 0.00 | 100.00 | 0.00 | 0.00 |
| Name | Avg Conns | Total Disp Time (s) | %Busy | %Idle | Total Queued | Total Queue Wait (s) | Avg Queue Wait (ms) |
|---|---|---|---|---|---|---|---|
| D000 | 0.00 | 14,413 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 14,413 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 14,413 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 14,413 | 0.00 | 100.00 | 0 | 0 | |
| Sum | 0.00 | 0 | 0 | ||||
| Avg | 0.00 | 0.00 | 100.00 | 0 | 0 | ||
| Std | 0.00 | 0.00 | 0.00 | 0 | 0 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| audit_file_dest | /u01/app/oracle/admin/billdb/adump | |
| audit_trail | DB | |
| cluster_database | TRUE | |
| compatible | 11.2.0.0.0 | |
| control_files | +DG_BILLDB_DATA/billdb/control01.ctl, +DG_BILLDB_DATA/billdb/control02.ctl | |
| db_block_size | 8192 | |
| db_domain | ||
| db_files | 2000 | |
| db_name | billdb | |
| diagnostic_dest | /u01/app/oracle | |
| dispatchers | (PROTOCOL=TCP) (SERVICE=billdbXDB) | |
| instance_number | 2 | |
| local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=136.24.2.29)(PORT=1521)))) | |
| log_archive_dest_1 | location=/ocs_arch2/billdb2 | |
| log_archive_dest_2 | ||
| log_archive_format | billdb%t_%s_%r.dbf | |
| nls_language | SIMPLIFIED CHINESE | |
| nls_territory | CHINA | |
| open_cursors | 600 | |
| pga_aggregate_target | 8145338368 | |
| processes | 5000 | |
| remote_listener | scan-xjocsdb:1521 | |
| remote_login_passwordfile | EXCLUSIVE | |
| service_names | serv_taf_billdb | |
| sessions | 7524 | |
| sga_target | 24494735360 | |
| spfile | +DG_BILLDB_DATA/billdb/spfilebilldb.ora | |
| thread | 2 | |
| undo_tablespace | UNDOTBS2 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| control_files | +DG_BILLDB_DATA/billdb/control01.ctl | |
control_files | +DG_BILLDB_DATA/billdb/control02.ctl |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| acks for commit broadcast(actual) | 30,793 | 2.14 | 0.57 |
| acks for commit broadcast(logical) | 31,951 | 2.22 | 0.59 |
| broadcast msgs on commit(actual) | 48,001 | 3.33 | 0.89 |
| broadcast msgs on commit(logical) | 53,323 | 3.70 | 0.99 |
| broadcast msgs on commit(wasted) | 1,328 | 0.09 | 0.02 |
| dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
| dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
| flow control messages received | 8 | 0.00 | 0.00 |
| flow control messages sent | 2 | 0.00 | 0.00 |
| gcs apply delta | 0 | 0.00 | 0.00 |
| gcs assume cvt | 0 | 0.00 | 0.00 |
| gcs assume no cvt | 12,751 | 0.88 | 0.24 |
| gcs ast xid | 3 | 0.00 | 0.00 |
| gcs blocked converts | 13,695 | 0.95 | 0.25 |
| gcs blocked cr converts | 14,136 | 0.98 | 0.26 |
| gcs compatible basts | 90 | 0.01 | 0.00 |
| gcs compatible cr basts (global) | 1,614 | 0.11 | 0.03 |
| gcs compatible cr basts (local) | 10,809 | 0.75 | 0.20 |
| gcs cr basts to PIs | 0 | 0.00 | 0.00 |
| gcs cr serve without current lock | 0 | 0.00 | 0.00 |
| gcs dbwr flush pi msgs | 1,647 | 0.11 | 0.03 |
| gcs dbwr write request msgs | 1,334 | 0.09 | 0.02 |
| 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 | 73 | 0.01 | 0.00 |
| gcs force cr grant | 514 | 0.04 | 0.01 |
| 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 | 1,541 | 0.11 | 0.03 |
| gcs immediate (null) converts | 18,890 | 1.31 | 0.35 |
| gcs immediate cr (compatible) converts | 3 | 0.00 | 0.00 |
| gcs immediate cr (null) converts | 2,288,140 | 158.76 | 42.37 |
| gcs indirect ast | 9,138 | 0.63 | 0.17 |
| gcs indirect bidless ast | 0 | 0.00 | 0.00 |
| gcs indirect fg ast | 9,122 | 0.63 | 0.17 |
| gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
| gcs lms write request msgs | 1,574 | 0.11 | 0.03 |
| gcs msgs process time(ms) | 22,309 | 1.55 | 0.41 |
| gcs msgs received | 2,557,897 | 177.47 | 47.36 |
| gcs new served by master | 9,355 | 0.65 | 0.17 |
| gcs out-of-order msgs | 7 | 0.00 | 0.00 |
| gcs pings refused | 8 | 0.00 | 0.00 |
| gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
| gcs push delta | 0 | 0.00 | 0.00 |
| gcs queued converts | 15 | 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 | 2 | 0.00 | 0.00 |
| gcs regular cr | 0 | 0.00 | 0.00 |
| gcs retry convert request | 119 | 0.01 | 0.00 |
| gcs share recovery bast | 0 | 0.00 | 0.00 |
| gcs side channel msgs actual | 7,525 | 0.52 | 0.14 |
| gcs side channel msgs logical | 30,877 | 2.14 | 0.57 |
| gcs stale cr | 34 | 0.00 | 0.00 |
| gcs undo cr | 150 | 0.01 | 0.00 |
| gcs write notification msgs | 125 | 0.01 | 0.00 |
| gcs writes refused | 65 | 0.00 | 0.00 |
| ges msgs process time(ms) | 897,573 | 62.28 | 16.62 |
| ges msgs received | 3,528,578 | 244.82 | 65.34 |
| global posts dropped | 0 | 0.00 | 0.00 |
| global posts queue time | 1,782 | 0.12 | 0.03 |
| global posts queued | 60 | 0.00 | 0.00 |
| global posts requested | 60 | 0.00 | 0.00 |
| global posts sent | 60 | 0.00 | 0.00 |
| implicit batch messages received | 20,410 | 1.42 | 0.38 |
| implicit batch messages sent | 42,645 | 2.96 | 0.79 |
| lmd msg send time(ms) | 0 | 0.00 | 0.00 |
| lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
| messages flow controlled | 1,416 | 0.10 | 0.03 |
| messages queue sent actual | 3,546,378 | 246.05 | 65.67 |
| messages queue sent logical | 970,316 | 67.32 | 17.97 |
| messages received actual | 3,790,959 | 263.02 | 70.19 |
| messages received logical | 6,086,430 | 422.29 | 112.70 |
| messages sent directly | 94,793 | 6.58 | 1.76 |
| messages sent indirectly | 961,192 | 66.69 | 17.80 |
| messages sent not implicit batched | 232 | 0.02 | 0.00 |
| messages sent pbatched | 5,945,671 | 412.52 | 110.09 |
| msgs causing lmd to send msgs | 3,432,290 | 238.14 | 63.55 |
| msgs causing lms(s) to send msgs | 44,063 | 3.06 | 0.82 |
| msgs received queue time (ms) | 542,071 | 37.61 | 10.04 |
| msgs received queued | 6,086,535 | 422.30 | 112.70 |
| msgs sent queue time (ms) | 175,731 | 12.19 | 3.25 |
| msgs sent queue time on ksxp (ms) | 1,099,373 | 76.28 | 20.36 |
| msgs sent queued | 4,472,438 | 310.31 | 82.81 |
| msgs sent queued on ksxp | 3,818,250 | 264.92 | 70.70 |
| number of broadcasted resources | 0 | 0.00 | 0.00 |
| number of ges deadlock detected | 0 | 0.00 | 0.00 |
| process batch messages received | 3,668,584 | 254.53 | 67.93 |
| process batch messages sent | 3,698,267 | 256.59 | 68.48 |
| Statistic | Total |
|---|---|
| CR Block Requests | 4,622 |
| CURRENT Block Requests | 6,065 |
| Data Block Requests | 4,622 |
| Undo Block Requests | 34 |
| TX Block Requests | 1,065 |
| Current Results | 10,582 |
| Private results | 73 |
| Zero Results | 30 |
| Disk Read Results | 1 |
| Fail Results | 1 |
| Fairness Down Converts | 4,544 |
| Fairness Clears | 113 |
| Free GC Elements | 0 |
| Flushes | 195 |
| Flushes Queued | 0 |
| Flush Queue Full | 0 |
| Flush Max Time (us) | 5,270 |
| Light Works | 65 |
| Errors | 0 |
| Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
|---|---|---|---|---|---|---|
| Pins | 54 | 77.78 | 7.41 | 14.81 | 0.00 | 0.00 |
| Flushes | 531 | 92.84 | 6.40 | 0.56 | 0.19 | 0.00 |
| Writes | 2,013 | 76.11 | 11.28 | 5.96 | 2.88 | 3.78 |
| CR | Current | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
| 1 | data block | 3,835 | 56.04 | 43.83 | 0.13 | 9,019 | 94.86 | 4.48 | 0.67 |
| 1 | Others | 5,470 | 99.87 | 0.11 | 0.02 | 3,630 | 93.69 | 6.23 | 0.08 |
| 1 | undo header | 384 | 84.90 | 14.84 | 0.26 | 97 | 97.94 | 1.03 | 1.03 |
| 1 | undo block | 83 | 73.49 | 26.51 | 0.00 | 0 |
| CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
| 1 | data block | 0.63 | 0.55 | 0.74 | 0.99 | 0.61 | 0.56 | 1.44 | 1.42 |
| 1 | others | 0.46 | 0.45 | 4.50 | 3.08 | 0.45 | 0.41 | 1.09 | 0.40 |
| 1 | undo header | 0.45 | 0.38 | 0.84 | 0.35 | 0.41 | 0.40 | 0.76 | 1.31 |
| 1 | undo block | 0.47 | 0.35 | 0.80 |
| CR | Current | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
| 1 | data block | 0 | 2,149 | 100.00 | 0.00 | 8,555 | 100.00 | 0.00 |
| 1 | others | 0 | 5,463 | 100.00 | 0.00 | 3,401 | 100.00 | 0.00 |
| 1 | undo header | 0 | 326 | 100.00 | 0.00 | 95 | 100.00 | 0.00 |
| 1 | undo block | 0 | 61 | 100.00 | 0.00 | 0 |
| CR Avg Time (ms) | Current Avg Time (ms) | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
| 1 | data block | 0.55 | 0.55 | 0.56 | 0.56 | |||
| 1 | others | 0.45 | 0.45 | 0.41 | 0.41 | |||
| 1 | undo header | 0.38 | 0.38 | 0.40 | 0.40 | |||
| 1 | undo block | 0.35 | 0.35 |
| Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
|---|---|---|---|---|---|---|
| 1 | 1,122 | 0.33 | 0.40 | 1,122 | 0.56 | 0.57 |
| 2 | 1,122 | 0.15 | 0.01 | 1,122 | 0.14 | 0.01 |
| Used By | Send Mbytes/sec | Receive Mbytes/sec |
|---|---|---|
| Global Cache | 0.01 | 0.01 |
| Parallel Query | 0.00 | 0.00 |
| DB Locks | 0.12 | 0.10 |
| DB Streams | 0.00 | 0.00 |
| Other | 0.01 | 0.01 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| en5 | 169.254.75.89 | NO | 0.34 | 0 | 0 | 0 | 0 | 0.28 | 0 | 0 | 0 | 0 | |
| en5 | 169.254.75.89 | NO | 0.34 | 0 | 0 | 0 | 0 | 0.28 | 0 | 0 | 0 | 0 | |
| en5 | 169.254.75.89 | NO | 0.34 | 0 | 0 | 0 | 0 | 0.28 | 0 | 0 | 0 | 0 | |
| en5 | 169.254.75.89 | NO | 0.34 | 0 | 0 | 0 | 0 | 0.28 | 0 | 0 | 0 | 0 |
| Name | Total | per Remaster Op | Begin Snap | End Snap |
|---|---|---|---|---|
| remaster ops | 9 | 1.00 | ||
| remastered objects | 14 | 1.56 | ||
| replayed locks received | 65 | 7.22 | ||
| replayed locks sent | 0 | 0.00 | ||
| resources cleaned | 0 | 0.00 | ||
| remaster time (s) | 23.3 | 2.59 | ||
| quiesce time (s) | 6.2 | 0.68 | ||
| freeze time (s) | 0.2 | 0.02 | ||
| cleanup time (s) | 3.9 | 0.44 | ||
| replay time (s) | 4.8 | 0.53 | ||
| fixwrite time (s) | 5.5 | 0.61 | ||
| sync time (s) | 2.6 | 0.28 | ||
| affinity objects | 2 | 5 |