Tuning Global Cache - Expert Oracle RAC Performance Diagnostics and Tuning - page 435

Lock Pin Pin Inval
Inst NAMESPACE Requests Requests Releases Requests Invals
---- -------------------- -------- -------- -------- -------- --------
1 SQL AREA 0 0 0 0 0
TABLE/PROCEDURE 122724 1469838 1469838 0 0
BODY 0 1181194 1181194 0 0
TRIGGER 0 3697 3697 0 0
INDEX 76331 79864 79864 0 0
CLUSTER 987 1011 1011 0 0
DIRECTORY 0 2 2 0 0
QUEUE 19751 61177 61177 0 0
SUMMARY 8177 8177 8177 96 96
APP CONTEXT 0 0 0 0 0
RULESET 0 88 88 0 0
XML SCHEMA 20 20 20 0 0
SUBSCRIPTION 19669 19684 19684 0 0
LOCATION 1 216430 216430 0 0
XDB CONFIG 0 0 0 0 0
USER AGENT 9834 9834 9834 0 0
SECURITY CLASS 17 17 17 0 0
XDB ACL 2 2 2 0 0
EDITION 11870 11870 11870 0 0
DBLINK 22770 0 0 0 0
OBJECT ID 0 0 0 0 0
SCHEMA 11149 0 0 0 0
DBINSTANCE 0 0 0 0 0
History for the library cache statistics is maintained in DBA_HIST_LIBRARYCACHE.
GV$ROWCACHE
This dynamic view is used to measure the caching behavior of the dictionary cache. The dictionary cache is part of the
shared pool and does not have any tunable parameters other than the SHARED_POOL initialization parameter itself.
This means that if the shared pool has not been sized correctly, there is a direct impact on the dictionary cache.
Applications not using locally managed tablespaces (LMT) could experience high dc_used_extents, dc_segments ,
and dc_free_extents counts. This is due to frequent access to the dictionary to update the latest extent information.
Using LMT reduces this activity because all tablespace management is performed locally at the tablespace level.
SQL> desc v$rowcache
Name Null? Type
------------------- -------- ----------------
CACHE# NUMBER
TYPE VARCHAR2(11)
SUBORDINATE# NUMBER
PARAMETER VARCHAR2(32)
COUNT NUMBER
USAGE NUMBER
FIXED NUMBER
GETS NUMBER
GETMISSES NUMBER
SCANS NUMBER