Ask the Expert

Comparing AWR data with the baseline during report generation

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.

    Requires Free Membership to View

Baselines can be used for loading SQL Tuning Sets and for setting alert/warning metric thresholds; they are also used by the Automatic Database Diagnostic Monitor (ADDM) for comparisons with similar workload periods when performance problems occur. I don't know of a way, though, to specify a baseline for manual comparison during report generation. I'd invite other readers to let us know if they have discovered a way to use baselines for this purpose.

This was first published in October 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: