InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Are There Any Special Features In Oracle Real Application Clusters (rac)? |
|
Answer» In general, we recommend that you set the SNAPSHOT level to the value 7 in the CASE of RAC. This means that the most heavily loaded SEGMENTS are recognized at segment level. These statistics help you to localize hot spots. To GENERATE a snapshot in an RAC environment, you must log on to the RAC instance for which you WANT to generate statistics. To set up automatic generation of snapshots in an RAC environment with the spauto.sql script for each RAC instance, you must run this script once on each instance. To create an performance report in an RAC environment, you must log on to the RAC instance for which you want to generate a performance report. In general, we recommend that you set the snapshot level to the value 7 in the case of RAC. This means that the most heavily loaded segments are recognized at segment level. These statistics help you to localize hot spots. To generate a snapshot in an RAC environment, you must log on to the RAC instance for which you want to generate statistics. To set up automatic generation of snapshots in an RAC environment with the spauto.sql script for each RAC instance, you must run this script once on each instance. To create an performance report in an RAC environment, you must log on to the RAC instance for which you want to generate a performance report. |
|