再讲RMAN备份和恢复所涉及的SGA

文档地址:http://docs.oracle.com/cd/B19306_01/server.102/b14211/memory.htm#i52838

 

Using the LargePool

Unlike the shared pool, the large pool does not have an LRUlist. Oracle does not attempt to age objects out of the largepool.

You should consider configuring a large pool if your instanceuses any of the following:

  • Parallel query

    Parallel query uses shared pool memory to cache parallelexecution message buffers.

    See Also:

    OracleDatabase Data Warehousing Guide for more information onsizing the large pool with parallel query
  • RecoveryManager

    Recovery Manager uses the sharedpool to cache I/O buffers during backup and restoreoperations. For I/O serverprocesses and backup and restore operations, Oracle allocatesbuffers that are a few hundred kilobytes in size.

    See Also:

    OracleDatabase Backup and Recovery Reference for moreinformation on sizing the large pool when using RecoveryManager
  • Shared server

    In a shared server architecture, the session memory for eachclient process is included in the shared pool.

 

文档地址:http://docs.oracle.com/cd/B19306_01/server.102/b14211/memory.htm#i34548

 

Shared PoolConcepts

 

     Anumber of features make large memory allocations in the sharedpool: for example, the shared server, parallel query, or RecoveryManager. Oracle recommends segregating the SGA memory used by thesefeatures by configuring a distinct memory area, called the largepool.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值