It depends on how you killed the process. If you did and alter system kill session you should be able to look at the used_ublk block in v$transaciton to get an estimate for the rollback being done. If you killed to server process in the OS and pmon is recovering the transaction you can look at V$FAST_START_TRANSACTIONS view to get the estimate. Harel Safra From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of SHEEHAN, JEREMY Sent: Monday, July 26, 2010 10:38 PM To: oracle-l@xxxxxxxxxxxxx Subject: cloning/refresh problem Hello listers, I've got a problem and I'm about to scream trying to figure it out. I've got a feeling it's undo related. Here is a little background on the problem. We had a process that was started on Saturday morning and was still running this morning. It was requested that we cancel the process by the business. No problems. It was killed and we all went on our merry way. The process was migrating data from one table partition to another. Apparently there was a lot of data to move. Now I'm running a clone (we're using EMC to run) and I'm getting stuck on the portion where I recover the database. It does the 'recover' just fine when we I go to shutdown the db it sits there. I've got a feeling it's attempting to rollback a process from production, but the process no longer exists production and I'm stuck trying to figure out where this problem is occurring. We had a the same problem last week and the fix was to just wait until the rollback finished on prod and attempt the refresh again. My question to everyone here, is how can I check if there is anything rolling back? We're on 9.2.0.8, AIX 5.3.7 and we're using UNDO Tablespace versus rollback segments. TIA! Jeremy