working on applications and technology

Recently I ' m working for a customer for a Oracle Database migration project from Sun Solaris to HP-UX platform. It  is a 10.2.0.4 RAC with totally 3.5 terabyte datafiles which reside on a Symentec cluster file system.  The migration requirement is simple: minimize the downtime of the database and keep it simple.

I consider all the possible solution for database migration across platform:

 Read more

As we mentioned in the last article that with Oracle 10g,  Oracle introduce the concept of 'Metric' and 'Baseline' for pro-active database performance management. It is a big leap for effective performance managment.

What is Metric

For the versions before Oracle database 10g,  The main performance diagnostic tools is statspack.  The essence of stackpack is to compute the change for Oracle internal counters:Read more

Recently I re-read the performance document of Oracle Database 9i,10g and 11g.  It is interesting to notice that different performance tools available with different version of Oracle database.  The newer version always introduce some new concept that lead to new performance tuning methodology.

This evolution of performance methodology could be best descrbied with the following:Read more

Oracle Universal Installer (oui) is an common installer for almost all of Oracle 's products. Although some of Oracle 's new aquired products might still use their own installation process. But It will be replaced by Oracle Universal installer eventually in the long term.Read more

Today a friend ask me a quesiton.
"I know that you talk about the 'select for update' problem long before, but could you tell me how to resolve the performance problem dued to this SQL ? we 're having performance problem right now for our production database!"
Though I have told my friend one year ago to remind him of avoiding this situation using different technique, they 're ending up with this situation!
Why use 'Select for update'?Read more