Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SMON and coalescing
Yes RBS' pctincrease should be 0.
CIAO
Suresh Bhat wrote in message <01bd8351$85d59a80$a504fa80_at_mndnet>...
>Hi everyone !!
>
>It has taken about 10 minutes for SMON to CPALESCE badly fragmented large
>tablespace with about 400 meg diskspace. It seems like SMON shares its
>time with other "work" and I noticed fragmentation going down via my script
>and eventually it COALESCED all disk space.
>
>One of the participants in this thread mentioned that SYSTEM tablespace
>would be the first to COALESCE.
>
>I was under the impression that SYSTEM, RBS, TOOLS and any other Oracle
>system related tablespaces should not be coalesced and consequently
>pctincrease for these tablespaces should be 0.
>
>Am I missing something ?
>
>John Vernes <vernes.j_at_consunet.nl> wrote in article
><6ja0pj$3s3$1_at_news.worldonline.nl>...
>> Hello,
>>
>> I have a short question regarding coalescing of tablespaces.
>>
>> As I understand this should be done by the System Monitor (SMON)
>process.
>> Since the SMON comes by every couple of minutes and the coalescing
>doesn't
>> happen is there something I am overlooking??
>>
>> Greetings
>>
>> John
>>
>>
>>
Received on Tue May 26 1998 - 09:39:35 CDT