working on applications and technology

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

What is the biggest database problem that most customer care about most. Many of them might pick the answers:
database performance!
Even with today 's uper power CPU and high capacity memory , even there 're so many tools we could use to investigate and diagnostic the performance problem. Few could have confidence that their database do not have performance problem.
According to experts from Oracle
"Most of today's database systems have been coded sub-optimally yet deliver performance that satisfies the customers requirements"Read more