1 Reply Latest reply on Dec 12, 2013 4:25 PM by mseberg

    Cpu spikes 100% when we query Static views to Physical active data guard


      Hi All,


      I would like to share one Problem with you, where Oracle support has just provided standard answer to upgrade to Newer version.


      We have Primary 3 Node Rac / standby single instance (non-rac)  Physical active data guard in Open read only Mode.


      On primary we have with some few latest Patch and Standby is on without any patchset.


      The problem is , when we query dynamic tables on standby database ,it does not spikes cpu.But as soon as we Query static or appliation Tables on Standby .It starts spike cpu. even query to static table has sysdba.


      the query does not respond and Just hangs. I cant even run AWR / Oradebug.


      Can somebody Please help on it .