Database Administration (MOSC)

MOSC Banner

Can I assign schema to consumer group in resource manager?

edited Oct 3, 2019 11:53PM in Database Administration (MOSC) 9 commentsAnswered ✓

hi

1)

Why can't I assign a schema to a consumer group.

Why is it only sessions?

2)

What if I want all session from a schema to be part of the 'SYS_GROUP' consumer group?

3)

Assigning session by sessions each time a user logs in is not practical so what is the logic behind this?

4)

I want to make the 'myadmin' user part of the consumer group SYS_GROUP which command do I use?

I'm logged in as sysdba

Thanks

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