In 8i and onwards we can find the hostname from v$instance (select host_name from v$instance). I want to find out in 7.3.4 which view/function will get me the hostname...thanks in advance.Oracle LazyDBA home page