moving window baseline

jichengjie發表於2018-04-13
A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This
is useful when using adaptive thresholds because the database can use AWR data in the entire AWR
retention period to compute metric threshold values. Oracle Database automatically maintains a systemdefined
moving window baseline. The default window size for the system-defined moving window baseline
is the current AWR retention period, which by default is 8 days. If you are planning to use adaptive
thresholds, consider using a larger moving window--such as 30 days--to accurately compute threshold
values. You can resize the moving window baseline by changing the number of days in the moving window
to a value that is equal to or less than the number of days in the AWR retention period. Therefore, to
increase the size of a moving window, you must first increase the AWR retention period accordingly

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26870952/viewspace-2152880/,如需轉載,請註明出處,否則將追究法律責任。

相關文章