Database Administration (MOSC)

MOSC Banner

resource manager

edited Jun 27, 2011 8:56PM in Database Administration (MOSC) 8 commentsAnswered
Hi All,
I want to use resource manger in my database.

The requirement is as below:

Database version : 10.2.0.4
No. of CPU's : 30

The batch user runs the batch during the daytime window, and we want to restrict only the batch user to user say 10 CPU's during the day time.

In the night time, when the batch runs the batch user should be able to use as many CPU's as he wants.

Is it possible to achieve this using resource manager?

TIA

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center