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 CPU.
| Oracle Wait Event Tuning: Optimization with Oracle Wait Interface and Wait Event Analysis |
| Description | |
| What to do next | Perform one of the following options: n Examine high wait for CPU statements in the Activity workspace. n Examine high n CPU statements usage in the Activity workspace. n Examine CPU utilization in the Statistics workspace. n Try to identify the system processes consuming CPU resources using the Insight Savvy for OS tool. |
| Advice | Perform one of the following options: n Identify other processes in the system. n The instance has spent much of its In Oracle time waiting for CPU; every process running in your system affects the available CPU resources. Effort spent tuning non-Oracle factors can improve Oracle performance. n Identify heavy statements using CPU or Waiting for CPU and try to tune them. |
No comments:
Post a Comment