Re: total cursor open currently
- From: Onkar N Tiwary <onkarnath.tiwary@xxxxxxxxx>
- To: Li-Shan Cheng <exriscer@xxxxxxxxx>
- Date: Thu, 22 Dec 2005 15:43:54 +0530
thanx a lot to all of you. now its clear to me. and i will start looking for
the usage and description of the parameters to avoid such foolish questions
in future. thanx once again.
On 12/22/05, Li-Shan Cheng <exriscer@xxxxxxxxx> wrote:
>
> 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
> >
>
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Other related posts:
