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

Whichever way you try to pull this one off - rest assured you'll need an expert in to do some true analysis. Performance covers a wide range of scenarios - network, application/ functionality, code, physical design/ DB layout, Oracle install / OFA, DB tuning/Optimal parameter etc.....

Good luck.

dgdss wrote:

> You have 1GB of ram on a 120 ? well that is money well spent he is your
> first step in tuning tuen the hardware....
> "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 Sun Mar 25 2001 - 20:52:18 CST