Oracle Shutdown Modes


  • ABORT: Performs the least amount of work before shutting down. Because this mode requires recovery before startup, use it only when necessary. It is typically used when no other form of shutdown works, when there are problems when starting the instance, or when you need to shut down immediately because of an impending situation (such as notice of a power outage within seconds).
  • IMMEDIATE: Is the most typically used option. Uncommitted transactions are rolled back.
  • TRANSACTIONAL: Allows transactions to finish
  • NORMAL: Waits for sessions to disconnect