Has anyone experienced the following scenario in 9.2 dbs running Automatic Undo?
1) A large (500+) number of undo segments have been created. 2) SMON is offlining a significant portion (100+) of them. 3) The database begins recording ORA-00600 and ORA-07445 errors (additional fields not identical) 4) Instance crashes (may not record termination in alert log). I am wondering if there is an issue with AUM and a large number of segments. Any thoughts, experiences, etc. are greatly appreciated. Daniel Fink
begin:vcard n:Fink;Daniel x-mozilla-html:FALSE org:Sun Microsystems, Inc. adr:;;;;;; version:2.1 title:Lead, Database Services x-mozilla-cpt:;9168 fn:Daniel W. Fink end:vcard