Yet Another Case Study: The over-commit trap!

plsql tuning:


Its always rewarding to talk about lesser known performance tuning
scenarios, which are not all that well appreciated in the DBA or
developer world. Ask anyone as to what performance tuning has one
worked upon and quite likely, you may hear - Ah well, I made sure the stats gathered were the latest, the right index was being used or I used a hint to use the right index. Typical Answer.

How often do we look at other aspects like the frequencey of commits?

Neither is it good to do commits less frequently, nor is it good to
over-commit. Moderation is the key for a happy medium and at times, it
can have bearings on performance problems as well.

Read the complete discussion 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