Both ORA-600 and ORA-7445 are so generic that quoting them without the first parameter is not meaningful. In square [brackets], the first parameter defines the kernel code/position/function which raises this error, subsequent parameters (if not blank) define what it is not happy with. Even if the parameters are not identical, there is usually a pattern - the real cause, ie the initial ones, and a bunch of subsequent red-herrings, eventually leading to an instance crash.
You have associated AUM with these errors, of which you may be right.But this is something that needs to be taken up wth Oracle Support. The approach I would take is search Metalink for the first parameter and then log a TAR With older releases, when you quote an ORA-600/7445 and the symptoms, chances are thats probably it when someone replies. With 9.2, it gets speculative. Of course, it always possible that some will have encountered what you have just described and provide a most definitive answer..., I would not bet my production databases on it. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 3:49 AM > 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 > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim 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).
