1 Reply Latest reply on Mar 18, 2020 11:19 AM by thatJeffSmith-Oracle

    Restful API's return content type compare with Query and PL/SQL




      I installed Apex and ORDS on tomcat.

      and I did API stress testing.

      and then, I found they are different performance with query's return and plsql's return.

      I mean GET method content return type.



      I used ngrinder tool. it's testing tool.

      Two way was different TPS in same instance.

      For example, query => 600 TPS, pl/sql => 300 TPS.

      and when pl/sql's testing, it makes server down with "java heap space" error.


      Is it right that I found?

      Could tell me why and solution?


      Thank you.