Re: Oracle on AIX: ps -ef command
From: Miller, Dave ( I.S.) (Dave.Miller_at_BHS.ORG)
Date: 04/30/03
- Previous message: Pugliese, Edward: "Re: Strange networking issue"
- Maybe in reply to: Leyden, Joseph: "Re: Oracle on AIX: ps -ef command"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 30 Apr 2003 12:54:41 -0400 To: aix-l@Princeton.EDU
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')
>
- Previous message: Pugliese, Edward: "Re: Strange networking issue"
- Maybe in reply to: Leyden, Joseph: "Re: Oracle on AIX: ps -ef command"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
