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 👍!