Performance tuning the database

The DB_KEEP_CACHE is a data cache which is persisted in the memory of the Oracle database so data can be retrieved without having to read the hard drive. Usually, core data that does not increase significantly is placed in the DB_KEEP_CACHE, with the exception of the dr$i_ctx_register_text$r table. The dr$i_ctx_register_text$r table is used for free text searches and Oracle recommends the table be included in the DB_KEEP_CACHE.

The DB_KEEP_CACHE is therefore used for conducting searches in WorkZone and the size of the DB_KEEP_CACHE also increases as the database itself increases over time due to usage and normal operations. If the size allocated to the DB_KEEP_CACHE becomes too small, search performance will be negatively impacted. It is therefore recommended to monitor the status of the DB_KEEP_CACHE and to tune it accordingly, mostly by increasing the DB_KEEP_CACHE size allocation.

The ScanSQLform

You can use the ScanSQL form to tune the DB_KEEP_CACHE by displaying and changing the DB_KEEP_CACHE parameters such the size of the cache and whether to use indexes or full table scans when searching as well as displaying and editing which objects and tables are to be included in the DB_KEEP_CACHE.

See also:

Updating DB_KEEP_CACHE parameters

Populating the DB_KEEP_CACHE