1Z0-117 Web TestEngine demo

Your database supports a workload consisting of three categories of SQL statements:

Statements that should execute in less than one minute Statement that may execute for up to 15 minutes Statements that may be executed for more than 15 minutes

You set PARALLEL_DEGREE_POLICY to Auto.

You plan to prioritize queued statements by using the Database Resource manager.

Which two are true about parallelism prioritization by a consumer group?

Select all that apply.

• A

  PARALLEL_TARGET_PERCENTAGE is used to prioritize a consumer group's use of the overall PARALLEL_SERVER_TARGET.

• B

  Queuing is done for a consumer group exceeding its percentage, even if the number of busy PX servers in the instance has not reached PARALLEL_SERVERS_TARGET.

• C

  PARALLEL_TARGET_PERCENTAGE us used to prioritize a consumer group's use of the overall SPAN CLASS = `OracleCode'>
  PARALLEL_MAX_SERVERS.

• D

  Having separate queues for consumer groups requires the use of management attributes (MGMT_P1, MGMT_P2 etc. . . )

• E

  Separate queue timeout using PARALLEL_QUEUE_TIMEOUT require the use of management attributes (MGMT_P1, MGMT_P2 etc . . . groups)