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 -----------------------------------------------------------------