Oracle Instace host name
SELECT fpov.profile_option_value
FROM fnd_profile_options fpo,
fnd_profile_option_values fpov
WHERE fpo.profile_option_id = fpov.profile_option_id
AND fpo.profile_option_name = 'SITENAME';
SELECT UPPER(HOST_NAME)
FROM V$INSTANCE;