Oracle Logbook

August 23, 2007

Good Buffer Distribution

Filed under: Uncategorized — heliodias @ 7:44 pm

PROD->SELECT name, 1-(physical_reads / (consistent_gets + db_block_gets ) )
  2  “HIT_RATIO” FROM V$BUFFER_POOL_STATISTICS
  3  WHERE ( consistent_gets + db_block_gets ) !=0;

NAME                  HIT_RATIO
——————– ———-
KEEP                 .999922843
RECYCLE              .618495732
DEFAULT               .86601863

For more information about buffer pool : http://jonathanlewis.wordpress.com/2007/09/05/hit-ratios-2/

About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: