Hi All,
For the last 10-12 days Database is giving frequent ORA 1650 errors. My
Database size is 74 GB and Total No. of Rollback segments are 19, with
Initial Extent 60MB, Next extent 60MB, MIN_EXTENTS 2, MAX_EXTENTS 505.
There are 2 Tablespaces holding these Rollback segments( 4GB and 1 GB)
There is no extra load on the database. I am really worried why this
problem has been started all of a sudden.
The rollback segment statistics is showing high number of Waits and wrap.
For few rollback segments wait statistics it is exceeding even 100 which I
have never seen. and now because of this few importants reports are
aborted.
Mon Jun 24 00:49:48 2002
Thread 1 advanced to log sequence 5416
Current log# 2 seq# 5416 mem# 0: /oracle05/oradata/GASPROD/redo02.log
Mon Jun 24 00:49:55 2002
ORA-1650: unable to extend rollback segment RBS12 by 7680 in tablespace
RBS
Failure to extend rollback segment 12 because of 1650 condition
Mon Jun 24 00:52:33 2002
Thread 1 advanced to log sequence 5417
Current log# 1 seq# 5417 mem# 0: /oracle05/oradata/GASPROD/redo01.log
Mon Jun 24 00:56:24 2002
Thread 1 advanced to log sequence 5418
Kindly suggest if anybody has some clue.
Regards
deepender
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
