How much should be the data file size..?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How much should be the data file size..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How much should be the data file size..?

    1. I have to create a tablespace of 19Gb size.

    2. How much should be each data file size..? Any guide line documents..?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You'll probably want to spread the i/o across your devices, so the minimum number of files should probably be equal to the number of disk arrays.

    Also, you'll want to keep the data file size manageable should you want to move them around.

    Generally people go for 2Gb or 4Gb -- in your case i would say 4x4Gb + 1x3Gb. Might as wel make is 5x4Gb really.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2002
    Location
    Bangalore
    Posts
    47
    There is no limitation as to what size u'r datafile should be.
    you can have a 19*1 .

    data file size manageable should you want to move them around.
    4GB*5 should be appropriate.

    U should also consider if u'r o/s handles large files without any i/o
    issues.
    Cheers
    Murali

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