Cache Summary Interval (PI_PICS)

Collection Interval

300

Y

Collection Offset

20

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

Yes

N

Cursor Open Hit %

(CURSOR_OPEN_HIT_PERCENTAGE)

found in cursor searches that were open cursors^{#2, #10}

AVG

double

No

All

V$SYSTEM_CURSOR_CACHE.HIT_RATIO * 100

Cursor Open Hits

(CURSOR_OPEN_HITS)

Total cursor open hits^{#2, #10}

AVG

double

Yes

All

V$SYSTEM_CURSOR_CACHE.HITS

Cursor Opens

(CURSOR_OPENS)

Total cursor opens^{#2, #10}

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, #9}

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, #9}

AVG

long

No

All

SUM(V$DB_OBJECT_CACHE.PINS)

Dict Cache Fixed

(DICTIONARY_CACHE_FIXED)

Number of entries fixed in cache^{#2, #10}

AVG

double

Yes

All

SUM(V$ROWCACHE.FIXED)

Dict Cache Flushes

(DICTIONARY_CACHE_FLUSHES)

Number of disk flushes^{#2, #10}

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, #10}

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, #10}

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, #10}

AVG

double

Yes

All

SUM(V$ROWCACHE.GETS)

Dict Cache Modifications

(DICTIONARY_CACHE_MODIFICATIONS)

Number of insert, update, and delete operations^{#2, #10}

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, #10}

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, #10}

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, #10}

AVG

double

Yes

All

SUM(V$ROWCACHE.SCANMISSES)

Dict Cache Scans

(DICTIONARY_CACHE_SCANS)

Number of scan requests^{#2, #10}

AVG

double

Yes

All

SUM(V$ROWCACHE.SCANS)

Dict Cache Usage

(DICTIONARY_CACHE_USAGE)

Number of cache entries with valid data^{#2, #10}

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, #10}

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, #10}

AVG

double

Yes

All

SUM(V$LIBRARYCACHE.GETHITS)

Lib Cache Gets

(LIBRARY_CACHE_GETS)

Number of locks requested for objects in library cache^{#2, #10}

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, #10}

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, #10}

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, #10}

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, #10}

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, #10}

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, #10}

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, #9}

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, #9}

COPY

double

Yes

All

execute count