Path: news.easynews.com!easynews!news.he.net!news!sn-xit-03!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle on AIX
Date: 1 Jan 2002 05:38:40 -0800
Organization: http://groups.google.com/
Lines: 22
Message-ID: <a20d28ee.0201010538.5e6d2431@posting.google.com>
References: <7d83d0a4.0201010216.726cbda0@posting.google.com>
NNTP-Posting-Host: 212.238.21.78
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1009892320 24360 127.0.0.1 (1 Jan 2002 13:38:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 1 Jan 2002 13:38:40 GMT
Xref: easynews comp.databases.oracle.server:129331
X-Received-Date: Tue, 01 Jan 2002 06:38:31 MST (news.easynews.com)

faisal_qasim@my-deja.com (Faisal Qasim) wrote in message news:<7d83d0a4.0201010216.726cbda0@posting.google.com>...
> Dear all,
> 
> How to map AIX process numbers to Oracle 7.3.4 sessions? Facing slow
> system performance, we were trying to find the heaviest sessions, but
> AIX shows OS process numbers and Oracle shows its session id. How to
> map these?
> 
> Regards
> 
> Faisal Qasim

select sid, serial#, program, terminal, spid "OS process id"
from v$session s, v$process p
where p.addr = s.paddr
and   s.sid = <yoursid>
(or p.spid = <your os process id>

Hth

Sybrand Bakker
Senior Oracle DBA