Re: Extent sizes in LMT

why not modify your nightly script for this object to report when the object will fail to allocate another 5 extents? or 10 extents?

yoy could create a script that monitors actual space usage (not just allocated). you could schedule this to run on a regular basis and keep a running history of space usage/allocation data, and then use that to extrapolate (forecast) extent failures.

"Chuck Hamilton" <chuck_hamilton_at_hotmail.com> wrote in message news:9fgc8d$3r188$1_at_ID-85580.news.dfncis.de...
> In a locally managed tablespace with uniformly sized extents, is there any
> way to specify a next extent size for objects in the tablesapce?
>
> Why would I want to do this? I have a nightly script that reports on
 objects
> that will fail to allocate their next extent. I want the extents to be
 large
> enough so that I get a week of advance warning before failure occurs. One
> table's growth rate was severly underestimated and now I'm stuck with 10m
> extents on a 10g table that's growing at 11m per day. The table is
 receiving
> inserts 24x7 and needs to be available continuously. Any suggestions would
> be appreciated.
> --
> If at first you don't succeed, skydiving isn't for you!
>
> Chuck Hamilton
> chuck_hamilton_at_hotmail.com
>
>
>
Received on Mon Jun 04 2001 - 23:19:05 CDT