Subscriber Count

    464

Subscribe to Posts by Email

Pages

Debate: SPA vs. SPM vs. ACS, SPM vs. sql_profiles etc.

Well there are many sources to explain about the functionality of

SQL Stored Outlines SQL Profiles SQL Performance Analyzer Adaptive Cursor Sharing SQL Plan Management

Indeed all these tools are available to give the plan stability but with different ways.

Basics:- Plan instability can occur due to bind value differences. Binds are used to reduce […]

SQL Performance Analyzer: Compare two workloads using DBMS_SPA

Hello,

The following Sql performance analyzer procedure helps you to create a comparison report of multiple runs.

This will especially useful when there is a major change in application for example: Application release, or Database optimizer settings changes etc.

**************************************************************************************

Step 1: Adjust the snapshot collection interval accordingly to 15 mins, the default is […]