Oracle Scratchpad

October 13, 2009

Cursor_sharing (2)

Filed under: CBO,Performance,Troubleshooting — Jonathan Lewis @ 6:23 pm GMT Oct 13,2009

In response to a question about a system that needed to set a very large shared_pool_size, I’ve just posted on the OTN database forum a brief summary of the impact of the cursor_sharing parameter on your system. It seemed like a waste not to link to it from the blog.

An earlier posting on my blog about one of the little oddities that can appear when you use cursor_sharing.

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: Logo

You are commenting using your 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

Powered by