By default, Essbase uses buffered I/O (input/output) access mode for databases, but direct I/O is available on most operating systems and file systems that Essbase supports. For databases for which you have Database Manager permissions, you can change I/O access mode. Changes become effective after databases are restarted.
Note: | This setting does not apply to aggregate storage databases. |
To select I/O access modes 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 Pending I/O access mode, select an I/O access mode.
Click Apply.
“Understanding Buffered I/O and Direct I/O” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference