Fw: Resource Manager Plans and SYSTEM_GROUP

From: Brad Peek <"Brad>
Date: Wed, 9 Dec 2020 20:02:14 +0000 (UTC)
Message-ID: <352342645.4001534.1607544134752_at_mail.yahoo.com>

I joined a team that has several databases with resource manager plans that prioritize SYSTEM_GROUP low relative to some other consumer groups.

GROUP        Share-----------  -----WEB           60BATCH         20SYSTEM_GROUP  10OTHER_GROUP   10 Since the servers almost never reach 100% CPU it hasn't been a big issue, but I did want to confirm that the general best practice is to give SYSTEM_GROUP the highest priority among the consumer groups. I suspect it is a case of copying the same plan across multiple DBs, but before I recommend changing this, can anyone think of a use case where having SYSTEM_GROUP with a relatively low priority would make sense?    Notes:-- DB version The mapping for SYSTEM_GROUP is oracle_user in ('SYS', 'SYSTEM') Brad Peek

Received on Wed Dec 09 2020 - 21:02:14 CET

Original text of this message