11 Replies Latest reply on Nov 14, 2019 12:51 PM by Jeremy Schlosky

    select 1 from dual query

    Catalin Pana
      Share This:

      I am facing issues with a query which is constantly executing at 1second interval, from multiple servers. Digging into the query itself I have found it is a "select 1 from dual" query (lowercase, not uppercase). I have found that it is being executed by all the AR Servers in the server group.

       

      This query is causing issues on the application performance (especially during Oracle DB maintenance window, during the nighttime).

       

      I know there is a similar query (SELECT 1 FROM DUAL) in uppercase, which is configured in ux.xml on all the MyIT servers, but the one appearing with top executions is the one in lowercase.

       

      I need a way to determine why all the application servers are running this query all the time, and how to modify/disable if necessary.

       

      Thanks

       

      Catalin