随笔分类 -  SGA&PGA

1
052-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 syst 阅读全文
posted @ 2017-12-07 14:18 巴啦啦大魔王 阅读(181) 评论(0) 推荐(0)
053-494
摘要：Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or 阅读全文
posted @ 2017-11-17 10:14 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)
053-205
摘要：You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You r 阅读全文
posted @ 2017-11-16 16:05 巴啦啦大魔王 阅读(106) 评论(0) 推荐(0)
053-151
摘要：Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)A. MEMORY_TARGET can be increased up to the value 阅读全文
posted @ 2017-11-16 15:13 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-212
摘要：Note the following parameters settings in your database:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the f 阅读全文
posted @ 2017-11-16 14:05 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-656
摘要：The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN sessi 阅读全文
posted @ 2017-11-16 13:27 巴啦啦大魔王 阅读(141) 评论(0) 推荐(0)
053-640
摘要：Examine the parameter setting in your database: Which statement is correct about the database?A. Automatic memory management is disabled because PGA_A 阅读全文
posted @ 2017-11-16 11:17 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-639
摘要：You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?A. Set MEMORY_TARGET to zeroB. Set the 阅读全文
posted @ 2017-11-16 11:12 巴啦啦大魔王 阅读(109) 评论(0) 推荐(0)
053-131
摘要：Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for theMEMORY_TARGET parameter of your database instance. 阅读全文
posted @ 2017-11-15 16:07 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-421
摘要：When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows 阅读全文
posted @ 2017-11-14 14:50 巴啦啦大魔王 阅读(121) 评论(0) 推荐(0)
053-420
摘要：Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)A. 阅读全文
posted @ 2017-11-14 14:42 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
053-419
摘要：In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_ 阅读全文
posted @ 2017-11-14 14:38 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
053-418
摘要：Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropr 阅读全文
posted @ 2017-11-14 14:17 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
053-417
摘要：When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?A. DB_CACHE_SIZEB. SHARED_POOL 阅读全文
posted @ 2017-11-14 14:12 巴啦啦大魔王 阅读(147) 评论(0) 推荐(0)
053-416
摘要：To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization 阅读全文
posted @ 2017-11-14 14:05 巴啦啦大魔王 阅读(146) 评论(0) 推荐(0)
053-415
摘要：For Oracle 11g, Oracle strongly recommends that you configure your database to use which of thefollowing memory-management features?A. Automatic PGA M 阅读全文
posted @ 2017-11-14 14:00 巴啦啦大魔王 阅读(115) 评论(0) 推荐(0)
053-414
摘要：By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to anonzero value, you will enable which of the following memory-man 阅读全文
posted @ 2017-11-14 13:58 巴啦啦大魔王 阅读(120) 评论(0) 推荐(0)
053-413
摘要：Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?A. Automatic PGA Memory Ma 阅读全文
posted @ 2017-11-14 13:47 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
053-525
摘要：What components are present in an ASM instance? (Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter f 阅读全文
posted @ 2017-11-07 10:05 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
053-518
摘要：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 阅读全文
posted @ 2017-11-06 23:32 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)

1