RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-14 Thread Richard Ji
System/Database 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

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
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 Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jesse, Rich

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
Hi! This is troubleshooting, not performance tuning ;) As far as Ixora states, v$sesstat opened cursors current shows PL/SQL cached cursors as well, even when they are explicitly closed (assuming that session_cached_cursors is set). But v$open_cursor doesn't show the number of cursor structures

RE: V$SESSSTAT stat 3 vs V$OPEN_CURSOR

2003-08-07 Thread Richard Ji
There were discussions about this before. You can search the archive for it. v$open_cursor and the statistic opened cursor current doesn't always agree. v$open_cursor show cursors parsed and not closed, while the opened cursor current shows cursors opened and not closed. v$open_cursor doesn't

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