0 Replies Latest reply on Dec 7, 2019 1:51 PM by user8977605

    heavy waits events for library cache: mutex X on database 11.1.0.7

    user8977605

      heavy waits events for library cache: mutex X on database 11.1.0.7

       

      our Database is 11.1.0.7

      EBS version R12.1.3

       

      EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
      library cache: mutex X138,778,29610013,33802,043.923.74

       

      Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
      DB CPU 331,097 92.91

       

      EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
      DB CPU 331,097 92.91
      library cache: mutex X138,778,29613,33803.74Concurrency
      db file sequential read7,223,7187,28212.04User I/O
      cursor: pin S wait on X233,9352,391100.67Concurrency
      enq: TX - row lock contention13687364150.24Application

       

      we are having cpu utilization issue. how can we fix the issue