Tags: break, client, database, event, events, mysql, occasionally, oracle, report, reset, sql, sqlnet, statspack, system
SQL*Net break/reset to client - wait event
I do occasionally see 'SQL*Net break/reset to client' event as one of the top 5 events in our system statspack report. I checked in Oracle documentation and it says,
========================Oracle Doc ============
The server sends a break or reset message to the client. The session running on the server waits for a reply from the client.
Wait Time: The actual time it takes for the break or reset message to return from the client
=========================Oracle Doc ==============
Is this wait events something need to be worried about ? Where do we start investigating this problem ?
Leave a comment...
- 1 Comments
- Looks to me like either this is a high network traffic environment (responses getting through a bit slowly) or a network problem (intermittent breaks/packet loss in the network).
I would suggest to involve your system + network administrators and get the issue resolved.#1; Sat, 23 Feb 2008 19:13:00 GMT