manually_implementation_of_sql_profile
Differences
This shows you the differences between two versions of the page.
|
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(' | select * from table(dbms_xplan.display_awr(' | ||
| + | or adding also plan_hash_value value: | ||
| + | select * from table(dbms_xplan.display_awr(' | ||
| 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
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
