This may be true but if a uniform extent size policy
(or very close to it) is adopted (or enforced with
lmt's) then there is no need to coalesce anything at
all - even if chunks of free space are contiguous.
hth
connor
- Whittle Jerome Contr NCI
<Jerome.Whittle_at_scott.af.mil> wrote: > The biggest
problem with setting the PCTINCREASE to
> 0 on existing tablespaces is that it won't
> automatically coalesce. You may need to manually
> coalesce occasionally especially if you deallocate
> tables or rebuild indexes. Below is what I use to
> see tablespaces needing coalescing:
>
> select a.tablespace_name, count(a.tablespace_name)
> "ContinguousFreeBlocks"
> from dba_free_space a, dba_free_space b
> where a.tablespace_name = b.tablespace_name
> and a.file_id = b.file_id
> and a.block_id = b.block_id + b.Blocks
> group by a.tablespace_name;
>
> If the number of ContinguousFreeBlocks gets above
> 20, I coalesce. You may chose a different number
> depending on the size of your tablespaces.
>
> Jerry Whittle
> ACIFICS DBA
> NCI Information Systems Inc.
> jerome.whittle_at_scott.af.mil
> 618-622-4145
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Whittle Jerome Contr NCI
> INET: Jerome.Whittle_at_scott.af.mil
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
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: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Feb 07 2002 - 03:09:52 CST
