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.
Received on Wed Nov 21 2001 - 15:53:57 CST
