centos7 oracle 12c 内存32G调整为16G
2021/6/22 20:02:33
本文主要是介绍centos7 oracle 12c 内存32G调整为16G,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
1. 32G oracle配置
1. 32G oracle配置
[oracle@oracle ~]$ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Thu May 13 08:56:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL> conn /as sysdba; Connected. SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 9664M sga_min_size big integer 0 sga_target big integer 9664M unified_audit_sga_queue_size integer 1048576 SQL> SQL> show parameter pga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_limit big integer 6436M pga_aggregate_target big integer 3218M SQL> show parameter target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_big_table_cache_percent_target string 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 parallel_servers_target integer 128 pga_aggregate_target big integer 3218M sga_target big integer 9664M target_pdbs integer 0
2. 32G sysctl.conf配置
cat /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 3294590 kernel.shmmax = 16868304896 kernel.shmmni= 4096 kernel.sem= 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
3.16G oracle配置
SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 8096M sga_min_size big integer 0 sga_target big integer 8000M unified_audit_sga_queue_size integer 1048576 SQL> SQL> show parameter pga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_limit big integer 2400M pga_aggregate_target big integer 798M SQL> show parameter target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_big_table_cache_percent_target string 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 parallel_servers_target integer 128 pga_aggregate_target big integer 798M sga_target big integer 8000M target_pdbs integer 0
4. 16G sysctl.conf配置
cat /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni= 4096 kernel.sem= 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
5. 修改32G oracle 的sysctl.conf
将 kernel.shmall = 3294590 kernel.shmmax = 16868304896 改为 kernel.shmall = 2097152 kernel.shmmax = 4294967295 执行命令使修改生效 sysctl -p
6. 修改32G oracle的配置
SQL> alter system set sga_max_size = 8096M scope=spfile; System altered. SQL> alter system set sga_target=8000M scope=spfile; System altered. SQL> alter system set pga_aggregate_target=798M scope=both; System altered. SQL> alter system set pga_aggregate_limit=2400M scope=both; System altered.
7.重启oracle
>sqlplus /nolog >conn /as sysdba shutdown immediate; startup;
8.修改服务器内存32G改为16G,然后启动oracle,已验证正常。
作者:yunwei_ls
链接:https://www.jianshu.com/p/04b6f58872fa
来源:简书
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。
这篇关于centos7 oracle 12c 内存32G调整为16G的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-04安装 VPrix Desktop 的系统要求-icode9专业技术文章分享
- 2024-05-01巧用 TiCDC Syncpoint 构建银行实时交易和准实时计算一体化架构
- 2024-05-01银行核心背后的落地工程体系丨Oracle - TiDB 数据迁移详解
- 2024-04-26高性能表格工具VTable总体构成-icode9专业技术文章分享
- 2024-04-16软路由代理问题, tg 无法代理问题-icode9专业技术文章分享
- 2024-04-16程序猿用什么锅-icode9专业技术文章分享
- 2024-04-16自建 NAS 的方案-icode9专业技术文章分享
- 2024-04-14ansible 在远程主机上执行脚本,并传入参数-icode9专业技术文章分享
- 2024-04-14ansible 在远程主机上执行脚本,并传入参数, 加上remote_src: yes 配置-icode9专业技术文章分享
- 2024-04-14ansible 检测远程主机的8080端口,如果关闭,则echo 进程已关闭-icode9专业技术文章分享