There are three types of baselines: Fixed, Moving Windows and Templates. In this chapter, we will focus in the third one, where our target is to create baselines for a contiguous time period in the future. There are two types of baseline templates: single and repeating.
They are very easy to create through "DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE" procedure. In the documentation, in less than 10 seconds you can reach that procedure with examples for both cases.
Enterprise Manager is also a very fast approach, but for this topic specially I would go for the packages.
Of course that a baseline must be used for something after it's created and stats computed. The main purpose is to compare periods to check system performance and also use the "Baseline Metric Thresholds" tool.
Path to Documentation:
Performance Tuning Guide -> 5.3.3 Managing Baseline Templates
Click here to go back to the Main OCM 11g Preparation page.
Have you enjoyed? Please leave a comment or give a 👍!
