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

From: Bjoern Rost <b.rost_at_portrix.net>
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

bjoern

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

portrix.net GmbH
Stresemannstr. 375
22761 Hamburg
HRB 79850 (Amtsgericht Hamburg)
Geschaeftsfuehrer: Knud Alex Mueller, Henning Voss, Niclas Schroeder

http://www.portrix.net/


--
http://www.freelists.org/webpage/oracle-l

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