Re: Creating multiple tables within a tablespace

Jeff,

In addition to the other reactions posted here, I'll give you some clues. You pointed out the main advantage in clustering tables per tablespace: easier to maintain. For clustering you should look at the I/O pattern of the database. If some tables are much more accessed then others, don't combine them in one tablespace, but spread them over different tablespaces/disks. Same reason for storing your index-data apart from your table-data. Look at your datamodel for combining the tables. For example combine your invoice-table with the invoice-detail table in one tablespace. You will use the cache more efficiently that way.

You should look at the Oracle Performance Tuning book of O'Reilly & Associates for further clues on database-tuning.

regards,
Guus van de Sande  

 What are the compelling
> advantages of having multiple tables per tablespace when
> most of our tables are of this magnitude.
>
> Kindest Regards,
> Jeff Hunter
Received on Tue Feb 24 1998 - 00:00:00 CST