REPOST: Re: Oracle on AIX

faisal_qasim_at_my-deja.com (Faisal Qasim) wrote in message news:<7d83d0a4.0201010216.726cbda0_at_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_at_sybrandb.demon.nl (Sybrand Bakker) Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <a20d28ee.0201010538.5e6d2431_at_posting.google.com> Control: cancel <a20d28ee.0201010538.5e6d2431_at_posting.google.com> Date: Wed, 2 Jan 2002 02:46:53 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.a20d28ee.0201010538.5e6d2431_at_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_at_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 Received on Tue Jan 01 2002 - 07:38:40 CST