Re: poor performance

I am using Oracle 9i. I didn't change the init.ora so it used the default settings which apparently aren't very good for large databases.

From reading up there are so many initialization parameters. Can you possibly give me some advice on which parameters have the most effect and what they should be set at. I can test it from there.

From reading up the most important parameters seem to be:

     block size which should be larger than it is. 8K or 16K maybe     Should I increase the max_sga_size and then make both the buffer pool size and the shared pool size bigger?

Also there are a whole lot of tablespace parameters that should be set. This is what I got from the documentation but it might be wrong? Maxextents= unlimited, PCTINCREASE=0, INITIAL and NEXT there is a formula, the data read is random so NOCACHE, CHUNK size as large as possible which is 32K, PCTFREE= 5 and PCTUSED=40, and global as mainly read only.

Any help would be greatly appreciated.
Thank you
Tonia
"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3CBBFE79.AF4CB455_at_mytoys.de...
> We now your OS but there are some other informations which are necessary:
> Oracle version, init.ora settings (very important!).
>
> --
> Dipl.-Inform. Knut Talman Fon +49.30.72 62 01 411
> myToys.de GmbH Fax +49.30.72 62 01 222
> Schoenhauser Allee 36-39 Mobil +49.173.671 65 65
> D-10435 Berlin
Received on Mon Apr 22 2002 - 09:06:06 CDT