Hi,

When querying V$SESSION, there is a column called TADDR. According to the docs, it is for Transaction State Object. I notice some sessions have a value in the TADDR column while the STATUS column is 'INACTIVE'. Does this mean the session is hang?

Doesn't INACTIVE status mean the SQL statement should finish executing already?

Thanks,