Youhavecreatedaresourceplan,DAY.Youexecutethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEPARTMENTS’,CPU_P1=0);END;Then,youissuethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEVELOPERS’,CPU_P2=100);END;Whatwillbetheimpactofexecutingtheabovecode?()
Youhavecreatedaresourceplan,DAY.Youexecutethefollowingcode:
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
(PLAN=>’DAY’,
COMMENT=>’DEPARTMENTSPLAN’,
GROUP_OR_SUBPLAN=>’DEPARTMENTS’,
CPU_P1=0);
END;
Then,youissuethefollowingcode:
SQL>BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE
(PLAN=>’DAY’,
COMMENT=>’DEPARTMENTSPLAN’,
GROUP_OR_SUBPLAN=>’DEVELOPERS’,
CPU_P2=100);
END;
Whatwillbetheimpactofexecutingtheabovecode?()
相关考题:
Youhavecreatedaresourceplan,PROD_DB_PLAN,withthefollowingconsumergroupswiththerespectiveplandirectives:ConsumergroupSALESwithCPU_P1as60andDEGREE_OF_PARALLELISMas4.ConsumergroupMARKETwithCPU_P1as20.ConsumergroupDEVwithCPU_P1as20.ConsumergroupOTHERSwithCPU_P1as0andCPU_P2as100.Whichtwostatementsarecorrectinthisscenario?()A.Themaximumdegreeofparallelismforthemembersoftheconsumergroupsis4.B.TheCPUallocationwillalwaysbeequalfortheconsumergroupsMARKETandDEV.C.TheOTHERSconsumergroupwouldget100%oftheCPUifthereareunusedlevel1CPUresources.D.TheSALESandMARKETconsumergroupswouldget100%oftheCPUifthereareunusedlevel2CPUresources.E.ThemaximumdegreeofparallelismforthemembersoftheconsumergroupSALESis4withnorestrictionfortheremaininggroups.
Youhavecreatedaresourceplan,PROD_DB_PLAN,thatusestheRATIOpolicy.Thefollowingconsumergroupsandtheirrespectiveplandirectiveshavebeenassignedtothisresourceplan:ConsumergroupHIGH_CGwithCPU_P1as10.ConsumergroupMEDIUM_CGwithCPU_P1as5.ConsumergroupLOW_CGwithCPU_P1as2.ConsumergroupOTHER_GROUPSwithCPU_P1as1.Whichstatementiscorrectinthisscenario?()A.TheplanPROD_DB_PLANcanhavesubplans.B.ThemembersoftheHIGH_CGconsumergroupwouldget10%oftheCPU.C.TheCPUallocationfortheconsumergroupswouldbebasedontheratiodefinedfortheCPU_P1.D.TheCPUallocationwouldbeequalbetweentheHIGH_CGandMEDIUM_CGconsumergroupsiftherearenosessionsexistingfortheLOW_CGandOTHER_GROUPSconsumergroups.
Youhavecreatedaresourceplan,DB_PLAN,usingDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANandyouwanttoimposearestrictiononutilizationofresourcesbythedatabaseusers.Whichstepmustbeperformedbeforeyoucanstartusingtheresourceplan?()A.assignuserstoconsumergroupsB.settheresourceplanfortheinstanceC.configureasimpleresourceplanandspecifyplandirectivesD.configureacomplexresourceplanandspecifyplandirectives