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-084万 star 的 NocoDB 在 sealos 上一键起,轻松把数据库编程智能表格
- 2024-05-08Mac 版Stable Diffusion WebUI的安装
- 2024-05-08解锁CodeGeeX智能问答中3项独有的隐藏技能
- 2024-05-08RAG算法优化+新增代码仓库支持,CodeGeeX的@repo功能效果提升
- 2024-05-08代码报错不用愁,CodeGeeX一键完成代码修复、错误解释的功能上线了!
- 2024-05-08今天开始程序员不用再发愁写commit message了,全部由CodeGeeX自动完成!
- 2024-05-08倒计时2天!AutoMQ 联合 StarRocks、KubeBlocks 共同探讨云原生现代化数据栈
- 2024-05-08云上如何实现 Autoscaling: AutoMQ 的实战经验与教训
- 2024-05-08AIGC爆发算力引领数据中心(IDC)长期需求
- 2024-05-08Kafka Exactly Once 语义实现原理:幂等性与事务消息