AWR in RAC
Hi
we have a quick question on AWR snapshot in RAC environment
we have 11.2.0.3 2 node RAC
If we connect to instance # 1 and execute --> exec dbms_workload_repository.create_snapshot;
and then query the dba_hist_snapshot, it is showing that the snapshot was created for both instance
although we had connected locally to instance # 1 only.
Is this a normal behavior in 11g RAC?
Also, as part of the automated AWR snapshot,would the engine be capturing the stats for
both instances? If yes, do we need to run awrrpt.sql or awrgrpt.sql to ensure that
the report shows stats from both instances?
we have a quick question on AWR snapshot in RAC environment
we have 11.2.0.3 2 node RAC
If we connect to instance # 1 and execute --> exec dbms_workload_repository.create_snapshot;
and then query the dba_hist_snapshot, it is showing that the snapshot was created for both instance
although we had connected locally to instance # 1 only.
Is this a normal behavior in 11g RAC?
Also, as part of the automated AWR snapshot,would the engine be capturing the stats for
both instances? If yes, do we need to run awrrpt.sql or awrgrpt.sql to ensure that
the report shows stats from both instances?
0