Thanks Daniel Ryan , it is not a time based object. let me go through the blog .

Thanks Thanks Bhaskar , have gone thru link but the option of dbcache does not work.

Thanks R Vohra, it is enabled but we want to purge the cache after daily ETL is complete. Thanks

Hi Brendan, curl -v -x <private_proxy_host:portnumber> -i -X DELETE -H "X-ID-TENANT-NAME:idcs-<>.oraclecloud.com" -u "<user_name>:<password>" https://<oac host>/api/tcm/v1/dbcache TLSv1.3 (IN), TLS handshake, [no content] (0): TLSv1.3 (IN), TLS handshake, Newsession Ticket (4): TLSv1.3 (IN), TLS handshake, [no content]…

Thanks SteveF , We followed KB59916 but as per Oracle the solution hasn't been tested when using proxy server.