This discussion is archived
1 Reply Latest reply: Jan 10, 2012 5:46 AM by 910040 RSS

Discoverer Desktop Cache usage

910040 Newbie
Currently Being Moderated
Hi,

Can somebody clarify little bit desktop cache usage and ways to control it via setup (registry)?

End users have found strange behaviour that when workbook is closed and opened again after data changes in database, workbook will not show up-to-date data.

I have reproduced this with
Desktop Client 10.1.2.48.18
Desktop Client 10.1.2.55.26

For Viewer I found note stating that Oracle doesn't position Discoverer "for" real- time reporting ...
How Discoverer deals with data in real- time systems [ID 1372946.1]
Applies to:
Oracle Discoverer - Version: 10.1.2.0.2 to 11.1.1.4.0 - Release: 10.1.2 to 11g
Information in this document applies to any platform.
Goal
While using the Discoverer viewer if a report is based on a table that refreshes frequently, it is noticed that the data is not refreshed automatically.
Even if the report is based on a parameter, reentering the parameters values and hitting go still doesn't show the new data.
Solution
This is the expected behavior as Discoverer is a Business Intelligence reporting tool that is not designed to deal with real time data.
it would only report static data and not data that is dynamic.

Discoverer fetches the query results into cache, so changing a parameter values will not cause a re-run of the query on the database.
If the 're-run' is needed then the option 're-run query must be actively selected'.

Hitting the database for every query is a costly operation.
This is why a specific link 'Re-run Query' was given to force hitting the DB when a user wants to see updated data.
Thanks in advance

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points