From: Damir Delija (damir.delija@PBZ.HR)
Date: Fri May 02 2003 - 01:35:51 EDT
In the ps you can't
but you can use lsof
something like
ps -ef | awk '$1~/oracle/ && $NF~/\(LOCAL=NO\)/ { print $2}'| xargs -n 1 lsof -p | grep TCP
or as you have perl on the system and get something much compact and more readable ...
> -----Original Message-----
> From: Leyden, Joseph [mailto:LeydenJ@MTA.NET]
> Sent: Wednesday, April 30, 2003 6:27 PM
> 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:48 EDT