We must have felt the pain when you have applied multiple patches and each time you have to give Y to the prompt in opatch. There is a solution available to this problem How to run Opatch in a non-interactive form We can run the opatch apply, napply, rollback and nrollback commands in non-interactive mode […]
Sql plan Management in Oracle
SQL Plan Management (SPM) in Oracle is a preventative mechanism that provides a level of control over the execution plans used by the Oracle optimizer. It ensures that regression due to changes in execution plans doesn’t occur, even as the database undergoes changes such as database upgrades, a gathering of new statistics, or changes to […]
Move SQL Baseline from One Database to Another in Oracle
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 […]
how to create sql baseline from AWR repository without STS
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 […]
how to create sql baseline from Sql tuning set in Oracle
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 […]
How to create sql baseline from cursor cache in Oracle
SQL Plan Baselines in Oracle Database are a method for maintaining the consistency of SQL statements’ performance.SQL baseline can be created from cursor cache, AWR, Sql tuning set etc. In this post, We will be looking at How to create sql baseline from the cursor cache in Oracle If you want to create a SQL […]