Block lost wait events by Streams Queue size (streams_sqmax) on HP-UX 11.23, HP-UX 11.31 (Doc ID 363418.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.4 to 11.1.0.6 [Release 9.0.1 to 11.1]
HP-UX Itanium
HP-UX PA-RISC (64-bit)
HP-UX ItaniumHP-UX PA-RISC (64-bit)

Symptoms

'gc cr block lost' is at the very top of timed events list reported by AWR or Statspack.
There's no packet loss on switch level,
no discard on os level using netstat or HP's lanadmin tool.

The timed events information of AWR report would be like following:

Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
db file sequential read 5,126,886 108,466 21 49.9 User I/O
gc cr block lost 53,068 57,071 1075 26.3 Cluster
CPU time 14,187 6.5
gc buffer busy 50,686 11,584 229 5.3 Cluster
gc cr grant 2-way 4,087,663 9,262 2 4.3 Cluster
-------------------------------------------------------------

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms