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