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.
Find status of shutdown immediate
oracle
Related Question
- Oracle DB Shutdown issue
- Oracle PL/SQL – Using EXECUTE IMMEDIATE in PL/SQL Block
- Slow running Oracle query caused by unnecessary full table scan
- Oracle RAC – How to Perform Shutdown
- ORA-27101 while trying to login after shutdown immediate
- Getting an error ORA-00933 while using EXECUTE IMMEDIATE
- Unable to shutdown immediate database – Oracle
Best Answer
Assuming you are running some flavour of UNIX, tail the alert log to see what is happening with your shutdown