Database Administration (MOSC)

MOSC Banner

Instance Caging

edited Jan 29, 2021 4:33AM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi,

I am currently doing a project => create a logical DR on PROD server(SunOS 5.11 sparc) with 8 databases version 19.3.

I have reviewed this host, and of course need to add more storage and memory, which should be OK to me. However, I have concerns about CPU on that server.

The host has 4 cores and 32 virtual processors, and the cpu parameters on all 8 databases are as below:

SQL> show parameter cpu%

NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

cpu_count              integer   32

cpu_min_count            string   32

parallel_threads_per_cpu       integer   1

resource_manager_cpu_allocation   integer   32


SQL> show parameter resource_manager_plan

NAME                 TYPE    VALUE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center