Re: total cursor open currently

  • From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
  • To: Li-Shan Cheng <exriscer@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Dec 2005 15:17:12 +0530

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 <exriscer@xxxxxxxxx> wrote:
>
> you can have a look at v$open_cursor
>
>
>
> On 12/22/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> 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@xxxxxxxxx
> >        onkarnath.tiwary@xxxxxxxxx
> >
> >
>
>


--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar@xxxxxxxxx
       onkarnath.tiwary@xxxxxxxxx

Other related posts: