Ah yes, the squashed squirrel demo... Connor
--- Cary Millsap <[EMAIL PROTECTED]> wrote: > You mean "make your PCTINCREASE 0 so that SMON will > *not* coalesce > them." Right? Some comments: > > - You don't want SMON coalescing your tablespaces. > It is a complete > waste of time. Oracle coalesces on demand during a > CREATE statement. > - The SMON coalesce feature was added under protest > by the smart people > in Server Technologies development, in response to > pressure from > Marketing and Support so that the Oracle RDBMS would > look better in > brochures. > - Thank goodness the developers made SMON smart > enough to *not* coalesce > freespace in any tablespace with PCTINCREASE set to > 0 (which is what it > *should* be set to almost everywhere). > - You can turn off SMON's ridiculous CPU-consuming, > lock-holding > behavior by setting event 10269. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Performance Diagnosis 101: 10/28 Phoenix, 11/19 > Sydney > - SQL Optimization 101: 12/8-12 Dallas > - Hotsos Symposium 2004: March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > Mladen Gogala > Sent: Sunday, October 26, 2003 8:09 PM > To: Multiple recipients of list ORACLE-L > > Well, having in mind that you're working on version > 7 (chuckle) , you > should > make your tablespaces have PCTINCREASE 0 (alter > tablespace default > storage...) > so SMON will coalesce them. You may also try (I'm > not sure whether this > has > existed before 7.3) with alter tablespace coalesce, > which should mark > the > tablespace to be coalesced by SMON at he first > opportunity. I'm afraid > that > PCTINCREASE 0 is your best option. > > On 2003.10.26 20:04, Ross Collado wrote: > > Hi, > > For those like me still working on an Oracle 716 > (hold the laughs), > how do > > we coalesce a tablespace? > > Rgds, > > Ross > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Ross Collado > > 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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Mladen Gogala > 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). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Cary Millsap > 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). ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "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" ________________________________________________________________________ Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
