I haven't checked it recently, but the attempt to
coalesce used to occur every 5 minutes; but
every 2 hours and 5 minutes (every 25th cycle)
smon would also look for temporary segments
that were due to be freed. Newer versions of
oracle have introduced new tasks - for example
the MONITOR option on tables is done in memory,
but written to the data dictionary every 3 hours.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Norman Dunbar wrote in message ...
>>> If the default storage of the tablespace is set to 1 or above, oracle
>>> will coalesce contiguous space.
>
>I suspect Stephen means 'if the default storage setting PCTINCREASE is 1
>or more in his reply.
>This will cause SMON to attempt to coalesce free bloocks that are
>contiguous into one large chunk.
>However, it doesn't do them all and it only tries to do it every 2 hours
>(some docs & books I've seen say every 5 mins, Oracle told me that SMON
>wakes every 5 mins but doesn't always do the same things when it wakes -
>you choose !)
Received on Fri Apr 20 2001 - 14:21:53 CDT
