Re: SMON and coalescing

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Thu, 04 Jun 1998 15:56:21 GMT
Message-ID: <01bd8fe0$e5c9dd20$a504fa80@mndnet>

That is precisely what it does. If you properly size your tables with initial and next extents, then Oracle will find the CONTIGUOUS free space for the next extent. If you monitor tablespaces for large tables then you can alter the next extent for those tables to fit into the coalesced contiguous space. The need
for frequent defragmenting via export/import is less.

Suresh

Peter Broadfield <GBH3R4BR_at_IBMMAIL.COM> wrote in article <6l1asi$dmg1_at_extnews.sunalliance.com>...
> Mark,
> Sorry but the answer is No.
> Coalescing will only join together to adjacent chunks of 'free space' to
> make one bigger chunk of 'free space'. The tables themselves will not be
> affected so you will still have to defragment them.
> --
> Regards Pete
> Mark Gornicki wrote in message <3570D006.6EC1_at_netcomuk.co.uk>...
> >hi
> >
> >excuse my ignorance but is 'coalescing' defragmenting the tablespace,
> >thus no longer requiring export/import?
> >
> >thanks,
> >Mark
> >
>
>
>
>
Received on Thu Jun 04 1998 - 10:56:21 CDT