Database Administration (MOSC)

MOSC Banner

Addm report findings

edited Dec 29, 2013 9:34PM in Database Administration (MOSC) 4 commentsAnswered ✓
Hi
In database ADDM report display some information about Network waits as bellow. What are the impact of this wait events and how to solve this kind of issues.


Finding 5: Unusual "Network" Wait Event
Impact is .03 active sessions, 11.71% of total activity.
--------------------------------------------------------
Wait event "SQL*Net more data to client" in wait class "Network" was consuming
significant database time.
 
   Recommendation 1: Application Analysis
   Estimated benefit is .03 active sessions, 11.71% of total activity.
   -------------------------------------------------------------------
   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.
 
   Recommendation 2: Application Analysis
   Estimated benefit is .03 active sessions, 11.71% of total activity.

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