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/ -- //www.freelists.org/webpage/oracle-l