Re: To autoextend or not to autoextend - that is the question

On 7 Nov 2005 19:19:07 -0800, "Noons" <wizofoz2k_at_yahoo.com.au> wrote:

>
>pinupgeek wrote:
>> My take on this is , yes by all means, use autoextend when applicable
>> but always use the maxsize parameter set to something less than your
>> total available physical diskspace ( for that tablespace/datafile)
>
>and make the next extension size something reasonable, not 10Mb!

the default is 1 block. I actually had such a tablespace once at a customer.
You don't want to know how it performed. It was a DMT too!

--
Sybrand Bakker, Senior Oracle DBA