Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Sun, 08 Jun 2003 10:21:06 -0700
Message-ID: <F001.005AD4BD.20030608095920@fatcity.com>


The critical boundary on 32-bit filesystems was 2048M. The problem was (and still is) in the "lseek" function, which accepts "int"

off_t lseek(int fildes, off_t offset, int whence);

In order to move through the files larger then 2GB (1 bit is for the sign), OS needs routines named lseek64 and tell64 which accept 64 bit values. That doesn't necessarily mean that the OS itself is 64-bit. That can be determined by finding sizeof(char *). If the returned number is 8, you are on a 64 system. There are some operating systems which have eliminated the sign and extended that boundary to 4GB, but that causes other problems, most notably with NFS because the other systems, which adhere to the POSIX specification don't know what to do with a 4GB file. One of such OSes was Dynix, may it rest in peace.

On 2003.06.08 12:59 Jared Still wrote:
>
> Just curious how you arrived at the 1900 meg number.
>
> Why not use 2000m?
>
> Oracle defines gigabytes in binary, not decimal as
> drive mfg's do, so 2000m would be fine.
>
> Not a criticism, just wondering.
>
> Jared
>
> On Sunday 08 June 2003 09:29, Yechiel Adar wrote:
> > We have been hit by a bug in autoextend that corrupted a database (8.1.6)
> > on NT.
> > It seems that the bug was exported to Linux as well.
> >
> > We now use all datafiles with autoextend up to 1900 MB.
> > We also define a second datafile with 200MB initial and autoextend to 1900
> > MB.
> > Whenever the last datafile starts to grow we define a new one with 200MB
> > etc.
> >
> > Seems to work so far.
> >
> > Yechiel Adar
> > Mehish
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > Sent: Wednesday, June 04, 2003 5:40 PM
> >
> > > I've just been informed that there is a 2GB datafile size limit with
> >
> > Oracle 8.1.7 on Linux... PERIOD. This despite the fact that we've had files
> > in excess of this for some time and they work just fine. The problem occurs
> > when the autoextend "feature" reaches the 2GB threshhold. Of course, Oracle
> > didn't tell me this until after about 4 days of back and forth testing for
> > them. (There is no such O/S file size limit.) I've reviewed the Linux
> > release notes, the Linux install guide, the Linux admin guide and the
> > contents of $ORACLE_HOME/relnotes and I don't find any such limitation in
> > the documentation. Did I miss it? Can anyone find any such published
> > limitation in the docs? Is this a secret?
> >
> > > Peeved at Oracle... AGAIN,
> > > Steve Orr
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Orr, Steve
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Sun Jun 08 2003 - 12:21:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US