Contents
What is shutdown immediate?
Shutdown IMMEDIATE -> Shuts down the target database immediately, with the following consequences: Current client SQL statements being processed by the database are allowed to complete. Uncommitted transactions are rolled back. All connected users are disconnected.
What is allowed in shutdown transaction?
The SHUTDOWN TRANSACTIONAL waits for all uncommitted transactions to complete before shutting down the database instance. This saves the work for all users without requesting them to log off. The database instance also does not accept any new transaction after a SHUTDOWN TRANSACTIONAL .
How to check the status of a database shutdown?
You can always check the status from alert log ( or trace log) file located in bdump directory. Thanks for contributing an answer to Database Administrators Stack Exchange! Please be sure to answer the question.
Why does shutdown immediate take so long to complete?
Now the original sessions could be waiting because of resource issues or Oracle Bugs. Shutdown immediate can take long time to complete (appear to be hung) because of three reasons: 1. Uncommitted transactions are being rolled back. 2. SMON is cleaning temp segments or performing delayed block cleanouts.
How to tell if a shutdown is planned or unplanned?
Remember to indicate that a shutdown is planned by using the p: parameter. Omitting p: indicates that a shutdown is unplanned. If you type p: followed by the reason code for an unplanned shutdown, the command will not carry out the shutdown. Conversely, if you omit p: and type in the reason code for a planned shutdown,…
What do I need to know about remote shutdown?
Description. /i. Displays the Remote Shutdown box. The /i option must be the first parameter following the command. If /i is specified, all other options are ignored. /l. Logs off the current user immediately, with no time-out period. You cannot use /l with /m or /t.