Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Coalesce Free Space

Re: Coalesce Free Space

From: Kevin A Lewis <Kevin_A_Lewis_at_Hotmail.com>
Date: 2000/06/29
Message-ID: <FOH65.13$7R.1829@newreader.ukcore.bt.net>#1/1

There are no downsides that I am aware of.

Only upsides

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
<thiko_at_my-deja.com> wrote in message news:8jf0p0$r7c$1_at_nnrp1.deja.com...

> Hi
>
> I have queried this on our database:
>
> SELECT tablespace_name, total_blocks,
> blocks_coalesced, percent_blocks_coalesced
> FROM dba_free_space_coalesced
> WHERE percent_blocks_coalesced<>100;
>
> and have found that yes we do have adjacent free extents in the
> database. I now would like to issue this command to coalesce them:
>
> ALTER TABLESPACE <tablespace_name> COALESCE;
>
> I would like to know what the down side (if any) of doing this is.
> Especially if it is quite a large database. e.g will anything become
> unavaliable, will things slow down? Is it a good idea?
>
> Thanks
>
> Thiko!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 29 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US