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.