I just issued a shutdown immediate command, and it's taking a lot of time. Is there any way, I can find the status of the shutdown task in terms of percentage completed? Or, any kind of status update. It's driving me crazy not knowing what's happening. I know it rolls back uncommited transactions, but I want to know how much of that has been done, how much is left etc.

  • It's one of my reasons to use shutdown abort. The instance recovery that is required - and done - during startup can be done in parallel, makig the rollback a lot quicker.
    – user953
    Jul 5, 2014 at 10:08

2 Answers 2


Assuming you are running some flavour of UNIX, tail the alert log to see what is happening with your shutdown

  • And why can't you do that on Windows? Jul 3, 2014 at 11:31
  • Because Tail is not a command available by default on Windows. Yes there are ways to do this but I was trying to keep the answer as simple as possible. Jul 3, 2014 at 11:34
  • You can use mtail for tail functionality in Windows for alert log :)
    – atenz
    Jul 16, 2014 at 14:48
  • Which is not available by default... Jul 16, 2014 at 16:00

You can always check the status from alert log ( or trace log) file located in bdump directory.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.