Sets the file access mode to direct I/O instead of the default buffered I/O. Applies only to new databases or to databases migrated from Release 6.2 or earlier.
This setting does not apply to aggregate storage databases.
DIRECTIO TRUE | FALSE
TRUE—Direct I/O is used, when possible, for newly created or migrated databases.
FALSE—This is the default. Buffered I/O is used for newly created or migrated databases.
For each database, a security file setting tells Essbase whether to use buffered or direct I/O when it accesses the database. By default, when Essbase creates a new database or migrates one from release 6.2 or earlier, it sets this I/O access mode setting to buffered I/O. You can specify the DIRECTIO TRUE configuration setting to change the default setting for new or migrated databases to be direct I/O.
To alter the I/O access mode setting for a database thereafter, use Administration Services or MaxL.
Effective use of direct I/O requires a larger index cache than is needed for buffered I/O. See the Oracle Essbase Database Administrator's Guide section on sizing caches for details.
On operating systems and file systems that do not support direct I/O, buffered I/O is used regardless of the setting in the security file.
DIRECTIO TRUE
When Essbase is restarted, the file access mode is set to direct I/O for new databases and databases migrated from release 6.2 or earlier.