Performance issue - Not sure if its disk or some thing - How can I narrow down this
From: BN <bnsarma@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 4 Dec 2007 12:13:02 -0500
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
