I/O Resource Plan

Question

My 10g DB is acting as a data warehouse store and is very busy. I know that it's possible to set limits on CPU consumption ratios between users so that certain users will be prioritized. However, in my case the IO is the "expensive" resource, not CPU. Is it possible to manage and set priorities on IO?

Thanks

p.s. I saw that one can use a profile to set IO limits, but I think this isn't suitable for me because the limits actually cause the query to be canceled if the limit is reach, and this is too far.

Answer 1

Basic PROFILE management doesn't allow you to set fine-tuned priorities. There is another tool in the database however that may be suitable for what you want to achieve: the Database Resource Manager.

I have not used this tool yet, but this blog post "Oracle Database Resource Manager and Oracle Application Express"(by the guy behind apex.oracle.com) looks like a good example. Perhaps you can use something similar to implement your priority strategy.