Re: ** identify overloaded file system - and balance the load

From: Bjoern Rost <>
Date: Mon, 05 Jan 2009 13:50:40 +0100
Message-Id: <1231157092.2714.43.camel_at_hermes>

have a look at the dtrace. the dtrace toolkit's iosnoop and iotop might be a good starting point for this


On Sat, 2009-01-03 at 19:01, A Joshi wrote:
> Hi,
> For : OLTP database
> Oracle version : 10G
> OS : SunSolaris
> I am trying to identify file systems with heavy usage. So that I can
> move the load out to file systems with less load. By moving database
> files or creating new heavy usage database files to light load file
> systems. I have sar reports. It has the devices. Next step for me is
> to map to the file systems. Or is there a way/command to get the sar
> to identify per file system instead of devices. I am also trying to
> use statspack but that also goes to the level of files/ tablespaces.
> Some tablespaces have files spread out over different file systems.
> This is my approach. There are over 200 files in the database and very
> difficult to sum them up. Instead if there is something at unix level
> to say which file system is overloaded and which is under loaded :
> that would help to balance it. Thanks for help. If someone has done
> similar work and has better suggestions : please let me know. Thanks

Bjoern Rost

Tel +49-40-39 80 53 - 19
Fax +49-40-39 80 53 - 29 GmbH
Stresemannstr. 375
22761 Hamburg
HRB 79850 (Amtsgericht Hamburg)
Geschaeftsfuehrer: Knud Alex Mueller, Henning Voss, Niclas Schroeder

Received on Mon Jan 05 2009 - 06:50:40 CST

Original text of this message