Re: LOCALLY MANAGED EXTENT PERFORMANCE

>> Doesn't do the job.  This only tells me what the largest extent sizes are
>> for segments.  It does not tell me whether any of them are possible to run
>> out of space within "N" extensions...
> 
> Assuming autoextention on the datafiles, why are you worrying about
> how many extents until you run out of disk space?  It seems to me that
> it now makes more sense to keep on eye on disk space itself.  Unless
> you are trying to run your mountpoints to 99% full or you have small
> mountpoints, ask the sysadmins to set a warning at X% and an alarm at
> Y%.

Autoextension can *postpone* the need for this kind of monitoring, but does
not eliminate it.  Think it through.

It's not a good idea to assume autoextension (or even extensibility) in all
scenarios, whether at the datafile level or at the file-system level.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: