Re: Oracle and UNIX integration...

From: Bob Murphy <murphytx_at_texas.net>
Date: Mon, 07 Feb 2005 06:02:01 -0600
Message-ID: <-_ydnUlXDPECxZrfRVn-qA@texas.net>

Shiva MahaDeva wrote:
...
> How (from UNIX) could I get Oracle application´s username ?
...

Although I am not familiar with Oracle Applications, etc., I quite often find the username by issuing a sqlplus script similar to:

cl scr
prompt
prompt Enter The UNIX PID :
accept PID number

SELECT a.username, a.terminal, a.program, b.sql_text FROM v$session a, v$sqlarea b, v$process c

WHERE   c.spid = &PID
AND     a.paddr = c.addr
AND     a.sql_address = b.address

Hope that helps too, Bob. Received on Mon Feb 07 2005 - 06:02:01 CST