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 !!
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
