In a dedicated server environment when the session is killed and the
rollback completes the process goes away so a join between v$session
and v$process will fail. The v$session entry also usually goes away
rather quickly, though I have seen cases where the v$session entry hung
around till the instance was bounced. But normally Oracle will overlay
the v$session entry with a new session using the same sid but a
different serial# within seconds on a busy system.
HTH -- Mark D Powell --
'
Received on Fri Jan 21 2005 - 08:25:43 CST
