Re: Init.Ora configuration

I suggest you read the Oracle Performance Tuning manual (as well as any - or all - of the Oracle tuning books that are out there on the market) before you jump to conclusions. And learn NT properly as well.

Main memory caches that Oracle uses are:

• Library cache
• Data dictionary cache
• Database block buffer cache
• Sort areas
• Redo log buffers

These are all configurable via:

    shared_pool_size (1 and 2 above)
    db_block_buffers (3 above)
    sort_area_size (4 above)
    log_buffer (5 above)

These *may* be set too low (and you seem to have plenty of RAM). Monitor these statistics on your system using the SQL scripts given in the Performance Tuning books (and lots of other places out there on the Net.)

However *look at your application, the workload on the machine and the configration of NT first*, because if you don't you'll end up chasing your own tail! :-)

Tuning a database and it's server is not a simple, easy task - and *every system is different.* Your disk activity could be caused be *any* number of factors, both Oracle and non-Oracle related. Tread carefully, and play wisely.

Steve Phelan.

Javi López wrote in message <34F4A7FC.4482_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 Thu Feb 26 1998 - 00:00:00 CET