Hi.. we are several months away from upgrading to 8.1.7.4 from 8.1.7.1 to resolve several oracle bugs including smons behavior of crashing when cleaning up oracle space from deleted entries in the obj$ table. In the meantime, Oracle suggested we set the 10052 event to turn of Smon from performing obj$ space cleanup.
We are a four node ops cluster (HP), 3 oltp and 1 batch. Questions: 1)What kind of entries are cleaned up. 2)Is there a danger to extent management in the obj$ table of "deleted but no cleaned up entries". 3)Is it reasonable to just shut down one node once a week, restart it for 20 minutes with smon enabled during our maintenance window and restart with 10052 re-enabled? 4)Any suggestions, pointers, or folks with bad experiences using this event? __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas Rosenthal INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
