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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > ===== __________________________________________________ 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).