I have a front end Java application server (Resin) running which connects to my Oracle DB 8.1.7.3. I notice when I query V$SESSION, the number of INACTIVE sessions is growing. Their TADDR entry is Null so no locks are placed on objects for the inactive sessions. My question is:
When does an INACTIVE session disappear from V$SESSION?
Thanks,