Tuesday, June 14, 2011

High Parallel Query Server Wait

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


Your instance has spent much of its In Oracle time waiting for the group event Parallel Query Server Wait.
High Parallel Query Server Wait findings

Description
What to do next
Perform one of the following options:
n   Examine the Oracle events that are grouped in the Parallel Query Server Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event in the Statistics workspace.
n   Examine high Parallel Query Server Wait statements in the Activity workspace.
Advice
Examine the Oracle events that are grouped into the Parallel Query Server Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event.





Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: