Re: SMON and coalescing

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 29 May 1998 20:18:28 GMT
Message-ID: <01bd8b4d$eddf02c0$a504fa80@mndnet>

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 Fri May 29 1998 - 15:18:28 CDT