Re: V$process vs v$session

d.a. wrote:
>
> Hi everyone,
>
> We hit our limit of processes and were trying to track down what was
> connected to Oracle and found that we had half as many entries in V$SESSION
> as there were on V$PROCESS.
>
> Does anyone know the relationship of v$process to v$session? Some queries
> we've done under normal circumstances show that they usually match (using
> addr = paddr) except for 1 extra row on the v$process that has a PID of 1
> and a PROGRAM of "PSUEDO".
>
> Thanks, -Dan

Commonly 1-to-1, but if you are running multithreaded server, then its many-to-one (many sessions can share one process)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."