John R Pierce wrote:
certainly are. The database adminstrators will spend hours pouring over IO logs and database statistics in order to better optimize the distribution of tables and indicies across the available tablespaces.
Didn't realise Oracle was that primitive. One should just balance all the tablespaces out over multiple volumes and or controllers and add table partitioning as needed. Transaction filesystem is a striped filesystem over the same raid/volumes.
Then if you need more I/O bandwidth you just add more controllers and disks. No need to dick around with "put that table there and that here", that is just counter productive.
With a proper setup you would then engange all disk arms you have available for the I/Os you need and you basically remove hotspot management.