Re: The limit of the unlimited ?

From: koert54 <nospam_at_spam.com>
Date: Sat, 07 Sep 2002 14:58:37 GMT
Message-ID: <xuoe9.106909$8o4.14886@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:58:37 CDT