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 the group event Resource Manager Wait.
| Description | |
| What to do next | Perform one of the following options: Examine the top statements that suffer from high Resource Manager Wait, and the influence of the wait on the instance in the Activity workspace. Try to identify the most dominant events related to Resource Manager Wait in the Statistics workspace. |
| Advice | To reduce the high Resource Manager Wait, consider the following solutions: Examine the Overtime graph for the instance, in order to measure the severity of the Resource Manager Wait. Also check the top statements that suffer from Resource Manager Wait. Checking the statements can reveal whether the problem relates to a specific statement. In the Statistics workspace, examine the Oracle events that are grouped to Resource Manager Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event. |
No comments:
Post a Comment