Re: OPEN_CURSORS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 25 Aug 2000 23:55:56 +0200
Message-ID: <967241565.8734.2.pluto.d4ee154e@news.demon.nl>

Remarks embedded

Hth,

Sybrand Bakker, Oracle DBA

"kishen" <kishenp_at_my-deja.com> wrote in message news:8o6685$tub$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 ?
By design 1 per sql statement.

Will increasing the number OPEN_CURSORS solve my problem ?

Of course. 50 is way too low. Two hunderd is more like it and I usually set it to 500.

>
> TIA
> Kishen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 25 2000 - 16:55:56 CDT