When you start databases, 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 of an application.
You can also configure databases to start automatically.
To start one database:
From Enterprise View or a custom view, select the database.
Right-click, and select Start.
To start all databases of an application:
From Enterprise View or a custom view, select the application.
Right-click, and select Start, and then All databases.
alter application (MaxL) in the Oracle Essbase Technical Reference
loaddb (ESSCMD) in the Oracle Essbase Technical Reference
login (ESSCMD) in the Oracle Essbase Technical Reference
select (ESSCMD) in the Oracle Essbase Technical Reference