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 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 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 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
> >
>
>
--
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 - 11:13:54 CST
