Re: Extents

Kevin McDaniel wrote:
>
> Please help me understand something: How is it not important to know
> WHEN or HOW OFTEN an extent is thrown? It seems that a DBA's focus is
> on how many extents and the size of the next extent. But when trying
> to decide if you need to adjust the next extent (in order to minimize
> the total number of extents for a segment), doesn't one need to now
> how often or at least when the segment extends? I've tried looking
> for a value being captured in the DBA_ views but no luck. I'm still
> "green" as a DBA, so I realize I may be overlooking something, or
> heading down the wrong path on this issue. But I'd certainly
> appreciate someone correcting me if I am wrong. I can't seem to find
> any information on this issue, which leads me to believe I'm chasing
> my own tail.

What you want is (on a per tablespace basis) identically sized extents. This is easiest to do with locally managed tablespaces.

After that, it really doesn't matter how many extents you have. If anything, more extents gives you greater granularity at trending the growth of the segments in the database.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."