|
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
|
Resettable |
Yes |
|
|
Event Type Database |
Logical Data Grouping db_event |
|
|
Element Name Element Type |
total_cons counter |
Description: Indicates the number of connections to the database since the first connect, activate, or last reset (coordinator agents).
Usage: You can use this element in conjunction with the "Database Activation Timestamp" and the "Start Database Manager Timestamp" monitor elements to calculate the frequency at which applications have connected to the database.
If the frequency of connects is low, you may want to explicitly activate the database using the ACTIVATE DATABASE command before connecting any other application, because of the extra overhead that is associated with the first connect to a database (for example, initial buffer pool allocation). This will result in subsequent connects being processed at a higher rate.
| Note: | When you reset this element, its value is set to the number of applications that are currently connected, not to zero. |