Re: Space Management w/ LMTs

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 13 Apr 2005 15:52:33 GMT
Message-ID: <425d3fb8.1273905569@localhost>

On Mon, 11 Apr 2005 21:12:04 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>On Mon, 11 Apr 2005 19:04:56 GMT, netcomradeNSPAM_at_bookexchange.net
>(NetComrade) wrote:
>
>>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.
>
>Does the word 'Autoextend' tell you anything? Make sure available
>diskspace is monitored and you are done.

Autoextend is not currently feasible.. Some databases still use QIO, which requires file pre-creation, plus there are multiple databases on multiple mount points, and autoextend discourages you from making sure database growth is in line with projections.

Thanks,
.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Apr 13 2005 - 10:52:33 CDT