Re: OPEN_CURSORS

From: Yong <yhuang_at_indigopool.com>
Date: Fri, 25 Aug 2000 12:26:52 -0500
Message-ID: <8o6afu$j5h$1@news.sinet.slb.com>

50 is way too small. I think that's default. Ours is 600. You should change it to at least 300 or depending on activity.

select * from v$open_cursor gives you session IDs and SQL statements. But this view does not give you all open cursors you think. Steve Adams has some remark on this issue. Search at www.ixora.com.au/home.htm.

Yong Huang
yhuang_at_indigopool.com

kishen <kishenp_at_my-deja.com> wrote in message news:8o665g$ttc$1_at_nnrp1.deja.com...
> Hi All,
> Currently we have the OPEN_CURSORS set as default 50.
> In some particular cases when certain SQL's are executed, 28-30 cursors
> get openend. Due to which i get the maximum OPEN_CURSORS limit exceeded.
> Is there a way to find out how many cursors get opened for a specific
> SQL ? Will increasing the number OPEN_CURSORS solve my problem ?
>
> TIA
> Kishen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 25 2000 - 12:26:52 CDT