| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: The simple "Can I extend" question
Not withstanding that fact that a tablespace being x% full has no
bearing on whether a segment within it will be able to extend, I'm
curious on how the myriad of 3rd party db monitoring tools out there
are planning on coping with system-alloc LMT's.
Considering that system-alloc LMT's are the default in 9i, it reasonable to expect a proliferation of applications that will use them. Interestingly, the current iterations of Oracle Applications uses dictionary-managed tspaces which are then converted to LMT's - I wonder if this has been done to avoid the null NEXT_EXTENT (or whether it was just easier for them to do it this way)
I wholeheartedly agree with your comments for the small set of cases where uniform LMT's can be mandated - which is my original post discounted that scenario from discussion.
Cheers
Connor
"Some days you're the pigeon, some days you're the statue..."
Daniel Morgan <damorgan_at_exesolutions.com> wrote in message news:<3CB34103.2DFFF4C_at_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 Wed Apr 10 2002 - 03:41:59 CDT
 |
 |