dbatricksworld.com
Query to find out progress of transaction recovery by SMON
Have you killed the long running query? SMON is solely responsible for recovering transactions when you kill any large running query( truncate and delete ) by killing OS process or aborting databas…