BigB Guesstimator

img00100
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.