Well,
if next_extent=250m, pctincrease=0. bytes *12 >= next_extent means
dba_free_space must have a (bytes*12) large space to satisfy the condition. But
I want 12 slots >250m, if I get less than 12 slots < 250m, I
will get email. Gee, I am confused myself, am I right?
Joan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques Kilchoer
Sent: Thursday, April 05, 2001 5:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: failed to extent to the next> -----Original Message-----
> From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
>
> 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?
