What is the SHUTDOWN ABORT statement?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is the SHUTDOWN ABORT statement?

Rating:

The SHUTDOWN ABORT statement is one of the options of the SHUTDOWN statement. It is the most deleterious and aggressive SHUTDOWN statement. It does not allow any new Oracle connections. It terminates any active transactions before they can be completed. It does not roll back any uncommitted transactions. It terminates all the connections of a client computer.

Caution: Do not use the SHUTDOWN ABORT statement regularly.
This statement should be implemented only if all other options of the SHUTDOWN statement do not work.

Note: Such a SHUTDOWN statement does not perform a clean shutdown, as it requires a recovery operation, whenever the database is restarted.

Rating: