Working with Technology at Oracle: Automatic Workload Repository (AWR) by Nisha
By user769227 on Mar 19, 2009
Feature Article: Oracle Customer Services Organisation Blog Week
Oracle 10g provides a wealth of features, and my favorite among them is AWR. AWR has come to my rescue in critical situations where our on-demand customers face performance issues. AWR collects database performance statistics and metrics for analysis and tuning, shows the exact time spent in the database, and even saves session information
Performance can degrade due to a variety of reason such as high load, problems with the network, addition of new code, poor optimizer statistics etc...
We at On Demand are committed toward giving 100% customer satisfaction. The AWR feature comes handy in such situations, and helps us to work towards a better diagnosis.
AWR helps to meet the immediate performance needs of customers and give quick resolution in customer's critical business hours. Also, as AWR collects detailed run-time statistics at specified intervals, it helps us to get the details of a performance issue that had occurred in the past. This helps in identifying recurring issues and. paves the way to arrive at and implement permanent solutions.
This article was written by Nisha who is a member of Oracle's On Demand Team