Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> rollbacks ??

rollbacks ??

From: Ed Lufker <elufker_at_swcp.com>
Date: 2 Jun 1998 13:33:34 GMT
Message-ID: <6l0uve$nah$1@sloth.swcp.com>


Hi all:

        Can anyone give me some tips on how to size my rollback segments for both batch and OLTP. I was getting the following error when doing a delete last night.

ORA-1628: max # extents 505 reached for rollback segment R05 Failure to extend rollback segment 6 because of 1628 condition FULL status of rollback segment 6 cleared.

thanks
eddie lufker Received on Tue Jun 02 1998 - 08:33:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US