Questions to ask:
* Blocksize of file system
* Type of file system (not RAID5 !!)
* Type of data
* Size of data
* Number of tables / indexes
* High hit tables for read / write
* Static / control tables
* Machine type
* Replication / 2phase commit
Once you know this, under V9, you can arrange you areas, BI, AI and tables within these to spread the load of the database across disks. I'd suggest you go and take a look through either this site or the PEG (
www.peg.com) {Thats not a bad thing to say is it??} and read through some other DBA posts.
Murray
