BigB Guesstimator (B)
This program allows you to see the effects of increasing/decreasing the number of memory blocks assigned to the database buffers. 100% represents the current number of memory blocks assigned at database server startup (-B server startup parameter).
|ProTop RT Label||Description|
|Pct||Percentage of data blocks, with 100% being the current -B value|
|BigB (-B)||Number of memory blocks assigned at database server process startup|
|BigB (GB)||Amount of memory assigned to database buffers as expressed in gigabytes|
|DB Size (GB)||Database size expressed in gigabytes|
|% DB Size||Amount of memory, in gigabytes, as a percentage of the size of the database|
|Hit:1||The number of database reads from buffers per single disk read. "999999" means no OS reads.|
|Miss%||Number of record reads from disk as a percentage of all reads|
|Hit%||Number of record reads from memory buffers as a percentage of all reads|
|OS Reads||Number of OS reads fetching records from the database|
|Note||Just a note ... usually indicates the current value of -B|
*This panel is not alertable per se. With the commercial version of ProTop, you can configure alerts using the metric names in this column. For a full list of metrics, see the Alertable Metrics section.