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 remote queries to complete.
| Description | |
| What to do next | Perform one of the following solutions: n Examine DBLink relevant statistics in the Statistics workspace. n Try to identify the statement suffering from a high wait for Oracle Comm Wait in the Activity workspace. |
| Advice | To reduce remote access wait time, consider the following options: n Launch Precise for Oracle on the remote instance, locate the remote query, and tune the statement. n Control the driving instance executing the statement by using the DRIVING_SITE hint. n Tune SQL*Net throughput by checking SDU and TDU settings. n Include TCP.NODELAY=yes parameter in the SQLNET.ORA configuration file. n Specify the parameters TDU and SDU in the connection description on the application client. For example: in the TNSNAMES.ORA configuration file and in the LISTENER.ORA configuration file on the Oracle database server. |
No comments:
Post a Comment