2 Replies Latest reply on Jan 28, 2013 2:13 AM by Hemant K Chitale

    CPU usage is ok on the server - but database is slow with high CPU wait

      I have a RAC 48 cores on solaris.
      I check dbconsole when application performance is very slow and everyone complains, and I see that the main wait is cpu - also on the awr report.
      however when I check server cpu I see about 80% idle! so how can I make oracle use more cpu power instead of waiting for it?
      I don't think that parallel is an option here because I can't change the application code.


      Edited by: 912294 on Jan 26, 2013 10:02 AM