1 Reply Latest reply: Dec 12, 2013 10:25 AM by mseberg RSS

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

    21145f87-ccb9-4427-b065-db89d329eb0f

      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 11.2.0.2 with some few latest Patch and Standby is on 11.2.0.2 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 .

       

      Thanks