Learn about the Data Dictionary Cache report.

The Data Dictionary Cache report captures statistics and data analysis of schema tables and caches in the current workspace.

If the tables change due to DDL or DML modifications, the APEX nightly job ORACLE_APEX_DICTIONARY_CACHE refreshes the Data Dictionary Cache. If the Data Dictionary Cache is incorrect or out of date, you can update the cache manually by clicking Gather Statistics and Refresh Cache or Refresh Cache Only.

The Create Application Wizard and Create Page Wizard also use this information when creating new applications and pages.

View or refresh the Data Dictionary Cache for a workspace in Workspace Administration.

To view or refresh the Data Dictionary Cache report for a workspace:

1. Navigate to the Workspace Administration page:
   1. Sign in to APEX.
   2. At the top of the Workspace home page, click the Administration menu and select Administration.
2. On the The Workspace Administration home page, click Manage Service.
3. Under Manage Meta Data on the right side of the page:
   1. Click Data Dictionary Cache.
      The Data Dictionary Cache report appears.
   2. To refresh the cache manually click either Gather Statistics and Refresh Cache or Refresh Cache Only.
   3. Click the workspace name.
4. To view cache for table:
   1. Click the table name.
      The Table Column Cache report appears. The Facets Search Score and Facet Display columns indicate how the Create Application Wizard and Create Page Wizard will render facets when creating a Faceted Search page.
   2. To refresh the cache manually click either Gather Statistics and Refresh Cache or Refresh Cache Only.