The EXTENT_MANAGEMENT column tells you if they are locally managed or not. If they are local, then the ALLOCATION_TYPE will be either UNIFORM, SYSTEM or USER. The latter means it was originally a dictionary managed tspace that has been converted to lmt.
But in any event, the coalesce is just extra work for no gain hth connor --- "Markham, Richard" <[EMAIL PROTECTED]> wrote: > Thanks for the info Igor. In addition to this I am > curious of how to > determine that a given TS's extents are UNIFORM. > dba_tablespaces shows > allocation_type of user for a known UNIFORM TS. TIA > > -----Original Message----- > Sent: Monday, December 16, 2002 1:30 PM > To: Multiple recipients of list ORACLE-L > > > Richard, > > If you are using UNIFORM extents (which is usually > the best option), you > don't need to do any coalescing on LMTs. > > Igor Neyman, OCP DBA > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > > > ----- Original Message ----- > To: Multiple recipients of list ORACLE-L > <mailto:[EMAIL PROTECTED]> > Sent: Monday, December 16, 2002 1:00 PM > > > ok. They are LMT's with PCTINCREASE 0. I'm running > 8.1.7.4 and > I believe that SMON requires PCTINCREASE > 0 to do > routine > coalescing.........perhaps you have further to add > to your post. > > > -----Original Message----- > ] > Sent: Monday, December 16, 2002 12:00 PM > To: Multiple recipients of list ORACLE-L > > > The obvious question being why you are coalescing > tablespaces.... > > --- "Markham, Richard" > <[EMAIL PROTECTED]> > wrote: > Is it possible to suppress successful DDL > within the > > alter log? > > For example, I have a cron job that coalesces 300+ > tablespaces > > which creates a couple line entry for each. I > would > > like to > > get feedback only if the DDL has actually failed. > > > > TIA > > > > ===== > Connor McDonald > http://www.oracledba.co.uk > <http://www.oracledba.co.uk> > http://www.oaktable.net <http://www.oaktable.net> > > "GIVE a man a fish and he will eat for a day. But > TEACH him how to fish, > and...he will sit in a boat and drink beer all day" > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > <http://uk.my.yahoo.com> > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > <http://www.orafaq.com> > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > <http://www.fatcity.com> > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in the > message BODY, include a line containing: UNSUB > ORACLE-L (or the name of > mailing list you want to be removed from). You may > also send the HELP > command for other information (like subscribing). > > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
