We have surfaced one database contention problem in Oracle during performance run and got to know that
oracle has in build feature to provide system workload report which they call as AWR ( Automatic work load) tool.
Interestingly it helped a lot to find the table and query which was giving problem during performance run and help to solve the issue.
More read @ following links, it has been introduced in oracle 10 onwards :
http://www.oracle-base.com/articles/10g/automatic-workload-repository-10g.php
Cheers ,
Kapil
No comments:
Post a Comment
Thanks for your comment, will revert as soon as we read it.