Database Tuning (MOSC)

MOSC Banner

Significance of max_utilization in dbrm

edited Mar 16, 2015 10:02AM in Database Tuning (MOSC) 3 commentsAnswered


Hello expert,

                   In one of the oracle documentation I found below.

Within a particular level, CPU allocations are not fixed. If there is not sufficient load in a particular consumer group or subplan, residual CPU can be allocated to remaining consumer groups or subplans.

Ref:-http://docs.oracle.com/database/121/ADMIN/dbrm.htm

Suppose I have one level and I have 3 consumer groups like below where max utilization limit is not set

cg name cpu allocation%

oltp                80

others            10

sys_group      10

Does that mean if my sys_group,other_groups are not actively used then oltp group can eat up 100% of cpu?In that case any backup job will hung.Please clarify this

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