Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance problems
What type of Performance problems are you seeing? You mention storage.
Have you checked the READ and WRITE I/O of your datafiles? Are they
BLOCKED or WAITING i.e a bottleneck? You might have a storage
performance issue or maybe also some bad SQL causing excessive I/O. So
you may also want to look at your top SQL and correlate with your I/O.
Also 8.0.5 is not a good version to be on. You probably want to
upgrade to 8.0.6 or maybe 8.1.6
Nicole
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<3cacba78$0$233$cc9e4d1f_at_news.dial.pipex.com>...
> Typically running close to 100% storage doesn't cause a performance problem,
> though a good DBA will allocate more storage as necessary since hitting 100%
> storage in a non-expanding tablespace does cause a performance problem (the
> db stops <g>). I'd start by seeing what operations perform slowly and
> tracing and optimising the sql statements for them.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "konopam" <konopam_at_yahoo.com> wrote in message news:%1%q8.2$l%.101_at_client...
> > Hello,
> >
> > I was wondering if anyone could let me know if having your tablespace
> > percentage
> > above 80 is bad? Should I make the extents bigger?
> >
> > We are having some performance problems w/ an Oracle 8.0.5 db and this has
> > been in production for about 5 months, the only thing that I can see from
> > storage manager is that there are 3 data files that are about fully
> used --
> > 95% or better should I increase these
> > tablespaces to help
> >
> > Any other ideas on what I can do to check performance of the database
> >
> > Appreciate any input
> >
> > Thanks
> > Andy
> >
> >
Received on Sun Apr 07 2002 - 17:09:51 CDT