Data Dictionary Cache Interval (PI_PIDD)
- Organization of this page
Function
data, taken at specific intervals, about usage of the data dictionary cache. PFM - Agent for Oracle creates one record for each data dictionary cache. This is a multi-instance record.
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
300 |
Y |
|
Collection Offset |
30 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PI_PIDD_CACHE_NUM
-
PI_PIDD_SUBORDINATE_NUM
Lifetime
From the start to the stop of an Oracle instance
Record size
-
Fixed part: 678 bytes
-
Variable part: 289 bytes
Fields
|
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
|---|---|---|---|---|---|---|
|
Cache # (CACHE_NUM) |
ID number of row cache#1 |
COPY |
double |
No |
All |
V$ROWCACHE.CACHE# |
|
Count (COUNT) |
Total number of entries in cache#2 |
AVG |
long |
No |
All |
V$ROWCACHE.COUNT |
|
Fixed (FIXED) |
Number of entries fixed in cache#2 |
AVG |
ulong |
No |
All |
V$ROWCACHE.FIXED |
|
Flushes (FLUSHES) |
Number of times cache was flushed to disk#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.FLUSHES |
|
Get Misses (GET_MISSES) |
Number of data requests for which a cache miss occurred#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.GETMISSES |
|
Get Misses % (GET_MISSES_PERCENTAGE) |
Percentage of data requests for which a cache miss occurred during the interval#2 |
AVG |
double |
No |
All |
(V$ROWCACHE.GETMISSES / V$ROWCACHE.GETS) * 100 |
|
Gets (GETS) |
Total number of requests to data object information#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.GETS |
|
Modifications (MODIFICATIONS) |
Number of insert, update, and delete operations#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.MODIFICATIONS |
|
Parameter (PARAMETER) |
Name of init.ora parameter that determines the number of entries in data dictionary cache#1 |
COPY |
string(32) |
No |
All |
V$ROWCACHE.PARAMETER |
|
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 PIDD)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
|
Scan Completes (SCAN_COMPLETES) |
Number of times a list of subordinate entries was scanned completely#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.SCANCOMPLETES |
|
Scan Misses (SCAN_MISSES) |
Number of scans during which data was not found in cache#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.SCANMISSES |
|
Scan Misses % (SCAN_MISSES_PERCENTAGE) |
Percentage of scans in which data was not found in cache#2 |
AVG |
double |
No |
All |
(V$ROWCACHE.SCANMISSES / V$ROWCACHE.SCANS) * 100 |
|
Scans (SCANS) |
Number of scan requests#2 |
AVG |
double |
Yes |
All |
V$ROWCACHE.SCANS |
|
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
|
Subordinate # (SUBORDINATE_NUM) |
Subordinate set number#1 |
COPY |
double |
No |
All |
V$ROWCACHE.SUBORDINATE# |
|
Type (TYPE) |
Type of master or subordinate row cache#1 |
COPY |
string(11) |
No |
All |
V$ROWCACHE.TYPE |
|
Usage (USAGE) |
Number of cache entries containing valid data#2 |
AVG |
ulong |
No |
All |
V$ROWCACHE.USAGE |