Starting and Stopping Databases

When you start databases, Oracle Essbase loads the databases into memory on the Essbase Server.

Index caches are allocated automatically, and data-file and data caches are allocated when blocks are requested. If you start databases before users access them, users may experience better initial performance (upon connection) because the databases are in memory.

When you start databases from applications that are not started, the applications and all databases within the applications are loaded. You can start one database or all databases for an application.

When you stop databases, Essbase unloads the databases from memory on the Essbase Server and commits updated data to disk. Thus, on the server computer, you increase available memory.

You can stop one database or all databases for an application.

Note:

You can start and stop block storage application databases.

To start or stop a database:

1. In System View, click the Database Properties icon.

2. In Enterprise View, expand the Planning application type and the application that contains the database you want to start or stop

3. Right-click the database, and select:

   • Start Database

   • Stop Database

To start or stop all databases for an application:

1. In System View, click the Database Properties icon.

2. In Enterprise View, expand the Planning application type and the application that contains the databases you want to start or stop

3. Right-click the application, and select:

   • Start All Databases

   • Stop All Databases