I have a question about Oracle Resource Manager in 10.2.0.4. We have a server with 4 databases on it. Each one hosts a different application.

Is it possible to create Resource Plans in each one to only allow each one access to 25% of the CPU? I know I can control the amount of CPU allocated to different groups within one database but I was wondering if I created a main group in each one to have 25% and then subplans under that.

Has anyon done this before?