首页 > 数据库技术 > 详细

【每日一练】Oracle OCP认证考试题库解析052-2

时间:2015-01-23 02:20:54      阅读:343      评论:0      收藏:0      [点我收藏+]

QUESTION 2

Identify the memory component from which memory may be allocated for:Session memory for the shared server, Buffers for I/O slaves Oracle Database Recovery Manager (RMAN) backup and restore operations


A. Large Pool

B. Redo Log Buffer

C. Database Buffer Cache

D. Program Global Area (PGA)


Correct Answer: A


Explanation/Reference:


Large Pool


The large pool is an optional memory area intended for memory allocations that are larger than is appropriate for the shared pool. The large pool can provide large memory allocations for the following:


UGA for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)

Message buffers used in the parallel execution of statements

Buffers for Recovery Manager (RMAN) I/O slaves


By allocating session memory from the large pool for shared SQL, the database avoids performance overhead caused by shrinking the shared SQL cache. By allocating memory in large buffers for RMAN operations, I/O server processes, and parallel buffers, the large pool can satisfy large memory requests better than the shared pool.




11g OCP题库,考试必备

恩墨学院开通【免费课程复习资料申请】,帮助同学们在课程结束后,有效果的进行温习。


申请步骤:

1、将[链接]复制-黏贴到网页中

申请链接:https://jinshuju.net/f/L82PlR

2、打开链接后,填写申请并提交即可

提交后,会在3个工作日内将【复习资料】发送至您的邮箱。

更多精彩认证系列课程,期待您的关注!
http://ke.qq.com/cgi-bin/courseDetail?course_id=36323#rd

【每日一练】Oracle OCP认证考试题库解析052-2

原文:http://blog.itpub.net/28530558/viewspace-1406895/

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!