Essbase allocates storage for data and index files on the Essbase Server. If you have Database Manager permissions, you can control how storage is allocated.
Note: | Disk volumes do not apply to aggregate storage databases. |
Files are written to the disk volume in the following directory structure:
.../app/app_name/db_name
For new files, disk volume settings become effective after the database is restarted. Previously existing files and volumes are not affected.
Note: | A SAN device can be designated as a disk volume. |
If disk volumes are not specified, Essbase stores files only on the volume where the ARBORPATH directory resides. If the ARBORPATH variable is not set, Essbase stores files only on the volume where Essbase Server was started.
To set disk volumes for databases:
From Enterprise View or a custom view, select a database.
Right-click, and select Edit, and then Properties.
In the Database Properties window, select the Storage tab.
In the columns of the disk volumes area, make your selections.
Click Set.
Click Apply.
Optional: To stop Essbase from storing files on a volume, select the relevant row, and click Delete.
Essbase does not write new files to the designated volume but continues to access and use files previously stored on the volume.
“Storage Allocation” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference