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

Home -> Community -> Usenet -> c.d.o.server -> SMON Logic?

SMON Logic?

From: Chakravarthy KM Nalamotu <kittu_at_Hawaii.Edu>
Date: 1997/05/05
Message-ID: <5kkktd$gg4@news.Hawaii.Edu>#1/1

Hi Oracle Users,
Was wondering why SMON requires pctincrease to be > 0 to coalesce tablespaces?
Wouldn't it be convenient to use pctincrease 0 and still have SMON coalesce the tablespaces. This way all the extents are uniformly sized.

Also, is it true that SMON coalesces only the first 5 datafiles and ignores the rest?

Thank you for your replies.
  Kittu. Received on Mon May 05 1997 - 00:00:00 CDT

Original text of this message

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