查询v$asm_disk视图hang住

查看等待事件
select inst_id,sid,username,event,count(*) from gv$session where wait_class<>'Idle' group by  inst_id,sid,username,event order by 4;

查看阻塞会话
select inst_id,sid,username,event,state,blocking_session from gv$session where sid='GPnP Get Item & rdbms ipc reply 等待事件对应的sid';

重启GPnp进程
ps -ef | grep gpnpd.bin
kill -HUP 'gpnpd.bin进程pid'

再次检查
crsctl stat res -t
ps -ef | grep gpnpd.bin
select path from v$asm_disk;