I do a similar thing. I run a weekly report producing a file that excel can open. I include a "Warning" message in the email header if any tablespace is more than 80% full. With LMT, I don't need to worry about individual tables any more - if there is room within the tablespace, then any table will be able to grab a new extent. Tom Mercadante Oracle Certified Professional -----Original Message----- From: ryan.gaffuri@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx] Sent: Wednesday, February 11, 2004 8:28 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: RE: LMT ASSM & next extent is there a practical need to do that? I typically just turn autoextend on for all my files and have code that monitors the bytes in all my segments in a tablespace vs. the size of the datafile and I get an email if its close to filling up or if the datafile extends. is there a need for a more comprehensive approach? > > From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx> > Date: 2004/02/11 Wed AM 07:26:20 EST > To: <oracle-l@xxxxxxxxxxxxx> > Subject: RE: LMT ASSM & next extent > > no. > > But if you are saving (err... exporting) dbms_stata output ... I can = > give you a SQL that will show you storage allocation pattern ... > > Raj > -------------------------------------------------------------------------= > ------- > Rajendra dot Jamadagni at nospamespn dot com > All Views expressed in this email are strictly personal. > QOTD: Any clod can have facts, having an opinion is an art ! > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jack van Zanen > Sent: Wednesday, February 11, 2004 7:18 AM > To: 'Oracle-L Freelists' > Subject: LMT ASSM & next extent > > > Hi=20 > > I have my script that will monitor for objects that can not allocate = > their > next extent. However on databases using LMT with autoallocate I do not = > have > a value for next extent. How can I get this figure anyway, or is their a > view that will give me the space bound objects? > > > Tia > > > Jack > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------