Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Server hostname from SQL*Plus?
This might be a clue:
on my 7.3.2.3, the program name for the shadow process is 'oracle_at_hostname (TNS .....)'
Look at:
select program from v$process where addr = (
select paddr from v$session where audsid = userenv('SESSIONID')); Received on Wed May 28 1997 - 00:00:00 CDT
![]() |
![]() |