| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Open Cursors, again
HP-UX and versions 8.0.5.2.1, 8.1.7.4, and 9.2.0.3.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Monday, April 14, 2003 1:09 PM
To: Multiple recipients of list ORACLE-L
There are bugs associated with reporting open cursor counts. What
platform/version
of Oracle are you running?
-----Original Message-----
Sent: Monday, April 14, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Richard,
True, you did not suggest a query, but I had one that I retrofitted with your suggestion:
SELECT USERNAME, A.SID, NVL(OSUSER,'UNKNOWN'), NVL(MACHINE,'*'),
NVL(PROGRAM, 'UNKNOWN'), value
FROM V$SESSION A, v$sesstat c
WHERE value > 0
and a.sid = c.sid
and statistic# = 3
GROUP BY USERNAME, A.SID, OSUSER, MACHINE, PROGRAM;
When I ran this in one of my database with a known cursor limit of
100 I had a number of rows that said there where 300+ cursors open for that
session. Obviously something it amiss!!
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Friday, April 11, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L
That might be me. :) I mentioned v$sesstat but I didn't provide any query. Which query did you use? Note, statistic# 2 is cumulative and 3 is current.
-----Original Message-----
Sent: Friday, April 11, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L
Folks,
This last week we had a thread on open cursors running around. I try to keep my mailbox clean to stay under my limits, so I've lost them thread. Anyway someone suggested using V$sesstat instead on V_$OPEN_CURSORS because it was sometimes in error. Well I think someone may have made a mistake as well. The open cursor limit on my DB is 100, but this query returned a value of 204 for a particular user who is not having a problem. On the other hand getting into V_$OPEN_CURSORS gives me a value of 2, which makes all the sense in the world. I've a funny feeling that V$SESSTAT is holding the cumulative number of cursors, not the current ones.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: DGoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: DGoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: DGoulet_at_vicr.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 14 2003 - 12:29:03 CDT
 |
 |