I am studying AWR, which will be used in our project for performance analysis. My requirement is to create a baseline of load between 2 snapshots during normal system load. We perform load/stress testing before final deployment. We are planning to take snapshots before and after load/stress tests. I want to compare the performance of the instance during the load/stress test with that of baseline performance.
Oracle provides the package DBMS_WORKLOAD_REPOSITORY for different functions of AWR. It provides the function CREATE_BASELINE function for creating baseline. But in the report generation function AWR_REPORT_HTML or AWR_REPORT_TXT no parameter is specified for comparing it with the baseline.
Is it possible to compare AWR data with the baseline during report generation? Currently Oracle supports only baseline creation and dropping that baseline. It can not be used for performance comparison.
This was first published in October 2004