Raj
Are you using autoallocate or uniform extents. If you are using
autoallocate, wouldn't uniform extents make your task easier?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, March 10, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L
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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
