Re: Getting the SID for an Oracle process

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 Thu Apr 08 1999 - 11:23:52 CDT