If the datawindow query is stuck for long time for retrieving data from database

[Former Member]

If the datawindow query is stuck for long time for retrieving data from database due to any one of following reason. 1. Database disconnected 2. Database slowness 3. If the data is huge to retrieve from database. If it is stuck for more than two hours then at 120th minute It should automatically terminate the application.

[former_member214873]

HI Ramachandran

There is a one workaround solution is there. we can create one profile and assign the database user

setting profile limit timeout of 120 mins

If a user exceeds the CONNECT_TIME or IDLE_TIME session resource limit, then the database rolls back the current transaction and ends the session. When the user process next issues a call, the database returns an error.

for more information follow the link

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6010.htm