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
