PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported Version	Data Source
Cursor Open Hit % (`CURSOR_OPEN_HIT_PERCENTAGE`)	found in cursor searches that were open cursors^#2	`AVG`	`double`	No	All	`V$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100`
Cursor Open Hits (`CURSOR_OPEN_HITS`)	Total cursor open hits^#2	`AVG`	`double`	Yes	All	`V$SYSTEM_CURSOR_CACHE.HITS`
Cursor Opens (`CURSOR_OPENS`)	Total cursor opens^#2	`AVG`	`double`	Yes	All	`V$SYSTEM_CURSOR_CACHE.OPENS`
Database Object Cache Keeps (`DATABASE_OBJECT_CACHE_KEEPS`)	Number of objects kept^#2	`AVG`	`ulong`	No	All	`COUNT(V$DB_OBJECT_CACHE) where KEPT='YES'`
Database Object Cache Locks (`DATABASE_OBJECT_CACHE_LOCKS`)	Number of users locking objects in cache^#2	`AVG`	`long`	No	All	`SUM(V$DB_OBJECT_CACHE.LOCKS)`
Database Object Cache Pins (`DATABASE_OBJECT_CACHE_PINS`)	Number of users who have acquired objects in cache^#2	`AVG`	`long`	No	All	`SUM(V$DB_OBJECT_CACHE.PINS)`
Dict Cache Fixed (`DICTIONARY_CACHE_FIXED`)	Number of entries fixed in cache^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.FIXED)`
Dict Cache Flushes (`DICTIONARY_CACHE_FLUSHES`)	Number of disk flushes^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.FLUSHES)`
Dict Cache Get Misses (`DICTIONARY_CACHE_GET_MISSES`)	Number of data requests for which a cache miss occurred^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.GETMISSES)`
Dict Cache Get Misses % (`DICTIONARY_CACHE_GET_MISSES_PERCENTAGE`)	Percentage of data requests for which a cache miss occurred^#2	`AVG`	`double`	No	All	`(SUM(V$ROWCACHE.GETMISSES) / SUM(V$ROWCACHE.GETS)) * 100`
Dict Cache Gets (`DICTIONARY_CACHE_GETS`)	Number of requests for information about data objects^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.GETS)`
Dict Cache Modifications (`DICTIONARY_CACHE_MODIFICATIONS`)	Number of insert, update, and delete operations^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.MODIFICATIONS)`
Dict Cache Scan Completes (`DICTIONARY_CACHE_SCAN_COMPLETES`)	Number of times scanning of a list of dependent entries was completed^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.SCANCOMPLETES)`
Dict Cache Scan Miss % (`DICTIONARY_CACHE_SCAN_MISSES_PERCENTAGE`)	Percentage of times data was not found in cache by scanning^#2	`AVG`	`double`	No	All	`(SUM(V$ROWCACHE.SCANMISSES) / SUM(V$ROWCACHE.SCANS)) * 100`
Dict Cache Scan Misses (`DICTIONARY_CACHE_SCAN_MISSES`)	Number of times data was not found in cache by scanning^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.SCANMISSES)`
Dict Cache Scans (`DICTIONARY_CACHE_SCANS`)	Number of scan requests^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.SCANS)`
Dict Cache Usage (`DICTIONARY_CACHE_USAGE`)	Number of cache entries with valid data^#2	`AVG`	`double`	Yes	All	`SUM(V$ROWCACHE.USAGE)`
Lib Cache Get Hit % (`LIBRARY_CACHE_GET_HIT_PERCENTAGE`)	Percentage of times objects were found in library cache^#2	`AVG`	`double`	No	All	`(SUM(V$LIBRARYCACHE.GETHITS) / SUM(V$LIBRARYCACHE.GETS)) * 100`
Lib Cache Get Hits (`LIBRARY_CACHE_GET_HITS`)	Number of times objects were found in library cache^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.GETHITS)`
Lib Cache Gets (`LIBRARY_CACHE_GETS`)	Number of locks requested for objects in library cache^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.GETS)`
Lib Cache Invalidations (`LIBRARY_CACHE_INVALIDATIONS`)	Number of times a nonpermane nt library object (such as a shared SQL area) was invalid^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.INVALIDATIONS)`
Lib Cache Miss % (`LIBRARY_CACHE_MISS_PERCENTAGE`)	Library cache miss percentage: The percentage of objects in the library cache that had to be reloaded into the library cache. A higher percentage indicates greater resource usage.^#2	`AVG`	`double`	No	All	`(SUM(V$LIBRARYCACHE.RELOADS) / SUM(V$LIBRARYCACHE.PINS)) * 100`
Lib Cache Pin Hit % (`LIBRARY_CACHE_PIN_HIT_PERCENTAGE`)	Ratio (as a percent) of the `LIBRARY_CACHE_PIN_HITS` value to the `LIBRARY_CACHE_PINS` value^#2	`AVG`	`double`	No	All	`(SUM(V$LIBRARYCACHE.PINHITS) / SUM(V$LIBRARYCACHE.PINS)) * 100`
Lib Cache Pin Hits (`LIBRARY_CACHE_PIN_HITS`)	Number of times an object acquired or accessed by the system had already been placed in cache and initialized^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.PINHITS)`
Lib Cache Pins (`LIBRARY_CACHE_PINS`)	Number of times the system acquired an object in cache to access it^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.PINS)`
Lib Cache Reloads (`LIBRARY_CACHE_RELOADS`)	Number of times the system needed to reinitialize a library object and load it along with the data because it had not been used recently or it was invalid^#2	`AVG`	`double`	Yes	All	`SUM(V$LIBRARYCACHE.RELOADS)`
Record Time (`RECORD_TIME`)	Collection termination time for the performance data stored in the record^#1	`COPY`	`time_t`	No	All	Agent Collector
Record Type (`INPUT_RECORD_TYPE`)	Record name (always `PICS`)^#1	`COPY`	`string`(4)	No	All	Agent Collector
SQL Executing (`SQL_EXECUTING`)	Total number of users currently executing SQL statements^#1	`COPY`	`double`	No	All	`SUM(V$SQLAREA.USERS_EXECUTING)`
Start Time (`START_TIME`)	Collection start time for the performance data stored in the record^#1	`COPY`	`time_t`	No	All	Agent Collector
Total SQL Executions (`TOTAL_SQL_EXECUTIONS`)	Total number of users currently executing SQL statements^#1	`COPY`	`double`	Yes	All	execute count

To Page Top