February 11, 2005 at 9:45 am
Hello,
Is there an easy way to check if there is a rollback in progress on a particular database?
Thanks,
Dan
February 11, 2005 at 9:54 am
Have you looked under Current Activity/Process Info in EM? I would think you should see it in the status column under one of the system processes.
February 11, 2005 at 10:00 am
Did take a look there and did see a process on that database where the Command column showed "AWAITING COMMAND". Is that what would show on a RollBack?
February 11, 2005 at 11:12 am
KILL "SPID" with statusonly
Amit Lohia
February 11, 2005 at 11:47 am
No. It should show status as Rollback. That is the way I have seen it before.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply