Wednesday 11 April 2018

handle cancelled session request from java to oracle,When a user run a report query, and he closes the window immediately does the query still keeps running

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:


http://docs.oracle.com/database/122/NETAG/configuring-profiles.htm#NETAG091 

SQLNET.SEND_TIMEOUT=3
lsnrctl stop and start