This alarm is invoked when the value of commits has deviated from a predefined baseline. This is an "informational" alarm and
does not indicate that there is an issue with the database, only that the value of commits is outside what is expected from previous use of the database.
A
baseline is like a reference point or a normal behavior pattern over time for a particular metric (like commits). For example: If your Oracle database's user commits are usually around 30 during regular tasks, that becomes the baseline. Deviations from this baseline could indicate potential issues.
A
baseline alarm in Foglight is triggered when there's a significant deviation from the established baseline. For example: Example: If the baseline for user commits is 12 user commits, a baseline alarm might be triggered if the user commits value suddenly increases to 77 user commits.
This statistic is an indication of how much work is being accomplished within the database. A spike in the transaction rate may not necessarily be bad. If response times stay close to normal, it means your system can handle the added load. Actually, a drop in transaction rates and an increase in response time may be indicators of problems. Depending upon the application, transaction loads may vary widely across different times of the day.
More details on Foglight baselines can be found in Knowledgebase article
4309018.
To review the historical values for this metric, the user can review the data via
Configuration | Databases | Oracle | {INSTANCE NAME OR IP ADDRESS} | Instance Statistics | User Commits | History and then setting the zonar to the desired time range and referring to the average column.
As an example in the image below when reviewing historical data, the highlighted value of 77 that has already been rolled up (due to a four hour retention period) is still significantly larger than the previous rolled up value. When reviewing older historical data such as this is best to refer to the printed metric in the alarm itself which indicates the original non-rolled up value.