Tuesday, June 14, 2011

High Background Process 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 Background Process Wait.
High Background Process Wait findings

Description
What to do next
Perform one of the following options:
n   Examine the Oracle events that are grouped in the Background Process Wait. Determine the dominant Oracle event and follow the tuning scenario set by this event in the Statistics workspace.
n   Examine high Background Process Wait statements in the Activity workspace.
Advice
Examine the Oracle events that are grouped into the Background Processes 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: