Re: LMT monitoring

Sounds like you are using LMTs with system allocation - wait until you get to LMTs with system allocation and ASS management.

Your problem is one of my favourite reasons for sticking to LMTs with uniform extent management. (see www.dbazine.com for an article wrote on LMTs).

There is something on my website about
checking the blocks above the HWM and
blocks on "the" free list on my website, based on a function call to dbms_space.unused_space (or some such) - which I once used as a basis for predictive monitoring - but this won't work with ASSM, or with multiple freelists/freelist groups as it stands.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____UK_______April 8th
____UK_______April 22nd

____USA_(FL)_May 2nd

Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 10 March 2003 14:28

> I have been reading some docs on free space etc., but I have not yet
found
> any conclusive document on how to monitors tables/indexes in LMT
environment
> so that we could *predict* when a segment would not be able to
allocated
> extent.
>
> Basically we want to monitor, when we needs to add more space to a
> tablespace, at-least 1 day before we get error messages. Devl team
doesn't
> always tell us before dataload (it happens, and now they have been
warned).
>
> I believe this is little bit complex compared to dictionary managed
> tablespaces, as (in auto allocate mode), there is no fixed published
formula
> for next extent ...
>
> Any ideas? TIA
> Raj
> -------------------------------------------------------------
> Rajendra dot Jamadagni at espn dot com
> Any views expressed here are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !!
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).