| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 8.0.6 running aweful!!!!! need tuning advice!
In article <Li8v6.421783$w35.66665103_at_news1.rdc1.nj.home.com>, oskar
<pheonix1t_at_home.com> writes:
>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
>
I have heard of Lawson as I have worked with an installation of it on a Sun
using version 8.0.6 and it runs pretty well. However, this system never grew
to be very big.
Every Lawson query includes an index hint in the SQL submitted to Oracle and every SQL statement pretty much has an index to support it. This makes the system CBO safe in that if other objects are in the database and have statistics the Lawson code should still run the way the Lawson designers wanted. A few of the Lawson batch jobs were slow even on our small system.
Lawson manages space by default using row counts estimates, but they provide a way for the DBA to take more control over the space by using four tables created just for DBA use. Two of the tables are for partitioned tables and indexed but the other two are for managing normal tables. The table names are law_dba_table and law_dba_index and you can specify the tablespace, initial extent, next extent, pctfree etc... using these. I can not remember the name of the script that the DBA runs to create these tables but you should be able to find them using grep in the Lawson directory or by calling the Lawson help desk.
For space management purposes I suggest
1- allocate law_dba tables to control space allocation
2- separate the large objects from the smaller ones
For performance I suggest you
1- Use OS level stripping to even out your IO
2- Rebuild you indexes - this will reclaim a lot of space and may help
performance
Lawson has no problem with the DBA rebuilding the objects using Oracle exp/imp or spooling/sqlldr instead of using the Lawson dbreorg utility.
The Oracle Performance and Tuning manual contains queries to check all the 'key' items like rollback segment contention, redo log buffer copy latches, and the bufer pool hit ratio, and library cache hits. Of all the database level tuning factors the shared pool is probably the most important to make sure it is not a problem.
Without knowing anything else about your system I would suggest your Oracle SGA be no more than 25% of real memory and probably not less than 12%, which means it should be between 128M and 256M on your system. Our version of Lawson did not have any packaged codes so your shared pool requiresments should not be too heavy unless you are using MTS.
Good luck.
 |
 |