多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE

题目
多选题
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）
A

SWITCH_TIME

B

SWITCH_GROUP

C

MAX_SESS_POOL

D

SWITCH_ESTIMATE

相似考题

1.View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）A. The pending area is automatically submitted after the plan creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

2.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$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

3.You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（） A、 CPU_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2

4.View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention

参考答案和解析
正确答案： B,D
解析： 暂无解析
更多“多选题Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）ASWITCH_TIMEBSWITCH_GROUPCMAX_SESS_POOLDSWITCH_ESTIMATE”相关问题

  • 第1题：

    Which of these represent the main components of Database Resource Manager？（）

    • A、 Resource consumer groups
    • B、 Resource plans
    • C、 Resource-plan groups
    • D、 Resource-plan directives
    • E、 All of the above

    正确答案:A,B,D

  • 第2题：

    You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

    • A、 Advisor Central
    • B、 Global Attributes
    • C、 Resource Monitors
    • D、 Memory Parameters
    • E、 Database Usage Statistics
    • F、 All Initialization Parameters
    • G、 Automatic Workload Repository

    正确答案:A,C

  • 第3题：

    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）

    • A、If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
    • B、In a PDB plan, subplans may be used with up to eight consumer groups.
    • C、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
    • D、If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
    • E、If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

    正确答案:A,B,C,D,E

  • 第4题：

    Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）

    • A、SWITCH_TIME
    • B、SWITCH_GROUP
    • C、MAX_SESS_POOL
    • D、SWITCH_ESTIMATE

    正确答案:A,B,D

  • 第5题：

    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

    • A、 The batch operation started by the user， SCOTT， terminates with an error.
    • B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
    • C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
    • D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
    • E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

    正确答案:A,D

  • 第6题：

    Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）

    • A、Maximum Undo per consumer group
    • B、Maximum Idle time
    • C、Parallel server limit
    • D、CPU
    • E、Exadata I/O
    • F、Local file system I/O

    正确答案:C,D,F

  • 第7题：

    多选题
    In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）
    A

    The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

    B

    The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

    C

    The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

    D

    If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

    E

    Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.


    正确答案： B,D
    解析： 暂无解析

  • 第8题：

    单选题
    You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group？（）
    A

     CPU_MTH

    B

     NEW_CPU_MTH

    C

     CPU_P1

    D

     CPU_P2


    正确答案： C
    解析： 暂无解析

  • 第9题：

    多选题
    You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）
    A

    CPU usage

    B

    degree of parallelism

    C

    number of open cursors

    D

    number of sorts performed

    E

    idle time for blocking sessions

    F

    number of disk I/O operations performed

    G

    number of memory I/O operations performed


    正确答案： G,D
    解析： 暂无解析

  • 第10题：

    单选题
    You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）
    A

    The Resource Manager plan does not affect the user.

    B

    There must be a plan directive in any of the plans of the group to control the resources.

    C

    The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.

    D

    The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.

    E

    The members of this group can change their group without the database administrator’s intervention.


    正确答案： E
    解析： 暂无解析

  • 第11题：

    多选题
    Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）
    A

    Maximum Undo per consumer group

    B

    Maximum Idle time

    C

    Parallel server limit

    D

    CPU

    E

    Exadata I/O

    F

    Local file system I/O


    正确答案： B,F
    解析： 暂无解析

  • 第12题：

    多选题
    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
    A

    The batch operation started by the user， SCOTT， terminates with an error.

    B

    The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.

    C

    The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.

    D

    The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.

    E

    The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.


    正确答案： D,A
    解析： 暂无解析

  • 第13题：

    You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_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）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）  

    • A、 The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.
    • B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.
    • C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.
    • D、 The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.

    正确答案:D

  • 第14题：

    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.

    正确答案:A

  • 第15题：

    You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE  （PLAN => ’DSS_PLAN’，   GROUP_OR_SUBPLAN => ’DSS_USERS’，   NEW_CPU_P1 => 80，   NEW_SWITCH_GROUP => ’CANCEL_SQL’，   NEW_SWITCH_ESTIMATE => TRUE，   NEW_SWITCH_TIME => 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）  

    • A、 The session is killed before starting the operation.
    • B、 The session generates an error before starting the operation.
    • C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.
    • D、 The session hangs before starting the operation.

    正确答案:B

  • 第16题：

    Which statement is true while creating subplans using Resource Manager？（）

    • A、 The subplan must belong to the consumer group， SYS_GROUP.
    • B、 The total CPU usage at any given level must be less than 100%.
    • C、 The subplans can be used to restrict the degree of parallelism for a user.
    • D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

    正确答案:D

  • 第17题：

    Which two files in the database can be configured for automatic backups by using the autobackup feature inRecovery Manager （RMAN）（）

    • A、Data files
    • B、Control files
    • C、Parameter file
    • D、Online redo log files
    • E、Server parameter file

    正确答案:B,E

  • 第18题：

    多选题
    In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）
    A

    The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

    B

    The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

    C

    The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

    D

    If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

    E

    If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.


    正确答案： B,E
    解析： 暂无解析

  • 第19题：

    多选题
    Which of these represent the main components of Database Resource Manager？（）
    A

    Resource consumer groups

    B

    Resource plans

    C

    Resource-plan groups

    D

    Resource-plan directives

    E

    All of the above


    正确答案： B,E
    解析： 暂无解析

  • 第20题：

    多选题
    Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature？（）
    A

    SWITCH_TIME

    B

    SWITCH_GROUP

    C

    MAX_SESS_POOL

    D

    SWITCH_ESTIMATE


    正确答案： A,B
    解析： 暂无解析

  • 第21题：

    多选题
    Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically， and to perform a switch to a low priority consumer group before they are initiated？（）
    A

    SWITCH_TIME

    B

    SWITCH_GROUP

    C

    MAX_SESS_POOL

    D

    SWITCH_ESTIMATE


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

    单选题
    Which statement is true while creating subplans using Resource Manager？（）
    A

     The subplan must belong to the consumer group， SYS_GROUP.

    B

     The total CPU usage at any given level must be less than 100%.

    C

     The subplans can be used to restrict the degree of parallelism for a user.

    D

     You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）
    A

    LOG_BUFFER

    B

    DB_CACHE_SIZE

    C

    JAVA_POOL_SIZE

    D

    LARGE_POOL_SIZE

    E

    SHARED_POOL_SIZE

    F

    STREAMS_POOL_SIZE


    正确答案： E,A
    解析： 暂无解析

  • 第24题：

    多选题
    Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?（）
    A

    If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.

    B

    In a PDB plan, subplans may be used with up to eight consumer groups.

    C

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.

    D

    If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

    E

    If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.


    正确答案： C,E
    解析： 暂无解析

相关内容