V$LIBRARYCACHE

Displays statistics on library cache activity.

Fields

The most relevant view fields are:

  • NAMESPACE: The library cache namespace
  • GETS: The number of times a lock was requested for objects in the namespace
  • GETHITRATIO: The number of times the object's handle was found in memory
  • PINS: The number of times a PIN was requested for objects in the namespace
  • PINHITRATIO: The number of times the object's metadata were found in memory
  • RELOADS: Any PIN of the object, following the first after object creation, which requires loading the object from disk
  • INVALIDATIONS: The number of times objects in the namespace were marked invalid due to dependent object modifications

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial