【每日一練】Oracle OCP認證考試題庫解析052-2

恩墨學院發表於2015-01-19

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、將[連結]複製-黏貼到網頁中

申請連結:

2、開啟連結後,填寫申請並提交即可

提交後,會在3個工作日內將【複習資料】傳送至您的郵箱。

更多精彩認證系列課程,期待您的關注!
http://ke.qq.com/cgi-bin/courseDetail?course_id=36323#rd

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28530558/viewspace-1406895/,如需轉載,請註明出處,否則將追究法律責任。

相關文章