| From: | Steve Adams |
| Date: | 23-Sep-2000 00:02 |
| Subject: | Interpreting lgwr_stats.sql |
|
|
It means that you commit so frequently (or generate redo so slowly) that the background write threshold (1/3 of log_buffer) is seldom the trigger for a LGWR write. Also log file sync waits are a little faster than log file parallel write waits, which means that for some syncs LGWR had already begun the write when the process began to wait for it. Given the fact that background writes are relatively rare, that suggests that there are DBWn syncs. You can check that with the APT script dbwn_sync_waits.sql. DBWn syncs could be due to overzealous checkpointing, or too small a buffer cache.
|
![]() |
In my db, the sync cost ratio is well under 1.5, but average log write size is very different of background write threshold. What it means?
Average Log Background
Write Size Write Theshold
-------------- --------------
5632 87552
Sync Cost Ratio
---------------
0.95
|