Database Writer Buffers Scanned (DBWRBuffScanned)
The total number of buffers looked at when scanning each LRU set for dirty buffers to clean. This count includes both dirty and clean buffers.
If the value is over 100, the DBWR process cannot keep up.
Recommendations
- Consider adding DBWR processes (if your environment allows it).
- Consider increasing the following parameters:
- DB_BLOCK_BUFFERS
- DB_WRITERS
- DB_BLOCK_WRITE_BATCH
- (Buffer Cache Size)
Default parameter attributes
Attribute | Default value |
|---|---|
Application class | ORACLE_PERFORMANCE |
Command type | not applicable |
Platform | all |
Icon style | Graph |
Unit | number of buffers |
Border range | undefined |
Alarm1 range | undefined |
Alarm2 range | undefined |
Scheduling(poll time) | poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollPerformance |
BMC ProactiveNet Performance Management properties
Property | Default value |
|---|---|
| Monitor type | Oracle Database Performance |
| Key Performance Indicator | No |
| Monitor for abnormalities | No |
| Graph by default | No |
| Availability | No |
| Response time | No |
| Normal distribution | Yes |
| Statistical | Yes |
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.