Re: recreate init.ora

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 30 Oct 2001 22:20:48 +0100
Message-ID: <c96uttoke6ikdll88lau0p0u11flqaiur1@4ax.com>

On Tue, 30 Oct 2001 21:23:13 +0100, "Aad Aldus" <a.aldus_at_modality.nl> wrote:

>I installed Oracle 8.1.7 on a Windows2000 server with 256 MByte memory.
>Oracle created the file init.ora.
>After the installation I added 512 MByte of memory. Oracle does not use this
>extra memory. I would like Oracle to generate the init.ora file again. Hoe
>can I do that?
>
>Thanks,
>Aad Aldus
>
>
>

You can't do that automatically, as the init.ora is a static file, which is never generated. There is a default init.ora and that's all. You need to re-tune your instance, check which areas need improvement and then change parameters manually and bounce the database.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Oct 30 2001 - 15:20:48 CST