Ah yes, the squashed squirrel demo...
Connor
- Cary Millsap <cary.millsap_at_hotsos.com> 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: Ross.Collado_at_techpac.com
> >
> > 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: ListGuru_at_fatcity.com (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: mgogala_at_adelphia.net
>
> 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: ListGuru_at_fatcity.com (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: cary.millsap_at_hotsos.com
>
> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Mon Oct 27 2003 - 08:14:34 CST
