Re: General question on tablespace creation

"gym dot scuba dot kennedy at gmail" <kennedyii_at_verizon.net> writes:

> "Xavier Maillard" <xma_at_gnu.org> wrote in message
> news:87hc5a5nl7.fsf_at_gnu.org...
>> Hi,
>>
>> Is it better to create a small tablespace auto-extendable to a (defined)
>> maxsize or to create it with a "static" size.
>>
>> What is your opinion ?
>>
>> Thank you
> It depends. One compromise is to have it autoextend in chunks up to a
> maximum. For example:
> alter tablespace foo add datafile 'mydbf' size 100M autoextend on next 50M
> maxsize 10240M;
>
> If you are going to use autoextend then I would extend in good sized chunks.
> (perhaps 100M not 50M) I wouldn't create 1 M pieces at a time. The
> disadvantage of autoextend is if you run out of room in the OS. You could
> have 10 files on that mount point and if they all tried to autoextend and
> the combined max was larger than the mount point you have a problem.
>
> On the other hand, if you are using a backup method instead of rman you have
> to back up a whole static file - even if it has very little data in it.)

Thank you very much for these crystal clear explanations. I think I will use the latter rule: create the tablespace to its maximum size.

Xavier Received on Sat Dec 13 2008 - 01:39:16 CST