11gr2 SQL result cache test notes

Pros:

  • SQL gets very good performance if the SQL is cached
  • Transparent to app
  • Low cost: only need several MB memory and no extra license

Cons:

My Conclusion:

  • not suitable for busy OLTP db.

Notes:

  • I have another blog entry to go through Result Cache : Result cache in oracle 11g
  • A very good ppt by Julian Dyke: Result Cache Internals
  • If a session is building a result cache, the other session may wait 10 seconds (default) to timeout. It is controlled by parameter hidden “_result_cache_timeout”.
About these ads

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

3 Responses to 11gr2 SQL result cache test notes

  1. Alex,

    things changed quite a bit in 11GR2 (the way latch dynamics works), see http://afatkulin.blogspot.com/2010/06/11gr2-result-cache-scalability.html

  2. Pingback: Result cache in oracle 11g « Oracle Explorer: Standing on the shoulders of giants

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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: