Re: poor performance

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 - 09:02:24 CDT