Re: smon Q?

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 28 Feb 2001 02:50:48 -0800
Message-ID: <F001.002BF5D8.20010228022532@fatcity.com>

Hi !!

• nlzanen1_at_ey.nl 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: kaygopal_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Feb 28 2001 - 04:50:48 CST