Backend db is oracle 11g Frontend is Java
handle cancelled session request from java in oracle,When a user run a report query, and he closes the window immediately does the query still keeps running.
Due to an abnormal client termination. If the probe finds a terminated connection, or a connection that is no longer in use.
The SQLNET.EXPIRE_TIME (set in your sqlnet.ora) determines how often you check for dead connections: