Re: poor performance

I will repeat myself ... you need to bring in a consultant for a week or two. This is far too complex if you are looking to do a good job for something you just play around with.

I would definitely use a block size of 8K or larger. But whether 8K or 32K is not just some arbitrary value where I can say use 16K and it would have any meaning. Some of your questions about tablespace defaults such as pctincrease can, and in my opinion should, be dealt with by using locally managed tablespaces with uniform extent.

With respect to pctfree an pctused this is something that must be determined on a table by table basis depending on how it will be used. Basically how much of the block should be left empty after inserts to handle additional row information in the block created by updating the row.

But back to the top ... there is a reason why DBAs are paid a lot of money. It is the huge wealth of knowledge they must possess to do their job well. You wouldn't go to law.criminal.murder and ask a bunch of lawyers to tell you how to prepare your defense and by the same token I would advise you to not do this with a commercial database either. If you want to play and learn ... do it on your own personal PC.

Daniel Morgan

Tonia Stakemire wrote:

> 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
> "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3CBC3C5D.752D7AF5_at_exesolutions.com...
> > Sounds glacial to me. But it also sounds like your installation may be far
> from
> > ideal. To start with I would have never used the default database for
> anything
> > other than learning a few lessons for a beginner.
> >
> > If this is a commercial operation I would urge you to hire a consultant
> who is
> > really an expert DBA (not just someone with a great looking resume) to
> come in
> > for one week and help you. Make sure that part of the deal is that there
> is a
> > knowledge transfer ... that they don't just do a bunch of hocus pocus and
> leave
> > you totally dependent on them.
> >
> > Then take a good class or three.
> >
> > Daniel Morgan
> >
> >
> >
> > Tonia Stakemire wrote:
> >
> > > Hello All,
> > > I just wanted to check that I have done everything correctly because
> Oracle
> > > is performing very badly. I have a dual processor pIII (800Mhz). IG of
> ram
> > > and its on windows 2000 server. I just used the default database that it
> > > created and created a larger tablespace. My database is to hold
> multimedia
> > > data and there are 3 user. There are many factors that could be making
> it
> > > slow. We have tested the network and it is not that.
> > >
> > > An example is that it takes 30 secs to upload a picture (500Kb) into the
> > > database. Isn't that really slow?
> > >
> > > Any advice?
> > > Thank you
> > > Tonia
> >
Received on Mon Apr 22 2002 - 10:38:38 CDT