A and B for me.
A) PDB not specified in the Plan will be assigne to the DEFAULT_PDB_DIRECTIVE. This directive set PARALLEL_SERVER_LIMIT to zero. (No parallel server).
B) PARALLEL_SERVER_LIMIT is not set for PDB3 Resource plan directive. The default value of 100% is used in this case.
Agree with you
A. Correct as then a PDB will get assigned the default directive with parallel_server_limit set to 0
B. Correct as parallel_server_limit is not specified for PDB3 and it defaults to 100
Quote:
https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN14008
"If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%."
C. Incorrect. A PDB can use more resources:
Quote from
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13777
"However, any PDB can use more than the guaranteed amount of a resource if there is no resource contention."
D. Incorrect. Shares is a minimum guaranteed value. But a PDB can use more as explained above in C.
E. Incorrect. Nothing confirms that there are only 3 PDBs attached. There may be others using the default pdb directive. Then the share for PDB2 is not 20%
F. Incorrect. parallel_server_limit is an upper limit.
I was wondering that since the default directive with parallel_server_limit set to 0, how is it that other PDB will get share (for your explaination of F) since they wont be allowed to run parallel?
The default value is 100 as described here: https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-3E84009E-5CD6-46B8-84D3-BE775D58D9AA
B y F i agree
SQL> COLUMN plan FORMAT A30
COLUMN pluggable_database FORMAT A25
SET LINESIZE 100
SQL> SQL> SQL> SQL> SELECT plan,
pluggable_database,
shares,
utilization_limit AS util,
parallel_server_limit AS parallel
FROM dba_cdb_rsrc_plan_directives
WHERE plan = 'TEST_CDB_PLAN'
ORDER BY pluggable_database; 2 3 4 5 6 7 8
PLAN PLUGGABLE_DATABASE SHARES UTIL PARALLEL
------------------------------ ------------------------- ---------- ---------- ----------
TEST_CDB_PLAN ORA$AUTOTASK 90
TEST_CDB_PLAN ORA$DEFAULT_PDB_DIRECTIVE 1
TEST_CDB_PLAN PDBDEV 2
TEST_CDB_PLAN PDBDEV2 2 25
TEST_CDB_PLAN PDBDEV3 1
B is correct no doubt.
For me the second correct is E. One share of five is 20%. Also we can conclude that these are all the PDBs, since there is not another reciurce_manager_plan.
When you do not explicitly define directives for a PDB, the PDB uses the default directive for PDBs. In this case the default directive sets the value 0 for parallel_server_limit. In this case I understand that PDB3 cannot use resources in parallel. So option A seems correct to me.
A- Incorrect : If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%
REF: https://docs.oracle.com/database/121/ADMIN/dbrm.htm#ADMIN14007
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/using-oracle-resource-manager-for-pdbs-with-sql-plus.html#GUID-3E84009E-5CD6-46B8-84D3-BE775D58D9AA
When you do not explicitly define directives for a PDB, the PDB uses the default directive for PDBs.
B - Correct : If PARALLEL_SERVER_LIMIT is not specified, then it defaults to 100%
C - Incorrect: PDB1 is NOT always limited to 40% of the available system resources regardless of demand.
D - Incorrect : When you do not explicitly define directives for a PDB, the PDB uses the default directive for PDBs., default is 100%
E: Incorrect : available system resources = utilization_limit and parallel_server_limit
F: Correct : parallel_server_limit =25
F: is incorrect, "parallel_server_limit" does not guarantee anything,
it limits the resource to 25% !
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm#ADMIN13786
Question:
Which three are true about performing an Oracle Database install on Linux?
(Choose three.)
Response:
A. The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
B. It allows you to select the languages supported by the Oracle database server.
C. The runfixup.sh script can install missing RPMs.
D. The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
E. It can be done after installing Grid Infrastructure for a Standalone Server.
F. It can be done before installing Grid Infrastructure for a Standalone Server.
G. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
D, E and F are correct. Any comments???
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SMagny
Highly Voted 4 years, 1 month agoAlejandrrro
3 years, 11 months agoasduta
2 years agoKuraudio
12 months agocujar2003
Most Recent 2 months, 1 week agocujar2003
2 months, 1 week agoSoiram
3 months, 2 weeks agoSoiram
3 months, 2 weeks agoauwia
6 months, 3 weeks agoGuhborges
1 year, 6 months ago_gio_
1 year, 8 months agoFranta1
2 years, 2 months agoflaviogcmelo
2 years, 8 months agoflaviogcmelo
2 years, 8 months agomtnetmaker
2 years, 8 months agoasduta
2 years, 7 months agovkra
1 year, 11 months agocasfdsaf
2 years, 9 months agoyarsalan
2 years, 11 months agoflaviogcmelo
3 years, 2 months agochefdba
3 years, 2 months agoNeil107
3 years, 5 months agoxsxxxxx
3 years, 6 months agoasduta
2 years agoGlykon
3 years, 11 months ago