QUESTION 11 Which three are true about the large pool for an Oracle database instance that supports

QUESTION 11
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
A. Allocates memory for RMAN backup and restore operations
B. Allocates memory for shared and private SQL areas
C. Contains a cursor area for storing runtime information about cursors
D. Contains stack space
E. Contains a hash area performing hash joins of tables
Correct Answer: ABC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
The large pool can provide large memory allocations for the following:
/ (B)UGA (User Global Area) 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

/ (A) Buffers for Recovery Manager (RMAN) I/O slaves
Note:
* large pool
Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
* Oracle XA
An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.
* UGA
User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.
* Configuring the Large Pool
Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:
* Shared server
In a shared server architecture, the session memory for each client process is included in the shared pool.
* Parallel query
Parallel query uses shared pool memory to cache parallel execution message buffers.
* Recovery Manager
Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.

 

 

问题11

对于支持共享服务器连接的Oracle数据库实例的大型池，哪三个是正确的？

A、 为RMAN备份和还原操作分配内存

B、 为共享和私有SQL区域分配内存

C、 包含用于存储有关游标的运行时信息的游标区域

D、 包含堆栈空间

E、 包含执行表的哈希联接的哈希区域

正确答案：ABC

章节：（无）

解释

说明/参考：

说明：

大型池可以为以下对象提供大型内存分配：

/（B）用于共享服务器和Oracle XA接口的UGA（用户全局区域）（在事务与多个数据库交互时使用）/用于并行执行语句的消息缓冲区

/（A）用于恢复管理器（RMAN）I/O从机的缓冲区

注：

*lager_pool

SGA中的可选区域，为备份和恢复操作、I/O服务器进程以及共享服务器和Oracle XA的会话内存提供大量内存分配。

*Oracle  XA

一种外部接口，允许全局事务由Oracle数据库以外的事务管理器进行协调。

*UGA

用户全局区域。存储会话变量（如登录信息）的会话内存，也可以包含OLAP池。

* Configuring the Large Pool

与共享池不同，Large Pool没有LRU列表（不是D）。Oracle数据库不会尝试将对象从大型池中过时。如果数据库实例使用以下任何Oracle数据库功能，请考虑配置大型池：

*共享服务器

在共享服务器体系结构中，每个客户机进程的会话内存都包含在共享池中。

*并行查询

并行查询使用共享池内存来缓存并行执行消息缓冲区。

*恢复管理器

恢复管理器（RMAN）在备份和恢复操作期间使用共享池缓存I/O缓冲区。对于I/O服务器进程、备份和还原操作，Oracle数据库分配大小为几百KB的缓冲区。