Re: OPEN_CURSORS

From: ORALAP <nospam_at_nospam.com>
Date: Fri, 25 Aug 2000 16:52:27 -0400
Message-ID: <f1Bp5.16529$Y51.157293@iad-read.news.verio.net>

Always set open_cursors to a high value. It's usually documented to have a maximum value of 255 or so, but the documentation isn't accurate - try setting it to 500 and then check V$PARAMETER after doing a shutdown/startup.

Want more tips? Check out http://www.lonyx.com , the Answer Index for database professionals. Tuning tips, general references, scripts, OCP help - you'll find them all there.

kishen wrote in message <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 - 15:52:27 CDT