Would someone please shed some light on why the LFS is 5 times LFPW ?
I dont believe it is a cpu contention or a re-nice issue.
EMC Symmetrix with AIX 2 node rac 11204 = Hardware being used.
Is this specifically a redo log needing a flash problem ?
| Snap Id | Snap Time | Sessions | Cursors/Session | Instances |
|---|
| Begin Snap: | 19488 | 20-Jun-16 13:00:32 | 84 | 40.7 | 2 |
| End Snap: | 19489 | 20-Jun-16 14:00:40 | 87 | 40.0 | 2 |
| Elapsed: | | 60.12 (mins) | | | |
| DB Time: | | 296.38 (mins) |
Load Profile
| Per Second | Per Transaction | Per Exec | Per Call |
|---|
| DB Time(s): | 4.9 | 0.1 | 0.00 | 0.00 |
| DB CPU(s): | 0.3 | 0.0 | 0.00 | 0.00 |
| Redo size (bytes): | 221,470.9 | 4,645.0 | | |
| Logical read (blocks): | 7,276.2 | 152.6 | | |
| Block changes: | 735.0 | 15.4 | | |
| Physical read (blocks): | 117.8 | 2.5 | | |
| Physical write (blocks): | 74.5 | 1.6 | | |
| Read IO requests: | 117.8 | 2.5 | | |
| Write IO requests: | 52.0 | 1.1 | | |
| Read IO (MB): | 0.9 | 0.0 | | |
| Write IO (MB): | 0.6 | 0.0 | | |
| Global Cache blocks received: | 87.3 | 1.8 | | |
| Global Cache blocks served: | 89.8 | 1.9 | | |
| User calls: | 1,867.2 | 39.2 | | |
| Parses (SQL): | 649.2 | 13.6 | | |
| Hard parses (SQL): | 0.1 | 0.0 | | |
| SQL Work Area (MB): | 0.2 | 0.0 | | |
| Logons: | 0.5 | 0.0 | | |
| Executes (SQL): | 1,824.1 | 38.3 | | |
| Rollbacks: | 7.5 | 0.2 | | |
| Transactions: | 47.7 | |
Top 10 Foreground Events by Total Wait Time
| Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
|---|
| log file sync | 155,237 | 5499.2 | 35 | 30.9 | Commit |
| gc buffer busy release | 42,558 | 2598.8 | 61 | 14.6 | Cluster |
| gc buffer busy acquire | 52,248 | 2063.5 | 39 | 11.6 | Cluster |
| db file sequential read | 425,105 | 1880.8 | 4 | 10.6 | User I/O |
| gc current block busy | 38,943 | 1068.9 | 27 | 6.0 | Cluster |
| DB CPU | | 952.6 | | 5.4 | |
| SQL*Net message from dblink | 125,982 | 821.4 | 7 | 4.6 | Network |
| reliable message | 288,789 | 781.9 | 3 | 4.4 | Other |
| enq: TX - index contention | 13,486 | 306.3 | 23 | 1.7 | Concurrency |
| gc current block 2-way | 212,260 | 165.9 | 1 | .9 | Cluster |
|
| Statistic Name | Time (s) | % of DB Time |
|---|
| sql execute elapsed time | 9,868.64 | 55.50 |
| DB CPU | 952.63 | 5.36 |
| parse time elapsed | 217.38 | 1.22 |
| sequence load elapsed time | 115.63 | 0.65 |
| connection management call elapsed time | 3.37 | 0.02 |
| PL/SQL execution elapsed time | 1.91 | 0.01 |
| hard parse elapsed time | 1.23 | 0.01 |
| repeated bind elapsed time | 0.07 | 0.00 |
| hard parse (sharing criteria) elapsed time | 0.06 | 0.00 |
| DB time | 17,782.63 | |
| background elapsed time | 3,711.91 | |
| background cpu time | 275.36 |
Background Wait Events
- ordered by wait time desc, waits desc (idle events last)
- Only events with Total Wait Time (s) >= .001 are shown
- %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
| Event | Waits | %Time -outs | Total Wait Time (s) | Avg wait (ms) | Waits /txn | % bg time |
|---|
| log file parallel write | 151,627 | 0 | 1,405 | 9 | 0.88 | 37.86 |
| gcs log flush sync | 203,139 | 4 | 974 | 5 | 1.18 | 26.25 |
| db file parallel write | 40,498 | 0 | 748 | 18 | 0.24 | 20.14 |
| control file sequential read | 10,882 | 0 | 39 | 4 | 0.06 | 1.06 |
| control file parallel write | 1,777 | 0 | 29 | 16 | 0.01 | 0.78 |
| ksxr poll remote instances | 542,109 | 100 | 13 | 0 | 3.15 | 0.35 |
| log file sequential read | 305 | 0 | 13 | 41 | 0.00 | 0.34 |