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

    ORDS - Long running web service - cancel session


      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?