Specifies the maximum amount of memory that Essbase can allocate to the triggers feature.
TRIGMAXMEMSIZE [application [database]] memsize
application—Optional. Sets the available memory cache for all databases in the specified application.
database—Optional. Sets the available memory cache for the specified database. If you specify a database, you must specify the application that contains it.
memsize—Available memory cache size (in bytes). Default: 4096 bytes. Minimum: 4096 bytes. Maximum: 8388608 bytes (8MB). Setting memsize to zero (0), or a negative value, disables all triggers.
TRIGMAXMEMSIZE specifies the maximum amount of memory available to the Essbase triggers feature. The triggers feature lets you efficiently monitor data changes in a database. If data breaks the rules that you have specified, Essbase logs the information in a file or sends an email alert.
For more information about triggers, see the Oracle Essbase Database Administrator's Guide. For information about MaxL triggers statements, see the Oracle Essbase Technical Reference.
You must specify the memory in bytes. If you specify a size greater than the maximum of 8388608 bytes, Essbase automatically sets the size to 8388608 bytes.
TRIGMAXMEMSIZE 12288
sets the maximum memory cache for the triggers feature to to 12288 bytes (12K). The setting applies to all appliations and databases on the Essbase Server.
create trigger (MaxL statement)
display trigger (MaxL statement)
alter trigger (MaxL statement)
drop trigger (MaxL statement)