Re: Question about tablespace datafile setup

From: Brian Wheeler <brian.wheeler_at_iname.com>
Date: Sun, 23 Jan 2000 06:21:15 GMT
Message-ID: <388A9B9D.D22C5DEA@iname.com>

Depends, especially on the number of spindles (disks) that you have on your system. Even if you are using RAID-5, the more virtual devices, the better, for I/O balancing.

At a minimum, put your index tables in a tablespace on one disk and your data tables on another disk. Put your redo files on a separate NON-RAID disk, and your rollback segments on a separate disk as well.

I prefer small tablespaces and lots of smaller disks. I can balance the I/O of the database this way by moving hot tables to separate disks. Received on Sun Jan 23 2000 - 00:21:15 CST