RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-14 Thread Richard Ji
: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500

RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-14 Thread Jared . Still
PROTECTED] Sent by: [EMAIL PROTECTED] 08/07/2003 02:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Yes, V$OPEN_CURSOR is instance-wide, but each row

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-14 Thread Jesse, Rich
Sent: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500

Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-10 Thread rgaffuri
:14:23 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR No takers on this from the perf tuning gurus? Please don't make me open a TAR. Think of the children... Rich Rich Jesse System/Database

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-10 Thread Jesse, Rich
Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hi

RE: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-08 Thread Jesse, Rich
] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR v$open_cursors is all open cursors in the instance v$sesstat is just open cursors in the session. what 3rd party product

Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Tanel Poder
Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich Sent: Thursday, July 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L Subject: V$SESSSTAT stat 3

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Richard Ji
recipients of list ORACLE-L Subject: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in the init.ora -- should be more than generous for a tiny app

Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Tanel Poder
PROTECTED] Sent: Thursday, August 07, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hi! This is troubleshooting, not performance tuning ;) As far as Ixora states, v$sesstat opened cursors current shows PL/SQL

Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Ryan
- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: V$SESSSTAT stat 3 vs V$OPEN_CURSOR Hi! This is troubleshooting, not performance tuning ;) As far as Ixora states, v$sesstat opened cursors

V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-07-24 Thread Jesse, Rich
Hey all, We recently had a problem with a 3rd-party app getting ORA-1000 max open cursors exceeded on their 8.1.7.4 DB. Since OPEN_CURSORS is set to 500 in the init.ora -- should be more than generous for a tiny app on a tiny DB -- we started looking into how many cursors the app actually has