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

Home -> Community -> Usenet -> c.d.o.server -> Re: 2gb filesize, large disks and splitting tablespaces

Re: 2gb filesize, large disks and splitting tablespaces

From: John Morais <jmorais_at_rochester.rr.com>
Date: Sat, 09 Jun 2001 22:22:41 GMT
Message-ID: <RkxU6.2825$3y3.467781@typhoon.nyroc.rr.com>

Oracle Supports to GB files if not running 64 bit OS. If you want to go over 2GB files then you need 64bit OS and 64bit Oracle. If your mount points are under Veritas control you must also enable largefiles for the FS. "Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0106061231.15306c47_at_posting.google.com...
> I want to take back the following words. A 32-bit binary number filled
> with "1" is 4G, not 2G (which is 31 bits of "1"s), and there's too
> much guess work.
>
> Yong Huang
> yong321_at_yahoo.com
>
> yong321_at_yahoo.com (Yong Huang) wrote in message
 news:<b3cb12d6.0106061005.1939af0_at_posting.google.com>...
> > Generally, it's a good idea of using files smaller than 2GB. Think
> > about it. 2G, or 2 x 10 [sup]9, corresponds to a 32-bit number all
> > filled. Even if the mount command says your filesystems have the
> > option largefiles enabled, how about Oracle? If Oracle binary,
> > $ORACLE_HOME/bin/oracle, supports large files (file oracle on
> > Solaris), how about any utility under $ORACLE_HOME/bin? There're too
> > many possibilities, even at OS level (is your OS 64-bit?).
Received on Sat Jun 09 2001 - 17:22:41 CDT

Original text of this message

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