本博客主要探讨了Oracle数据库19c中关于PDB资源限制的问题。在给出的输出中，选项A和B被确认为正确。A选项指出未在计划中指定的PDB将无法执行并行语句，因为其parallel_server_limit默认设为0。B选项正确是因为PDB3的parallel_server_limit未指定，因此默认为100%，可以在没有资源争用的情况下使用所有可用的并行执行进程。其他选项C、D、E和F因各种原因被判定为不正确，如C选项中PDB可以使用超过保证的资源量，D选项中PDB的资源使用并不受16.5%的限制，E选项未能确认只有三个PDB，而F选项中parallel_server_limit是上限而非保证分配。
Examine this output:
Which two are true? (Choose two.)
- A. Any PDB not specified in the plan will be unable to execute statements in parallel.
- B. PDB3 can use all available parallel execution processes at times.
- C. PDB1 is always limited to 40% of the available system resources regardless of demand.
- D. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
- F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
AB
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 speci
最低0.47元/天 解锁文章
392
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
