select 

SYS_CONTEXT ('USERENV', 'HOST'),

SYS_CONTEXT ('USERENV', 'DB_NAME'),

SYS_CONTEXT ('USERENV', 'SESSION_USER')

from dual