You can disable automatic cache size tuning by specifying -ca 0 option. If you do not include the -ca 0 option, the database
server automatically increases the cache size. If you specify this option, the cache size is still adjusted if the database
server would otherwise run into an error indicating that the dynamic memory is exhausted.
This server option must only be used in the form -ca 0.
The use of AWE is deprecated. It is recommended that you use the 64-bit version of the database server on a 64-bit Windows
operating system if you require a large cache.
The following example starts a database server named myserver that has a static cache that is 40% of the total physical memory
and loads the sample database, and the database server does not automatically adjust the cache size:
Syntax