Friday, 6 August 2010

Oracle Reports Cache directory growing rapidly

In R12, when concurrent requests of the execution method of Oracle Reports are submitted, temporary files are present under the path of $INST_TOP/logs/ora/10.1.2/reports/cache. This folder is growing rapidly and consume the disk space on the server and is not being purged at all.

There are multiple solutions to solve this issue

1. Shutdown the Concurrent Processing server.
2. Manually delete all the temporary files under the $INST_TOP/logs/ora/10.1.2/reports/cache path
3. Startup up the Concurrent Processing server.

Other Solution is that

As a current workaround to patch 9032800:

Change the Oracle Reports configuration file $INST_TOP/ora/10.1.2/reports/conf/rwbuilder.conf and bouncing the services.

property name="cacheSize" value="50" to
property name="cacheSize" value="0"

This change will be lost when Autoconfig is run. Apply patch 8602992 for permanent solution


SocialTwist Tell-a-Friend

Related Posts by Categories

No comments: