单项选择题
A.DBA_SCHEDULER_RUNNING_JOBS B.DBA_SCHEDULER_JOB_RUN_DETAILS C.DBA_SCHEDULER_JOBS D.DBA_SCHEDULER_JOB_LOG
YourecentlycreatedacomplexresourceplannamedDB_PLANthath...
单项选择题You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）
A. 45.5 B. 65 C. 70 D. 100
You execute the following block of code： SQL>BEGIN ...
You execute the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN => ’DEPARTMENTS’， CONSUMER_GROUP1 => ’PAYROLLL’， GROUP1_CPU => 50， CONSUMER_GROUP2 => ’SALES’， GROUP2_CPU => 25， CONSUMER_GROUP3 => ’MARKETING’， GROUP3_CPU => 25）； END； SQL>/ What is a prerequisite for using the simple resource plan created by executing the above code？（）
A. You must assign users to consumer groups. B. You must grant the switch privilege to the users. C. You must create a resource plan directive. D. You must specify the complex resource plan.
YourecentlyactivatedaresourceplannamedOLTP_PLANinyourda...
单项选择题You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）
A. V$SYSSTAT B. V$SESSSTAT C. V$RSRC_PLAN D. V$RSRC_CONSUMER_GROUP
