Processes Hang Waiting on 'cursor: pin S wait on X' (and other Wait Events) on HP-UX 11.23 and 11.31 Itanium Systems

(Doc ID 580273.1)

Last updated on JANUARY 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
HP-UX Itanium


Process hangs indefinitely waiting on one of the following wait events:

There is no blocker process.
The variety in wait events is explained by the fact that the underlying issue is with the pw_wait() HP-UX system call.
Therefore, the above list is not exhaustive, use the pstack output below to match the problem in all cases.
The problem is commonly seen on Parallel Execution Slave processes but can affect any Oracle process.
A command to generate a  systemstate, processstate, or errorstack dump e.g. via ALTER SESSION or oradebug command frees the hanging process.

An example of the top of the call stack of an affected process, obtained using pstack:

 0: c0000000003e2ff0 : pw_wait() + 0x30 (/usr/lib/hpux64/
 1: 4000000002e98a20 : pw_wait() + 0x80 
 2: 4000000002e492f0 : sskgpwwait() + 0x170 (/oracle/DwhProd/orabin/oradb/pr
 3: 4000000002e3af80 : skgpwwait() + 0xa0 (/oracle/DwhP
 4: 4000000002d6ffd0 : ksliwat() + 0x670 
 5: 4000000002d4a1b0 : kslwaitns_timed() + 0x70 
 6: 4000000002d4b9b0 : kskthbwt() + 0x190 (/oracle/DwhProd/orabin/oradb/p
 7: 4000000002e35220 : kslwait() + 0xe0 (/oracle/DwhPr

First few calls of the call stacks will differ depending on the particular wait event.

Output of the tusc system call tracer tool will be similar to the following:

( Attached to process 6144 ("ora_j032_SATAVA02") [64-bit] )
 15:30:27 [6144]{631499} #1 pw_wait(0x9ffffffffffe1700) ... [sleeping]
 User time:                     0.00
 Interrupt time:                0.00
 Elapsed time:                 66.3


The following HP Patch Bundle for 11.31 may have been recently applied
Mar 2008: FEATURE11i,B.11.31.0803.318b.

Note: it has been brought to our attention that the problem may also occur on HP-UX 11.23 systems.


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