RE: v$open_cursor problem

From: Reddy, Gautam <Gautam_Reddy_at_Dell.com>
Date: Tue, 19 Sep 2000 10:49:35 -0500
Message-Id: <10624.117357@fatcity.com>

Hi Yong

This is really bummer I have bounced the instance to recycle and see if it shows up again. I get the same results. I have sent this to Oracle support and have not got a answer yet.

SQL> select * from v$parameter where name like 'open_cursors';

       NUM NAME
---------- ----------------------------------------------------------------

      TYPE

---

VALUE

---

---

ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ
--------- ----- --------- ---------- -----
DESCRIPTION

---

       325 open_cursors
         3
1000
FALSE     FALSE FALSE     FALSE      FALSE

max # cursors per process

1 row selected.

Thx
Gautam

-----Original Message-----

From: yong huang [mailto:yong321_at_yahoo.com] Sent: Tuesday, September 19, 2000 10:24 AM To: Reddy, Gautam
Subject: v$open_cursor problem

Gautam,

Interesting. Could you verify the real open cursors setting in the instance:

select * from v$parameter where name = 'open_cursors';

just in case.

When you find the answer, could you post it to the list?

Yong

---

---

Sent: Tuesday, September 19, 2000 10:24 AM To: Reddy, Gautam
Subject: v$open_cursor problem

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

---

Do You Yahoo!? Received on Tue Sep 19 2000 - 10:49:35 CDT