Hi !!
--- [EMAIL PROTECTED] wrote:
> Hi All,
>
>
> Last night we were trying to bring down one of our
> databases with Shutdown
> immediate.
> We waited about 20 minutes before we finally did an
> abort.
>
> We found this entry in the alert log "Waiting for
> smon to disable tx
> recovery." before the shutdown abort entry. It looks
> like this was the
> cause for our wait. Does anybody know what this
> means? (The database was
> restarted succesfully in case you're wondering)
>
Hi !
I guess you have very smaller extents or doing more
dynamic space allocation, I have seen this in many
databases. Normally SMON does coalescs (if you call
it) the extents and cleans up the temporary extents
during the shutdown-normal/immediate life cycle.
It will scan the UET$ and FET$ and i think there is an
excellent article in Jonathan Lewis site
(http://www.jlcomp.demon.co.uk) which describes the
entire clean up process. Though it it littel outdated
most of the things still applicabel for the current
versions,.
You can safely ignore the message if you not bothered
too much !!!!
=====
Have a nice day !!
------------------------------------------------------------
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: K Gopalakrishnan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
