Oracle 11G OCP 1Z0-052 51

（51）In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache.

In the night, the system supports batch jobs that require a higher value to be set for the large pool.

You must simultaneously configure the memory components to accommodate the peak requirement.

What would you do to automate this configuration for the memory components with change in mode of working?

A.Set the SGA_TARGET initialization parameter to zero.

B.Set the PRE_PAGE_SGA initialization parameter to TRUE.

C.Set the MEMORY_MAX_TARGET initialization parameter to zero.

D.Set the SGA_TARGET initialization parameter to a nonzero value.

答案：（D）

解析：

這裡需要Oracle根據需要自動地根據需要來調整記憶體元件的大小，即SGA需要自動進行管理。

B（X）. PRE_PAGE_SGA決定Oracle在例項啟動時是否將整個SGA讀入記憶體。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1180132/，如需轉載，請註明出處，否則將追究法律責任。