Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Number of open cursors

Re: Number of open cursors

From: Ari D Kaplan <akaplan_at_interaccess.com>
Date: Tue, 29 Aug 2000 21:24:00 -0500 (CDT)
Message-Id: <10603.115807@fatcity.com>


You can issue

SELECT COUNT(*) FROM V$OPEN_CURSOR; To be more specific, this can be selected for ALL cursors, or by SID.

SELECT * FROM V$OPEN_CURSOR; Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 380+ Oracle tips, visit:                         <->
<->                                                      <->
<->             www.arikaplan.com                        <->
<->                                                      <->
<->             email: akaplan_at_interaccess.com           <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->


On Tue, 29 Aug 2000, Linda Hagedorn wrote:

> Where would I find the number of currently open cursors, instance wide?
>
> Thanks,
>
> Linda Hagedorn
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Tue Aug 29 2000 - 21:24:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US