RE: rollback job

Tariff,

The rollback will take roughly as much time as the roll forward. If the job has been running for two hours without commits, it will take two hours to roll back.

It will release the space aquired in the rollback segment and release the table locks.

Advice is to let it run. If you kill by aborting the instance, it will roll back during recovery anyway.

In the future, try putting the job in a PL/SQL procedure and commiting each x records, this will reduce the rollback.

Jack Silvey
ocp x 2
senior @ xol.com

-----Original Message-----
From: Salih, Tarig - ASPEN Project [mailto:SalihT_at_ci.denver.co.us] Sent: Tuesday, June 27, 2000 5:55 PM
To: Multiple recipients of list ORACLE-L Subject: rollback job

Hi gurus
I Started a job at 10:00 AM this morning after two hours I decided to kill that job, I killed it. My question is since this job has been running for 2 hours, how long approximately it will take this job to rollback? Would it releases the space acquired from the rollback segment? This job is still locking some tables and taking some space from the rollback segment.
Any advice there?. I appreciate your help. Tariff

-- 
Author: Salih, Tarig - ASPEN Project
  INET: SalihT_at_ci.denver.co.us

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).