Re: Open_cursors parameter

From: <edawad_at_yahoo.com>
Date: 1998/03/18
Message-ID: <6ep5pn$amf$1_at_nnrp1.dejanews.com>#1/1


In article <6ejjnl$5i8$1_at_minus.oleane.net>,   "Florence" <chrislaval_at_hotmail.com> wrote:
>
> Hello,
> I wonder How increase Open_cursors parameter ?
> i use Oracle V7
> Thanks a lot
> Florence
>
>

If you are using Oracle 7.3 Enterprise Manager, you can change the parameter OPEN_CURSORS graphically from the startup/shutdown database option.

OR

you can change the parameter OPEN_CURSORS in the file INIT<sid>.ORA . The parameter has a default value of 50. Once changed, the database has to be shutdown and started up again.



Eddie.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 18 1998 - 00:00:00 CET

Original text of this message