sar disk statistics shows high avserv time

[Fenil Manek_4]

Hi all,

My daily sar output for disk stats
shows high avserv time for a particular disk.

Can you suggest us some solution?

Beocz some of the important tables which are read only lies on this disk.

IF some has understanding of oracle then for them I want to tell them that entire tablespace
of 4GB lies on this disk.

Regards
Fenil MAnek

[Massimo Bianchi · Accepted solution]

Hi,
it seems your disk is reaching its maximum trhougput.


Solution.... hard to say.


On that disk resides both data and indexes ? Maybe moving the indexes away can help.

Are you using LVM and mirroring ? if so you could think of striping the content of the lvol across multiple disks, to maximize performances.


Are your statistics up-to-date ? The troughput is quite high, like if there are many full table scan. Try analyzing with compute statistics the objects in the tablespace.



If the tables are really read-only, is it acceptable to enlarge the SGA to let the
blocks being cached?


May be creating new indexes could also help.

HTH,
Massimo

[Fenil Manek_4]

Thanks a lot sir we have table and index lie on the same disk.

Regards
Fenil Manek