Oracle 参数 USE_LARGE_PAGES 官方解释,作用,如何配置最优化建议
USE_LARGE_PAGES参数用来控制是否使用大页(大页是物理内存中的一种特殊分类,比普通分页大很多)来管理SGA内存空间,如果设置为TRUE,则SGA中部分内存将用大页来管理,大页能够提供较少的系统开销,降低缓存模式下对页表的开销,一般情况下,Oracle集群系统会使用大页,而独立的Oracle数据库服务器则不会。
正确设置USE_LARGE_PAGES参数的步骤如下:
1、在操作系统提供的设置工具中设置大页,确保大页可以使用;
2、设置USE_LARGE_PAGES参数的值为TRUE,确认更改生效。
3、使用诊断工具检查大页设置是否正确,将错误信息记录下来,以便之后及时处理;
4、重启Oracle服务器,确认large page参数已生效;
5、使用查询语句检查系统是否正确使用large page,如果仍存在大页设置无效的情况,可以尝试在操作系统层面重新设置看看是否有用。
官方英文解释USE_LARGE_PAGES is used to manage the database s use of large pages for SGA memory.
Note:
This parameter is applicable only on the Linux operating system. However, setting this parameter to FALSE can cause performance degradation on any platform.
TRUE
Specifies that the instance can use large pages if large pages are configured on the system.
In Oracle Database 11g Release 2 (11.2.0.2), if there are not enough large pages configured on the system, then regular sized pages will be used to allocate SGA memory. This can cause the free large pages to go unused, and the operating system can allocate a huge amount of memory to create page tables to map SGA into physical pages for the Oracle processes. This may lead to ORA-04030 errors and severe performance degradation on an instance.
In Oracle Database 11g Release 2 (11.2.0.3) and later releases, Oracle allocates as much of the SGA as it can in large pages, and if it runs out, it will allocate the rest of the SGA using regular sized pages. This can cause the instance to create additional shared memory segments for the SGA, but the total SGA size will be unchanged. In this supported mixed page mode allocation, the database will exhaust the available large pages before switching to regular sized pages.
FALSE
Specifies that the instance will not use large pages. This setting is not recommended because it can cause severe performance degradation for the instance. Although the USE_LARGE_PAGES initialization parameter applies only to Linux systems, setting this parameter to FALSE can cause performance degradation on any platform.
AUTO
Specifies that, during startup, the instance will calculate and request the number of large pages it requires. If the operating system cannot fulfill this request, then the instance will start with a combination of large and regular pages.
ONLY
Specifies that the instance will fail to start if large pages cannot be used for the entire SGA memory. Oracle recommends this setting for consistent performance.
AUTO_ONLY
This setting is available starting with Oracle Database 19c and it is the default setting for Exadata systems. It specifies that, during startup, the instance will calculate and request the number of large pages it requires. If the operating system can fulfill this request, then the instance will start successfully. If the operating system cannot fulfill this request, then the instance will fail to start. This ensures that no instances will run with under-provisioned large pages.
Note:
USE_LARGE_PAGES is set to FALSE automatically in an Oracle ASM instance when MEMORY_TARGET is enabled. In this case, the FALSE setting does not cause performance degradation.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 参数 USE_LARGE_PAGES 官方解释,作用,如何配置最优化建议
相关文章
- Oracle中重命名用户的方法(oracle重命名用户)
- Oracle 参数 CURSOR_SPACE_FOR_TIME 官方解释,作用,如何配置最优化建议
- Oracle 参数 DB_FILE_MULTIBLOCK_READ_COUNT 官方解释,作用,如何配置最优化建议
- Oracle 参数 DIAGNOSTICS_CONTROL 官方解释,作用,如何配置最优化建议
- Oracle 参数 DISPATCHERS 官方解释,作用,如何配置最优化建议
- Oracle 参数 HASH_AREA_SIZE 官方解释,作用,如何配置最优化建议
- Oracle 参数 LISTENER_NETWORKS 官方解释,作用,如何配置最优化建议
- Oracle 参数 MAX_DUMP_FILE_SIZE 官方解释,作用,如何配置最优化建议
- Oracle 参数 NLS_TIMESTAMP_FORMAT 官方解释,作用,如何配置最优化建议
- Oracle 参数 OPTIMIZER_REAL_TIME_STATISTICS 官方解释,作用,如何配置最优化建议
- Oracle 参数 PRE_PAGE_SGA 官方解释,作用,如何配置最优化建议
- Oracle 参数 SERVICE_NAMES 官方解释,作用,如何配置最优化建议
- Oracle 参数 SGA_TARGET 官方解释,作用,如何配置最优化建议
- Oracle 参数 SKIP_UNUSABLE_INDEXES 官方解释,作用,如何配置最优化建议
- 解决Oracle删除实例的方法(oracle删除实例)
- 探索Oracle版本的数字之秘(查看oracle的位数)
- Oracle网络配置指南(oracle网络配置)
- 精通Oracle触发器的实现类型(oracle触发器类型)
- 探索Oracle数据库中的触发器类型(oracle触发器类型)
- 深入理解Oracle数据库分组和分析(oracle如何分组)
- Oracle如何判断记录是否存在?——25字(oracle判断记录存在)
- 「如何查询 Oracle 表记录数?」(oracle表记录数)
- Oracle监听器配置指南:简明扼要(怎么配置oracle监听)
- 解决Oracle监听配置失败烦恼(oracle配置监听失败)
- Oracle如何正确配置监听程序,完成数据库连接管理(oracle配置监听程序)
- 数据表Oracle数据表DDL删除技术实现(ddl删除 oracle)
- Oracle数据库中的试图分类研究(oracle中试图的分类)
- Oracle中填补空白的方法(oracle中补空格)
- Oracle侦听服务器配置指南(oracle侦听配置)
- 询数据深入浅出从Oracle从库中快速查询数据(oracle从库里查)
- Oracle在中国的朝气蓬勃发展(oracle中国部门)
- 查询Oracle中SQL语句查看显示报表(oracle中sql显示)
- Oracle OGG开启无缝数据迁移之旅(oracle ogg收费)
- Oracle IO优化提升系统的性能表现(oracle io配置)