Database Administration (MOSC)

MOSC Banner

Background processes in DBRM

edited Jan 9, 2015 10:04AM in Database Administration (MOSC) 1 commentAnswered

Hi

i'm trying to implement a complex plan in our production database . I can't find where are defined the default consumer group for background processes .

I've mapped every user in the database into a defined consumer group , but in the night i see a lot of call into the OTHER_GROUP .

The maintenance window are mapped into a group called DBSNMP_RG . From my query the result is that the workload during the night depend from

background process

SQL> select consumer_group_id, count(*)

  2  from gv$active_session_history

  3  where session_type='BACKGROUND'

  4  group by consumer_group_id;

CONSUMER_GROUP_ID   COUNT(*)

Tagged:

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