script for monitoring db buffer cache Options

[rokyj055]

Dear All ,

Can anyone please give a script to find how much my db buffe cache and redo log buffer cache is used and how much is free.....

This post has been edited by rokyj055: Mar 26 2012, 08:44 AM

[burleson]

Here are script using v$bh for buffer monitoring:

http://www.dba-oracle.com/art_builder_buffer.htm

After a few transactions, 100% of it is used, caching blocks.

Read this, you don't indicate that you understanding how it works:

http://www.praetoriate.com/t_oracle_data_b...caching_sga.htm

***************************************
>> redo log buffer cache is used

http://www.dba-oracle.com/t_log_buffer.htm