Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SMON Logic?
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