Re: TABLESPACES WITH DATAFILES "AUTOEXTEND ON " and TABLES with UNLIMITED EXTENTS

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 07 Dec 1998 18:37:06 +0800
Message-ID: <366BAFD2.7766@bhp.com.au>

Suzanne Fudge wrote:
>
> Is anybody out there in production with an ORACLE Database with Datafiles
> with AUTOEXTEND on and UMLIMITED extents on Tables/Index Objects? What
> version? OS? Any problems? Are we nuts for using it?
>
> Suzanne (Oracle 7.3.3.4.0 on OpenVMS 7.1)
> sfudge_at_newfoundlandpower.com

Just because the feature exists doesn't particularly mean that you should be out there using it...Going for AUTOEXTEND ON and UNLIMITED extents could be interpreted as having little or no knowledge about the use/growth/design/performance of your database...

You may get lucky and have files autoextending rarely, and database segments in manageable number of extents (say less than 20-50)...But you may also be unlucky at end up with a disks running out of space and the wrong time, tables in 100's or 1000's of extents (with possible performance degradations either directly due to extent sizes/numbers or indirectly thru uet$...)

I really think you'd be better off putting in the time to at least get a reasonable idea on how your objects will grow/shrink etc and size accordingly...

Cheers

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Mon Dec 07 1998 - 04:37:06 CST