I am running ords 17 on weblogic server. Our database consists of 407 Tables in total. ORDS requests are taking way too long for simple get requests returning 10 rows of data. It takes around 4 secs. I have tried enabling debug mode but it doesn't log any proper information that can help investigate the issue. I have tried upgrading the connection pool settings but it still hasn't helped.
how long does the SQL or PL/SQL take to run for your restful service?
how big is your pagesize (number of rows?)
how 'far away' is your wls from your db - network latency?
how many sessions do you have going at a time, and how big is your connection pool?