2 Replies Latest reply on Oct 3, 2018 7:56 PM by Pavol Babel

    ORDS REST handlers caching

    Pavol Babel

      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