I am running an Oracle 11g database with a physical standby. I am trying to use Oracle's new ability to run an Active Standby to allow reports and other internal querying to take place on the Standby, instead of taking up resources on the primary.
The problem i am having though is that when i try to run any reports on the Standby the database will eventually stop processing queries, and just hang. The standby will still consume archive logs but will not respond to queries.
Has anyone encountered this type of problem before? Can you point me in the direction of where i might find a reason this is happening, and a way to fix it?
Thank you in advance for any help provided
Just to be clear, the standby will process queries for a little bit, but eventually stops responding to them and hangs.