| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Frequent ''ORA -1650: unable to extend rollback segment errors'' in the
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: Deepender.Gupta_at_newpower.com
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: ListGuru_at_fatcity.com (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). Received on Mon Jun 24 2002 - 17:38:21 CDT
 |
 |