8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: library_cache.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/library_cache.sql -- Author : Tim Hall -- Description : Displays library cache statistics. -- Requirements : Access to the V$ views. -- Call Syntax : @library_cache -- Last Modified: 15/07/2000 -- ----------------------------------------------------------------------------------- SET LINESIZE 500 SET PAGESIZE 1000 SET VERIFY OFF SELECT a.namespace "Name Space", a.gets "Get Requests", a.gethits "Get Hits", Round(a.gethitratio,2) "Get Ratio", a.pins "Pin Requests", a.pinhits "Pin Hits", Round(a.pinhitratio,2) "Pin Ratio", a.reloads "Reloads", a.invalidations "Invalidations" FROM v$librarycache a ORDER BY 1; SET PAGESIZE 14 SET VERIFY ON