v$open_cursor problem

From: Reddy, Gautam <Gautam_Reddy_at_Dell.com>
Date: Mon, 18 Sep 2000 14:34:08 -0500
Message-Id: <10623.117279@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_01C021A7.AA3D6D02
Content-Type: text/plain;

charset="iso-8859-1"

Guys
This is on a 8.1.6 db. I have open_cursors=1000 in my init file but when I query v$sesstat i get the following output. Anyone see this?

SQL> select * from v$sesstat where STATISTIC# = 3 and value >1000

SID STATISTIC# VALUE
---------- ---------- ----------

        10          3       2833
        15          3       3302
        28          3       3317
        62          3       4506
        71          3       5036
        72          3       3674
        91          3       5268

SQL> select * from v$sysstat where name like '%open%'

STATISTIC# NAME

---------- ----------------------------------------------------------------
     CLASS      VALUE
---------- ----------
         2 opened cursors cumulative
         1 1.8447E+19
 
         3 opened cursors current
         1 8589959026

Thx
Gautam

------_=_NextPart_001_01C021A7.AA3D6D02
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>Guys</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>This is on a 8.1.6 db. I have open_cursors=1000 in my init file but when I query v$sesstat i get the following output. Anyone see this?</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>SQL> select * from v$sesstat where STATISTIC# = 3 and value >1000</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>       SID STATISTIC#      VALUE<BR>---------- ---------- ----------<BR>        10          3      
2833<BR>        15          3      
3302<BR>        28          3      
3317<BR>        62          3      
4506<BR>        71          3      
5036<BR>        72          3      
3674<BR>        91          3       5268</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000></SPAN></FONT> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>SQL> select * from v$sysstat where name like '%open%'<BR></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN

class=898002719-18092000>STATISTIC# NAME<BR>---------- 
----------------------------------------------------------------<BR>&nbsp;&nbsp;&nbsp;&nbsp; 
CLASS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<BR>---------- 
----------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 opened cursors

cumulative<BR>         1 1.8447E+19</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>         3 opened cursors current<BR>         1 8589959026</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2>Thx</FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><STRONG>Gautam
Received on Mon Sep 18 2000 - 14:34:08 CDT