Dear all,
i am using oracle 12c R1 on windows server 2012.
i have the following situation.
i follow a blog https://joelkallman.blogspot.com/2009/08/oracle-database-resource-manager-and.html
i create a resource plan but i am not happy with it. i want to use the default resource plan. how to do it?
after following the blog, i execute the following
alter system set resource_manager_plan = 'DEFAULT_PLAN' sid = '*';
here are some details
SELECT NAME, IS_TOP_PLAN FROM V$RSRC_PLAN;
DEFAULT_PLAN TRUE
SELECT * FROM DBA_RSRC_CONSUMER_GROUP_PRIVS;
PUBLIC DEFAULT_CONSUMER_GROUP YES YES
APEX_PUBLIC_USER APEX_HIGH NO NO
APEX_050000 APEX_MEDIUM NO NO
APEX_050000 APEX_LOW NO NO
APEX_050000 APEX_HIGH NO NO
SYSTEM SYS_GROUP NO YES
APEX_PUBLIC_USER APEX_LOW NO NO
APEX_PUBLIC_USER APEX_MEDIUM NO NO
PUBLIC LOW_GROUP NO NO
now i want to set the default oracle plan insted of APEX_HIGH, APEX_LOW and APEX_MEDIUM.
one other question.
if we freshly install oracle 12c R1, any resource plan is active by default or not?
if not, how can i disable all the resource plan.
if yes, then how to select that default plan for all the users in database.
Thank you.