Previous Next JavaScript must be enabled to correctly display this content

## 2.9 Accessing the Data Dictionary Cache Report from Workspace Administration

Access the Data Dictionary Cache report from Workspace Administration to view statistics and data analysis of schema tables and caches in a workspace.

- About the Data Dictionary Cache Report
  Learn about the Data Dictionary Cache report.
- Viewing or Refreshing Data Dictionary Cache in Workspace Administration
  View or refresh the Data Dictionary Cache for a workspace in Workspace Administration.

See Also:

Accessing the Data Dictionary Cache Report from Administration Services

Parent topic: Workspace and Application Administration

### 2.9.1 About the Data Dictionary Cache Report

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.

Parent topic: Accessing the Data Dictionary Cache Report from Workspace Administration

### 2.9.2 Viewing or Refreshing Data Dictionary Cache in Workspace Administration

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. Select the Administration menu and then 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.

See Also:

List of DBMS_SCHEDULER Jobs

Parent topic: Accessing the Data Dictionary Cache Report from Workspace Administration