Disk Utilization 100%

[Former Member]

Dear friends

We have problems of performance with the system SAP (HP-UX with Oracle 10.2)

The Disk Util is 100% and the GLANCE command shows that the oracleSID process is using a high disk.

The problem is when any process to access to

[Former Member]

Hi

we have similar problem few weeks ago. we are using HPUX 11.23 and Oracle 9.2.0.6.

many reason can cause this problem :

- write process (mainly) -- and read process too,that is not separated to some logical volume (or volume groups) but concentrated in one logical volume (or one volume groups). in this case write process will hit only in one LV ( or VG). to solve this, you must distribute write process into several LVs (or several VGs) so writer process will write evenly to the datafile in several locations. the same way when reading process from several LVs (or VGs) compared with reading in one LV (or one VG).

- bottleneck in your I/O. you must discuss with your hardware vendor and storage vendor, if there is some bottleneck that causing this.

what have happened to us is broken index of the most table we have caused by system restore few weeks before. after we are doing index for suspected tables, our utilization in decreased.

we are using command :

sar -d 5 5

to monitor disk utilization

and maybe nfile parameter (sum of files opened by OS at the same time) is useful to be monitored, using command :

sar -v 5 5

to monitor nfile parameter.

hope it help you

rgds,

Alfonsus Guritno

[Former Member]

Hi,

If possible try to restart the server, few days back I faced the same issue after restarting disk utilization is fine.

Regards,

Prashant