Can an active session in oracle be dead?
You should query 
V$SESSION_WAIT
to see what your statement is doing. A short description of the wait events can be found in "Part IV Appendixes", "C Oracle Wait Events" of the "Database Reference"