RE: failed to extent to the next

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 05 Apr 2001 14:00:54 -0700
Message-ID: <F001.002E338F.20010405135114@fatcity.com>

> -----Original Message-----
> From: Joan Hsieh [mailto:Joan.Hsieh_at_mirror-image.com]
>
> I used to use this script detect the tablespace fail to
> extent to the next
> and sent email to me everyday. It works fine. However, the
> other dba think
> next extent is not good enough to get quick responds since we
> have so much
> volume transactions going on. He want to detect the
> tablespace can't extent
> to the next 12 extents. I tried couple ways, (bytes * 12)
> but that result
> not 100% correct. Thanks in advance if someone can share your ideas.

What do you mean by "not 100% correct"? How do you know? Have you considered the pct_increase factor for the next_extent? Received on Thu Apr 05 2001 - 16:00:54 CDT