Cache purging in OAC
Hello,
How does the cache gets purged in OAC. We want to schedule purging of cache in our oracle managed OAC instance, what are the options available (calling scripts/APIs etc).
Any suggestions?
Thanks,
Kanaka
If you ever get an answer I'd like to know too
To purge the cache manually, use this command in the "Issue Sql" in the Administration Console:
Call SAPurgeAllCache();
* and make sure to uncheck "Use Oracle BI Presentation Services Cache"
There are also additional purging options by DB, table and query... as well as continued reading about developing your cache strategy:
https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/querycaching.htm#BIESG244
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
