| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| BPPFEDB | 1195271196 | bppfedb1 | 1 | 04-Mar-14 18:03 | 11.2.0.3.0 | YES |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| bppfedb1 | Linux x86 64-bit | 48 | 24 | 4 | 125.99 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 23867 | 05-Mar-14 11:00:10 | 331 | 4.7 |
| End Snap: | 23868 | 05-Mar-14 11:30:14 | 283 | 5.2 |
| Elapsed: | 30.07 (mins) | |||
| DB Time: | 57.86 (mins) |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 49,408M | 49,408M | Std Block Size: | 8K |
| Shared Pool Size: | 9,472M | 9,472M | Log Buffer: | 53,972K |
| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 1.9 | 0.1 | 0.00 | 0.00 |
| DB CPU(s): | 1.6 | 0.1 | 0.00 | 0.00 |
| Redo size: | 88,028.6 | 2,581.7 | ||
| Logical reads: | 113,249.5 | 3,321.4 | ||
| Block changes: | 528.4 | 15.5 | ||
| Physical reads: | 4,051.6 | 118.8 | ||
| Physical writes: | 38.0 | 1.1 | ||
| User calls: | 2,401.9 | 70.4 | ||
| Parses: | 493.5 | 14.5 | ||
| Hard parses: | 58.3 | 1.7 | ||
| W/A MB processed: | 10.4 | 0.3 | ||
| Logons: | 0.3 | 0.0 | ||
| Executes: | 461.9 | 13.6 | ||
| Rollbacks: | 3.9 | 0.1 | ||
| Transactions: | 34.1 |
| Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.77 | In-memory Sort %: | 100.00 |
| Library Hit %: | 85.62 | Soft Parse %: | 88.19 |
| Execute to Parse %: | -6.86 | Latch Hit %: | 99.86 |
| Parse CPU to Parse Elapsd %: | 107.49 | % Non-Parse CPU: | 91.39 |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 72.14 | 72.43 |
| % SQL with executions>1: | 79.48 | 78.47 |
| % Memory for SQL w/exec>1: | 74.52 | 73.92 |
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| SQL*Net break/reset to client | 441 | 1,489,166 | 3376794 | 42892.09 | Application |
| DB CPU | 2,944 | 84.80 | |||
| db file sequential read | 76,423 | 166 | 2 | 4.78 | User I/O |
| direct path read | 21,331 | 89 | 4 | 2.57 | User I/O |
| SQL*Net message from dblink | 1,207 | 87 | 72 | 2.50 | Network |
| Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|
| 1.79 | 1.52 | 3.5 | 0.5 | 0.3 | 95.9 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 3.6 | 88.4 | 0.0 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 129,015.4 | 129,015.4 |
| SGA use (MB): | 60,160.0 | 60,160.0 |
| PGA use (MB): | 1,437.9 | 1,243.9 |
| % Host Mem used for SGA+PGA: | 47.74 | 47.59 |
| Begin | End | |
|---|---|---|
| Number of Instances: | 2 | 2 |
| Per Second | Per Transaction | |
|---|---|---|
| Global Cache blocks received: | 93.85 | 2.75 |
| Global Cache blocks served: | 155.48 | 4.56 |
| GCS/GES messages received: | 1,019.82 | 29.91 |
| GCS/GES messages sent: | 532.66 | 15.62 |
| DBWR Fusion writes: | 5.24 | 0.15 |
| Estd Interconnect traffic (KB) | 2,297.90 |
| Buffer access - local cache %: | 99.69 |
| Buffer access - remote cache %: | 0.09 |
| Buffer access - disk %: | 0.23 |
| Avg global enqueue get time (ms): | 0.0 |
| Avg global cache cr block receive time (ms): | 0.7 |
| Avg global cache current block receive time (ms): | 0.6 |
| 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 %: | 9.2 |
| Avg global cache cr block flush time (ms): | 1.8 |
| Avg global cache current block pin time (ms): | 391.2 |
| Avg global cache current block send time (ms): | 0.0 |
| Global cache log flushes for current blocks served %: | 0.7 |
| Avg global cache current block flush time (ms): | 13,631.6 |
| Avg message sent queue time (ms): | 0.1 |
| Avg message sent queue time on ksxp (ms): | 0.5 |
| Avg message received queue time (ms): | 0.4 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.0 |
| % of direct sent messages: | 52.68 |
| % of indirect sent messages: | 46.85 |
| % of flow controlled messages: | 0.47 |
| Begin | End | |||||
|---|---|---|---|---|---|---|
| Interface | IP Address | Pub | Source | IP | Pub | Src |
| bond1:1 | 169.254.10.248 | N |
| Statistic Name | Time (s) | % of DB Time |
|---|---|---|
| DB CPU | 2,944.01 | 84.80 |
| sql execute elapsed time | 2,834.42 | 81.64 |
| parse time elapsed | 284.17 | 8.18 |
| hard parse elapsed time | 194.77 | 5.61 |
| connection management call elapsed time | 4.64 | 0.13 |
| PL/SQL execution elapsed time | 4.61 | 0.13 |
| hard parse (sharing criteria) elapsed time | 0.76 | 0.02 |
| sequence load elapsed time | 0.43 | 0.01 |
| hard parse (bind mismatch) elapsed time | 0.43 | 0.01 |
| repeated bind elapsed time | 0.18 | 0.01 |
| PL/SQL compilation elapsed time | 0.10 | 0.00 |
| failed parse elapsed time | 0.05 | 0.00 |
| DB time | 3,471.89 | |
| background elapsed time | 281.67 | |
| background cpu time | 221.76 |
| Statistic | Value | End Value |
|---|---|---|
| BUSY_TIME | 358,163 | |
| IDLE_TIME | 8,343,280 | |
| IOWAIT_TIME | 25,779 | |
| NICE_TIME | 0 | |
| SYS_TIME | 46,227 | |
| USER_TIME | 303,825 | |
| LOAD | 2 | 2 |
| RSRC_MGR_CPU_WAIT_TIME | 0 | |
| PHYSICAL_MEMORY_BYTES | 135,282,409,472 | |
| NUM_CPUS | 48 | |
| NUM_CPU_CORES | 24 | |
| NUM_CPU_SOCKETS | 4 | |
| GLOBAL_RECEIVE_SIZE_MAX | 4,194,304 | |
| GLOBAL_SEND_SIZE_MAX | 1,048,576 | |
| TCP_RECEIVE_SIZE_DEFAULT | 87,380 | |
| TCP_RECEIVE_SIZE_MAX | 4,194,304 | |
| TCP_RECEIVE_SIZE_MIN | 4,096 | |
| TCP_SEND_SIZE_DEFAULT | 16,384 | |
| TCP_SEND_SIZE_MAX | 4,194,304 | |
| TCP_SEND_SIZE_MIN | 4,096 |
| Snap Time | Load | %busy | %user | %sys | %idle | %iowait |
|---|---|---|---|---|---|---|
| 05-Mar 11:00:10 | 1.79 | |||||
| 05-Mar 11:30:14 | 1.52 | 4.12 | 3.49 | 0.53 | 95.88 | 0.30 |
| Wait Class | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | %DB time |
|---|---|---|---|---|---|
| Application | 509 | 0 | 1,489,167 | 2925672 | 42,892.11 |
| DB CPU | 2,944 | 84.80 | |||
| User I/O | 139,765 | 0 | 294 | 2 | 8.48 |
| Cluster | 236,248 | 0 | 143 | 1 | 4.11 |
| Network | 3,003,520 | 0 | 90 | 0 | 2.60 |
| Commit | 54,109 | 0 | 85 | 2 | 2.44 |
| Other | 73,062 | 1 | 27 | 0 | 0.79 |
| Concurrency | 3,702 | 0 | 3 | 1 | 0.09 |
| System I/O | 708 | 0 | 0 | 1 | 0.01 |
| Configuration | 8 | 0 | 0 | 0 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % DB time |
|---|---|---|---|---|---|---|
| SQL*Net break/reset to client | 441 | 0 | 1,489,166 | 3376794 | 0.01 | 42892.09 |
| db file sequential read | 76,423 | 0 | 166 | 2 | 1.24 | 4.78 |
| direct path read | 21,331 | 0 | 89 | 4 | 0.35 | 2.57 |
| SQL*Net message from dblink | 1,207 | 0 | 87 | 72 | 0.02 | 2.50 |
| log file sync | 54,109 | 0 | 85 | 2 | 0.88 | 2.44 |
| gc current block 2-way | 112,319 | 0 | 55 | 0 | 1.83 | 1.58 |
| db file scattered read | 38,418 | 0 | 38 | 1 | 0.62 | 1.10 |
| gc cr block 2-way | 38,607 | 0 | 19 | 0 | 0.63 | 0.53 |
| gc cr multi block request | 23,621 | 0 | 16 | 1 | 0.38 | 0.45 |
| gc cr block busy | 4,924 | 0 | 13 | 3 | 0.08 | 0.36 |
| DFS lock handle | 27,318 | 0 | 11 | 0 | 0.44 | 0.31 |
| gc current grant busy | 13,152 | 0 | 10 | 1 | 0.21 | 0.28 |
| gc current block busy | 2,446 | 0 | 10 | 4 | 0.04 | 0.28 |
| rdbms ipc reply | 41,675 | 0 | 8 | 0 | 0.68 | 0.24 |
| gc cr grant 2-way | 25,101 | 0 | 8 | 0 | 0.41 | 0.23 |
| gcs drm freeze in enter server mode | 17 | 47 | 7 | 418 | 0.00 | 0.20 |
| gc remaster | 8 | 0 | 6 | 752 | 0.00 | 0.17 |
| gc current grant 2-way | 11,857 | 0 | 5 | 0 | 0.19 | 0.13 |
| SQL*Net message to client | 2,990,862 | 0 | 3 | 0 | 48.63 | 0.09 |
| gc buffer busy acquire | 812 | 0 | 1 | 1 | 0.01 | 0.03 |
| enq: TX - index contention | 160 | 0 | 1 | 6 | 0.00 | 0.03 |
| gc current block congested | 1,890 | 0 | 1 | 0 | 0.03 | 0.03 |
| db file parallel read | 130 | 0 | 1 | 6 | 0.00 | 0.02 |
| library cache: mutex X | 518 | 0 | 1 | 1 | 0.01 | 0.02 |
| enq: TX - row lock contention | 43 | 0 | 0 | 11 | 0.00 | 0.01 |
| name-service call wait | 6 | 0 | 0 | 80 | 0.00 | 0.01 |
| control file sequential read | 708 | 0 | 0 | 1 | 0.01 | 0.01 |
| latch: shared pool | 1,169 | 0 | 0 | 0 | 0.02 | 0.01 |
| gc cr block congested | 674 | 0 | 0 | 1 | 0.01 | 0.01 |
| cursor: pin S wait on X | 39 | 0 | 0 | 9 | 0.00 | 0.01 |
| row cache lock | 862 | 0 | 0 | 0 | 0.01 | 0.01 |
| SQL*Net more data to client | 10,125 | 0 | 0 | 0 | 0.16 | 0.01 |
| Disk file operations I/O | 3,356 | 0 | 0 | 0 | 0.05 | 0.01 |
| PX Deq: Slave Session Stats | 39 | 0 | 0 | 5 | 0.00 | 0.01 |
| gc buffer busy release | 65 | 0 | 0 | 3 | 0.00 | 0.01 |
| kksfbc child completion | 4 | 100 | 0 | 51 | 0.00 | 0.01 |
| ASM file metadata operation | 6 | 0 | 0 | 28 | 0.00 | 0.00 |
| gc cr grant congested | 392 | 0 | 0 | 0 | 0.01 | 0.00 |
| library cache pin | 310 | 0 | 0 | 0 | 0.01 | 0.00 |
| library cache lock | 259 | 1 | 0 | 0 | 0.00 | 0.00 |
| os thread startup | 1 | 0 | 0 | 118 | 0.00 | 0.00 |
| enq: JQ - contention | 298 | 100 | 0 | 0 | 0.00 | 0.00 |
| gc current grant congested | 237 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc current multi block request | 107 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch free | 29 | 0 | 0 | 2 | 0.00 | 0.00 |
| enq: KO - fast object checkpoint | 24 | 0 | 0 | 2 | 0.00 | 0.00 |
| buffer busy waits | 206 | 0 | 0 | 0 | 0.00 | 0.00 |
| direct path read temp | 76 | 0 | 0 | 1 | 0.00 | 0.00 |
| CSS initialization | 10 | 0 | 0 | 4 | 0.00 | 0.00 |
| KJC: Wait for msg sends to complete | 2,712 | 0 | 0 | 0 | 0.04 | 0.00 |
| reliable message | 32 | 0 | 0 | 1 | 0.00 | 0.00 |
| IPC send completion sync | 78 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: PS - contention | 30 | 17 | 0 | 1 | 0.00 | 0.00 |
| CSS operation: action | 10 | 0 | 0 | 2 | 0.00 | 0.00 |
| SQL*Net more data from client | 121 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net more data from dblink | 14 | 0 | 0 | 1 | 0.00 | 0.00 |
| read by other session | 6 | 0 | 0 | 3 | 0.00 | 0.00 |
| gc current split | 34 | 0 | 0 | 1 | 0.00 | 0.00 |
| direct path write temp | 25 | 0 | 0 | 1 | 0.00 | 0.00 |
| enq: FB - contention | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: cache buffers chains | 143 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS operation: query | 30 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: reap credit | 327 | 100 | 0 | 0 | 0.01 | 0.00 |
| latch: gc element | 22 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TX - allocate ITL entry | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: row cache objects | 31 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message to dblink | 1,191 | 0 | 0 | 0 | 0.02 | 0.00 |
| asynch descriptor resize | 303 | 100 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 3 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: ges resource hash list | 28 | 0 | 0 | 0 | 0.00 | 0.00 |
| SQL*Net message from client | 2,990,879 | 0 | 438,846 | 147 | 48.63 | |
| jobq slave wait | 6,634 | 91 | 3,305 | 498 | 0.11 | |
| single-task message | 15 | 0 | 1 | 44 | 0.00 | |
| PX Deq: Execution Msg | 108 | 0 | 1 | 6 | 0.00 | |
| PX Deq: Join ACK | 12 | 0 | 0 | 3 | 0.00 | |
| PX Deq: Execute Reply | 12 | 0 | 0 | 1 | 0.00 | |
| PX Deq: Parse Reply | 12 | 0 | 0 | 1 | 0.00 | |
| KSV master wait | 27 | 0 | 0 | 0 | 0.00 |
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|---|---|---|---|---|---|
| log file parallel write | 60,967 | 0 | 34 | 1 | 0.99 | 12.11 |
| db file parallel write | 39,896 | 0 | 15 | 0 | 0.65 | 5.50 |
| gcs log flush sync | 9,729 | 3 | 11 | 1 | 0.16 | 3.98 |
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100 | 7 | 6954 | 0.00 | 2.47 |
| reliable message | 145 | 2 | 6 | 40 | 0.00 | 2.07 |
| control file sequential read | 6,241 | 0 | 5 | 1 | 0.10 | 1.64 |
| DFS lock handle | 6,027 | 99 | 4 | 1 | 0.10 | 1.26 |
| ges lms sync during dynamic remastering and reconfig | 24 | 100 | 3 | 141 | 0.00 | 1.20 |
| db file sequential read | 497 | 0 | 2 | 4 | 0.01 | 0.70 |
| os thread startup | 23 | 0 | 1 | 49 | 0.00 | 0.40 |
| gc cr block 2-way | 2,181 | 0 | 1 | 0 | 0.04 | 0.32 |
| row cache lock | 2,990 | 0 | 0 | 0 | 0.05 | 0.17 |
| control file parallel write | 880 | 0 | 0 | 1 | 0.01 | 0.16 |
| kjbdrmcvtq lmon drm quiesce: ping completion | 13 | 0 | 0 | 33 | 0.00 | 0.15 |
| gc current block 2-way | 656 | 0 | 0 | 0 | 0.01 | 0.10 |
| latch free | 32 | 0 | 0 | 7 | 0.00 | 0.08 |
| gc current block busy | 33 | 0 | 0 | 6 | 0.00 | 0.07 |
| CGS wait for IPC msg | 16,162 | 100 | 0 | 0 | 0.26 | 0.07 |
| ASM file metadata operation | 724 | 0 | 0 | 0 | 0.01 | 0.07 |
| row cache process | 24,674 | 0 | 0 | 0 | 0.40 | 0.07 |
| CSS operation: data query | 87 | 0 | 0 | 2 | 0.00 | 0.05 |
| ges generic event | 11 | 100 | 0 | 11 | 0.00 | 0.04 |
| enq: KO - fast object checkpoint | 313 | 0 | 0 | 0 | 0.01 | 0.04 |
| ksxr poll remote instances | 10,517 | 100 | 0 | 0 | 0.17 | 0.03 |
| name-service call wait | 2 | 0 | 0 | 44 | 0.00 | 0.03 |
| row cache cleanup | 16,140 | 0 | 0 | 0 | 0.26 | 0.03 |
| ges inquiry response | 179 | 0 | 0 | 0 | 0.00 | 0.03 |
| library cache lock | 222 | 0 | 0 | 0 | 0.00 | 0.03 |
| library cache pin | 230 | 0 | 0 | 0 | 0.00 | 0.03 |
| db file async I/O submit | 38,670 | 0 | 0 | 0 | 0.63 | 0.03 |
| gc cr block busy | 10 | 0 | 0 | 7 | 0.00 | 0.02 |
| ges LMON to get to FTDONE | 4 | 75 | 0 | 16 | 0.00 | 0.02 |
| gc current grant busy | 95 | 0 | 0 | 0 | 0.00 | 0.02 |
| ADR block file read | 16 | 0 | 0 | 2 | 0.00 | 0.01 |
| CSS group membership query | 29 | 0 | 0 | 1 | 0.00 | 0.01 |
| enq: CF - contention | 66 | 91 | 0 | 0 | 0.00 | 0.01 |
| gc current grant 2-way | 63 | 0 | 0 | 0 | 0.00 | 0.01 |
| ADR block file write | 5 | 0 | 0 | 5 | 0.00 | 0.01 |
| gc cr block congested | 44 | 0 | 0 | 0 | 0.00 | 0.01 |
| libcache interrupt action by LCK | 11,791 | 0 | 0 | 0 | 0.19 | 0.01 |
| enq: TX - index contention | 1 | 0 | 0 | 15 | 0.00 | 0.01 |
| CSS operation: action | 16 | 0 | 0 | 1 | 0.00 | 0.01 |
| LGWR wait for redo copy | 318 | 0 | 0 | 0 | 0.01 | 0.01 |
| direct path write | 13 | 0 | 0 | 1 | 0.00 | 0.00 |
| PX Deq: reap credit | 1,211 | 100 | 0 | 0 | 0.02 | 0.00 |
| Disk file operations I/O | 501 | 0 | 0 | 0 | 0.01 | 0.00 |
| CSS initialization | 2 | 0 | 0 | 4 | 0.00 | 0.00 |
| enq: PS - contention | 12 | 50 | 0 | 1 | 0.00 | 0.00 |
| gc current block congested | 13 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr grant 2-way | 13 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: shared pool | 17 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: WF - contention | 12 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TT - contention | 13 | 92 | 0 | 0 | 0.00 | 0.00 |
| db file scattered read | 8 | 0 | 0 | 0 | 0.00 | 0.00 |
| log file sync | 2 | 0 | 0 | 2 | 0.00 | 0.00 |
| asynch descriptor resize | 339 | 100 | 0 | 0 | 0.01 | 0.00 |
| latch: gc element | 17 | 0 | 0 | 0 | 0.00 | 0.00 |
| buffer busy waits | 30 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Slave Session Stats | 9 | 0 | 0 | 0 | 0.00 | 0.00 |
| gc cr multi block request | 3 | 0 | 0 | 1 | 0.00 | 0.00 |
| latch: call allocation | 21 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TM - contention | 5 | 80 | 0 | 0 | 0.00 | 0.00 |
| enq: FB - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TD - KTF dump entries | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| latch: ges resource hash list | 32 | 0 | 0 | 0 | 0.00 | 0.00 |
| CSS operation: query | 35 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: TA - contention | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| enq: RO - fast object reuse | 4 | 0 | 0 | 0 | 0.00 | 0.00 |
| PX Deq: Signal ACK RSG | 9 | 0 | 0 | 0 | 0.00 | 0.00 |
| rdbms ipc message | 213,859 | 16 | 51,717 | 242 | 3.48 | |
| class slave wait | 331 | 0 | 5,712 | 17258 | 0.01 | |
| gcs remote message | 876,816 | 43 | 5,328 | 6 | 14.26 | |
| wait for unread message on broadcast channel | 3,635 | 89 | 3,608 | 993 | 0.06 | |
| DIAG idle wait | 44,936 | 85 | 3,587 | 80 | 0.73 | |
| PX Idle Wait | 29 | 0 | 2,718 | 93708 | 0.00 | |
| Space Manager: slave idle wait | 484 | 98 | 2,407 | 4974 | 0.01 | |
| Streams AQ: qmn slave idle wait | 69 | 1 | 1,870 | 27104 | 0.00 | |
| Streams AQ: waiting for time management or cleanup tasks | 77 | 64 | 1,820 | 23638 | 0.00 | |
| PING | 642 | 22 | 1,806 | 2813 | 0.01 | |
| GCR sleep | 361 | 99 | 1,805 | 5000 | 0.01 | |
| pmon timer | 627 | 95 | 1,804 | 2876 | 0.01 | |
| Streams AQ: qmn coordinator idle wait | 129 | 49 | 1,803 | 13977 | 0.00 | |
| ASM background timer | 362 | 0 | 1,802 | 4979 | 0.01 | |
| shared server idle wait | 60 | 100 | 1,801 | 30010 | 0.00 | |
| dispatcher timer | 30 | 100 | 1,800 | 60010 | 0.00 | |
| ges remote message | 93,241 | 7 | 1,797 | 19 | 1.52 | |
| smon timer | 7 | 71 | 1,746 | 249364 | 0.00 | |
| SQL*Net message from client | 905 | 0 | 12 | 13 | 0.01 | |
| heartbeat monitor sleep | 28 | 0 | 0 | 2 | 0.00 | |
| KSV master wait | 1,194 | 94 | 0 | 0 | 0.02 | |
| PX Deq: Parse Reply | 9 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Join ACK | 9 | 0 | 0 | 2 | 0.00 | |
| PX Deq: Execute Reply | 9 | 0 | 0 | 0 | 0.00 | |
| Streams AQ: RAC qmn coordinator idle wait | 130 | 100 | 0 | 0 | 0.00 |
| % of Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Total Waits | <1ms | <2ms | <4ms | <8ms | <16ms | <32ms | <=1s | >1s |
| ADR block file read | 16 | 56.3 | 6.3 | 37.5 | |||||
| ADR block file write | 5 | 60.0 | 40.0 | ||||||
| ADR file lock | 6 | 100.0 | |||||||
| ASM file metadata operation | 730 | 98.9 | 1.0 | .1 | |||||
| CGS wait for IPC msg | 16.2K | 100.0 | |||||||
| CSS group membership query | 29 | 79.3 | 20.7 | ||||||
| CSS initialization | 10 | 50.0 | 20.0 | 30.0 | |||||
| CSS operation: action | 24 | 37.5 | 37.5 | 25.0 | |||||
| CSS operation: data query | 87 | 1.1 | 94.3 | 4.6 | |||||
| CSS operation: query | 59 | 96.6 | 3.4 | ||||||
| DFS lock handle | 33.4K | 99.5 | .5 | .0 | .0 | .0 | |||
| Disk file operations I/O | 3838 | 99.7 | .0 | .1 | .0 | .1 | .0 | .0 | |
| IPC send completion sync | 84 | 98.8 | 1.2 | ||||||
| KJC: Wait for msg sends to complete | 2730 | 100.0 | |||||||
| LGWR wait for redo copy | 319 | 99.7 | .3 | ||||||
| PX Deq: Signal ACK EXT | 21 | 100.0 | |||||||
| PX Deq: Signal ACK RSG | 21 | 100.0 | |||||||
| PX Deq: Slave Session Stats | 48 | 97.9 | 2.1 | ||||||
| PX Deq: reap credit | 1537 | 100.0 | |||||||
| SQL*Net break/reset to client | 443 | 89.4 | .2 | 10.4 | |||||
| SQL*Net message from dblink | 1198 | 47.7 | 24.9 | 10.7 | 3.3 | .8 | 1.3 | 11.3 | .1 |
| SQL*Net message to client | 2992.4K | 100.0 | |||||||
| SQL*Net message to dblink | 1182 | 100.0 | |||||||
| SQL*Net more data from client | 123 | 100.0 | |||||||
| SQL*Net more data from dblink | 14 | 71.4 | 7.1 | 21.4 | |||||
| SQL*Net more data to client | 10.1K | 100.0 | |||||||
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100.0 | |||||||
| asynch descriptor resize | 638 | 100.0 | |||||||
| buffer busy waits | 237 | 97.5 | 1.3 | 1.3 | |||||
| buffer deadlock | 23 | 100.0 | |||||||
| control file parallel write | 881 | 93.1 | 3.3 | .9 | 1.2 | 1.2 | .2 | ||
| control file sequential read | 6953 | 93.2 | 3.6 | 1.2 | 1.0 | .6 | .3 | .1 | |
| cursor: mutex X | 1 | 100.0 | |||||||
| cursor: pin S wait on X | 39 | 7.7 | 5.1 | 7.7 | 79.5 | ||||
| db file async I/O submit | 38.6K | 100.0 | |||||||
| db file parallel read | 129 | 41.1 | 7.8 | 7.8 | 14.0 | 23.3 | 4.7 | 1.6 | |
| db file parallel write | 39.8K | 95.8 | 2.1 | .8 | .5 | .4 | .3 | .1 | |
| db file scattered read | 38.4K | 83.9 | 6.4 | 4.3 | 3.8 | 1.4 | .2 | .0 | |
| db file sequential read | 76.9K | 68.6 | 2.5 | 6.4 | 17.6 | 3.9 | .9 | .2 | |
| direct path read | 21.3K | 26.7 | 21.3 | 20.4 | 17.9 | 10.1 | 3.0 | .5 | |
| direct path read temp | 76 | 94.7 | 1.3 | 2.6 | 1.3 | ||||
| direct path write | 13 | 84.6 | 7.7 | 7.7 | |||||
| direct path write temp | 24 | 91.7 | 8.3 | ||||||
| enq: AE - lock | 1 | 100.0 | |||||||
| enq: AF - task serialization | 1 | 100.0 | |||||||
| enq: CF - contention | 66 | 100.0 | |||||||
| enq: CR - block range reuse ckpt | 1 | 100.0 | |||||||
| enq: DR - contention | 1 | 100.0 | |||||||
| enq: FB - contention | 24 | 100.0 | |||||||
| enq: HW - contention | 1 | 100.0 | |||||||
| enq: JQ - contention | 299 | 100.0 | |||||||
| enq: JS - job run lock - synchronize | 1 | 100.0 | |||||||
| enq: KO - fast object checkpoint | 337 | 97.3 | .6 | .6 | .6 | .9 | |||
| enq: PS - contention | 42 | 95.2 | 2.4 | 2.4 | |||||
| enq: RO - fast object reuse | 4 | 100.0 | |||||||
| enq: TA - contention | 4 | 100.0 | |||||||
| enq: TD - KTF dump entries | 4 | 100.0 | |||||||
| enq: TM - contention | 5 | 100.0 | |||||||
| enq: TQ - TM contention | 1 | 100.0 | |||||||
| enq: TS - contention | 2 | 100.0 | |||||||
| enq: TT - contention | 16 | 100.0 | |||||||
| enq: TX - allocate ITL entry | 8 | 100.0 | |||||||
| enq: TX - index contention | 161 | 52.8 | 1.2 | 4.3 | 12.4 | 14.3 | 11.8 | 3.1 | |
| enq: TX - row lock contention | 43 | 4.7 | 9.3 | 16.3 | 44.2 | 25.6 | |||
| enq: UL - contention | 1 | 100.0 | |||||||
| enq: WF - contention | 12 | 100.0 | |||||||
| gc buffer busy acquire | 817 | 83.6 | 7.1 | 3.2 | 2.9 | 2.2 | .6 | .4 | |
| gc buffer busy release | 66 | 60.6 | 13.6 | 4.5 | 7.6 | 9.1 | 4.5 | ||
| gc cr block 2-way | 40.7K | 99.2 | .7 | .0 | .0 | .0 | .0 | ||
| gc cr block busy | 4936 | 1.4 | 80.1 | 10.3 | 2.9 | 3.5 | 1.2 | .4 | |
| gc cr block congested | 717 | 98.9 | 1.0 | .1 | |||||
| gc cr grant 2-way | 25.1K | 99.7 | .3 | .0 | .0 | ||||
| gc cr grant congested | 392 | 100.0 | |||||||
| gc cr multi block request | 23.6K | 90.5 | 9.4 | .0 | .0 | .0 | .0 | ||
| gc current block 2-way | 112.9K | 99.3 | .7 | .0 | .0 | .0 | .0 | ||
| gc current block busy | 2479 | 8.7 | 56.2 | 12.0 | 7.2 | 13.6 | 1.5 | .9 | |
| gc current block congested | 1902 | 99.1 | .8 | .1 | |||||
| gc current grant 2-way | 11.9K | 99.6 | .3 | .0 | .1 | .0 | |||
| gc current grant busy | 13.3K | 98.9 | .5 | .1 | .1 | .2 | .1 | .2 | |
| gc current grant congested | 237 | 99.2 | .8 | ||||||
| gc current multi block request | 106 | 96.2 | 2.8 | .9 | |||||
| gc current retry | 2 | 100.0 | |||||||
| gc current split | 35 | 97.1 | 2.9 | ||||||
| gc remaster | 8 | 100.0 | |||||||
| gcs drm freeze in enter server mode | 17 | 5.9 | 94.1 | ||||||
| gcs log flush sync | 9754 | 74.7 | 16.5 | 3.6 | 2.7 | 2.5 | |||
| ges LMON to get to FTDONE | 4 | 25.0 | 75.0 | ||||||
| ges generic event | 11 | 100.0 | |||||||
| ges inquiry response | 179 | 100.0 | |||||||
| ges lms sync during dynamic remastering and reconfig | 24 | 8.3 | 91.7 | ||||||
| ges2 LMON to wake up LMD - mrcvr | 1 | 100.0 | |||||||
| global enqueue expand wait | 3 | 100.0 | |||||||
| kjbdrmcvtq lmon drm quiesce: ping completion | 13 | 30.8 | 7.7 | 61.5 | |||||
| kksfbc child completion | 4 | 100.0 | |||||||
| ksxr poll remote instances | 10.4K | 100.0 | |||||||
| latch free | 62 | 62.9 | 1.6 | 24.2 | 6.5 | 3.2 | 1.6 | ||
| latch: active service list | 5 | 100.0 | |||||||
| latch: cache buffers chains | 156 | 100.0 | |||||||
| latch: call allocation | 22 | 100.0 | |||||||
| latch: enqueue hash chains | 1 | 100.0 | |||||||
| latch: gc element | 39 | 100.0 | |||||||
| latch: gcs resource hash | 2 | 100.0 | |||||||
| latch: ges resource hash list | 64 | 100.0 | |||||||
| latch: messages | 3 | 100.0 | |||||||
| latch: object queue header operation | 2 | 100.0 | |||||||
| latch: redo allocation | 1 | 100.0 | |||||||
| latch: row cache objects | 32 | 100.0 | |||||||
| latch: shared pool | 1182 | 93.5 | 3.9 | 2.2 | .3 | .1 | |||
| libcache interrupt action by LCK | 11.7K | 100.0 | |||||||
| library cache load lock | 3 | 100.0 | |||||||
| library cache lock | 482 | 97.5 | 1.7 | .6 | .2 | ||||
| library cache pin | 541 | 99.1 | .6 | .4 | |||||
| library cache: mutex X | 518 | 93.2 | .2 | 6.2 | .4 | ||||
| log file parallel write | 61K | 93.3 | 3.1 | .8 | 1.1 | 1.1 | .5 | .1 | |
| log file sync | 54.1K | 76.1 | 16.2 | 3.5 | 1.6 | 1.5 | .8 | .3 | |
| name-service call wait | 8 | 25.0 | 75.0 | ||||||
| os thread startup | 24 | 100.0 | |||||||
| rdbms ipc reply | 41.7K | 99.2 | .8 | .0 | .0 | ||||
| read by other session | 6 | 33.3 | 66.7 | ||||||
| reliable message | 177 | 64.4 | 19.2 | 7.3 | 4.0 | .6 | .6 | 4.0 | |
| row cache cleanup | 15.9K | 99.9 | .0 | .0 | .0 | ||||
| row cache lock | 3838 | 98.5 | 1.5 | .1 | |||||
| row cache process | 24.3K | 100.0 | |||||||
| ASM background timer | 362 | .3 | 99.7 | ||||||
| DIAG idle wait | 45.1K | 12.6 | 1.4 | .1 | .1 | 12.7 | 27.9 | 45.3 | |
| GCR sleep | 361 | 100.0 | |||||||
| KSV master wait | 1221 | 100.0 | |||||||
| PING | 642 | 77.9 | 22.1 | ||||||
| PX Deq: Execute Reply | 21 | 81.0 | 14.3 | 4.8 | |||||
| PX Deq: Execution Msg | 108 | 82.4 | 10.2 | 3.7 | 1.9 | .9 | .9 | ||
| PX Deq: Join ACK | 21 | 38.1 | 38.1 | 19.0 | 4.8 | ||||
| PX Deq: Parse Reply | 21 | 76.2 | 14.3 | 9.5 | |||||
| PX Idle Wait | 27 | 7.4 | 3.7 | 3.7 | 3.7 | 3.7 | 33.3 | 44.4 | |
| SQL*Net message from client | 2993.1K | 92.1 | 4.2 | .4 | .3 | .4 | .3 | 1.9 | .5 |
| Space Manager: slave idle wait | 485 | 100.0 | |||||||
| Streams AQ: RAC qmn coordinator idle wait | 130 | 100.0 | |||||||
| Streams AQ: qmn coordinator idle wait | 129 | 48.8 | 51.2 | ||||||
| Streams AQ: qmn slave idle wait | 69 | 100.0 | |||||||
| Streams AQ: waiting for time management or cleanup tasks | 77 | 32.5 | 31.2 | 36.4 | |||||
| class slave wait | 331 | 32.6 | .3 | 1.8 | 20.8 | 3.9 | 2.4 | 38.1 | |
| dispatcher timer | 30 | 100.0 | |||||||
| gcs remote message | 877.8K | 19.4 | 11.2 | 11.5 | 12.1 | 45.8 | .0 | .0 | |
| ges remote message | 94K | 29.0 | 5.8 | 10.2 | 9.8 | 14.6 | 12.1 | 18.5 | |
| heartbeat monitor sleep | 28 | 17.9 | 82.1 | ||||||
| jobq slave wait | 6623 | .0 | .0 | .0 | .0 | 99.9 | |||
| pmon timer | 627 | .8 | .2 | .3 | .3 | .5 | 2.1 | 95.9 | |
| rdbms ipc message | 213.8K | 45.2 | 5.5 | 6.0 | 3.7 | 5.6 | 4.2 | 24.2 | 5.6 |
| shared server idle wait | 61 | 100.0 | |||||||
| single-task message | 15 | 100.0 | |||||||
| smon timer | 7 | 100.0 | |||||||
| wait for unread message on broadcast channel | 3635 | .7 | 99.2 | .1 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 64ms to 2s | <32ms | <64ms | <1/8s | <1/4s | <1/2s | <1s | <2s | >=2s |
| ASM file metadata operation | 1 | 99.9 | .1 | ||||||
| Disk file operations I/O | 1 | 100.0 | .0 | ||||||
| PX Deq: Slave Session Stats | 1 | 97.9 | 2.1 | ||||||
| SQL*Net message from dblink | 136 | 88.6 | 2.0 | .7 | .2 | .2 | 8.3 | .1 | |
| control file sequential read | 9 | 99.9 | .1 | .1 | |||||
| db file parallel read | 2 | 98.4 | .8 | .8 | |||||
| db file parallel write | 42 | 99.9 | .1 | .0 | |||||
| db file scattered read | 15 | 100.0 | .0 | .0 | .0 | ||||
| db file sequential read | 119 | 99.8 | .1 | .0 | .0 | .0 | |||
| direct path read | 112 | 99.5 | .4 | .1 | |||||
| enq: TX - index contention | 5 | 96.9 | 3.1 | ||||||
| gc buffer busy acquire | 3 | 99.6 | .4 | ||||||
| gc cr block 2-way | 2 | 100.0 | .0 | .0 | |||||
| gc cr block busy | 22 | 99.6 | .4 | .0 | |||||
| gc cr block congested | 1 | 99.9 | .1 | ||||||
| gc cr grant 2-way | 1 | 100.0 | .0 | ||||||
| gc cr multi block request | 10 | 100.0 | .0 | .0 | |||||
| gc current block busy | 22 | 99.1 | .7 | .2 | |||||
| gc current grant 2-way | 2 | 100.0 | .0 | .0 | |||||
| gc current grant busy | 25 | 99.8 | .1 | .0 | .0 | .0 | |||
| gc remaster | 8 | 100.0 | |||||||
| gcs drm freeze in enter server mode | 16 | 5.9 | 94.1 | ||||||
| ges lms sync during dynamic remastering and reconfig | 22 | 8.3 | 25.0 | 58.3 | 8.3 | ||||
| kjbdrmcvtq lmon drm quiesce: ping completion | 8 | 38.5 | 53.8 | 7.7 | |||||
| kksfbc child completion | 4 | 100.0 | |||||||
| latch free | 1 | 98.4 | 1.6 | ||||||
| library cache: mutex X | 2 | 99.6 | .4 | ||||||
| log file parallel write | 72 | 99.9 | .1 | .0 | |||||
| log file sync | 181 | 99.7 | .2 | .1 | .0 | ||||
| name-service call wait | 6 | 25.0 | 12.5 | 62.5 | |||||
| os thread startup | 24 | 87.5 | 12.5 | ||||||
| reliable message | 7 | 96.0 | 1.1 | 2.8 |
| % of Total Waits | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| Event | Waits 4s to 2m | <2s | <4s | <8s | <16s | <32s | < 1m | < 2m | >=2m |
| Streams AQ: qmn coordinator waiting for slave to start | 1 | 100.0 |
| % of Total Waits | ||||||||
|---|---|---|---|---|---|---|---|---|
| Event | Waits 4m to 1h | <2m | <4m | <8m | <1/4h | <1/2h | < 1h | >=1h |
| SQL*Net break/reset to client | 21 | 89.6 | 4.7 | 5.6 |
| Service Name | DB Time (s) | DB CPU (s) | Physical Reads (K) | Logical Reads (K) |
|---|---|---|---|---|
| bppfedb | 3,449 | 2,922 | 7,308 | 203,904 |
| SYS$USERS | 24 | 22 | 0 | 313 |
| SYS$BACKGROUND | 0 | 0 | 0 | 172 |
| bppfedbXDB | 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 |
|---|---|---|---|---|---|---|---|---|
| bppfedb | 138482 | 293 | 3323 | 3 | 0 | 0 | 3002666 | 90 |
| SYS$USERS | 1284 | 1 | 394 | 0 | 0 | 0 | 1046 | 0 |
| SYS$BACKGROUND | 1019 | 2 | 15449 | 2 | 0 | 0 | 0 | 0 |
| Elapsed Time (s) | Executions | Elapsed Time per Exec (s) | %Total | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 463.03 | 30 | 15.43 | 13.34 | 76.42 | 16.58 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 89.69 | 6 | 14.95 | 2.58 | 80.94 | 11.14 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 71.96 | 17 | 4.23 | 2.07 | 99.86 | 0.00 | cq4va5130p8sh | Hibernate with C3P0 | select * from (select rownum a... |
| 70.84 | 89 | 0.80 | 2.04 | 0.12 | 0.00 | 4m81j4p2kdz0w | Hibernate with C3P0 | update T_INF_ORDERCTL set TMNN... |
| 67.23 | 17 | 3.95 | 1.94 | 99.88 | 0.00 | 53u07hu2mu21y | Hibernate with C3P0 | select count(1) from (with M a... |
| 51.43 | 90 | 0.57 | 1.48 | 99.91 | 0.00 | 133uk3sy9sm19 | Hibernate with C3P0 | SELECT T.PRTN_ID, T.PRTN_NAME ... |
| 42.77 | 29 | 1.47 | 1.23 | 99.77 | 0.00 | 681zrwjq2914w | select DISTINCT BATCH_CODE fro... | |
| 36.47 | 706 | 0.05 | 1.05 | 96.15 | 0.02 | 5urzmwn0d4t64 | AutoPayReward@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT T2.DISC_... |
| 34.07 | 33 | 1.03 | 0.98 | 99.40 | 0.00 | 557uvyxct35rk | Hibernate with C3P0 | select toppordfee0_.ORDFEE_ID ... |
| 32.66 | 16 | 2.04 | 0.94 | 99.90 | 0.00 | dg3sa65ctnm65 | Hibernate with C3P0 | select count(1) from (select o... |
| CPU Time (s) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 353.85 | 30 | 11.80 | 12.02 | 463.03 | 76.42 | 16.58 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 72.60 | 6 | 12.10 | 2.47 | 89.69 | 80.94 | 11.14 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 71.86 | 17 | 4.23 | 2.44 | 71.96 | 99.86 | 0.00 | cq4va5130p8sh | Hibernate with C3P0 | select * from (select rownum a... |
| 67.15 | 17 | 3.95 | 2.28 | 67.23 | 99.88 | 0.00 | 53u07hu2mu21y | Hibernate with C3P0 | select count(1) from (with M a... |
| 51.38 | 90 | 0.57 | 1.75 | 51.43 | 99.91 | 0.00 | 133uk3sy9sm19 | Hibernate with C3P0 | SELECT T.PRTN_ID, T.PRTN_NAME ... |
| 42.67 | 29 | 1.47 | 1.45 | 42.77 | 99.77 | 0.00 | 681zrwjq2914w | select DISTINCT BATCH_CODE fro... | |
| 35.07 | 706 | 0.05 | 1.19 | 36.47 | 96.15 | 0.02 | 5urzmwn0d4t64 | AutoPayReward@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT T2.DISC_... |
| 33.87 | 33 | 1.03 | 1.15 | 34.07 | 99.40 | 0.00 | 557uvyxct35rk | Hibernate with C3P0 | select toppordfee0_.ORDFEE_ID ... |
| 32.63 | 16 | 2.04 | 1.11 | 32.66 | 99.90 | 0.00 | dg3sa65ctnm65 | Hibernate with C3P0 | select count(1) from (select o... |
| 32.49 | 15 | 2.17 | 1.10 | 32.55 | 99.81 | 0.00 | 291n4n001kkdd | Hibernate with C3P0 | select * from (select rownum a... |
| User I/O Time (s) | Executions | UIO per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 76.79 | 30 | 2.56 | 25.91 | 463.03 | 76.42 | 16.58 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 19.03 | 10,628 | 0.00 | 6.42 | 29.42 | 21.02 | 64.69 | 1ddkpcc6s63jx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACT_ATTR (A... |
| 12.11 | 2,519 | 0.00 | 4.08 | 22.95 | 24.24 | 52.75 | 23gz1n4vudn3n | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDER (ORDE... |
| 10.62 | 2,518 | 0.00 | 3.58 | 16.11 | 19.73 | 65.92 | 52g7t0n7yzq6c | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_PAYMENT (PA... |
| 10.00 | 6 | 1.67 | 3.37 | 89.69 | 80.94 | 11.14 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 6.75 | 3,399 | 0.00 | 2.28 | 16.27 | 31.68 | 41.48 | 2d4q4c5ubp9k8 | tmservice@BPPF_EAS2 (TNS V1-V3) | Insert into T_EBK_DEALLOG (LOG... |
| 5.10 | 3,014 | 0.00 | 1.72 | 11.93 | 28.40 | 42.74 | 7gh2xdvx3r5s0 | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_OPERLOG (LO... |
| 1.33 | 4,494 | 0.00 | 0.45 | 8.67 | 30.39 | 15.31 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| 1.07 | 2,527 | 0.00 | 0.36 | 6.30 | 35.98 | 16.95 | dqrq64nan0ktx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACTFEE (ACT... |
| 0.84 | 2,518 | 0.00 | 0.28 | 5.67 | 40.20 | 14.78 | 687wyyw17qhdu | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDATTR (OR... |
| Buffer Gets | Executions | Gets per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 32,134,656 | 30 | 1,071,155.20 | 15.73 | 463.03 | 76.4 | 16.6 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 15,988,890 | 17 | 940,522.94 | 7.83 | 71.96 | 99.9 | 0 | cq4va5130p8sh | Hibernate with C3P0 | select * from (select rownum a... |
| 14,627,661 | 17 | 860,450.65 | 7.16 | 67.23 | 99.9 | 0 | 53u07hu2mu21y | Hibernate with C3P0 | select count(1) from (with M a... |
| 9,316,443 | 706 | 13,196.09 | 4.56 | 36.47 | 96.2 | 0 | 5urzmwn0d4t64 | AutoPayReward@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT T2.DISC_... |
| 6,427,075 | 6 | 1,071,179.17 | 3.15 | 89.69 | 80.9 | 11.1 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 3,380,656 | 29 | 116,574.34 | 1.65 | 42.77 | 99.8 | 0 | 681zrwjq2914w | select DISTINCT BATCH_CODE fro... | |
| 2,231,282 | 16 | 139,455.13 | 1.09 | 32.66 | 99.9 | 0 | dg3sa65ctnm65 | Hibernate with C3P0 | select count(1) from (select o... |
| 2,114,731 | 15 | 140,982.07 | 1.04 | 32.55 | 99.8 | 0 | 291n4n001kkdd | Hibernate with C3P0 | select * from (select rownum a... |
| 1,746,807 | 5 | 349,361.40 | 0.86 | 12.99 | 99.3 | 0 | 5htg4qmxfjh4u | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 1,438,228 | 90 | 15,980.31 | 0.70 | 51.43 | 99.9 | 0 | 133uk3sy9sm19 | Hibernate with C3P0 | SELECT T.PRTN_ID, T.PRTN_NAME ... |
| Physical Reads | Executions | Reads per Exec | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 2,353,726 | 30 | 78,457.53 | 32.20 | 463.03 | 76.42 | 16.58 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 15,335 | 6 | 2,555.83 | 0.21 | 89.69 | 80.94 | 11.14 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 3,027 | 10,628 | 0.28 | 0.04 | 29.42 | 21.02 | 64.69 | 1ddkpcc6s63jx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACT_ATTR (A... |
| 2,076 | 2,519 | 0.82 | 0.03 | 22.95 | 24.24 | 52.75 | 23gz1n4vudn3n | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDER (ORDE... |
| 1,601 | 2,518 | 0.64 | 0.02 | 16.11 | 19.73 | 65.92 | 52g7t0n7yzq6c | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_PAYMENT (PA... |
| 1,021 | 3,399 | 0.30 | 0.01 | 16.27 | 31.68 | 41.48 | 2d4q4c5ubp9k8 | tmservice@BPPF_EAS2 (TNS V1-V3) | Insert into T_EBK_DEALLOG (LOG... |
| 941 | 3,014 | 0.31 | 0.01 | 11.93 | 28.40 | 42.74 | 7gh2xdvx3r5s0 | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_OPERLOG (LO... |
| 231 | 4,494 | 0.05 | 0.00 | 8.67 | 30.39 | 15.31 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| 160 | 2,527 | 0.06 | 0.00 | 6.30 | 35.98 | 16.95 | dqrq64nan0ktx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACTFEE (ACT... |
| 126 | 2,518 | 0.05 | 0.00 | 5.67 | 40.20 | 14.78 | 687wyyw17qhdu | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDATTR (OR... |
| UnOptimized Read Reqs | Physical Read Reqs | Executions | UnOptimized Reqs per Exec | %Opt | %Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 89,118 | 89,118 | 30 | 2,970.60 | 0.00 | 52.24 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 10,175 | 10,175 | 6 | 1,695.83 | 0.00 | 5.96 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 2,914 | 2,914 | 10,628 | 0.27 | 0.00 | 1.71 | 1ddkpcc6s63jx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACT_ATTR (A... |
| 2,003 | 2,003 | 2,519 | 0.80 | 0.00 | 1.17 | 23gz1n4vudn3n | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDER (ORDE... |
| 1,559 | 1,559 | 2,518 | 0.62 | 0.00 | 0.91 | 52g7t0n7yzq6c | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_PAYMENT (PA... |
| 1,011 | 1,011 | 3,399 | 0.30 | 0.00 | 0.59 | 2d4q4c5ubp9k8 | tmservice@BPPF_EAS2 (TNS V1-V3) | Insert into T_EBK_DEALLOG (LOG... |
| 891 | 891 | 3,014 | 0.30 | 0.00 | 0.52 | 7gh2xdvx3r5s0 | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_OPERLOG (LO... |
| 154 | 154 | 2,527 | 0.06 | 0.00 | 0.09 | dqrq64nan0ktx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACTFEE (ACT... |
| 126 | 126 | 2,518 | 0.05 | 0.00 | 0.07 | 687wyyw17qhdu | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDATTR (OR... |
| 11 | 11 | 4,494 | 0.00 | 0.00 | 0.01 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| Executions | Rows Processed | Rows per Exec | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|
| 37,917 | 37,917 | 1.00 | 8.81 | 85.1 | 0 | 02hsnb7xtghfp | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT sq_scs_stepinst.NEXTVAL... |
| 30,527 | 30,526 | 1.00 | 23.87 | 97.9 | 0 | 6jbqatwrgbamp | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT PRTN_CODE, PRTN_NAME FR... |
| 15,795 | 7,290 | 0.46 | 4.16 | 99.7 | 0 | 8bsppxkpc1dm1 | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM T_CUM_CUSTOM WHE... |
| 12,012 | 0 | 0.00 | 1.06 | 96.6 | 0 | 059md8mr237hf | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT ACTION_NAME FROM T_PDM... |
| 12,006 | 0 | 0.00 | 1.06 | 97 | 0 | 79vnx2tsr8mhs | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT ACTION_CODE FROM T_PDM... |
| 12,006 | 0 | 0.00 | 1.05 | 93.3 | 0 | ab2cqsptaqytu | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT PROD_NAME FROM T_PDM_P... |
| 12,006 | 0 | 0.00 | 1.08 | 91.9 | 0 | dnan8kdpy6yck | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT PROD_CODE FROM T_PDM_P... |
| 10,838 | 10,838 | 1.00 | 2.25 | 96.6 | 0 | 4dzfsvnk16ps4 | PayTimeoutJob@BPPF_EAS1 (TNS V1-V3) | SELECT SQ_SCS_SYMSEQ.NEXTVAL A... |
| 10,628 | 10,628 | 1.00 | 29.42 | 21 | 64.7 | 1ddkpcc6s63jx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACT_ATTR (A... |
| 8,026 | 8,026 | 1.00 | 0.89 | 97.3 | 0 | 7y5q05wqf50g5 | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT DICT_ID, DICT_TYPEID, D... |
| Parse Calls | Executions | % Total Parses | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 37,123 | 30,527 | 4.17 | 6jbqatwrgbamp | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT PRTN_CODE, PRTN_NAME FR... |
| 21,399 | 15,795 | 2.40 | 8bsppxkpc1dm1 | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM T_CUM_CUSTOM WHE... |
| 9,137 | 7,738 | 1.03 | d9xfggh4tc5ab | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT DISTINCT I.OBJ_ID, I.PR... |
| 6,780 | 4,494 | 0.76 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| 6,447 | 6,643 | 0.72 | 3m8quzddcths6 | tmservice@BPPF_BIS1 (TNS V1-V3) | SELECT DICT_ID, DICT_TYPEID, D... |
| 6,273 | 4,595 | 0.70 | 20z3qc860g79d | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT SQ_SYM_TRADESEQ.NEXTVAL... |
| 6,046 | 8,013 | 0.68 | c6xvugn8bnxmt | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT DICT_ID, DICT_TYPEID, D... |
| 6,020 | 8,026 | 0.68 | 7y5q05wqf50g5 | tmservice@BPPF_BIS2 (TNS V1-V3) | SELECT DICT_ID, DICT_TYPEID, D... |
| 6,006 | 3,027 | 0.67 | cx5paj1fm5q4a | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT SQ_SCS_OPERLOG.NEXTVAL ... |
| 5,974 | 2,998 | 0.67 | bxnv7tr0ffu8n | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT ATTR_ID FROM T_SYM_ATT... |
| Sharable Mem (b) | Executions | % Total | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|
| 222,375,280 | 30,527 | 2.24 | 6jbqatwrgbamp | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT PRTN_CODE, PRTN_NAME FR... |
| 92,618,721 | 15,795 | 0.93 | 8bsppxkpc1dm1 | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM T_CUM_CUSTOM WHE... |
| 30,095,978 | 4,494 | 0.30 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| 19,214,116 | 536 | 0.19 | 447ku4suqwzcw | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT * FROM (SELECT PRTN_ID,... |
| 12,141,456 | 750 | 0.12 | 30uvjcd56583v | tmservice@BPPF_EAS4 (TNS V1-V3) | select tcc.th, ted.end_bal fro... |
| 11,846,232 | 708 | 0.12 | 4kgprupqky1dz | tmservice@BPPF_EAS4 (TNS V1-V3) | select tcc.th, ted.end_bal fro... |
| 10,759,289 | 536 | 0.11 | 5htj25pp01mbd | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT CUST_ID, CUST_CODE, CUS... |
| 6,638,043 | 276 | 0.07 | 68368kpu6b3yc | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT CUST_ID, CUST_CODE, CUS... |
| Version Count | Executions | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|
| 79 | 30,527 | 6jbqatwrgbamp | tmservice@BPPF_EAS4 (TNS V1-V3) | SELECT PRTN_CODE, PRTN_NAME FR... |
| 67 | 15,795 | 8bsppxkpc1dm1 | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM T_CUM_CUSTOM WHE... |
| 55 | 6 | 8ta1c19zayct0 | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT TH FROM T_CUM_CUSTOM WH... |
| 47 | 750 | 30uvjcd56583v | tmservice@BPPF_EAS4 (TNS V1-V3) | select tcc.th, ted.end_bal fro... |
| 47 | 276 | 68368kpu6b3yc | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT CUST_ID, CUST_CODE, CUS... |
| 43 | 708 | 4kgprupqky1dz | tmservice@BPPF_EAS4 (TNS V1-V3) | select tcc.th, ted.end_bal fro... |
| 36 | 8 | fr18sbu3zk4sr | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT COUNT(*) AS CON FROM T_... |
| 34 | 8 | 363am73y9dwpj | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT GRP_ID, ACTION_ID, MEMO... |
| 33 | 4,494 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| Cluster Wait Time (s) | Executions | %Total | Elapsed Time(s) | %Clu | %CPU | %IO | SQL Id | SQL Module | SQL Text |
|---|---|---|---|---|---|---|---|---|---|
| 31.18 | 30 | 21.60 | 463.03 | 6.73 | 76.42 | 16.58 | 6sn1ujjjymknw | python@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) COUNTING, TO_C... |
| 8.45 | 6 | 5.85 | 89.69 | 9.42 | 80.94 | 11.14 | csqmhq6dk66s6 | python@BPPF_EAS1 (TNS V1-V3) | SELECT PDM.ACTION_NAME, COUNT(... |
| 6.29 | 2,519 | 4.36 | 22.95 | 27.40 | 24.24 | 52.75 | 23gz1n4vudn3n | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDER (ORDE... |
| 5.21 | 3,399 | 3.61 | 16.27 | 32.05 | 31.68 | 41.48 | 2d4q4c5ubp9k8 | tmservice@BPPF_EAS2 (TNS V1-V3) | Insert into T_EBK_DEALLOG (LOG... |
| 5.18 | 4,494 | 3.59 | 8.67 | 59.67 | 30.39 | 15.31 | 4x6bpjkhyguk8 | tmservice@BPPF_EAS2 (TNS V1-V3) | select VALUE1 , VALUE3 from T_... |
| 4.56 | 10,628 | 3.16 | 29.42 | 15.49 | 21.02 | 64.69 | 1ddkpcc6s63jx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACT_ATTR (A... |
| 3.97 | 3,014 | 2.75 | 11.93 | 33.27 | 28.40 | 42.74 | 7gh2xdvx3r5s0 | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_OPERLOG (LO... |
| 3.27 | 2,527 | 2.27 | 6.30 | 51.93 | 35.98 | 16.95 | dqrq64nan0ktx | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ACTFEE (ACT... |
| 2.82 | 2,518 | 1.95 | 5.67 | 49.72 | 40.20 | 14.78 | 687wyyw17qhdu | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_ORDATTR (OR... |
| 2.72 | 2,518 | 1.88 | 16.11 | 16.86 | 19.73 | 65.92 | 52g7t0n7yzq6c | tmservice@BPPF_EAS2 (TNS V1-V3) | INSERT INTO T_SCS_PAYMENT (PA... |
| 1.42 | 706 | 0.98 | 36.47 | 3.89 | 96.15 | 0.02 | 5urzmwn0d4t64 | AutoPayReward@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT T2.DISC_... |
| 0.38 | 2 | 0.26 | 10.90 | 3.48 | 96.07 | 0.00 | 8ucs3qd2rdp7b | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 0.07 | 5 | 0.05 | 12.99 | 0.57 | 99.33 | 0.00 | 5htg4qmxfjh4u | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 0.04 | 37,917 | 0.03 | 8.81 | 0.41 | 85.08 | 0.00 | 02hsnb7xtghfp | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT sq_scs_stepinst.NEXTVAL... |
| 0.04 | 33 | 0.03 | 8.13 | 0.44 | 98.66 | 0.00 | 4v2dndynxxh3z | tmservice@BPPF_EAS2 (TNS V1-V3) | select * from t_pdm_include wh... |
| 0.04 | 29 | 0.02 | 42.77 | 0.08 | 99.77 | 0.00 | 681zrwjq2914w | select DISTINCT BATCH_CODE fro... | |
| 0.03 | 6 | 0.02 | 8.56 | 0.38 | 99.32 | 0.00 | fj0a5xg65pzcy | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT COUNT(1) AS COUNT_RECOR... |
| 0.02 | 17 | 0.01 | 67.23 | 0.03 | 99.88 | 0.00 | 53u07hu2mu21y | Hibernate with C3P0 | select count(1) from (with M a... |
| 0.01 | 10,838 | 0.01 | 2.25 | 0.54 | 96.61 | 0.00 | 4dzfsvnk16ps4 | PayTimeoutJob@BPPF_EAS1 (TNS V1-V3) | SELECT SQ_SCS_SYMSEQ.NEXTVAL A... |
| 0.01 | 11 | 0.01 | 11.44 | 0.10 | 99.64 | 0.00 | 28a7c2f6nrbww | Hibernate with C3P0 | select toppordfee0_.ORDFEE_ID ... |
| 0.01 | 9 | 0.01 | 0.47 | 2.38 | 97.43 | 0.00 | 1xz2z2p42axnc | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 0.01 | 150 | 0.01 | 0.10 | 10.40 | 57.67 | 36.70 | 3ktacv9r56b51 | select owner#, name, namespace... | |
| 0.01 | 16 | 0.01 | 32.66 | 0.03 | 99.90 | 0.00 | dg3sa65ctnm65 | Hibernate with C3P0 | select count(1) from (select o... |
| 0.01 | 7 | 0.01 | 4.69 | 0.18 | 99.83 | 0.00 | 6xvha45aryv1v | Hibernate with C3P0 | select * from (select rownum a... |
| 0.01 | 2 | 0.01 | 5.45 | 0.15 | 99.46 | 0.00 | b0m2z4fnc1944 | Hibernate with C3P0 | select pre.term_seq, info.cust... |
| 0.01 | 750 | 0.01 | 0.18 | 4.60 | 80.64 | 0.00 | 30uvjcd56583v | tmservice@BPPF_EAS4 (TNS V1-V3) | select tcc.th, ted.end_bal fro... |
| 0.01 | 17 | 0.01 | 71.96 | 0.01 | 99.86 | 0.00 | cq4va5130p8sh | Hibernate with C3P0 | select * from (select rownum a... |
| 0.01 | 3 | 0.01 | 4.46 | 0.18 | 98.87 | 0.00 | gs4a6a5bfsxtw | Hibernate with C3P0 | select count(1) from (select o... |
| 0.01 | 3 | 0.01 | 0.25 | 3.14 | 97.20 | 0.00 | 9wufsznupghta | tmservice@BPPF_EAS2 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 0.01 | 15 | 0.01 | 32.55 | 0.02 | 99.81 | 0.00 | 291n4n001kkdd | Hibernate with C3P0 | select * from (select rownum a... |
| 0.01 | 33 | 0.00 | 34.07 | 0.02 | 99.40 | 0.00 | 557uvyxct35rk | Hibernate with C3P0 | select toppordfee0_.ORDFEE_ID ... |
| 0.01 | 3 | 0.00 | 0.25 | 2.24 | 97.75 | 0.00 | 6y2s3vp4sh8ff | tmservice@BPPF_EAS1 (TNS V1-V3) | SELECT * FROM (SELECT ROW_.*, ... |
| 0.01 | 4 | 0.00 | 6.12 | 0.09 | 99.77 | 0.00 | 2fhb7zrfp9pp8 | Hibernate with C3P0 | select count(1) from (select o... |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| Batched IO (bound) vector count | 1,647 | 0.91 | 0.03 |
| Batched IO (full) vector count | 1 | 0.00 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 8,364 | 4.64 | 0.14 |
| Batched IO buffer defrag count | 8 | 0.00 | 0.00 |
| Batched IO double miss count | 343 | 0.19 | 0.01 |
| Batched IO same unit count | 4,592 | 2.55 | 0.07 |
| Batched IO single block count | 1,261 | 0.70 | 0.02 |
| Batched IO slow jump count | 1 | 0.00 | 0.00 |
| Batched IO vector block count | 2,426 | 1.34 | 0.04 |
| Batched IO vector read count | 727 | 0.40 | 0.01 |
| Block Cleanout Optim referenced | 4,366 | 2.42 | 0.07 |
| CCursor + sql area evicted | 785 | 0.44 | 0.01 |
| CPU used by this session | 293,451 | 162.68 | 4.77 |
| CPU used when call started | 277,651 | 153.92 | 4.51 |
| CR blocks created | 6,324 | 3.51 | 0.10 |
| Cached Commit SCN referenced | 17,980 | 9.97 | 0.29 |
| Clusterwide global transactions | 10,485 | 5.81 | 0.17 |
| Commit SCN cached | 26,568 | 14.73 | 0.43 |
| DB time | 660,345 | 366.06 | 10.74 |
| DBWR checkpoint buffers written | 47,276 | 26.21 | 0.77 |
| DBWR checkpoints | 133 | 0.07 | 0.00 |
| DBWR fusion writes | 9,454 | 5.24 | 0.15 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 599 | 0.33 | 0.01 |
| DBWR transaction table writes | 211 | 0.12 | 0.00 |
| DBWR undo block writes | 9,059 | 5.02 | 0.15 |
| DFO trees parallelized | 12 | 0.01 | 0.00 |
| DX/BB enqueue lock background get time | 401 | 0.22 | 0.01 |
| DX/BB enqueue lock background gets | 20,970 | 11.62 | 0.34 |
| DX/BB enqueue lock foreground requests | 721,565 | 400.00 | 11.73 |
| DX/BB enqueue lock foreground wait time | 1,911 | 1.06 | 0.03 |
| Effective IO time | 89,146,557 | 49,418.54 | 1,449.35 |
| GTX processes spawned by autotune | 0 | 0.00 | 0.00 |
| GTX processes stopped by autotune | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 111,563 | 61.85 | 1.81 |
| Heap Segment Array Inserts | 154 | 0.09 | 0.00 |
| Heap Segment Array Updates | 381 | 0.21 | 0.01 |
| Number of read IOs issued | 54,429 | 30.17 | 0.88 |
| PX local messages recv'd | 36 | 0.02 | 0.00 |
| PX local messages sent | 36 | 0.02 | 0.00 |
| PX remote messages recv'd | 60 | 0.03 | 0.00 |
| PX remote messages sent | 60 | 0.03 | 0.00 |
| Parallel operations downgraded to serial | 0 | 0.00 | 0.00 |
| Parallel operations not downgraded | 12 | 0.01 | 0.00 |
| Requests to/from client | 2,991,022 | 1,658.08 | 48.63 |
| RowCR - row contention | 1,685 | 0.93 | 0.03 |
| RowCR attempts | 13,288 | 7.37 | 0.22 |
| RowCR hits | 11,539 | 6.40 | 0.19 |
| 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 | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 2,991,163 | 1,658.16 | 48.63 |
| SQL*Net roundtrips to/from dblink | 1,188 | 0.66 | 0.02 |
| active txn count during cleanout | 10,850 | 6.01 | 0.18 |
| application wait time | 148,916,693 | 82,552.22 | 2,421.09 |
| background checkpoints completed | 0 | 0.00 | 0.00 |
| background checkpoints started | 0 | 0.00 | 0.00 |
| background timeouts | 15,977 | 8.86 | 0.26 |
| branch node splits | 3 | 0.00 | 0.00 |
| buffer is not pinned count | 68,601,600 | 38,029.41 | 1,115.33 |
| buffer is pinned count | 144,456,900 | 80,079.93 | 2,348.59 |
| bytes received via SQL*Net from client | 980,314,497 | 543,439.00 | 15,938.00 |
| bytes received via SQL*Net from dblink | 632,954 | 350.88 | 10.29 |
| bytes sent via SQL*Net to client | 1,370,788,520 | 759,898.93 | 22,286.35 |
| bytes sent via SQL*Net to dblink | 275,581 | 152.77 | 4.48 |
| calls to get snapshot scn: kcmgss | 862,189 | 477.96 | 14.02 |
| calls to kcmgas | 249,023 | 138.05 | 4.05 |
| calls to kcmgcs | 259,059 | 143.61 | 4.21 |
| cell physical IO interconnect bytes | 60,942,858,240 | 33,783,776.37 | 990,811.90 |
| change write time | 740 | 0.41 | 0.01 |
| cleanout - number of ktugct calls | 53,113 | 29.44 | 0.86 |
| cleanouts and rollbacks - consistent read gets | 5,993 | 3.32 | 0.10 |
| cleanouts only - consistent read gets | 35,810 | 19.85 | 0.58 |
| cluster key scan block gets | 5,592 | 3.10 | 0.09 |
| cluster key scans | 5,170 | 2.87 | 0.08 |
| cluster wait time | 14,430 | 8.00 | 0.23 |
| commit batch performed | 32 | 0.02 | 0.00 |
| commit batch requested | 32 | 0.02 | 0.00 |
| commit batch/immediate performed | 110 | 0.06 | 0.00 |
| commit batch/immediate requested | 110 | 0.06 | 0.00 |
| commit cleanout failures: block lost | 4,648 | 2.58 | 0.08 |
| commit cleanout failures: buffer being written | 1 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 10,894 | 6.04 | 0.18 |
| commit cleanout failures: cannot pin | 84 | 0.05 | 0.00 |
| commit cleanouts | 311,375 | 172.61 | 5.06 |
| commit cleanouts successfully completed | 295,748 | 163.95 | 4.81 |
| commit immediate performed | 78 | 0.04 | 0.00 |
| commit immediate requested | 78 | 0.04 | 0.00 |
| commit txn count during cleanout | 101,703 | 56.38 | 1.65 |
| concurrency wait time | 500 | 0.28 | 0.01 |
| consistent changes | 23,136 | 12.83 | 0.38 |
| consistent gets | 202,877,493 | 112,465.48 | 3,298.39 |
| consistent gets - examination | 31,387,762 | 17,399.86 | 510.30 |
| consistent gets direct | 6,858,472 | 3,802.01 | 111.51 |
| consistent gets from cache | 196,018,979 | 108,663.45 | 3,186.89 |
| consistent gets from cache (fastpath) | 162,989,490 | 90,353.50 | 2,649.89 |
| cursor authentications | 61,920 | 34.33 | 1.01 |
| data blocks consistent reads - undo records applied | 13,736 | 7.61 | 0.22 |
| db block changes | 953,133 | 528.37 | 15.50 |
| db block gets | 1,413,216 | 783.42 | 22.98 |
| db block gets direct | 7,537 | 4.18 | 0.12 |
| db block gets from cache | 1,405,679 | 779.24 | 22.85 |
| db block gets from cache (fastpath) | 358,072 | 198.50 | 5.82 |
| deferred (CURRENT) block cleanout applications | 79,430 | 44.03 | 1.29 |
| dirty buffers inspected | 4,849 | 2.69 | 0.08 |
| enqueue conversions | 821 | 0.46 | 0.01 |
| enqueue releases | 287,587 | 159.42 | 4.68 |
| enqueue requests | 287,548 | 159.40 | 4.67 |
| enqueue timeouts | 1 | 0.00 | 0.00 |
| enqueue waits | 1,035 | 0.57 | 0.02 |
| exchange deadlocks | 68 | 0.04 | 0.00 |
| execute count | 833,166 | 461.87 | 13.55 |
| failed probes on index block reclamation | 6 | 0.00 | 0.00 |
| file io wait time | 276,636,483 | 153,353.90 | 4,497.57 |
| free buffer inspected | 655,499 | 363.38 | 10.66 |
| free buffer requested | 647,857 | 359.14 | 10.53 |
| gc blocks compressed | 88,583 | 49.11 | 1.44 |
| gc cr block flush time | 837 | 0.46 | 0.01 |
| gc cr block receive time | 3,282 | 1.82 | 0.05 |
| gc cr blocks received | 47,474 | 26.32 | 0.77 |
| gc cr blocks served | 51,395 | 28.49 | 0.84 |
| gc current block flush time | 2,205,597 | 1,222.68 | 35.86 |
| gc current block pin time | 8,961,985 | 4,968.09 | 145.70 |
| gc current block receive time | 6,866 | 3.81 | 0.11 |
| gc current blocks received | 121,824 | 67.53 | 1.98 |
| gc current blocks served | 229,084 | 126.99 | 3.72 |
| gc kbytes saved | 220,586 | 122.28 | 3.59 |
| gc kbytes sent | 2,023,247 | 1,121.59 | 32.89 |
| gc local grants | 141,773 | 78.59 | 2.30 |
| gc read wait time | 1 | 0.00 | 0.00 |
| gc read wait timeouts | 0 | 0.00 | 0.00 |
| gc read waits | 1 | 0.00 | 0.00 |
| gc remote grants | 328,796 | 182.27 | 5.35 |
| gcs messages sent | 861,518 | 477.58 | 14.01 |
| ges messages sent | 99,358 | 55.08 | 1.62 |
| global enqueue get time | 4,684 | 2.60 | 0.08 |
| global enqueue gets async | 4,086 | 2.27 | 0.07 |
| global enqueue gets sync | 1,647,640 | 913.37 | 26.79 |
| global enqueue releases | 1,499,073 | 831.01 | 24.37 |
| heap block compress | 2,115 | 1.17 | 0.03 |
| hot buffers moved to head of LRU | 11,595 | 6.43 | 0.19 |
| immediate (CR) block cleanout applications | 41,805 | 23.17 | 0.68 |
| immediate (CURRENT) block cleanout applications | 32,488 | 18.01 | 0.53 |
| in call idle wait time | 9,192,101 | 5,095.66 | 149.45 |
| index crx upgrade (positioned) | 377 | 0.21 | 0.01 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 3,846 | 2.13 | 0.06 |
| index fetch by key | 11,230,073 | 6,225.41 | 182.58 |
| index scans kdiixs1 | 38,154,082 | 21,150.78 | 620.31 |
| leaf node 90-10 splits | 388 | 0.22 | 0.01 |
| leaf node splits | 1,314 | 0.73 | 0.02 |
| lob reads | 1,626 | 0.90 | 0.03 |
| lob writes | 1,728 | 0.96 | 0.03 |
| lob writes unaligned | 1,728 | 0.96 | 0.03 |
| logical read bytes from cache | 1,617,301,962,752 | 896,554,073.82 | 26,294,172.51 |
| logons cumulative | 576 | 0.32 | 0.01 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 155,148 | 86.01 | 2.52 |
| messages sent | 155,148 | 86.01 | 2.52 |
| min active SCN optimization applied on CR | 78 | 0.04 | 0.00 |
| no buffer to keep pinned count | 489 | 0.27 | 0.01 |
| no work - consistent read gets | 170,423,557 | 94,474.59 | 2,770.75 |
| non-idle wait count | 4,337,687 | 2,404.60 | 70.52 |
| non-idle wait time | 148,990,197 | 82,592.97 | 2,422.29 |
| opened cursors cumulative | 1,146,271 | 635.44 | 18.64 |
| parse count (describe) | 50 | 0.03 | 0.00 |
| parse count (failures) | 7 | 0.00 | 0.00 |
| parse count (hard) | 105,117 | 58.27 | 1.71 |
| parse count (total) | 890,288 | 493.53 | 14.47 |
| parse time cpu | 25,335 | 14.04 | 0.41 |
| parse time elapsed | 23,569 | 13.07 | 0.38 |
| physical read IO requests | 170,586 | 94.56 | 2.77 |
| physical read bytes | 59,873,353,728 | 33,190,894.73 | 973,423.84 |
| physical read total IO requests | 178,012 | 98.68 | 2.89 |
| physical read total bytes | 59,991,121,920 | 33,256,179.73 | 975,338.52 |
| physical read total multi block requests | 58,311 | 32.32 | 0.95 |
| physical reads | 7,308,759 | 4,051.62 | 118.83 |
| physical reads cache | 448,015 | 248.36 | 7.28 |
| physical reads cache prefetch | 333,051 | 184.63 | 5.41 |
| physical reads direct | 6,860,742 | 3,803.26 | 111.54 |
| physical reads direct (lob) | 12 | 0.01 | 0.00 |
| physical reads direct temporary tablespace | 2,270 | 1.26 | 0.04 |
| physical reads prefetch warmup | 1,432 | 0.79 | 0.02 |
| physical write IO requests | 45,492 | 25.22 | 0.74 |
| physical write bytes | 560,963,584 | 310,971.11 | 9,120.17 |
| physical write total IO requests | 171,286 | 94.95 | 2.78 |
| physical write total bytes | 951,736,320 | 527,596.64 | 15,473.37 |
| physical write total multi block requests | 871 | 0.48 | 0.01 |
| physical writes | 68,477 | 37.96 | 1.11 |
| physical writes direct | 9,807 | 5.44 | 0.16 |
| physical writes direct (lob) | 62 | 0.03 | 0.00 |
| physical writes direct temporary tablespace | 9,619 | 5.33 | 0.16 |
| physical writes from cache | 58,670 | 32.52 | 0.95 |
| physical writes non checkpoint | 49,886 | 27.65 | 0.81 |
| pinned buffers inspected | 10 | 0.01 | 0.00 |
| prefetch clients - default | 1 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 291 | 0.16 | 0.00 |
| prefetched blocks aged out before use | 0 | 0.00 | 0.00 |
| process last non-idle time | 1,788 | 0.99 | 0.03 |
| queries parallelized | 12 | 0.01 | 0.00 |
| recovery blocks read | 2 | 0.00 | 0.00 |
| recursive calls | 359,154 | 199.10 | 5.84 |
| recursive cpu usage | 22,654 | 12.56 | 0.37 |
| redo KB read | 0 | 0.00 | 0.00 |
| redo blocks checksummed by FG (exclusive) | 55,932 | 31.01 | 0.91 |
| redo blocks written | 353,447 | 195.93 | 5.75 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 548,426 | 304.02 | 8.92 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo log space wait time | 0 | 0.00 | 0.00 |
| redo ordering marks | 7,045 | 3.91 | 0.11 |
| redo size | 158,795,640 | 88,028.63 | 2,581.71 |
| redo size for direct writes | 1,546,908 | 857.53 | 25.15 |
| redo subscn max counts | 3,505 | 1.94 | 0.06 |
| redo synch long waits | 85 | 0.05 | 0.00 |
| redo synch time | 8,488 | 4.71 | 0.14 |
| redo synch time (usec) | 85,146,091 | 47,200.88 | 1,384.31 |
| redo synch writes | 54,215 | 30.05 | 0.88 |
| redo wastage | 16,137,044 | 8,945.60 | 262.36 |
| redo write broadcast ack count | 3,065 | 1.70 | 0.05 |
| redo write broadcast ack time | 103,360,538,706 | 57,298,089.15 | 1,680,440.57 |
| redo write broadcast lgwr post count | 1 | 0.00 | 0.00 |
| redo write time | 6,943 | 3.85 | 0.11 |
| redo writes | 60,973 | 33.80 | 0.99 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 398 | 0.22 | 0.01 |
| rollbacks only - consistent read gets | 1,465 | 0.81 | 0.02 |
| rows fetched via callback | 7,251,470 | 4,019.86 | 117.89 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 207,102 | 114.81 | 3.37 |
| session logical reads | 204,291,695 | 113,249.45 | 3,321.38 |
| shared hash latch upgrades - no wait | 766,791 | 425.07 | 12.47 |
| shared hash latch upgrades - wait | 88 | 0.05 | 0.00 |
| sorts (memory) | 1,669,316 | 925.39 | 27.14 |
| sorts (rows) | 79,871,957 | 44,277.15 | 1,298.56 |
| sql area evicted | 103,627 | 57.45 | 1.68 |
| sql area purged | 8 | 0.00 | 0.00 |
| summed dirty queue length | 13,461 | 7.46 | 0.22 |
| switch current to new buffer | 6,641 | 3.68 | 0.11 |
| table fetch by rowid | 98,607,212 | 54,663.07 | 1,603.16 |
| table fetch continued row | 3,265 | 1.81 | 0.05 |
| table scan blocks gotten | 108,791,053 | 60,308.50 | 1,768.73 |
| table scan rows gotten | 6,235,584,186 | 3,456,706.62 | 101,378.43 |
| table scans (direct read) | 8 | 0.00 | 0.00 |
| table scans (long tables) | 44 | 0.02 | 0.00 |
| table scans (short tables) | 64,721 | 35.88 | 1.05 |
| total cf enq hold time | 310 | 0.17 | 0.01 |
| total number of cf enq holders | 107 | 0.06 | 0.00 |
| total number of times SMON posted | 2 | 0.00 | 0.00 |
| transaction lock background gets | 0 | 0.00 | 0.00 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction rollbacks | 110 | 0.06 | 0.00 |
| transaction tables consistent read rollbacks | 13 | 0.01 | 0.00 |
| transaction tables consistent reads - undo records applied | 870 | 0.48 | 0.01 |
| undo change vector size | 54,477,236 | 30,199.55 | 885.69 |
| user I/O wait time | 29,629 | 16.42 | 0.48 |
| user calls | 4,332,809 | 2,401.90 | 70.44 |
| user commits | 54,456 | 30.19 | 0.89 |
| user rollbacks | 7,052 | 3.91 | 0.11 |
| workarea executions - onepass | 2 | 0.00 | 0.00 |
| workarea executions - optimal | 1,683,188 | 933.08 | 27.37 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 1 | 0.00 | 0.00 |
| Statistic | Begin Value | End Value |
|---|---|---|
| session pga memory | 25,382,742,272 | 25,882,508,016 |
| session pga memory max | 48,916,271,872 | 49,104,408,560 |
| session cursor cache count | 372,540 | 386,609 |
| session uga memory | 40,390,941,024,928 | 41,688,010,869,648 |
| opened cursors current | 1,544 | 1,480 |
| logons current | 331 | 283 |
| session uga memory max | 25,666,045,800 | 27,248,703,376 |
| Statistic | Total | per Hour |
|---|---|---|
| log switches (derived) | 0 | 0.00 |
| Function Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 52.3G | 30.22 | 29.7121 | 1M | 0.00 | .000554 | 0 | |
| Buffer Cache Reads | 3.4G | 64.31 | 1.94023 | 0M | 0.00 | 0M | 115K | 1.43 |
| DBWR | 0M | 0.00 | 0M | 457M | 24.98 | .253338 | 2 | 0.00 |
| LGWR | 0M | 0.00 | 0M | 346M | 68.86 | .191805 | 61.1K | 0.54 |
| Others | 112M | 4.14 | .062087 | 28M | 0.98 | .015521 | 8351 | 0.49 |
| Direct Writes | 0M | 0.00 | 0M | 75M | 0.20 | .041576 | 0 | |
| TOTAL: | 55.9G | 98.68 | 31.7144 | 907M | 95.03 | .502796 | 184.4K | 1.09 |
| Filetype Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Small Read | Large Read |
|---|---|---|---|---|---|---|---|---|
| Data File | 55.7G | 94.74 | 31.6119 | 458M | 25.02 | .253893 | 1.36 | 6.94 |
| Log File | 0M | 0.00 | 0M | 345M | 68.83 | .191251 | ||
| Temp File | 75M | 0.08 | .041576 | 76M | 0.18 | .042130 | 0.11 | 9.40 |
| Control File | 109M | 3.85 | .060424 | 28M | 0.98 | .015521 | 0.33 | |
| TOTAL: | 55.9G | 98.67 | 31.7139 | 907M | 95.00 | .502796 | 1.30 | 6.95 |
| Function/File Name | Reads: Data | Reqs per sec | Data per sec | Writes: Data | Reqs per sec | Data per sec | Waits: Count | Avg Tm(ms) |
|---|---|---|---|---|---|---|---|---|
| Direct Reads | 52.3G | 30.22 | 29.7121 | 1M | 0.00 | .000554 | 0 | |
| Direct Reads (Data File) | 52.3G | 30.22 | 29.7121 | 1M | 0.00 | .000554 | 0 | |
| Buffer Cache Reads | 3.4G | 64.30 | 1.93912 | 0M | 0.00 | 0M | 114.8K | 1.40 |
| Buffer Cache Reads (Data File) | 3.4G | 64.30 | 1.93912 | 0M | 0.00 | 0M | 114.8K | 1.40 |
| DBWR | 0M | 0.00 | 0M | 458M | 24.98 | .253893 | 2 | 0.00 |
| DBWR (Data File) | 0M | 0.00 | 0M | 458M | 24.98 | .253893 | 2 | 0.00 |
| LGWR | 0M | 0.00 | 0M | 345M | 68.81 | .191251 | 0 | |
| LGWR (Log File) | 0M | 0.00 | 0M | 345M | 68.81 | .191251 | 0 | |
| Others | 112M | 4.14 | .062087 | 28M | 0.98 | .015521 | 7471 | 0.48 |
| Others (Control File) | 108M | 3.85 | .059869 | 27M | 0.98 | .014967 | 6949 | 0.33 |
| Others (Data File) | 4M | 0.29 | .002217 | 1M | 0.01 | .000554 | 522 | 2.48 |
| Direct Writes | 0M | 0.00 | 0M | 75M | 0.20 | .041576 | 0 | |
| Direct Writes (Data File) | 0M | 0.00 | 0M | 75M | 0.20 | .041576 | 0 | |
| TOTAL: | 55.9G | 98.66 | 31.7133 | 907M | 94.99 | .502796 | 122.3K | 1.34 |
| Tablespace | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|---|---|---|---|---|---|---|---|
| BPPF_EAS_DAT_B01 | 154,914 | 86 | 0.66 | 47.01 | 4,973 | 3 | 61 | 0.98 |
| BPPF_EAS_IDX_B01 | 14,651 | 8 | 6.64 | 1.03 | 35,323 | 20 | 704 | 1.31 |
| BPPF_BIS_DAT_A01 | 44 | 0 | 4.55 | 1.00 | 2,646 | 1 | 39 | 0.77 |
| SYSAUX | 383 | 0 | 5.04 | 1.05 | 701 | 0 | 0 | 0.00 |
| UNDOTBS1 | 0 | 0 | 0.00 | 0.00 | 851 | 0 | 53 | 0.38 |
| BPPF_BIS_DAT_B01 | 208 | 0 | 3.94 | 1.04 | 382 | 0 | 21 | 1.43 |
| TEMP | 149 | 0 | 7.85 | 64.56 | 321 | 0 | 0 | 0.00 |
| BPPF_BIS_IDX_B01 | 115 | 0 | 4.70 | 1.01 | 136 | 0 | 21 | 0.95 |
| SYSTEM | 58 | 0 | 7.59 | 1.00 | 107 | 0 | 6 | 1.67 |
| BPPF_BIS_IDX_A01 | 25 | 0 | 5.60 | 1.00 | 41 | 0 | 59 | 0.00 |
| USERS | 39 | 0 | 6.41 | 1.00 | 7 | 0 | 0 | 0.00 |
| TS_MAINTAIN_DATA | 0 | 0 | 0.00 | 0.00 | 12 | 0 | 0 | 0.00 |
| BPPF_GOS_DAT_B01 | 2 | 0 | 5.00 | 1.00 | 7 | 0 | 0 | 0.00 |
| BPPF_GOS_IDX_B01 | 1 | 0 | 20.00 | 1.00 | 0 | 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) |
|---|---|---|---|---|---|---|---|---|---|
| BPPF_BIS_DAT_A01 | +DATA/bppfedb/datafile/bppf_bis_dat_a01.270.785362165 | 44 | 0 | 4.55 | 1.00 | 2,646 | 1 | 39 | 0.77 |
| BPPF_BIS_DAT_B01 | +DATA/bppfedb/datafile/bppf_bis_dat_b01.272.785362187 | 3 | 0 | 6.67 | 1.00 | 20 | 0 | 13 | 0.00 |
| BPPF_BIS_DAT_B01 | +DATA/bppfedb/datafile/bppf_bis_dat_b02.dbf | 98 | 0 | 3.88 | 1.00 | 127 | 0 | 1 | 0.00 |
| BPPF_BIS_DAT_B01 | +DATA/bppfedb/datafile/bppf_bis_dat_b03.dbf | 14 | 0 | 5.00 | 1.00 | 67 | 0 | 0 | 0.00 |
| BPPF_BIS_DAT_B01 | +DATA/bppfedb/datafile/bppf_bis_dat_b04.dbf | 93 | 0 | 3.76 | 1.09 | 168 | 0 | 7 | 4.29 |
| BPPF_BIS_IDX_A01 | +DATA/bppfedb/datafile/bppf_bis_idx_a01.271.785362175 | 25 | 0 | 5.60 | 1.00 | 41 | 0 | 59 | 0.00 |
| BPPF_BIS_IDX_B01 | +DATA/bppfedb/datafile/bppf_bis_idx_b01.273.785362309 | 115 | 0 | 4.70 | 1.01 | 136 | 0 | 21 | 0.95 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b01.278.785362659 | 5,393 | 3 | 0.67 | 83.86 | 728 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b02.dbf | 9,618 | 5 | 0.61 | 82.36 | 195 | 0 | 20 | 1.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b03.dbf | 8,710 | 5 | 0.69 | 76.15 | 258 | 0 | 22 | 1.36 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b04.dbf | 22,154 | 12 | 0.69 | 37.88 | 629 | 0 | 4 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b05.dbf | 15,868 | 9 | 0.69 | 52.94 | 1,289 | 1 | 1 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b06.dbf | 20,403 | 11 | 0.64 | 41.84 | 448 | 0 | 5 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b07.dbf | 24,561 | 14 | 0.66 | 27.95 | 251 | 0 | 4 | 2.50 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b08.dbf | 15,198 | 8 | 0.52 | 29.07 | 9 | 0 | 2 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b09.dbf | 11,357 | 6 | 0.65 | 38.24 | 0 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b10.dbf | 11,175 | 6 | 0.62 | 37.28 | 983 | 1 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b11.dbf | 2,013 | 1 | 0.64 | 101.86 | 2 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b12.dbf | 1,997 | 1 | 0.66 | 102.67 | 13 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b13.dbf | 1,990 | 1 | 1.06 | 83.13 | 25 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b14.dbf | 1,656 | 1 | 0.59 | 99.10 | 12 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b15.dbf | 790 | 0 | 0.73 | 79.56 | 4 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b16.dbf | 1,683 | 1 | 0.92 | 35.92 | 0 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b17.dbf | 80 | 0 | 4.38 | 1.20 | 0 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b18.dbf | 67 | 0 | 2.84 | 1.16 | 0 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b19.dbf | 66 | 0 | 3.94 | 1.20 | 3 | 0 | 0 | 0.00 |
| BPPF_EAS_DAT_B01 | +DATA/bppfedb/datafile/bppf_eas_dat_b20.dbf | 135 | 0 | 3.04 | 1.05 | 124 | 0 | 3 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_bis_idx_b02.dbf | 510 | 0 | 6.96 | 1.04 | 1,028 | 1 | 43 | 0.93 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01.279.785362673 | 181 | 0 | 6.69 | 1.00 | 393 | 0 | 1 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_02.dbf | 148 | 0 | 6.55 | 1.01 | 274 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_03.dbf | 156 | 0 | 6.54 | 1.06 | 257 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_04.dbf | 198 | 0 | 9.24 | 1.05 | 266 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_05.dbf | 114 | 0 | 6.40 | 1.00 | 119 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_06.dbf | 105 | 0 | 6.86 | 1.04 | 123 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_07.dbf | 374 | 0 | 7.11 | 1.03 | 578 | 0 | 5 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_08.dbf | 420 | 0 | 7.45 | 1.01 | 779 | 0 | 9 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_09.dbf | 559 | 0 | 7.30 | 1.06 | 1,131 | 1 | 8 | 3.75 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_10.dbf | 847 | 0 | 6.58 | 1.05 | 2,139 | 1 | 29 | 1.72 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_11.dbf | 779 | 0 | 7.00 | 1.02 | 1,586 | 1 | 60 | 1.33 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_12.dbf | 1,086 | 1 | 6.66 | 1.03 | 2,768 | 2 | 42 | 1.43 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_13.dbf | 938 | 1 | 6.84 | 1.04 | 2,715 | 2 | 65 | 1.23 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_14.dbf | 855 | 0 | 5.96 | 1.05 | 1,735 | 1 | 66 | 1.36 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_15.dbf | 942 | 1 | 6.43 | 1.03 | 2,450 | 1 | 35 | 0.86 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_16.dbf | 1,365 | 1 | 6.46 | 1.04 | 3,105 | 2 | 79 | 0.63 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_17.dbf | 717 | 0 | 6.65 | 1.04 | 2,564 | 1 | 89 | 1.46 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_18.dbf | 413 | 0 | 6.90 | 1.01 | 946 | 1 | 20 | 1.50 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_19.dbf | 303 | 0 | 6.50 | 1.05 | 626 | 0 | 8 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_20.dbf | 367 | 0 | 6.78 | 1.04 | 641 | 0 | 20 | 2.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_21.dbf | 406 | 0 | 6.82 | 1.02 | 1,052 | 1 | 33 | 1.82 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_22.dbf | 239 | 0 | 6.86 | 1.05 | 435 | 0 | 26 | 0.77 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_23.dbf | 248 | 0 | 7.06 | 1.02 | 410 | 0 | 3 | 16.67 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_24.dbf | 301 | 0 | 7.48 | 1.01 | 877 | 0 | 6 | 3.33 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_25.dbf | 190 | 0 | 6.84 | 1.04 | 828 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_26.dbf | 121 | 0 | 7.11 | 1.00 | 279 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_27.dbf | 184 | 0 | 6.79 | 1.02 | 921 | 1 | 1 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_28.dbf | 249 | 0 | 4.34 | 1.06 | 611 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_29.dbf | 296 | 0 | 5.10 | 1.03 | 943 | 1 | 18 | 1.11 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_30.dbf | 221 | 0 | 3.53 | 1.04 | 215 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_31.dbf | 103 | 0 | 6.41 | 1.04 | 278 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_32.dbf | 110 | 0 | 6.73 | 1.03 | 256 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_33.dbf | 94 | 0 | 6.38 | 1.00 | 240 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_34.dbf | 61 | 0 | 7.54 | 1.00 | 163 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_35.dbf | 59 | 0 | 7.29 | 1.10 | 152 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_36.dbf | 46 | 0 | 5.65 | 1.00 | 83 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_37.dbf | 51 | 0 | 6.67 | 1.10 | 80 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_38.dbf | 36 | 0 | 5.28 | 1.00 | 82 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_39.dbf | 50 | 0 | 7.00 | 1.00 | 156 | 0 | 12 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_40.dbf | 60 | 0 | 7.50 | 1.02 | 222 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_41.dbf | 60 | 0 | 7.00 | 1.07 | 434 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_42.dbf | 13 | 0 | 6.92 | 1.00 | 107 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_44.dbf | 3 | 0 | 3.33 | 1.00 | 2 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_45.dbf | 5 | 0 | 6.00 | 1.00 | 4 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_46.dbf | 12 | 0 | 5.00 | 1.00 | 9 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_47.dbf | 11 | 0 | 5.45 | 1.00 | 6 | 0 | 0 | 0.00 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_48.dbf | 45 | 0 | 7.11 | 1.00 | 253 | 0 | 26 | 1.54 |
| BPPF_EAS_IDX_B01 | +DATA/bppfedb/datafile/bppf_eas_idx_b01_49.dbf | 0 | 0 | 2 | 0 | 0 | 0.00 | ||
| BPPF_GOS_DAT_B01 | +DATA/bppfedb/datafile/bppf_gos_dat_b01.284.785362723 | 2 | 0 | 5.00 | 1.00 | 7 | 0 | 0 | 0.00 |
| BPPF_GOS_IDX_B01 | +DATA/bppfedb/datafile/bppf_gos_idx_b01.285.785362733 | 1 | 0 | 20.00 | 1.00 | 0 | 0 | 0 | 0.00 |
| SYSAUX | +DATA/bppfedb/datafile/sysaux.261.785359287 | 90 | 0 | 8.11 | 1.00 | 266 | 0 | 0 | 0.00 |
| SYSAUX | +DATA/bppfedb/datafile/sysaux01.dbf | 84 | 0 | 10.60 | 1.00 | 300 | 0 | 0 | 0.00 |
| SYSAUX | +DATA/bppfedb/datafile/sysaux02.dbf | 209 | 0 | 1.48 | 1.10 | 135 | 0 | 0 | 0.00 |
| SYSTEM | +DATA/bppfedb/datafile/system.260.785359279 | 55 | 0 | 7.82 | 1.00 | 93 | 0 | 6 | 1.67 |
| SYSTEM | +DATA/bppfedb/datafile/system01.dbf | 3 | 0 | 3.33 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEMP | +DATA/bppfedb/tempfile/temp.263.785359309 | 1 | 0 | 80.00 | 51.00 | 2 | 0 | 0 | |
| TEMP | +DATA/bppfedb/tempfile/temp_01.dbf | 148 | 0 | 7.36 | 64.65 | 319 | 0 | 0 | |
| TS_MAINTAIN_DATA | +DATA/bppfedb/datafile/ts_maintain_data01.dbf | 0 | 0 | 12 | 0 | 0 | 0.00 | ||
| UNDOTBS1 | +DATA/bppfedb/datafile/undotbs1.262.785359293 | 0 | 0 | 851 | 0 | 53 | 0.38 | ||
| USERS | +DATA/bppfedb/datafile/users.265.785359339 | 39 | 0 | 6.41 | 1.00 | 7 | 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 | 5,837,671 | 100 | 197,487,430 | 448,007 | 58,676 | 0 | 0 | 1,059 |
| MTTR Writes | Log Size Writes | Log Ckpt Writes | Other Settings Writes | Autotune Ckpt Writes | Thread Ckpt Writes |
|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 46,692 | 0 |
| Targt MTTR (s) | Estd MTTR (s) | Recovery Estd IOs | Actual RedoBlks | Target RedoBlks | Log Sz RedoBlks | Log Ckpt Timeout RedoBlks | Log Ckpt Interval RedoBlks | Opt Log Sz(M) | Estd RAC Avail Time | |
|---|---|---|---|---|---|---|---|---|---|---|
| B | 0 | 4 | 14590 | 111120 | 384884 | 1698651 | 384884 | 2 | ||
| E | 0 | 2 | 10005 | 70084 | 353296 | 1698651 | 353296 | 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 | 4,864 | 0.10 | 575 | 7.31 | 47,179 | 1 | 139215.00 |
| D | 9,728 | 0.20 | 1,149 | 3.54 | 22,838 | 1 | 62617.00 |
| D | 14,592 | 0.30 | 1,724 | 1.10 | 7,088 | 1 | 13055.00 |
| D | 19,456 | 0.39 | 2,299 | 1.03 | 6,680 | 1 | 11772.00 |
| D | 24,320 | 0.49 | 2,873 | 1.02 | 6,594 | 1 | 11498.00 |
| D | 29,184 | 0.59 | 3,448 | 1.02 | 6,554 | 1 | 11374.00 |
| D | 34,048 | 0.69 | 4,023 | 1.00 | 6,482 | 1 | 11147.00 |
| D | 38,912 | 0.79 | 4,598 | 1.00 | 6,457 | 1 | 11068.00 |
| D | 43,776 | 0.89 | 5,172 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 48,640 | 0.98 | 5,747 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 49,408 | 1.00 | 5,838 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 53,504 | 1.08 | 6,322 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 58,368 | 1.18 | 6,896 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 63,232 | 1.28 | 7,471 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 68,096 | 1.38 | 8,046 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 72,960 | 1.48 | 8,620 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 77,824 | 1.58 | 9,195 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 82,688 | 1.67 | 9,770 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 87,552 | 1.77 | 10,344 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 92,416 | 1.87 | 10,919 | 1.00 | 6,456 | 1 | 11064.00 |
| D | 97,280 | 1.97 | 11,494 | 0.97 | 6,264 | 1 | 10460.00 |
| PGA Cache Hit % | W/A MB Processed | Extra W/A MB Read/Written |
|---|---|---|
| 99.09 | 18,839 | 173 |
| Low Optimal | High Optimal | Total Execs | Optimal Execs | 1-Pass Execs | M-Pass Execs |
|---|---|---|---|---|---|
| 2K | 4K | 1,674,252 | 1,674,252 | 0 | 0 |
| 64K | 128K | 777 | 777 | 0 | 0 |
| 128K | 256K | 604 | 604 | 0 | 0 |
| 256K | 512K | 2,580 | 2,580 | 0 | 0 |
| 512K | 1024K | 2,658 | 2,658 | 0 | 0 |
| 1M | 2M | 726 | 726 | 0 | 0 |
| 2M | 4M | 326 | 326 | 0 | 0 |
| 4M | 8M | 740 | 740 | 0 | 0 |
| 8M | 16M | 460 | 460 | 0 | 0 |
| 64M | 128M | 2 | 0 | 2 | 0 |
| 128M | 256M | 4 | 4 | 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 |
|---|---|---|---|---|---|---|
| 5,280 | 0.13 | 160,377.21 | 86.73 | 100.00 | 0 | 4,438,248 |
| 10,560 | 0.25 | 160,377.21 | 86.73 | 100.00 | 0 | 4,438,248 |
| 21,120 | 0.50 | 160,377.21 | 86.73 | 100.00 | 0 | 4,438,248 |
| 31,680 | 0.75 | 160,377.21 | 86.73 | 100.00 | 0 | 4,438,248 |
| 42,240 | 1.00 | 160,377.21 | 86.73 | 100.00 | 0 | 4,438,248 |
| 50,688 | 1.20 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 59,136 | 1.40 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 67,584 | 1.60 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 76,032 | 1.80 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 84,480 | 2.00 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 126,720 | 3.00 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 168,960 | 4.00 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 253,440 | 6.00 | 160,377.21 | 0.00 | 100.00 | 0 | 4,435,849 |
| 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) |
|---|---|---|---|---|---|---|---|---|
| 7,424 | 0.78 | 341 | 53,610 | 115,050 | 0.96 | 9,274 | 1.82 | 23,605 |
| 7,680 | 0.81 | 596 | 69,097 | 116,008 | 0.97 | 8,316 | 1.63 | 23,955 |
| 7,936 | 0.84 | 851 | 84,854 | 116,514 | 0.98 | 7,810 | 1.53 | 24,190 |
| 8,192 | 0.86 | 1,106 | 100,100 | 116,971 | 0.98 | 7,353 | 1.44 | 24,403 |
| 8,448 | 0.89 | 1,361 | 115,690 | 117,393 | 0.98 | 6,931 | 1.36 | 24,606 |
| 8,704 | 0.92 | 1,616 | 132,145 | 117,800 | 0.99 | 6,524 | 1.28 | 24,805 |
| 8,960 | 0.95 | 1,872 | 147,823 | 118,193 | 0.99 | 6,131 | 1.20 | 24,998 |
| 9,216 | 0.97 | 2,127 | 163,359 | 118,582 | 0.99 | 5,742 | 1.13 | 25,189 |
| 9,472 | 1.00 | 2,382 | 178,525 | 119,230 | 1.00 | 5,094 | 1.00 | 25,521 |
| 9,728 | 1.03 | 2,637 | 193,767 | 119,358 | 1.00 | 4,966 | 0.97 | 25,594 |
| 9,984 | 1.05 | 2,890 | 208,344 | 119,376 | 1.00 | 4,948 | 0.97 | 25,603 |
| 10,240 | 1.08 | 3,145 | 223,642 | 119,390 | 1.00 | 4,934 | 0.97 | 25,611 |
| 10,496 | 1.11 | 3,401 | 238,466 | 119,400 | 1.00 | 4,924 | 0.97 | 25,618 |
| 10,752 | 1.14 | 3,657 | 253,237 | 119,414 | 1.00 | 4,910 | 0.96 | 25,625 |
| 11,008 | 1.16 | 3,913 | 268,574 | 119,423 | 1.00 | 4,901 | 0.96 | 25,632 |
| 11,264 | 1.19 | 4,169 | 284,680 | 119,432 | 1.00 | 4,892 | 0.96 | 25,638 |
| 11,520 | 1.22 | 4,425 | 299,979 | 119,440 | 1.00 | 4,884 | 0.96 | 25,644 |
| 11,776 | 1.24 | 4,681 | 318,008 | 119,448 | 1.00 | 4,876 | 0.96 | 25,650 |
| 12,544 | 1.32 | 5,448 | 366,233 | 119,476 | 1.00 | 4,848 | 0.95 | 25,667 |
| 13,568 | 1.43 | 6,472 | 428,895 | 119,512 | 1.00 | 4,812 | 0.94 | 25,690 |
| 14,592 | 1.54 | 7,495 | 490,799 | 119,555 | 1.00 | 4,769 | 0.94 | 25,716 |
| 15,616 | 1.65 | 8,518 | 553,227 | 119,584 | 1.00 | 4,740 | 0.93 | 25,734 |
| 16,640 | 1.76 | 9,541 | 616,927 | 119,627 | 1.00 | 4,697 | 0.92 | 25,755 |
| 17,664 | 1.86 | 10,564 | 680,786 | 119,675 | 1.00 | 4,649 | 0.91 | 25,778 |
| 18,688 | 1.97 | 11,588 | 743,182 | 119,702 | 1.00 | 4,622 | 0.91 | 25,794 |
| 19,712 | 2.08 | 12,610 | 806,899 | 119,729 | 1.00 | 4,595 | 0.90 | 25,807 |
| SGA Target Size (M) | SGA Size Factor | Est DB Time (s) | Est Physical Reads |
|---|---|---|---|
| 15,040 | 0.25 | 218,505 | 47,170,862 |
| 22,560 | 0.38 | 94,793 | 7,087,024 |
| 30,080 | 0.50 | 89,137 | 6,679,026 |
| 37,600 | 0.63 | 88,776 | 6,592,520 |
| 45,120 | 0.75 | 88,450 | 6,480,837 |
| 52,640 | 0.88 | 88,195 | 6,480,837 |
| 60,160 | 1.00 | 88,089 | 6,455,660 |
| 67,680 | 1.13 | 88,090 | 6,454,369 |
| 75,200 | 1.25 | 88,090 | 6,454,369 |
| 82,720 | 1.38 | 88,090 | 6,454,369 |
| 90,240 | 1.50 | 88,090 | 6,454,369 |
| 97,760 | 1.63 | 88,090 | 6,454,369 |
| 105,280 | 1.75 | 87,764 | 6,262,636 |
| 112,800 | 1.88 | 87,482 | 6,262,636 |
| 120,320 | 2.00 | 87,482 | 6,262,636 |
| Size for Est (MB) | Size Factor | Est Spill Count | Est Spill Time (s) | Est Unspill Count | Est Unspill Time (s) |
|---|---|---|---|---|---|
| 256 | 1.00 | 0 | 0 | 0 | 0 |
| 512 | 2.00 | 0 | 0 | 0 | 0 |
| 768 | 3.00 | 0 | 0 | 0 | 0 |
| 1,024 | 4.00 | 0 | 0 | 0 | 0 |
| 1,280 | 5.00 | 0 | 0 | 0 | 0 |
| 1,536 | 6.00 | 0 | 0 | 0 | 0 |
| 1,792 | 7.00 | 0 | 0 | 0 | 0 |
| 2,048 | 8.00 | 0 | 0 | 0 | 0 |
| 2,304 | 9.00 | 0 | 0 | 0 | 0 |
| 2,560 | 10.00 | 0 | 0 | 0 | 0 |
| 2,816 | 11.00 | 0 | 0 | 0 | 0 |
| 3,072 | 12.00 | 0 | 0 | 0 | 0 |
| 3,328 | 13.00 | 0 | 0 | 0 | 0 |
| 3,584 | 14.00 | 0 | 0 | 0 | 0 |
| 3,840 | 15.00 | 0 | 0 | 0 | 0 |
| 4,096 | 16.00 | 0 | 0 | 0 | 0 |
| 4,352 | 17.00 | 0 | 0 | 0 | 0 |
| 4,608 | 18.00 | 0 | 0 | 0 | 0 |
| 4,864 | 19.00 | 0 | 0 | 0 | 0 |
| 5,120 | 20.00 | 0 | 0 | 0 | 0 |
| Class | Waits | Total Wait Time (s) | Avg Time (ms) |
|---|---|---|---|
| data block | 864 | 1 | 1 |
| undo header | 84 | 0 | 1 |
| undo block | 63 | 0 | 1 |
| segment header | 37 | 0 | 1 |
| 1st level bmb | 10 | 0 | 0 |
| Enqueue Type (Request Reason) | Requests | Succ Gets | Failed Gets | Waits | Wt Time (s) | Av Wt Time(ms) |
|---|---|---|---|---|---|---|
| TX-Transaction (index contention) | 198 | 198 | 0 | 161 | 1 | 6.21 |
| TX-Transaction (row lock contention) | 56 | 56 | 0 | 43 | 1 | 12.09 |
| KO-Multiple Object Checkpoint (fast object checkpoint) | 788 | 788 | 0 | 337 | 0 | 0.59 |
| JQ-Job Queue | 302 | 302 | 0 | 298 | 0 | 0.47 |
| CF-Controlfile Transaction | 4,085 | 4,085 | 0 | 66 | 0 | 1.21 |
| PS-PX Process Reservation | 93 | 93 | 0 | 42 | 0 | 0.48 |
| TT-Tablespace | 2,714 | 2,714 | 0 | 16 | 0 | 0.63 |
| TX-Transaction (allocate ITL entry) | 8 | 8 | 0 | 8 | 0 | 1.25 |
| TD-KTF map table enqueue (KTF dump entries) | 4 | 4 | 0 | 4 | 0 | 2.50 |
| FB-Format Block | 48 | 48 | 0 | 26 | 0 | 0.00 |
| WF-AWR Flush | 22 | 22 | 0 | 12 | 0 | 0.00 |
| TM-DML | 94,423 | 94,421 | 0 | 5 | 0 | 0.00 |
| RO-Multiple Object Reuse (fast object reuse) | 8 | 8 | 0 | 4 | 0 | 0.00 |
| TA-Instance Undo | 5 | 5 | 0 | 4 | 0 | 0.00 |
| TS-Temporary Segment | 2 | 2 | 0 | 2 | 0 | 0.00 |
| AE-Edition Lock (lock) | 535 | 535 | 0 | 1 | 0 | 0.00 |
| AF-Advisor Framework (task serialization) | 13 | 13 | 0 | 1 | 0 | 0.00 |
| CR-Reuse Block Range (block range reuse ckpt) | 6 | 6 | 0 | 1 | 0 | 0.00 |
| DR-Distributed Recovery | 1 | 1 | 0 | 1 | 0 | 0.00 |
| HW-Segment High Water Mark | 1,223 | 1,223 | 0 | 1 | 0 | 0.00 |
| JS-Job Scheduler (job run lock - synchronize) | 1 | 1 | 0 | 1 | 0 | 0.00 |
| TO-Temp Object | 2 | 2 | 0 | 1 | 0 | 0.00 |
| TQ-Queue table enqueue (TM contention) | 25 | 25 | 0 | 1 | 0 | 0.00 |
| UL-User-defined | 2 | 2 | 0 | 1 | 0 | 0.00 |
| Undo TS# | Num Undo Blocks (K) | Number of Transactions | Max Qry Len (s) | Max Tx Concurcy | Min/Max TR (mins) | STO/ OOS | uS/uR/uU/ eS/eR/eU |
|---|---|---|---|---|---|---|---|
| 2 | 8.58 | 59,949 | 1,199 | 17 | 29610.1/29987.2 | 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 |
|---|---|---|---|---|---|---|---|
| 05-Mar 11:26 | 2,318 | 20,251 | 596 | 12 | 29,610 | 0/0 | 0/0/0/0/0/0 |
| 05-Mar 11:16 | 1,965 | 15,314 | 1,199 | 11 | 29,835 | 0/0 | 0/0/0/0/0/0 |
| 05-Mar 11:06 | 4,297 | 24,384 | 597 | 17 | 29,987 | 0/0 | 0/0/0/0/0/0 |
| Latch Name | Get Requests | Pct Get Miss | Avg Slps /Miss | Wait Time (s) | NoWait Requests | Pct NoWait Miss |
|---|---|---|---|---|---|---|
| AQ deq hash table latch | 1 | 0.00 | 0 | 0 | ||
| AQ dequeue txn counter latch | 420 | 0.00 | 0 | 0 | ||
| ASM Keyed state latch | 545 | 0.00 | 0 | 0 | ||
| ASM allocation | 158 | 0.00 | 0 | 0 | ||
| ASM db client latch | 1,705 | 0.00 | 0 | 0 | ||
| ASM map operation freelist | 3,503 | 2.71 | 0.00 | 0 | 0 | |
| ASM map operation hash table | 703,871 | 0.00 | 0.00 | 0 | 0 | |
| ASM network background latch | 839 | 0.00 | 0 | 0 | ||
| ASM network state latch | 273 | 0.00 | 0 | 0 | ||
| AWR Alerted Metric Element list | 22,949 | 0.00 | 0 | 0 | ||
| Change Notification Hash table latch | 605 | 0.00 | 0 | 0 | ||
| Consistent RBA | 60,974 | 0.01 | 0.00 | 0 | 0 | |
| DML lock allocation | 9,508,438 | 0.00 | 0.00 | 0 | 0 | |
| Event Group Locks | 828 | 0.00 | 0 | 0 | ||
| FAL Queue | 48 | 0.00 | 0 | 0 | ||
| FOB s.o list latch | 10,689 | 5.14 | 0.00 | 0 | 0 | |
| File State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
| I/O Staticstics latch | 1 | 0.00 | 0 | 0 | ||
| IPC other latch | 17 | 0.00 | 0 | 0 | ||
| IPC stats buffer allocation latch | 1,196 | 0.00 | 0 | 940 | 0.00 | |
| In memory undo latch | 1 | 0.00 | 0 | 0 | ||
| JS Sh mem access | 5 | 0.00 | 0 | 0 | ||
| JS broadcast add buf latch | 416 | 0.00 | 0 | 0 | ||
| JS broadcast autostart latch | 76 | 0.00 | 0 | 0 | ||
| JS broadcast drop buf latch | 416 | 0.00 | 0 | 0 | ||
| JS broadcast load blnc latch | 361 | 0.00 | 0 | 0 | ||
| JS mem alloc latch | 3 | 0.00 | 0 | 0 | ||
| JS queue access latch | 4 | 0.00 | 0 | 0 | ||
| JS queue state obj latch | 13,120 | 0.00 | 0 | 0 | ||
| JS slv state obj latch | 26 | 0.00 | 0 | 0 | ||
| KFC FX Hash Latch | 1 | 0.00 | 0 | 0 | ||
| KFC Hash Latch | 1 | 0.00 | 0 | 0 | ||
| KFCL LE Freelist | 1 | 0.00 | 0 | 0 | ||
| KFK SGA Libload latch | 600 | 0.00 | 0 | 0 | ||
| KFMD SGA | 6 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SHM structure | 1 | 0.00 | 0 | 0 | ||
| KGNFS-NFS:SVR LIST | 1 | 0.00 | 0 | 0 | ||
| KJC message pool free list | 44,471 | 0.10 | 0.00 | 0 | 23,701 | 0.00 |
| KJCT flow control latch | 1,042,471 | 0.01 | 0.00 | 0 | 0 | |
| KMG MMAN ready and startup request latch | 602 | 0.00 | 0 | 0 | ||
| KSXR large replies | 122 | 0.00 | 0 | 0 | ||
| KTF sga latch | 14 | 0.00 | 0 | 605 | 0.00 | |
| KWQMN job cache list latch | 262 | 0.00 | 0 | 0 | ||
| KWQP Prop Status | 2 | 0.00 | 0 | 0 | ||
| KWQS pqsubs latch | 3 | 0.00 | 0 | 0 | ||
| KWQS pqueue ctx latch | 12 | 0.00 | 0 | 0 | ||
| Locator state objects pool parent latch | 1 | 0.00 | 0 | 0 | ||
| Lsod array latch | 4,350 | 1.66 | 0.01 | 0 | 0 | |
| MQL Tracking Latch | 0 | 0 | 36 | 0.00 | ||
| Memory Management Latch | 1 | 0.00 | 0 | 602 | 0.00 | |
| Memory Queue | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #1 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #2 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #3 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Message Subscriber #4 | 1 | 0.00 | 0 | 0 | ||
| Memory Queue Subscriber | 1 | 0.00 | 0 | 0 | ||
| MinActiveScn Latch | 1,240 | 0.00 | 0 | 0 | ||
| Mutex | 1 | 0.00 | 0 | 0 | ||
| Mutex Stats | 1 | 0.00 | 0 | 0 | ||
| OS process | 1,260 | 0.00 | 0 | 0 | ||
| OS process allocation | 4,231 | 0.02 | 0.00 | 0 | 0 | |
| OS process: request allocation | 545 | 0.00 | 0 | 0 | ||
| PL/SQL warning settings | 1,550 | 0.00 | 0 | 0 | ||
| PX hash array latch | 1 | 0.00 | 0 | 0 | ||
| QMT | 1 | 0.00 | 0 | 0 | ||
| Real-time plan statistics latch | 22,527 | 0.00 | 0 | 0 | ||
| SGA IO buffer pool latch | 4 | 0.00 | 0 | 4 | 0.00 | |
| SGA blob parent | 1 | 0.00 | 0 | 0 | ||
| SGA bucket locks | 1 | 0.00 | 0 | 0 | ||
| SGA heap locks | 1 | 0.00 | 0 | 0 | ||
| SGA pool locks | 1 | 0.00 | 0 | 0 | ||
| SQL memory manager latch | 61 | 0.00 | 0 | 600 | 0.00 | |
| SQL memory manager workarea list latch | 142,182 | 0.00 | 0 | 0 | ||
| Shared B-Tree | 257 | 0.00 | 0 | 0 | ||
| Streams Generic | 1 | 0.00 | 0 | 0 | ||
| Testing | 1 | 0.00 | 0 | 0 | ||
| Token Manager | 1 | 0.00 | 0 | 0 | ||
| WCR: sync | 1 | 0.00 | 0 | 0 | ||
| Write State Object Pool Parent Latch | 1 | 0.00 | 0 | 0 | ||
| X$KSFQP | 1 | 0.00 | 0 | 0 | ||
| XDB NFS Security Latch | 1 | 0.00 | 0 | 0 | ||
| XDB unused session pool | 1 | 0.00 | 0 | 0 | ||
| XDB used session pool | 1 | 0.00 | 0 | 0 | ||
| active checkpoint queue latch | 51,977 | 0.55 | 0.00 | 0 | 0 | |
| active service list | 2,277,901 | 0.02 | 0.01 | 0 | 17,680 | 0.01 |
| archive control | 30 | 0.00 | 0 | 0 | ||
| archive process latch | 144 | 0.00 | 0 | 0 | ||
| begin backup scn array | 68 | 0.00 | 0 | 0 | ||
| buffer pool | 1 | 0.00 | 0 | 0 | ||
| business card | 25 | 0.00 | 0 | 0 | ||
| cache buffer handles | 8,995 | 0.03 | 0.00 | 0 | 0 | |
| cache buffers chains | 368,369,411 | 0.14 | 0.00 | 0 | 17,840,936 | 0.00 |
| cache buffers lru chain | 529,009 | 0.01 | 0.00 | 0 | 20,985,105 | 0.01 |
| cache table scan latch | 38,053 | 0.00 | 0 | 38,053 | 0.00 | |
| call allocation | 3,654 | 0.90 | 0.64 | 0 | 0 | |
| cas latch | 1 | 0.00 | 0 | 0 | ||
| change notification client cache latch | 1 | 0.00 | 0 | 0 | ||
| channel handle pool latch | 575 | 0.35 | 0.00 | 0 | 0 | |
| channel operations parent latch | 689,820 | 0.00 | 0.00 | 0 | 0 | |
| checkpoint queue latch | 2,033,486 | 0.00 | 0.00 | 0 | 117,201 | 0.00 |
| client/application info | 3,530 | 0.00 | 0 | 0 | ||
| compile environment latch | 579 | 0.00 | 0 | 0 | ||
| corrupted undo seg latch | 1,304 | 0.00 | 0 | 0 | ||
| cp cmon/server latch | 1 | 0.00 | 0 | 0 | ||
| cp pool latch | 1 | 0.00 | 0 | 0 | ||
| cp server hash latch | 1 | 0.00 | 0 | 0 | ||
| cp sga latch | 59 | 0.00 | 0 | 0 | ||
| cvmap freelist lock | 1 | 0.00 | 0 | 0 | ||
| deferred cleanup latch | 59 | 0.00 | 0 | 0 | ||
| dml lock allocation | 63 | 0.00 | 0 | 0 | ||
| done queue latch | 1 | 0.00 | 0 | 0 | ||
| dummy allocation | 1,207 | 0.41 | 0.00 | 0 | 0 | |
| enqueue freelist latch | 1 | 0.00 | 0 | 267,739 | 0.00 | |
| enqueue hash chains | 779,324 | 0.02 | 0.01 | 0 | 1 | 0.00 |
| enqueues | 59 | 0.00 | 0 | 0 | ||
| error message lists | 54 | 0.00 | 0 | 0 | ||
| fifth spare latch | 1 | 0.00 | 0 | 0 | ||
| file cache latch | 2,196 | 0.00 | 0 | 0 | ||
| flashback copy | 1 | 0.00 | 0 | 0 | ||
| fourth Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
| gc element | 3,525,756 | 0.06 | 0.02 | 0 | 44,400 | 0.01 |
| gc persistent rm | 1 | 0.00 | 0 | 0 | ||
| gcr global ctx | 28 | 0.00 | 0 | 0 | ||
| gcs commit scn state | 1 | 0.00 | 0 | 0 | ||
| gcs opaque info freelist | 348,646 | 0.14 | 0.00 | 0 | 0 | |
| gcs partitioned table hash | 16,940,325 | 0.40 | 0.00 | 0 | 209,893 | 0.00 |
| gcs pcm hashed value bucket hash | 1 | 0.00 | 0 | 0 | ||
| gcs remaster request queue | 177 | 0.56 | 0.00 | 0 | 0 | |
| gcs remastering latch | 5,863,555 | 1.45 | 0.00 | 0 | 38 | 7.89 |
| gcs resource freelist | 99,964 | 0.00 | 0.00 | 0 | 1,092,953 | 0.00 |
| gcs resource hash | 13,767,422 | 0.00 | 0.00 | 0 | 9 | 0.00 |
| gcs resource scan list | 20 | 0.00 | 0 | 0 | ||
| gcs shadows freelist | 70,200 | 0.00 | 0.00 | 0 | 1,035,032 | 0.00 |
| ges DFS wait callback info | 1 | 0.00 | 0 | 0 | ||
| ges caches resource lists | 519,866 | 0.03 | 0.03 | 0 | 135,178 | 0.03 |
| ges deadlock list | 2,440 | 0.00 | 0 | 0 | ||
| ges domain table | 1,664,423 | 0.00 | 0.00 | 0 | 0 | |
| ges enqueue table freelist | 3,022,125 | 0.01 | 0.00 | 0 | 0 | |
| ges group table | 3,129,099 | 0.02 | 0.00 | 0 | 0 | |
| ges process hash list | 111,447 | 0.00 | 1.00 | 0 | 0 | |
| ges process parent latch | 6,182,637 | 0.00 | 0 | 0 | ||
| ges process table freelist | 545 | 0.73 | 0.00 | 0 | 0 | |
| ges resource hash list | 6,383,799 | 0.02 | 0.06 | 0 | 42,231 | 0.00 |
| ges resource scan list | 735 | 0.00 | 0 | 0 | ||
| ges resource table freelist | 81,060 | 0.00 | 0 | 2 | 0.00 | |
| ges timeout list | 12,090 | 0.00 | 0 | 224 | 0.45 | |
| ges value block free list | 1,172,599 | 0.11 | 0.01 | 0 | 0 | |
| global KZLD latch for mem in SGA | 187 | 0.00 | 0 | 0 | ||
| global tx hash mapping | 601,742 | 0.00 | 0.00 | 0 | 0 | |
| granule operation | 1 | 0.00 | 0 | 0 | ||
| hash table column usage latch | 748 | 0.00 | 0 | 1,178,483 | 0.00 | |
| hash table modification latch | 104 | 0.00 | 0 | 0 | ||
| heartbeat check | 1 | 0.00 | 0 | 603 | 0.00 | |
| heartbeat structure management | 0 | 0 | 361 | 0.00 | ||
| instance information | 2,100 | 0.00 | 0 | 0 | ||
| internal temp table object number allocation latch | 83 | 0.00 | 0 | 0 | ||
| interrupt manipulation | 234 | 0.00 | 0 | 0 | ||
| intra txn parallel recovery | 1 | 0.00 | 0 | 0 | ||
| io pool granule metadata list | 1 | 0.00 | 0 | 0 | ||
| job workq parent latch | 304 | 0.00 | 0 | 304 | 5.26 | |
| job_queue_processes free list latch | 606 | 0.00 | 0 | 0 | ||
| job_queue_processes parameter latch | 696 | 0.00 | 0 | 0 | ||
| k2q global data latch | 45,337 | 0.00 | 0 | 0 | ||
| k2q lock allocation | 1,119,936 | 0.00 | 0.00 | 0 | 0 | |
| kdlx hb parent latch | 1 | 0.00 | 0 | 0 | ||
| kgb parent | 1 | 0.00 | 0 | 0 | ||
| kgnfs mount latch | 1 | 0.00 | 0 | 0 | ||
| kokc descriptor allocation latch | 50 | 0.00 | 0 | 0 | ||
| ksfv messages | 1 | 0.00 | 0 | 0 | ||
| ksim group membership cache | 1,086 | 0.00 | 0 | 0 | ||
| ksim membership request latch | 0 | 0 | 1,086 | 0.00 | ||
| kss move lock | 23 | 0.00 | 0 | 0 | ||
| ksuosstats global area | 184 | 0.00 | 0 | 0 | ||
| ksv allocation latch | 105 | 0.00 | 0 | 0 | ||
| ksv class latch | 4,515 | 0.00 | 0 | 0 | ||
| ksv instance latch | 100 | 0.00 | 0 | 0 | ||
| ksv msg queue latch | 29 | 0.00 | 0 | 28 | 0.00 | |
| ksxp shared latch | 545 | 0.18 | 0.00 | 0 | 0 | |
| ksxp so latch | 545 | 0.00 | 0 | 0 | ||
| ksz_so allocation latch | 545 | 0.37 | 0.00 | 0 | 0 | |
| ktm global data | 23 | 0.00 | 0 | 0 | ||
| kwqbsn:qsga | 65 | 0.00 | 0 | 0 | ||
| lgwr LWN SCN | 61,426 | 0.02 | 0.00 | 0 | 0 | |
| list of block allocation | 8,862 | 0.02 | 0.00 | 0 | 0 | |
| loader state object freelist | 250 | 0.00 | 0 | 0 | ||
| lob segment dispenser latch | 1 | 0.00 | 0 | 0 | ||
| lob segment hash table latch | 7 | 0.00 | 0 | 0 | ||
| lob segment query latch | 1 | 0.00 | 0 | 0 | ||
| lock DBA buffer during media recovery | 1 | 0.00 | 0 | 0 | ||
| logical standby cache | 1 | 0.00 | 0 | 0 | ||
| logminer context allocation | 2 | 0.00 | 0 | 0 | ||
| logminer work area | 1 | 0.00 | 0 | 0 | ||
| longop free list parent | 46 | 0.00 | 0 | 45 | 0.00 | |
| managed standby latch | 48 | 0.00 | 0 | 0 | ||
| mapped buffers lru chain | 1 | 0.00 | 0 | 0 | ||
| message pool operations parent latch | 3,391 | 0.00 | 0 | 0 | ||
| messages | 754,677 | 0.17 | 0.00 | 0 | 0 | |
| mostly latch-free SCN | 61,854 | 0.64 | 0.01 | 0 | 0 | |
| msg queue latch | 1 | 0.00 | 0 | 0 | ||
| multiblock read objects | 276,984 | 0.00 | 0.00 | 0 | 0 | |
| name-service memory objects | 21,316 | 0.00 | 0 | 0 | ||
| name-service namespace bucket | 21,101 | 0.00 | 0 | 0 | ||
| name-service pending queue | 11,002 | 0.00 | 0 | 0 | ||
| name-service request | 16 | 0.00 | 0 | 0 | ||
| name-service request queue | 31,464 | 0.00 | 0 | 0 | ||
| ncodef allocation latch | 59 | 0.00 | 0 | 0 | ||
| object queue header heap | 417,453 | 0.00 | 0 | 11,622 | 0.00 | |
| object queue header operation | 2,370,003 | 0.02 | 0.01 | 0 | 0 | |
| object stats modification | 98 | 0.00 | 0 | 0 | ||
| parallel query alloc buffer | 1,068 | 0.00 | 0 | 0 | ||
| parallel query stats | 64 | 0.00 | 0 | 0 | ||
| parallel txn reco latch | 4,205 | 0.00 | 0 | 0 | ||
| parameter list | 1,885 | 0.05 | 0.00 | 0 | 0 | |
| parameter table management | 5,670 | 0.02 | 0.00 | 0 | 0 | |
| peshm | 1 | 0.00 | 0 | 0 | ||
| pesom_free_list | 1 | 0.00 | 0 | 0 | ||
| pesom_hash_node | 1 | 0.00 | 0 | 0 | ||
| policy information | 11,550 | 0.00 | 0 | 0 | ||
| post/wait queue | 192,525 | 0.01 | 0.00 | 0 | 158,196 | 0.01 |
| process allocation | 9,226 | 0.24 | 1.32 | 0 | 247 | 0.40 |
| process group creation | 545 | 0.37 | 0.00 | 0 | 0 | |
| process queue | 174 | 0.00 | 0 | 0 | ||
| process queue reference | 2,894 | 0.00 | 0 | 261 | 0.00 | |
| qmn state object latch | 3 | 0.00 | 0 | 0 | ||
| qmn task context latch | 1 | 0.00 | 0 | 0 | ||
| qmn task queue latch | 265 | 0.00 | 0 | 0 | ||
| query server freelists | 138 | 0.00 | 0 | 0 | ||
| query server process | 13 | 7.69 | 1.00 | 0 | 3 | 0.00 |
| queued dump request | 6 | 0.00 | 0 | 0 | ||
| queuing load statistics | 1 | 0.00 | 0 | 0 | ||
| recovery domain hash list | 1 | 0.00 | 0 | 0 | ||
| redo allocation | 246,669 | 0.05 | 0.01 | 0 | 548,073 | 0.18 |
| redo copy | 1 | 0.00 | 0 | 548,500 | 0.08 | |
| redo writing | 235,951 | 0.05 | 0.00 | 0 | 0 | |
| resmgr group change latch | 598 | 0.00 | 0 | 0 | ||
| resmgr:active threads | 1,207 | 0.00 | 0 | 0 | ||
| resmgr:actses change group | 564 | 0.00 | 0 | 0 | ||
| resmgr:actses change state | 1 | 0.00 | 0 | 0 | ||
| resmgr:free threads list | 1,206 | 0.58 | 0.00 | 0 | 0 | |
| resmgr:plan CPU method | 1 | 0.00 | 0 | 0 | ||
| resmgr:resource group CPU method | 1 | 0.00 | 0 | 0 | ||
| resmgr:schema config | 11 | 0.00 | 0 | 0 | ||
| resmgr:session queuing | 1 | 0.00 | 0 | 0 | ||
| rm cas latch | 1 | 0.00 | 0 | 0 | ||
| row cache objects | 23,750,009 | 0.23 | 0.00 | 0 | 801 | 0.37 |
| rules engine rule set statistics | 100 | 0.00 | 0 | 0 | ||
| second Audit Vault latch | 1 | 0.00 | 0 | 0 | ||
| second spare latch | 1 | 0.00 | 0 | 0 | ||
| sequence cache | 379,748 | 0.06 | 0.00 | 0 | 0 | |
| session allocation | 106,081 | 0.00 | 0 | 104,848 | 0.00 | |
| session idle bit | 8,769,680 | 0.00 | 0.00 | 0 | 0 | |
| session queue latch | 1 | 0.00 | 0 | 0 | ||
| session state list latch | 3,079 | 0.19 | 0.50 | 0 | 0 | |
| session switching | 358 | 0.56 | 0.00 | 0 | 0 | |
| session timer | 626 | 0.00 | 0 | 0 | ||
| shared pool | 6,219,663 | 0.10 | 0.20 | 0 | 0 | |
| shared pool sim alloc | 1 | 0.00 | 0 | 0 | ||
| shared pool simulator | 401,808 | 0.01 | 0.44 | 0 | 0 | |
| sim partition latch | 1 | 0.00 | 0 | 0 | ||
| simulator hash latch | 12,350,092 | 0.00 | 0.02 | 0 | 0 | |
| simulator lru latch | 1 | 0.00 | 0 | 11,932,363 | 0.19 | |
| sort extent pool | 254 | 0.39 | 0.00 | 0 | 0 | |
| space background state object latch | 2 | 0.00 | 0 | 0 | ||
| space background task latch | 2,182 | 0.09 | 0.00 | 0 | 1,202 | 0.00 |
| state object free list | 2 | 0.00 | 0 | 0 | ||
| statistics aggregation | 560 | 0.00 | 0 | 0 | ||
| tablespace key chain | 3 | 0.00 | 0 | 0 | ||
| temp lob duration state obj allocation | 18 | 5.56 | 0.00 | 0 | 0 | |
| temporary table state object allocation | 5 | 0.00 | 0 | 0 | ||
| test excl. parent l0 | 1 | 0.00 | 0 | 0 | ||
| test excl. parent2 l0 | 1 | 0.00 | 0 | 0 | ||
| third spare latch | 1 | 0.00 | 0 | 0 | ||
| threshold alerts latch | 195 | 0.00 | 0 | 0 | ||
| transaction allocation | 2,271,658 | 0.00 | 0.00 | 0 | 0 | |
| transaction branch allocation | 570,868 | 0.02 | 0.00 | 0 | 0 | |
| undo global data | 300,768 | 0.00 | 0.00 | 0 | 0 | |
| virtual circuit buffers | 1 | 0.00 | 0 | 0 | ||
| virtual circuit holder | 1 | 0.00 | 0 | 0 | ||
| virtual circuit queues | 1 | 0.00 | 0 | 0 |
| Latch Name | Get Requests | Misses | Sleeps | Spin Gets |
|---|---|---|---|---|
| cache buffers chains | 368,369,411 | 505,588 | 165 | 505,426 |
| gcs partitioned table hash | 16,940,325 | 68,451 | 1 | 68,452 |
| row cache objects | 23,750,009 | 55,692 | 31 | 55,661 |
| shared pool | 6,219,663 | 6,272 | 1,259 | 5,101 |
| gc element | 3,525,756 | 2,183 | 40 | 2,144 |
| ges value block free list | 1,172,599 | 1,320 | 8 | 1,312 |
| messages | 754,677 | 1,257 | 3 | 1,254 |
| ges resource hash list | 6,383,799 | 1,047 | 60 | 987 |
| ges group table | 3,129,099 | 766 | 1 | 765 |
| gcs opaque info freelist | 348,646 | 483 | 2 | 481 |
| gcs resource hash | 13,767,422 | 424 | 2 | 422 |
| mostly latch-free SCN | 61,854 | 396 | 2 | 394 |
| active service list | 2,277,901 | 377 | 5 | 372 |
| object queue header operation | 2,370,003 | 360 | 2 | 358 |
| active checkpoint queue latch | 51,977 | 284 | 1 | 283 |
| sequence cache | 379,748 | 246 | 1 | 245 |
| ges enqueue table freelist | 3,022,125 | 204 | 1 | 203 |
| ges caches resource lists | 519,866 | 167 | 5 | 162 |
| enqueue hash chains | 779,324 | 151 | 1 | 150 |
| redo allocation | 246,669 | 118 | 1 | 117 |
| Lsod array latch | 4,350 | 72 | 1 | 71 |
| simulator hash latch | 12,350,092 | 65 | 1 | 64 |
| call allocation | 3,654 | 33 | 21 | 12 |
| shared pool simulator | 401,808 | 25 | 11 | 16 |
| process allocation | 9,226 | 22 | 29 | 3 |
| session state list latch | 3,079 | 6 | 3 | 3 |
| ges process hash list | 111,447 | 3 | 3 | 0 |
| query server process | 13 | 1 | 1 | 0 |
| Latch Name | Where | NoWait Misses | Sleeps | Waiter Sleeps |
|---|---|---|---|---|
| Lsod array latch | kfklsodtablCleanup | 0 | 1 | 1 |
| active checkpoint queue latch | kcbbacq: scan active checkpoints | 0 | 1 | 1 |
| active service list | kswsite: service iterator | 0 | 6 | 0 |
| active service list | kswslogon: session logout | 0 | 2 | 1 |
| cache buffers chains | kcbgtcr: fast path | 0 | 38 | 16 |
| cache buffers chains | kcbgtcr: fast path (cr pin) | 0 | 38 | 10 |
| cache buffers chains | kcbget: fast exchange | 0 | 30 | 21 |
| cache buffers chains | kcbrls: fast release | 0 | 25 | 12 |
| cache buffers chains | kcbchg1: mod cr pin | 0 | 23 | 12 |
| cache buffers chains | kcbgcur_2 | 0 | 8 | 3 |
| cache buffers chains | kcbgcur_4 | 0 | 5 | 1 |
| cache buffers chains | kcbzwb | 0 | 4 | 4 |
| cache buffers chains | kcbget: pin buffer | 0 | 3 | 1 |
| cache buffers chains | kcbgtcr_2 | 0 | 3 | 20 |
| cache buffers chains | kcbget: fast path | 0 | 2 | 0 |
| cache buffers chains | kcbgtcr: kslbegin excl | 0 | 2 | 13 |
| cache buffers chains | kcbgtcr: kslbegin shared | 0 | 2 | 2 |
| cache buffers chains | kclbla | 0 | 2 | 1 |
| cache buffers chains | kcllkopesc | 0 | 2 | 0 |
| cache buffers chains | kcbget: upgrade latch | 0 | 1 | 4 |
| cache buffers chains | kcbzar_fpin_1 | 0 | 1 | 22 |
| cache buffers chains | kcbzib: finish processing buffer | 0 | 1 | 1 |
| cache buffers chains | kcbzibmlt: multi-block read: nowait | 0 | 1 | 0 |
| cache buffers chains | kclcls_3 | 0 | 1 | 8 |
| cache buffers chains | kclcqchk | 0 | 1 | 0 |
| cache buffers chains | kclwrt | 0 | 1 | 0 |
| call allocation | ksuxds | 0 | 21 | 18 |
| enqueue hash chains | ksqrcl | 0 | 1 | 1 |
| gc element | kclollnumiter_4 | 0 | 17 | 0 |
| gc element | kclnfndnewm | 0 | 14 | 6 |
| gc element | kclbla | 0 | 9 | 0 |
| gc element | kclrwrite | 0 | 3 | 5 |
| gc element | KCLUNLNK | 0 | 2 | 8 |
| gc element | kclplz | 0 | 2 | 4 |
| gc element | kclplz_1 | 0 | 1 | 1 |
| gc element | kclulb | 0 | 1 | 11 |
| gc element | kclwrt | 0 | 1 | 1 |
| gcs opaque info freelist | kjbrcvt save opaque info | 0 | 1 | 1 |
| gcs opaque info freelist | kjbrinfofree free opaque info | 0 | 1 | 1 |
| gcs partitioned table hash | kjdrchkdrm find pt | 0 | 1 | 0 |
| gcs resource hash | kjbassume | 0 | 1 | 0 |
| gcs resource hash | kjbmdowncvt | 0 | 1 | 0 |
| ges enqueue table freelist | kjlfr: remove lock from parent object | 0 | 1 | 1 |
| ges group table | kjgagll: move a lock from process lock list to group lock list | 0 | 1 | 0 |
| ges process hash list | kjakiqa: set inquiry response | 0 | 3 | 0 |
| ges resource hash list | kjakcai: search for resp by resname | 0 | 45 | 0 |
| ges resource hash list | kjrmas1: lookup master node | 0 | 10 | 2 |
| ges resource hash list | kjlmfnd: search for lockp by rename and inst id | 0 | 3 | 0 |
| ges resource hash list | kjakoca: search for resp by resname | 0 | 1 | 45 |
| ges resource hash list | kjlrlr: remove lock from resource queue | 0 | 1 | 2 |
| ges resource table freelist | kjruch: cached obj cleanup | 0 | 3 | 0 |
| ges resource table freelist | kjchc: clean resource cache | 0 | 2 | 0 |
| ges value block free list | kjvblkgrow: allocation | 0 | 7 | 2 |
| ges value block free list | kjvblkfr: free | 0 | 1 | 6 |
| lgwr LWN SCN | kcs023 | 0 | 2 | 0 |
| messages | ksarcv | 0 | 2 | 0 |
| messages | ksarcr | 0 | 1 | 0 |
| object queue header operation | kcbo_link_q | 0 | 1 | 0 |
| object queue header operation | kcbo_service_ockpt | 0 | 1 | 21 |
| object queue header operation | kcbo_switch_mq_bg | 0 | 1 | 1 |
| process allocation | ksucrp:1 | 0 | 19 | 0 |
| process allocation | ksuapc | 0 | 8 | 29 |
| process allocation | ksudlp | 0 | 2 | 0 |
| query server process | kxfpcrer | 0 | 1 | 0 |
| redo allocation | kcrfw_redo_gen: redo allocation 1 | 0 | 1 | 0 |
| row cache objects | kqreqd: reget | 0 | 16 | 1 |
| row cache objects | kqrpre: find obj | 0 | 9 | 24 |
| row cache objects | kqrso | 0 | 6 | 0 |
| sequence cache | kdnnxt: cached seq | 0 | 1 | 0 |
| session state list latch | kpseqd | 0 | 3 | 1 |
| shared pool | kghalo | 0 | 1,013 | 516 |
| shared pool | kghalp | 0 | 180 | 303 |
| shared pool | kghupr1 | 0 | 28 | 402 |
| shared pool | kgh_heap_sizes | 0 | 19 | 25 |
| shared pool | kghasp | 0 | 10 | 4 |
| shared pool | kghfre | 0 | 9 | 8 |
| shared pool simulator | kglsim_upd_newhp | 0 | 11 | 5 |
| simulator hash latch | kcbsacc: lookup dba | 0 | 1 | 1 |
| Mutex Type | Location | Sleeps | Wait Time (ms) |
|---|---|---|---|
| Library Cache | kgllkdl1 85 | 123 | 0 |
| Cursor Pin | kkslce [KKSCHLPIN2] | 117 | 0 |
| Library Cache | kglget1 1 | 105 | 0 |
| Library Cache | kglpnal2 91 | 59 | 0 |
| Library Cache | kgldtin1 42 | 56 | 0 |
| Library Cache | kglhdgn2 106 | 50 | 0 |
| Library Cache | kglpin1 4 | 43 | 0 |
| Library Cache | kglpndl1 95 | 37 | 0 |
| Library Cache | kglhdgn1 62 | 32 | 0 |
| Library Cache | kglpnal1 90 | 20 | 0 |
| Library Cache | kglget2 2 | 18 | 0 |
| Library Cache | kglobpn1 71 | 18 | 0 |
| Library Cache | kglrfcl1 79 | 18 | 0 |
| Library Cache | kgllkc1 57 | 15 | 0 |
| Library Cache | kgllkal1 80 | 14 | 0 |
| Library Cache | kglhdgh1 64 | 9 | 0 |
| Library Cache | kglini1 32 | 1 | 0 |
| Cursor Parent | kkscsAddChildNode [KKSPRTLOC34] | 1 | 0 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Logical Reads | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 57,815,968 | 28.30 | |
| BPPF_BIS | BPPF_BIS_DAT_A01 | T_SYM_OPERLOG | TABLE | 30,561,296 | 14.96 | |
| BPPF_BIS | BPPF_BIS_DAT_B01 | T_OPP_PREORDER | TABLE | 14,572,624 | 7.13 | |
| BPPF_BIS | BPPF_BIS_DAT_B01 | T_CUM_INFO | TABLE | 10,343,184 | 5.06 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_DEALLOG | TABLE | 10,200,448 | 4.99 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 4,122,747 | 56.41 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 2,520,880 | 34.49 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_INVOICE | TABLE | 594,240 | 8.13 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDFEE | TABLE | 37,275 | 0.51 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_DEALLOG | TABLE | 7,612 | 0.10 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Read Requests | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 107,884 | 63.24 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 33,032 | 19.36 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_DEALLOG | TABLE | 6,870 | 4.03 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_INVOICE | TABLE | 4,772 | 2.80 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDFEE | TABLE | 2,067 | 1.21 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | UnOptimized Reads | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 107,884 | 63.24 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 33,032 | 19.36 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_DEALLOG | TABLE | 6,870 | 4.03 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_INVOICE | TABLE | 4,772 | 2.80 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDFEE | TABLE | 2,067 | 1.21 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Reads | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 4,122,400 | 60.09 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 2,141,812 | 31.22 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_INVOICE | TABLE | 594,202 | 8.66 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Writes | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 4,382 | 6.40 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ORDER_FULLQUERY | INDEX | 4,180 | 6.10 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_EBK_DEALLOG_ACCTCODE | INDEX | 2,386 | 3.48 | |
| BPPF_BIS | BPPF_BIS_DAT_A01 | T_SYM_STAFF | TABLE | 2,275 | 3.32 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_PAYMENT_ACCTCODE | INDEX | 1,988 | 2.90 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Phys Write Requests | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ORDER_FULLQUERY | INDEX | 4,153 | 9.13 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_EBK_DEALLOG_ACCTCODE | INDEX | 2,251 | 4.95 | |
| BPPF_BIS | BPPF_BIS_DAT_A01 | T_SYM_STAFF | TABLE | 2,153 | 4.73 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_PAYMENT_ACCTCODE | INDEX | 1,980 | 4.35 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 1,928 | 4.24 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Direct Writes | %Total |
|---|---|---|---|---|---|---|
| SYS | SYSAUX | WRH$_ACTIVE_SESSION_HISTORY | WRH$_ACTIVE_1195271196_23752 | TABLE PARTITION | 124 | 1.26 |
| SYS | SYSAUX | SYS_LOB0000006339C00038$$ | LOB | 60 | 0.61 | |
| SYS | SYSAUX | SYS_LOB0000006331C00004$$ | LOB | 2 | 0.02 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Table Scans | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 38 | 0.98 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 5 | 0.13 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_INVOICE | TABLE | 1 | 0.03 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | DB Block Changes | % of Capture |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 29,472 | 8.40 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ORDER_FULLQUERY | INDEX | 18,608 | 5.31 | |
| BPPF_BIS | BPPF_BIS_IDX_A01 | T_SYM_SCRAND_PK | INDEX | 17,856 | 5.09 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTATTR_ACTLISTID | INDEX | 14,256 | 4.06 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | PK_T_SCS_ACT_ATTR | INDEX | 13,280 | 3.79 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Row Lock Waits | % of Capture |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_ACCTINFO | TABLE | 42 | 20.29 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_EBK_DEALLOG_EVENTSEQ | INDEX | 36 | 17.39 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTATTR_ACTLISTID | INDEX | 20 | 9.66 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTFEE_ORDERID | INDEX | 14 | 6.76 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IDX_EBKDEALLOG_ORDERID | INDEX | 12 | 5.80 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | ITL Waits | % of Capture |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_IDX_B01 | IDX_EBKDEALLOG_ORDERID | INDEX | 4 | 50.00 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_EBK_DEALLOG_RECORDDATE | INDEX | 4 | 50.00 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Buffer Busy Waits | % of Capture |
|---|---|---|---|---|---|---|
| BPPF_BIS | BPPF_BIS_IDX_A01 | T_SYM_SCRAND_PK | INDEX | 54 | 29.83 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTATTR_ACTLISTID | INDEX | 17 | 9.39 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | PK_T_SCS_ACT_ATTR | INDEX | 16 | 8.84 | |
| BPPF_BIS | BPPF_BIS_IDX_B01 | PK_T_INF_DCOPERLOG | INDEX | 9 | 4.97 | |
| BPPF_BIS | BPPF_BIS_DAT_A01 | T_SYM_SCRAND | TABLE | 7 | 3.87 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | GC Buffer Busy | % of Capture |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_IDX_B01 | PK_T_SCS_ORDER | INDEX | 102 | 14.96 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ORDFEE_ORDERID | INDEX | 38 | 5.57 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_ACCTINFO | TABLE | 37 | 5.43 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTFEE_ORDERID | INDEX | 33 | 4.84 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_PAYMENT_ORDERID | INDEX | 30 | 4.40 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | CR Blocks Received | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_IDX_B01 | PK_T_SCS_ORDER | INDEX | 4,203 | 8.85 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 4,121 | 8.68 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_EBK_ACCTINFO | TABLE | 3,915 | 8.25 | |
| BPPF_BIS | BPPF_BIS_DAT_A01 | T_SYM_CER | TABLE | 1,485 | 3.13 | |
| BPPF_GOS | BPPF_BIS_DAT_B01 | T_RSK_REFER | TABLE | 1,380 | 2.91 |
| Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Current Blocks Received | %Total |
|---|---|---|---|---|---|---|
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ORDER | TABLE | 45,979 | 37.74 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ORDER_FULLQUERY | INDEX | 3,630 | 2.98 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | IX_SCS_ACTLIST_VRF | INDEX | 3,531 | 2.90 | |
| BPPF_EAS | BPPF_EAS_DAT_B01 | T_SCS_ACTLIST | TABLE | 3,065 | 2.52 | |
| BPPF_EAS | BPPF_EAS_IDX_B01 | PK_T_SCS_ORDER | INDEX | 2,003 | 1.64 |
| Cache | Get Requests | Pct Miss | Scan Reqs | Pct Miss | Mod Reqs | Final Usage |
|---|---|---|---|---|---|---|
| dc_awr_control | 34 | 0.00 | 0 | 2 | 1 | |
| dc_constraints | 28 | 50.00 | 0 | 28 | 1 | |
| dc_files | 714 | 0.00 | 0 | 0 | 119 | |
| dc_global_oids | 2,258 | 0.49 | 0 | 0 | 31 | |
| dc_histogram_data | 2,389,418 | 0.04 | 0 | 0 | 3,001 | |
| dc_histogram_defs | 3,002,862 | 0.10 | 0 | 4 | 2,682 | |
| dc_object_grants | 27 | 0.00 | 0 | 0 | 7 | |
| dc_objects | 2,291,128 | 0.03 | 0 | 8 | 1,409 | |
| dc_profiles | 974 | 0.00 | 0 | 0 | 3 | |
| dc_rollback_segments | 78,488 | 0.00 | 0 | 0 | 843 | |
| dc_segments | 959,041 | 0.07 | 0 | 5 | 893 | |
| dc_sequences | 208 | 51.92 | 0 | 208 | 21 | |
| dc_tablespaces | 184,309 | 0.00 | 0 | 0 | 29 | |
| dc_users | 596,140 | 0.00 | 0 | 0 | 105 | |
| global database name | 2,889 | 0.00 | 0 | 0 | 1 | |
| outstanding_alerts | 77 | 100.00 | 0 | 0 | 25 | |
| sch_lj_oids | 3 | 100.00 | 0 | 0 | 1 |
| Cache | GES Requests | GES Conflicts | GES Releases |
|---|---|---|---|
| dc_awr_control | 4 | 0 | 0 |
| dc_constraints | 56 | 0 | 14 |
| dc_global_oids | 11 | 0 | 14 |
| dc_histogram_defs | 2,865 | 0 | 2,817 |
| dc_objects | 206 | 3 | 373 |
| dc_segments | 646 | 1 | 628 |
| dc_sequences | 416 | 99 | 7 |
| dc_users | 5 | 0 | 4 |
| outstanding_alerts | 152 | 0 | 77 |
| sch_lj_oids | 3 | 0 | 2 |
| Namespace | Get Requests | Pct Miss | Pin Requests | Pct Miss | Reloads | Invali- dations |
|---|---|---|---|---|---|---|
| ACCOUNT_STATUS | 370 | 0.81 | 0 | 0 | 0 | |
| APP CONTEXT | 525 | 0.00 | 1,639 | 0.00 | 0 | 0 |
| BODY | 4,116 | 0.49 | 4,753 | 0.50 | 3 | 0 |
| CLUSTER | 83 | 1.20 | 83 | 1.20 | 0 | 0 |
| DBLINK | 1,729 | 0.52 | 0 | 0 | 0 | |
| EDITION | 534 | 0.00 | 1,021 | 0.00 | 0 | 0 |
| INDEX | 134 | 17.91 | 134 | 17.91 | 0 | 0 |
| OBJECT ID | 3 | 100.00 | 0 | 0 | 0 | |
| QUEUE | 513 | 0.19 | 543 | 0.18 | 0 | 0 |
| SCHEMA | 859 | 0.00 | 0 | 0 | 0 | |
| SQL AREA | 494,180 | 18.66 | 1,833,348 | 16.65 | 7,546 | 13 |
| SQL AREA BUILD | 105,264 | 94.19 | 0 | 0 | 0 | |
| SQL AREA STATS | 104,737 | 91.86 | 104,739 | 91.86 | 0 | 0 |
| TABLE/PROCEDURE | 160,828 | 0.12 | 856,865 | 0.18 | 914 | 0 |
| TRANSFORMATION | 180 | 0.00 | 180 | 0.00 | 0 | 0 |
| TRIGGER | 72 | 1.39 | 72 | 1.39 | 0 | 0 |
| Namespace | GES Lock Requests | GES Pin Requests | GES Pin Releases | GES Inval Requests | GES Invali- dations |
|---|---|---|---|---|---|
| ACCOUNT_STATUS | 370 | 0 | 0 | 0 | 0 |
| BODY | 0 | 4,752 | 4,752 | 0 | 0 |
| CLUSTER | 83 | 83 | 83 | 0 | 0 |
| DBLINK | 1,729 | 0 | 0 | 0 | 0 |
| EDITION | 534 | 534 | 534 | 0 | 0 |
| INDEX | 134 | 134 | 134 | 0 | 0 |
| QUEUE | 258 | 543 | 543 | 0 | 0 |
| SCHEMA | 490 | 0 | 0 | 0 | 0 |
| TABLE/PROCEDURE | 245,030 | 474,776 | 474,776 | 0 | 0 |
| TRANSFORMATION | 180 | 180 | 180 | 0 | 0 |
| TRIGGER | 0 | 72 | 72 | 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 | 49,408.00 | 49,408.00 | 49,408.00 | 49,408.00 | 0 | INI/ |
| KEEP buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| PGA Target | 42,240.00 | 42,240.00 | 42,240.00 | 42,240.00 | 0 | STA/ |
| RECYCLE buffer cache | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| SGA Target | 60,160.00 | 60,160.00 | 60,160.00 | 60,160.00 | 0 | STA/ |
| Shared IO Pool | 0.00 | 0.00 | 0.00 | 0.00 | 0 | STA/ |
| java pool | 256.00 | 256.00 | 256.00 | 256.00 | 0 | STA/ |
| large pool | 256.00 | 256.00 | 256.00 | 256.00 | 0 | STA/ |
| shared pool | 9,472.00 | 9,472.00 | 9,472.00 | 9,472.00 | 0 | STA/ |
| streams pool | 256.00 | 256.00 | 256.00 | 256.00 | 0 | STA/ |
| Category | Alloc (MB) | Used (MB) | Avg Alloc (MB) | Std Dev Alloc (MB) | Max Alloc (MB) | Hist Max Alloc (MB) | Num Proc | Num Alloc | |
|---|---|---|---|---|---|---|---|---|---|
| B | Other | 1,223.03 | 3.65 | 4.78 | 44 | 44 | 335 | 335 | |
B | Freeable | 179.56 | 0.00 | 0.76 | 0.81 | 10 | 237 | 237 | |
B | PL/SQL | 27.98 | 16.50 | 0.08 | 0.04 | 0 | 0 | 333 | 331 |
B | SQL | 7.78 | 4.17 | 0.03 | 0.21 | 4 | 201 | 295 | 285 |
| E | Other | 1,051.81 | 3.68 | 5.14 | 44 | 44 | 286 | 286 | |
E | Freeable | 165.25 | 0.00 | 0.77 | 0.85 | 10 | 216 | 216 | |
E | PL/SQL | 23.00 | 13.76 | 0.08 | 0.04 | 0 | 0 | 284 | 283 |
E | SQL | 3.95 | 0.51 | 0.02 | 0.02 | 0 | 201 | 248 | 239 |
| SGA regions | Begin Size (Bytes) | End Size (Bytes) (if different) |
|---|---|---|
| Database Buffers | 51,808,043,008 | |
| Fixed Size | 2,240,984 | |
| Redo Buffers | 55,267,328 | |
| Variable Size | 55,029,272,104 |
| Pool | Name | Begin MB | End MB | % Diff |
|---|---|---|---|---|
| java | free memory | 256.00 | 256.00 | 0.00 |
| large | PX msg pool | 7.81 | 7.81 | 0.00 |
| large | free memory | 247.81 | 247.81 | 0.00 |
| shared | ASH buffers | 96.00 | 96.00 | 0.00 |
| shared | KGLH0 | 1,325.71 | 1,346.35 | 1.56 |
| shared | KGLHD | 191.11 | 193.78 | 1.39 |
| shared | SQLA | 1,808.63 | 1,817.79 | 0.51 |
| shared | db_block_hash_buckets | 356.00 | 356.00 | 0.00 |
| shared | free memory | 2,639.25 | 2,611.74 | -1.04 |
| shared | gc name table | 144.00 | 144.00 | 0.00 |
| shared | gcs resources | 1,293.39 | 1,293.39 | 0.00 |
| shared | gcs shadows | 754.48 | 754.48 | 0.00 |
| shared | kglsim object batch | 97.51 | 97.51 | 0.00 |
| streams | free memory | 256.00 | 256.00 | 0.00 |
| buffer_cache | 49,408.00 | 49,408.00 | 0.00 | |
| fixed_sga | 2.14 | 2.14 | 0.00 | |
| log_buffer | 52.71 | 52.71 | 0.00 |
| Session Type | First Logon | CPU time(s) | User IO Wait time(s) | SYS IO Wait time(s) |
|---|---|---|---|---|
| QMON Slaves | 0304 18:07:40 | 0.17 | 0.00 | 0.00 |
| QMON Coordinator | 0304 18:07:39 | 0.07 | 0.00 | 0.00 |
| Queue Name | Enq Msgs | Deq Msgs | %Exp Msgs | %Delay Msgs | Enq Time(s) | Deq Time(s) | %Transf Time | %Eval Time |
|---|---|---|---|---|---|---|---|---|
| SYS.ALERT_QUE(12733) | 0 | 0 | 0.00 | 0.00 | ||||
| SYS.AQ$_ALERT_QT_E(12732) | 0 | 0 | 0.00 | 0.00 | ||||
| SYSMAN.MGMT_TASK_Q(69070) | 0 | 0 | 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 | ||
| SYS.AQ$_ALERT_QT_E(12732) | 0.00 | 0.00 | ||
| SYSMAN.MGMT_TASK_Q(69070) | 0.00 | 0.00 |
| Subscriber/Queue | Enqueue Msgs | Dequeue Msgs | Expire Msgs | Enqueue Msgs/sec | Dequeue Msgs/sec | Expire Msgs/sec |
|---|---|---|---|---|---|---|
| BPPFEDB1_3938_BPPFEDB1(22)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| BPPFEDB2_3938_BPPFEDB2(42)/SYS.ALERT_QUE | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 |
| HAE_SUB(1)/SYS.ALERT_QUE | 0 | 0 | 0 |
| 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 % |
|---|---|---|---|---|
| 1,804 | 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 | 1,804 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 1,804 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 1,804 | 0.00 | 100.00 | 0 | 0 | |
| D000 | 0.00 | 1,804 | 0.00 | 100.00 | 0 | 0 | |
| Sum | 0.00 | 0 | 0 | ||||
| Avg | 0.00 | 0.00 | 100.00 | 0 | 0 | ||
| Std | 0.00 | 0.00 | 0.00 | 0 | 0 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| audit_file_dest | /oracle/app/oracle/admin/bppfedb/adump | |
| audit_trail | NONE | |
| cluster_database | TRUE | |
| compatible | 11.2.0.0.0 | |
| control_files | +DATA/bppfedb/controlfile/current.256.785359263, +FRA/bppfedb/controlfile/current.256.785359265 | |
| db_block_size | 8192 | |
| db_create_file_dest | +DATA | |
| db_domain | ||
| db_name | bppfedb | |
| db_recovery_file_dest | +FRA | |
| db_recovery_file_dest_size | 161061273600 | |
| diagnostic_dest | /oracle/app/oracle | |
| dispatchers | (PROTOCOL=TCP) (SERVICE=bppfedbXDB) | |
| instance_number | 1 | |
| job_queue_processes | 1000 | |
| local_listener | (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=132.97.122.3)(PORT=1521)))) | |
| memory_max_target | 107374182400 | |
| memory_target | 107374182400 | |
| open_cursors | 300 | |
| processes | 2000 | |
| remote_listener | (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=132.97.122.5)(PORT=1523))) | |
| remote_login_passwordfile | NONE | |
| sessions | 3024 | |
| spfile | +DATA/bppfedb/spfilebppfedb.ora | |
| thread | 1 | |
| undo_tablespace | UNDOTBS1 |
| Parameter Name | Begin value | End value (if different) |
|---|---|---|
| control_files | +DATA/bppfedb/controlfile/current.256.785359263 | |
control_files | +FRA/bppfedb/controlfile/current.256.785359265 |
| Statistic | Total | per Second | per Trans |
|---|---|---|---|
| acks for commit broadcast(actual) | 32,488 | 18.01 | 0.53 |
| acks for commit broadcast(logical) | 35,441 | 19.65 | 0.58 |
| broadcast msgs on commit(actual) | 58,711 | 32.55 | 0.95 |
| broadcast msgs on commit(logical) | 60,961 | 33.79 | 0.99 |
| broadcast msgs on commit(wasted) | 3,218 | 1.78 | 0.05 |
| dynamically allocated gcs resources | 0 | 0.00 | 0.00 |
| dynamically allocated gcs shadows | 0 | 0.00 | 0.00 |
| flow control messages received | 0 | 0.00 | 0.00 |
| flow control messages sent | 18 | 0.01 | 0.00 |
| gcs apply delta | 0 | 0.00 | 0.00 |
| gcs assume cvt | 0 | 0.00 | 0.00 |
| gcs assume no cvt | 106,724 | 59.16 | 1.74 |
| gcs ast xid | 35 | 0.02 | 0.00 |
| gcs blocked converts | 98,091 | 54.38 | 1.59 |
| gcs blocked cr converts | 52,093 | 28.88 | 0.85 |
| gcs compatible basts | 990 | 0.55 | 0.02 |
| gcs compatible cr basts (global) | 8,549 | 4.74 | 0.14 |
| gcs compatible cr basts (local) | 76,539 | 42.43 | 1.24 |
| 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 | 6,960 | 3.86 | 0.11 |
| gcs dbwr write request msgs | 4,939 | 2.74 | 0.08 |
| gcs delta msgs sent | 0 | 0.00 | 0.00 |
| gcs delta push aborted by cancel | 0 | 0.00 | 0.00 |
| gcs delta push aborted by remastering | 0 | 0.00 | 0.00 |
| gcs delta push cancelled | 0 | 0.00 | 0.00 |
| gcs delta push cancelled at master | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by close | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by consign | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by cvt ping | 0 | 0.00 | 0.00 |
| gcs delta push cancelled by dwncvt | 0 | 0.00 | 0.00 |
| gcs delta push create pi | 0 | 0.00 | 0.00 |
| gcs delta update master msgs sent | 0 | 0.00 | 0.00 |
| gcs delta wait aborted by remastering | 0 | 0.00 | 0.00 |
| gcs delta wait cancelled | 0 | 0.00 | 0.00 |
| gcs error msgs | 0 | 0.00 | 0.00 |
| gcs force cr block only | 44 | 0.02 | 0.00 |
| gcs force cr grant | 208 | 0.12 | 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 | 3,491 | 1.94 | 0.06 |
| gcs immediate (null) converts | 24,307 | 13.47 | 0.40 |
| gcs immediate cr (compatible) converts | 9,976 | 5.53 | 0.16 |
| gcs immediate cr (null) converts | 2,294 | 1.27 | 0.04 |
| gcs indirect ast | 21,508 | 11.92 | 0.35 |
| gcs indirect bidless ast | 716 | 0.40 | 0.01 |
| gcs indirect fg ast | 20,792 | 11.53 | 0.34 |
| gcs lms flush pi msgs | 0 | 0.00 | 0.00 |
| gcs lms write request msgs | 1,887 | 1.05 | 0.03 |
| gcs msgs process time(ms) | 34,551 | 19.15 | 0.56 |
| gcs msgs received | 1,736,819 | 962.81 | 28.24 |
| gcs new served by master | 324 | 0.18 | 0.01 |
| gcs out-of-order msgs | 3 | 0.00 | 0.00 |
| gcs pings refused | 171 | 0.09 | 0.00 |
| gcs pkey conflicts retry | 0 | 0.00 | 0.00 |
| gcs push delta | 0 | 0.00 | 0.00 |
| gcs queued converts | 21 | 0.01 | 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 | 27 | 0.01 | 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 | 13,640 | 7.56 | 0.22 |
| gcs side channel msgs logical | 206,881 | 114.68 | 3.36 |
| gcs stale cr | 506 | 0.28 | 0.01 |
| gcs undo cr | 2,315 | 1.28 | 0.04 |
| gcs write notification msgs | 860 | 0.48 | 0.01 |
| gcs writes refused | 244 | 0.14 | 0.00 |
| ges msgs process time(ms) | 2,559 | 1.42 | 0.04 |
| ges msgs received | 102,844 | 57.01 | 1.67 |
| global posts dropped | 0 | 0.00 | 0.00 |
| global posts queue time | 0 | 0.00 | 0.00 |
| global posts queued | 0 | 0.00 | 0.00 |
| global posts requested | 0 | 0.00 | 0.00 |
| global posts sent | 0 | 0.00 | 0.00 |
| implicit batch messages received | 17,010 | 9.43 | 0.28 |
| implicit batch messages sent | 32,819 | 18.19 | 0.53 |
| lmd msg send time(ms) | 471 | 0.26 | 0.01 |
| lms(s) msg send time(ms) | 0 | 0.00 | 0.00 |
| messages flow controlled | 2,881 | 1.60 | 0.05 |
| messages queue sent actual | 137,583 | 76.27 | 2.24 |
| messages queue sent logical | 212,111 | 117.58 | 3.45 |
| messages received actual | 603,683 | 334.65 | 9.81 |
| messages received logical | 1,839,800 | 1,019.90 | 29.91 |
| messages sent directly | 323,091 | 179.11 | 5.25 |
| messages sent indirectly | 287,298 | 159.26 | 4.67 |
| messages sent not implicit batched | 32 | 0.02 | 0.00 |
| messages sent pbatched | 367,195 | 203.56 | 5.97 |
| msgs causing lmd to send msgs | 50,650 | 28.08 | 0.82 |
| msgs causing lms(s) to send msgs | 18,479 | 10.24 | 0.30 |
| msgs received queue time (ms) | 692,995 | 384.16 | 11.27 |
| msgs received queued | 1,839,817 | 1,019.91 | 29.91 |
| msgs sent queue time (ms) | 23,372 | 12.96 | 0.38 |
| msgs sent queue time on ksxp (ms) | 253,941 | 140.77 | 4.13 |
| msgs sent queued | 314,912 | 174.57 | 5.12 |
| msgs sent queued on ksxp | 529,051 | 293.28 | 8.60 |
| number of broadcasted resources | 0 | 0.00 | 0.00 |
| number of ges deadlock detected | 0 | 0.00 | 0.00 |
| process batch messages received | 155,721 | 86.32 | 2.53 |
| process batch messages sent | 112,649 | 62.45 | 1.83 |
| Statistic | Total |
|---|---|
| CR Block Requests | 40,605 |
| CURRENT Block Requests | 11,293 |
| Data Block Requests | 40,605 |
| Undo Block Requests | 1,466 |
| TX Block Requests | 5,409 |
| Current Results | 47,659 |
| Private results | 1,433 |
| Zero Results | 2,300 |
| Disk Read Results | 506 |
| Fail Results | 0 |
| Fairness Down Converts | 18,882 |
| Fairness Clears | 4,190 |
| Free GC Elements | 0 |
| Flushes | 4,745 |
| Flushes Queued | 0 |
| Flush Queue Full | 0 |
| Flush Max Time (us) | 0 |
| Light Works | 3,183 |
| Errors | 0 |
| Statistic | Total | % <1ms | % <10ms | % <100ms | % <1s | % <10s |
|---|---|---|---|---|---|---|
| Pins | 452 | 0.66 | 57.30 | 42.04 | 0.00 | 0.00 |
| Flushes | 1,618 | 51.67 | 44.44 | 3.83 | 0.06 | 0.00 |
| Writes | 5,905 | 53.01 | 41.54 | 1.05 | 0.25 | 4.15 |
| CR | Current | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | Blocks Received | % Immed | % Busy | % Congst | Blocks Received | % Immed | % Busy | % Congst |
| 2 | data block | 31,595 | 84.24 | 14.16 | 1.60 | 119,195 | 96.08 | 2.07 | 1.84 |
| 2 | undo header | 9,942 | 96.16 | 2.14 | 1.70 | 415 | 97.35 | 0.72 | 1.93 |
| 2 | Others | 3,963 | 98.49 | 0.03 | 1.49 | 2,208 | 98.28 | 0.14 | 1.59 |
| 2 | undo block | 1,913 | 83.59 | 14.90 | 1.52 | 0 |
| CR Avg Time (ms) | Current Avg Time (ms) | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Inst No | Block Class | All | Immed | Busy | Congst | All | Immed | Busy | Congst |
| 2 | data block | 0.79 | 0.50 | 2.58 | 0.52 | 0.57 | 0.49 | 3.95 | 0.66 |
| 2 | undo header | 0.45 | 0.39 | 3.28 | 0.40 | 0.49 | 0.48 | 1.84 | 0.46 |
| 2 | others | 0.58 | 0.57 | 1.59 | 1.07 | 0.49 | 0.49 | 4.12 | 0.47 |
| 2 | undo block | 0.67 | 0.44 | 1.97 | 0.45 |
| CR | Current | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Blocks Lost | Immed Blks Received | % 2hop | % 3hop | Immed Blks Received | % 2hop | % 3hop |
| 2 | data block | 0 | 26,616 | 100.00 | 0.00 | 114,523 | 100.00 | 0.00 |
| 2 | undo header | 0 | 9,560 | 100.00 | 0.00 | 404 | 100.00 | 0.00 |
| 2 | others | 0 | 3,903 | 100.00 | 0.00 | 2,170 | 100.00 | 0.00 |
| 2 | undo block | 0 | 1,599 | 100.00 | 0.00 | 0 |
| CR Avg Time (ms) | Current Avg Time (ms) | |||||||
|---|---|---|---|---|---|---|---|---|
| Src Inst# | Block Class | Lost Time | Immed | 2hop | 3hop | Immed | 2hop | 3hop |
| 2 | data block | 0.50 | 0.50 | 0.49 | 0.49 | |||
| 2 | undo header | 0.39 | 0.39 | 0.48 | 0.48 | |||
| 2 | others | 0.57 | 0.57 | 0.49 | 0.49 | |||
| 2 | undo block | 0.44 | 0.44 |
| Target Instance | 500B Ping Count | Avg Latency 500B msg | Stddev 500B msg | 8K Ping Count | Avg Latency 8K msg | Stddev 8K msg |
|---|---|---|---|---|---|---|
| 1 | 142 | 0.25 | 0.09 | 142 | 0.23 | 0.08 |
| 2 | 142 | 0.37 | 0.10 | 142 | 0.50 | 0.13 |
| Used By | Send Mbytes/sec | Receive Mbytes/sec |
|---|---|---|
| Global Cache | 1.10 | 0.63 |
| Parallel Query | 0.00 | 0.00 |
| DB Locks | 0.14 | 0.19 |
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| bond1:1 | 169.254.10.248 | NO | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0 | 0 | 0 | 0 |
| Name | Total | per Remaster Op | Begin Snap | End Snap |
|---|---|---|---|---|
| remaster ops | 1 | 1.00 | ||
| remastered objects | 1 | 1.00 | ||
| replayed locks received | 944,924 | 944,924.00 | ||
| replayed locks sent | 0 | 0.00 | ||
| resources cleaned | 0 | 0.00 | ||
| remaster time (s) | 13.6 | 13.61 | ||
| quiesce time (s) | 1.2 | 1.15 | ||
| freeze time (s) | 0.0 | 0.04 | ||
| cleanup time (s) | 0.3 | 0.27 | ||
| replay time (s) | 1.4 | 1.44 | ||
| fixwrite time (s) | 1.7 | 1.69 | ||
| sync time (s) | 9.0 | 9.02 | ||
| affinity objects | 138 | 139 |