-
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.
Jeff Hunter
-
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
-
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?
Jeff Hunter
-
Originally posted by Tracy
Mostly Index.
Are the indexes partitioned? If so, how will you partition them?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|