Cpu_count too big
Fernando, May 22, 2023 - 11:39 am UTC
Is there a way to tell if the cpu_count is too big for a running database?
And where to check that too in cloud control?
Thanks
May 23, 2023 - 4:54 am UTC
If you check the "average active sessions" metric in your AWR reports, or your V$SYSMETRIC views, then if you are getting sustained peaks above the physical core count for your machine, then perhaps you might want to look at reducing cpu_count.
At the OS level, you can also look at the run queue (the list of processes that *wanted* to use the CPU but could not). If that is non-zero for sustained periods of time, you might be max-ing out your server.