I'm not sure if there's any extras in 12c that may be a better fit, however
I've used Resource Manager on 11.2 with very good results. If you go down that
route insure that you verify/test your config. In multi-tier deployments it
may not act exactly as you intend.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN027 ;
<http://docs.oracle.com/cd/E11882_01/server.112/e25494/dbrm.htm#ADMIN027>
On Feb 29, 2016, at 2:07 PM, Woody McKay <woody.mckay@xxxxxxxxx> wrote:
Hi,
Is there a best practice for having oltp application connections to have
priority over running jobs?
Mgmt wants to ensure that the user application isn't slowed down by jobs
running in the background.
I have thought about using different resource plans (rather than
default_maintenance_plan for all, but I'm not sure how to implement that. If
the solution is using different plans, how do you know what jobs and
scheduled jobs run as who? By the job owner?
Win 2012R2, 32cpu, 512g ram, 26 SIDs, oracle 12.1.0.2.7
--
Sincerely - Woody