Database DataWarehousing (MOSC)

MOSC Banner

How to verify if Oracle automatic resource allocation working ?

edited Aug 25, 2011 12:59AM in Database DataWarehousing (MOSC) 4 commentsAnswered ✓
Hi,

In our 10gR2 DWH environment , we have created following resource consumer group plans :
DAILY_BUSINESS_PLAN( active from 8 AM to 4 PM )
DAILY_ETL_PLAN ( active from 4 PM to 8 AM)
WEEKEND_ETL_PLAN ( active on Saturday and Sunday from 8 AM to 4 PM)

we have also created many resource groups(RG) and put all the users under different consumer groups.

we want automatic switching of the resources(used by sessions falling in the category ) used by RGs when a new consumer group plan starts. for example @4 pm all the sessions used by one RG downgraded/upgraded to suits DAILY_ETL_PLAN.

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