A tuning case study: The goofy optimizer (9i.x RDBMS)

oracle_optimizer:

While it may not be ideal, at times, it may be required to supplement
or coach the CBO to achieve acceptable levels of application
performance.

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.

This
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...


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

bocadmin_ww

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today