Re: maximum initial extent size

From: David F. Newman <buzzwang_at_localhost.localdomain>
Date: Thu, 27 Jan 2000 02:34:16 GMT
Message-ID: <86g0vks0j8.fsf@localhost.localdomain>

Mohamed Buhari <mbuhari_at_assigncorp.com> writes:

> Try to create a 3GB flat file at os level. You will know !
>
> You can try this "mkfile" command at OS level to find out its max file size
> capacity :-). In solaris 2.6 , I am pretty sure its 2GB!!!!!. Actuly Sol 2.6
> is partialy 64 bit depending upon the hardware
>

[kamehameha] By your command% uname -a
SunOS kamehameha 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-Enterprise [kamehameha] By your command% mkfile 3072m test.dbf [kamehameha] By your command% ls -l test.dbf -rw------- 1 dnewman dba 3221225472 Jan 26 21:11 test.dbf

3221225472 bytes / 1024^3 = 3G

SQL> select bytes from v$datafile where file#=12;

     BYTES

---

7516192768

That would be a 7gig file. So it looks like my extent problem remains an Oracle limitation.

--
David F. Newman
Oracle DBA
buzzwang_at_ourvillage.com Received on Wed Jan 26 2000 - 20:34:16 CST