Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
Resettable |
No |
|
Event Type Database |
Logical Data Grouping db_event |
|
Element Name Element Type |
sec_log_used_top water mark |
Description: The maximum amount of secondary log space used (in bytes).
Usage: You may use this element in conjunction with "Secondary Logs Allocated Currently" and "Maximum Total Log Space Used" to show your current dependency on secondary logs. If this value is high, you may need larger log files, or more primary log files, or more frequent COMMIT statements within your application.
As a result, you may need to adjust the following configuration parameters:
The value will be zero if the database does not have any secondary log files. This would be the case if there were none defined.
For more information, see the Administration Guide.
| Note: | While the database system monitor information is given in bytes, the configuration parameters are set in pages, which are each 4K bytes. |