2.8 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.
- Viewing or Refreshing the Workspace Data Dictionary Cache
View or refresh the Data Dictionary Cache for a workspace in Workspace Administration.
Parent topic: Workspace and Application Administration
2.8.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:
- Navigate to the Workspace Administration page:
- Sign in to Oracle Application Express.
- At the top of the Workspace home page, click the Administration menu and select Administration.
- On the The Workspace Administration home page, click Manage Service.
- Under Manage Meta Data on the right side of the
page:
- To view cache for table:
See Also: