Message-Id: <10623.117279@fatcity.com> From: "Reddy, Gautam" Date: Mon, 18 Sep 2000 14:34:08 -0500 Subject: v$open_cursor problem 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"

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