Re: oracle 8.0.6 running aweful!!!!! need tuning advice!

I endorse Howards comments.

I would like to add you need to run $ORACLE_HOMED/rdbms/admin/utlbstat using svrmgrl
and 4 or more hours later utlestat the same directory. This will result in a report.txt, which usually identifies the major bottlenecks.
Toad has a nice module for this too, and it's free at www.toadsoft.com Personally I still think the checktuning script by Dave Sisk is useful. (www.ipass.net/~davesisk/oont.htm)

Hth,

Sybrand Bakker, Oracle DBA

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3abd133f_at_news.iprimus.com.au...
> You could do worse than visit www.ixora.com.au.
>
> It's about the best performance tuning resource there is. Links from
 there
> are also available to Jonathan Lewis' site, which is the only other one
> worth visiting.
>
> Concentrate first on tuning the Instance -Library Cache hit ratio, Buffer
> Cache hit ratio etc. Then start on physical file issues.
>
> Regards
> HJR
>
>
> "oskar" <pheonix1t_at_home.com> wrote in message
> news:Li8v6.421783$w35.66665103_at_news1.rdc1.nj.home.com...
> > hello people,
> > I have a strange situation at work ( somehow I get the feeling I should
 get
> > used to these situations!).
> > The oracle server is running very slow. It's on an HP-UX 10.20 (
 900/800).
> > It has 1G RAM, a SCSI disk array of several drives....don't recall how
 many
> > but at least 6 disks....space isn't a problem! The processor is
> > 120MHZ.....don't laugh!!!!!!! :)
> > That's what we have to work with!
> > I'm pretty sure no one has ever done any sort of performance tuning on
 this
> > thing.....
> > They are also running Lawson on the oracle database as well....I think
 this
> > adds to the complexity and trouble of tuning this thing! I've never
 heard
> > of Lawson until I started working at this place.
> > Anyway, I tried suggesting that the owner hire an oracle specialist
> > (Dulcian.com) to tune this thing but he turned that down..........too
> > expensive and wants to let this "partner" ( consultants ) do this. They
 are
> > doing a great job of web developing and programming...but they never
 said
> > they were Oracle specialists....even their website doesn't even mention
> > Oracle. ( comvision.com ).
> > So, until they get around to it I need to start taking some
 measurements
> > of this thing and see just how bad it is and why? Kyle Hailey posted a
> > monitor utility that he's developed as well as a link to Quest.com.
 What
 do
> > oracle professionals have to say about quest software or Kyle's monitor
> > software?
> > I started doing some research at Oracle and found some basic
> > documentation on performance tuning the version 8.0.6 database as well
 as
 a
> > site called oracle.ittoolbox.com that has a lot of very good info.
> > Basically, since I'm going through a crash course of database
> > admininstration in real life! What or where are the best places to go
 so
 as
> > to quickly learn the things I need to do in order to start analysing the
> > performance of this database so I can have an idea of what is going
> > on??......so if or when the changes start to be put into place by the
> > "partner" ( consultants).....I'll have an idea of what the consequences
 will
> > be. I'm the systems admin. of this place so if anything goes
> > wrong........its my butt on the line! I'm very confident of my
 abilities
> > with windows NT/98/2000 and linux. I'm starting to get good at
 unix...but
> > still learning. The oracle database thing is totally new to
 me.........but
> > from what I can see.........this is very sophisticated stuff and
> > trouble-shooting it is hard because it interacts with so many different
> > things (software and hardware). From what I'm quickly
 learning...........
> > the way the database is setup and even the way the sql scripts are
 written
> > will have a big effect on the performance of the database under a
 production
> > environment.
> >
> > forgive the long message but I'd really appreciate some accurate advice
 on
> > what I should be reading or looking at to solve this problem!
> >
> > Thank you,
> >
> > Oskar
> >
> >
>
>
Received on Sat Mar 24 2001 - 16:40:35 CST