Retrieval buffer size | Setting the Retrieval Buffer Size | Administration Services: Database Properties window, General tab MaxL: alter database appname.dbname set retrieve_buffer_size n ESSCMD SETDBSTATEITEM 16
|
Retrieval sort buffer size | Setting the Retrieval Sort Buffer Size | Administration Services: Database Properties window, General tab MaxL: alter database appname.dbname set retrieve_sort_buffer_size n ESSCMD: SETDBSTATEITEM 17
|
Data compression | Data Compression | Administration Services: Database Properties window, Storage tab MaxL: alter database appname.dbname enable compression and alter database appname.dbname set compression type ESSCMD: SETDBSTATEITEM 14 SETDBSTATEITEM 15
|
Maximum memory for trigger definitions | Understanding Triggers Definitions | MaxL: create or replace trigger, alter trigger display trigger, and drop trigger |