Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> v$open_cursor problem

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>&nbsp;</DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>SQL&gt; select * from v$sesstat where STATISTIC# = 3 and value &gt;1000</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SID STATISTIC#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE<BR>---------- ---------- ----------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2833<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3302<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3317<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 62&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
4506<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
5036<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
3674<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5268</SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>SQL&gt; select * from v$sysstat where name like '%open%'<BR></SPAN></FONT></DIV>
<DIV>&nbsp;</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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 1.8447E+19</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=898002719-18092000>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 opened cursors current<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 8589959026</SPAN></FONT></DIV>
<DIV>&nbsp;</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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US