The Log Status tab on the Database Analysis drilldown provides current log utilization statistics for the selected database or partition. Use this information to help you pinpoint log utilization problems.
The following statistics describe the current status of the log files on the database. If you detect log utilization problems, such as a log-full condition, you might need to adjust configuration parameter settings for the log files. For information on current parameter settings, go to the Configuration tab for the Databases drilldown.
|
|
These graphs provides an overview of log activity and space utilization over consecutive monitoring intervals:
Total Transaction Rate -- Keeps track of the number of commits and rollbacks taking place in the log files per second.
Avg Log Space per Transaction -- Keeps track of the average amount of log file space being used per transaction.
The Statistics tab on the Database Analysis drilldown lists performance statistics for events that have occurred in the selected database. Each row in the list identifies a specific event and provides countsfor the event based on these time measurements:
Interval—Displays the number of occurrences of the event for the most recent monitoring interval.
Rate—Displays the rate per second during the most recent monitoring interval.
Lifetime—Displays the number of occurrences during the life of the event (since the database was activated or performance statistics were reset).
The Tables tab in the Database Analysis drilldown shows a list of tables in the database that are currently experiencing I/O activity. The list provides the following information about each table in a grid format. Since you can choose to hide, display, or rearrange any column in the grid, some columns below might not appear in your current list view, or be in the order shown here.
|
|
The Memory Pools tab on the Database Analysis drilldown helps you keep track of system memory usage as it relates to the database you are monitoring. It is important to remember that, with the notable exception of buffer pools, most memory is allocated dynamically on an as needed basis by the Database Manager.
The memory pools list provides the following information about each memory pool in a grid format. Since you can choose to hide or display any column in the grid, some columns below might not display in your current list view.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
