Online Documentation for SQL Manager for Oracle

Library Cache

The Library Cache tab provides information on Oracle library cache.


Database Statistics - SGA - Library Cache


The Library Cache area displays items as a grid with the following columns: Namespace, Gets, Get Hits, Get Hit Ratio, Pins, Pin Hits, Pin Hit Ratio, Reloads, Invalidations. 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.