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

Reply via email to