AWR on a RAC Environment
Hello Knowledgeable Guys of Oracle Forums...
Finally, our management has bought a license for AWR (after years of using the system!!!) because the database performance has been degrading for quite a while....goodbye to statspack!
I have a question on AWR collection on RAC..
We have a 5 Node RAC Cluster working on Oracle 10g R2 on Linux 5.1...
I would like to know:
1. How to collect AWR snapshots in a RAC environment? Do I need to collect AWR per node (per instance)?
2. Is there a way to collect AWR for the entire RAC cluster (Node 1 to Node 5)?
3. What is the proper way (best way) to collect AWR reports in our 5-node RAC?
4. How does AWR work on RAC?
Any sample blogsites...or sample actual AWR collection that you use in your system...
Thank you