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;