#Check database startup time oracle how to#
See "Monitoring Sessions" for information on how to view current database sessions. However, you can also shut Oracle Database XE down manually whenever you want, such as to reduce the overall system processing overhead when you do not need to use the database.īefore shutting down Oracle Database XE, it is best to ensure that all users and applications have completed their work and logged out. Oracle Database Express Edition (Oracle Database XE) shuts down automatically when you shut down the computer that hosts it.
The query results should look similar to the following: (Optional) Enter the following SQL query to verify that the database started up properly: (System global area sizes will vary depending on the amount of physical memory in your Oracle Database XE host computer.) If the command is successful, it displays output similar to the following. The slash (/) indicates that the database should authenticate you with operating system authentication.Īt the SQL Command Line prompt, enter the following command: See "Setting Environment Variables on the Linux Platform" for details.Īt the operating system prompt, enter the following command to start the SQL Command Line and connect to the database: Linux platform only: Ensure that environment variables are set properly. If not already opened, open a terminal session or command window. To start up the database using the SQL Command Line: When you start up the database with the SQL Command Line, you must run the SQL Command Line on the same computer where you installed Oracle Database XE (the "Oracle Database XE host computer"). Starting Up the Databas e Using the SQL Command Line On Linux with KDE: Click the icon for the K Menu, point to Oracle Database 11g Express Edition, and then select Start Database. On Linux with Gnome: In the Applications menu, point to Oracle Database 11g Express Edition, and then select Start Database. On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 11g Express Edition, and then select Start Database. See "Operating System Authentication" for more information. On Linux: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a user who is a member of the dba user group.
#Check database startup time oracle windows#
On Windows: Log in to the Oracle Database XE host computer as the user that installed Oracle Database XE or as a Windows administrator-that is, as a user who is a member of the Administrator group. To start up the database using the desktop: See "Starting Up the Database Using the SQL Command Line" for instructions.
If your Linux computer is not running a windowing manager, or is running a windowing manager other than KDE or Gnome, you must start the database with the SQL Command Line. This section explains how to start up the database from the desktop in Windows and in the following two Linux windowing managers: KDE and Gnome. Starting Up the Data base from the Desktop
0 kommentar(er)
