topic Re: Performance issue in Operating System - HP-UX

Performance issue

xcvzxvzxdv — Mon, 15 May 2006 01:17:07 GMT

hello,
I need help from one of u expert. Its simply that the time taken by a database file is more on one volume than on other. I am unable to figure out from where shall i start with.

Re: Performance issue

Frank de Vries — Mon, 15 May 2006 01:39:38 GMT

Some disks are more busy then others.
A matter of getting an idea of the disk i/o
on your system.

First check the volumes then the datafiles.

The volumes are they local in your machine, or do they reside on a external disk system or SAN ?
If local you can monitor with sar -d
if on a SAN use the performance diagnostics for that system.

For the datafiles you can use Oracle performance pack to see how many blocks write/read are done by each tablespace
and datafile to see the usage.

Re: Performance issue

xcvzxvzxdv — Mon, 15 May 2006 02:12:32 GMT

it is residing on SAN. and it is a staredge 3510 Array box. Other volumes belong to EVA 3000 of HP

Re: Performance issue

Steven Protter — Mon, 15 May 2006 02:56:00 GMT

Shalom,

http://www.hpux.ws/system.perf.sh

One of the scripts in the link above will identify the bottleneck disk. This will enable you to re-arrange the SAN and improve overall input/output.

SEP