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. 
Answer: D   

SGA_TARGET 设置为非0值后，会进入assm模式，这是10G的考题了。在11G是amm用的是memory_target

SQL> select * from v$version where rownum <=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production1 row selectedSQL> show parameter targetNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------archive_lag_target                   integer     0db_flashback_retention_target        integer     1440fast_start_io_target                 integer     0fast_start_mttr_target               integer     0memory_max_target                    big integer 1232Mmemory_target                        big integer 1232Mparallel_servers_target              integer     32pga_aggregate_target                 big integer 0sga_target                           big integer 0