Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

System appears fine, but apps run slow

Michael Peddycord
Occasional Contributor

System appears fine, but apps run slow

Our rp7410 with HPUX11.11 says that the CPU utilization is good, the memory utilization is good and the disk utilization is good, but our Oracle compiles run about 8 times slower than they do on a V2500 with 11.0. Where should I look for possible solutions.

Thanks

Mike Peddycord
5 REPLIES
Martin Johnson
Honored Contributor

Re: System appears fine, but apps run slow

Make sure your database is properly indexed. Also check for locking contention.

On the system side, look at memory allocation. What percentage of the I/O is physical I/O?

HTH
Marty
A. Clay Stephenson
Acclaimed Contributor

Re: System appears fine, but apps run slow

Hi Mike:

There are two methods to analyze your problem:

1) You supply very little data and we "Use the Force".

2) You supply things like kmtune outputs from both boxes, sar or Glance output, vmstat output, ... and then we use more conventional methods.

You mention longer compile times but what about other applications. Are database query times longer? More data, please.



If it ain't broke, I can fix that.
Yogeeraj_1
Honored Contributor

Re: System appears fine, but apps run slow

hi Mike,

a few more info.

Is the database on the same server or a different one?

(could it be a network connection problem?)

revert

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: System appears fine, but apps run slow

I shall provide you a tool for collecting the data A. Clay asks for.

My adaptation of HP's background performance data collection scripts.

Simply run the attached scripts in the background and data will be magically collected. You will see what your bottleneck is and have a good start at cleaning it up.

I'm betting on swap, based on your answer.

swapinfo -tam

On low memory systems (Under 4 GB), swap needs to be twice RAM to support Oracle. That is based on real world experience.

How you get there is a matter of debate.

I am now testing the A. Clay style of smaller primary swap with a larger secondary swap. Sized correctly this can provide you great performance.

Run the scripts Luke. See what the data tells you(Couldn't resist).



SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
malay boy
Trusted Contributor

Re: System appears fine, but apps run slow

Hi Mike,
Well you can check the database performance by running script :$ORACLE_HOME/rdbms/bin.

The two script are utlbstat.sql and utlestat.sql.

OR you can load a software called TOAD at www.toad.com.It's free trial for 30 days.

Then post the output of this script and we might take turn to look at the result.

regards
mB
There are three person in my team-Me ,myself and I.