Re: Init.Ora configuration

Hi,
I would suggest u check oracle7 server administrator's guide. It's online too.

But in any case, what is ur SGA size ? If it is too small then it may need to bring in lot of database blocks in main memory every time oracle requires them and if it is too large to be fit in the available main memory (Total memory - total memory required for all other apps on machine.) U are going after DB_BLOCK_BUFFERS parameters in the init.ora file mostly.

So u may have to figure that out first. Usually Oracle's defaults are not sufficiant.

Ketan Shah.
In article <34F4A7E3.7275_at_eitb.com>,
  Javi López <javi_at_eitb.com> wrote:
>
> 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.
>

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