Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the baseline, mobile window, AWR". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what is the baseline, mobile window, AWR".

1. What is the baseline?

A "baseline" is a snapshot set taken at a certain time. The collected data is classified according to the way of grouping statistics, such as lock, the number of sessions, etc., in order to produce a set of curves that change over time. The baseline is used to record the changes in a metric over a period of time, such as the number of user sessions from 8 a.m. to 6 p.m.

The Oracle Database 11g baseline provides the data needed to calculate the threshold over time based on the baseline data. Use baselines to generate AWR reports (compare two periods).

2. What is the mobile window baseline (SYSTEM_MOVING_WINDOW)

By default, Oracle Database 11g defines a mobile window baseline that comes with the system, which corresponds to all AWR data in the AWR retention period (8 days by default). In an Oracle database, only one mobile window baseline can exist, corresponding to the mobile window baseline of the last eight days of AWR data.

The Oracle database automatically maintains a system-defined mobile window baseline. The default window size for the system-defined mobile window baseline is the current AWR retention period and defaults to eight days.

The size (days) of the moving window can only be equal to or less than the number of days in the AWR retention period. Therefore, if you want to increase the mobile window, you first need to increase the AWR retention period. The window size of the AWR retention period and the system-defined mobile window baseline is controlled by two independent parameters. The AWR retention period must be greater than or equal to the window size of the system-defined mobile window baseline.

Thank you for your reading, the above is "what is the baseline, mobile window, AWR" content, after the study of this article, I believe you have a deeper understanding of what is the baseline, mobile window, AWR this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.