You use the Database Properties window to view and edit database properties. To edit the properties of a database, you must have Database Manager permissions for the database.
|
Note: |
Click the Refresh button in the Database Properties window to see the latest information. |
The following tabs of the Database Properties window apply to aggregate and block storage databases:
General—Set options for startup, calculations, and minimum permissions.
Dimensions—View information about dimensions.
Statistics—View information about data blocks, hit ratios, and read/write operations.
Modifications—View a list of operations performed against the database.
The following tabs of the Database Properties window apply only to block storage databases:
Caches—Size Essbase caches and specify cache-related settings.
Transactions—Specify when and how Essbase writes data to disk.
Storage—Specify a data compression method and set multiple-disk storage parameters for data.
Currency—Link to a currency database and set related options.
The Compression tab, in which you view compression estimates, applies only to aggregate storage databases.
alter database (MaxL) in the Oracle Essbase Technical Reference
query database (MaxL) in the Oracle Essbase Technical Reference
display database (MaxL) in the Oracle Essbase Technical Reference
getdbinfo (ESSCMD) in the Oracle Essbase Technical Reference
getdbstate (ESSCMD) in the Oracle Essbase Technical Reference
getdbstats (ESSCMD) in the Oracle Essbase Technical Reference
getperfstats (ESSCMD) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference