Thanks a million :)
In article <tvoe9.106911$8o4.14887_at_afrodite.telenet-ops.be>, koert54 wrote:
>>> 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 - 15:18:15 CDT
