0 Replies Latest reply on Dec 20, 2016 1:11 PM by Shaik

    q000 process causing cpu load

    Shaik

      Hi All

       

      OS: Hp Unix Itanium

      Db: 11.2.0.4 two node rac

      Apps: R12.1.3

       

      In RAC Node2 i can see q000 process taking 90% cpu in top command

       

       

      CPU TTY  PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CPU COMMAND

      4   ? 23085 oradb    178 20 15172M 11524K run      2:05 97.25 97.08 ora_q000_PROD2

       

       

      I checked in gv$session  its showing as Streams

       

       

      Please suggest.

       

       

      Regards

      Shaik