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_at_reply.to.invalid>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
Subject: cmsg cancel <aqa33ugdnfu0iiu88o9jlev9gshio393i7_at_4ax.com>
Control: cancel <aqa33ugdnfu0iiu88o9jlev9gshio393i7_at_4ax.com>
Date: Wed, 2 Jan 2002 02:06:56 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.aqa33ugdnfu0iiu88o9jlev9gshio393i7_at_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_at_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
Received on Tue Jan 01 2002 - 06:28:51 CST