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 MTS Wait.
| Description | |
| What to do next | Perform one of the following options: n Examine high MTS wait by programs in the Activity workspace. n Try to identify the most dominant events related to MTS Wait in the Statistics workspace. |
| Advice | To reduce high MTS wait, consider the following solutions: n Examine the Overtime graph for the instance, in order to measure the severity of the MTS Wait. Look for top programs suffering from MTS Wait. n Examine the memory usage of MTS connections by querying v$sesstat and v$sessions. Measure the maximum amount of UGA memory used at any given moment and divide that amount by the number of current user sessions. This determines the average amount of memory each connection allocates. n If your environment is not suited to MTS, use "dedicated" connections which create a separate server process for each user connection. |
No comments:
Post a Comment