ASM Hang due to high number of GCS_SERVER_PROCESSES (Doc ID 1959934.1)

Last updated on JANUARY 08, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

operation like cd on ASMCMD or mv may hang
While creating standby redo log file hang & forced to bounce the dataabase

Number gcs_server_processes at ASM level was 4

 

From hang analysis,

Chain 1 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/20/8/0x6bd49c68/14486/buffer busy>
Chain 2 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/21/20/0x6bd49480/13256/buffer busy>
Chain 3 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/22/6/0x6bd48c98/31295/buffer busy>
Chain 4 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/23/3/0x6bd484b0/25421/buffer busy>
Chain 5 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/24/3/0x6bd47cc8/26063/buffer busy>
Chain 6 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/25/2/0x6bd474e0/26061/PX Deq: Execute Reply>
Chain 7 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/26/22/0x6bd43d88/31999/DIAG idle wait>
Chain 8 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/28/50/0x6bd46510/19505/buffer busy>
Chain 9 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/29/371/0x6bd45540/19081/buffer busy>
Chain 10 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/30/2209/0x6bd44d58/12823/no free locks>
Chain 11 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/31/3347/0x6bd44570/20624/no free locks>
Chain 12 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<2/48/1/0x6bd3bf08/7465/No Wait>
Chain 13 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<0/24/13/GCS lock esc X>
Chain 14 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<0/28/427/PX Deq: Execution Msg>
Chain 15 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<0/29/3971/GCS lock esc X>
Chain 16 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<0/30/5/PX Deq: Execute Reply>
Chain 17 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :
<0/31/3272/PX Deq: Execution Msg>
Chain 18 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :

 

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