Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Tuesday, March 18, 2008

Script for finding more about current buffer busy waits

Please find the script for finding more about current buffer busy waits.



Script2 : FIND MORE ON BUFFER BUSY WAIT EVENT


Note: Please try the script on your own risk.

2 comments:

  1. Venkata SubramaniamMarch 18, 2008 at 5:27 AM

    Hi, I've got a production OLTP system for work. Hope this script help's me removing my DB memory bottlenecks

    ReplyDelete
  2. Hi, Venkat, This script might be helpful to find the potential problems in your OLTP systems occuring due to the "BUFFER BUSY WAIT EVENTS".
    Regards,
    Ajith Narayanan

    ReplyDelete

Thanks for you valuable comments !