Oracle
1Z0-063 · Question #62
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. 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 withan 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
How the community answered
(38 responses)- A8% (3)
- B16% (6)
- C74% (28)
- D3% (1)
Community Discussion
No community discussion yet for this question.