Yes sir.. It works.. Thanks.. Exactly what I was looking for..

Can you please tell me, why some Unix PID is in v$process and only some in v$session, when you get a chance..

I shall re-write my query now to accommodate both the views..

Thanks, ST2000