OCP-1Z0-053-V13.02-702题

发布时间:2014-10-22 19:59:21编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"OCP-1Z0-053-V13.02-702题",主要涉及到OCP-1Z0-053-V13.02-702题方面的内容,对于OCP-1Z0-053-V13.02-702题感兴趣的同学可以参考一下。

702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:   Why did the instance fail to start? A.Because the PGA_AGGREGATE_TARGET parameter is not set B.Because the STATISTICS_LEVEL parameter is set to BASIC C.Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal D.Because both the SGA_TARGET and MEMORY_TARGET parameters are set. Answer: D  答案解析: 参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN11207 以下实验说明SGA_TARGET and MEMORY_TARGET可以同时set,而从官方文档看出STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL 故这道题的答案D是错误的,正确应该为B Setting SGA Target Size You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a nonzero value. This parameter sets the total size of the SGA. It replaces the parameters that control the memory allocated for a specific set of individual components, which are now automatically and dynamically resized (tuned) as needed. Note: The STATISTICS_LEVEL initialization parameter must be set to TYPICAL (the default) or ALL for automatic shared memory management to function.   [oracle@rtest ~]$ oerr ora 824 00824, 00000, "cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings" // *Cause: Could not set SGA_TARGET or MEMORY_TARGET due to current parameter settings. // *Action: Check the other error messages for additional information. sys@TEST1107> alter system set memory_target=1210M scope=spfile; System altered. sys@TEST1107> alter system set sga_target=500M scope=spfile; System altered. sys@TEST1107> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. sys@TEST1107> startup ORACLE instance started. Total System Global Area 1269366784 bytes Fixed Size                  2227984 bytes Variable Size             805306608 bytes Database Buffers          452984832 bytes Redo Buffers                8847360 bytes Database mounted. Database opened. sys@TEST1107> show parameter target  NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target                   integer     0 db_flashback_retention_target        integer     1440 fast_start_io_target                 integer     0 fast_start_mttr_target               integer     0 memory_max_target                    big integer 1216M memory_target                        big integer 1216M parallel_servers_target              integer     128 pga_aggregate_target                 big integer 0 sga_target                           big integer 512M sys@TEST1107> 


上一篇:hdu 1059 Dividing(优化的多重背包 可达可不达)
下一篇:第一周项目-3(扩展)-两人生日差的天数

相关文章

相关评论

本站评论功能暂时取消,后续此功能例行通知。

一、不得利用本站危害国家安全、泄露国家秘密,不得侵犯国家社会集体的和公民的合法权益,不得利用本站制作、复制和传播不法有害信息!

二、互相尊重,对自己的言论和行为负责。

好贷网好贷款