Setting up Instance Caging
A great way to limit CPU on a shared database server is by using instance caging, below are the steps to implement instance caging. 1. Check to see if instance caging is enabled SQL> select name from v$rsrc_plan where is_top_plan = ‘TRUE’ and cpu_managed=’ON’; no rows selected Its not enabled 2. Set the CPU count Set the […]