Shutting Down the Database |
 Previous |
 Next |
Oracle Database Express Edition (Oracle Database XE) shuts down automatically when you shut down the computer that hosts it.
Before shutting down Oracle Database XE, it is best to ensure that all users and applications have completed their work and logged out. See "Monitoring Sessions" for information on how to view current database sessions.
If users or applications are still logged in when you begin a shutdown operation, the shutdown proceeds under the following conditions:
-
No new connections are permitted, and no new transactions are allowed to be started.
-
Any uncommitted transactions are rolled back.
-
All users and applications are immediately disconnected.
You can shut down the database with the desktop or with SQL Command Line (SQL*Plus). Each of these methods is described in the following sections: