What shutdown modes does Oracle have?

Oracle shutdown mode: 1. Normal mode, which does not allow new connections and waits for the original connection to end; 2. Immediate mode, which does not allow new connections and actively disconnects users; 3. Transactional mode , do not allow new connections, wait for the end of the current transaction.

Oracle shutdown mode:

1. Closing the database requires permissions: SYSDBA or SYSOPER.

2. Tools for closing the database: SQL*PLUS or SRVCTL.

3. Tools for closing the database Four modes: normal (sql*plus tool default), immediate (srvctl tool default), transactional and abort

• Normal mode:

  Does not allow new connections and waits for the end of the original connection. If there are long transactions or long connections in the system, it will take too long to close the database. Generally not used.

• immediate mode:

  Does not allow new connections and actively disconnects users. If there is a transaction on the current connection, roll back the uncommitted transaction.

• transactional mode:

  Does not allow new connections, waits for the end of the current transaction, and disconnects after all transactions end.

• abort mode:

  Does not allow new connections and actively disconnects users, ends the transaction immediately (without rollback), client SQL statement processing is terminated immediately.

Related learning recommendations: oracle database learning tutorial

The above is the detailed content of What shutdown modes does Oracle have?. For more information, please follow other related articles on the PHP Chinese website!