very slow performance of oracle

[Pulse001]

No oracle is not installed in vg00, it is on /u01. That is why it is even more baffling to understand why io to root disk is very high.

[Pulse001]

I am attaching the captured logs here

[Pulse001]

Logs of top command attached herewith, captured during peak load.

[Pulse001]

Hi,

I have installed Glance now. I can check io to vg00 (for individual LV's e.g /tmp). Let me check the io now and i will sit with DBA to check file locations.

[Pulse001]

.

[TwoProc]

Ask your DBA to review his statspack data, it will clearly list the largest I/O offender queries that are running in the system. You need to start there.