YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement:
SQL>EXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
(PLAN=>’SALES_PLAN’,
GROUP_OR_SUBPLAN=>’MANAGERS’,
CPU_P1=>100,CPU_P2=>0,
SWITCH_GROUP=>’CLERKS’,
SWITCH_TIME_IN_CALL=>600);
Auser,SCOTT,whoisassignedtotheMANAGERSgroup,startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete?()