YouareusingtheDatabaseResourceManagertoman

题目

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?()