Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Your instance has spent much of its In Oracle time waiting for RAC or OPS.
| Description | |
| What to do next | Perform one of the following options: n Examine the Oracle events that are grouped in the Oracle RAC/OPS Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event in the Statistics workspace. n Examine Load balancing between RAC instances in the Activity workspace. n Examine Heavy objects suffering from RAC Waits in the Activity workspace. |
| Advice | There are two typical scenarios relevant to RAC Waits. Launch to the Dashboard RAC Database view. This view compares the selected instance with other instances in the same database. From the RAC Database view, examine each of the following issues: n If there is a balancing instances issue, launch to the Activity workspace and identify the root cause for this unbalanced issue. n If there is a RAC Wait event, compare them to other events in the database in the Statistics workspace. n If there are Objects suffering from RAC Waits, launch to the Activity workspace and identify their use across Database instances. |
No comments:
Post a Comment