Re: LOCALLY MANAGED EXTENT PERFORMANCE

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 26 Apr 2005 11:28:52 -0600
Message-ID: <BE93D674.266A3%tim@evdbt.com>

>> 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

Received on Tue Apr 26 2005 - 13:33:33 CDT