DBA_learner
Member
Dear All,
How many APW’s we should have with a database?
Our database size is around 800GB and currently we have 12 APW’s running. As per below Promon activities, writes by APW seems fine but rest values should be lower (I think).
Please help on how many APW’s should we have with a DB.
Regards
How many APW’s we should have with a database?
Our database size is around 800GB and currently we have 12 APW’s running. As per below Promon activities, writes by APW seems fine but rest values should be lower (I think).
Code:
Writes by APW 99 %
Buffs Flushed 345569 /* buffs are flushed in memory and not written to DB or Transaction lost, is this correct?*/
Checkpoints 82164
Total BI writes 166981K 4767 79.46 0.34
Busy buffer waits 619140 17 0.29 0.00
Empty buffer waits 3404067 95 1.58 0.01
Before-image block size: 8192 bytes
Before-image cluster size: 16384 kb (16777216 bytes)
Number of before-image extents: 6
Please help on how many APW’s should we have with a DB.
Regards