How to verify if Oracle automatic resource allocation working ?
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.
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.
0