Starting a Database

When Essbase starts a database and loads it to memory, the entire index cache for that database is allocated in memory automatically. The data cache and data file cache are allocated as blocks requested from Essbase clients.

When you start an application, Essbase loads the application and its databases into memory on the Essbase Server computer. When you start a database from an application that is not started, the application is loaded into memory along with all its related databases.

  To start a database, use a tool:

Tool

Topic

Location

Agent

START appname

Enter the Agent command at the command prompt in the Essbase Server console window.

Administration Services

Starting Databases

Oracle Essbase Administration Services Online Help

MaxL

alter application load database

Oracle Essbase Technical Reference

ESSCMD

LOADDB or SELECT

Oracle Essbase Technical Reference

  To configure a database to start automatically when its parent application starts, use a tool:

Tool

Topic

Location

Administration Services

Configuring Databases to Start Automatically

Oracle Essbase Administration Services Online Help

MaxL

alter database enable autostartup

Oracle Essbase Technical Reference