So, if I have a 200G filesystem and in the future it will expand
I wont have the option to use the whole filesystem ? unless i will
create more datafiles to the tablespace ? ( and this last can only
happen manualy ). ?
>
> 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:55:05 CDT
