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.