session_cached_cursors

I've only been able to find bits and pieces of documentation on the init.ora param SESSION_CACHED_CURSORS. (14-18 of O8 Tuning guide).

It says that session cursors should be reused but I'm finding that the parse calls are still the same (sqltrace and v$sqlarea).

My guess is that the number of parse calls recorded in both v$sqlarea and from sqltrace does not distinguish between a logical (cached) parse and a normal parse.

v$sesstat/v$sysstat values for session cursor cache hits do go up after setting the parameter.

Does anyone know for sure what is happening? Received on Sat Dec 05 1998 - 16:52:28 CST