Re: Init.Ora configuration

From: KRISHNAN GANESAN <KRISHNANG_at_MSN.COM>
Date: 1998/02/27
Message-ID: <#Jmk69$Q9GA.255@upnetnews04>#1/1

The increased disk reads may be due to:

frequent checkpoints, in which case look at log_checkpoint_interval, log_checkpoint_timeout parameters. Make the checkpoint to occur only during log switches. Set the log_checkpoint_interval (in terms of OS/ blocks) greater than the size of the redo log file and set the log_checkpoint_timeout to zero. - The DB_BLOCK_LRU_EXTENDED_STATISTICS parameter can be used to find the effect of adding buffers to the data cache. (DB_BLOCK_BUFFERS)

90% of the time, it is the poorly written, untuned SQL that causes excessive I/O. So, it is not a bad idea to identify specific programs before doing any init.ora changes. Also, do some memory usage monitoring and tuning.

All the best.
Krish

Javi López wrote in message <34F4A7E3.7275_at_eitb.com>...
>Hi!
>
>We have an HP Lx machine with two Pentium 200 processors, 4 disks of 4
>Gb (Raid5) and
>1 Gb of RAM memory.
>
>The operating system is Windows NT working in a client-server
>environment with
>Oracle DataBase.
>
>We have the following problem:
>
>Oracle accesses the disk too often, and doesn't work eonough from the
>memory (It's 1Gb !!)
>
>Is there anyone who could help me to configure INIT.ORA in order to get
>a most favourable
>result?
>
>Thanks.
Received on Fri Feb 27 1998 - 00:00:00 CST