Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: session_cached_cursors
You need to write SQL from your application that does less parsing. You
need to use more host variables (see the application developer's guide -
they have some excellent examples of what this means.). It will make a big
difference on CPU usage.
Jim
Doug Cha wrote in message <3669b92c$0$227_at_nntp1.ba.best.com>...
>
>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 - 23:39:06 CST