Re: 7.0 rollback hassles

--Boundary-7846945-0-0

Check out "Managing Rollback Segments" in your DBA manual. Use the MONITOR ROLLBACK feature to gather stats on your rollback usage. It sounds like your OPTIMAL setting is not "optimal".

Tim Sawmiller
tsawmiller_at_us.oracle.com
"I speak for me and no else!"

--Boundary-7846945-0-0

Content-Type: message/rfc822

Date: 16 Jan 96 15:58:01
From:"Ian " <STEWARTI_at_MWP.ESKOM.CO.ZA>
To: Multiple,recipients,of,list,ORACLE-L,ORACLE-L_at_CCVM.SUNYSB.EDU Subject: 7.0 rollback hassles
Reply-to: ORACLE-L_at_CCVM.SUNYSB.EDU
X-Orcl-Application: Sender: "ORACLE database mailing list."  <ORACLE-L_at_CCVM.SUNYSB.EDU>
X-Orcl-Application: Organization: ESKOM Megawatt Park X-To: ORACLE-L_at_ccvm.sunysb.edu

Problem
We are running 7.0.15 and are having problems with rollback segments. They extend but will not reduce to 'optimal' again. The database runs out of rollbacks and has to be bounced to clear it. The rollback segment must be dropped to free the space.

What is the problem ?
does anyone have a fix that does not entail bouncing the database (i.e. shutting down and starting up again)

thx

ian stewart

--Boundary-7846945-0-0--
Received on Tue Jan 16 1996 - 09:56:24 CST