Here are some beneficial Queries on Sqlplan Management in oracle How to check the sql plan parameter show parameter sql_plan How to check the settings for Automatic plan capture If OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=true, then we can use the below query to find out the settings of the automatic plan capture How to check the sql baseline for […]

In this post, we will check out how to move SQL baseline from One Database to Another  How to move the sql baselines in Oracle Suppose you have created a sql baseline in System A and Now you want to transfer that sql baseline to System B. Step 1On System A: Creating a staging table

We have seen that sql baseline can be created with AWR using sql tuning set. With 12c, Oracle provided a way to directly create sql baseline using AWR without creating the tuning set. It is through procedure  DBMS_SPM.LOAD_PLANS_FROM_AWR. In this post, we will check how to create sql baseline from the AWR repository without STS

Sql baseline can be created from cursor cache, AWR and Sql tuning set. In this post, we will check out how to create sql baseline from Sql tuning set in Oracle How to create the Sql tuning set This can be done using the DBMS_SQLTUNE.CREATE_SQLSET procedure. In the following example, we’re creating a SQL Tuning