| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| tesss | 2357990674 | madock | 2 | 02-Jan-16 21:01 | 11.2.0.3.0 | YES |
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| jjjjj | Linux x86 64-bit | 24 | 12 | 2 | 47.25 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 35154 | 16-Feb-16 12:00:11 | 360 | 8.6 |
| End Snap: | 35155 | 16-Feb-16 13:00:14 | 360 | 4.8 |
| Elapsed: | 60.06 (mins) | |||
| DB Time: | 368.85 (mins) |
| Begin | End | |||
|---|---|---|---|---|
| Buffer Cache: | 8,448M | 8,448M | Std Block Size: | 8K |
| Shared Pool Size: | 3,520M | 3,520M | Log Buffer: | 11,840K |
| Per Second | Per Transaction | Per Exec | Per Call | |
|---|---|---|---|---|
| DB Time(s): | 6.1 | 3.3 | 0.04 | 0.01 |
| DB CPU(s): | 4.3 | 2.3 | 0.03 | 0.01 |
| Redo size: | 19,355.9 | 10,357.4 | ||
| Logical reads: | 1,709,514.8 | 914,769.9 | ||
| Block changes: | 110.8 | 59.3 | ||
| Physical reads: | 4,936.3 | 2,641.5 | ||
| Physical writes: | 13.7 | 7.4 | ||
| User calls: | 484.9 | 259.5 | ||
| Parses: | 49.7 | 26.6 | ||
| Hard parses: | 0.3 | 0.1 | ||
| W/A MB processed: | 9.9 | 5.3 | ||
| Logons: | 0.2 | 0.1 | ||
| Executes: | 162.9 | 87.1 | ||
| Rollbacks: | 0.1 | 0.1 | ||
| Transactions: | 1.9 |
| Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
| Buffer Hit %: | 99.90 | In-memory Sort %: | 100.00 |
| Library Hit %: | 99.65 | Soft Parse %: | 99.48 |
| Execute to Parse %: | 69.46 | Latch Hit %: | 99.94 |
| Parse CPU to Parse Elapsd %: | 31.64 | % Non-Parse CPU: | 99.97 |
| Begin | End | |
|---|---|---|
| Memory Usage %: | 76.14 | 75.69 |
| % SQL with executions>1: | 89.47 | 90.96 |
| % Memory for SQL w/exec>1: | 89.88 | 90.00 |
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| DB CPU | 15,421 | 69.68 | |||
| enq: TX - row lock contention | 15 | 5,775 | 384974 | 26.09 | Application |
| db file sequential read | 4,873,705 | 835 | 0 | 3.77 | User I/O |
| gc current block 2-way | 251,582 | 53 | 0 | 0.24 | Cluster |
| direct path read | 68,588 | 47 | 1 | 0.21 | User I/O |
| Load Average Begin | Load Average End | %User | %System | %WIO | %Idle |
|---|---|---|---|---|---|
| 6.62 | 4.42 | 19.0 | 1.0 | 0.8 | 79.9 |
| %Total CPU | %Busy CPU | %DB time waiting for CPU (Resource Manager) |
|---|---|---|
| 18.2 | 90.4 | 0.0 |
| Begin | End | |
|---|---|---|
| Host Mem (MB): | 48,384.4 | 48,384.4 |
| SGA use (MB): | 12,288.0 | 12,288.0 |
| PGA use (MB): | 1,474.6 | 1,238.1 |
| % Host Mem used for SGA+PGA: | 28.44 | 27.96 |
| Begin | End | |
|---|---|---|
| Number of Instances: | 2 | 2 |
| Per Second | Per Transaction | |
|---|---|---|
| Global Cache blocks received: | 115.09 | 61.58 |
| Global Cache blocks served: | 135.83 | 72.68 |
| GCS/GES messages received: | 372.30 | 199.22 |
| GCS/GES messages sent: | 393.77 | 210.71 |
| DBWR Fusion writes: | 3.14 | 1.68 |
| Estd Interconnect traffic (KB) | 2,157.00 |
| Buffer access - local cache %: | 99.89 |
| Buffer access - remote cache %: | 0.01 |
| Buffer access - disk %: | 0.10 |
| Avg global enqueue get time (ms): | 7.5 |
| Avg global cache cr block receive time (ms): | 0.3 |
| Avg global cache current block receive time (ms): | 0.3 |
| Avg global cache cr block build time (ms): | 0.0 |
| Avg global cache cr block send time (ms): | 0.0 |
| Global cache log flushes for cr blocks served %: | 1.5 |
| Avg global cache cr block flush time (ms): | 0.5 |
| Avg global cache current block pin time (ms): | 0.0 |
| Avg global cache current block send time (ms): | 0.0 |
| Global cache log flushes for current blocks served %: | 0.1 |
| Avg global cache current block flush time (ms): | 0.6 |
| Avg message sent queue time (ms): | 0.0 |
| Avg message sent queue time on ksxp (ms): | 2.2 |
| Avg message received queue time (ms): | 0.0 |
| Avg GCS message process time (ms): | 0.0 |
| Avg GES message process time (ms): | 0.0 |
| % of direct sent messages: | 48.41 |
| % of indirect sent messages: | 50.82 |
| % of flow controlled messages: | 0.77 |