Hi,
We are using ORDS 18.2 with Oracle Database 12.1.0.2, PL/SQL blocks exclusively. I have recently noticed ORDS performs quite many roundtrips during every single REST request
1) The first query selects from user_ords_services and is searching for published services for BASE_PATH
2) the second one queries definition from user_ords_modules/handlers/templates
3) the third query checks users_ords_privileges, user_ords_privilege_mappings
Accoring to tcpdump, this adds at least 20-30ms latency because of roundtrips between Application server and DB server. So I'm thinking of cache.caching. I'm not sure if it is was designed to cache REST handlers, but I hope so. Unfortunately my settings does not seem to help
According to log, apex has accepted folliowing parameters:
cache.caching=true
cache.directory=/tmp/apex/cache
cache.duration=hours
cache.expiration=2
cache.monitorInterval=10
cache.procedureNameList=*,*
Our ORDS is deployed on Weblogic 12.2
BR
Pavol Babel
OCM DBA 10g/11g