session_cached_cursors

I wish someone had told me this a long time ago.

alter system set session_cached_cursors=500 scope=spfile sid=’*’;
alter system set open_cursors=1000 scope=both sid=’*’;


That's it. Restart your db instance so that session_cached_cursors takes effect. For an OLTP database, to reduce library cache contention in the shared pool, set that value.

I've read many books, used many ridiculous performance management tools, and not one said - set that parameter and don't worry about it. Watch your concurrency soar! I have been searching for a solution for a really long time to ease the demand on the SQL cache. 

This is it.