Re: total cursor open currently

From: Li-Shan Cheng <exriscer_at_gmail.com>
Date: 2005-12-22 11:10:17
Message-id: 6e9345580512220210v65d2c066h8cd3a0dcbe1153d4@mail.gmail.com

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

>

Received on Thu Dec 22 2005 - 11:10:17 CST