Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> script for monitoring db buffer cache
rokyj055
post Mar 26 2012, 08:43 AM
Post #1


Advanced Member
***

Group: Members
Posts: 75
Joined: 23-January 12
Member No.: 46,637



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
Go to the top of the page
 
+Quote Post
burleson
post Mar 26 2012, 09:27 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,603
Joined: 26-January 04
Member No.: 13



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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th October 2014 - 07:30 PM