Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do you know when to add space to tablesapce?
Most segments are more than 1 extent, and you would likely monitor their growth trend. I have no need to know how close any of my segments are to extending - but I can predict it through analyzing the trend. But I never need to, because...
I just have a cron job that will detect any segments that are likely to fail if they extend twice. By appropriately sizing next_extent, I can guarantee that I'll know about impending doom well in advance because no segment will extend twice in one day... consequently, I run most tablespaces pretty near to full most of the time.
"Robert Yeh" <robert.yeh_at_qwest.com> wrote in message
news:9gvgot$9fp$1_at_bob.news.rcn.net...
> So you guys do not consider how much space within an allocated segment has
> been used either.
> Like what I said earlier, you might have a large extent with no records in
> it. How do you count for that?
>
>
>
Received on Fri Jun 22 2001 - 10:33:32 CDT