Populating the DB_KEEP_CACHE

The objects required for normal operations are included by default in the DB_KEEP_CACHE as it is installed initially but customizations and daily usage can change the requirements of the composition of the DB_KEEP_CACHE. In some situations, it may be necessary to remove objects from the DB_KEEP_CACHE for performance reasons as the DB_KEEP_CACHE increases in size and memory demands.

You can add additional objects as well as remove unneeded objects to the DB_KEEP_CACHE by updating the objects and then applying your changes to the DB_KEEP_CACHE.

There are no upper or lower limits to the number or size of objects in the DB_KEEP_CACHE but the size of the cache will limit how much data it can contain and still operate effectively.

  1. On the WorkZone Content Server, press Start and type ScanSQL to open the ScanSQL form. You can also press ALT+R in windows to open the Run window and type ScanSQL.
  2. In the ScanSQL form, click SjBase to open the SjBase form.
  3. In the SjBase form, click Tuning to open the Tuning form.
  4. In the Tuning form, click View candidates to open the WorkZone SQL form and display all objects currently in the DB_KEEP_CACHE as well as all objects that are to be included in the DB_KEEP_CACHE but are not yet included.
Important:
  • You must know the table of the object you are adding or removing from the DB_KEEP_CACHE.
  • If you are adding a new object to the DB_KEEP_CACHE, you must update the Object_Keep field to Yes. Likewise, if you are removing objects from the DB_KEEP_CACHE, you must update the Object_Keep field to No.
  • When you apply your changes, the DB_KEEP_CACHE will be updated to only contain objects with the Yes value in the Object_Keep field.
  • Display the current and coming objects before applying the changes to double-check your planned updates.
  1. On the WorkZone Content Server, press Start and type ScanSQL to open the ScanSQL form. You can also press ALT+R in windows to open the Run window and type ScanSQL.
  2. In the ScanSQL form, click SjBase to open the SjBase form.
  3. In the SjBase form, click Tuning to open the Tuning form.
  4. In the Tuning form, click Apply changes to update the DB_KEEP_CACHE with objects that contain the value of Yes in the Object_Keep field.

Note: You can also use the Oracle SQL Developer tool, which is included in a standard WorkZone installation and available on the WorkZone server.