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 data from the Oracle server.
| Description | |
| What to do next | Perform one of the following options: n Examine SQL*Net relevant statistics in the Statistics workspace. n Identify top statements that suffer from the high Oracle Client Comm Wait in the Activity workspace. |
| Advice | To reduce the amount of data transferred via SQL*Net, consider the following solutions: n Change the SQL statements so that only needed data is transferred to the client. For example, select only columns that are actually used in the client application and only retrieve required rows. n Check that you are not suffering implicit delays in your TCP/IP network by specifying TCP.NODELAY=yes in the SQLNET.ORA files for the Oracle listener and for the application client. 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