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