Default Cache Size Per Database

Go Up to Configuring the Database Cache

The buffers parameter of the gfix utility sets the default number of cache pages for a specific database:

gfix -buffers n database_name

This sets the number of cache pages for the specified database to <n>, overriding the server value, which by default is 2048 pages.

The default size for a database can also be set using the ALTER DATABASE statement:

ALTER DATABASE SET PAGE CACHE n

To run gfix or ALTER DATABASE, you must be either SYSDBA or the owner of the database.

Both gfix and ALTER DATABASE immediately attempt to expand the cache buffers to the number of pages requested.