A tuning case study: The goofy optimizer (9i.x RDBMS)
By gaurav.verma on Jan 22, 2007
While it may not be ideal, at times, it may be required to supplement
or coach the CBO to achieve acceptable levels of application
They say: Tune the application first.
And then, many a times, the CBO behaviour is not predictable or
favourable, inspite of its best intentions or internal hueristic rules
or availability of latest statistics with good sampling percent.
is one such example in which Hints had to be used as one of
the last options to improve the performance of a concurrent program.
Read the entire case study here...