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 statement has spent much of its In Oracle time waiting for a remote query to complete.
| Description | |
| What to do next | Perform one of the following options: n Select the findings type to see the SQL text sent to the remote database on the Statistics tab, Other column. n Examine DBLink relevant statistics in the Statistics 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: the TNSNAMES.ORA configuration file and in the LISTENER.ORA configuration file in the Oracle database server. |
No comments:
Post a Comment