Verifying Cache Size

Go Up to Configuring the Database Cache

To verify the size of the database cache currently in use, execute the following commands in isql:

isql> CONNECT database_name;
isql> SET STATS ON;
isql> COMMIT;
Current memory = 415768
Delta memory = -2048
Max memory = 419840
Elapsed time = 0.03 sec
Buffers = 2048
Reads = 0
Writes 2
Fetches = 2
isql> QUIT;

The empty COMMIT command prompts isql to display information about memory and buffer usage. The “Buffers” line specifies the size of the cache for that database.

Note: The example command listing shows "Buffers = 2048" for user to verify that cache setting has been changed. This is no longer strictly true. For very large cache buffer settings (>256MB), InterBase incrementally allocates additional cache buffers on-demand. So it is possible that the listed command will show a Buffers value that is a lower number. The actual value can always be determined by running gstat -h and examining the Page buffers entry or querying column RDB$PAGE_CACHE from system table RDB$DATABASE.