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
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
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
: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
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
] [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
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
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
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
-
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
10 matches
Mail list logo