Re: How to Determine Oracle Session ID given UNIX PID?

From: Gaja Krishna Vaidyanatha <oraperfman_at_yahoo.com>
Date: Fri, 04 Apr 2003 15:57:17 -0800
Message-ID: <F001.0057B1E4.20030404155717@fatcity.com>

Sam,

Try this out:

undef os_pid

select S.Username "User", P.Spid "OS ProcessID", S.Sid "Session ID", S.Serial# "Serial#"

   from V$SESSION S, V$PROCESS P
 where S.PADDR = P.ADDR
   and P.SPID = &os_pid
/

Cheers,

Gaja

• Sam Bootsma <sbootsma_at_gbrownc.on.ca> wrote:
  > Oracle 7.3.4 running on AIX 4.3.3
  >
  >
  >
  > The ps command on our AIX box shows a UNIX process
  > taking 50% of the
  > CPU. The PID is 89510. When I try to find the
  > corresponding session on
  > the Oracle database it returns no rows. Is there a
  > way I can map the
  > given PID on UNIX to a session id on Oracle? See
  > below for the query I
  > ran.
  >
  >
  >
  > SQL> l
  >
  > 1 select sid from v$session
  >
  > 2* where process like '%89510%'
  >
  > SQL> /
  >
  >
  >
  > no rows selected
  >
  >
  >
  > Thanks for your information!
  >
  >
  >
  >
  >
  >
  >
  > Sam
  >
  > sbootsma_at_gbrownc.on.ca
  >
  >
  >
  >
  

  ---

---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gaja Krishna Vaidyanatha
  INET: oraperfman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Apr 04 2003 - 17:57:17 CST