Partitioning & Filesystem Layout
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Partitioning & Filesystem Layout

  1. #1
    Join Date
    Apr 2000
    Location
    Boston, MA 01803
    Posts
    24

    Question

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2000
    Location
    Boston, MA 01803
    Posts
    24


    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

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by Tracy

    Mostly Index.
    Are the indexes partitioned? If so, how will you partition them?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width