Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

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.

 

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

OptionalRegion1
This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 

  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com