If you want to purge cache for specific tables during the day, oracle has a utility SAPURGECACHEBYTABLE. However apparently it does not work with many versions of OBIEE. Refer to the bug:
The Bug 6906535 - SAPURGECACHEBYDATABASE AND SAPURGECACHEBYTABLE NOT WORKING IN 10.1.3.4.0 [ID 956345.1]
No comments:
Post a Comment