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