| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Rollback segment full
Ana,
Once an RBS encounters an ORA-1562 error its status is changed to FULL so that no further transactions will use it. The status of FULL will be cleared when all of the current tx's in the rbs are committed or rolled back.
The alert log should show an additional error indicating why the rbs couldn't extend (typically an ORA-1650 "unable to allocate extent" or ORA-1628 "max # extents reached") in which case you don't have enough contiguous free space in the tablespace or you need to increase max extents.
HTH,
>From: achoto_at_american.edu
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Rollback segment full
>Date: Fri, 28 Apr 2000 13:05:32 -0800
>
>One of our rollback segments is showing as 'FULL'. There is a transaction
>running now for over 7 hours in that segment. Here is the message in the
>alert log:
>
>Failure to extend rollback segment 3 because of 1562 condition
>Failure to extend rollback segment 3
>
>We use DataStage to load this table. The table seems to be loading at 16
>rows per second, so far we have about 438,000 rows loaded. I don't know
>how many rows are still left to be loaded because I'm not familiar with the
>source or the process, and unfortunately the developer who knows is on
>vacation.
>
>This is the first time I see the status of 'FULL' in our rollback segments.
>We have a total of five rollback segments in the RBS tablespace for a total
>of 1,000MB. Usually we have approximately 8 batch jobs that start the load
>at about 4:30 am and finish around 8:30 am. I've never seen a transaction
>running for so long.
>
>Can anyone out there enlighten me as to where to look for an answer to this
>problem?
>
>Thanks to all of you, and have a great weekend. I hope this gets to the
>list because I seemed to have been unsubscribed. But, I did resubscribe.
>
>Thanks
>
>Ana E. Choto
>Systems Programmer
>American University
>Office of Information Technology
>Phone (202) 885-2275
>Fax (202) 885-2224
>
>--
>Author:
> INET: achoto_at_american.edu
>
>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).
 |
 |