Performance issue - Not sure if its disk or some thing - How can I narrow down this

Greetings

Oracle 9i AIX 5L we are using SAN Stroage

I see quite a few SQL in the STATSPACK report with high Elapsed time,

I notice the following:

1. Disk is 100% bussy - topas report
2. sar -d report - Service time is less than 20 msec, disks show 99 to 100% busy
3. STATSPACK Report for file io shows 3 digit numbers for Av rd (ms)
4. STATSPACK Report TOP SQL Shows high Elapsed time. Some of the SQL are doing FTS What other stats should I look at to narrow down the issue

Should I go behind Tuning the Queries or Storage, spreading datafiles across multiple disks.

Apprecaite your thoughts

--

Regards & Thanks
BN

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 04 2007 - 11:13:02 CST