SQL*Net break/reset to client (%)


The server is sending a break or reset message to the client. The session running on the server is waiting for a reply from the client.

These waits are caused by an application attempting to:

If the value, v$session_wait.p2, for this parameter equals 0, it means a reset was sent to the client. A non-zero value means that the break was sent to the client.

Metric Summary

The rest of the information in this section is only valid for this metric when it appears in either the Enterprise Manager Grid Control or the Enterprise Manager Database Control (if applicable).

The following table shows how often the metric's value is collected and compared against the default thresholds. The 'Consecutive Number of Occurrences Preceding Notification' column indicates the consecutive number of times the comparison against thresholds should hold TRUE before an alert is generated.

Target Version

Evaluation and Collection Frequency

Upload Frequency


Default Warning Threshold

Default Critical Threshold

Consecutive Number of Occurrences Preceding Notification

Alert Text


Every Minute

After Every Sample



Not Defined


%value%%% of service time is spent waiting on the 'SQL*Net break/reset to client' event.

Data Source

(DeltaNetResetToClientTime/DeltaServiceTime)*100 where:

Wait time: Up to one second, then loop back and check that buffer is clean.


P1: Absolute file number

P2: Block number

See Idle Events

User Action

If these waits are significant, track down the application logic producing these errors to reduce these waits. Check in v$sysstat "parse count (failures)" to see that statements have been parsed where columns or tables are unknown. The statistic "parse count (failures)" does not increase if you send SQL with invalid syntax.

The clearest method to track down the root cause of the error is to run tracing on the users experiencing the wait. Their trace files will contain the SQL statements failing and generating the break/reset wait.

Related Topics

About Alerts

About the Metric Detail Page

Editing Thresholds

Understanding Line Charts