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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance problems

Re: Performance problems

From: Nicole <nsj10_at_hotmail.com>
Date: 7 Apr 2002 15:09:51 -0700
Message-ID: <a9e0e9fb.0204071409.183744ca@posting.google.com>


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

Original text of this message

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