4 Replies Latest reply on Oct 15, 2019 5:55 PM by thatJeffSmith-Oracle

    ORDS delay > 6 sec between request and answer

    Denis_Levshuk

      Hello,

      I have ords version 3.0.12.263.15.32 and as a web server use tomcat.

      I configure getting data from database using POST request.

      When i call API, on database part executes pl/sql block.

      When i execute it on database directly, in PL/SQL developer, it works fast,   <0.5s.The block fetches and returns it as json, using APEX_JSON pkg.

      When i call it using API, it takes usually > 6 sec. And even when i call it several times consistently, it still takes 6+ sec.

      Maybe someone has got the same issue?