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 Shared Pool Wait.
| Description | |
| What to do next | Perform one of the following options: n Examine the Oracle events that are grouped into the Wait for Shared Pool in the Statistics workspace. Determine the dominant Oracle event and follow the tuning scenario set by this event. n Examine high Shared Pool Wait statements in the Activity workspace. |
| Advice | Common scenarios for this wait occur when the shared pool is either too small or too big. Make sure your shared pool is sized according to the type of application being used (cursor sharing, literals usage, and so on.) |
No comments:
Post a Comment