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 |