Number of Active Sessions and CPU_COUNT

Hello everyone!

We are under:

  X5-2 Eighth Rack HC 4TB

  Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

  Linux  4.1.12-61.28.1.el6uek.x86_64 #2 SMP Tue Dec 20 16:51:49 PST 2016 x86_64 x86_64 x86_64 GNU/Linux

We have instance caging running up and one of the databases has cpu_count=20. We are using DEFAULT_PLAN as we don't actually need

any specific one so almost every user is under OTHER_GROUPS.

If a run the following query:

SELECT avg(round(m.cpu_consumed_time / 60000, 2)) avg_running_sessions

FROM v$rsrcmgrmetric_history m,

     dba_rsrc_plan_directives d,

     v$rsrc_plan p

WHERE m.consumer_group_name = d.group_or_subplan