High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

SQL*Net vector data from client

Client is indicating getting Very Slow response from his logical  database ,8-15-2015 from 10:00 AM to 11:00 AM.

Does the following indicating that I have to go ahead with a network issue troubleshooting?

I can see SQL*Net vector data from client is the top event and ADDM mentioning also Network

AWR report:

top 5 Timed Foreground Events

Event                                         Waits    Time(s)    Avg wait (ms)    % DB time    Wait Class

SQL*Net vector data from client    7,364    3,515    477    924.07    Network

log file sequential read                25,426    154    6    40.38    System I/O

DB CPU                                   101         26.49   

RFS ping                                  54    101    1862    26.43    Other

control file sequential read         13,445    11    1    2.99    System I/O

ADDM:

Activity During the Analysis Period

-----------------------------------

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