Re: session cursor cache

I am aware of the v$ views relating to cursors. Is it possible to view the contents of the entire cache? The 3 paragraphs in the 10g Performance Tuning Guide does not go into much detail.

I am looking for real life answers from people who tune and monitor the cursor cache.

Sometimes web pages have a very slight hesitation. Sometime they don't. This is what tuning is all about. I am curious why sometimes the cache hit rate fluctuates from 30% to 100%. I would like to see which cursors from my application are in the cache and which system cursors are being cached. Possibly I might better understand why all my cursors are not being cached as a set of pooled sessions execute the same code over and over again.

The slight hesitations I'm working on are hardly noticeable. The users are very happy with performance. Can it get better? Sure.

Asking other skilled professions who are able to offer good advice is hardly ignorant. Received on Tue Oct 18 2005 - 13:11:52 CDT