Partitioning & Filesystem Layout

Hi,

I'm hoping someone can shed some light on a problem we're having. We have an 8 disk box that we want to create multiple filesystems for our Oracle DB. We are going to implement partitioning (warehouse db) & striping.

My question is -- if I create 4 filesystems for indexes and 4 filesystems for data (about 6GB each) and then I create my tablespace called "Fct_Data" and create the datafiles across the 4 filesystem -- is that efficient?

My co-worker thinks I should probably create multiple tablespaces (Fct_Data1, Fct_Data2, etc.) instead.

When I'm partitioning the data (range by date), I only say tablespace "Fct_Data" because I think that since I put the datafiles across the 4 filesystems -- I'm ok.

Yes, this is confusing -- sorry for length. Can anybody help me? I'm looking for general opinions/tips.

Thanks,
Tracy

It all depends on how you setup your RAID sets.

You say you have 8 disks. Are you going to create 4 mirrored pairs? Or maybe 1 RAID 5 set? Or 2 0+1 RAID sets?

Will the partitioned data be accessed at the same time or will you only be looking at one partition at a time?

Will most of the database hits be via index reads or full table scans?

We can't really comment until we know more about your setup.

We're using 0+1 Raid.



We're actually using a composite partitioning methodology. We're doing a range by date and then a hash by client. So, we'll be looking at a specific range -- but many clients.



Mostly Index.

thanks!
Tracy

Quote:

---

Originally posted by Tracy

We're using 0+1 Raid.

---

How many filesystems?
How many disks per filesystem?
How many controllers?
Are the disks exclusive for each filesystem or are they shared with another filesystem?

Quote:

---

Originally posted by Tracy

Mostly Index.

---

Are the indexes partitioned? If so, how will you partition them?