ocp-118

QUESTION NO: 118

The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his

unique knowledge of the application. Which of these are good starting points to use when configuring the

maximum values for SGA and PGA, based on the amount of memory available on the system?

A. 20% SGA, 80% PGA

B. 25% SGA, 75% PGA

C. 50% SGA, 50% PGA

D. 75% SGA, 25% PGA

E. 80% SGA, 20% PGA

Answer: E

DBA 已經選

擇在 OLTP 資料庫中分開管理 SGA 和 PGA 記憶體，因為他獨特的應用知識。 基于系統上可用的記憶體量，當配

置 SGA 和 PGA 的最大值時， 這些良好的出發點中哪個可以利用？

E. 80% SGA, 20% PGA