I'm see ORA-1594 and ORA-1595 errors ON A 9.0.1.3 database. There are no accompanying ORA-601 or ORA=604 errors. The database is using automatic undo management. Here is the trace file
*** 2002-07-13 02:49:08.842 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 03:30:07.831 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 04:26:28.403 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 05:22:48.969 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 06:19:09.530 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 07:15:30.111 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 08:11:50.684 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 09:08:11.262 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 10:04:31.833 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 11:00:52.426 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 11:57:12.998 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 12:53:33.582 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 13:49:54.157 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 14:46:14.739 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 15:32:20.928 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 16:28:41.504 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 17:25:02.089 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 18:21:22.666 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 19:17:43.236 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 20:14:03.810 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** 2002-07-13 21:05:17.171 SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed *** SMON: following errors trapped and ignored: ORA-01595: error freeing extent (2) of rollback segment (8)) ORA-01594: attempt to wrap into rollback segment (8) extent (2) which is being freed ================================================================================================== Why the errors began, occurred every 56 minutes or so then stopped I have no idea. The database has almost no activity, but will eventually be used to store metrics from an 8-way Klystron array and other equipment being tested for the proposed Next Linear Collider. The errors stopped when a hot backup was commenced at 2002-07-13 22:03:24. But that is probably coincidental. Anyway as smon is ignoring these errors can I do so as well. If so, I thought 9.0.1.3 was supposed to stop such things. At least I get that feeling from reading some of the articles on Metalink. I cannot however read document 210980.995 which is scored at 100 for this problem. Can anyone else? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
