Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!cyclone.bc.net!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Subject: REPOST: Re: Oracle on AIX
Newsgroups: comp.databases.oracle.server
X-Repost-Date: 2 Jan 2002 21:24:20 GMT
Message-ID: <7$--$$-$-%-___$$$$@news.noc.cabal.int>
X-Original-Path: sn-us!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
X-Original-Message-ID: <a20d28ee.0201010538.5e6d2431@posting.google.com>
X-Original-NNTP-Posting-Host: 212.238.21.78
Date: 1 Jan 2002 05:38:40 -0800
Organization: http://groups.google.com/
References: <7d83d0a4.0201010216.726cbda0@posting.google.com>
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
Sender: resurrector@mindspring.com (Guido the Resurrector)
X-Reposted-By: resurrector@mindspring.com (Guido the Resurrector)
X-Comments: GtR Repost: The following Usenet article was cancelled, more
X-Comments: than likely by someone other than the original poster.  Please
X-Comments: see the end of this posting for a copy of the cancel.
X-Comments: Guido the Resurrector can be contacted at
X-Comments: resurrector@mindspring.com.
Xref: easynews comp.databases.oracle.server:129451
X-Received-Date: Thu, 03 Jan 2002 09:50:28 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

========= WAS CANCELLED BY =======:
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!uunet!osa.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: postbus@sybrandb.demon.nl (Sybrand Bakker)
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
Subject: cmsg cancel <a20d28ee.0201010538.5e6d2431@posting.google.com>
Control: cancel <a20d28ee.0201010538.5e6d2431@posting.google.com>
Date: Wed, 2 Jan 2002 02:46:53 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.a20d28ee.0201010538.5e6d2431@posting.google.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009944087 21023 166.102.15.34 (2 Jan 2002 04:01:27 GMT)
X-Complaints-To: abuse@navix.net
NNTP-Posting-Date: 2 Jan 2002 04:01:27 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?
Xref: news.uni-stuttgart.de control:40277414

autocancel