session cursor cache

From: Brian <brian_at_databaseknowledge.com>
Date: 17 Oct 2005 20:21:54 -0700
Message-ID: <1129605714.382262.43070@f14g2000cwb.googlegroups.com>

Is there any way to see what's in the session cursor cache for all sessions?

How do you know when to raise or lower session_cached_cursors?

I've been watching the Cursor Cache Hit (%) and just kept raising session_cached_cursors till the hit % stayed below zero.

Current settings:
session_cached_cursors = 220
cursor_space_for_time = true
cursor_sharing = exact
Cursor Cache Hit (%) is about 60% Received on Mon Oct 17 2005 - 22:21:54 CDT