0 Replies Latest reply on May 9, 2019 3:46 PM by user10935427

    ORDS - Long running web service - cancel session

    user10935427

      We have an ORDS service that can take a very long time under certain conditions.

       

      The user gets bored, close their browser and try again, however in Oracle, the database session continues to execute until completion (which can be a very long time).

       

      Can Tomcat/ORDS receive a cancel session (akin to pressing ctrl+c in SLPlus, or break in plsql or break in sql developer)?

       

      We are seeing these queries continue to gobble up resources long after the user has logged out of their browser.

       

      Any ideas?