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

  • From: Bjoern Rost <b.rost@xxxxxxxxxxx>
  • To: ajoshi977@xxxxxxxxx
  • Date: Mon, 05 Jan 2009 13:50:40 +0100

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


Other related posts: