Oracle Scratchpad

February 11, 2007

SQL Profiles (10g)

Filed under: CBO, Execution plans, Hints, Performance, Statistics, Tuning — Jonathan Lewis @ 7:43 pm UTC Feb 11,2007

[Forward to part 2]

When the Tuning Advisor suggests that you accept a SQL Profile, what is it offering you. If you want to find out, the following SQL seems to be the appropriate query to run before you accept the profile:
(more…)

Blog at WordPress.com.