Hello.
We have an Oracle Database Enterprise Edition 11.2 running on Solaris SPARC 64-bit OS. We are facing issues from time to time cause by inactive sessions in the database that are consuming large amounts of memory and swap (even exhausting it). This issue is fixed by killing them but eventually this builds up. How come when a session is inactive (and the LAST_CALL value is big) it uses so much resources? It seems it builds up by the past queries that are run through the connection.