V$process vs v$session

From: d.a. <dan_at_nospam.com>
Date: Mon, 17 Sep 2001 12:52:03 -0700
Message-ID: <9o5k94$490$1@news.Stanford.EDU>

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 Received on Mon Sep 17 2001 - 14:52:03 CDT