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
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/28530558/viewspace-1406895/
,如需转载,请注明出处,否则将追究法律责任。