Re: SMON and coalescing

hi

excuse my ignorance but is 'coalescing' defragmenting the tablespace, thus no longer requiring export/import?

thanks,
Mark

Suresh Bhat wrote:
>
> Yes I have confirmed this with several tests. It works for table and index
> tablespaces. But I have noticed that index tablespace sometimes may not
> get COALESCED cannot confirm this since I am now testing this on the
> production data base.
>
> Later !!!
>
> suresh.bhat_at_mitchell-energy.com
>
> aa <aau_at_interlog.com> wrote in article <6kd97d$2ii$1_at_news.interlog.com>...
> > According to "Advanced Performance Tuning" from Oracle Press, to enable
> > automatic coalescing by SMON you must set pctincrease as follows:
> >
> > Tablespace level pctincrease = 1
>
> >
> > (Can someone confirm this?)
> >
Received on Sat May 30 1998 - 22:35:34 CDT