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: total cursor open currently

Re: total cursor open currently

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: 2005-12-22 10:47:12
Message-id: a144e5210512220147v1def9294ic10df333004b5fbf@mail.gmail.com


hi cheng,

thanx for the reply. i checked in v$open_cursor view which gave me a total of 5000+ rows however my open_cursor parameter is set to 2600 only. i don know why?????? can u plz. tell me..

On 12/22/05, Li-Shan Cheng wrote:
>
> you can have a look at v$open_cursor
>
>
>
> On 12/22/05, Onkar N Tiwary wrote:
> >
> > hi guys,
> >
> > how to find total no of cursors opened in the memory at any point of
> > time??????
> >
> > --
> > Thanks & Regards,
> > T. Onkar Nath
> > OneAPPS Enterprise Technology Pvt. Ltd.
> > to_onkar_at_yahoo.com
> > onkarnath.tiwary_at_gmail.com
> >
> >
>
>

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com
Received on Thu Dec 22 2005 - 10:47:12 CST

Original text of this message

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