DBA Data[Home] [Help]

VIEW: SYS.V_$LIBRARYCACHE

Source

View Text - Preformatted

select "NAMESPACE","GETS","GETHITS","GETHITRATIO","PINS","PINHITS","PINHITRATIO","RELOADS","INVALIDATIONS","DLM_LOCK_REQUESTS","DLM_PIN_REQUESTS","DLM_PIN_RELEASES","DLM_INVALIDATION_REQUESTS","DLM_INVALIDATIONS","CON_ID" from v$librarycache
View Text - HTML Formatted

SELECT "NAMESPACE"
, "GETS"
, "GETHITS"
, "GETHITRATIO"
, "PINS"
, "PINHITS"
, "PINHITRATIO"
, "RELOADS"
, "INVALIDATIONS"
, "DLM_LOCK_REQUESTS"
, "DLM_PIN_REQUESTS"
, "DLM_PIN_RELEASES"
, "DLM_INVALIDATION_REQUESTS"
, "DLM_INVALIDATIONS"
, "CON_ID"
FROM V$LIBRARYCACHE