hostname not desplayed fully in v$instance view
zombieMay 17 2011 — edited May 17 2011HI All,
I am facing a pecuilar problem with my Oracle 10gR2 database.
As i am unable to view the full server hostname by quering the v$instance view from the database level.
Please help me with this as to how do i update the v$instance view to display the full hostname of the server.
output given below
SQL> select distinct(HOST_NAME) from v$instance;
HOST_NAME
----------------------------------------------------------------
uaedxbpd
SQL> !hostname
uaedxbpdctapp02
DB Version:10gR2
OS :HP-UX