Wednesday, December 12, 2012

How to see status of a killed session

You can monitor status of a killed session which is currently rolling back with following command:

kill with statusonly

ouput is similar to:

SPID : transaction rollback in progress. Estimated rollback completion: %. Estimated time remaining: seconds.

No comments: