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
Post a Comment