General question on tablespace creation
From: Xavier Maillard <xma_at_gnu.org>
Date: Thu, 11 Dec 2008 23:55:16 +0100
Message-ID: <87hc5a5nl7.fsf@gnu.org>
Date: Thu, 11 Dec 2008 23:55:16 +0100
Message-ID: <87hc5a5nl7.fsf@gnu.org>
Hi,
I have a general question about tablespace creation.
Is it better to create a small tablespace auto-extendable to a (defined) maxsize or to create it with a "static" size.
Ex:
alter tablespace foo add datafile 'mydbf' size 10240M autoextend off;
or
alter tablespace foo add datafile 'mydbf' size 1M autoextend on maxsize 10240M;
I tried to find a Note on metalink but failed.
What is your opinion ?
Thank you Received on Thu Dec 11 2008 - 16:55:16 CST