Database Administration (MOSC)

MOSC Banner

Top 5 Timed events from Statspack - SQL*Net break/reset to client

edited May 13, 2013 10:06PM in Database Administration (MOSC) 3 commentsAnswered
11.2.0.2

Hi,

Below is the Timed events from a statspack report (1.5h):

Top 5 Timed Events                                                    Avg %Total
~~~~~~~~~~~~~~~~~~                                                   wait   Call
Event                                            Waits    Time (s)   (ms)   Time
----------------------------------------- ------------ ----------- ------ ------
SQL*Net break/reset to client                       68      64,820 ######   93.4
db file sequential read                        557,838       2,014      4    2.9
db file scattered read                         316,048       1,314      4    1.9
CPU time                                                       442            .6
read by other session                          139,382         301      2     .4

Should I be worried by the SQL*Net break/reset to client ?

I found http://blog.tanelpoder.com/2008/04/10/sqlnet-breakreset-to-client/

But I still not sure what to do.

Any advice?

Regards

S

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