Updating tables through object views in oracle
Having said that, I think your options are: The best option is to use another Data Guard instance (not schema, it have no sense) on another machine.
In this case you can have an up-to-date database an no disturb the production application.
And if the queries against materialized views also doesn't waste too many resources.
"We always did feel the same, We just saw it from a different point of view…
We need to run reports at a scheduled time of the day.
The application runs 24*7 and so there is not "off-peak" time as such.
Therefore, running the reports should not add undue load on the system.