| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Internals: setting oracle event 10052 -turn off smon from cleaning deleted objects (bug)
Hi:
THis event 10052(Stop SMON from cleaning OBJ$) is most commonly used in OPS/RAC environments to avoid the the so called spinning behavior of SMON and to avoid the ORA-600 (16224).
It is absolutely safe to use this event as it just asks the SMON to skip some of the regular garbage cleaning activities (In this case cleaning up the OBJ$ entries). The only thing you see in your database is the SYS table OBJ$ will be full of garbage's of the entries with non existing tables/object names. You can once in a while restart the database without the event 10052 which cleans up the OBJ$,
Normally SMON does lots of garbage cleaning (!?) during the life cycle of the instance like cleaning the UET$,FET$ (in dictionary Managed Table space databases) in every 5 minutes,SEG$(once in 125 minutes?), Shrinking the rollback segments once in 12hrs unless you set the event 10512 apart from the regular stats update when you set the MONITORING options.
In a short answer, yes.. you can set the event as suggested !!
Best Regards,
K Gopalakrishnan
-----Original Message-----
Rosenthal
Sent: Thursday, November 28, 2002 8:04 AM
To: Multiple recipients of list ORACLE-L
cleaning deleted objects (bug)
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?
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: 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).
--
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 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: 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 Thu Nov 28 2002 - 13:29:50 CST
 |
 |