Oracle Logbook

November 22, 2011

Greatly Boosting Buffer Cache Efficiency with IOT

Filed under: Uncategorized — heliodias @ 3:41 pm

One very important thing regarding the IOT is the clustering factor.

Since the data are stored together according to the PK, as a bonus you decrease the amount of buffer cache usage.

Martin Widlake wrote a wonderful article about it:

http://mwidlake.wordpress.com/2011/08/08/iot-part-4-greatly-boosting-buffer-cache-efficiency/

 

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. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: