Background processes in DBRM
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(*)