Re: OLTP should have priority over jobs

From: Ryan January <rjanuary_at_gmail.com>
Date: Mon, 29 Feb 2016 14:11:49 -0600
Message-Id: <C9272E94-BEA1-4EAC-9F3F-3ACBBD97E3BD_at_gmail.com>

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_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 29 2016 - 21:11:49 CET