Database Reference
In-Depth Information
SQL*Net More Data to Client
Oracle is attempting to send more data or messages to the client over and above the SDU limit. This event indicates
tuning the SDU parameter at the SQL Net layer. Please note that starting with Oracle Database 11g, the SDU defaults
to 8K.
SQL*Net More Data From Client
This is similar to the previous event; however, in this case, the event is triggered when the client is attempting to send
packets larger than the SDU size. This event normally occurs in batch application performing high-volume inserts.
Increasing the SDU size can help improve this wait event.
Conclusion
Response times for the end user are just not confined to tuning the database and SQL queries. If the buffer or pipe
that carries the data back and forth between the client or application server and the database server is not sufficiently
sized, the overall response time maybe affected. Similarly, if the application server or the client is not tuned or has
network buffers sized well, the database will spend time waiting to send data to the client; and only when the client
buffer is freed up will new data be sent to the client application.
Tuning the network layers using the SDU parameters and where possible using network technologies such as
jumbo frames and setting the array sizes inside the application code to a large size should be considered in tuning the
application to give good response times.
Search WWH ::
Custom Search