Toad World® Forums

Server Name?

           How can I  view the name of the backend server in my current connection?

select host_name
from v$instance;

or

select host_name
from gv$instance;

or…

select sys_context(‘USERENV’,‘SERVER_HOST’) from dual