SQL*Net message from client
This wait has to do with the time spent waiting on the client, whether it is the app server (as the client) or the client machine logged directly into the database.
Recommendation:
This is all about the application or network waits as it is waiting on client response.
Areas within the application that move large amounts of data should be redesigned to move only pieces of data (i.e. via use of paging) or if the data can summarized within the database before returning to the user.
The application needs to be redesigned to make use of array processing and not use the method of inserting one row at a time using the INSERT statement with the VALUES clause.
