Database Tuning (MOSC)

MOSC Banner

Wait event "SQL*Net more data to client"

edited Apr 25, 2009 4:31AM in Database Tuning (MOSC) 1 commentAnswered
Hi folks ,

From ADDM report I am getting wait events

 Wait event "SQL*Net more data to client" in wait class "Network" was consuming
significant database time.

   RECOMMENDATION 1: Application Analysis, 6.3% benefit (25825 seconds)
      ACTION: Investigate the cause for high "SQL*Net more data to client"
         waits. Refer to Oracle's "Database Reference" for the description of
         this wait event. Use given SQL for further investigation.
      RATIONALE: The SQL statement with SQL_ID "0qk1agyrwvx9x" was found
         waiting for "SQL*Net more data to client" wait event.
         RELEVANT OBJECT: SQL statement with SQL_ID 0qk1agyrwvx9x
         SELECT /*+ OPAQUE_TRANSFORM */
         "ACCOUNT_LINK_CODE_N","TRANS_TYPE_V","TRANS_NUM_V","SERIAL_NUM_N","AD

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center