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 …
Top Queries on Sqlplan Management in Oracle Read More »
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 …
adopmon utility in R12.2 Starting with R12.2.5, Oracle provides a utility name adopmon to monitor the progress of the adop session. The adopmon utility is useful both in following the overall progress of a patching cycle and identifying the various individual actions that are being taken. The following example shows how adopmon is used, with …
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 …
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 …
Move SQL Baseline from One Database to Another in Oracle Read More »
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 AWR repository without STS Read More »
