Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> session_cached_cursors
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Hi All,
Excuse my poor English !
What are parameters and statistics should i consider to size the value of the initialization parameter SESSION_CACHED_CURSORS ?
Is there any rule about this ?
I use the following SQL query and compare the values of the statistics "parse count" and "session cursor cache hits", but i am not sure :
select name,value
from v$sysstat
where statistic# in (131,142);
| |------------------- parse count |-------------------------- session cursor cachehits
Thanks in advance.
Casablanca (Morocco)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.0.1459.75">
<TITLE>session_cached_cursors</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi All,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Excuse my poor English !</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">What are parameters and statistics =
should i consider to size the value of the initialization parameter =
SESSION_CACHED_CURSORS ?</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Is there any rule about this ?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I use the following SQL query and =
compare the values of the statistics "parse count" and =
"session cursor cache hits", but i am not sure :</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">select name,value</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">from v$sysstat</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">where statistic# in (131,142);</FONT>
<BR> =
<FONT SIZE=3D2 =
FACE=3D"Arial"> =
| |------------------- parse =count</FONT></P>
<P> =
<FONT SIZE=3D2 =
FACE=3D"Arial"> =
|-------------------------- session cursor cache hits</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in advance.</FONT>
</P>
<P><I><FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans =
MS">------------------------------------------------------------------</=FONT></I>
![]() |
![]() |