Path: news.easynews.com!easynews!hub1.nntpserver.com!newsfeed.direct.ca!look.ca!news.noc.cabal.int!resurrector!guidorepost!not-for-mail
From: Bruno Jargot <see@reply.to.invalid>
Subject: REPOST: Re: Oracle on AIX
Newsgroups: comp.databases.oracle.server
X-Repost-Date: 2 Jan 2002 21:33:16 GMT
Message-ID: <0$--$$-$-%--$_%-$$@news.noc.cabal.int>
X-Original-Path: sn-us!sn-xit-03!supernews.com!194.159.255.21.MISMATCH!dispose.news.demon.net!demon!grolier!not-for-mail
X-Original-Message-ID: <aqa33ugdnfu0iiu88o9jlev9gshio393i7@4ax.com>
X-Original-NNTP-Posting-Host: 212.194.85.72
Date: Tue, 01 Jan 2002 13:28:51 +0100
Organization: H.A.T.
Reply-To: bjargot@club-internet.fr
References: <7d83d0a4.0201010216.726cbda0@posting.google.com>
X-Newsreader: Forte Agent 1.8/32.548
X-No-Archive: yes
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Date: 01 Jan 2002 12:28:58 GMT
X-Trace: 1009888138 news.club-internet.fr 24727 212.194.85.72
X-Complaints-To: abuse@club-internet.fr
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:129452
X-Received-Date: Thu, 03 Jan 2002 09:50:35 MST (news.easynews.com)

On 1 Jan 2002 02:16:26 -0800, Faisal Qasim wrote:

>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?

The mapping between the session ID and the PID is done with the
v$process view.

========= WAS CANCELLED BY =======:
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: Bruno Jargot <see@reply.to.invalid>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
Subject: cmsg cancel <aqa33ugdnfu0iiu88o9jlev9gshio393i7@4ax.com>
Control: cancel <aqa33ugdnfu0iiu88o9jlev9gshio393i7@4ax.com>
Date: Wed, 2 Jan 2002 02:06:56 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.aqa33ugdnfu0iiu88o9jlev9gshio393i7@4ax.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009944091 21023 166.102.15.34 (2 Jan 2002 04:01:31 GMT)
X-Complaints-To: abuse@navix.net
NNTP-Posting-Date: 2 Jan 2002 04:01:31 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?
Xref: news.uni-stuttgart.de control:40277426

autocancel
