Re: Performance-Tuning with init.ora?

The values of the parameters specified within init.ora are dependant upon many factors; database size, number of users, type of application, size of the machine upon which you are running Oracle, etc. It is therefore virtually impossible for me to advise you on the actual values you should use given only the limited information which you have provided.

Simply go with the values recommended within the init.ora file provided during installation and then tweak them later if necessary.

If you're really stuck, let me know and I'll send you the init.ora which I currently use (our databases are of a similar size). Unfortunately, I don't have a copy of it to hand at the moment otherwise I would post it.

Frank Szymanski wrote in message <34ED9BDC.749B5CF2_at_kaa.bbn.hp.com>...
>Hello,
>
>I've got a database with two .dbf-files together they are 600 meg bytes
 large.
>
>My question is:
>
>Are there any init.ora parameter defaults recommended for such an
 installation?
>
>Thanks in advance and
>
>Tschuess,
> Frank
Received on Sat Feb 21 1998 - 00:00:00 CST