From Joan.Hsieh@mirror-image.com Fri, 06 Apr 2001 06:37:57 -0700 From: "Joan Hsieh" Date: Fri, 06 Apr 2001 06:37:57 -0700 Subject: RE: failed to extent to the next Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: 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?   Joan -----Original Message-----From: root@fatcity.com [mailto:root@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 [mailto:Joan.Hsieh@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?