Re: Space Management w/ LMTs

On Fri, 08 Apr 2005 23:30:26 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

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

Not everyone has Enterprise license.. unless OEM comes with standard now. I am not sure what you mean that my issue is not an issue, besides no fragmentation in LMT, tables still need to grow and still need space in tablespaces for growth.

-a

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Apr 11 2005 - 14:04:56 CDT