RE: failed to extent to the next

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? <FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>Joan

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Jacques KilchoerSent:   Thursday, April 05, 2001 5:51 PMTo: Multiple recipients of list   ORACLE-LSubject: RE: failed to extent to the   next
> -----Original Message----- >

  From: Joan Hsieh [<A
  href="mailto:Joan.Hsieh_at_mirror-image.com">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 <FONT
  size=2>> volume transactions going on. He want to detect the
> tablespace can't extent <FONT

  size=2>> 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 Fri Apr 06 2001 - 08:37:57 CDT