Skip to Content
avatar image
Former Member

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

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.
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded