From: Miller, Dave ( I.S.) (Dave.Miller@BHS.ORG)
Date: Wed Apr 30 2003 - 12:54:41 EDT
You need to do this with SQL...
Run this, supply the pid in question, and you should get user info.
set verify off
set linesize 100
col username format a15
col osuser format a10
col program format a30
select a.username, a.osuser, a.program, a.process, spid, sid, a.serial#
from v$session a, v$process b
where a.paddr = b.addr
and spid = '&spid';
/tempxxx #
-----Original Message-----
From: Green, Simon [mailto:Simon.Green@EU.ALTRIA.COM]
Sent: Wednesday, April 30, 2003 12:40 PM
To: aix-l@Princeton.EDU
Subject: Re: Oracle on AIX: ps -ef command
What you're seeing there is the actual command parameters. It is not
interpreted in any way by the ps command.
Simon Green
Altria ITSC Europe s.a.r.l.
AIX-L Archive at http://marc.theaimsgroup.com/?l=aix-l&r=1&w=2
AIX FAQ at http://www.faqs.org/faqs/aix-faq/
N.B. Unsolicited email from vendors will not be appreciated.
> -----Original Message-----
> From: Leyden, Joseph [mailto:LeydenJ@MTA.NET]
> Sent: 30 April 2003 17:27
> To: aix-l@Princeton.EDU
> Subject: Re: Oracle on AIX: ps -ef command
>
>
> Is it possible on the 'ps -ef' command to show
> the computer name instead of (LOCAL=NO) on display.
>
> example:
> oracledb01 (LOCAL=NO)
>
> preferred:
> oracledb01 ('remote computer name')
>
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:47 EDT