How to Configure AWR for 11G
If you use Oracle Database 11g software, you can utilize the Automatic Workload Repository. AWR, first introduced in Oracle Database 10g, is a part of Oracle STATSPACK, the software that analyzes and reports your server loads. AWR can be used to measure various server performance issues, for example. To configure AWR on Oracle Database 11g, you can set up AWR baselines -- the AWR tests -- in the command-line. That said, it's simpler to do this from your graphical user interface.
Other People Are Reading
Instructions
-
-
1
Log in to your 11g Enterprise Manager. The login details will be specific to your server.
-
2
Click "Server" followed by "AWR Baselines." Click "Create." This loads the baselines creation screen, allowing you to configure AWR.
-
-
3
Click either "Single" or "Repeating," depending on what type of check you want to run. Click "Continue."
-
4
Type a name for your baseline and then click either "Snapshot Range" or "Time Range." If you chose the Snapshot timeline, click "Start Time" and then select your start time from the chart. After this, click "End Time" and choose the desired end time. If you chose the Time Range option, follow the same procedure, but be sure to use dates instead.
-
5
Click "Finish." You have now finished configuring AWR for Oracle Database 11g.
-
1
