OCM 11g Preparation - Administer Resource Manager

Resource Manager is very very useful when you want to limit your system resources. Sometimes you can have a session that is out of control taking all your parallels servers or consuming a lot of CPU and I/O. Or even if you want to limit ("give a quota") the UNDO tablespace consumption by someone.

So, in this topic, be prepared to be requested to implement and configure end-to-end the resource manager. Practice, because just reading and understanding is not enough for this topic. Trust me.

You must be able to:

  • Create Plans
  • Create Consumer Groups
  • Create Plan Directives
  • Clear/Create/Validate/Submit Pending Area
  • Switch between plans and check the current active one
  • Create Consumer Group Mappings
  • Grant Privilege on Consumer Group to User (if you forget this, you will have problems)
  • Query the %_RSRC_% views

One important thing: there are some bugs in Oracle Enterprise Manager 11g Database and Grid Control when you try to set up a resource manager from there, so be very good doing the CLI way.

Path to Documentation:

Administrator's Guide -> 27 Managing Resources with Oracle Database Resource Manager


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.