Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Server hostname from SQL*Plus?

Re: Server hostname from SQL*Plus?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/05/28
Message-ID: <01bc6b98$61cee000$294b989e@WORKSTATION>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US