Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: poor performance

Re: poor performance

From: Ron Reidy <rereidy_at_indra.com>
Date: Wed, 24 Apr 2002 08:03:19 -0600
Message-ID: <3CC6BB27.E6B84F4E@indra.com>


Tonia Stakemire wrote:
>
> 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

Tonia,

I suggest getting a good DBA book and taking the Oracle DBA classes. Your knowledge is so limited that this approach of trying to piecmeal together a good performing database will be very frustating (to you and your developer and end users).

-- 
Ron Reidy
Oracle DBA
Received on Wed Apr 24 2002 - 09:03:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US