User Tools

Site Tools


manually_implementation_of_sql_profile

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

manually_implementation_of_sql_profile [2017/12/29 11:07]
admin created
manually_implementation_of_sql_profile [2018/01/09 14:46] (current)
admin
Line 5: Line 5:
 2. Obtain the sql plan hints: 2. Obtain the sql plan hints:
   select * from table(dbms_xplan.display_awr('2tgrx1vgdw0t9',format => 'ADVANCED'));   select * from table(dbms_xplan.display_awr('2tgrx1vgdw0t9',format => 'ADVANCED'));
 +or adding also plan_hash_value value:
 +  select * from table(dbms_xplan.display_awr('9tk35vcp7znns',plan_hash_value => '2586930822', format => 'ADVANCED'));
  
 3. Create sql profiles for sql_id using the above hints: 3. Create sql profiles for sql_id using the above hints:
manually_implementation_of_sql_profile.1514538444.txt.gz ยท Last modified: 2017/12/29 11:07 by admin