Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Space Management w/ LMTs

Re: Space Management w/ LMTs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Apr 2005 23:30:26 +0200
Message-ID: <krtd51lqipbemkuk39dgc7lavb1oc7s71u@4ax.com>


On Fri, 08 Apr 2005 21:15:27 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>I don't think I displayed confusion over fragmentation, but thanks..
>
>But as you pointed out, as tablespaces grow, you still need to know
>how much space you have left in them, and with uniform extents you
>might want X extents to be available, with dictionary tablespaces your
>criteria must be different.. hece the query i posted earlier.
>
>-a

I'm not sure why you insist on topposting. Do you want to be ignored in the future?

Your issue is a non-issue. It would be only an issue with autoextend off.
It also a non-issue because you can use OEM to monitor free space, and set thresholds.
Why re-invent the wheel?

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Apr 08 2005 - 16:30:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US