Buffer Pool (PD_PDBP)
- Organization of this page
Function
The Buffer Pool (PD_PDBP) record stores performance data indicating the status of the buffer pool available to instances at a specific point in time. PFM - Agent for Oracle creates one record for each buffer pool. This is a multi-instance record.
Default and changeable values
Item |
Default Value |
Changeable |
---|---|---|
Collection Interval |
600 |
Y |
Collection Offset |
45 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC Key Fields
PD_PDBP_ID
Lifetime
From the start to the stop of an Oracle instance
Record Size
-
Fixed part: 678 bytes
-
Variable part: 177 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported Version |
Data Source |
---|---|---|---|---|---|---|
Buffer Busy Wait (BUFFER_BUSY_WAIT) |
Statistics about buffer busy waits Number of buffers in buffer pool |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.BUFFER_BUSY_WAIT |
Buffers (BUFFERS) |
Statistics about consistent gets |
-- |
double |
No |
All |
V$BUFFER_POOL.BUFFERS |
Consistent Gets (CONSISTENT_GETS) |
Statistics about consistent gets |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.CONSISTENT_GETS |
Db Block Change (DB_BLOCK_CHANGE) |
Statistics about changes to database blocks |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.DB_BLOCK_CHANGE |
Db Block Gets (DB_BLOCK_GETS) |
Statistics about collected database blocks |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.DB_BLOCK_GETS |
Dirty Buffers Inspected (DIRTY_BUFFERS_INSPECTED) |
Information about dirty buffers |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.DIRTY_BUFFERS_INSPECTED |
Free Buffer Inspected (FREE_BUFFER_INSPECTED) |
Information about free buffers |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.FREE_BUFFER_INSPECTED |
Free Buffer Wait (FREE_BUFFER_WAIT) |
Statistics about free buffer waits |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.FREE_BUFFER_WAIT |
Got Buffers (BUF_GOT) |
Number of buffers collected by sets |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.BUF_GOT |
ID (ID) |
Buffer pool ID |
-- |
ulong |
No |
All |
V$BUFFER_POOL.ID |
Max Set Size (SET_MSIZE) |
Maximum size of buffer pool set |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.SET_MSIZE |
Name (NAME) |
Buffer pool name. Valid values are DEFAULT, KEEP, and RECYCLE. |
-- |
string(20) |
No |
All |
V$BUFFER_POOL.NAME |
Physical Reads (PHYSICAL_READS) |
Statistical value of physical read operations |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.PHYSICAL_READS |
Physical Writes (PHYSICAL_WRITES) |
Statistical value of physical write operations |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.PHYSICAL_WRITES |
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 PDBP) |
-- |
string(4) |
No |
All |
Agent Collector |
Repl Num (CNUM_REPL) |
Number of buffers on exchange list |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.CNUM_REPL |
Scan Sum (SUM_SCAN) |
Number of scanned buffers in sets |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.SUM_SCAN |
Set Count (SET_COUNT) |
Number of sets in buffer pool |
-- |
double |
No |
All |
V$BUFFER_POOL.SET_COUNT |
Set Num (CNUM_SET) |
Number of buffers in sets |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.CNUM_SET |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record |
-- |
time_t |
No |
All |
Agent Collector |
Write Complete Wait (WRITE_COMPLETE_WAIT) |
Statistical value of write complete waits |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.WRITE_COMPLETE_WAIT |
Write Num (CNUM_WRITE) |
Number of buffers on write list |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.CNUM_WRITE |
Write Sum (SUM_WRITE) |
Number of buffers written in sets |
-- |
double |
Yes |
All |
V$BUFFER_POOL_STATISTICS.SUM_WRITE |