Calendar

March 2010
S M T W T F S
« Feb    
 123456
78910111213
14151617181920
21222324252627
28293031  

Oracle Performance Tuning

Recently I am struggling to deal with the performance tuning of oracle databases. As we used Baan IVc4 and Oracle 9i, it keeps growing the data space of index and data. It has been 7 years without much actions to the database performance.

The thing I would like to tackle is that I must rebuild some [...]

Baan ASCII Functions

Last week I was asked to verify the item description to exclude certain characters and to limit the first character with 0-9 and A-Z. As some of the characters such as double quote (“) and semicolon (;) can not be easily used in the expressions, I finally decided to use the value of ASCII alternatively.

There [...]

Baan IVc4 Installation for China Projects

Last 2 weeks was a nightmare for me. It ruined my time to install the Baan IVc4 for China factories. Even though it was finally fixed it, I was not satisfied with the progress.

The installation was hosted on: – VMware ESX 3 (Two VM Servers); [...]