Re: LOCALLY MANAGED EXTENT PERFORMANCE
- From: Tim Gorman <tim@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Apr 2005 11:28:52 -0600
>> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
