Skip to Content
0

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

Aug 23, 2017 at 04:01 PM

25

avatar image
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.
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Aug 29, 2017 at 03:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded