1. Administration Guide
  2. Workspace and Application Administration
  3. Accessing the Data Dictionary Cache Report from Workspace Administration

2.7 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.

See Also:

"Accessing the Data Dictionary Cache Report from Administration Services"

Parent topic: Workspace and Application Administration

2.7.1 Viewing or Refreshing the Workspace Data Dictionary Cache

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

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 report for a workspace:

  1. Navigate to the Workspace Administration page:
    1. Sign in to Oracle Application Express.
    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.

See Also:

"List of DBMS_SCHEDULER Jobs"

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