Re: The simple "Can I extend" question

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 09 Apr 2002 19:29:11 GMT
Message-ID: <3CB34103.2DFFF4C@exesolutions.com>

I've never asked that question nor had any reason to. I can't conceive of ever letting a tablespace get that full.

I do everything with locally managed uniform extent and I don't like to see more than 80% utilization.

Daniel Morgan

Connor McDonald wrote:

> Just wondering what people are doing out there to answer the question
> "Can segment X take a new extent?"...
>
> Seems easy enough....for segments in a tablespace that is:
>
> 1) Dictionary-managed: xxx_SEGMENTS.NEXT_EXTENT versus DBA_FREE_SPACE
> 2) Converted LMT: ditto
> 3) Uniform LMT: trivial (simple existence check in
> DBA_FREE_SPACE)
> 4) System-alloc LMT: hmmmmmmmmmm
>
> (xxx_SEGMENTS.NEXT_EXTENT is null in (4)
>
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Tue Apr 09 2002 - 14:29:11 CDT