Re: Getting the SID for an Oracle process

Using the relationship v$process.addr = v$session.paddr I get the answer I wanted.

Cheers,

Kevin

Ron Reidy wrote in message <370CD818.FCC6BF7C_at_uswest.net>...
>Look at V$PROCESS and V$SESSION.
>
>rr
>
>Kevin Berry wrote:
>
>> Hi,
>>
>> How do I tie the UNIX PID of a oracle server process back to the Oracle
SID.
>>
>> I often need to find out who is using CPU cycles on our Digital UNIX box.
>> This is easy if they are connecting from the server itself because the
Unix
>> process id is referenced in v$session. However, most of the users are
>> connect from PC clients and the PID referenced in v$session is, I assume,
>> the PID of the Windows 95 process not that of the local oracle process.
>>
>> Oracle server is;
>>
>> Oracle7 Server Release 7.3.2.3.0 with the 64-bit option - Production
Release
>> With the distributed, parallel query and Spatial Data options
>> PL/SQL Release 2.3.2.3.0 - Production
>>
>> Any pointers would be appreciated.
>>
>> Kevin
>
Received on Fri Apr 09 1999 - 06:28:40 CDT