Re: The limit of the unlimited ?

>> max of 2^10 datablocks = 4194304

should be 2^22

"koert54" <nospam_at_spam.com> wrote in message news:xuoe9.106909$8o4.14886_at_afrodite.telenet-ops.be...
> The maxsize of a datafile is limited by the structure of the DBA
 (datablock
> address)
> and the blocksize (unless ulimit is hit first)
> Typically :
> - the dba is 4 bytes
> - 10 bits represent the filenumber (oracle/platform specific)
> - that leaves 22 bits for the blocknumber
> thus a datafile can have a max of 2^10 datablocks = 4194304
>
> So blocksize of
> 2K -> max of 8GB
> 4K -> 16GB
> 8K -> 32GB
> 16K -> 64GB
>
>
> "Roye Avidor" <att_at_internetdollar.com> wrote in message
> news:slrnank3hn.dt4.roya_at_www.attbi.com...
> > Hi all,
> > I installed Oracle 9.2.0 on linux ( RedHat7.3).
> > This release of linux can create very big files.
> > When I'm create a tablespace an sets the maxsize
> > to unlimited, I'm getting in the dba_data_files
> > a maxsize of 16G.
> >
> > Is this the limit that 9.2.0 can handle ?
> >
> >
> > Thx,
> > Roye Avidor
> >
> >
>
>
Received on Sat Sep 07 2002 - 09:59:37 CDT