Altering a Database

Figure 151. MaxL statement to change data file cache size

This image shows a MaxL statement for changing the size of the data file cache (alter database with the set_data_file_cache_size grammar).

Example:

alter database Sample.Basic set data_file_cache_size 32768KB;