session_cached

From: Benhayoune khalid <benhayoune_at_maroclear.co.ma>
Date: Thu, 18 May 2000 16:29:22 -0000
Message-Id: <10501.105998@fatcity.com>

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.

=_NextPart_001_01BFC0E6.39D69DB0 Content-Type: text/plain

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 cache

hits

Thanks in advance.

K.Benhayoune
System engineer/DBA
MAROCLEAR
Phone : 212-2-48-49-49
Fax : 212-2-48-67-03
Address : 216, BD ZERKTOUNI, 5 eme etage

Casablanca (Morocco)

=_NextPart_001_01BFC0E6.39D69DB0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable

<!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>

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);
         =
            =

|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |------------------- parse =

count

        =
            =

|-------------------------- session cursor cache hits</FONT></P>

Thanks in advance.


<FONT COLOR=3D"#008000" SIZE=3D2 FACE=3D"Comic Sans =

MS">------------------------------------------------------------------</=

FONT>
 K.Benhayoune
 System =
engineer/DBA
 MAROCLEAR
 Phone : =
212-2-48-49-49
 Fax : =
212-2-48-67-03
 Address =
: 216, BD ZERKTOUNI, 5 eme etage
            &n= bsp;  Casablanca (Morocco) Received on Thu May 18 2000 - 11:29:22 CDT