Shulou(Shulou.com)06/01 Report--

SQL*Net more data from client is not a common wait event, but it is often seen in some scenarios, such as batch insert, update, delete (array of insert, update, delete) single insert (insert), but there are many columns, and most of the column data is very large, such as string fields that are almost filled with 4000 bytes (char, varchar2, etc.). In this case, it is required that insert is a query (select) that uses bound variables. There are too many values in in.

In short, the execution of a statement or a batch of statements, the required data can not be transmitted by SDU at a time, and the wait event will be generated.

So, what is SDU? SDU is Session Data Unit.

SDU sizes can range from 512 to 65535. The default SDU size for clients and dedicated services is 8192 bytes. For shared services, the default size of SDU is 65535 bytes.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.