Finding orphan sessions

Hi,

     We have a requirement where we need to find the Orphan session in DB.
Well, it happened some time back when one of our job get killed after
reaching its max time, but it's thread processes were running, so we need a
monitoring sql to check such process who does not have any parent.

     Possible ?

--
Regards,
Tanmoy

-- "Time is the coin of life. Only you can determine how it will be spent."

Other related posts: