database - Check if Oracle Resource Management is enabled -


what's sql statement have run sys find out whether db uses resource management or not?

resource management enabled default. must know if user using resource manager or not.

find out list of users/roles consumer of resources manager groups executing: sys: select * dba_rsrc_consumer_group_privs ;

for logged in user, find out resource groups assigned : select * user_rsrc_consumer_group_privs ;

  • abhi

Comments

Popular posts from this blog

networking - Vagrant-provisioned VirtualBox VM is not reachable from Ubuntu host -

c# - ASP.NET Core - There is already an object named 'AspNetRoles' in the database -

android - IllegalStateException: Cannot call this method while RecyclerView is computing a layout or scrolling -