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 memory.
| Description | |
| What to do next | Perform one of the following options: n Examine high Memory Wait statements in the Activity workspace. n Try to identify the system processes consuming memory using the Insight Savvy for OS tool. |
| Advice | Perform one of the following options: n Identify other processes in the system. The instance has spent much of its In Oracle time waiting for memory; every process running in your system affects the available memory. Effort spent tuning non-Oracle factors can improve Oracle performance. For example: the result of setting a high number of MAX_PARALLEL_SERVERS when using a parallel query option. n Identify heavy statements using High Memory Wait and try to tune them. |
No comments:
Post a Comment