Re: total cursor open currently
- From: Li-Shan Cheng <exriscer@xxxxxxxxx>
- To: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- Date: Thu, 22 Dec 2005 11:10:17 +0100
count(*) and group by sid, the values shown is per session
open_cursor is per session, in other words you can open up to 2600 cursor
per session
rgds
--
LSC
On 12/22/05, Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx> wrote:
>
> 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:
