October 2011
Oracle Database pro-active performance management with Metrics and Alert
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
Oracle database performance methodology evolution - from 9i to 10g and 11g
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