datafile size limit for Oracle 8i on Windows 2000 Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: datafile size limit for Oracle 8i on Windows 2000

  1. #1
    Join Date
    Apr 2001

    datafile size limit for Oracle 8i on Windows 2000

    Does anyone know the maximum size for Oracle 8i datafiles on Windows 2000?

    Thank you.

  2. #2
    Join Date
    Feb 2001

    Re: datafile size limit for Oracle 8i on Windows 2000

    There is no Oracle limit to the file size on W2K. Whether having multiple files will help your performance really depends on the situation. In many cases, users like to split tablespaces into multiple files so they can put the files on different disks and thus distribute the I/O. By the same theory, tables can be striped across disks within these multiple datafiles causing users to access multiple disks.If you are asking about a Win2K limit, it is up in the exabytes.

    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    Thanks and Regards
    Rohit S Nirkhe

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    As a matter of supportability I tend to not create datafiles of more than 2 or 4 Gb -- any bigger than that is just inconvenient to backup and store, or move around between machines or disk arrays. Consider also that when backing up the files of a 20Gb tablespace on a RAID array, you would do better to copy five 4Gb files all at the same time than one single 20Gb file.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  4. #4
    Join Date
    Apr 2001
    What if my datafiles are located across a RAID 5 or RAID 0+1 array? Does it still matter whether I have one big datafile for a tablespace or several smaller ones?

    Also, if I have several smaller files for a tablespace to copy over and I am copying all at the same time, won't that make the files fragmented on the destination drive?


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