Skip to Content
0
Former Member
Sep 01, 2009 at 06:08 AM

Data buffer quality is not good and buffer busy wait waiting for data block

166 Views

Hi Oracle Gurus,

we have SAP R/3 and database is oracle 9.2.0.8.

Data buffer quality is not good (75.5) whereas it should be more than 95. I checked and found buffer busy wait waiting for data block in st04 trans-> Detail analyis menu -> Busy buffer wait.

Current Database size is 74 GB and sga_max_size is 1200M and shared_pool_size=392M and db_block_buffers=96000, db_block_size=8192 so db_buffer_cache= db_block_buffers * db_block_size 750M.

Did anyone face such issue?

Please suggest what should I do to improve data buffer quality?

Thanks,

Bhupesh