Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2009
    Posts
    46

    Unanswered: How large can a Datafile be??

    Dear Support,

    I would like to seek some clarifications as a matter of urgency:

    Database version is Oracle 10gR2 (10.2.0.1.0)
    and Server is Windows Server 2003 R2

    The issues I seek clarification on are:

    1. How large can my datafiles be (can it be greater than 2GB )

    2. Can a datafile that is not configured to Auto extend be Redone to Enable autoextend after it has reached 2GB?
    If so, how can it be done?
    3. Does windows platform has any limitations on Datafile size and autoextend enabled?

    Any assistance is very much welcome
    FoKwame

  2. #2
    Join Date
    Mar 2009
    Posts
    46

    How large can a Datafile be??

    Dear Support,

    I would like to seek some clarifications as a matter of urgency:

    Database version is Oracle 10gR2 (10.2.0.1.0)
    and Server is Windows Server 2003 R2

    The issues I seek clarification on are:

    1. How large can my datafiles be (can it be greater than 2GB )

    2. Can a datafile that is not configured to Auto extend be Redone to Enable autoextend after it has reached 2GB?
    If so, how can it be done?
    3. Does windows platform has any limitations on Datafile size and autoextend enabled?
    4. Which is better? 1. To add additional datafiles or
    2. To Enable autoextend and allow one datafile to grow very big (perhaps >5GB or >10GB??


    Any assistance is very much welcome

    FoKwame

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Your questions are partially answered in Physical database limits document.

    The rest - I wouldn't know, I'm not a DBA.

  4. #4
    Join Date
    Sep 2003
    Location
    Columbia, MD USA
    Posts
    95
    32GB is the max data file size in your situation.

    And yes, you can set a data file to auto extend after it has reached the limit that was set previously.
    drew
    ------------------
    http://wjtechnologies.com

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by Littlefoot View Post
    Your questions are partially answered in Physical database limits document.

    The rest - I wouldn't know, I'm not a DBA.
    To answer the other part:
    3. Does windows platform has any limitations on Datafile size and autoextend enabled?
    Just make sure "largefiles" is enabled.

    4. Which is better? 1. To add additional datafiles or 2. To Enable autoextend and allow one datafile to grow very big (perhaps >5GB or >10GB??
    I prefer the "Divide and Conquer" approach (multiple small files, perhaps <= 32G)
    This because with rman the minimum size of a backup file would be the size of the largest data file.
    If you have just a few large data files, then the rman parallel threads are also limited and consequently the backup will take more time.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by drew View Post
    32GB is the max data file size in your situation.

    And yes, you can set a data file to auto extend after it has reached the limit that was set previously.
    Wow, didn't know 32GB was the max file size on WinDoze 2003?

    Can you confirm this? Please post a link...

    Thx.

    PS: I don't do windoze.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by drew View Post
    32GB is the max data file size in your situation.

    And yes, you can set a data file to auto extend after it has reached the limit that was set previously.
    Only true for an 8K block size. If you increase the block size to 16KB a single datafile can be 64GB: Oracle Database Specifications for Windows


    Wow, didn't know 32GB was the max file size on WinDoze 2003?
    The 32/64GB limit is an Oracle limit (and will probably apply to other OS as well due to the limit on the number of blocks)

    The maximum size of a single file in NTFS is 16 Exabyte

  8. #8
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs up Clear as mud...?

    Quote Originally Posted by shammat View Post
    Only true for an 8K block size. If you increase the block size to 16KB a single datafile can be 64GB: Oracle Database Specifications for Windows


    The 32/64GB limit is an Oracle limit (and will probably apply to other OS as well due to the limit on the number of blocks)

    The maximum size of a single file in NTFS is 16 Exabyte
    Thanks for the clarification...
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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