col client_instance_name format a21
col host_name format a9
col status format a9

select distinct i.host_name, i.instance_name asm_instance_name,
c.instance_name client_instance_name, c.db_name, c.status
from gv$instance i, gv$asm_client c
where i.inst_id=c.inst_id;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.