Online Documentation for SQL Manager for Oracle

Data Dictionary Cache

The Data Dictionary Cache tab provides information on Oracle data dictionary cache.


Database Statistics - SGA - Data Dictionary Cache


The Data Dictionary Cache area displays items as a grid with the following columns: Type, Parameter, Count, Usage, Fixed, Gets, Get Misses, Scans, Scan Misses, Scan Completes, Modifications, Flushes. If more convenient, you can change the order of the columns by dragging their headers horizontally.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


In order to filter items in grid, you can use Custom Filter and Filter Builder dialog. For more information refer to the Filtering records page.