Forum Stats

  • 3,750,416 Users
  • 2,250,175 Discussions
  • 7,866,972 Comments

Discussions

ORDS REST handlers caching

Pavol Babel
Pavol Babel Member Posts: 2

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

Kiran Pawar

Answers