DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: datafile size limit

  1. 03-01-2002, 06:00 AM #1
    dknight
    dknight is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The platform is Solaris 2.8 and Oracle 8.1.7.1.

    While copying from 8.1.5 to what will be the file system for an 8.1.7 instance, a 2.6 GB datafile ran into the size limit. The friendly Unix SA explained that this can be cured with a largefiles setting an some small changes on Veritas.

    Are there any special parameter settings needed in Oracle to enable datafiles greater than 2 GB?
    David Knight
    OCP DBA 8i, 9i, 10g
    Reply With Quote Reply With Quote
  2. 03-01-2002, 07:26 AM #2
    vijay8282
    vijay8282 is offline Senior Member
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    On UNIX, block sizes usually vary between 2-8K, although larger than 8K is
    possible. Maximum database file size is 2Gb on most 32-bit UNIX platforms,
    though some (AIX, Solaris and HP/UX) now support a larger maximum, usually 32Gb.

    --------------------------
    The Time has come ....
    Reply With Quote Reply With Quote
  3. 03-01-2002, 08:03 AM #3
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Are there any special parameter settings needed in Oracle to enable datafiles greater than 2 GB?
    With NTFS, the datafile size limit is based on the value of DB_BLOCK_SIZE.

    Examples:

    2k block size max= 8GB
    4k block size max= 16GB
    8k block size max= 32GB
    16k block size max= 64GB

    The maximum file size for FAT is 4GB.

    I would never have a file grow more than 1G.

    Reply With Quote Reply With Quote
  4. 03-01-2002, 11:20 AM #4
    dknight
    dknight is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    [QUOTE]Originally posted by julian
    [B]

    I would never have a file grow more than 1G.
    Neither would I. Fortunately, I can blame it on someone else. :-)

    After the Unix SA enabled largefiles, everything is fine.
    David Knight
    OCP DBA 8i, 9i, 10g
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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