| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| TYQXDB | 1493581804 | tyqxdb1 | 1 | 21-12月-13 03:12 | 11.2.0.3.0 | YES |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| tyqxdb1 | Linux x86 64-bit | 64 | 32 | 4 | 31.30 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 8585 | 14-11月-14 15:00:07 | 369 | 3.2 |
| End Snap: | 8588 | 14-11月-14 18:00:27 | 350 | 2.7 |
| Elapsed: | 180.34 (mins) | |||
| DB Time: | 1,488.28 (mins) |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 8,160M | 8,160M | Std Block Size: | 8K |
| Shared Pool Size: | 5,920M | 5,920M | Log Buffer: | 62,604K |
| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 8.3 | 0.2 | 0.02 | 0.00 |
| DB CPU(s): | 1.5 | 0.0 | 0.00 | 0.00 |
| Redo size: | 72,276.7 | 1,580.8 | ||
| Logical reads: | 61,188.5 | 1,338.3 | ||
| Block changes: | 3,100.9 | 67.8 | ||
| Physical reads: | 11,608.4 | 253.9 | ||
| Physical writes: | 12.8 | 0.3 | ||
| User calls: | 3,520.0 | 77.0 | ||
| Parses: | 150.8 | 3.3 | ||
| Hard parses: | 39.0 | 0.9 | ||
| W/A MB processed: | 9.4 | 0.2 | ||
| Logons: | 6.8 | 0.2 | ||
| Executes: | 466.3 | 10.2 | ||
| Rollbacks: | 0.0 | 0.0 | ||
| Transactions: | 45.7 |
| Buffer Nowait %: | 99.98 | Redo NoWait %: | 98.00 |
| Buffer Hit %: | 81.03 | In-memory Sort %: | 100.00 |
| Library Hit %: | 86.64 | Soft Parse %: | 74.13 |
| Execute to Parse %: | 67.66 | Latch Hit %: | 99.80 |
| Parse CPU to Parse Elapsd %: | 94.50 | % Non-Parse CPU: | 88.17 |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 81.64 | 81.68 |
| % SQL with executions>1: | 80.87 | 82.55 |
| % Memory for SQL w/exec>1: | 73.01 | 75.73 |
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| db file scattered read | 2,278,640 | 18,164 | 8 | 20.34 | User I/O |
| DB CPU | 16,455 | 18.43 | |||
| db file parallel read | 355,179 | 10,562 | 30 | 11.83 | User I/O |
| log file sync | 579,947 | 6,614 | 11 | 7.41 | Commit |
| db file sequential read | 550,885 | 2,674 | 5 | 2.99 | User I/O |
| Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|
| 3.74 | 1.93 | 2.3 | 0.6 | 2.7 | 96.9 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 2.6 | 84.6 | 0.0 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 32,053.5 | 32,053.5 |
| SGA use (MB): | 14,496.0 | 14,496.0 |
| PGA use (MB): | 1,395.6 | 1,295.9 |
| % Host Mem used for SGA+PGA: | 49.58 | 49.27 |
| Begin | End | |
|---|---|---|
| Number of Instances: | 2 | 2 |
| Per Second | Per Transaction | |
|---|---|---|
| Global Cache blocks received: | 647.97 | 14.17 |
| Global Cache blocks served: | 325.81 | 7.13 |
| GCS/GES messages received: | 6,059.41 | 132.53 |
| GCS/GES messages sent: | 6,545.66 | 143.17 |
| DBWR Fusion writes: | 1.23 | 0.03 |
| Estd Interconnect traffic (KB) | 10,252.11 |
| Buffer access - local cache %: | 79.97 |
| Buffer access - remote cache %: | 1.06 |
| Buffer access - disk %: | 18.97 |
| Avg global enqueue get time (ms): | 0.0 |
| Avg global cache cr block receive time (ms): | 2.3 |
| Avg global cache current block receive time (ms): | 2.2 |
| 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 %: | 0.4 |
| Avg global cache cr block flush time (ms): | 11.8 |
| 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 %: | 0.6 |
| Avg global cache current block flush time (ms): | 11.7 |
| Avg message sent queue time (ms): | 0.1 |
| Avg message sent queue time on ksxp (ms): | 1.4 |
| Avg message received queue time (ms): | 0.0 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.0 |
| % of direct sent messages: | 4.77 |
| % of indirect sent messages: | 94.04 |
| % of flow controlled messages: | 1.19 |
| Begin | End | |||||
|---|---|---|---|---|---|---|
| Interface | IP Address | Pub | Source | IP | Pub | Src |
| eth3:1 | 169.254.212.83 | N |
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| sql execute elapsed time | 46,840.88 | 52.46 |
| DB CPU | 16,455.29 | 18.43 |
| connection management call elapsed time | 2,782.06 | 3.12 |
| parse time elapsed | 2,091.43 | 2.34 |
| hard parse elapsed time | 1,690.87 | 1.89 |
| PL/SQL compilation elapsed time | 231.79 | 0.26 |
| PL/SQL execution elapsed time | 140.78 | 0.16 |
| failed parse elapsed time | 94.66 | 0.11 |
| hard parse (sharing criteria) elapsed time | 29.27 | 0.03 |
| repeated bind elapsed time | 1.02 | 0.00 |
| hard parse (bind mismatch) elapsed time | 0.90 | 0.00 |
| RMAN cpu time (backup/restore) | 0.78 | 0.00 |
| Java execution elapsed time | 0.25 | 0.00 |
| sequence load elapsed time | 0.18 | 0.00 |
| DB time | 89,296.71 | |
| background elapsed time | 4,528.60 | |
| background cpu time | 1,746.04 |
| Statistic | Value | End Value |
|---|---|---|
| BUSY_TIME | 2,151,532 | |
| IDLE_TIME | 67,061,300 | |
| IOWAIT_TIME | 1,845,153 | |
| NICE_TIME | 708 | |
| SYS_TIME | 431,753 | |
| USER_TIME | 1,577,851 | |
| LOAD | 4 | 2 |
| RSRC_MGR_CPU_WAIT_TIME | 0 | |
| VM_IN_BYTES | 45,056 | |
| VM_OUT_BYTES | 0 | |
| PHYSICAL_MEMORY_BYTES | 33,610,498,048 | |
| NUM_CPUS | 64 | |
| NUM_CPU_CORES | 32 | |
| NUM_CPU_SOCKETS | 4 | |
| GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
| GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
| TCP_RECEIVE_SIZE_DEFAULT | 4,194,304 | |
| TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
| TCP_RECEIVE_SIZE_MIN | 4,194,304 | |
| TCP_SEND_SIZE_DEFAULT | 262,144 | |
| TCP_SEND_SIZE_MAX | 262,144 | |
| TCP_SEND_SIZE_MIN | 262,144 |
| Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
|---|---|---|---|---|---|---|
| 14-11月 15:00:07 | 3.74 | |||||
| 14-11月 16:00:15 | 2.72 | 3.46 | 2.56 | 0.67 | 96.54 | 2.68 |
| 14-11月 17:00:21 | 2.85 | 3.01 | 2.18 | 0.60 | 96.99 | 2.46 |
| 14-11月 18:00:27 | 1.93 | 2.86 | 2.10 | 0.59 | 97.14 | 2.85 |
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
|---|---|---|---|---|---|
| User I/O | 3,353,797 | 0 | 31,895 | 10 | 35.72 |
| DB CPU | 16,455 | 18.43 | |||
| Commit | 579,947 | 0 | 6,614 | 11 | 7.41 |
| Cluster | 1,457,504 | 0 | 3,230 | 2 | 3.62 |
| Configuration | 2,234 | 0 | 974 | 436 | 1.09 |
| Concurrency | 142,688 | 0 | 341 | 2 | 0.38 |
| Other | 100,883 | 14 | 136 | 1 | 0.15 |
| Network | 34,328,042 | 0 | 40 | 0 | 0.04 |
| Application | 6,204 | 6 | 2 | 0 | 0.00 |
| System I/O | 767 | 0 | 2 | 2 | 0.00 |
| Administrative | 1 | 100 | 0 | 101 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| db file scattered read | 2,278,640 | 0 | 18,164 | 8 | 4.61 | 20.34 |
| db file parallel read | 355,179 | 0 | 10,562 | 30 | 0.72 | 11.83 |
| log file sync | 579,947 | 0 | 6,614 | 11 | 1.17 | 7.41 |
| db file sequential read | 550,885 | 0 | 2,674 | 5 | 1.11 | 2.99 |
| gc cr multi block request | 916,142 | 0 | 1,607 | 2 | 1.85 | 1.80 |
| log file switch (checkpoint incomplete) | 1,192 | 0 | 956 | 802 | 0.00 | 1.07 |
| gc buffer busy acquire | 23,685 | 0 | 518 | 22 | 0.05 | 0.58 |
| gc current block busy | 20,410 | 0 | 428 | 21 | 0.04 | 0.48 |
| read by other session | 54,360 | 0 | 318 | 6 | 0.11 | 0.36 |
| gc buffer busy release | 7,449 | 0 | 288 | 39 | 0.02 | 0.32 |
| gc current block 2-way | 271,599 | 0 | 209 | 1 | 0.55 | 0.23 |
| library cache: mutex X | 62,629 | 0 | 189 | 3 | 0.13 | 0.21 |
| buffer busy waits | 20,489 | 0 | 123 | 6 | 0.04 | 0.14 |
| Data file init write | 24,510 | 0 | 112 | 5 | 0.05 | 0.13 |
| gc cr grant 2-way | 100,341 | 0 | 58 | 1 | 0.20 | 0.07 |
| gc cr block 2-way | 76,408 | 0 | 57 | 1 | 0.15 | 0.06 |
| DFS lock handle | 53,235 | 3 | 49 | 1 | 0.11 | 0.06 |
| direct path write temp | 7,658 | 0 | 42 | 5 | 0.02 | 0.05 |
| gcs drm freeze in enter server mode | 186 | 0 | 37 | 200 | 0.00 | 0.04 |
| SQL*Net message to client | 34,265,147 | 0 | 37 | 0 | 69.26 | 0.04 |
| gc cr block busy | 1,345 | 0 | 28 | 21 | 0.00 | 0.03 |
| Disk file operations I/O | 82,289 | 0 | 20 | 0 | 0.17 | 0.02 |
| log file switch completion | 185 | 0 | 17 | 90 | 0.00 | 0.02 |
| enq: MS - contention | 2,959 | 0 | 16 | 5 | 0.01 | 0.02 |
| gc current grant busy | 20,040 | 0 | 15 | 1 | 0.04 | 0.02 |
| cursor: pin S wait on X | 5,321 | 0 | 14 | 3 | 0.01 | 0.02 |
| CSS initialization | 3,168 | 0 | 11 | 4 | 0.01 | 0.01 |
| kksfbc child completion | 209 | 95 | 10 | 49 | 0.00 | 0.01 |
| gc current grant 2-way | 13,345 | 0 | 9 | 1 | 0.03 | 0.01 |
| CSS operation: action | 3,168 | 0 | 8 | 2 | 0.01 | 0.01 |
| row cache lock | 23,437 | 0 | 7 | 0 | 0.05 | 0.01 |
| gc current block congested | 3,095 | 0 | 5 | 2 | 0.01 | 0.01 |
| latch: shared pool | 12,486 | 0 | 3 | 0 | 0.03 | 0.00 |
| gc remaster | 66 | 0 | 3 | 45 | 0.00 | 0.00 |
| library cache lock | 2,071 | 1 | 3 | 1 | 0.00 | 0.00 |
| SQL*Net more data from client | 36,043 | 0 | 3 | 0 | 0.07 | 0.00 |
| direct path read | 125 | 0 | 2 | 18 | 0.00 | 0.00 |
| enq: HW - contention | 846 | 0 | 2 | 2 | 0.00 | 0.00 |
| control file sequential read | 740 | 0 | 2 | 2 | 0.00 | 0.00 |
| gc cr grant congested | 1,244 | 0 | 2 | 1 | 0.00 | 0.00 |
| gc current multi block request | 1,408 | 0 | 2 | 1 | 0.00 | 0.00 |
| CSS operation: query | 9,504 | 0 | 1 | 0 | 0.02 | 0.00 |
| enq: TX - row lock contention | 724 | 0 | 1 | 2 | 0.00 | 0.00 |
| library cache pin | 1,955 | 0 | 1 | 1 | 0.00 | 0.00 |
| enq: FB - contention | 1,055 | 0 | 1 | 1 | 0.00 | 0.00 |
| gc cr block congested | 712 | 0 | 1 | 1 | 0.00 | 0.00 |
| latch: gc element | 2,990 | 0 | 1 | 0 | 0.01 | 0.00 |
| SQL*Net break/reset to client | 5,107 | 0 | 1 | 0 | 0.01 | 0.00 |
| local write wait | 126 | 0 | 1 | 5 | 0.00 | 0.00 |
| latch: object queue header operation | 5,333 | 0 | 1 | 0 | 0.01 | 0.00 |
| library cache load lock | 561 | 0 | 1 | 1 | 0.00 | 0.00 |
| latch: cache buffers chains | 10,419 | 0 | 0 | 0 | 0.02 | 0.00 |
| SQL*Net more data to client | 26,852 | 0 | 0 | 0 | 0.05 | 0.00 |
| enq: UL - contention | 373 | 99 | 0 | 1 | 0.00 | 0.00 |
| cursor: pin S | 777 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current grant congested | 187 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: SR - contention | 356 | 0 | 0 | 1 | 0.00 | 0.00 |
| write complete waits | 3 | 0 | 0 | 80 | 0.00 | 0.00 |
| enq: JQ - contention | 229 | 100 | 0 | 1 | 0.00 | 0.00 |
| control file parallel write | 26 | 0 | 0 | 7 | 0.00 | 0.00 |
| enq: JI - contention | 193 | 0 | 0 | 1 | 0.00 | 0.00 |
| IPC send completion sync | 201 | 0 | 0 | 1 | 0.00 | 0.00 |
| JS kgl get object wait | 1 | 100 | 0 | 101 | 0.00 | 0.00 |
| enq: PS - contention | 107 | 30 | 0 | 1 | 0.00 | 0.00 |
| latch: row cache objects | 2,091 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 159 | 0 | 0 | 0 | 0.00 | 0.00 |
| direct path write | 16 | 0 | 0 | 4 | 0.00 | 0.00 |
| ASM file metadata operation | 4 | 0 | 0 | 13 | 0.00 | 0.00 |
| gc cr failure | 3 | 0 | 0 | 15 | 0.00 | 0.00 |
| reliable message | 473 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffers lru chain | 560 | 0 | 0 | 0 | 0.00 | 0.00 |
| direct path read temp | 6 | 0 | 0 | 7 | 0.00 | 0.00 |
| KJC: Wait for msg sends to complete | 2,269 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc reply | 5 | 0 | 0 | 7 | 0.00 | 0.00 |
| kfk: async disk IO | 1 | 0 | 0 | 31 | 0.00 | 0.00 |
| latch: gcs resource hash | 419 | 0 | 0 | 0 | 0.00 | 0.00 |
| asynch descriptor resize | 11,455 | 100 | 0 | 0 | 0.02 | 0.00 |
| cursor: mutex S | 117 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffer handles | 5 | 0 | 0 | 5 | 0.00 | 0.00 |
| latch: ges resource hash list | 214 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch free | 217 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TO - contention | 25 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 66 | 0 | 0 | 0 | 0.00 | 0.00 |
| cursor: mutex X | 335 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: active service list | 476 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: enqueue hash chains | 34 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: reap credit | 1,234 | 100 | 0 | 0 | 0.00 | 0.00 |
| gc current retry | 8 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc cr disk read | 17 | 0 | 0 | 0 | 0.00 | 0.00 |
| ADR block file read | 40 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TX - contention | 2 | 100 | 0 | 2 | 0.00 | 0.00 |
| PX Deq: Signal ACK EXT | 66 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: call allocation | 49 | 0 | 0 | 0 | 0.00 | 0.00 |
| ADR block file write | 40 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: AE - lock | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
| wait list latch free | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
| db file single write | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
| global enqueue expand wait | 54 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: CF - contention | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: SQ - contention | 1 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: JS - job run lock - synchronize | 4 | 100 | 0 | 0 | 0.00 | 0.00 |
| ADR file lock | 80 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: redo allocation | 10 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message from client | 34,265,155 | 0 | 3,356,585 | 98 | 69.26 | |
| jobq slave wait | 117,066 | 95 | 57,910 | 495 | 0.24 | |
| KSV master wait | 13 | 0 | 17 | 1299 | 0.00 | |
| PX Deq: Execution Msg | 372 | 0 | 1 | 3 | 0.00 | |
| PX Deq: Parse Reply | 66 | 0 | 1 | 8 | 0.00 | |
| PX Deq: Join ACK | 66 | 0 | 0 | 5 | 0.00 | |
| PX Deq: Execute Reply | 66 | 0 | 0 | 2 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| log file parallel write | 582,663 | 0 | 2,164 | 4 | 1.18 | 47.78 |
| gcs log flush sync | 71,456 | 12 | 234 | 3 | 0.14 | 5.17 |
| control file sequential read | 77,119 | 0 | 196 | 3 | 0.16 | 4.32 |
| db file parallel write | 30,213 | 0 | 133 | 4 | 0.06 | 2.94 |
| reliable message | 1,186 | 7 | 109 | 92 | 0.00 | 2.40 |
| db file sequential read | 3,812 | 0 | 42 | 11 | 0.01 | 0.93 |
| control file parallel write | 6,643 | 0 | 31 | 5 | 0.01 | 0.69 |
| ges lms sync during dynamic remastering and reconfig | 600 | 83 | 24 | 39 | 0.00 | 0.52 |
| ASM file metadata operation | 7,642 | 0 | 21 | 3 | 0.02 | 0.46 |
| Streams AQ: qmn coordinator waiting for slave to start | 2 | 100 | 12 | 5934 | 0.00 | 0.26 |
| log file sequential read | 1,580 | 0 | 11 | 7 | 0.00 | 0.24 |
| os thread startup | 458 | 0 | 7 | 16 | 0.00 | 0.16 |
| latch free | 978 | 0 | 6 | 6 | 0.00 | 0.14 |
| DFS lock handle | 10,711 | 11 | 6 | 1 | 0.02 | 0.14 |
| enq: CF - contention | 389 | 53 | 5 | 12 | 0.00 | 0.11 |
| row cache lock | 9,339 | 0 | 4 | 0 | 0.02 | 0.09 |
| libcache interrupt action by LCK | 153,219 | 0 | 3 | 0 | 0.31 | 0.08 |
| enq: WF - contention | 49 | 0 | 3 | 62 | 0.00 | 0.07 |
| RMAN backup & recovery I/O | 339 | 0 | 2 | 7 | 0.00 | 0.05 |
| gc cr block 2-way | 3,416 | 0 | 2 | 1 | 0.01 | 0.05 |
| gc current block 2-way | 3,090 | 0 | 2 | 1 | 0.01 | 0.05 |
| row cache process | 280,281 | 0 | 2 | 0 | 0.57 | 0.04 |
| CSS operation: action | 3,208 | 0 | 2 | 1 | 0.01 | 0.04 |
| gc current block busy | 60 | 0 | 1 | 23 | 0.00 | 0.03 |
| gc cr multi block request | 569 | 0 | 1 | 2 | 0.00 | 0.03 |
| ADR block file read | 1,840 | 0 | 1 | 1 | 0.00 | 0.03 |
| ksxr poll remote instances | 147,310 | 100 | 1 | 0 | 0.30 | 0.03 |
| library cache pin | 2,157 | 0 | 1 | 1 | 0.00 | 0.02 |
| Disk file operations I/O | 1,507 | 0 | 1 | 1 | 0.00 | 0.02 |
| gc cr block busy | 48 | 0 | 1 | 21 | 0.00 | 0.02 |
| CGS wait for IPC msg | 102,911 | 100 | 1 | 0 | 0.21 | 0.02 |
| direct path read | 131 | 0 | 1 | 6 | 0.00 | 0.02 |
| asynch descriptor resize | 69,585 | 100 | 1 | 0 | 0.14 | 0.02 |
| CSS operation: data query | 480 | 0 | 1 | 1 | 0.00 | 0.01 |
| ges LMON to get to FTDONE | 24 | 96 | 1 | 26 | 0.00 | 0.01 |
| gc cr grant 2-way | 1,280 | 0 | 1 | 0 | 0.00 | 0.01 |
| log file single write | 276 | 0 | 1 | 2 | 0.00 | 0.01 |
| library cache lock | 771 | 0 | 1 | 1 | 0.00 | 0.01 |
| row cache cleanup | 193,883 | 0 | 1 | 0 | 0.39 | 0.01 |
| ges generic event | 45 | 98 | 0 | 10 | 0.00 | 0.01 |
| gc current grant 2-way | 837 | 0 | 0 | 1 | 0.00 | 0.01 |
| direct path write | 110 | 0 | 0 | 4 | 0.00 | 0.01 |
| Log archive I/O | 69 | 0 | 0 | 5 | 0.00 | 0.01 |
| kfk: async disk IO | 207 | 0 | 0 | 2 | 0.00 | 0.01 |
| control file single write | 187 | 0 | 0 | 2 | 0.00 | 0.01 |
| db file parallel read | 11 | 0 | 0 | 29 | 0.00 | 0.01 |
| enq: JQ - contention | 592 | 100 | 0 | 1 | 0.00 | 0.01 |
| LGWR wait for redo copy | 7,269 | 0 | 0 | 0 | 0.01 | 0.01 |
| kjbdrmcvtq lmon drm quiesce: ping completion | 43 | 0 | 0 | 7 | 0.00 | 0.01 |
| gc current grant busy | 402 | 0 | 0 | 1 | 0.00 | 0.01 |
| log file switch (checkpoint incomplete) | 2 | 0 | 0 | 116 | 0.00 | 0.01 |
| SQL*Net message to client | 252,939 | 0 | 0 | 0 | 0.51 | 0.00 |
| latch: call allocation | 2,304 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc object scan | 22,512 | 100 | 0 | 0 | 0.05 | 0.00 |
| CSS group membership query | 160 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: shared pool | 521 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: object queue header operation | 811 | 0 | 0 | 0 | 0.00 | 0.00 |
| db file scattered read | 11 | 0 | 0 | 12 | 0.00 | 0.00 |
| log file sync | 11 | 0 | 0 | 12 | 0.00 | 0.00 |
| enq: TM - contention | 24 | 83 | 0 | 5 | 0.00 | 0.00 |
| latch: ges resource hash list | 806 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffers chains | 500 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS initialization | 20 | 0 | 0 | 3 | 0.00 | 0.00 |
| latch: gc element | 475 | 0 | 0 | 0 | 0.00 | 0.00 |
| wait for scn ack | 8 | 0 | 0 | 8 | 0.00 | 0.00 |
| gc buffer busy release | 6 | 0 | 0 | 10 | 0.00 | 0.00 |
| cursor: pin S wait on X | 2 | 0 | 0 | 27 | 0.00 | 0.00 |
| log file switch completion | 2 | 0 | 0 | 27 | 0.00 | 0.00 |
| enq: PS - contention | 46 | 22 | 0 | 1 | 0.00 | 0.00 |
| latch: gcs resource hash | 409 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr block congested | 30 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc current block congested | 33 | 0 | 0 | 1 | 0.00 | 0.00 |
| ADR block file write | 687 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 56 | 71 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: reap credit | 5,007 | 100 | 0 | 0 | 0.01 | 0.00 |
| enq: WL - contention | 35 | 100 | 0 | 1 | 0.00 | 0.00 |
| gc current multi block request | 27 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 54 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: HW - contention | 32 | 3 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 54 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr grant congested | 13 | 0 | 0 | 1 | 0.00 | 0.00 |
| db file async I/O submit | 13,129 | 0 | 0 | 0 | 0.03 | 0.00 |
| IPC send completion sync | 36 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TA - contention | 32 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current grant congested | 11 | 0 | 0 | 1 | 0.00 | 0.00 |
| CSS operation: query | 220 | 0 | 0 | 0 | 0.00 | 0.00 |
| library cache: mutex X | 15 | 0 | 0 | 1 | 0.00 | 0.00 |
| gc quiesce | 1 | 100 | 0 | 10 | 0.00 | 0.00 |
| enq: TD - KTF dump entries | 24 | 0 | 0 | 0 | 0.00 | 0.00 |
| ADR file lock | 656 | 13 | 0 | 0 | 0.00 | 0.00 |
| enq: FB - contention | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
| ARCH wait for archivelog lock | 69 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: US - contention | 8 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: DR - contention | 6 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: Signal ACK EXT | 54 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc buffer busy acquire | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: CR - block range reuse ckpt | 7 | 0 | 0 | 0 | 0.00 | 0.00 |
| KJC: Wait for msg sends to complete | 191 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TQ - TM contention | 4 | 0 | 0 | 1 | 0.00 | 0.00 |
| ges2 LMON to wake up LMD - mrcvr | 36 | 0 | 0 | 0 | 0.00 | 0.00 |
| ges DFS hang analysis phase 2 acks | 1 | 0 | 0 | 2 | 0.00 | 0.00 |
| buffer busy waits | 14 | 0 | 0 | 0 | 0.00 | 0.00 |
| ges inquiry response | 2 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: MW - contention | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
| kjctssqmg: quick message send wait | 64 | 100 | 0 | 0 | 0.00 | 0.00 |
| enq: AF - task serialization | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffers lru chain | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc message | 1,268,196 | 16 | 321,912 | 254 | 2.56 | |
| gcs remote message | 8,425,708 | 29 | 41,888 | 5 | 17.03 | |
| class slave wait | 19,887 | 0 | 31,887 | 1603 | 0.04 | |
| wait for unread message on broadcast channel | 21,612 | 100 | 21,635 | 1001 | 0.04 | |
| DIAG idle wait | 5,264,938 | 98 | 21,385 | 4 | 10.64 | |
| Space Manager: slave idle wait | 3,462 | 98 | 17,102 | 4940 | 0.01 | |
| Streams AQ: qmn slave idle wait | 385 | 1 | 10,957 | 28460 | 0.00 | |
| smon timer | 68 | 35 | 10,865 | 159772 | 0.00 | |
| dispatcher timer | 181 | 100 | 10,860 | 60002 | 0.00 | |
| shared server idle wait | 361 | 100 | 10,830 | 30001 | 0.00 | |
| PING | 4,139 | 20 | 10,822 | 2615 | 0.01 | |
| ASM background timer | 3,814 | 0 | 10,819 | 2837 | 0.01 | |
| GCR sleep | 2,163 | 100 | 10,818 | 5001 | 0.00 | |
| PX Idle Wait | 93 | 0 | 10,817 | 116316 | 0.00 | |
| pmon timer | 4,044 | 87 | 10,807 | 2672 | 0.01 | |
| Streams AQ: qmn coordinator idle wait | 754 | 50 | 10,804 | 14329 | 0.00 | |
| ges remote message | 323,232 | 30 | 10,803 | 33 | 0.65 | |
| Streams AQ: waiting for time management or cleanup tasks | 147 | 66 | 6,912 | 47022 | 0.00 | |
| JOX Jit Process Sleep | 98 | 100 | 735 | 7502 | 0.00 | |
| SQL*Net message from client | 322,009 | 0 | 198 | 1 | 0.65 | |
| KSV master wait | 14,413 | 46 | 3 | 0 | 0.03 | |
| heartbeat monitor sleep | 93 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Parse Reply | 54 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Join ACK | 54 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Execute Reply | 54 | 0 | 0 | 0 | 0.00 | |
| Streams AQ: RAC qmn coordinator idle wait | 763 | 100 | 0 | 0 | 0.00 |
| % of Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
| ADR block file read | 1880 | 90.2 | .1 | 1.5 | 6.9 | 1.3 | |||
| ADR block file write | 727 | 100.0 | |||||||
| ADR file lock | 736 | 100.0 | |||||||
| ARCH wait for archivelog lock | 69 | 100.0 | |||||||
| ASM file metadata operation | 7642 | 94.7 | 2.1 | 1.0 | 1.0 | .3 | .7 | .3 | .0 |
| CGS wait for IPC msg | 102.9K | 100.0 | |||||||
| CSS group membership query | 160 | 52.5 | 46.3 | 1.3 | |||||
| CSS initialization | 3188 | 50.0 | 43.3 | 6.5 | .3 | ||||
| CSS operation: action | 6375 | 40.0 | 9.8 | 50.0 | .2 | .0 | |||
| CSS operation: data query | 480 | .6 | 98.3 | 1.0 | |||||
| CSS operation: query | 9724 | 96.8 | 3.0 | .2 | .0 | ||||
| DFS lock handle | 63.9K | 73.6 | 19.7 | 5.6 | 1.0 | .1 | .0 | .0 | |
| Data file init write | 24.5K | 20.0 | 17.9 | 25.4 | 25.4 | 8.0 | 2.3 | 1.0 | |
| Disk file operations I/O | 83.8K | 99.9 | .0 | .0 | .0 | .0 | .0 | ||
| IPC send completion sync | 237 | 90.7 | 6.3 | 3.0 | |||||
| JS kgl get object wait | 1 | 100.0 | |||||||
| KJC: Wait for msg sends to complete | 2449 | 99.9 | .0 | .0 | |||||
| LGWR wait for redo copy | 7267 | 99.9 | .1 | ||||||
| Log archive I/O | 69 | 4.3 | 1.4 | 34.8 | 50.7 | 5.8 | 2.9 | ||
| PX Deq: Signal ACK EXT | 120 | 99.2 | .8 | ||||||
| PX Deq: Signal ACK RSG | 120 | 94.2 | 5.0 | .8 | |||||
| PX Deq: Slave Session Stats | 213 | 92.5 | 5.2 | 1.9 | .5 | ||||
| PX Deq: reap credit | 6239 | 100.0 | |||||||
| RMAN backup & recovery I/O | 339 | 48.1 | .3 | 41.9 | 8.8 | .9 | |||
| SQL*Net break/reset to client | 5103 | 99.7 | .1 | .1 | .1 | .0 | |||
| SQL*Net message to client | 34.5M | 100.0 | |||||||
| SQL*Net more data from client | 36K | 99.6 | .2 | .1 | .1 | .0 | .0 | .0 | |
| SQL*Net more data to client | 26.8K | 100.0 | |||||||
| Streams AQ: qmn coordinator waiting for slave to start | 2 | 100.0 | |||||||
| asynch descriptor resize | 81.1K | 100.0 | |||||||
| buffer busy waits | 20.5K | 87.9 | 7.3 | 3.2 | .8 | .1 | .0 | .5 | .2 |
| control file parallel write | 6668 | 43.8 | 13.7 | 12.9 | 13.7 | 10.1 | 3.8 | 2.0 | |
| control file sequential read | 77.8K | 65.3 | 14.8 | 7.4 | 4.3 | 5.0 | 2.3 | 1.0 | |
| control file single write | 187 | 7.0 | 65.2 | 27.8 | |||||
| cursor: mutex S | 117 | 98.3 | 1.7 | ||||||
| cursor: mutex X | 335 | 99.4 | .6 | ||||||
| cursor: pin S | 778 | 96.8 | .1 | 3.1 | |||||
| cursor: pin S wait on X | 5322 | 6.8 | 35.5 | 49.2 | 5.5 | 2.8 | .2 | .0 | |
| db file async I/O submit | 13.1K | 100.0 | |||||||
| db file parallel read | 355.2K | 7.0 | 10.4 | 14.3 | 10.5 | 15.5 | 15.7 | 26.5 | .0 |
| db file parallel write | 30.2K | 54.7 | 14.5 | 11.1 | 7.4 | 6.5 | 3.2 | 2.6 | |
| db file scattered read | 2275.5K | 27.1 | 17.7 | 15.9 | 10.6 | 13.7 | 10.4 | 4.6 | |
| db file sequential read | 553.5K | 46.3 | 16.4 | 9.4 | 10.3 | 10.3 | 5.0 | 2.3 | |
| db file single write | 3 | 66.7 | 33.3 | ||||||
| direct path read | 256 | 24.2 | 14.5 | 16.8 | 16.0 | 11.3 | 9.8 | 7.4 | |
| direct path read temp | 6 | 66.7 | 16.7 | 16.7 | |||||
| direct path write | 126 | 42.9 | 23.0 | 14.3 | 7.9 | 5.6 | 4.8 | 1.6 | |
| direct path write temp | 7655 | 45.3 | 9.6 | 10.0 | 10.9 | 16.5 | 5.2 | 2.6 | |
| enq: AE - lock | 12 | 100.0 | |||||||
| enq: AF - task serialization | 3 | 100.0 | |||||||
| enq: CF - contention | 392 | 60.7 | 8.7 | 3.3 | 3.3 | 3.8 | 8.9 | 11.2 | |
| enq: CR - block range reuse ckpt | 7 | 100.0 | |||||||
| enq: CT - state | 1 | 100.0 | |||||||
| enq: DR - contention | 6 | 66.7 | 33.3 | ||||||
| enq: FB - contention | 1068 | 74.2 | 22.3 | 2.7 | .7 | .1 | .1 | ||
| enq: FD - Flashback logical operations | 1 | 100.0 | |||||||
| enq: HW - contention | 870 | 43.1 | 32.9 | 17.9 | 3.9 | .7 | .8 | .7 | |
| enq: JI - contention | 193 | 87.6 | 8.3 | 4.1 | |||||
| enq: JQ - contention | 820 | 87.4 | 9.6 | 2.9 | |||||
| enq: JS - job run lock - synchronize | 4 | 100.0 | |||||||
| enq: MS - contention | 2959 | 68.2 | 10.2 | 7.7 | 5.5 | 2.5 | .7 | 5.3 | |
| enq: MW - contention | 3 | 100.0 | |||||||
| enq: PS - contention | 153 | 80.4 | 15.7 | 3.9 | |||||
| enq: SQ - contention | 1 | 100.0 | |||||||
| enq: SR - contention | 356 | 84.3 | 14.6 | .8 | .3 | ||||
| enq: TA - contention | 32 | 93.8 | 6.3 | ||||||
| enq: TD - KTF dump entries | 24 | 95.8 | 4.2 | ||||||
| enq: TM - contention | 24 | 95.8 | 4.2 | ||||||
| enq: TO - contention | 25 | 76.0 | 24.0 | ||||||
| enq: TQ - TM contention | 4 | 100.0 | |||||||
| enq: TT - contention | 60 | 85.0 | 13.3 | 1.7 | |||||
| enq: TX - contention | 2 | 50.0 | 50.0 | ||||||
| enq: TX - row lock contention | 724 | 87.6 | 3.2 | 1.1 | 4.0 | 3.2 | .1 | .8 | |
| enq: UL - contention | 373 | 79.9 | 19.0 | 1.1 | |||||
| enq: US - contention | 8 | 87.5 | 12.5 | ||||||
| enq: WF - contention | 49 | 79.6 | 14.3 | 2.0 | 4.1 | ||||
| enq: WL - contention | 35 | 85.7 | 11.4 | 2.9 | |||||
| gc buffer busy acquire | 23.7K | 27.1 | 19.1 | 12.1 | 9.2 | 8.6 | 8.6 | 15.1 | .2 |
| gc buffer busy release | 7455 | 9.7 | 6.1 | 9.7 | 14.2 | 18.1 | 19.5 | 22.2 | .5 |
| gc cr block 2-way | 79.7K | 85.4 | 12.0 | 2.1 | .4 | .0 | .0 | .0 | |
| gc cr block busy | 1392 | 5.0 | 13.8 | 15.6 | 19.2 | 14.2 | 13.6 | 18.5 | |
| gc cr block congested | 741 | 62.1 | 25.9 | 7.3 | 4.3 | .3 | .1 | ||
| gc cr disk read | 17 | 100.0 | |||||||
| gc cr failure | 3 | 100.0 | |||||||
| gc cr grant 2-way | 101.3K | 89.9 | 8.1 | 1.6 | .3 | .0 | .0 | .0 | |
| gc cr grant congested | 1251 | 65.8 | 23.3 | 7.1 | 3.4 | .2 | .1 | .2 | |
| gc cr multi block request | 915K | 28.1 | 49.7 | 15.5 | 6.4 | .2 | .0 | .0 | |
| gc current block 2-way | 274.6K | 85.1 | 11.8 | 2.5 | .6 | .0 | .0 | .0 | |
| gc current block busy | 20.5K | 5.7 | 12.5 | 16.0 | 19.1 | 17.9 | 12.2 | 16.6 | .0 |
| gc current block congested | 3122 | 54.8 | 21.1 | 13.4 | 9.8 | .6 | .1 | .2 | |
| gc current grant 2-way | 14.2K | 87.4 | 10.0 | 2.0 | .5 | .1 | .0 | .0 | |
| gc current grant busy | 20.4K | 84.3 | 12.5 | 2.4 | .6 | .2 | .0 | .0 | |
| gc current grant congested | 196 | 57.1 | 30.1 | 9.2 | 2.6 | .5 | .5 | ||
| gc current multi block request | 1432 | 60.6 | 32.8 | 5.9 | .5 | .1 | |||
| gc current retry | 9 | 66.7 | 22.2 | 11.1 | |||||
| gc object scan | 22.5K | 100.0 | |||||||
| gc quiesce | 1 | 100.0 | |||||||
| gc remaster | 66 | 12.1 | 1.5 | 4.5 | 16.7 | 21.2 | 43.9 | ||
| gcs drm freeze in enter server mode | 186 | 19.9 | .5 | .5 | 79.0 | ||||
| gcs log flush sync | 71.5K | 39.6 | 15.5 | 15.1 | 14.3 | 15.6 | .0 | ||
| ges DFS hang analysis phase 2 acks | 1 | 100.0 | |||||||
| ges LMON to get to FTDONE | 24 | 4.2 | 83.3 | 12.5 | |||||
| ges generic event | 45 | 2.2 | 97.8 | ||||||
| ges inquiry response | 2 | 100.0 | |||||||
| ges lms sync during dynamic remastering and reconfig | 600 | 1.2 | 5.0 | 3.3 | 31.5 | 15.5 | 43.5 | ||
| ges2 LMON to wake up LMD - mrcvr | 36 | 100.0 | |||||||
| global enqueue expand wait | 54 | 100.0 | |||||||
| kfk: async disk IO | 208 | 59.1 | 16.3 | 13.5 | 6.7 | 1.9 | 2.4 | ||
| kjbdrmcvtq lmon drm quiesce: ping completion | 43 | 62.8 | 4.7 | 4.7 | 4.7 | 9.3 | 4.7 | 9.3 | |
| kjctssqmg: quick message send wait | 64 | 100.0 | |||||||
| kksfbc child completion | 209 | 4.8 | 95.2 | ||||||
| ksxr poll remote instances | 147.3K | 100.0 | |||||||
| latch free | 1193 | 37.5 | .3 | 38.8 | 22.6 | .8 | |||
| latch: active service list | 513 | 99.8 | .2 | ||||||
| latch: cache buffer handles | 5 | 20.0 | 80.0 | ||||||
| latch: cache buffers chains | 10.9K | 99.9 | .1 | .0 | |||||
| latch: cache buffers lru chain | 568 | 99.1 | .9 | ||||||
| latch: call allocation | 2357 | 99.6 | .4 | ||||||
| latch: enqueue hash chains | 34 | 97.1 | 2.9 | ||||||
| latch: gc element | 3459 | 93.9 | 4.5 | 1.3 | .2 | .1 | |||
| latch: gcs resource hash | 827 | 99.3 | .5 | .1 | .1 | ||||
| latch: ges resource hash list | 1019 | 99.6 | .3 | .1 | |||||
| latch: messages | 10 | 100.0 | |||||||
| latch: object queue header operation | 6144 | 99.6 | .3 | .1 | |||||
| latch: redo allocation | 20 | 100.0 | |||||||
| latch: redo writing | 10 | 100.0 | |||||||
| latch: row cache objects | 2099 | 99.6 | .4 | ||||||
| latch: shared pool | 13K | 97.9 | 1.9 | .1 | .0 | .0 | |||
| latch: undo global data | 1 | 100.0 | |||||||
| libcache interrupt action by LCK | 153.2K | 100.0 | .0 | ||||||
| library cache load lock | 561 | 91.6 | .4 | .2 | 7.5 | .4 | |||
| library cache lock | 2865 | 69.1 | 11.5 | 16.0 | 2.5 | .8 | .1 | ||
| library cache pin | 4135 | 90.4 | 7.0 | 2.1 | .5 | .0 | |||
| library cache: mutex X | 62.6K | 74.8 | .3 | .0 | 23.1 | 1.7 | .2 | ||
| local write wait | 126 | 24.6 | 46.0 | 16.7 | 7.1 | 5.6 | |||
| lock escalate retry | 1 | 100.0 | |||||||
| log file parallel write | 582.5K | 52.3 | 12.1 | 12.9 | 11.6 | 6.3 | 3.2 | 1.5 | |
| log file sequential read | 1580 | 36.8 | 12.7 | 11.8 | 14.2 | 12.1 | 7.8 | 4.5 | |
| log file single write | 276 | 69.6 | 7.6 | 11.2 | 5.8 | 3.3 | 1.8 | .7 | |
| log file switch (checkpoint incomplete) | 1192 | 2.5 | 6.5 | 58.6 | 32.4 | ||||
| log file switch completion | 187 | 2.7 | 11.2 | 86.1 | |||||
| log file sync | 579.7K | 5.9 | 18.2 | 17.5 | 19.6 | 19.6 | 11.9 | 7.2 | |
| os thread startup | 458 | 59.0 | 41.0 | ||||||
| rdbms ipc reply | 5 | 60.0 | 20.0 | 20.0 | |||||
| read by other session | 54.4K | 36.7 | 17.0 | 11.8 | 12.4 | 13.3 | 6.3 | 2.6 | |
| reliable message | 1659 | 77.2 | 9.0 | 3.4 | .4 | .5 | 1.1 | 8.4 | |
| row cache cleanup | 193.9K | 100.0 | .0 | .0 | |||||
| row cache lock | 32.8K | 93.6 | 5.4 | .8 | .1 | .0 | .0 | .0 | |
| row cache process | 280.4K | 100.0 | .0 | ||||||
| wait for scn ack | 8 | 12.5 | 12.5 | 37.5 | 25.0 | 12.5 | |||
| wait list latch free | 2 | 100.0 | |||||||
| write complete waits | 3 | 33.3 | 66.7 | ||||||
| ASM background timer | 3814 | 28.8 | 1.3 | 2.8 | 2.0 | 1.5 | 1.6 | 4.5 | 57.5 |
| DIAG idle wait | 5263.8K | .7 | 87.4 | 8.4 | .1 | .6 | 1.4 | 1.4 | |
| GCR sleep | 2162 | 100.0 | |||||||
| JOX Jit Process Sleep | 98 | 7.1 | 92.9 | ||||||
| KSV master wait | 14.4K | 97.2 | 1.1 | .5 | .5 | .1 | .3 | .1 | .0 |
| PING | 4135 | 78.4 | .8 | .3 | .1 | .0 | 20.5 | ||
| PX Deq: Execute Reply | 120 | 57.5 | 9.2 | 32.5 | .8 | ||||
| PX Deq: Execution Msg | 372 | 65.3 | 10.5 | 8.9 | 3.2 | 8.3 | 3.8 | ||
| PX Deq: Join ACK | 120 | 48.3 | 13.3 | 16.7 | 6.7 | 11.7 | 3.3 | ||
| PX Deq: Parse Reply | 120 | 51.7 | 7.5 | 5.8 | 8.3 | 17.5 | 9.2 | ||
| PX Idle Wait | 93 | 1.1 | 12.9 | 4.3 | 1.1 | 80.6 | |||
| SQL*Net message from client | 34.6M | 85.7 | 9.0 | 1.5 | .5 | .2 | .3 | 2.4 | .5 |
| Space Manager: slave idle wait | 3458 | .0 | .5 | 99.5 | |||||
| Streams AQ: RAC qmn coordinator idle wait | 763 | 100.0 | |||||||
| Streams AQ: qmn coordinator idle wait | 754 | 49.9 | 50.1 | ||||||
| Streams AQ: qmn slave idle wait | 385 | .3 | 99.7 | ||||||
| Streams AQ: waiting for time management or cleanup tasks | 147 | 32.7 | 32.0 | 35.4 | |||||
| class slave wait | 19.9K | 34.9 | 10.2 | 15.4 | 14.5 | 8.8 | 5.5 | 7.4 | 3.2 |
| dispatcher timer | 180 | 100.0 | |||||||
| gcs remote message | 8418.4K | 27.5 | 14.3 | 11.3 | 12.7 | 34.2 | .0 | ||
| ges remote message | 323.2K | 53.0 | 5.5 | 3.1 | 2.3 | 1.9 | 1.6 | 32.7 | |
| heartbeat monitor sleep | 93 | 86.0 | 10.8 | 3.2 | |||||
| jobq slave wait | 117.1K | .0 | .0 | .0 | .0 | .0 | .0 | 99.9 | |
| pmon timer | 4043 | 2.5 | .3 | .6 | 1.0 | .8 | 1.3 | 3.9 | 89.6 |
| rdbms ipc message | 1267.9K | 48.1 | 5.0 | 5.7 | 6.9 | 7.3 | 5.4 | 15.7 | 6.0 |
| shared server idle wait | 361 | 100.0 | |||||||
| smon timer | 64 | 3.1 | 14.1 | 82.8 | |||||
| wait for unread message on broadcast channel | 21.6K | 100.0 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
| ASM file metadata operation | 22 | 99.7 | .3 | .0 | |||||
| DFS lock handle | 14 | 100.0 | .0 | .0 | |||||
| Data file init write | 238 | 99.0 | .7 | .2 | .1 | ||||
| Disk file operations I/O | 1 | 100.0 | .0 | ||||||
| JS kgl get object wait | 1 | 100.0 | |||||||
| RMAN backup & recovery I/O | 3 | 99.1 | .9 | ||||||
| SQL*Net break/reset to client | 1 | 100.0 | .0 | ||||||
| SQL*Net more data from client | 1 | 100.0 | .0 | ||||||
| buffer busy waits | 144 | 99.3 | .0 | .0 | .1 | .2 | .1 | .2 | .0 |
| control file parallel write | 136 | 98.0 | 1.5 | .4 | .1 | ||||
| control file sequential read | 802 | 99.0 | .8 | .2 | .0 | .0 | |||
| cursor: pin S wait on X | 2 | 100.0 | .0 | ||||||
| db file parallel read | 94.2K | 73.5 | 12.8 | 9.5 | 3.7 | .5 | .1 | .0 | |
| db file parallel write | 789 | 97.4 | 1.4 | 1.1 | .1 | ||||
| db file scattered read | 105K | 95.4 | 3.7 | .8 | .1 | .0 | .0 | ||
| db file sequential read | 12.6K | 97.7 | 1.8 | .5 | .0 | .0 | .0 | ||
| direct path read | 19 | 92.6 | 2.7 | 3.5 | 1.2 | ||||
| direct path write | 2 | 98.4 | 1.6 | ||||||
| direct path write temp | 196 | 97.4 | 2.0 | .5 | .0 | ||||
| enq: CF - contention | 44 | 88.8 | 6.4 | 3.1 | 1.8 | ||||
| enq: FB - contention | 1 | 99.9 | .1 | ||||||
| enq: HW - contention | 6 | 99.3 | .7 | ||||||
| enq: MS - contention | 156 | 94.7 | 2.9 | 1.8 | .6 | ||||
| enq: TM - contention | 1 | 95.8 | 4.2 | ||||||
| enq: TX - row lock contention | 6 | 99.2 | .7 | .1 | |||||
| enq: WF - contention | 3 | 93.9 | 2.0 | 4.1 | |||||
| gc buffer busy acquire | 3624 | 84.7 | 7.2 | 5.3 | 2.0 | .4 | .2 | .2 | .0 |
| gc buffer busy release | 1679 | 77.3 | 12.6 | 6.3 | 2.0 | .6 | .7 | .3 | .1 |
| gc cr block 2-way | 10 | 100.0 | .0 | .0 | .0 | ||||
| gc cr block busy | 258 | 81.5 | 10.6 | 5.2 | 2.5 | .2 | |||
| gc cr block congested | 1 | 99.9 | .1 | ||||||
| gc cr grant 2-way | 14 | 100.0 | .0 | .0 | |||||
| gc cr grant congested | 2 | 99.8 | .1 | .1 | |||||
| gc cr multi block request | 141 | 100.0 | .0 | .0 | .0 | .0 | .0 | ||
| gc current block 2-way | 38 | 100.0 | .0 | .0 | |||||
| gc current block busy | 3401 | 83.4 | 9.0 | 5.5 | 1.8 | .2 | .0 | .0 | .0 |
| gc current block congested | 5 | 99.8 | .1 | .1 | |||||
| gc current grant 2-way | 7 | 100.0 | .0 | .0 | |||||
| gc current grant busy | 9 | 100.0 | .0 | ||||||
| gc current grant congested | 1 | 99.5 | .5 | ||||||
| gc current multi block request | 2 | 99.9 | .1 | ||||||
| gc remaster | 29 | 56.1 | 19.7 | 15.2 | 9.1 | ||||
| gcs drm freeze in enter server mode | 147 | 21.0 | 3.2 | 12.4 | 28.0 | 35.5 | |||
| ges LMON to get to FTDONE | 3 | 87.5 | 4.2 | 8.3 | |||||
| ges lms sync during dynamic remastering and reconfig | 261 | 56.5 | 19.8 | 23.7 | |||||
| kjbdrmcvtq lmon drm quiesce: ping completion | 4 | 90.7 | 9.3 | ||||||
| kksfbc child completion | 199 | 4.8 | 95.2 | ||||||
| latch: ges resource hash list | 1 | 99.9 | .1 | ||||||
| library cache lock | 2 | 99.9 | .1 | ||||||
| library cache: mutex X | 118 | 99.8 | .2 | .0 | |||||
| log file parallel write | 8714 | 98.5 | 1.2 | .3 | .0 | .0 | |||
| log file sequential read | 71 | 95.5 | 3.8 | .6 | .1 | ||||
| log file single write | 2 | 99.3 | .7 | ||||||
| log file switch (checkpoint incomplete) | 1019 | 9.0 | 4.3 | 4.6 | 8.2 | 22.1 | 19.5 | 26.8 | 5.5 |
| log file switch completion | 161 | 13.9 | 2.7 | 83.4 | |||||
| log file sync | 41.8K | 92.8 | 5.3 | 1.6 | .3 | .0 | |||
| read by other session | 1410 | 97.4 | 2.2 | .4 | .0 | .0 | .0 | ||
| reliable message | 140 | 91.6 | .5 | .2 | .7 | .6 | 6.4 | ||
| row cache lock | 1 | 100.0 | .0 | ||||||
| write complete waits | 2 | 33.3 | 66.7 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
| ASM file metadata operation | 1 | 100.0 | .0 | ||||||
| Streams AQ: qmn coordinator waiting for slave to start | 2 | 100.0 | |||||||
| buffer busy waits | 2 | 100.0 | .0 | ||||||
| gc buffer busy acquire | 3 | 100.0 | .0 | ||||||
| gc buffer busy release | 11 | 99.9 | .1 | ||||||
| gc current block busy | 1 | 100.0 | .0 | ||||||
| log file switch (checkpoint incomplete) | 66 | 94.5 | 5.5 |
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|---|---|---|---|
| SYS$USERS | 72,342 | 7,502 | 125,561 | 304,770 |
| tyqxdb | 16,995 | 8,960 | 143 | 356,890 |
| SYS$BACKGROUND | 0 | 0 | 5 | 600 |
| tyqxdbXDB | 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 |
|---|---|---|---|---|---|---|---|---|
| SYS$USERS | 3138113 | 30889 | 40034 | 36 | 1 | 0 | 2178 | 0 |
| tyqxdb | 216053 | 1009 | 102478 | 305 | 0 | 0 | 34325542 | 40 |
| SYS$BACKGROUND | 5593 | 45 | 166640 | 17 | 0 | 0 | 0 | 0 |
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 8,150.58 | 251 | 32.47 | 9.13 | 16.93 | 80.33 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 7,922.11 | 167 | 47.44 | 8.87 | 19.28 | 77.66 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 5,770.52 | 137 | 42.12 | 6.46 | 14.60 | 81.90 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 5,181.90 | 105 | 49.35 | 5.80 | 17.52 | 78.11 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 5,069.46 | 95 | 53.36 | 5.68 | 21.17 | 76.27 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 4,722.36 | 112 | 42.16 | 5.29 | 20.34 | 75.38 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 4,347.02 | 135 | 32.20 | 4.87 | 20.56 | 78.21 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 3,747.15 | 93 | 40.29 | 4.20 | 17.92 | 77.11 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 3,628.61 | 107 | 33.91 | 4.06 | 18.88 | 78.36 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 3,237.24 | 83 | 39.00 | 3.63 | 16.50 | 81.25 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 3,203.02 | 82 | 39.06 | 3.59 | 13.03 | 84.33 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 3,113.29 | 69 | 45.12 | 3.49 | 14.83 | 81.48 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,973.14 | 100 | 29.73 | 3.33 | 17.10 | 81.27 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,269.44 | 117 | 19.40 | 2.54 | 14.59 | 82.38 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 1,879.90 | 6 | 313.32 | 2.11 | 12.10 | 84.09 | 9d0bgdv1q2gqz | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,872.20 | 62 | 30.20 | 2.10 | 15.21 | 82.64 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 1,016.33 | 117 | 8.69 | 1.14 | 13.29 | 83.03 | 7jrvd7hwqsp2z | DECLARE job BINARY_INTEGER := ... | |
| 1,005.70 | 53,656 | 0.02 | 1.13 | 101.12 | 0.03 | a72tfu60rqjn9 | sqlproxy_svr@localhost (TNS V1-V3) | select ext_val_id, res_id, re... |
| 1,004.93 | 122 | 8.24 | 1.13 | 12.59 | 83.17 | 9gr21c020pw5g | DECLARE job BINARY_INTEGER := ... |
| CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 1,527.36 | 167 | 9.15 | 9.28 | 7,922.11 | 19.28 | 77.66 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,380.22 | 251 | 5.50 | 8.39 | 8,150.58 | 16.93 | 80.33 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,073.19 | 95 | 11.30 | 6.52 | 5,069.46 | 21.17 | 76.27 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 1,017.00 | 53,656 | 0.02 | 6.18 | 1,005.70 | 101.12 | 0.03 | a72tfu60rqjn9 | sqlproxy_svr@localhost (TNS V1-V3) | select ext_val_id, res_id, re... |
| 960.59 | 112 | 8.58 | 5.84 | 4,722.36 | 20.34 | 75.38 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 907.62 | 105 | 8.64 | 5.52 | 5,181.90 | 17.52 | 78.11 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 893.88 | 135 | 6.62 | 5.43 | 4,347.02 | 20.56 | 78.21 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 842.45 | 137 | 6.15 | 5.12 | 5,770.52 | 14.60 | 81.90 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 685.19 | 107 | 6.40 | 4.16 | 3,628.61 | 18.88 | 78.36 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 671.40 | 93 | 7.22 | 4.08 | 3,747.15 | 17.92 | 77.11 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 534.21 | 83 | 6.44 | 3.25 | 3,237.24 | 16.50 | 81.25 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 508.33 | 100 | 5.08 | 3.09 | 2,973.14 | 17.10 | 81.27 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 461.82 | 69 | 6.69 | 2.81 | 3,113.29 | 14.83 | 81.48 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 417.44 | 82 | 5.09 | 2.54 | 3,203.02 | 13.03 | 84.33 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 391.56 | 233 | 1.68 | 2.38 | 402.16 | 97.36 | 0.58 | a4qx62v2p9cm4 | /* MV_REFRESH (INS) */ INSERT ... | |
| 355.89 | 190 | 1.87 | 2.16 | 405.88 | 87.68 | 9.89 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 340.27 | 161 | 2.11 | 2.07 | 427.33 | 79.63 | 17.75 | 9ya4tc409vxy9 | DECLARE job BINARY_INTEGER := ... | |
| 331.02 | 117 | 2.83 | 2.01 | 2,269.44 | 14.59 | 82.38 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 319.18 | 145 | 2.20 | 1.94 | 332.75 | 95.92 | 3.83 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 304.75 | 245,529 | 0.00 | 1.85 | 304.33 | 100.14 | 0.01 | 0yzw7gaxkauwx | sqlproxy_svr@localhost (TNS V1-V3) | select ID as id, RES_ID as re... |
| 284.84 | 62 | 4.59 | 1.73 | 1,872.20 | 15.21 | 82.64 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 260.50 | 171 | 1.52 | 1.58 | 266.07 | 97.91 | 1.65 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 250.22 | 195 | 1.28 | 1.52 | 254.23 | 98.42 | 1.21 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 227.44 | 6 | 37.91 | 1.38 | 1,879.90 | 12.10 | 84.09 | 9d0bgdv1q2gqz | /* MV_REFRESH (DEL) */ DELETE ... |
| User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 6,547.55 | 251 | 26.09 | 20.50 | 8,150.58 | 16.93 | 80.33 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 6,152.18 | 167 | 36.84 | 19.26 | 7,922.11 | 19.28 | 77.66 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 4,725.82 | 137 | 34.50 | 14.80 | 5,770.52 | 14.60 | 81.90 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 4,047.69 | 105 | 38.55 | 12.67 | 5,181.90 | 17.52 | 78.11 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 3,866.28 | 95 | 40.70 | 12.10 | 5,069.46 | 21.17 | 76.27 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 3,559.89 | 112 | 31.78 | 11.15 | 4,722.36 | 20.34 | 75.38 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 3,400.02 | 135 | 25.19 | 10.65 | 4,347.02 | 20.56 | 78.21 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 2,889.40 | 93 | 31.07 | 9.05 | 3,747.15 | 17.92 | 77.11 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 2,843.24 | 107 | 26.57 | 8.90 | 3,628.61 | 18.88 | 78.36 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 2,701.26 | 82 | 32.94 | 8.46 | 3,203.02 | 13.03 | 84.33 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 2,630.23 | 83 | 31.69 | 8.23 | 3,237.24 | 16.50 | 81.25 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,536.68 | 69 | 36.76 | 7.94 | 3,113.29 | 14.83 | 81.48 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,416.21 | 100 | 24.16 | 7.56 | 2,973.14 | 17.10 | 81.27 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,869.58 | 117 | 15.98 | 5.85 | 2,269.44 | 14.59 | 82.38 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 1,580.81 | 6 | 263.47 | 4.95 | 1,879.90 | 12.10 | 84.09 | 9d0bgdv1q2gqz | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,547.21 | 62 | 24.95 | 4.84 | 1,872.20 | 15.21 | 82.64 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 843.85 | 117 | 7.21 | 2.64 | 1,016.33 | 13.29 | 83.03 | 7jrvd7hwqsp2z | DECLARE job BINARY_INTEGER := ... | |
| 835.77 | 122 | 6.85 | 2.62 | 1,004.93 | 12.59 | 83.17 | 9gr21c020pw5g | DECLARE job BINARY_INTEGER := ... | |
| 691.08 | 6 | 115.18 | 2.16 | 795.62 | 11.30 | 86.86 | g9bc6f79yswt0 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 496.03 | 8 | 62.00 | 1.55 | 575.60 | 10.36 | 86.18 | 7dv6rj97jqhuf | /* MV_REFRESH (DEL) */ DELETE ... | |
| 430.03 | 3 | 143.34 | 1.35 | 499.12 | 10.41 | 86.16 | 3ff8gx20bt87z | /* MV_REFRESH (DEL) */ DELETE ... | |
| 424.14 | 98 | 4.33 | 1.33 | 498.32 | 14.51 | 85.11 | bwb00my8gpq7a | DECLARE job BINARY_INTEGER := ... | |
| 394.45 | 11 | 35.86 | 1.23 | 465.68 | 13.55 | 84.70 | 6xx2shsjwg3fm | /* MV_REFRESH (DEL) */ DELETE ... | |
| 367.92 | 119 | 3.09 | 1.15 | 474.87 | 14.77 | 77.48 | a76w6qhuyuxm6 | DECLARE job BINARY_INTEGER := ... | |
| 356.85 | 11 | 32.44 | 1.12 | 379.23 | 6.34 | 94.10 | d829zjyhbw3z2 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 330.70 | 7 | 47.24 | 1.04 | 382.73 | 10.98 | 86.41 | 36c9sur4dv7c5 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 327.09 | 6 | 54.51 | 1.02 | 381.50 | 10.85 | 85.74 | awsxgwh4dk95q | /* MV_REFRESH (DEL) */ DELETE ... |
| Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 120,694,876 | 53,656 | 2,249.42 | 18.23 | 1,005.70 | 101.1 | 0 | a72tfu60rqjn9 | sqlproxy_svr@localhost (TNS V1-V3) | select ext_val_id, res_id, re... |
| 42,193,752 | 112 | 376,729.93 | 6.37 | 4,722.36 | 20.3 | 75.4 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 41,413,589 | 167 | 247,985.56 | 6.25 | 7,922.11 | 19.3 | 77.7 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 38,816,440 | 135 | 287,529.19 | 5.86 | 4,347.02 | 20.6 | 78.2 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 38,230,587 | 251 | 152,313.10 | 5.77 | 8,150.58 | 16.9 | 80.3 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 36,524,649 | 245,529 | 148.76 | 5.52 | 304.33 | 100.1 | 0 | 0yzw7gaxkauwx | sqlproxy_svr@localhost (TNS V1-V3) | select ID as id, RES_ID as re... |
| 36,055,419 | 95 | 379,530.73 | 5.45 | 5,069.46 | 21.2 | 76.3 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 33,239,831 | 105 | 316,569.82 | 5.02 | 5,181.90 | 17.5 | 78.1 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 32,212,275 | 233 | 138,250.11 | 4.87 | 402.16 | 97.4 | .6 | a4qx62v2p9cm4 | /* MV_REFRESH (INS) */ INSERT ... | |
| 31,787,209 | 161 | 197,436.08 | 4.80 | 427.33 | 79.6 | 17.7 | 9ya4tc409vxy9 | DECLARE job BINARY_INTEGER := ... | |
| 30,649,398 | 190 | 161,312.62 | 4.63 | 405.88 | 87.7 | 9.9 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 26,300,780 | 107 | 245,801.68 | 3.97 | 3,628.61 | 18.9 | 78.4 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 24,347,997 | 93 | 261,806.42 | 3.68 | 3,747.15 | 17.9 | 77.1 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 21,916,479 | 137 | 159,974.30 | 3.31 | 5,770.52 | 14.6 | 81.9 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 20,971,746 | 152 | 137,972.01 | 3.17 | 115.13 | 99.8 | 0 | 9pvhw3fqf20zp | select count(1) from Isc_User ... | |
| 20,970,179 | 152 | 137,961.70 | 3.17 | 134.53 | 93.6 | 6.3 | 4cwwqg2vry71m | select * from ( select u.id id... | |
| 16,936,933 | 195 | 86,856.07 | 2.56 | 254.23 | 98.4 | 1.2 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 16,507,672 | 100 | 165,076.72 | 2.49 | 2,973.14 | 17.1 | 81.3 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 16,391,939 | 83 | 197,493.24 | 2.48 | 3,237.24 | 16.5 | 81.2 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 15,995,958 | 171 | 93,543.61 | 2.42 | 266.07 | 97.9 | 1.7 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 14,024,184 | 82 | 171,026.63 | 2.12 | 3,203.02 | 13 | 84.3 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 13,640,759 | 145 | 94,074.20 | 2.06 | 332.75 | 95.9 | 3.8 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 13,046,528 | 69 | 189,080.12 | 1.97 | 3,113.29 | 14.8 | 81.5 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 12,125,602 | 1,526 | 7,946.00 | 1.83 | 116.08 | 96.1 | .6 | 89p0z887n3p2f | JDBC Thin Client | select distinct t.USER_ID from... |
| 11,235,920 | 117 | 96,033.50 | 1.70 | 2,269.44 | 14.6 | 82.4 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 10,040,812 | 132 | 76,066.76 | 1.52 | 147.28 | 98.8 | .9 | aq0p7pd7k1z5y | /* MV_REFRESH (INS) */ INSERT ... | |
| 9,505,903 | 62 | 153,321.02 | 1.44 | 1,872.20 | 15.2 | 82.6 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 7,081,712 | 891 | 7,948.05 | 1.07 | 69.65 | 94.4 | .7 | au7p061bpfmnf | JDBC Thin Client | update SAS_STATISTICS_DAY_LOGI... |
| 6,735,640 | 76 | 88,626.84 | 1.02 | 99.33 | 98.7 | 1 | 6fqrrgy93rc1p | /* MV_REFRESH (INS) */ INSERT ... |
| Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 35,300,117 | 167 | 211,377.95 | 28.10 | 7,922.11 | 19.28 | 77.66 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 30,853,809 | 251 | 122,923.54 | 24.56 | 8,150.58 | 16.93 | 80.33 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 19,739,697 | 95 | 207,786.28 | 15.72 | 5,069.46 | 21.17 | 76.27 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 19,172,039 | 135 | 142,015.10 | 15.26 | 4,347.02 | 20.56 | 78.21 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 17,649,775 | 112 | 157,587.28 | 14.05 | 4,722.36 | 20.34 | 75.38 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 16,942,225 | 137 | 123,665.88 | 13.49 | 5,770.52 | 14.60 | 81.90 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 15,298,695 | 105 | 145,701.86 | 12.18 | 5,181.90 | 17.52 | 78.11 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 14,210,812 | 100 | 142,108.12 | 11.31 | 2,973.14 | 17.10 | 81.27 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 14,021,057 | 83 | 168,928.40 | 11.16 | 3,237.24 | 16.50 | 81.25 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 11,973,528 | 107 | 111,902.13 | 9.53 | 3,628.61 | 18.88 | 78.36 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 10,502,053 | 82 | 128,073.82 | 8.36 | 3,203.02 | 13.03 | 84.33 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 10,246,670 | 93 | 110,179.25 | 8.16 | 3,747.15 | 17.92 | 77.11 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 10,216,459 | 69 | 148,064.62 | 8.13 | 3,113.29 | 14.83 | 81.48 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 6,988,822 | 117 | 59,733.52 | 5.56 | 2,269.44 | 14.59 | 82.38 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 6,851,617 | 62 | 110,509.95 | 5.45 | 1,872.20 | 15.21 | 82.64 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 6,075,279 | 6 | 1,012,546.50 | 4.84 | 1,879.90 | 12.10 | 84.09 | 9d0bgdv1q2gqz | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,490,140 | 6 | 415,023.33 | 1.98 | 795.62 | 11.30 | 86.86 | g9bc6f79yswt0 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,181,932 | 117 | 18,648.99 | 1.74 | 1,016.33 | 13.29 | 83.03 | 7jrvd7hwqsp2z | DECLARE job BINARY_INTEGER := ... | |
| 1,789,368 | 122 | 14,666.95 | 1.42 | 1,004.93 | 12.59 | 83.17 | 9gr21c020pw5g | DECLARE job BINARY_INTEGER := ... | |
| 1,582,192 | 11 | 143,835.64 | 1.26 | 465.68 | 13.55 | 84.70 | 6xx2shsjwg3fm | /* MV_REFRESH (DEL) */ DELETE ... |
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 3,958,250 | 3,958,250 | 95 | 41,665.79 | 0.00 | 16.58 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 3,547,138 | 3,547,138 | 112 | 31,670.88 | 0.00 | 14.86 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 3,236,812 | 3,236,812 | 107 | 30,250.58 | 0.00 | 13.56 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 3,098,400 | 3,098,400 | 105 | 29,508.57 | 0.00 | 12.98 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 2,605,153 | 2,605,153 | 93 | 28,012.40 | 0.00 | 10.91 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 1,968,760 | 1,968,760 | 135 | 14,583.41 | 0.00 | 8.25 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 1,865,220 | 1,865,220 | 82 | 22,746.59 | 0.00 | 7.81 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 992,970 | 992,970 | 117 | 8,486.92 | 0.00 | 4.16 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 786,671 | 786,671 | 62 | 12,688.24 | 0.00 | 3.30 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 568,400 | 568,400 | 117 | 4,858.12 | 0.00 | 2.38 | 7jrvd7hwqsp2z | DECLARE job BINARY_INTEGER := ... | |
| 343,729 | 343,729 | 122 | 2,817.45 | 0.00 | 1.44 | 9gr21c020pw5g | DECLARE job BINARY_INTEGER := ... |
| Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 253,379 | 405,002 | 1.60 | 36.94 | 98.7 | 0 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
| 245,529 | 5,715,143 | 23.28 | 304.33 | 100.1 | 0 | 0yzw7gaxkauwx | sqlproxy_svr@localhost (TNS V1-V3) | select ID as id, RES_ID as re... |
| 103,577 | 103,538 | 1.00 | 7.64 | 97.1 | 0 | 520mkxqpf15q8 | select 1 from dual | |
| 77,863 | 77,841 | 1.00 | 15.62 | 97.1 | 0 | 0uj9hp1fj5xaa | select iscuser0_.ID as ID32_, ... | |
| 77,467 | 0 | 0.00 | 3.35 | 98 | 0 | cjaa80k1hvpc1 | select 1 from sys.cdc_change_t... | |
| 73,347 | 253,546 | 3.46 | 32.33 | 97.9 | 0 | 0k8522rmdzg4k | select privilege# from sysauth... | |
| 72,240 | 72,236 | 1.00 | 19.04 | 96.4 | 0 | 459f3z9u4fb3u | select value$ from props$ wher... | |
| 69,046 | 69,028 | 1.00 | 31.89 | 87.8 | 0 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
| 69,034 | 69,033 | 1.00 | 715.71 | 8.6 | .9 | f711myt0q6cma | insert into sys.aud$( sessioni... | |
| 69,023 | 69,034 | 1.00 | 16.65 | 88.3 | 0 | 5ur69atw3vfhj | select decode(failover_method,... | |
| 53,656 | 19,081,955 | 355.64 | 1,005.70 | 101.1 | 0 | a72tfu60rqjn9 | sqlproxy_svr@localhost (TNS V1-V3) | select ext_val_id, res_id, re... |
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 73,347 | 73,347 | 4.50 | 0k8522rmdzg4k | select privilege# from sysauth... | |
| 73,347 | 253,379 | 4.50 | cm5vu20fhtnq1 | select /*+ connect_by_filterin... | |
| 72,241 | 72,240 | 4.43 | 459f3z9u4fb3u | select value$ from props$ wher... | |
| 69,055 | 69,046 | 4.23 | 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', ... | |
| 69,053 | 69,023 | 4.23 | 5ur69atw3vfhj | select decode(failover_method,... | |
| 69,026 | 69,034 | 4.23 | f711myt0q6cma | insert into sys.aud$( sessioni... | |
| 29,748 | 103,577 | 1.82 | 520mkxqpf15q8 | select 1 from dual | |
| 13,731 | 77,863 | 0.84 | 0uj9hp1fj5xaa | select iscuser0_.ID as ID32_, ... | |
| 8,241 | 12,365 | 0.51 | 4yvsj6a508pgf | SELECT NAME FROM SYS.USER$ WHE... | |
| 8,234 | 8,233 | 0.50 | cn51n9wumt7pz | select sysdate+(1/1440) from d... |
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 19,128,637 | 145 | 0.31 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 14,049,056 | 195 | 0.23 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 13,779,464 | 190 | 0.22 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 10,942,434 | 171 | 0.18 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 6,660,588 | 132 | 0.11 | aq0p7pd7k1z5y | /* MV_REFRESH (INS) */ INSERT ... | |
| 6,566,479 | 76 | 0.11 | 6fqrrgy93rc1p | /* MV_REFRESH (INS) */ INSERT ... | |
| 5,783,108 | 61 | 0.09 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 5,522,185 | 48 | 0.09 | 51usvbqthqjam | /* MV_REFRESH (INS) */ INSERT ... | |
| 5,269,315 | 41 | 0.08 | d9y2s2fzjp3qh | /* MV_REFRESH (INS) */ INSERT ... | |
| 4,766,432 | 38 | 0.08 | 1pc3w08xhpf6w | /* MV_REFRESH (INS) */ INSERT ... | |
| 4,005,771 | 29 | 0.06 | ac4h67wt6ku2v | /* MV_REFRESH (INS) */ INSERT ... | |
| 3,629,578 | 167 | 0.06 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 3,601,776 | 34 | 0.06 | c2gft4scabjzk | /* MV_REFRESH (INS) */ INSERT ... | |
| 3,569,207 | 24 | 0.06 | fs8sw662j161s | /* MV_REFRESH (INS) */ INSERT ... | |
| 3,559,435 | 92 | 0.06 | 2q6v017yvanxu | /* MV_REFRESH (INS) */ INSERT ... | |
| 3,307,561 | 251 | 0.05 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 3,055,308 | 25 | 0.05 | 36xr6u2nrfnww | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,909,889 | 137 | 0.05 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 2,895,548 | 97 | 0.05 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,871,760 | 23 | 0.05 | 8u56kwk9nu9b6 | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,686,301 | 54 | 0.04 | 6ncg8jrztww8x | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,367,796 | 56 | 0.04 | g26t1kwgzbm9p | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,313,202 | 20 | 0.04 | 726ddwmdshgyy | /* MV_REFRESH (INS) */ INSERT ... | |
| 2,025,884 | 97 | 0.03 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,708,132 | 56 | 0.03 | g26t1kwgzbm9p | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,663,677 | 145 | 0.03 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,478,436 | 61 | 0.02 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,453,596 | 25 | 0.02 | 36xr6u2nrfnww | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,452,483 | 41 | 0.02 | d9y2s2fzjp3qh | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,447,548 | 237 | 0.02 | c2pmtb0umq4vk | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,423,958 | 83 | 0.02 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,410,283 | 29 | 0.02 | ac4h67wt6ku2v | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,337,612 | 61 | 0.02 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,328,477 | 69 | 0.02 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1,195,088 | 23 | 0.02 | 8u56kwk9nu9b6 | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,181,578 | 171 | 0.02 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 1,050,059 | 41 | 0.02 | d9y2s2fzjp3qh | /* MV_REFRESH (INS) */ INSERT ... |
| Version Count | Executions | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|
| 99 | 6 | awsxgwh4dk95q | /* MV_REFRESH (DEL) */ DELETE ... | |
| 99 | 171 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 99 | 171 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 94 | 7 | 36c9sur4dv7c5 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 93 | 11 | 6xx2shsjwg3fm | /* MV_REFRESH (DEL) */ DELETE ... | |
| 92 | 145 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 92 | 145 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 88 | 137 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 88 | 137 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 86 | 38 | 1pc3w08xhpf6w | /* MV_REFRESH (INS) */ INSERT ... | |
| 86 | 97 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 86 | 97 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 86 | 97 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 84 | 30,983 | 2vnzfjzg6px33 | select log, oldest, oldest_pk,... | |
| 81 | 69 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 81 | 69 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 81 | 11 | d829zjyhbw3z2 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 79 | 29 | ac4h67wt6ku2v | /* MV_REFRESH (INS) */ INSERT ... | |
| 79 | 29 | ac4h67wt6ku2v | /* MV_REFRESH (INS) */ INSERT ... | |
| 76 | 195 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 76 | 195 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 75 | 34 | c2gft4scabjzk | /* MV_REFRESH (INS) */ INSERT ... | |
| 75 | 34 | c2gft4scabjzk | /* MV_REFRESH (INS) */ INSERT ... | |
| 69 | 9 | 2uzsrjnrjxk31 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 69 | 190 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 69 | 190 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 69 | 54 | 6ncg8jrztww8x | /* MV_REFRESH (INS) */ INSERT ... | |
| 69 | 54 | 6ncg8jrztww8x | /* MV_REFRESH (INS) */ INSERT ... | |
| 67 | 10,961 | 6f0p92vq1g505 | update sys.slog$ set snaptime ... | |
| 63 | 4,291 | cumjq42201t37 | select u1.user#, u2.user#, u3.... | |
| 62 | 56 | g26t1kwgzbm9p | /* MV_REFRESH (INS) */ INSERT ... | |
| 62 | 56 | g26t1kwgzbm9p | /* MV_REFRESH (INS) */ INSERT ... | |
| 62 | 56 | g26t1kwgzbm9p | /* MV_REFRESH (INS) */ INSERT ... | |
| 61 | 92 | 2q6v017yvanxu | /* MV_REFRESH (INS) */ INSERT ... | |
| 61 | 92 | 2q6v017yvanxu | /* MV_REFRESH (INS) */ INSERT ... | |
| 61 | 23 | 8u56kwk9nu9b6 | /* MV_REFRESH (INS) */ INSERT ... | |
| 61 | 23 | 8u56kwk9nu9b6 | /* MV_REFRESH (INS) */ INSERT ... | |
| 60 | 4,292 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
| 58 | 20 | 726ddwmdshgyy | /* MV_REFRESH (INS) */ INSERT ... | |
| 58 | 20 | 726ddwmdshgyy | /* MV_REFRESH (INS) */ INSERT ... | |
| 58 | 2,939 | 81aj4367ac18z | UPDATE sys.snap$ SET status = ... | |
| 58 | 24 | fs8sw662j161s | /* MV_REFRESH (INS) */ INSERT ... | |
| 58 | 24 | fs8sw662j161s | /* MV_REFRESH (INS) */ INSERT ... | |
| 57 | 61 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 57 | 61 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 57 | 61 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 56 | 48 | 51usvbqthqjam | /* MV_REFRESH (INS) */ INSERT ... | |
| 56 | 48 | 51usvbqthqjam | /* MV_REFRESH (INS) */ INSERT ... | |
| 56 | 8 | 7dv6rj97jqhuf | /* MV_REFRESH (DEL) */ DELETE ... | |
| 50 | 6 | g9bc6f79yswt0 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 46 | 251 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 46 | 251 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 44 | 83 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 44 | 83 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 43 | 167 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 43 | 167 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 43 | 237 | c2pmtb0umq4vk | /* MV_REFRESH (DEL) */ DELETE ... | |
| 43 | 237 | c2pmtb0umq4vk | /* MV_REFRESH (DEL) */ DELETE ... | |
| 40 | 4,299 | 47a50dvdgnxc2 | update sys.job$ set failures=0... | |
| 39 | 10,961 | 34g19nwsvy10j | update sumdetail$ set detailob... | |
| 39 | 6,495 | 3h1g1sszzr4xr | select OLDEST, flag from sys.m... | |
| 35 | 1 | c9ndfjv32xf98 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 32 | 25 | 36xr6u2nrfnww | /* MV_REFRESH (INS) */ INSERT ... | |
| 32 | 25 | 36xr6u2nrfnww | /* MV_REFRESH (INS) */ INSERT ... | |
| 32 | 76 | 6fqrrgy93rc1p | /* MV_REFRESH (INS) */ INSERT ... |
| Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 580.61 | 69,034 | 17.92 | 715.71 | 81.12 | 8.59 | 0.89 | f711myt0q6cma | insert into sys.aud$( sessioni... | |
| 392.65 | 167 | 12.12 | 7,922.11 | 4.96 | 19.28 | 77.66 | 4x4v4trdn3whh | /* MV_REFRESH (DEL) */ DELETE ... | |
| 361.36 | 251 | 11.15 | 8,150.58 | 4.43 | 16.93 | 80.33 | 6ph89trc2y0um | /* MV_REFRESH (DEL) */ DELETE ... | |
| 303.65 | 105 | 9.37 | 5,181.90 | 5.86 | 17.52 | 78.11 | 6ss17y2pvnsz1 | DECLARE job BINARY_INTEGER := ... | |
| 297.25 | 137 | 9.18 | 5,770.52 | 5.15 | 14.60 | 81.90 | 4n1hb4s087wy8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 269.23 | 112 | 8.31 | 4,722.36 | 5.70 | 20.34 | 75.38 | aagh6tg30f1z4 | DECLARE job BINARY_INTEGER := ... | |
| 244.70 | 93 | 7.55 | 3,747.15 | 6.53 | 17.92 | 77.11 | 61uyx2mfm4apk | DECLARE job BINARY_INTEGER := ... | |
| 203.18 | 95 | 6.27 | 5,069.46 | 4.01 | 21.17 | 76.27 | f8twynkxqzddt | DECLARE job BINARY_INTEGER := ... | |
| 171.78 | 69 | 5.30 | 3,113.29 | 5.52 | 14.83 | 81.48 | 8cv2cducrmwu8 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 150.02 | 107 | 4.63 | 3,628.61 | 4.13 | 18.88 | 78.36 | 8pjkk927b7rdv | DECLARE job BINARY_INTEGER := ... | |
| 121.48 | 83 | 3.75 | 3,237.24 | 3.75 | 16.50 | 81.25 | g3fqkk66mycn9 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 115.90 | 82 | 3.58 | 3,203.02 | 3.62 | 13.03 | 84.33 | a79g63hp8huk2 | DECLARE job BINARY_INTEGER := ... | |
| 97.41 | 6 | 3.01 | 1,879.90 | 5.18 | 12.10 | 84.09 | 9d0bgdv1q2gqz | /* MV_REFRESH (DEL) */ DELETE ... | |
| 90.14 | 117 | 2.78 | 2,269.44 | 3.97 | 14.59 | 82.38 | byptv5ajggjwn | DECLARE job BINARY_INTEGER := ... | |
| 85.38 | 100 | 2.64 | 2,973.14 | 2.87 | 17.10 | 81.27 | dqqdbtwnmy295 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 84.41 | 135 | 2.61 | 4,347.02 | 1.94 | 20.56 | 78.21 | 06aws7rn601qy | DECLARE job BINARY_INTEGER := ... | |
| 57.71 | 100 | 1.78 | 438.56 | 13.16 | 17.12 | 71.81 | 4tn0739zgh4w9 | DECLARE job BINARY_INTEGER := ... | |
| 53.33 | 62 | 1.65 | 1,872.20 | 2.85 | 15.21 | 82.64 | 29j72usaarjc6 | DECLARE job BINARY_INTEGER := ... | |
| 43.82 | 122 | 1.35 | 1,004.93 | 4.36 | 12.59 | 83.17 | 9gr21c020pw5g | DECLARE job BINARY_INTEGER := ... | |
| 43.71 | 117 | 1.35 | 1,016.33 | 4.30 | 13.29 | 83.03 | 7jrvd7hwqsp2z | DECLARE job BINARY_INTEGER := ... | |
| 39.98 | 119 | 1.23 | 474.87 | 8.42 | 14.77 | 77.48 | a76w6qhuyuxm6 | DECLARE job BINARY_INTEGER := ... | |
| 34.97 | 9 | 1.08 | 230.25 | 15.19 | 9.59 | 77.44 | 2uzsrjnrjxk31 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 27.12 | 8 | 0.84 | 575.60 | 4.71 | 10.36 | 86.18 | 7dv6rj97jqhuf | /* MV_REFRESH (DEL) */ DELETE ... | |
| 26.09 | 59 | 0.81 | 297.37 | 8.77 | 16.97 | 74.40 | db56n7pqmwxmu | DECLARE job BINARY_INTEGER := ... | |
| 20.64 | 3 | 0.64 | 499.12 | 4.14 | 10.41 | 86.16 | 3ff8gx20bt87z | /* MV_REFRESH (DEL) */ DELETE ... | |
| 19.69 | 6 | 0.61 | 795.62 | 2.48 | 11.30 | 86.86 | g9bc6f79yswt0 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 18.25 | 5 | 0.56 | 291.26 | 6.27 | 11.97 | 82.61 | cb92khr2mk8qw | /* MV_REFRESH (DEL) */ DELETE ... | |
| 17.48 | 5 | 0.54 | 307.56 | 5.68 | 16.07 | 78.97 | 394t4xhxqacan | /* MV_REFRESH (DEL) */ DELETE ... | |
| 16.19 | 6 | 0.50 | 381.50 | 4.24 | 10.85 | 85.74 | awsxgwh4dk95q | /* MV_REFRESH (DEL) */ DELETE ... | |
| 13.85 | 1 | 0.43 | 120.73 | 11.47 | 16.62 | 74.58 | bphtxs3kuba1c | /* MV_REFRESH (DEL) */ DELETE ... | |
| 13.00 | 7 | 0.40 | 382.73 | 3.40 | 10.98 | 86.41 | 36c9sur4dv7c5 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 12.49 | 3 | 0.39 | 211.55 | 5.90 | 9.85 | 85.18 | ch60gk6rx8rjg | /* MV_REFRESH (DEL) */ DELETE ... | |
| 11.82 | 11 | 0.36 | 465.68 | 2.54 | 13.55 | 84.70 | 6xx2shsjwg3fm | /* MV_REFRESH (DEL) */ DELETE ... | |
| 8.80 | 190 | 0.27 | 405.88 | 2.17 | 87.68 | 9.89 | 606bj7h24vx8p | /* MV_REFRESH (INS) */ INSERT ... | |
| 8.61 | 1 | 0.27 | 165.22 | 5.21 | 6.23 | 89.94 | c9ndfjv32xf98 | /* MV_REFRESH (DEL) */ DELETE ... | |
| 7.88 | 233 | 0.24 | 402.16 | 1.96 | 97.36 | 0.58 | a4qx62v2p9cm4 | /* MV_REFRESH (INS) */ INSERT ... | |
| 6.01 | 161 | 0.19 | 427.33 | 1.41 | 79.63 | 17.75 | 9ya4tc409vxy9 | DECLARE job BINARY_INTEGER := ... | |
| 3.59 | 1,526 | 0.11 | 116.08 | 3.09 | 96.11 | 0.63 | 89p0z887n3p2f | JDBC Thin Client | select distinct t.USER_ID from... |
| 2.47 | 891 | 0.08 | 69.65 | 3.55 | 94.36 | 0.73 | au7p061bpfmnf | JDBC Thin Client | update SAS_STATISTICS_DAY_LOGI... |
| 2.33 | 30,983 | 0.07 | 10.28 | 22.68 | 43.92 | 0.03 | 2vnzfjzg6px33 | select log, oldest, oldest_pk,... | |
| 2.04 | 36,167 | 0.06 | 82.80 | 2.46 | 88.82 | 12.41 | 4d8a0vp9yyhsd | select ext_val_id, res_id, res... | |
| 1.86 | 25 | 0.06 | 235.45 | 0.79 | 16.23 | 83.30 | 36xr6u2nrfnww | /* MV_REFRESH (INS) */ INSERT ... | |
| 1.61 | 1 | 0.05 | 200.82 | 0.80 | 15.69 | 84.34 | 99q30aua1245r | /* MV_REFRESH (DEL) */ DELETE ... | |
| 1.43 | 4,292 | 0.04 | 18.96 | 7.54 | 7.81 | 0.00 | aq8yqxyyb40nn | update sys.job$ set this_date=... | |
| 1.15 | 98 | 0.04 | 498.32 | 0.23 | 14.51 | 85.11 | bwb00my8gpq7a | DECLARE job BINARY_INTEGER := ... | |
| 1.12 | 4,255 | 0.03 | 9.25 | 12.13 | 18.39 | 70.29 | 3zzbwu9um4r6r | select id, role_id, org_id, re... | |
| 0.89 | 171 | 0.03 | 266.07 | 0.33 | 97.91 | 1.65 | fc7v6qgnhqq79 | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.70 | 20 | 0.02 | 168.37 | 0.42 | 14.98 | 84.91 | 726ddwmdshgyy | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.60 | 24 | 0.02 | 92.63 | 0.64 | 35.85 | 63.77 | fs8sw662j161s | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.55 | 97 | 0.02 | 82.05 | 0.67 | 89.75 | 9.53 | 8qcpg8khjf22v | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.52 | 195 | 0.02 | 254.23 | 0.21 | 98.42 | 1.21 | 28yxd4ka3zkr3 | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.50 | 4,299 | 0.02 | 4.32 | 11.66 | 25.00 | 0.00 | 47a50dvdgnxc2 | update sys.job$ set failures=0... | |
| 0.50 | 10,961 | 0.02 | 2.34 | 21.20 | 82.62 | 0.08 | 34g19nwsvy10j | update sumdetail$ set detailob... | |
| 0.49 | 145 | 0.02 | 332.75 | 0.15 | 95.92 | 3.83 | 5uptukz9dh67x | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.44 | 10,961 | 0.01 | 3.38 | 12.93 | 84.54 | 0.00 | 6f0p92vq1g505 | update sys.slog$ set snaptime ... | |
| 0.43 | 4,291 | 0.01 | 2.39 | 17.90 | 41.88 | 0.26 | cumjq42201t37 | select u1.user#, u2.user#, u3.... | |
| 0.42 | 3,132 | 0.01 | 6.61 | 6.34 | 19.30 | 76.52 | aw84hsshtvbgs | select id, name, sporg_system_... | |
| 0.25 | 132 | 0.01 | 147.28 | 0.17 | 98.78 | 0.90 | aq0p7pd7k1z5y | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.25 | 54 | 0.01 | 57.68 | 0.44 | 68.34 | 23.36 | 6ncg8jrztww8x | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.22 | 38 | 0.01 | 28.48 | 0.77 | 94.21 | 3.84 | 1pc3w08xhpf6w | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.20 | 61 | 0.01 | 60.15 | 0.34 | 95.77 | 3.78 | 7amd39gpy0pad | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.18 | 92 | 0.01 | 67.55 | 0.27 | 93.15 | 6.48 | 2q6v017yvanxu | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.16 | 76 | 0.01 | 99.33 | 0.17 | 98.74 | 0.96 | 6fqrrgy93rc1p | /* MV_REFRESH (INS) */ INSERT ... | |
| 0.15 | 29 | 0.00 | 24.87 | 0.60 | 86.71 | 12.59 | ac4h67wt6ku2v | /* MV_REFRESH (INS) */ INSERT ... |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| Batched IO (bound) vector count | 4,230 | 0.39 | 0.01 |
| Batched IO (full) vector count | 756 | 0.07 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 17,497 | 1.62 | 0.04 |
| Batched IO buffer defrag count | 164 | 0.02 | 0.00 |
| Batched IO double miss count | 380 | 0.04 | 0.00 |
| Batched IO same unit count | 10,114 | 0.93 | 0.02 |
| Batched IO single block count | 3,632 | 0.34 | 0.01 |
| Batched IO slow jump count | 203 | 0.02 | 0.00 |
| Batched IO vector block count | 4,547 | 0.42 | 0.01 |
| Batched IO vector read count | 1,560 | 0.14 | 0.00 |
| Block Cleanout Optim referenced | 2 | 0.00 | 0.00 |
| CCursor + sql area evicted | 29,724 | 2.75 | 0.06 |
| CPU used by this session | 1,565,578 | 144.69 | 3.16 |
| CPU used when call started | 664,607 | 61.42 | 1.34 |
| CR blocks created | 20,095 | 1.86 | 0.04 |
| Cached Commit SCN referenced | 25,485 | 2.36 | 0.05 |
| Clusterwide global transactions | 0 | 0.00 | 0.00 |
| Commit SCN cached | 991 | 0.09 | 0.00 |
| DB time | 11,391,147 | 1,052.73 | 23.03 |
| DBWR checkpoint buffers written | 111,958 | 10.35 | 0.23 |
| DBWR checkpoints | 69 | 0.01 | 0.00 |
| DBWR fusion writes | 13,303 | 1.23 | 0.03 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR thread checkpoint buffers written | 84,375 | 7.80 | 0.17 |
| DBWR transaction table writes | 1,842 | 0.17 | 0.00 |
| DBWR undo block writes | 23,325 | 2.16 | 0.05 |
| DFO trees parallelized | 69 | 0.01 | 0.00 |
| DX/BB enqueue lock background get time | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock background gets | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock foreground requests | 0 | 0.00 | 0.00 |
| DX/BB enqueue lock foreground wait time | 0 | 0.00 | 0.00 |
| Effective IO time | 2,294,749 | 212.07 | 4.64 |
| HSC Heap Segment Block Changes | 935,257 | 86.43 | 1.89 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 448,747 | 41.47 | 0.91 |
| Heap Segment Array Updates | 21,535 | 1.99 | 0.04 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 3 | 0.00 | 0.00 |
| Number of read IOs issued | 181 | 0.02 | 0.00 |
| PX local messages recv'd | 204 | 0.02 | 0.00 |
| PX local messages sent | 204 | 0.02 | 0.00 |
| PX remote messages recv'd | 222 | 0.02 | 0.00 |
| PX remote messages sent | 222 | 0.02 | 0.00 |
| Parallel operations not downgraded | 69 | 0.01 | 0.00 |
| Requests to/from client | 34,265,175 | 3,166.68 | 69.26 |
| RowCR - row contention | 1 | 0.00 | 0.00 |
| RowCR attempts | 1,175 | 0.11 | 0.00 |
| RowCR hits | 1,173 | 0.11 | 0.00 |
| SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
| SMON posted for instance recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 21 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 34,265,149 | 3,166.67 | 69.26 |
| TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
| TBS Extension: files extended | 0 | 0.00 | 0.00 |
| TBS Extension: tasks created | 0 | 0.00 | 0.00 |
| TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
| active txn count during cleanout | 35,519 | 3.28 | 0.07 |
| application wait time | 236 | 0.02 | 0.00 |
| auto extends on undo tablespace | 0 | 0.00 | 0.00 |
| background checkpoints completed | 69 | 0.01 | 0.00 |
| background checkpoints started | 69 | 0.01 | 0.00 |
| background timeouts | 113,661 | 10.50 | 0.23 |
| branch node splits | 70 | 0.01 | 0.00 |
| buffer is not pinned count | 133,508,169 | 12,338.39 | 269.86 |
| buffer is pinned count | 202,514,394 | 18,715.72 | 409.35 |
| bytes received via SQL*Net from client | 4,847,332,950 | 447,974.69 | 9,798.05 |
| bytes sent via SQL*Net to client | 9,613,425,328 | 888,441.39 | 19,431.90 |
| calls to get snapshot scn: kcmgss | 59,782,596 | 5,524.91 | 120.84 |
| calls to kcmgas | 1,412,239 | 130.51 | 2.85 |
| calls to kcmgcs | 2,943,335 | 272.01 | 5.95 |
| cell physical IO interconnect bytes | 1,068,525,288,448 | 98,749,618.98 | 2,159,841.22 |
| change write time | 6,019 | 0.56 | 0.01 |
| cleanout - number of ktugct calls | 46,976 | 4.34 | 0.09 |
| cleanouts and rollbacks - consistent read gets | 16,780 | 1.55 | 0.03 |
| cleanouts only - consistent read gets | 1,617 | 0.15 | 0.00 |
| cluster key scan block gets | 215,619 | 19.93 | 0.44 |
| cluster key scans | 206,308 | 19.07 | 0.42 |
| cluster wait time | 323,813 | 29.93 | 0.65 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 164 | 0.02 | 0.00 |
| commit batch/immediate requested | 164 | 0.02 | 0.00 |
| commit cleanout failures: block lost | 118 | 0.01 | 0.00 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 214 | 0.02 | 0.00 |
| commit cleanout failures: cannot pin | 26,952 | 2.49 | 0.05 |
| commit cleanouts | 828,989 | 76.61 | 1.68 |
| commit cleanouts successfully completed | 801,705 | 74.09 | 1.62 |
| commit immediate performed | 164 | 0.02 | 0.00 |
| commit immediate requested | 164 | 0.02 | 0.00 |
| commit txn count during cleanout | 29,118 | 2.69 | 0.06 |
| concurrency wait time | 35,766 | 3.31 | 0.07 |
| consistent changes | 29,723,823 | 2,746.98 | 60.08 |
| consistent gets | 594,558,821 | 54,947.19 | 1,201.80 |
| consistent gets - examination | 23,086,769 | 2,133.60 | 46.67 |
| consistent gets direct | 204 | 0.02 | 0.00 |
| consistent gets from cache | 594,558,622 | 54,947.17 | 1,201.80 |
| consistent gets from cache (fastpath) | 566,138,359 | 52,320.66 | 1,144.35 |
| cursor authentications | 58,413 | 5.40 | 0.12 |
| data blocks consistent reads - undo records applied | 58,465 | 5.40 | 0.12 |
| db block changes | 33,553,746 | 3,100.93 | 67.82 |
| db block gets | 67,534,182 | 6,241.29 | 136.51 |
| db block gets direct | 7,928 | 0.73 | 0.02 |
| db block gets from cache | 67,526,254 | 6,240.56 | 136.49 |
| db block gets from cache (fastpath) | 1,061,732 | 98.12 | 2.15 |
| deferred (CURRENT) block cleanout applications | 620,529 | 57.35 | 1.25 |
| dirty buffers inspected | 7,989 | 0.74 | 0.02 |
| drop segment calls in space pressure | 0 | 0.00 | 0.00 |
| enqueue conversions | 17,174 | 1.59 | 0.03 |
| enqueue deadlocks | 0 | 0.00 | 0.00 |
| enqueue releases | 3,329,508 | 307.70 | 6.73 |
| enqueue requests | 3,331,708 | 307.91 | 6.73 |
| enqueue timeouts | 2,256 | 0.21 | 0.00 |
| enqueue waits | 8,213 | 0.76 | 0.02 |
| exchange deadlocks | 3 | 0.00 | 0.00 |
| execute count | 5,045,540 | 466.29 | 10.20 |
| failed probes on index block reclamation | 1 | 0.00 | 0.00 |
| file io service time | 2,000 | 0.18 | 0.00 |
| file io wait time | 35,438,792,494 | 3,275,137.51 | 71,633.46 |
| frame signature mismatch | 0 | 0.00 | 0.00 |
| free buffer inspected | 131,887,655 | 12,188.63 | 266.59 |
| free buffer requested | 139,626,720 | 12,903.85 | 282.23 |
| gc blocks compressed | 487,792 | 45.08 | 0.99 |
| gc blocks lost | 27 | 0.00 | 0.00 |
| gc cr block flush time | 1,309 | 0.12 | 0.00 |
| gc cr block receive time | 284,865 | 26.33 | 0.58 |
| gc cr blocks received | 1,257,701 | 116.23 | 2.54 |
| gc cr blocks served | 275,307 | 25.44 | 0.56 |
| gc current block flush time | 22,893 | 2.12 | 0.05 |
| gc current block pin time | 4,816 | 0.45 | 0.01 |
| gc current block receive time | 1,272,566 | 117.61 | 2.57 |
| gc current blocks received | 5,753,661 | 531.73 | 11.63 |
| gc current blocks served | 3,250,092 | 300.36 | 6.57 |
| gc kbytes saved | 1,388,943 | 128.36 | 2.81 |
| gc kbytes sent | 26,814,241 | 2,478.08 | 54.20 |
| gc local grants | 108,515,314 | 10,028.63 | 219.35 |
| gc read wait failures | 0 | 0.00 | 0.00 |
| gc read wait time | 397 | 0.04 | 0.00 |
| gc read wait timeouts | 0 | 0.00 | 0.00 |
| gc read waits | 361 | 0.03 | 0.00 |
| gc remote grants | 21,443,351 | 1,981.72 | 43.34 |
| gcs messages sent | 70,171,443 | 6,485.02 | 141.84 |
| ges messages sent | 656,253 | 60.65 | 1.33 |
| global enqueue get time | 19,608 | 1.81 | 0.04 |
| global enqueue gets async | 67,301 | 6.22 | 0.14 |
| global enqueue gets sync | 6,530,113 | 603.49 | 13.20 |
| global enqueue releases | 6,435,447 | 594.74 | 13.01 |
| global undo segment hints helped | 0 | 0.00 | 0.00 |
| global undo segment hints were stale | 0 | 0.00 | 0.00 |
| heap block compress | 9,473 | 0.88 | 0.02 |
| hot buffers moved to head of LRU | 1,266,460 | 117.04 | 2.56 |
| immediate (CR) block cleanout applications | 18,397 | 1.70 | 0.04 |
| immediate (CURRENT) block cleanout applications | 13,541 | 1.25 | 0.03 |
| in call idle wait time | 60,797,203 | 5,618.68 | 122.89 |
| index crx upgrade (positioned) | 1,311 | 0.12 | 0.00 |
| index crx upgrade (prefetch) | 823 | 0.08 | 0.00 |
| index fast full scans (full) | 1,309 | 0.12 | 0.00 |
| index fetch by key | 3,327,009 | 307.47 | 6.72 |
| index scans kdiixs1 | 28,509,635 | 2,634.77 | 57.63 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap live object count | 0 | 0.00 | 0.00 |
| java call heap live object count max | 0 | 0.00 | 0.00 |
| java call heap live size | 0 | 0.00 | 0.00 |
| java call heap live size max | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| java session heap live object count | 0 | 0.00 | 0.00 |
| java session heap live object count max | 0 | 0.00 | 0.00 |
| java session heap live size | 0 | 0.00 | 0.00 |
| java session heap live size max | 0 | 0.00 | 0.00 |
| java session heap object count | 0 | 0.00 | 0.00 |
| java session heap object count max | 0 | 0.00 | 0.00 |
| java session heap used size | 0 | 0.00 | 0.00 |
| java session heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 46 | 0.00 | 0.00 |
| leaf node splits | 744 | 0.07 | 0.00 |
| lob reads | 26,954 | 2.49 | 0.05 |
| lob writes | 26,034,356 | 2,406.01 | 52.62 |
| lob writes unaligned | 25,571,003 | 2,363.19 | 51.69 |
| local undo segment hints helped | 0 | 0.00 | 0.00 |
| local undo segment hints were stale | 0 | 0.00 | 0.00 |
| logical read bytes from cache | 5,423,799,443,456 | 501,249,838.71 | 10,963,283.45 |
| logons cumulative | 73,948 | 6.83 | 0.15 |
| max cf enq hold time | 300 | 0.03 | 0.00 |
| messages received | 669,172 | 61.84 | 1.35 |
| messages sent | 669,172 | 61.84 | 1.35 |
| min active SCN optimization applied on CR | 28 | 0.00 | 0.00 |
| no buffer to keep pinned count | 3,495 | 0.32 | 0.01 |
| no work - consistent read gets | 516,294,564 | 47,714.26 | 1,043.60 |
| non-idle wait count | 50,034,361 | 4,624.01 | 101.14 |
| non-idle wait time | 4,624,253 | 427.36 | 9.35 |
| opened cursors cumulative | 5,500,470 | 508.34 | 11.12 |
| parse count (describe) | 142 | 0.01 | 0.00 |
| parse count (failures) | 9,330 | 0.86 | 0.02 |
| parse count (hard) | 422,188 | 39.02 | 0.85 |
| parse count (total) | 1,631,742 | 150.80 | 3.30 |
| parse time cpu | 194,643 | 17.99 | 0.39 |
| parse time elapsed | 205,979 | 19.04 | 0.42 |
| physical read IO requests | 23,870,793 | 2,206.06 | 48.25 |
| physical read bytes | 1,028,986,904,576 | 95,095,610.62 | 2,079,921.14 |
| physical read total IO requests | 23,950,556 | 2,213.43 | 48.41 |
| physical read total bytes | 1,031,829,385,728 | 95,358,303.45 | 2,085,666.73 |
| physical read total multi block requests | 1,291,348 | 119.34 | 2.61 |
| physical reads | 125,608,753 | 11,608.35 | 253.90 |
| physical reads cache | 125,607,278 | 11,608.21 | 253.89 |
| physical reads cache prefetch | 122,420,960 | 11,313.75 | 247.45 |
| physical reads direct | 1,475 | 0.14 | 0.00 |
| physical reads direct (lob) | 181 | 0.02 | 0.00 |
| physical reads direct temporary tablespace | 90 | 0.01 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical reads retry corrupt | 0 | 0.00 | 0.00 |
| physical write IO requests | 69,724 | 6.44 | 0.14 |
| physical write bytes | 1,131,675,648 | 104,585.77 | 2,287.49 |
| physical write total IO requests | 1,294,064 | 119.59 | 2.62 |
| physical write total bytes | 36,695,927,296 | 3,391,317.81 | 74,174.54 |
| physical write total multi block requests | 33,981 | 3.14 | 0.07 |
| physical writes | 138,144 | 12.77 | 0.28 |
| physical writes direct | 9,205 | 0.85 | 0.02 |
| physical writes direct (lob) | 22 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 7,743 | 0.72 | 0.02 |
| physical writes from cache | 128,939 | 11.92 | 0.26 |
| physical writes non checkpoint | 110,066 | 10.17 | 0.22 |
| pinned buffers inspected | 127,932 | 11.82 | 0.26 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 17 | 0.00 | 0.00 |
| process last non-idle time | 10,819 | 1.00 | 0.02 |
| queries parallelized | 69 | 0.01 | 0.00 |
| recovery blocks read | 0 | 0.00 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 15,534,755 | 1,435.67 | 31.40 |
| recursive cpu usage | 969,595 | 89.61 | 1.96 |
| redo KB read | 904,680 | 83.61 | 1.83 |
| redo blocks checksummed by FG (exclusive) | 163,743 | 15.13 | 0.33 |
| redo blocks written | 1,798,537 | 166.21 | 3.64 |
| redo buffer allocation retries | 32,334 | 2.99 | 0.07 |
| redo entries | 2,114,488 | 195.41 | 4.27 |
| redo log space requests | 42,268 | 3.91 | 0.09 |
| redo log space wait time | 97,210 | 8.98 | 0.20 |
| redo ordering marks | 21,120 | 1.95 | 0.04 |
| redo size | 782,073,284 | 72,276.66 | 1,580.83 |
| redo size for direct writes | 2,263,228 | 209.16 | 4.57 |
| redo subscn max counts | 9,763 | 0.90 | 0.02 |
| redo synch long waits | 0 | 0.00 | 0.00 |
| redo synch poll writes | 619,531 | 57.26 | 1.25 |
| redo synch polls | 1,025,468 | 94.77 | 2.07 |
| redo synch time | 659,115 | 60.91 | 1.33 |
| redo synch time (usec) | 6,613,815,586 | 611,227.25 | 13,368.70 |
| redo synch writes | 619,531 | 57.26 | 1.25 |
| redo wastage | 117,136,696 | 10,825.39 | 236.77 |
| redo write broadcast ack count | 101,360 | 9.37 | 0.20 |
| redo write broadcast ack time | 52,336,498 | 4,836.77 | 105.79 |
| redo write broadcast lgwr post count | 18 | 0.00 | 0.00 |
| redo write time | 219,708 | 20.30 | 0.44 |
| redo writes | 582,597 | 53.84 | 1.18 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 162 | 0.01 | 0.00 |
| rollbacks only - consistent read gets | 3,978 | 0.37 | 0.01 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 2,399,269 | 221.73 | 4.85 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 842,338 | 77.85 | 1.70 |
| session logical reads | 662,092,693 | 61,188.45 | 1,338.31 |
| shared hash latch upgrades - no wait | 1,660,716 | 153.48 | 3.36 |
| shared hash latch upgrades - wait | 317 | 0.03 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 1,258,401 | 116.30 | 2.54 |
| sorts (rows) | 31,424,745 | 2,904.17 | 63.52 |
| space was found by tune down | 0 | 0.00 | 0.00 |
| space was not found by tune down | 0 | 0.00 | 0.00 |
| sql area evicted | 412,508 | 38.12 | 0.83 |
| sql area purged | 10,847 | 1.00 | 0.02 |
| steps of tune down ret. in space pressure | 0 | 0.00 | 0.00 |
| summed dirty queue length | 30,301 | 2.80 | 0.06 |
| switch current to new buffer | 137,019 | 12.66 | 0.28 |
| table fetch by rowid | 145,791,356 | 13,473.56 | 294.69 |
| table fetch continued row | 1,271,789 | 117.53 | 2.57 |
| table scan blocks gotten | 386,751,116 | 35,742.28 | 781.75 |
| table scan rows gotten | 12,092,387,568 | 1,117,538.98 | 24,442.69 |
| table scans (direct read) | 0 | 0.00 | 0.00 |
| table scans (long tables) | 753 | 0.07 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 1,188,709 | 109.86 | 2.40 |
| temp space allocated (bytes) | 3,145,728 | 290.72 | 6.36 |
| total cf enq hold time | 48,860 | 4.52 | 0.10 |
| total number of cf enq holders | 6,249 | 0.58 | 0.01 |
| total number of times SMON posted | 43 | 0.00 | 0.00 |
| transaction lock background gets | 2 | 0.00 | 0.00 |
| transaction lock foreground requests | 2 | 0.00 | 0.00 |
| transaction lock foreground wait time | 1 | 0.00 | 0.00 |
| transaction rollbacks | 162 | 0.01 | 0.00 |
| transaction tables consistent read rollbacks | 32 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 4,199 | 0.39 | 0.01 |
| tune down retentions in space pressure | 0 | 0.00 | 0.00 |
| undo change vector size | 161,123,768 | 14,890.53 | 325.68 |
| user I/O wait time | 3,191,828 | 294.98 | 6.45 |
| user calls | 38,088,687 | 3,520.03 | 76.99 |
| user commits | 494,724 | 45.72 | 1.00 |
| user rollbacks | 0 | 0.00 | 0.00 |
| workarea executions - onepass | 4 | 0.00 | 0.00 |
| workarea executions - optimal | 841,252 | 77.75 | 1.70 |
| write clones created in background | 1,256 | 0.12 | 0.00 |
| write clones created in foreground | 332 | 0.03 | 0.00 |
| Statistic | Begin Value | End Value |
|---|---|---|
| opened cursors current | 1,168 | 962 |
| workarea memory allocated | 28,347 | 2,441 |
| logons current | 369 | 350 |
| session uga memory max | 45,259,939,447,240 | 45,317,357,997,256 |
| session pga memory | 32,676,535,132,480 | 32,694,558,749,056 |
| session pga memory max | 157,030,216,673,568 | 157,365,737,240,928 |
| session cursor cache count | 1,381,579,943 | 1,382,621,201 |
| session uga memory | 42,756,745,403,492,912 | 42,775,256,158,284,064 |
| Statistic | Total | per Hour |
|---|---|---|
| log switches (derived) | 69 | 22.96 |
| 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 | 957.2G | 2205.19 | 90.5869 | 0M | 0.00 | 0M | 3183.3K | 9.52 |
| Others | 1.6G | 3.65 | .149345 | 31.1G | 4.72 | 2.94338 | 44.5K | 3.73 |
| LGWR | 613M | 3.65 | .056651 | 1.7G | 109.07 | .164501 | 623K | 3.12 |
| DBWR | 0M | 0.00 | 0M | 1007M | 5.62 | .093063 | 27 | 1.41 |
| RMAN | 480M | 0.06 | .044360 | 349M | 0.04 | .032253 | 1011 | 6.10 |
| Direct Reads | 11M | 0.13 | .001016 | 3M | 0.04 | .000277 | 0 | |
| Direct Writes | 0M | 0.00 | 0M | 8M | 0.07 | .000739 | 0 | |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 34 | 10.85 |
| TOTAL: | 959.9G | 2212.69 | 90.8383 | 34.2G | 119.56 | 3.23421 | 3851.9K | 8.41 |
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|---|---|---|---|---|---|---|---|
| Data File | 957.2G | 2204.98 | 90.5814 | 1003M | 5.70 | .092693 | 0.48 | 10.66 |
| Log File | 884M | 0.15 | .081696 | 1.7G | 108.93 | .162283 | 3.25 | 0.01 |
| Control File | 1.8G | 7.21 | .168752 | 382M | 1.25 | .035303 | 2.13 | 8.13 |
| Archive Log | 0M | 0.00 | 0M | 884M | 0.08 | .081696 | ||
| Other | 0M | 0.00 | 0M | 174M | 0.02 | .016080 | ||
| Temp File | 61M | 0.71 | .005637 | 81M | 0.74 | .007485 | 2.14 | |
| TOTAL: | 959.9G | 2213.05 | 90.8375 | 4.2G | 116.72 | .395543 | 0.49 | 10.65 |
| 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 | 956.8G | 2205.05 | 90.5476 | 0M | 0.00 | 0M | 2827.3K | 6.93 |
| Buffer Cache Reads (Data File) | 956.8G | 2205.05 | 90.5476 | 0M | 0.00 | 0M | 2827.3K | 6.93 |
| Others | 1.6G | 3.65 | .149437 | 31.1G | 4.72 | 2.94338 | 38.6K | 3.63 |
| Others (Data File) | 0M | 0.00 | 0M | 30.1G | 3.55 | 2.84467 | 55 | 3.89 |
| Others (Control File) | 734M | 3.52 | .067833 | 184M | 1.09 | .017004 | 38.1K | 3.63 |
| Others (Archive Log) | 0M | 0.00 | 0M | 884M | 0.08 | .081696 | 0 | |
| Others (Log File) | 883M | 0.13 | .081603 | 0M | 0.00 | 0M | 483 | 3.47 |
| LGWR | 613M | 3.65 | .056651 | 1.7G | 109.06 | .164409 | 39.8K | 0.73 |
| LGWR (Log File) | 0M | 0.03 | 0M | 1.7G | 108.91 | .162191 | 552 | 2.34 |
| LGWR (Control File) | 613M | 3.63 | .056651 | 24M | 0.14 | .002218 | 39.3K | 0.70 |
| DBWR | 0M | 0.00 | 0M | 1007M | 5.62 | .093063 | 27 | 1.41 |
| DBWR (Data File) | 0M | 0.00 | 0M | 1007M | 5.62 | .093063 | 1 | 1.00 |
| DBWR (Control File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 26 | 1.42 |
| RMAN | 480M | 0.06 | .044360 | 175M | 0.02 | .016172 | 649 | 5.89 |
| RMAN (Control File) | 480M | 0.06 | .044360 | 175M | 0.02 | .016172 | 649 | 5.89 |
| Direct Reads | 11M | 0.13 | .001016 | 3M | 0.04 | .000277 | 0 | |
| Direct Reads (Data File) | 11M | 0.13 | .001016 | 3M | 0.04 | .000277 | 0 | |
| Direct Writes | 0M | 0.00 | 0M | 8M | 0.07 | .000739 | 0 | |
| Direct Writes (Data File) | 0M | 0.00 | 0M | 8M | 0.07 | .000739 | 0 | |
| Streams AQ | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 34 | 10.85 |
| Streams AQ (Data File) | 0M | 0.00 | 0M | 0M | 0.00 | 0M | 34 | 10.85 |
| TOTAL: | 959.5G | 2212.55 | 90.7991 | 34G | 119.53 | 3.21804 | 2906.4K | 6.80 |
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|
| ISC_TBS | 23,845,477 | 2,204 | 0.87 | 5.27 | 21,916 | 2 | 69,320 | 4.61 |
| ISCAS_TBS | 13,248 | 1 | 10.20 | 1.00 | 22,784 | 2 | 1,631 | 25.73 |
| TEMP | 7,690 | 1 | 2.47 | 1.01 | 8,062 | 1 | 0 | 0.00 |
| SYSTEM | 3,828 | 0 | 9.47 | 1.04 | 6,971 | 1 | 41,648 | 18.77 |
| SYSAUX | 3,530 | 0 | 11.48 | 1.04 | 3,503 | 0 | 0 | 0.00 |
| UNDOTBS1 | 77 | 0 | 3.90 | 1.00 | 4,902 | 0 | 3,247 | 0.02 |
| ISC_UAP_TEMP_TBS | 538 | 0 | 5.37 | 1.00 | 1,478 | 0 | 39 | 8.72 |
| UNDOTBS2 | 77 | 0 | 2.21 | 1.00 | 38 | 0 | 29 | 0.34 |
| USERS | 41 | 0 | 0.98 | 1.00 | 38 | 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) |
|---|---|---|---|---|---|---|---|---|---|
| ISCAS_TBS | +TYQXDATA/tyqxdb/datafile/iscas_tbs.269.832015599 | 63 | 0 | 3.49 | 1.02 | 613 | 0 | 80 | 0.88 |
| ISCAS_TBS | +TYQXDATA/tyqxdb/datafile/iscas_tbs.290.848077371 | 7,856 | 1 | 9.94 | 1.00 | 10,339 | 1 | 975 | 22.62 |
| ISCAS_TBS | +TYQXDATA/tyqxdb/datafile/iscas_tbs.291.848077557 | 5,235 | 0 | 10.81 | 1.00 | 10,876 | 1 | 381 | 51.60 |
| ISCAS_TBS | +TYQXDATA/tyqxdb/datafile/iscas_tbs.292.859296465 | 85 | 0 | 4.00 | 1.00 | 821 | 0 | 195 | 0.92 |
| ISCAS_TBS | +TYQXDATA/tyqxdb/datafile/iscas_tbs.294.863631433 | 9 | 0 | 0.00 | 1.00 | 135 | 0 | 0 | 0.00 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.268.832015491 | 1,607,893 | 149 | 0.96 | 5.21 | 2,302 | 0 | 9,736 | 3.83 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.271.834728781 | 1,552,698 | 143 | 0.97 | 5.40 | 1,242 | 0 | 5,595 | 3.58 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.273.846020563 | 1,467,626 | 136 | 0.89 | 5.23 | 1,270 | 0 | 1,140 | 3.65 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.274.846148173 | 1,389,863 | 128 | 0.94 | 5.43 | 1,043 | 0 | 1,055 | 5.54 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.275.846148639 | 1,407,889 | 130 | 0.92 | 5.31 | 988 | 0 | 1,085 | 4.98 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.276.846875927 | 1,320,087 | 122 | 0.99 | 5.34 | 999 | 0 | 9,003 | 4.07 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.277.846877797 | 1,311,835 | 121 | 1.00 | 5.19 | 1,020 | 0 | 10,030 | 4.31 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.280.848062887 | 1,278,814 | 118 | 0.83 | 5.28 | 1,044 | 0 | 4,046 | 5.65 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.281.848063033 | 1,307,960 | 121 | 0.78 | 5.17 | 1,612 | 0 | 3,875 | 5.60 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.282.848063165 | 1,201,150 | 111 | 0.84 | 5.22 | 1,846 | 0 | 2,969 | 5.49 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.283.848063405 | 1,141,537 | 105 | 0.90 | 5.26 | 1,506 | 0 | 3,005 | 5.50 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.284.848063517 | 1,119,165 | 103 | 0.86 | 5.38 | 1,251 | 0 | 2,949 | 5.07 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.285.848064025 | 1,140,593 | 105 | 0.84 | 5.29 | 636 | 0 | 2,810 | 4.91 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.286.848064265 | 1,185,741 | 110 | 0.89 | 5.43 | 1,045 | 0 | 2,784 | 5.35 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.287.848065543 | 1,837,827 | 170 | 0.71 | 5.13 | 1,401 | 0 | 3,209 | 4.79 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.288.848076609 | 1,850,826 | 171 | 0.70 | 5.20 | 1,153 | 0 | 3,015 | 5.29 |
| ISC_TBS | +TYQXDATA/tyqxdb/datafile/isc_tbs.289.848077207 | 1,723,973 | 159 | 0.80 | 5.26 | 1,558 | 0 | 3,014 | 4.88 |
| ISC_UAP_TEMP_TBS | +TYQXDATA/tyqxdb/datafile/isc_uap_temp_tbs.270.832160825 | 186 | 0 | 6.29 | 1.00 | 939 | 0 | 3 | 3.33 |
| ISC_UAP_TEMP_TBS | +TYQXDATA/tyqxdb/datafile/isc_uap_temp_tbs.272.834759299 | 134 | 0 | 5.30 | 1.00 | 293 | 0 | 17 | 7.06 |
| ISC_UAP_TEMP_TBS | +TYQXDATA/tyqxdb/datafile/isc_uap_temp_tbs.278.848062687 | 96 | 0 | 3.85 | 1.00 | 126 | 0 | 11 | 11.82 |
| ISC_UAP_TEMP_TBS | +TYQXDATA/tyqxdb/datafile/isc_uap_temp_tbs.279.848062761 | 122 | 0 | 5.25 | 1.00 | 120 | 0 | 8 | 10.00 |
| SYSAUX | +TYQXDATA/tyqxdb/datafile/sysaux.257.832014877 | 3,530 | 0 | 11.48 | 1.04 | 3,503 | 0 | 0 | 0.00 |
| SYSTEM | +TYQXDATA/tyqxdb/datafile/system.256.832014875 | 3,780 | 0 | 9.56 | 1.04 | 2,702 | 0 | 7,274 | 2.40 |
| SYSTEM | +TYQXDATA/tyqxdb/datafile/system.293.862133123 | 48 | 0 | 2.08 | 1.00 | 4,269 | 0 | 34,374 | 22.23 |
| TEMP | +TYQXDATA/tyqxdb/tempfile/temp.263.832014961 | 7,690 | 1 | 2.47 | 1.01 | 8,062 | 1 | 0 | |
| UNDOTBS1 | +TYQXDATA/tyqxdb/datafile/undotbs1.258.832014877 | 77 | 0 | 3.90 | 1.00 | 4,902 | 0 | 3,247 | 0.02 |
| UNDOTBS2 | +TYQXDATA/tyqxdb/datafile/undotbs2.264.832015039 | 77 | 0 | 2.21 | 1.00 | 38 | 0 | 29 | 0.34 |
| USERS | +TYQXDATA/tyqxdb/datafile/users.259.832014877 | 41 | 0 | 0.98 | 1.00 | 38 | 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 | 961,846 | 80 | 661,712,583 | 131,304,624 | 128,939 | 0 | 3 | 115,969 |
| MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 27,583 | 84,375 |
| 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 | 3 | 2690 | 38903 | 82944 | 82944 | 92063 | 1 | ||
| E | 0 | 2 | 1239 | 27842 | 82944 | 82944 | 92016 | 1 |
| 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 | 800 | 0.10 | 94 | 3.01 | 184,330,678 | 1 | 47578913.00 |
| D | 1,600 | 0.20 | 189 | 2.13 | 130,740,864 | 1 | 33041564.00 |
| D | 2,400 | 0.29 | 283 | 1.61 | 98,506,190 | 1 | 24297280.00 |
| D | 3,200 | 0.39 | 378 | 1.32 | 80,786,491 | 1 | 19490440.00 |
| D | 4,000 | 0.49 | 472 | 1.17 | 71,463,394 | 1 | 16961367.00 |
| D | 4,800 | 0.59 | 567 | 1.09 | 66,608,329 | 1 | 15644334.00 |
| D | 5,600 | 0.69 | 661 | 1.04 | 64,001,472 | 1 | 14937169.00 |
| D | 6,400 | 0.78 | 756 | 1.02 | 62,552,458 | 1 | 14544095.00 |
| D | 7,200 | 0.88 | 850 | 1.01 | 61,742,654 | 1 | 14324418.00 |
| D | 8,000 | 0.98 | 945 | 1.00 | 61,303,687 | 1 | 14205340.00 |
| D | 8,160 | 1.00 | 964 | 1.00 | 61,257,253 | 1 | 14192743.00 |
| D | 8,800 | 1.08 | 1,039 | 1.00 | 61,071,529 | 1 | 14142364.00 |
| D | 9,600 | 1.18 | 1,134 | 0.99 | 60,935,780 | 1 | 14105538.00 |
| D | 10,400 | 1.27 | 1,228 | 0.99 | 60,819,372 | 1 | 14073963.00 |
| D | 11,200 | 1.37 | 1,323 | 0.99 | 60,576,977 | 1 | 14008207.00 |
| D | 12,000 | 1.47 | 1,417 | 0.98 | 60,279,917 | 1 | 13927623.00 |
| D | 12,800 | 1.57 | 1,512 | 0.98 | 59,964,753 | 1 | 13842126.00 |
| D | 13,600 | 1.67 | 1,606 | 0.97 | 59,565,108 | 1 | 13733716.00 |
| D | 14,400 | 1.76 | 1,701 | 0.96 | 59,052,192 | 1 | 13594577.00 |
| D | 15,200 | 1.86 | 1,795 | 0.96 | 58,506,778 | 1 | 13446620.00 |
| D | 16,000 | 1.96 | 1,890 | 0.95 | 57,985,994 | 1 | 13305347.00 |
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|---|---|
| 99.98 | 101,244 | 16 |
| PGA Aggr Target(M) | Auto PGA Target(M) | PGA Mem Alloc(M) | W/A PGA Used(M) | %PGA W/A Mem | %Auto W/A Mem | %Man W/A Mem | Global Mem Bound(K) | |
|---|---|---|---|---|---|---|---|---|
| B | 4,826 | 3,423 | 1,395.57 | 23.93 | 1.71 | 100.00 | 0.00 | 494,180 |
| E | 4,826 | 3,489 | 1,295.91 | 8.73 | 0.67 | 100.00 | 0.00 | 494,180 |
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|---|---|---|---|---|
| 2K | 4K | 738,254 | 738,254 | 0 | 0 |
| 64K | 128K | 5,523 | 5,523 | 0 | 0 |
| 128K | 256K | 461 | 461 | 0 | 0 |
| 256K | 512K | 15,903 | 15,903 | 0 | 0 |
| 512K | 1024K | 78,446 | 78,446 | 0 | 0 |
| 1M | 2M | 1,592 | 1,592 | 0 | 0 |
| 2M | 4M | 149 | 145 | 4 | 0 |
| 4M | 8M | 66 | 66 | 0 | 0 |
| 8M | 16M | 352 | 352 | 0 | 0 |
| 32M | 64M | 252 | 252 | 0 | 0 |
| 64M | 128M | 170 | 170 | 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 |
|---|---|---|---|---|---|---|
| 603 | 0.13 | 542,701,040.13 | 336,016,218.58 | 62.00 | 1,520,121 | 579,586,224,086 |
| 1,207 | 0.25 | 542,701,040.13 | 2,056,103.67 | 100.00 | 34,377 | 359,312,091,444 |
| 2,413 | 0.50 | 542,701,040.13 | 182,884.48 | 100.00 | 2,927 | 358,076,549,491 |
| 3,620 | 0.75 | 542,701,040.13 | 169,225.00 | 100.00 | 2,192 | 358,067,539,945 |
| 4,826 | 1.00 | 542,701,040.13 | 147,202.39 | 100.00 | 1,899 | 358,053,014,224 |
| 5,791 | 1.20 | 542,701,040.13 | 70,227.04 | 100.00 | 586 | 358,002,242,658 |
| 6,756 | 1.40 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 7,722 | 1.60 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 8,687 | 1.80 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 9,652 | 2.00 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 14,478 | 3.00 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 19,304 | 4.00 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 28,956 | 6.00 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 38,608 | 8.00 | 542,701,040.13 | 70,227.04 | 100.00 | 0 | 358,002,242,658 |
| 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) |
|---|---|---|---|---|---|---|---|---|
| 4,096 | 0.69 | 577 | 52,095 | 349,384,483 | 0.97 | 18,696,585 | 2.98 | 1,691,094 |
| 4,704 | 0.79 | 1,184 | 77,325 | 355,365,765 | 0.98 | 12,715,303 | 2.03 | 2,024,618 |
| 5,312 | 0.90 | 1,792 | 103,472 | 359,103,481 | 0.99 | 8,977,587 | 1.43 | 2,252,665 |
| 5,600 | 0.95 | 2,079 | 117,250 | 360,428,771 | 1.00 | 7,652,297 | 1.22 | 2,336,182 |
| 5,632 | 0.95 | 2,111 | 118,669 | 360,570,054 | 1.00 | 7,511,014 | 1.20 | 2,344,984 |
| 5,664 | 0.96 | 2,143 | 120,077 | 360,711,185 | 1.00 | 7,369,883 | 1.17 | 2,353,783 |
| 5,696 | 0.96 | 2,175 | 121,462 | 360,852,672 | 1.00 | 7,228,396 | 1.15 | 2,362,584 |
| 5,728 | 0.97 | 2,207 | 122,840 | 360,994,308 | 1.00 | 7,086,760 | 1.13 | 2,371,420 |
| 5,760 | 0.97 | 2,239 | 124,214 | 361,129,575 | 1.00 | 6,951,493 | 1.11 | 2,379,832 |
| 5,792 | 0.98 | 2,271 | 125,631 | 361,264,612 | 1.00 | 6,816,456 | 1.09 | 2,388,232 |
| 5,824 | 0.98 | 2,303 | 127,099 | 361,399,749 | 1.00 | 6,681,319 | 1.06 | 2,396,631 |
| 5,856 | 0.99 | 2,335 | 128,306 | 361,534,935 | 1.00 | 6,546,133 | 1.04 | 2,405,028 |
| 5,888 | 0.99 | 2,367 | 129,372 | 361,669,666 | 1.00 | 6,411,402 | 1.02 | 2,413,406 |
| 5,920 | 1.00 | 2,399 | 130,476 | 361,805,178 | 1.00 | 6,275,890 | 1.00 | 2,421,886 |
| 5,952 | 1.01 | 2,431 | 131,661 | 361,806,420 | 1.00 | 6,274,648 | 1.00 | 2,422,055 |
| 5,984 | 1.01 | 2,463 | 132,811 | 361,806,832 | 1.00 | 6,274,236 | 1.00 | 2,422,113 |
| 6,016 | 1.02 | 2,495 | 134,134 | 361,806,999 | 1.00 | 6,274,069 | 1.00 | 2,422,130 |
| 6,048 | 1.02 | 2,526 | 135,453 | 361,808,974 | 1.00 | 6,272,094 | 1.00 | 2,422,392 |
| 6,080 | 1.03 | 2,558 | 136,693 | 361,809,742 | 1.00 | 6,271,326 | 1.00 | 2,422,493 |
| 6,112 | 1.03 | 2,590 | 137,867 | 361,809,832 | 1.00 | 6,271,236 | 1.00 | 2,422,504 |
| 6,144 | 1.04 | 2,622 | 139,052 | 361,809,975 | 1.00 | 6,271,093 | 1.00 | 2,422,518 |
| 6,176 | 1.04 | 2,654 | 140,241 | 361,810,201 | 1.00 | 6,270,867 | 1.00 | 2,422,547 |
| 6,208 | 1.05 | 2,686 | 141,446 | 361,810,357 | 1.00 | 6,270,711 | 1.00 | 2,422,563 |
| 6,528 | 1.10 | 3,006 | 153,241 | 361,814,294 | 1.00 | 6,266,774 | 1.00 | 2,423,014 |
| 7,136 | 1.21 | 3,613 | 175,154 | 361,815,534 | 1.00 | 6,265,534 | 1.00 | 2,423,173 |
| 7,744 | 1.31 | 4,218 | 195,944 | 361,816,566 | 1.00 | 6,264,502 | 1.00 | 2,423,313 |
| 8,352 | 1.41 | 4,826 | 215,704 | 361,817,463 | 1.00 | 6,263,605 | 1.00 | 2,423,443 |
| 8,960 | 1.51 | 5,434 | 237,038 | 361,818,261 | 1.00 | 6,262,807 | 1.00 | 2,423,561 |
| 9,568 | 1.62 | 6,042 | 258,786 | 361,819,013 | 1.00 | 6,262,055 | 1.00 | 2,423,680 |
| 10,176 | 1.72 | 6,650 | 282,013 | 361,819,893 | 1.00 | 6,261,175 | 1.00 | 2,423,785 |
| 10,784 | 1.82 | 7,257 | 305,124 | 361,820,548 | 1.00 | 6,260,520 | 1.00 | 2,423,883 |
| 11,392 | 1.92 | 7,864 | 328,521 | 361,821,192 | 1.00 | 6,259,876 | 1.00 | 2,423,977 |
| 12,000 | 2.03 | 8,472 | 352,058 | 361,821,721 | 1.00 | 6,259,347 | 1.00 | 2,424,062 |
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|---|---|---|
| 5,436 | 0.38 | 144,385,772 | 184,892,767,536 |
| 7,248 | 0.50 | 115,110,665 | 98,807,949,520 |
| 9,060 | 0.63 | 104,127,575 | 81,031,094,622 |
| 10,872 | 0.75 | 100,000,297 | 66,813,286,138 |
| 12,684 | 0.88 | 98,897,063 | 62,739,678,796 |
| 14,496 | 1.00 | 98,503,051 | 61,257,253,267 |
| 16,308 | 1.13 | 98,434,099 | 61,006,098,529 |
| 18,120 | 1.25 | 98,276,494 | 60,460,908,975 |
| 19,932 | 1.38 | 97,951,434 | 59,229,638,184 |
| 21,744 | 1.50 | 97,665,775 | 58,163,761,977 |
| 23,556 | 1.63 | 97,655,925 | 58,163,761,977 |
| 25,368 | 1.75 | 97,655,925 | 58,163,761,977 |
| 27,180 | 1.88 | 97,655,925 | 58,163,761,977 |
| 28,992 | 2.00 | 97,646,074 | 58,163,761,977 |
| Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
|---|---|---|---|---|---|
| 32 | 1.00 | 0 | 0 | 0 | 0 |
| 64 | 2.00 | 0 | 0 | 0 | 0 |
| 96 | 3.00 | 0 | 0 | 0 | 0 |
| 128 | 4.00 | 0 | 0 | 0 | 0 |
| 160 | 5.00 | 0 | 0 | 0 | 0 |
| 192 | 6.00 | 0 | 0 | 0 | 0 |
| 224 | 7.00 | 0 | 0 | 0 | 0 |
| 256 | 8.00 | 0 | 0 | 0 | 0 |
| 288 | 9.00 | 0 | 0 | 0 | 0 |
| 320 | 10.00 | 0 | 0 | 0 | 0 |
| 352 | 11.00 | 0 | 0 | 0 | 0 |
| 384 | 12.00 | 0 | 0 | 0 | 0 |
| 416 | 13.00 | 0 | 0 | 0 | 0 |
| 448 | 14.00 | 0 | 0 | 0 | 0 |
| 480 | 15.00 | 0 | 0 | 0 | 0 |
| 512 | 16.00 | 0 | 0 | 0 | 0 |
| 544 | 17.00 | 0 | 0 | 0 | 0 |
| 576 | 18.00 | 0 | 0 | 0 | 0 |
| 608 | 19.00 | 0 | 0 | 0 | 0 |
| 640 | 20.00 | 0 | 0 | 0 | 0 |
| Java Pool Size(M) | JP 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 |
|---|---|---|---|---|---|---|---|---|
| 32 | 0.14 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 64 | 0.29 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 96 | 0.43 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 128 | 0.57 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 160 | 0.71 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 192 | 0.86 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 224 | 1.00 | 10 | 190 | 2,472,306 | 1.00 | 6,275,890 | 1.00 | 6,630,296 |
| 256 | 1.14 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 288 | 1.29 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 320 | 1.43 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 352 | 1.57 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 384 | 1.71 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 416 | 1.86 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 448 | 2.00 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 480 | 2.14 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| 512 | 2.29 | 10 | 190 | 2,472,345 | 1.00 | 6,275,851 | 1.00 | 6,630,423 |
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|---|---|---|
| data block | 109,206 | 1,105 | 10 |
| 1st level bmb | 287 | 21 | 73 |
| segment header | 2,867 | 12 | 4 |
| 2nd level bmb | 282 | 4 | 15 |
| undo header | 2,529 | 0 | 0 |
| undo block | 747 | 0 | 0 |
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|---|---|---|---|---|---|
| MS-Materialized View Refresh Log | 22,530 | 22,530 | 0 | 2,959 | 16 | 5.41 |
| CF-Controlfile Transaction | 35,684 | 35,676 | 8 | 392 | 5 | 12.42 |
| WF-AWR Flush | 72 | 72 | 0 | 49 | 3 | 62.04 |
| HW-Segment High Water Mark | 3,012 | 3,013 | 0 | 878 | 2 | 2.02 |
| FB-Format Block | 2,182 | 2,182 | 0 | 1,067 | 1 | 1.06 |
| TX-Transaction (row lock contention) | 735 | 735 | 0 | 724 | 1 | 1.48 |
| JQ-Job Queue | 6,014 | 4,640 | 1,315 | 821 | 0 | 0.46 |
| UL-User-defined | 4,141 | 3,208 | 933 | 373 | 0 | 0.83 |
| SR-Synchronized Replication | 3,186 | 3,186 | 0 | 356 | 0 | 0.59 |
| PS-PX Process Reservation | 453 | 453 | 0 | 153 | 0 | 0.78 |
| TM-DML | 1,202,477 | 1,202,398 | 0 | 24 | 0 | 5.00 |
| JI-Materialized View | 4,119 | 4,118 | 0 | 193 | 0 | 0.57 |
| TT-Tablespace | 8,930 | 8,930 | 0 | 60 | 0 | 1.00 |
| WL-Being Written Redo Log | 69 | 69 | 0 | 35 | 0 | 0.86 |
| TO-Temp Object | 7,656 | 7,656 | 0 | 25 | 0 | 0.80 |
| AE-Edition Lock (lock) | 75,124 | 75,124 | 0 | 12 | 0 | 0.83 |
| US-Undo Segment | 23 | 23 | 0 | 8 | 0 | 1.25 |
| TX-Transaction | 724,802 | 724,782 | 0 | 2 | 0 | 5.00 |
| TA-Instance Undo | 38 | 38 | 0 | 32 | 0 | 0.00 |
| TD-KTF map table enqueue (KTF dump entries) | 25 | 25 | 0 | 24 | 0 | 0.00 |
| CR-Reuse Block Range (block range reuse ckpt) | 198 | 198 | 0 | 7 | 0 | 0.00 |
| DR-Distributed Recovery | 6 | 6 | 0 | 6 | 0 | 0.00 |
| JS-Job Scheduler (job run lock - synchronize) | 9 | 9 | 0 | 4 | 0 | 0.00 |
| TQ-Queue table enqueue (TM contention) | 50 | 50 | 0 | 4 | 0 | 0.00 |
| AF-Advisor Framework (task serialization) | 33 | 33 | 0 | 3 | 0 | 0.00 |
| MW-MWIN Schedule | 6 | 6 | 0 | 3 | 0 | 0.00 |
| CT-Block Change Tracking (state) | 1 | 1 | 0 | 1 | 0 | 0.00 |
| FD-Flashback Database (Flashback logical operations) | 2 | 2 | 0 | 1 | 0 | 0.00 |
| SQ-Sequence Cache | 133 | 133 | 0 | 1 | 0 | 0.00 |
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 2 | 22.24 | 747,922 | 1,977 | 25 | 36.8/48 | 0/0 | 0/0/0/0/0/0 |
| End Time | Num Undo Blocks | Number of Transactions | Max Qry Len (s) | Max Tx Concy | Tun Ret (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 14-11月 17:51 | 1,371 | 56,865 | 1,835 | 11 | 46 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 17:41 | 1,495 | 59,421 | 1,732 | 18 | 44 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 17:31 | 866 | 25,951 | 1,815 | 17 | 45 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 17:21 | 1,034 | 28,189 | 1,908 | 13 | 47 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 17:11 | 879 | 23,806 | 1,568 | 18 | 41 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 17:01 | 1,027 | 21,780 | 1,842 | 20 | 46 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:51 | 954 | 19,859 | 1,545 | 13 | 44 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:41 | 906 | 25,366 | 1,052 | 16 | 37 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:31 | 1,063 | 23,766 | 1,977 | 20 | 48 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:21 | 602 | 28,384 | 1,899 | 19 | 47 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:11 | 780 | 39,623 | 1,193 | 8 | 43 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 16:01 | 1,709 | 51,760 | 1,549 | 25 | 44 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:51 | 1,242 | 52,917 | 1,535 | 16 | 41 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:41 | 2,099 | 65,938 | 1,419 | 18 | 39 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:31 | 1,322 | 54,770 | 1,602 | 10 | 42 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:21 | 1,511 | 64,380 | 1,587 | 21 | 44 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:11 | 1,703 | 59,623 | 1,699 | 16 | 43 | 0/0 | 0/0/0/0/0/0 |
| 14-11月 15:01 | 1,674 | 45,524 | 1,815 | 15 | 45 | 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 | 3 | 0.00 | 0 | 0 | ||
| AQ dequeue txn counter latch | 2,522 | 0.00 | 0 | 0 | ||
| ASM Keyed state latch | 139,064 | 0.03 | 0.00 | 0 | 0 | |
| ASM allocation | 14,315 | 0.01 | 0.00 | 0 | 0 | |
| ASM db client latch | 7,328 | 0.00 | 0 | 0 | ||
| ASM map headers | 2,365 | 0.00 | 0 | 0 | ||
| ASM map load waiting list | 352 | 0.00 | 0 | 0 | ||
| ASM map operation freelist | 56,612 | 0.04 | 0.00 | 0 | 0 | |
| ASM map operation hash table | 52,901,431 | 0.00 | 0.00 | 0 | 0 | |
| ASM network SGA latch | 207 | 0.00 | 0 | 0 | ||
| ASM network background latch | 13,899 | 0.00 | 0 | 0 | ||
| ASM network state latch | 13,912 | 0.00 | 0 | 0 | ||
| ASM scan context latch | 276 | 0.00 | 0 | 0 | ||
| AWR Alerted Metric Element list | 110,845 | 0.00 | 0 | 0 | ||
| Change Notification Hash table latch | 11,244 | 0.00 | 0 | 0 | ||
| Consistent RBA | 582,733 | 0.00 | 0.00 | 0 | 0 | |
| DML lock allocation | 2,405,066 | 0.00 | 0.00 | 0 | 0 | |
| Event Group Locks | 143,464 | 0.00 | 0.00 | 0 | 0 | |
| FAL Queue | 429 | 0.00 | 0 | 0 | ||
| FIB s.o chain latch | 715 | 0.00 | 0 | 0 | ||
| FOB s.o list latch | 166,910 | 0.17 | 0.00 | 0 | 0 | |
| File IO Stats segmented array latch | 2 | 0.00 | 0 | 0 | ||
| File State Object Pool Parent Latch | 3 | 0.00 | 0 | 0 | ||
| I/O Staticstics latch | 3 | 0.00 | 0 | 0 | ||
| IPC other latch | 91 | 0.00 | 0 | 0 | ||
| IPC stats buffer allocation latch | 209,387 | 0.00 | 0.00 | 0 | 209,292 | 0.00 |
| In memory undo latch | 3 | 0.00 | 0 | 0 | ||
| JOX JIT latch | 7 | 0.00 | 0 | 7 | 0.00 | |
| JOX SGA heap latch | 441 | 0.00 | 0 | 0 | ||
| JS Sh mem access | 21 | 0.00 | 0 | 0 | ||
| JS broadcast add buf latch | 16,898 | 0.00 | 0 | 0 | ||
| JS broadcast drop buf latch | 16,901 | 0.00 | 0 | 0 | ||
| JS broadcast load blnc latch | 16,588 | 0.00 | 0 | 0 | ||
| JS mem alloc latch | 25 | 0.00 | 0 | 0 | ||
| JS queue access latch | 28 | 0.00 | 0 | 0 | ||
| JS queue state obj latch | 597,318 | 0.00 | 0 | 0 | ||
| JS slv state obj latch | 605 | 0.33 | 0.00 | 0 | 0 | |
| KFC FX Hash Latch | 3 | 0.00 | 0 | 0 | ||
| KFC Hash Latch | 3 | 0.00 | 0 | 0 | ||
| KFCL LE Freelist | 3 | 0.00 | 0 | 0 | ||
| KFK SGA Libload latch | 1,745 | 0.00 | 0 | 0 | ||
| KFMD SGA | 1,597 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SHM structure | 3 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SVR LIST | 3 | 0.00 | 0 | 0 | ||
| KJC message pool free list | 2,038,528 | 0.14 | 0.01 | 0 | 715,146 | 0.11 |
| KJCT flow control latch | 33,759,847 | 0.02 | 0.00 | 0 | 0 | |
| KMG MMAN ready and startup request latch | 3,604 | 0.00 | 0 | 0 | ||
| KSXR large replies | 724 | 0.00 | 0 | 0 | ||
| KTF sga latch | 143,622 | 0.01 | 0.00 | 0 | 3,618 | 0.08 |
| KWQMN job cache list latch | 1,030 | 0.00 | 0 | 0 | ||
| KWQP Prop Status | 6 | 0.00 | 0 | 0 | ||
| KWQS pqsubs latch | 26 | 0.00 | 0 | 0 | ||
| KWQS pqueue ctx latch | 256 | 0.00 | 0 | 0 | ||
| Locator state objects pool parent latch | 3 | 0.00 | 0 | 0 | ||
| Lsod array latch | 914,003 | 0.55 | 0.03 | 0 | 0 | |
| MQL Tracking Latch | 0 | 0 | 215 | 0.00 | ||
| Memory Management Latch | 3 | 0.00 | 0 | 3,604 | 0.00 | |
| Memory Queue | 3 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #1 | 3 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #2 | 3 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #3 | 3 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #4 | 3 | 0.00 | 0 | 0 | ||
| Memory Queue Subscriber | 3 | 0.00 | 0 | 0 | ||
| MinActiveScn Latch | 7,415 | 0.00 | 0 | 0 | ||
| Mutex | 3 | 0.00 | 0 | 0 | ||
| Mutex Stats | 3 | 0.00 | 0 | 0 | ||
| OS process | 280,433 | 0.00 | 0 | 0 | ||
| OS process allocation | 162,420 | 0.16 | 0.00 | 0 | 0 | |
| OS process: request allocation | 139,064 | 0.23 | 0.01 | 0 | 0 | |
| PL/SQL warning settings | 78,669 | 0.00 | 0.00 | 0 | 0 | |
| PX hash array latch | 3 | 0.00 | 0 | 0 | ||
| QMT | 3 | 0.00 | 0 | 0 | ||
| Real-time plan statistics latch | 199,012 | 0.00 | 0.00 | 0 | 0 | |
| Result Cache: RC Latch | 39,345 | 0.49 | 0.05 | 0 | 0 | |
| Result Cache: SO Latch | 8,245 | 0.07 | 0.00 | 0 | 0 | |
| SGA IO buffer pool latch | 483 | 0.00 | 0 | 485 | 0.00 | |
| SGA blob parent | 3 | 0.00 | 0 | 0 | ||
| SGA bucket locks | 3 | 0.00 | 0 | 0 | ||
| SGA heap locks | 3 | 0.00 | 0 | 0 | ||
| SGA pool locks | 3 | 0.00 | 0 | 0 | ||
| SQL memory manager latch | 3 | 0.00 | 0 | 3,583 | 0.00 | |
| SQL memory manager workarea list latch | 780,490 | 0.00 | 0.00 | 0 | 0 | |
| Shared B-Tree | 1,141 | 0.00 | 0 | 0 | ||
| Streams Generic | 3 | 0.00 | 0 | 0 | ||
| Testing | 3 | 0.00 | 0 | 0 | ||
| Token Manager | 3 | 0.00 | 0 | 0 | ||
| WCR: sync | 3 | 0.00 | 0 | 0 | ||
| Write State Object Pool Parent Latch | 3 | 0.00 | 0 | 0 | ||
| X$KSFQP | 8,182 | 0.00 | 0 | 0 | ||
| XDB NFS Security Latch | 3 | 0.00 | 0 | 0 | ||
| XDB unused session pool | 3 | 0.00 | 0 | 0 | ||
| XDB used session pool | 3 | 0.00 | 0 | 0 | ||
| active checkpoint queue latch | 71,270 | 0.44 | 0.01 | 0 | 0 | |
| active service list | 20,353,273 | 0.03 | 0.08 | 0 | 30,346 | 0.03 |
| alert log latch | 138 | 0.00 | 0 | 0 | ||
| archive control | 387 | 0.00 | 0 | 0 | ||
| archive process latch | 1,357 | 0.15 | 1.00 | 0 | 0 | |
| begin backup scn array | 38 | 0.00 | 0 | 0 | ||
| buffer pool | 3 | 0.00 | 0 | 0 | ||
| business card | 141 | 0.00 | 0 | 0 | ||
| cache buffer handles | 37,875 | 0.07 | 0.18 | 0 | 0 | |
| cache buffers chains | 1,671,201,628 | 0.22 | 0.00 | 1 | 571,292,210 | 0.01 |
| cache buffers lru chain | 54,453,029 | 0.29 | 0.00 | 0 | 546,432,343 | 0.16 |
| cache table scan latch | 2,229,819 | 0.19 | 0.00 | 0 | 2,273,302 | 0.21 |
| call allocation | 275,977 | 1.54 | 0.58 | 0 | 0 | |
| cas latch | 3 | 0.00 | 0 | 0 | ||
| change notification client cache latch | 3 | 0.00 | 0 | 0 | ||
| channel handle pool latch | 139,282 | 0.06 | 0.00 | 0 | 0 | |
| channel operations parent latch | 9,223,399 | 0.01 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 7,902,375 | 0.00 | 0.00 | 0 | 201,199 | 0.01 |
| client/application info | 464,815 | 0.00 | 0 | 0 | ||
| compile environment latch | 73,935 | 0.00 | 0 | 0 | ||
| constraint object allocation | 8,245 | 0.05 | 0.00 | 0 | 0 | |
| corrupted undo seg latch | 655 | 0.00 | 0 | 0 | ||
| cp cmon/server latch | 3 | 0.00 | 0 | 0 | ||
| cp pool latch | 3 | 0.00 | 0 | 0 | ||
| cp server hash latch | 3 | 0.00 | 0 | 0 | ||
| cp sga latch | 704 | 0.00 | 0 | 0 | ||
| cvmap freelist lock | 3 | 0.00 | 0 | 0 | ||
| deferred cleanup latch | 704 | 0.00 | 0 | 0 | ||
| dml lock allocation | 704 | 0.00 | 0 | 0 | ||
| done queue latch | 3 | 0.00 | 0 | 0 | ||
| dummy allocation | 147,885 | 0.07 | 0.02 | 0 | 0 | |
| enqueue freelist latch | 3 | 0.00 | 0 | 2,655,127 | 0.00 | |
| enqueue hash chains | 9,375,233 | 0.11 | 0.00 | 0 | 57 | 0.00 |
| enqueues | 5 | 0.00 | 0 | 0 | ||
| error message lists | 309 | 0.00 | 0 | 0 | ||
| fifth spare latch | 3 | 0.00 | 0 | 0 | ||
| file cache latch | 1,365 | 0.00 | 0 | 0 | ||
| file number translation table | 1 | 0.00 | 0 | 0 | ||
| flashback copy | 3 | 0.00 | 0 | 0 | ||
| fourth Audit Vault latch | 3 | 0.00 | 0 | 0 | ||
| gc element | 172,711,661 | 0.19 | 0.01 | 1 | 276,407 | 0.04 |
| gc persistent rm | 57 | 0.00 | 0 | 0 | ||
| gcr global ctx | 93 | 0.00 | 0 | 0 | ||
| gcs commit scn state | 3 | 0.00 | 0 | 0 | ||
| gcs opaque info freelist | 10,703,596 | 0.42 | 0.00 | 0 | 0 | |
| gcs partitioned table hash | 528,868,761 | 0.18 | 0.00 | 0 | 108,483,761 | 0.00 |
| gcs pcm hashed value bucket hash | 3 | 0.00 | 0 | 0 | ||
| gcs remaster request queue | 13,450 | 0.11 | 0.00 | 0 | 0 | |
| gcs remastering latch | 23,734,561 | 3.28 | 0.00 | 0 | 53,716 | 1.85 |
| gcs resource freelist | 30,171,560 | 0.05 | 0.00 | 0 | 20,387,241 | 0.01 |
| gcs resource hash | 324,248,929 | 0.09 | 0.00 | 0 | 400 | 0.25 |
| gcs resource scan list | 919 | 0.00 | 0 | 0 | ||
| gcs shadows freelist | 19,814,255 | 0.00 | 0.00 | 0 | 20,126,811 | 0.00 |
| ges DFS wait callback info | 8 | 0.00 | 0 | 1 | 0.00 | |
| ges caches resource lists | 3,065,883 | 0.02 | 0.02 | 0 | 361,011 | 0.03 |
| ges deadlock list | 14,014 | 0.01 | 0.00 | 0 | 0 | |
| ges domain table | 12,686,431 | 0.00 | 0.00 | 0 | 0 | |
| ges enqueue table freelist | 12,896,730 | 0.00 | 0.00 | 0 | 0 | |
| ges group table | 12,677,749 | 0.01 | 0.00 | 0 | 0 | |
| ges process hash list | 411,049 | 0.00 | 0 | 0 | ||
| ges process parent latch | 26,346,626 | 0.00 | 0.00 | 0 | 0 | |
| ges process table freelist | 139,064 | 0.19 | 0.00 | 0 | 0 | |
| ges resource hash list | 25,127,009 | 0.10 | 0.04 | 0 | 56,725 | 0.07 |
| ges resource scan list | 55,594 | 0.01 | 0.00 | 0 | 0 | |
| ges resource table freelist | 67,677 | 0.00 | 0.00 | 0 | 0 | |
| ges timeout list | 31,372 | 0.00 | 0.00 | 0 | 5,928 | 0.00 |
| ges value block free list | 25,818 | 0.00 | 0 | 0 | ||
| global KZLD latch for mem in SGA | 69,067 | 0.00 | 0 | 0 | ||
| global tx hash mapping | 3 | 0.00 | 0 | 0 | ||
| granule operation | 3 | 0.00 | 0 | 0 | ||
| hash table column usage latch | 2,299 | 0.00 | 0 | 8,084,115 | 0.00 | |
| hash table modification latch | 349 | 0.00 | 0 | 0 | ||
| heartbeat check | 3 | 0.00 | 0 | 4,140 | 0.00 | |
| heartbeat structure management | 0 | 0 | 2,163 | 0.00 | ||
| internal temp table object number allocation latch | 157 | 0.00 | 0 | 0 | ||
| interrupt manipulation | 814 | 0.00 | 0 | 0 | ||
| intra txn parallel recovery | 3 | 0.00 | 0 | 0 | ||
| io pool granule metadata list | 3 | 0.00 | 0 | 0 | ||
| job workq parent latch | 4,327 | 0.00 | 0 | 4,333 | 17.63 | |
| job_queue_processes free list latch | 8,666 | 0.53 | 0.00 | 0 | 0 | |
| job_queue_processes parameter latch | 21,069 | 0.00 | 0.00 | 0 | 0 | |
| k2q global data latch | 7,208 | 0.00 | 0 | 0 | ||
| k2q lock allocation | 3 | 0.00 | 0 | 0 | ||
| kcbtsemkid latch | 69 | 0.00 | 0 | 0 | ||
| kdlx hb parent latch | 3 | 0.00 | 0 | 0 | ||
| kgb parent | 3 | 0.00 | 0 | 0 | ||
| kgnfs mount latch | 3 | 0.00 | 0 | 0 | ||
| kokc descriptor allocation latch | 39,738 | 0.01 | 0.00 | 0 | 0 | |
| ksfv messages | 3 | 0.00 | 0 | 0 | ||
| ksim group membership cache | 79,898 | 0.00 | 0 | 0 | ||
| ksim membership request latch | 0 | 0 | 6,900 | 0.00 | ||
| kss move lock | 327 | 0.00 | 0 | 0 | ||
| ksuosstats global area | 1,090 | 0.00 | 0 | 0 | ||
| ksv allocation latch | 1,352 | 0.00 | 0 | 0 | ||
| ksv class latch | 83,082 | 0.05 | 0.03 | 0 | 0 | |
| ksv instance latch | 56 | 0.00 | 0 | 0 | ||
| ksv msg queue latch | 651 | 0.00 | 0 | 648 | 0.00 | |
| ksxp shared latch | 139,064 | 0.14 | 0.00 | 0 | 0 | |
| ksxp so latch | 139,064 | 0.06 | 0.00 | 0 | 0 | |
| ksz_so allocation latch | 139,064 | 0.33 | 0.00 | 0 | 0 | |
| ktm global data | 282 | 0.00 | 0 | 0 | ||
| kwqbsn:qsga | 382 | 0.00 | 0 | 0 | ||
| lgwr LWN SCN | 583,666 | 0.01 | 0.00 | 0 | 0 | |
| list of block allocation | 156,883 | 0.05 | 0.00 | 0 | 0 | |
| loader state object freelist | 16,018 | 0.03 | 0.00 | 0 | 0 | |
| lob segment dispenser latch | 3 | 0.00 | 0 | 0 | ||
| lob segment hash table latch | 39 | 0.00 | 0 | 0 | ||
| lob segment query latch | 3 | 0.00 | 0 | 0 | ||
| lock DBA buffer during media recovery | 3 | 0.00 | 0 | 0 | ||
| logical standby cache | 3 | 0.00 | 0 | 0 | ||
| logminer context allocation | 6 | 0.00 | 0 | 0 | ||
| logminer work area | 3 | 0.00 | 0 | 0 | ||
| longop free list parent | 867 | 0.00 | 0 | 772 | 0.00 | |
| managed standby latch | 360 | 0.00 | 0 | 0 | ||
| mapped buffers lru chain | 3 | 0.00 | 0 | 0 | ||
| message pool operations parent latch | 14,851 | 0.00 | 0 | 0 | ||
| messages | 3,465,042 | 0.14 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 612,436 | 2.54 | 0.00 | 0 | 0 | |
| msg queue latch | 3 | 0.00 | 0 | 0 | ||
| multiblock read objects | 6,512,829 | 0.06 | 0.00 | 0 | 0 | |
| name-service memory objects | 104,058 | 0.00 | 0 | 0 | ||
| name-service namespace bucket | 212,816 | 0.00 | 0.00 | 0 | 0 | |
| name-service pending queue | 46,698 | 0.00 | 0 | 0 | ||
| name-service request queue | 179,331 | 0.00 | 0 | 0 | ||
| ncodef allocation latch | 704 | 0.00 | 0 | 0 | ||
| object queue header heap | 790,878 | 0.00 | 0.00 | 0 | 786,517 | 0.00 |
| object queue header operation | 286,501,656 | 0.02 | 0.12 | 1 | 0 | |
| object stats modification | 1,438 | 0.00 | 0 | 0 | ||
| parallel query alloc buffer | 7,211 | 0.00 | 0 | 0 | ||
| parallel query stats | 303 | 0.00 | 0 | 0 | ||
| parallel txn reco latch | 4,070 | 0.00 | 0 | 0 | ||
| parameter list | 632,330 | 0.03 | 0.00 | 0 | 0 | |
| parameter table management | 329,457 | 0.10 | 0.23 | 0 | 0 | |
| peshm | 15 | 0.00 | 0 | 0 | ||
| pesom_free_list | 4,659 | 0.00 | 0 | 0 | ||
| pesom_hash_node | 4,671 | 0.00 | 0 | 0 | ||
| pesom_heap_alloc | 56 | 0.00 | 0 | 0 | ||
| post/wait queue | 449,616 | 0.06 | 0.00 | 0 | 417,833 | 0.03 |
| process allocation | 190,699 | 0.58 | 0.70 | 6 | 69,449 | 0.11 |
| process group creation | 139,064 | 0.27 | 0.00 | 0 | 0 | |
| process queue | 780 | 0.00 | 0 | 0 | ||
| process queue reference | 12,885 | 0.02 | 0.00 | 0 | 1,185 | 0.00 |
| qmn state object latch | 4 | 0.00 | 0 | 0 | ||
| qmn task context latch | 2 | 0.00 | 0 | 0 | ||
| qmn task queue latch | 1,548 | 0.00 | 0 | 0 | ||
| query server freelists | 636 | 0.00 | 0 | 0 | ||
| query server process | 51 | 0.00 | 0 | 0 | ||
| queued dump request | 36 | 0.00 | 0 | 0 | ||
| queuing load statistics | 3 | 0.00 | 0 | 0 | ||
| recovery domain hash list | 3 | 0.00 | 0 | 0 | ||
| redo allocation | 2,960,199 | 0.09 | 0.01 | 0 | 2,135,946 | 0.43 |
| redo copy | 131 | 0.00 | 0 | 2,139,387 | 0.67 | |
| redo writing | 1,871,491 | 0.07 | 0.01 | 0 | 0 | |
| resmgr group change latch | 73,679 | 0.00 | 0.00 | 0 | 0 | |
| resmgr:active threads | 147,885 | 0.00 | 0 | 0 | ||
| resmgr:actses change group | 73,629 | 0.00 | 0 | 0 | ||
| resmgr:actses change state | 3 | 0.00 | 0 | 0 | ||
| resmgr:free threads list | 147,882 | 0.23 | 0.00 | 0 | 0 | |
| resmgr:plan CPU method | 3 | 0.00 | 0 | 0 | ||
| resmgr:resource group CPU method | 3 | 0.00 | 0 | 0 | ||
| resmgr:schema config | 243 | 0.00 | 0 | 0 | ||
| resmgr:session queuing | 3 | 0.00 | 0 | 0 | ||
| rm cas latch | 3 | 0.00 | 0 | 0 | ||
| row cache objects | 180,893,784 | 0.44 | 0.00 | 0 | 2,227 | 0.40 |
| rules engine aggregate statistics | 10 | 0.00 | 0 | 0 | ||
| rules engine rule set statistics | 320 | 0.00 | 0 | 0 | ||
| second Audit Vault latch | 3 | 0.00 | 0 | 0 | ||
| second spare latch | 3 | 0.00 | 0 | 0 | ||
| segmented array pool | 695 | 0.00 | 0 | 0 | ||
| sequence cache | 228,014 | 0.08 | 0.00 | 0 | 0 | |
| session allocation | 2,464,358 | 0.00 | 0.00 | 0 | 2,316,774 | 0.00 |
| session idle bit | 78,421,081 | 0.00 | 0.00 | 0 | 0 | |
| session queue latch | 3 | 0.00 | 0 | 0 | ||
| session state list latch | 164,489 | 0.07 | 0.13 | 0 | 0 | |
| session switching | 70,245 | 0.32 | 0.00 | 0 | 0 | |
| session timer | 4,044 | 0.00 | 0 | 0 | ||
| shared pool | 32,466,445 | 0.31 | 0.14 | 4 | 0 | |
| shared pool sim alloc | 3 | 0.00 | 0 | 0 | ||
| shared pool simulator | 1,554,459 | 0.01 | 0.20 | 0 | 0 | |
| sim partition latch | 3 | 0.00 | 0 | 0 | ||
| simulator hash latch | 73,918,911 | 0.00 | 0.00 | 0 | 0 | |
| simulator lru latch | 3 | 0.00 | 0 | 58,706,257 | 0.36 | |
| sort extent pool | 51,463 | 0.08 | 0.00 | 0 | 0 | |
| space background state object latch | 40 | 0.00 | 0 | 0 | ||
| space background task latch | 14,250 | 0.55 | 0.03 | 0 | 7,229 | 0.00 |
| state object free list | 6 | 0.00 | 0 | 0 | ||
| statistics aggregation | 1,680 | 0.00 | 0 | 0 | ||
| tablespace key chain | 6 | 0.00 | 0 | 0 | ||
| temp lob duration state obj allocation | 1,521 | 0.53 | 0.00 | 0 | 0 | |
| temporary table state object allocation | 3,150 | 0.13 | 0.00 | 0 | 0 | |
| test excl. parent l0 | 3 | 0.00 | 0 | 0 | ||
| test excl. parent2 l0 | 3 | 0.00 | 0 | 0 | ||
| third spare latch | 3 | 0.00 | 0 | 0 | ||
| threshold alerts latch | 494 | 0.00 | 0 | 0 | ||
| transaction allocation | 226,811 | 0.00 | 0.00 | 0 | 0 | |
| transaction branch allocation | 4,044 | 0.00 | 0 | 0 | ||
| undo global data | 2,304,778 | 0.02 | 0.00 | 0 | 0 | |
| virtual circuit buffers | 3 | 0.00 | 0 | 0 | ||
| virtual circuit holder | 3 | 0.00 | 0 | 0 | ||
| virtual circuit queues | 3 | 0.00 | 0 | 0 |
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
|---|---|---|---|---|
| cache buffers chains | 1,671,201,628 | 3,719,613 | 11,262 | 3,707,369 |
| gcs partitioned table hash | 528,868,761 | 934,721 | 3 | 934,729 |
| row cache objects | 180,893,784 | 793,570 | 2,110 | 791,712 |
| gcs remastering latch | 23,734,561 | 778,185 | 7 | 777,278 |
| gc element | 172,711,661 | 331,374 | 3,619 | 327,910 |
| gcs resource hash | 324,248,929 | 289,534 | 851 | 288,725 |
| cache buffers lru chain | 54,453,029 | 159,142 | 583 | 158,574 |
| shared pool | 32,466,445 | 100,174 | 13,585 | 87,188 |
| object queue header operation | 286,501,656 | 57,956 | 6,771 | 51,814 |
| gcs opaque info freelist | 10,703,596 | 45,220 | 48 | 45,173 |
| ges resource hash list | 25,127,009 | 24,727 | 1,029 | 23,706 |
| mostly latch-free SCN | 612,436 | 15,534 | 1 | 15,533 |
| gcs resource freelist | 30,171,560 | 14,929 | 15 | 14,914 |
| enqueue hash chains | 9,375,233 | 10,500 | 34 | 10,466 |
| active service list | 20,353,273 | 6,421 | 521 | 5,908 |
| KJCT flow control latch | 33,759,847 | 5,341 | 14 | 5,327 |
| Lsod array latch | 914,003 | 5,023 | 161 | 4,863 |
| messages | 3,465,042 | 4,861 | 11 | 4,851 |
| call allocation | 275,977 | 4,257 | 2,471 | 1,912 |
| cache table scan latch | 2,229,819 | 4,213 | 10 | 4,203 |
| multiblock read objects | 6,512,829 | 3,912 | 12 | 3,900 |
| KJC message pool free list | 2,038,528 | 2,834 | 19 | 2,818 |
| redo allocation | 2,960,199 | 2,721 | 20 | 2,701 |
| redo writing | 1,871,491 | 1,237 | 10 | 1,228 |
| ges group table | 12,677,749 | 1,231 | 1 | 1,230 |
| process allocation | 190,699 | 1,112 | 781 | 371 |
| session idle bit | 78,421,081 | 925 | 2 | 923 |
| ges caches resource lists | 3,065,883 | 623 | 13 | 610 |
| undo global data | 2,304,778 | 520 | 1 | 519 |
| channel operations parent latch | 9,223,399 | 476 | 2 | 474 |
| ASM map operation hash table | 52,901,431 | 402 | 1 | 401 |
| resmgr:free threads list | 147,882 | 346 | 1 | 345 |
| parameter table management | 329,457 | 331 | 77 | 255 |
| OS process: request allocation | 139,064 | 313 | 2 | 311 |
| active checkpoint queue latch | 71,270 | 313 | 2 | 311 |
| session switching | 70,245 | 228 | 1 | 227 |
| Result Cache: RC Latch | 39,345 | 192 | 10 | 182 |
| shared pool simulator | 1,554,459 | 176 | 35 | 142 |
| session state list latch | 164,489 | 107 | 14 | 93 |
| dummy allocation | 147,885 | 105 | 2 | 103 |
| space background task latch | 14,250 | 79 | 2 | 77 |
| ksv class latch | 83,082 | 38 | 1 | 37 |
| cache buffer handles | 37,875 | 28 | 5 | 23 |
| archive process latch | 1,357 | 2 | 2 | 0 |
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|---|---|---|---|
| ASM map operation hash table | kffmTranslate | 0 | 1 | 0 |
| KJC message pool free list | kjcsmpav: allocate a msg buffer | 0 | 10 | 18 |
| KJC message pool free list | kjcspfmbq: free vector of msg buffers | 0 | 8 | 0 |
| KJC message pool free list | kjcsombd: free freelist msg buffs | 0 | 1 | 1 |
| KJCT flow control latch | kjctcsnd: send normal message | 0 | 10 | 10 |
| KJCT flow control latch | kjcts_sedeqv2: dequeue a vector of msgs | 0 | 2 | 0 |
| KJCT flow control latch | kjcts_sqenq: queue a message | 0 | 2 | 2 |
| Lsod array latch | kfklsodtablCleanup | 0 | 161 | 161 |
| OS process: request allocation | kso_new_process | 0 | 1 | 0 |
| OS process: request allocation | ksoreqholder_delete | 0 | 1 | 2 |
| Result Cache: RC Latch | Result Cache: Serialization12 | 0 | 29 | 22 |
| active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 2 | 2 |
| active service list | kswslogon: session logout | 0 | 911 | 129 |
| active service list | kswsite: service iterator | 0 | 30 | 0 |
| active service list | kswslogon: session login | 0 | 4 | 3 |
| active service list | kswsgetso: get service object | 0 | 1 | 781 |
| active service list | kswsgsnp: get service name ptr | 0 | 1 | 29 |
| archive process latch | kcrrsarc | 0 | 2 | 0 |
| cache buffer handles | kcbzfs | 0 | 3 | 4 |
| cache buffer handles | kcbzgs | 0 | 2 | 1 |
| cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 3,663 | 3,854 |
| cache buffers chains | kcbgcur_2 | 0 | 2,976 | 1,877 |
| cache buffers chains | kcbgtcr_2 | 0 | 2,093 | 1,842 |
| cache buffers chains | kcbgtcr: fast path | 0 | 2,043 | 81 |
| cache buffers chains | kclcls_3 | 0 | 800 | 184 |
| cache buffers chains | kcbzwb | 0 | 703 | 748 |
| cache buffers chains | kcbchg1: mod cr pin | 0 | 442 | 241 |
| cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 221 | 0 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 190 | 801 |
| cache buffers chains | kcbgcur_4 | 0 | 183 | 364 |
| cache buffers chains | kcbchg1: clear MS bit | 0 | 72 | 1,721 |
| cache buffers chains | kcbzgb: scan from tail. nowait | 0 | 46 | 0 |
| cache buffers chains | kcbrls: fast release | 0 | 31 | 140 |
| cache buffers chains | kcbrls_2 | 0 | 22 | 254 |
| cache buffers chains | kcllkopesc | 0 | 21 | 3 |
| cache buffers chains | kclbla | 0 | 18 | 15 |
| cache buffers chains | kcbgtcr: kslbegin shared | 0 | 13 | 12 |
| cache buffers chains | kcbgcur: fast path (shr) | 0 | 10 | 25 |
| cache buffers chains | kcbivbr | 0 | 9 | 12 |
| cache buffers chains | kcbnew: new latch again | 0 | 7 | 1 |
| cache buffers chains | kcbzibmlt: finish free bufs | 0 | 5 | 67 |
| cache buffers chains | kcl_fairness | 0 | 4 | 0 |
| cache buffers chains | kcbbxsv | 0 | 3 | 5 |
| cache buffers chains | kcbnlc | 0 | 3 | 251 |
| cache buffers chains | kcbzib: finish processing buffer | 0 | 3 | 67 |
| cache buffers chains | kcbchg1: aux pin | 0 | 2 | 0 |
| cache buffers chains | kcbget: fast exchange | 0 | 2 | 1 |
| cache buffers chains | kclwcrs | 0 | 2 | 24 |
| cache buffers chains | kclwrt | 0 | 2 | 0 |
| cache buffers chains | kcbcge | 0 | 1 | 49 |
| cache buffers chains | kcbgtcr_1 | 0 | 1 | 0 |
| cache buffers chains | kclcqchk | 0 | 1 | 0 |
| cache buffers lru chain | kcbzgws | 0 | 355 | 0 |
| cache buffers lru chain | kcbzgb_2 | 0 | 179 | 248 |
| cache buffers lru chain | kcbzgb | 0 | 17 | 12 |
| cache buffers lru chain | kcbzfw | 0 | 16 | 2 |
| cache buffers lru chain | kcbzar: KSLNBEGIN | 0 | 11 | 0 |
| cache buffers lru chain | kcbo_link_q | 0 | 2 | 2 |
| cache buffers lru chain | kcbbic2 | 0 | 1 | 4 |
| cache buffers lru chain | kcbzgm | 0 | 1 | 0 |
| cache buffers lru chain | kcbzibmlt: free buffers | 0 | 1 | 309 |
| cache table scan latch | kcbz_find_table_scan_read_buffer | 0 | 7 | 0 |
| cache table scan latch | kcbz_free_table_scan_read_buffer | 0 | 3 | 10 |
| call allocation | ksuxds | 0 | 2,425 | 1,806 |
| call allocation | ksudlp: top call | 0 | 39 | 535 |
| call allocation | ksucrp: top call | 0 | 5 | 76 |
| call allocation | ksuinfos_modact | 0 | 1 | 34 |
| call allocation | ksuprc | 0 | 1 | 9 |
| channel operations parent latch | ksrchdelete_sub() | 0 | 2 | 2 |
| channel operations parent latch | ksrmfree() | 0 | 1 | 0 |
| dummy allocation | ktcscnfy | 0 | 2 | 1 |
| enqueue hash chains | ksqrcl | 0 | 12 | 23 |
| enqueue hash chains | ksqgtl3 | 0 | 11 | 5 |
| enqueue hash chains | ksqcmi: if lk mode not requested | 0 | 8 | 2 |
| enqueue hash chains | ksqcmi: if lk mode requested | 0 | 3 | 4 |
| gc element | kclnfndnewm | 0 | 2,426 | 1,028 |
| gc element | kclollnumiter_4 | 0 | 900 | 0 |
| gc element | kclplz | 0 | 353 | 341 |
| gc element | kclulb | 0 | 208 | 1,383 |
| gc element | kclchkping | 0 | 140 | 2 |
| gc element | kclbla | 0 | 91 | 0 |
| gc element | KCLUNLNK | 0 | 70 | 754 |
| gc element | kclplz_1 | 0 | 50 | 76 |
| gc element | kclcqchk | 0 | 24 | 83 |
| gc element | kcl_fairness | 0 | 8 | 0 |
| gc element | kclnfndx | 0 | 7 | 26 |
| gc element | kclnfnds | 0 | 6 | 555 |
| gc element | kclcontext | 0 | 5 | 7 |
| gc element | kclnfndnew | 0 | 4 | 2 |
| gc element | kclexpand_2 | 0 | 2 | 3 |
| gc element | kclfwrite1 | 0 | 2 | 2 |
| gc element | kclcqchk_1 | 0 | 1 | 2 |
| gc element | kcllwr | 0 | 1 | 0 |
| gc element | kclnfnd | 0 | 1 | 11 |
| gc element | kclprm | 0 | 1 | 0 |
| gc element | kclrwrite | 0 | 1 | 2 |
| gcs opaque info freelist | kjbrcvt save opaque info | 0 | 25 | 32 |
| gcs opaque info freelist | kjbrinfofree free opaque info | 0 | 23 | 16 |
| gcs partitioned table hash | ikjfcdrmrfg end step scan pts | 0 | 3 | 0 |
| gcs partitioned table hash | kjdrptref insert into pt table | 0 | 1 | 0 |
| gcs remastering latch | kjdrdwnlk writer latch | 0 | 6 | 0 |
| gcs remastering latch | kjfcdrmrfg beginning | 0 | 2 | 0 |
| gcs resource freelist | kjbralc add resource | 0 | 14 | 2 |
| gcs resource freelist | kjbrfr_bg2 | 0 | 1 | 13 |
| gcs resource hash | kjblocalobj_nolock | 0 | 269 | 258 |
| gcs resource hash | kjbrrcfwst | 0 | 193 | 3 |
| gcs resource hash | kjbcropen | 0 | 144 | 146 |
| gcs resource hash | kjbassume | 0 | 113 | 19 |
| gcs resource hash | kjbconvert | 0 | 48 | 0 |
| gcs resource hash | kjbopen | 0 | 18 | 0 |
| gcs resource hash | kjbopen:affinity | 0 | 14 | 0 |
| gcs resource hash | kjblpast | 0 | 13 | 59 |
| gcs resource hash | kjbclose | 0 | 12 | 221 |
| gcs resource hash | kjbmpopen | 0 | 11 | 34 |
| gcs resource hash | kjbcrconvert | 0 | 4 | 0 |
| gcs resource hash | kjbmpclose | 0 | 3 | 51 |
| gcs resource hash | kjbcrcomplete | 0 | 2 | 6 |
| gcs resource hash | kjbmdowncvt | 0 | 2 | 17 |
| gcs resource hash | kjbmprlst: shadow | 0 | 2 | 2 |
| gcs resource hash | kclfwrite1 | 0 | 1 | 1 |
| gcs resource hash | kclgrantlk_1 | 0 | 1 | 0 |
| gcs resource hash | kjbrrcres_99 | 0 | 1 | 5 |
| ges group table | kjgdgll: move a lock from group lock list to process lock list | 0 | 1 | 1 |
| ges resource hash list | kjrmas1: lookup master node | 0 | 542 | 14 |
| ges resource hash list | kjucvl: lock convert request | 0 | 357 | 428 |
| ges resource hash list | kjakcai: search for resp by resname | 0 | 49 | 2 |
| ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 44 | 0 |
| ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 14 | 406 |
| ges resource hash list | kjrref: find matched resource | 0 | 13 | 71 |
| ges resource hash list | kjakoca: search for resp by resname | 0 | 5 | 108 |
| ges resource hash list | kjcvscn: remove from scan queue | 0 | 5 | 0 |
| ges resource table freelist | kjchc: clean resource cache | 0 | 9 | 0 |
| ges resource table freelist | kjruch: cached obj cleanup | 0 | 3 | 0 |
| ges resource table freelist | kjrm2c: move resource to cache | 0 | 1 | 13 |
| ksv class latch | ksvclsl: create | 0 | 1 | 1 |
| messages | ksaamb: after wakeup | 0 | 11 | 6 |
| mostly latch-free SCN | kcslcu3 | 0 | 1 | 1 |
| multiblock read objects | kcbzibmlt | 0 | 8 | 8 |
| multiblock read objects | kcbzibmlt: normal mbr free | 0 | 4 | 4 |
| object queue header operation | kclobj_5 | 0 | 6,131 | 613 |
| object queue header operation | kclobj_1 | 0 | 331 | 47 |
| object queue header operation | kclobj_2 | 0 | 217 | 141 |
| object queue header operation | kcbo_unlink_q | 0 | 164 | 5,401 |
| object queue header operation | kcbo_ivbo | 0 | 21 | 11 |
| object queue header operation | kcbo_switch_cq | 0 | 14 | 6 |
| object queue header operation | kcbo_link_q | 0 | 11 | 646 |
| object queue header operation | kcbo_sw_buf | 0 | 1 | 0 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 4 |
| object queue header operation | kcldbufs | 0 | 1 | 2 |
| object queue header operation | kclobj_6 | 0 | 1 | 6 |
| parameter table management | ksp_param_table_free | 0 | 72 | 0 |
| parameter table management | kspcpy | 0 | 27 | 1 |
| process allocation | ksucrp:1 | 0 | 581 | 0 |
| process allocation | ksudlp | 0 | 124 | 232 |
| process allocation | ksuapc | 0 | 39 | 454 |
| process allocation | ksufap: active procs | 0 | 37 | 93 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 9 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 3 | 0 | 9 | 10 |
| redo allocation | kcrfw_redo_gen: redo allocation 2 | 0 | 2 | 0 |
| redo writing | kcrfws: in loop | 0 | 7 | 7 |
| redo writing | kcrfwcr | 0 | 2 | 1 |
| redo writing | kcrfrsn | 0 | 1 | 2 |
| resmgr:free threads list | kskthrcreate | 0 | 1 | 1 |
| row cache objects | kqrpre: find obj | 0 | 820 | 989 |
| row cache objects | kqrso | 0 | 570 | 301 |
| row cache objects | kqreqd: reget | 0 | 390 | 69 |
| row cache objects | kqreqd | 0 | 316 | 744 |
| row cache objects | kqrbgl | 0 | 4 | 1 |
| row cache objects | kqrigt | 0 | 2 | 0 |
| row cache objects | kqrigt2 | 0 | 2 | 0 |
| session idle bit | ksupuc: set busy | 0 | 2 | 1 |
| session state list latch | kpseqd | 0 | 12 | 0 |
| session state list latch | kpscad | 0 | 2 | 1 |
| session switching | kskexeall | 0 | 1 | 1 |
| shared pool | kghalo | 0 | 12,593 | 6,631 |
| shared pool | kghupr1 | 0 | 376 | 3,457 |
| shared pool | kghalp | 0 | 340 | 2,160 |
| shared pool | kghfre | 0 | 182 | 1,074 |
| shared pool | kgh_heap_sizes | 0 | 43 | 208 |
| shared pool | kgh_next_free | 0 | 40 | 2 |
| shared pool | kghasp | 0 | 11 | 49 |
| shared pool | kghfrunp: clatch: nowait | 0 | 5 | 0 |
| shared pool | kghfrunp: clatch: wait | 0 | 1 | 1 |
| shared pool simulator | kglsim_upd_newhp | 0 | 35 | 23 |
| space background task latch | ktsj_grab_task | 0 | 2 | 2 |
| undo global data | ktudnx:child | 0 | 1 | 0 |
| Mutex Type | Location | Sleeps | Wait Time (ms) |
|---|---|---|---|
| Library Cache | kglhdgn2 106 | 30,787 | 0 |
| Library Cache | kgllkdl1 85 | 16,939 | 0 |
| Library Cache | kglget1 1 | 15,854 | 0 |
| Cursor Pin | kkslce [KKSCHLPIN2] | 13,709 | 0 |
| Library Cache | kgllkc1 57 | 9,617 | 0 |
| Library Cache | kglpnal2 91 | 5,137 | 0 |
| Library Cache | kglhdgn1 62 | 4,133 | 0 |
| Library Cache | kgldtin1 42 | 3,442 | 0 |
| Library Cache | kgllkal1 80 | 3,021 | 0 |
| Library Cache | kglpin1 4 | 2,704 | 0 |
| Library Cache | kglobpn1 71 | 2,314 | 0 |
| Library Cache | kglhdgh1 64 | 1,652 | 0 |
| Library Cache | kglpndl1 95 | 1,542 | 0 |
| Library Cache | kglpnal1 90 | 1,079 | 0 |
| Library Cache | kglget2 2 | 707 | 0 |
| Library Cache | kglrfcl1 79 | 362 | 0 |
| Cursor Parent | kkscsAddChildNode [KKSPRTLOC34] | 337 | 0 |
| Library Cache | kglllal3 111 | 251 | 0 |
| Cursor Pin | kksLockDelete [KKSCHLPIN6] | 239 | 0 |
| Library Cache | kglini1 32 | 221 | 0 |
| Library Cache | kglobld1 75 | 125 | 0 |
| Cursor Pin | kksfbc [KKSCHLFSP2] | 116 | 0 |
| Cursor Parent | kkscsPruneChild [KKSPRTLOC35] | 115 | 0 |
| Library Cache | kglllal1 109 | 89 | 0 |
| Library Cache | kgllldl2 112 | 88 | 0 |
| Library Cache | kglhdgc1 102 | 46 | 0 |
| Library Cache | kglrdtin1 44 | 43 | 0 |
| Cursor Pin | kksfbc [KKSCHLPIN1] | 35 | 0 |
| Library Cache | kglUpgradeLock 119 | 34 | 0 |
| Library Cache | kglati1 45 | 21 | 0 |
| Library Cache | kgllkal3 82 | 13 | 0 |
| hash table | kkshGetNextChild [KKSHBKLOC1] | 4 | 0 |
| Library Cache | kglGetHandleReference 124 | 3 | 0 |
| Library Cache | kglReleaseHandleReference 125 | 3 | 0 |
| hash table | kkscsSearchChildList [KKSHBKLOC2] | 1 | 0 |
| hash table | kkshListChanged [KKSHBKLOC10] | 1 | 0 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | ISC_USER | TABLE | 76,485,184 | 11.55 | |
| ISC | ISC_TBS | ISC_ACTOR_ROLE_R | TABLE | 55,774,080 | 8.42 | |
| ISC | ISC_TBS | MLOG$_ISC_USER | TABLE | 44,777,856 | 6.76 | |
| ISCAS | ISCAS_TBS | SAS_STATISTICS_DAY_LOGIN_USERS | TABLE | 38,878,368 | 5.87 | |
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 21,828,224 | 3.30 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 21,001,028 | 16.72 | |
| ISC | ISC_TBS | GETUSERBYAPPID_MVIEW | TABLE | 19,403,518 | 15.45 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 18,343,989 | 14.60 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 16,245,664 | 12.93 | |
| ISC | ISC_TBS | GETUSERSBYORGROLE_MVIEW | TABLE | 12,733,631 | 10.14 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 5,144,319 | 21.55 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 4,170,026 | 17.47 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 4,027,633 | 16.87 | |
| ISC | ISC_TBS | GETUSERSBYORGROLE_MVIEW | TABLE | 3,889,766 | 16.30 | |
| ISC | ISC_TBS | GETUSERSBYSPORGID_MVIEW | TABLE | 3,678,392 | 15.41 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 5,144,319 | 21.55 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 4,170,026 | 17.47 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 4,027,633 | 16.87 | |
| ISC | ISC_TBS | GETUSERSBYORGROLE_MVIEW | TABLE | 3,889,766 | 16.30 | |
| ISC | ISC_TBS | GETUSERSBYSPORGID_MVIEW | TABLE | 3,678,392 | 15.41 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | SYS_LOB0000075835C00011$$ | LOB | 168 | 11.39 | |
| ISC | ISC_TBS | SYS_LOB0000075839C00006$$ | LOB | 2 | 0.14 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
|---|---|---|---|---|---|---|
| ISCAS | ISCAS_TBS | SAS_STANDARD_DB_LOG_201411 | TABLE | 59,632 | 43.17 | |
| SYS | SYSTEM | AUD$ | TABLE | 4,883 | 3.53 | |
| ISC | ISC_TBS | IDX_USER_RES_R_VIEW_3 | INDEX | 2,061 | 1.49 | |
| ISC | ISC_TBS | IDX_ORGROLE_RES_USER_MVIEW | INDEX | 1,708 | 1.24 | |
| ISCAS | ISCAS_TBS | SAS_STATISTICS_DAY_LOGIN_USERS | TABLE | 1,403 | 1.02 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
|---|---|---|---|---|---|---|
| ISCAS | ISCAS_TBS | SAS_STANDARD_DB_LOG_201411 | TABLE | 19,912 | 28.56 | |
| SYS | SYSTEM | AUD$ | TABLE | 4,492 | 6.44 | |
| ISC | ISC_TBS | IDX_USER_RES_R_VIEW_3 | INDEX | 1,666 | 2.39 | |
| ISC | ISC_TBS | IDX_ORGROLE_RES_USER_MVIEW | INDEX | 1,602 | 2.30 | |
| ISCAS | ISCAS_TBS | SAS_STATISTICS_DAY_LOGIN_USERS | TABLE | 1,396 | 2.00 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
|---|---|---|---|---|---|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1493581804_8581 | TABLE PARTITION | 253 | 2.75 |
| ** MISSING ** | TEMP | ** TRANSIENT: 5435392 | ** MISSING ** | UNDEFINED | 82 | 0.89 |
| ISC | ISC_TBS | SYS_LOB0000075835C00011$$ | LOB | 8 | 0.09 | |
| ISC | ISC_TBS | SYS_LOB0000075839C00006$$ | LOB | 8 | 0.09 | |
| ** MISSING ** | TEMP | ** MISSING: -40014066/5271552 | ** MISSING ** | UNDEFINED | 2 | 0.02 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | IDX_ISC_ROLE_LAYER_BY_ORG_3 | INDEX | 493 | 23.91 | |
| ISC | ISC_TBS | IDX_ISC_SPECIALORG_UNIT_1 | INDEX | 247 | 11.98 | |
| ISC | ISC_TBS | GETUSERBYAPPID_MVIEW | TABLE | 134 | 6.50 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 104 | 5.04 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 104 | 5.04 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
|---|---|---|---|---|---|---|
| ** MISSING ** | TEMP | ** TRANSIENT: 5716096 | ** MISSING ** | UNDEFINED | 2,186,016 | 9.29 |
| ** MISSING ** | TEMP | ** TRANSIENT: 5696768 | ** MISSING ** | UNDEFINED | 2,069,968 | 8.80 |
| ** MISSING ** | TEMP | ** TRANSIENT: 5366272 | ** MISSING ** | UNDEFINED | 1,766,176 | 7.51 |
| ** MISSING ** | TEMP | ** TRANSIENT: 5350912 | ** MISSING ** | UNDEFINED | 1,637,008 | 6.96 |
| ** MISSING ** | TEMP | ** TRANSIENT: 5435392 | ** MISSING ** | UNDEFINED | 1,232,640 | 5.24 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | MLOG$ | TABLE | 452 | 58.47 | |
| SYS | SYSTEM | DBMS_LOCK_ALLOCATED | TABLE | 230 | 29.75 | |
| SYS | SYSTEM | SNAP_LOADERTIME$ | TABLE | 45 | 5.82 | |
| ISC | ISC_TBS | IDX_USER_RES_R_EXT_VIEW_TEMP_1 | INDEX | 12 | 1.55 | |
| ISC | ISC_TBS | IDX_ORGROLE_RES_USER_MVIEW | INDEX | 8 | 1.03 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | IDX_USER_RES_R_EXT_VIEW_TEMP | INDEX | 1 | 100.00 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | AUD$ | TABLE | 13,560 | 74.29 | |
| SYS | SYSTEM | SNAP_LOADERTIME$ | TABLE | 1,201 | 6.58 | |
| SYS | SYSTEM | JOB$ | TABLE | 963 | 5.28 | |
| SYS | SYSTEM | I_SLOG1 | INDEX | 640 | 3.51 | |
| SYS | SYSTEM | SUMDETAIL$ | TABLE | 348 | 1.91 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
|---|---|---|---|---|---|---|
| SYS | SYSTEM | AUD$ | TABLE | 22,744 | 81.61 | |
| ISC | ISC_TBS | ISC_ACTOR_ROLE_R | TABLE | 1,671 | 6.00 | |
| ISC | ISC_TBS | USER_RES_R_VIEW | TABLE | 761 | 2.73 | |
| ISC | ISC_TBS | ISC_USER_SPORG | TABLE | 545 | 1.96 | |
| ISCAS | ISCAS_TBS | SAS_STANDARD_DB_LOG_201411 | TABLE | 415 | 1.49 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 375,594 | 29.86 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 321,855 | 25.59 | |
| ISC | ISC_TBS | GETUSERSBYSPORGID_MVIEW | TABLE | 222,831 | 17.72 | |
| ISC | ISC_TBS | GETUSERSBYORGROLE_MVIEW | TABLE | 106,655 | 8.48 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 57,463 | 4.57 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
|---|---|---|---|---|---|---|
| ISC | ISC_TBS | GETUSERSPERMISSION_MVIEW | TABLE | 1,137,603 | 19.77 | |
| ISC | ISC_TBS | GETUSERSBYORG_MVIEW | TABLE | 857,413 | 14.90 | |
| ISC | ISC_TBS | GETUSERSBYSPORGID_MVIEW | TABLE | 821,726 | 14.28 | |
| ISC | ISC_TBS | GETUSERSBYORGROLE_MVIEW | TABLE | 783,765 | 13.62 | |
| ISC | ISC_TBS | GETUSERORGPATHBYUSERID_MVIEW | TABLE | 769,821 | 13.38 |
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|---|---|---|---|---|---|
| dc_awr_control | 204 | 1.47 | 0 | 3 | 1 | |
| dc_files | 190 | 49.47 | 0 | 3 | 32 | |
| dc_global_oids | 404,779 | 0.00 | 0 | 0 | 34 | |
| dc_histogram_data | 19,322,678 | 0.02 | 0 | 0 | 2,403 | |
| dc_histogram_defs | 15,229,866 | 0.05 | 0 | 36 | 2,824 | |
| dc_object_grants | 77,297 | 0.00 | 0 | 0 | 4 | |
| dc_objects | 25,222,602 | 0.01 | 0 | 2,223 | 1,225 | |
| dc_profiles | 73,387 | 0.00 | 0 | 0 | 1 | |
| dc_rollback_segments | 28,209 | 0.02 | 0 | 2 | 113 | |
| dc_segments | 5,304,315 | 0.04 | 0 | 38 | 802 | |
| dc_sequences | 132 | 43.94 | 0 | 132 | 2 | |
| dc_table_scns | 39,924 | 5.27 | 0 | 455 | 19 | |
| dc_tablespaces | 794,554 | 0.00 | 0 | 0 | 9 | |
| dc_users | 6,960,920 | 0.00 | 0 | 0 | 86 | |
| global database name | 92,605 | 0.00 | 0 | 0 | 2 | |
| outstanding_alerts | 124 | 90.32 | 0 | 8 | 0 | |
| sch_lj_oids | 21 | 28.57 | 0 | 0 | 4 |
| Cache | GES Requests | GES Conflicts | GES Releases |
|---|---|---|---|
| dc_awr_control | 9 | 3 | 0 |
| dc_files | 98 | 0 | 62 |
| dc_global_oids | 13 | 0 | 14 |
| dc_histogram_defs | 8,124 | 0 | 7,574 |
| dc_objects | 8,115 | 1,663 | 1,229 |
| dc_rollback_segments | 8 | 6 | 0 |
| dc_segments | 2,018 | 17 | 1,849 |
| dc_sequences | 264 | 45 | 15 |
| dc_table_scns | 31,715 | 2,104 | 0 |
| dc_users | 28 | 0 | 29 |
| outstanding_alerts | 231 | 107 | 2 |
| sch_lj_oids | 6 | 0 | 9 |
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|---|---|---|---|---|---|
| ACCOUNT_STATUS | 138,139 | 0.00 | 0 | 0 | 0 | |
| BODY | 99,524 | 0.07 | 126,028 | 0.08 | 21 | 0 |
| CLUSTER | 173 | 2.89 | 175 | 2.86 | 0 | 0 |
| DBLINK | 138,147 | 0.00 | 0 | 0 | 0 | |
| EDITION | 73,608 | 0.00 | 146,978 | 0.00 | 0 | 0 |
| INDEX | 413 | 18.16 | 413 | 18.16 | 0 | 0 |
| JAVA DATA | 14 | 0.00 | 0 | 0 | 0 | |
| JAVA SOURCE | 7 | 85.71 | 7 | 85.71 | 0 | 0 |
| OBJECT ID | 26 | 100.00 | 0 | 0 | 0 | |
| QUEUE | 2,481 | 0.00 | 3,150 | 0.03 | 1 | 0 |
| RULESET | 1 | 0.00 | 10 | 20.00 | 2 | 0 |
| SCHEMA | 74,837 | 0.00 | 0 | 0 | 0 | |
| SQL AREA | 1,523,448 | 26.30 | 6,539,982 | 19.21 | 17,693 | 10,848 |
| SQL AREA BUILD | 421,995 | 96.18 | 0 | 0 | 0 | |
| SQL AREA STATS | 421,606 | 96.26 | 421,595 | 96.26 | 0 | 0 |
| SUBSCRIPTION | 60 | 1.67 | 60 | 3.33 | 1 | 0 |
| SUMMARY | 28,703 | 0.65 | 26,576 | 1.03 | 81 | 1,548 |
| TABLE/PROCEDURE | 1,843,939 | 0.04 | 5,205,684 | 0.10 | 2,737 | 0 |
| TRANSFORMATION | 1,080 | 0.00 | 1,080 | 0.00 | 0 | 0 |
| TRIGGER | 10,906 | 0.11 | 13,649 | 0.27 | 24 | 0 |
| Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
|---|---|---|---|---|---|
| ACCOUNT_STATUS | 138,139 | 0 | 0 | 0 | 0 |
| BODY | 0 | 125,681 | 125,681 | 0 | 0 |
| CLUSTER | 175 | 175 | 175 | 0 | 0 |
| DBLINK | 138,147 | 0 | 0 | 0 | 0 |
| EDITION | 73,608 | 73,608 | 73,608 | 0 | 0 |
| INDEX | 413 | 413 | 413 | 0 | 0 |
| JAVA SOURCE | 0 | 7 | 7 | 0 | 0 |
| QUEUE | 1,189 | 3,150 | 3,150 | 0 | 0 |
| RULESET | 0 | 10 | 10 | 0 | 0 |
| SCHEMA | 73,399 | 0 | 0 | 0 | 0 |
| SUBSCRIPTION | 0 | 60 | 60 | 0 | 0 |
| SUMMARY | 26,576 | 26,574 | 26,574 | 1,184 | 1,184 |
| TABLE/PROCEDURE | 1,882,992 | 2,221,199 | 2,221,199 | 0 | 0 |
| TRANSFORMATION | 1,080 | 1,080 | 1,080 | 0 | 0 |
| TRIGGER | 0 | 13,649 | 13,649 | 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 | 8,160.00 | 8,160.00 | 7,584.00 | 10,656.00 | 0 | SHR/DEF |
| KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| PGA Target | 4,832.00 | 4,832.00 | 4,832.00 | 4,832.00 | 0 | STA/ |
| RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| SGA Target | 14,496.00 | 14,496.00 | 14,496.00 | 14,496.00 | 0 | STA/ |
| Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| java pool | 224.00 | 224.00 | 224.00 | 224.00 | 0 | SHR/DEF |
| large pool | 32.00 | 32.00 | 32.00 | 32.00 | 0 | STA/ |
| shared pool | 5,920.00 | 5,920.00 | 3,392.00 | 6,496.00 | 0 | GRO/DEF |
| streams pool | 32.00 | 32.00 | 32.00 | 64.00 | 0 | SHR/DEF |
| 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 | 1,216.73 | 3.17 | 6.73 | 53 | 54 | 384 | 384 | |
B | Freeable | 131.44 | 0.00 | 1.10 | 1.24 | 11 | 119 | 119 | |
B | SQL | 46.48 | 33.92 | 0.13 | 0.88 | 14 | 140 | 345 | 320 |
B | PL/SQL | 6.18 | 4.73 | 0.02 | 0.08 | 1 | 2 | 382 | 381 |
| E | Other | 1,145.01 | 3.12 | 6.86 | 53 | 54 | 367 | 367 | |
E | Freeable | 122.00 | 0.00 | 1.18 | 1.31 | 11 | 103 | 103 | |
E | SQL | 18.18 | 6.89 | 0.06 | 0.21 | 3 | 139 | 328 | 299 |
E | PL/SQL | 2.10 | 1.01 | 0.01 | 0.01 | 0 | 2 | 365 | 364 |
| SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
|---|---|---|
| Database Buffers | 8,556,380,160 | |
| Fixed Size | 2,243,112 | |
| Redo Buffers | 64,106,496 | |
| Variable Size | 6,509,561,304 |
| Pool | Name | Begin MB | End MB | % Diff |
|---|---|---|---|---|
| java | JOXLE | 11.59 | 11.59 | 0.07 |
| java | free memory | 211.55 | 211.55 | -0.00 |
| large | ASM map operations hashta | 0.38 | 0.38 | 0.00 |
| large | PX msg pool | 7.81 | 7.81 | 0.00 |
| large | free memory | 23.81 | 23.81 | 0.00 |
| shared | ASH buffers | 128.00 | 128.00 | 0.00 |
| shared | KGH: NO ACCESS | 657.80 | 657.80 | 0.00 |
| shared | KGLH0 | 971.85 | 968.31 | -0.36 |
| shared | KGLHD | 198.88 | 206.84 | 4.00 |
| shared | Result Cache | 72.77 | 72.77 | 0.00 |
| shared | SQLA | 2,053.88 | 2,053.33 | -0.03 |
| shared | db_block_hash_buckets | 89.00 | 89.00 | 0.00 |
| shared | free memory | 1,086.78 | 1,084.43 | -0.22 |
| shared | gcs resources | 278.81 | 278.81 | 0.00 |
| shared | gcs shadows | 162.64 | 162.64 | 0.00 |
| shared | ges resource | 66.50 | 66.50 | 0.00 |
| shared | kglsim object batch | 68.13 | 68.13 | 0.00 |
| streams | free memory | 32.00 | 32.00 | 0.00 |
| buffer_cache | 8,160.00 | 8,160.00 | 0.00 | |
| fixed_sga | 2.14 | 2.14 | 0.00 | |
| log_buffer | 61.14 | 61.14 | 0.00 |
| Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
|---|---|---|---|---|
| QMON Slaves | 0516 10:14:41 | 0.29 | 0.24 | 0.00 |
| QMON Coordinator | 1221 03:21:51 | 0.00 | 0.00 | 0.00 |
| Rule | Evals | No-SQL Eval% | SQL Execs | CPU(s) | Ela(s) | Eval /Sec | SQL per Eval | Ela(s) per Eval | CPU(s) per Eval | Reloads |
|---|---|---|---|---|---|---|---|---|---|---|
| SYS.ALERT_QUE_R | 10 | 0.00 | 0 | 0.14 | 0.70 | 0.00 | 0.00 | 0.07 | 0.01 | 2 |
| Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
|---|---|---|---|---|---|---|---|---|
| SYS.ALERT_QUE(12733) | 10 | 0 | 100.00 | 0.00 | 1.23 | 0.00 | 0.00 | 56.34 |
| SYS.AQ$_ALERT_QT_E(12732) | 10 | 0 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.00 |
| SYSMAN.MGMT_TASK_Q(68711) | 190 | 190 | 0.00 | 0.00 | 0.18 | 0.18 | 0.00 | 0.00 |
| Queue Name | Enqueue Msgs/sec | Dequeue Msgs/sec | Avg Enqueue sec / msg | Avg Dequeue sec / msg |
|---|---|---|---|---|
| SYS.ALERT_QUE(12733) | 0.00 | 0.00 | 0.12 | |
| SYS.AQ$_ALERT_QT_E(12732) | 0.00 | 0.00 | 0.00 | |
| SYSMAN.MGMT_TASK_Q(68711) | 0.02 | 0.02 | 0.00 | 0.00 |
| Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
|---|---|---|---|---|---|---|
| HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 | |||
| TYQXDB1_3938_TYQXDB1(41)/SYS.ALERT_QUE | 10 | 0 | 10 | 0.00 | 0.00 | 0.00 |
| Avg Total Connections | Avg Active Connections | Avg Total Shared Srvrs | Avg Active Shared Srvrs | Avg Total Dispatchers | Avg Active Dispatchers |
|---|---|---|---|---|---|
| 0 | 0 | 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 % |
|---|---|---|---|---|
| 10,812 | 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 | 10,812 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 10,812 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 10,812 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 10,812 | 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 | 0 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| audit_file_dest | /u01/app/oracle/admin/tyqxdb/adump | |
| audit_trail | DB | |
| cluster_database | TRUE | |
| compatible | 11.2.0.0.0 | |
| control_files | +TYQXDATA/tyqxdb/controlfile/current.260.832014957, +ARCHIVE/tyqxdb/controlfile/current.256.832014957 | |
| db_block_size | 8192 | |
| db_create_file_dest | +TYQXDATA | |
| db_domain | ||
| db_name | tyqxdb | |
| db_recovery_file_dest | +ARCHIVE | |
| db_recovery_file_dest_size | 4558159872 | |
| diagnostic_dest | /u01/app/oracle | |
| dispatchers | (PROTOCOL=TCP) (SERVICE=tyqxdbXDB) | |
| instance_number | 1 | |
| local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.18.153)(PORT=1521)))) | |
| log_archive_dest_1 | location=+ARCHIVE | |
| log_archive_format | %t_%s_%r.dbf | |
| nls_language | SIMPLIFIED CHINESE | |
| nls_territory | CHINA | |
| open_cursors | 1000 | |
| pga_aggregate_target | 5060427776 | |
| processes | 2000 | |
| remote_listener | tyqxscan.role.db:1521 | |
| remote_login_passwordfile | EXCLUSIVE | |
| sessions | 3072 | |
| sga_target | 15200157696 | |
| thread | 1 | |
| undo_tablespace | UNDOTBS1 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| control_files | +ARCHIVE/tyqxdb/controlfile/current.256.832014957 | |
control_files | +TYQXDATA/tyqxdb/controlfile/current.260.832014957 |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| acks for commit broadcast(actual) | 419,768 | 38.79 | 0.85 |
| acks for commit broadcast(logical) | 461,041 | 42.61 | 0.93 |
| broadcast msgs on commit(actual) | 543,542 | 50.23 | 1.10 |
| broadcast msgs on commit(logical) | 582,589 | 53.84 | 1.18 |
| broadcast msgs on commit(wasted) | 45,029 | 4.16 | 0.09 |
| dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
| dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
| flow control messages received | 1 | 0.00 | 0.00 |
| flow control messages sent | 0 | 0.00 | 0.00 |
| gcs apply delta | 0 | 0.00 | 0.00 |
| gcs assume cvt | 0 | 0.00 | 0.00 |
| gcs assume no cvt | 659,066 | 60.91 | 1.33 |
| gcs ast xid | 0 | 0.00 | 0.00 |
| gcs blocked converts | 89,040 | 8.23 | 0.18 |
| gcs blocked cr converts | 1,098,619 | 101.53 | 2.22 |
| gcs compatible basts | 1,112 | 0.10 | 0.00 |
| gcs compatible cr basts (global) | 8,815 | 0.81 | 0.02 |
| gcs compatible cr basts (local) | 5,250,476 | 485.23 | 10.61 |
| 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 | 11,715 | 1.08 | 0.02 |
| gcs dbwr write request msgs | 8,546 | 0.79 | 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 | 1 | 0.00 | 0.00 |
| gcs force cr block only | 29 | 0.00 | 0.00 |
| gcs force cr grant | 57 | 0.01 | 0.00 |
| gcs force cr no current | 0 | 0.00 | 0.00 |
| gcs forward cr to pinged instance | 0 | 0.00 | 0.00 |
| gcs immediate (compatible) converts | 2,540 | 0.23 | 0.01 |
| gcs immediate (null) converts | 438,385 | 40.51 | 0.89 |
| gcs immediate cr (compatible) converts | 9,569,713 | 884.40 | 19.34 |
| gcs immediate cr (null) converts | 23,253,636 | 2,149.03 | 47.00 |
| gcs indirect ast | 145,208 | 13.42 | 0.29 |
| gcs indirect bidless ast | 803 | 0.07 | 0.00 |
| gcs indirect fg ast | 144,405 | 13.35 | 0.29 |
| gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
| gcs lms write request msgs | 2,942 | 0.27 | 0.01 |
| gcs msgs process time(ms) | 682,196 | 63.05 | 1.38 |
| gcs msgs received | 65,342,994 | 6,038.79 | 132.08 |
| gcs new served by master | 32,747 | 3.03 | 0.07 |
| gcs out-of-order msgs | 217 | 0.02 | 0.00 |
| gcs pings refused | 442 | 0.04 | 0.00 |
| gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
| gcs push delta | 0 | 0.00 | 0.00 |
| gcs queued converts | 173 | 0.02 | 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 | 0 | 0.00 | 0.00 |
| gcs share recovery bast | 0 | 0.00 | 0.00 |
| gcs side channel msgs actual | 103,267 | 9.54 | 0.21 |
| gcs side channel msgs logical | 7,119,411 | 657.95 | 14.39 |
| gcs stale cr | 9 | 0.00 | 0.00 |
| gcs undo cr | 953 | 0.09 | 0.00 |
| gcs write notification msgs | 1,269 | 0.12 | 0.00 |
| gcs writes refused | 543 | 0.05 | 0.00 |
| ges msgs process time(ms) | 5,541 | 0.51 | 0.01 |
| ges msgs received | 223,142 | 20.62 | 0.45 |
| global posts dropped | 0 | 0.00 | 0.00 |
| global posts queue time | 356 | 0.03 | 0.00 |
| global posts queued | 210 | 0.02 | 0.00 |
| global posts requested | 210 | 0.02 | 0.00 |
| global posts sent | 210 | 0.02 | 0.00 |
| implicit batch messages received | 1,936,700 | 178.98 | 3.91 |
| implicit batch messages sent | 1,643,246 | 151.86 | 3.32 |
| lmd msg send time(ms) | 268 | 0.02 | 0.00 |
| lms(s) msg send time(ms) | 30 | 0.00 | 0.00 |
| messages flow controlled | 286,832 | 26.51 | 0.58 |
| messages queue sent actual | 2,475,773 | 228.80 | 5.00 |
| messages queue sent logical | 24,270,057 | 2,242.96 | 49.06 |
| messages received actual | 7,045,566 | 651.13 | 14.24 |
| messages received logical | 65,553,609 | 6,058.25 | 132.51 |
| messages sent directly | 1,153,535 | 106.61 | 2.33 |
| messages sent indirectly | 22,720,236 | 2,099.73 | 45.93 |
| messages sent not implicit batched | 38,441 | 3.55 | 0.08 |
| messages sent pbatched | 47,552,104 | 4,394.61 | 96.12 |
| msgs causing lmd to send msgs | 74,863 | 6.92 | 0.15 |
| msgs causing lms(s) to send msgs | 6,853,206 | 633.35 | 13.85 |
| msgs received queue time (ms) | 1,185,274 | 109.54 | 2.40 |
| msgs received queued | 65,555,331 | 6,058.41 | 132.51 |
| msgs sent queue time (ms) | 1,339,507 | 123.79 | 2.71 |
| msgs sent queue time on ksxp (ms) | 10,596,506 | 979.29 | 21.42 |
| msgs sent queued | 22,909,030 | 2,117.18 | 46.31 |
| msgs sent queued on ksxp | 7,426,821 | 686.36 | 15.01 |
| number of broadcasted resources | 0 | 0.00 | 0.00 |
| number of ges deadlock detected | 0 | 0.00 | 0.00 |
| process batch messages received | 3,474,660 | 321.12 | 7.02 |
| process batch messages sent | 4,660,512 | 430.71 | 9.42 |
| Statistic | Total |
|---|---|
| CR Block Requests | 244,668 |
| CURRENT Block Requests | 26,177 |
| Data Block Requests | 246,172 |
| Undo Block Requests | 769 |
| TX Block Requests | 6,785 |
| Current Results | 271,927 |
| Private results | 8 |
| Zero Results | 420 |
| Disk Read Results | 4 |
| Fail Results | 0 |
| Fairness Down Converts | 229,227 |
| Fairness Clears | 3,568 |
| Free GC Elements | 0 |
| Flushes | 1,109 |
| Flushes Queued | 0 |
| Flush Queue Full | 0 |
| Flush Max Time (us) | 0 |
| Light Works | 543 |
| Errors | 0 |
| Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
|---|---|---|---|---|---|---|
| Pins | 4,040 | 60.84 | 36.88 | 1.16 | 0.69 | 0.42 |
| Flushes | 19,558 | 17.18 | 52.23 | 29.60 | 0.99 | 0.00 |
| Writes | 13,301 | 11.78 | 33.28 | 43.89 | 8.60 | 2.45 |
| CR | Current | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
| 2 | data block | 1,227,879 | 80.21 | 0.05 | 19.74 | 5,743,869 | 84.09 | 0.36 | 15.56 |
| 2 | Others | 18,558 | 95.45 | 3.66 | 0.89 | 9,664 | 98.87 | 0.40 | 0.72 |
| 2 | undo header | 10,228 | 97.55 | 1.50 | 0.96 | 40 | 90.00 | 7.50 | 2.50 |
| 2 | undo block | 1,012 | 98.32 | 0.40 | 1.28 | 1 | 100.00 | 0.00 | 0.00 |
| CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
| 2 | data block | 2.30 | 2.08 | 21.45 | 3.19 | 2.23 | 1.99 | 21.01 | 3.13 |
| 2 | others | 1.60 | 0.82 | 22.06 | 1.33 | 0.82 | 0.79 | 5.00 | 1.61 |
| 2 | undo header | 1.05 | 0.82 | 15.75 | 1.42 | 4.37 | 0.63 | 50.42 | 0.75 |
| 2 | undo block | 0.81 | 0.70 | 27.94 | 0.83 | 0.89 | 0.89 |
| CR | Current | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
| 2 | data block | 0 | 984,854 | 100.00 | 0.00 | 4,829,834 | 100.00 | 0.00 |
| 2 | others | 0 | 17,714 | 100.00 | 0.00 | 9,555 | 100.00 | 0.00 |
| 2 | undo header | 0 | 9,977 | 100.00 | 0.00 | 36 | 100.00 | 0.00 |
| 2 | undo block | 0 | 995 | 100.00 | 0.00 | 1 | 100.00 | 0.00 |
| CR Avg Time (ms) | Current Avg Time (ms) | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
| 2 | data block | 2.08 | 2.08 | 1.99 | 1.99 | |||
| 2 | others | 0.82 | 0.82 | 0.79 | 0.79 | |||
| 2 | undo header | 0.82 | 0.82 | 0.63 | 0.63 | |||
| 2 | undo block | 0.70 | 0.70 | 0.89 | 0.89 |
| Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
|---|---|---|---|---|---|---|
| 1 | 846 | 0.19 | 0.05 | 846 | 0.17 | 0.05 |
| 2 | 846 | 0.68 | 0.52 | 846 | 1.03 | 0.58 |
| Used By | Send Mbytes/sec | Receive Mbytes/sec |
|---|---|---|
| Global Cache | 2.42 | 4.79 |
| Parallel Query | 0.00 | 0.00 |
| DB Locks | 1.50 | 1.32 |
| DB Streams | 0.00 | 0.00 |
| Other | 0.00 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| eth3:1 | 169.254.212.83 | NO | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
| Name | Total | per Remaster Op | Begin Snap | End Snap |
|---|---|---|---|---|
| remaster ops | 25 | 1.00 | ||
| remastered objects | 55 | 2.20 | ||
| replayed locks received | 831,949 | 33,277.96 | ||
| replayed locks sent | 437,393 | 17,495.72 | ||
| resources cleaned | 0 | 0.00 | ||
| remaster time (s) | 49.3 | 1.97 | ||
| quiesce time (s) | 7.0 | 0.28 | ||
| freeze time (s) | 0.8 | 0.03 | ||
| cleanup time (s) | 2.9 | 0.12 | ||
| replay time (s) | 5.4 | 0.22 | ||
| fixwrite time (s) | 15.6 | 0.62 | ||
| sync time (s) | 17.5 | 0.70 | ||
| affinity objects | 60 | 68 |