node information

set lines 300
select INST_ID,HOST_NAME,INSTANCE_NAME,TO_CHAR(STARTUP_TIME, 'DD-MON-RR HH24:MI:SS') FROM gv$instance;


col "Conc_Node" for a20
col "Conc_Node" for a10
col "Form_Node" for a10
col "Web_Node" for a10
col Admin_Node for a10
col DB_Node for a10
select NODE_NAME,
decode(SUPPORT_CP,'Y','Yes','No') "Conc_Node",
decode(SUPPORT_FORMS,'Y','Yes','No') "Form_Node",
decode(SUPPORT_WEB,'Y','Yes','No') "Web_Node",
decode(SUPPORT_ADMIN,'Y','Yes','No') "Admin_Node",
decode(SUPPORT_DB,'Y','Yes','No') "DB_Node",
decode(STATUS,'Y','Enabled','Not Enabled') "Status"
from apps.fnd_nodes order by 1;