3.13.13 Accessing the Data Dictionary Cache Report from Administration Services

Access the Data Dictionary Cache report from Administration Services to view statistics and data analysis of all workspace schema tables and caches in an instance.

• Viewing or Refreshing the Data Dictionary Cache
  View or refresh the Data Dictionary Cache.

See Also:

"Accessing the Data Dictionary Cache Report from Workspace Administration"

3.13.13.1 Viewing or Refreshing the Data Dictionary Cache

View or refresh the Data Dictionary Cache.

The Create Application Wizard and Create Page Wizard use this information when creating new applications and pages. If the tables change due to DDL or DML modifications, the Oracle Application Express 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.

To view or refresh the Data Dictionary Cache:

1. Sign in to Oracle Application Express Administration Services.
2. Click Manage Workspaces.
3. Under Workspace Reports, click Data Dictionary Cache.
   The Data Dictionary Cache page appears listing the workspace, cached objects, schema count, last data definition, last dictionary cache, and workspace ID
4. To view cache for a workspace:
   1. Click the workspace name.
      The Workspace Cache report appears.
   2. To refresh the cache manually click either Gather Statistics and Refresh Cache or Refresh Cache Only.
5. 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.

See Also:

"List of DBMS_SCHEDULER Jobs"