Oracle
1Z0-067 · Question #155
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time…
The correct answer is C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group E. A user belonging to the DSS__QUERIES resource consumer group can create a new session but. See the full explanation below for the reasoning.
Question
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed. SQL> SELECT name, active_sessions, queue_length, consumed_cpu_time, cpu_waits, cpu_wait_time FROM v$rsrc_consumer_group; Which two statements are true?
Exhibit
Options
- AAn attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- BAn attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
- CThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
- DThe CPU_WAIT_TIME column indicates the total time that sessions in the consumer group
- EA user belonging to the DSS__QUERIES resource consumer group can create a new session but
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C77% (36)
- D11% (5)
Community Discussion
No community discussion yet for this question.