OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Rollback

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rollback [message #54809]

Fri, 06 December 2002 07:01

Robert Bruns
Messages: 1
Registered: December 2002

Junior Member

I recently wrote a Oracle trigger and a situation occured where the trigger started updating large number of records. The process was killed. Now the rollback is running and has been for almost 24 hrs. It is going extremely slow. Any ideas how to speed this up?

Report message to a moderator

Re: Rollback [message #54811 is a reply to message #54809]

Fri, 06 December 2002 08:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Hi,
long story short,
first Check  if FAST_START_PARALLEL_ROLLBACK =true(default), 
if  true then
	check  v$fast_start_transactions and v$fast_start_servers AND
	SET FAST_START_PARALLEL_ROLLBACK=false 

NOTE:
ofcourse, you cannot helpit NOW.
u have to kill the process, toggle the database

Report message to a moderator

Previous Topic:	ORA-1114
Next Topic:	oracle server type

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:40:07 CDT 2024