This parameter determines the amount of the memory, in pages, to allocate for database system monitor data. Memory is allocated from the monitor heap when you perform database monitoring activities such as taking a snapshot, turning on a monitor switch, resetting a monitor, or activating an event monitor.
A value of zero prevents the database manager from collecting database system monitor data.
Recommendation: The amount of memory required for monitoring activity depends on the number of monitoring applications (applications taking snapshots or event monitors), which switches are set, and the level of database activity.
The following formula provides an approximation of the number of pages required for the monitor heap:
( number of monitoring applications + 1 ) *
( number of databases *
(800 + ( number of tables accessed * 20 )
+ ( ( number of applications connected + 1) *
(200 + (number of table spaces * 100) ) ) ) )
/ 4096
If the available memory in this heap runs out, one of the following will occur:
[ Top of Page | Table of Contents | Glossary | Index ]