SQL Tuning - Expert Oracle RAC Performance Diagnostics and Tuning - page 225

Step 1
Execute the following query using SQL*Plus:
SELECT
/*+ NOPARALLEL */ n_name,
r_name,
p_name,
s_name,
SUM(ps_supplycost)
FROM region,
nation,
supplier,
partsupp,
part
WHERE ps_partkey = p_partkey
AND ps_suppkey = s_suppkey
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
GROUP BY n_name,
r_name,
p_name,
s_name;
Step 2
We find the SQL_ID for this query from the V$SQL view:
SQL> SELECT SQL_ID,
SQL_FULLTEXT
FROM V$SQL
WHERE SQL_TEXT LIKE 'SELECT /*+ NOPARALLEL */ N_NAME%';
SQL_ID SQL_FULLTEXT
------------- ----------------------------------------
gbybkujt0w0y6 SELECT /*+ NOPARALLEL */ N_NAME,R_NAME,P
_NAME,S_NAME,SUM(PS_SUPPLYCOST) FROM reg
Step 3
Using the SQL_ID , create a SQL plan baseline for the statement:
SQL> variable sqlid number;
SQL> EXECUTE :sqlid :=DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id=>'gbybkujt0w0y6');
PL/SQL procedure successfully completed.