Hello Friends, In this post we will discuss creating sql baseline and force query to use better execution plan (plan hash value). ...
Read More
Showing posts with label Oracle Tuning. Show all posts
Showing posts with label Oracle Tuning. Show all posts
STEPS TO COPY SPM BASELINE FROM PROD TO TEST
Step 1: RUN QUERY ON THE SOURCE Database Run the SQL on the source database and get the sql_id and plan_hash_value sql_id: 5qw0w762nh6sq ...
Read More
Steps To Run SQL Tuning Advisor For A Sql_id
Sql_id used for example : 5qw0w762nh6sq Step 1 : Create Tuning Task DECLARE l_sql_tune_task_id VARCHAR2(100); BEGIN l_sql_tune_task_...
Read More
Subscribe to:
Comments (Atom)