Which three statements are true about Quality of Service Management (QoS)?
A.
A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.
B.
It can manage database services only if they are defined as UNIFORM services.
C.
It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
D.
It supports multiple databases assigned to the same server pool.
E.
Databases managed by QoS can be administrator managed or policy managed.
Explanation:
B: Database services should be created as UNIFORM services, meaning the service is offered by every available instance running in the specified server pool. If
your application requires a SINGLETON service, then, to use Oracle Database QoS Management in management mode, the service must run in a server pool that
has a maximum size of one. If you use a SINGLETON service in a server pool that has a maximum size greater than one, then Oracle Database QoS Management
reports a configuration violation.
C: Initial QoS configuration includes:
Installing and Configuring Oracle Grid Infrastructure for a Cluster
Creating and Configuring Server Pools
Creating and Configuring an Oracle RAC Database
Enabling Oracle Database QoS Management
Incorrect Answers:
E: It must be policy managed. When you use DBCA to create an Oracle RAC database, you select policy-managed for the database, and choose the server pools
which the database instances should run in.
https://docs.oracle.com/cd/E11882_01/server.112/e24611/install_config.htm#APQOS157
https://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341
Hi
Think B,C,D are correct
http://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341
Regards
BCD is correct.
i think c,d,e
For full use of Oracle Database QoS Management features, the databases must be configured as policy-managed databases that run in server pools. E is wrong answer
Thanks Tmihalicek!
E is wrong
For full use of Oracle Database QoS Management features, the databases must be configured as policy-managed databases that run in server pools.
http://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341
A is correct.
You can select server pools to be managed by Oracle Database QoS Management even if they do not contain any database instances
http://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS340
B is wrong.
If you selected measure-only for the management mode for this database, then you can use SINGLETON services any configuration.
http://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341
C is right
The initial configuration tasks for the Oracle Database QoS Management administrator are covered in more detail in the following sections:
Installing and Configuring Oracle Grid Infrastructure for a Cluster
https://docs.oracle.com/cd/E11882_01/server.112/e24611/install_config.htm#APQOS153
D is right
Oracle Database QoS Management supports multiple databases sharing a server pool. If you have multiple databases using the same server pool, then every database that uses the server pool must have Oracle Database QoS Management enabled. Oracle Database QoS Management also supports Oracle RAC One Node databases (sometimes referred to as singleton databases), but these databases must use server pools that have a maximum size of one.
http://docs.oracle.com/database/121/APQOS/wlm_strats.htm#APQOS341
E is wrong
For administrator-managed databases in the Generic server pool, Oracle Database QoS Management measures and monitors the workload and response times.
=>> Databases in the Generic pool cannot be managed by Oracle Database QoS Management and are not visible in the user interface
Generic means administrator-managed
Agree with Tri – ACD
B – In order for SINGLETON services to be managed by QoS the service must run in a server pool that has a maximum size of one.
E – Administrator managed databases can only be monitored by QoS, not managed.
Agree, ACD