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 -> Re: Some rollback segment errors (1551,1595) urgent

Re: Some rollback segment errors (1551,1595) urgent

From: duraisingh <duraisingh_at_yahoo.com>
Date: Fri, 05 Nov 1999 13:47:54 -0500
Message-ID: <3823265A.294021B8@yahoo.com>


the database version is 7.3.3/Aix 4.2

MTun1999_at_gmx.net wrote:

> The ORA-1551 is an Oracle internal error - contact Oracle Support ... what
> is your DBMS Version?
> The ORA-01575: Wait a few minutes and retry your action.....
>
> Michael
>
> duraisingh wrote:
>
> > Dear Fellow Dba's
> > I had the following errors in my alert logs.while running some
> > transactions.
> > The database have 40 rollback segments with 5mb each (initial 500k,next
> > 500k minextents 10 maxextents 250)
> >
> > *** SESSION ID:(6.1) 1999.11.05.08.09.03.000
> > SMON: following errors trapped and ignored:
> > ORA-01595: error freeing extent (536871148) of rollback segment (158))
> > ORA-01551: extended rollback segment, pinned blocks released
> > got it by 8 o clock
> >
> > Thu Oct 28 09:11:36 1999
> > Thu Oct 28 09:11:36 1999
> > *** SESSION ID:(6.1) 1999.10.28.09.11.36.000
> > SMON: following errors trapped and ignored:
> > ORA-01595: error freeing extent (536871148) of rollback segment (159))
> > ORA-01575: timeout waiting for space management resource
> > got it by 9 o clock
> >
> > Can you please tell How can i rectify the problem.
> >
> > I have created a new rollback segment of size 100mb & ask the client to
> > put SET TRANSACTION USE ROLLBACK SEGMENT RBS_40 before thier sql
> > statement . Is it correct?.
> > Please give some clues & hints. Any immediate hints will be appreciated.
> >
> > John D
Received on Fri Nov 05 1999 - 12:47:54 CST

Original text of this message

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