Posts

Showing posts from January, 2012

Instance Caging - Managing Multiple Database Instances on a Single Server

Image
Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, to limit the number of CPUs that can be used by a given instance simultaneously. This feature allows Oracle DBAs to easily manage Oracle Instance CPU consumption. There are two typical approaches to instance caging for a server: Over-provisioning: In this approach, the sum of the CPU limits for each instance exceeds the actual number of CPUs on the system. Partitioning:In this approach, the sum of allocate CPUs for each instance is equal to the number of CPUs on the server

ASM Processes parameter setting is dependent on the number of databases that connect to ASM

Setting init.oraparameter ASM instance Use default values sesettings. Only processes parameter may need modification. Processes parameter setting is dependent on the number of databases that connect to ASM processes= 25 + 15n, where n = # databases connected to ASM . If max processes is reache on ASM, this indicaties offten on hanging processes of cluster agents or RMAN processes