The minimum value suggested as per https://docs.oracle.com/database/121/LTDQI/toc.htm#BHCCADGD for aio-max-nr is 1048576 .
We recommend setting aio-max-nr to 3145728 in case that ORA-27090 occurred.
And the maximum of aio-max-nr parameter can be calculated by -
aio-max-nr =no of process per DB no of databases 4096
After deriving the value using this formula , you should still monitor the /proc/sys/fs/aio-nr value and also monitor I/O loading.
Points to know -
1) Number of processes per database is not background server process number, it's the number of background server process + user
process.
2) Parameter aio-max-nr is a limitation of aio-nr, no impact was reported if you set it too high. But we should still monitor /proc/sys/fs/aio-nr
value and tune this value.
What value should kernel parameter AIO-MAX-NR be set to ?
2024-05-23
60
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《
阿里云开发者社区用户服务协议》和
《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写
侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：
What value should kernel parameter AIO-MAX-NR be set to ?
目录
相关文章
成功解决A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,co
成功解决A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,co
8744
0
0
|
3月前
|
Kubernetes
Unix
容器
As the default settings are now deprecated, you should set the endpoint inste
As the default settings are now deprecated, you should set the endpoint inste
35
0
0
|
3月前
|
Java
应用服务中间件
nginx
【Azure 环境】Azure应用程序网关设置set_Cookie=key=value; SameSite=Strict; HTTPOnly，AzureAD登录使用cookie时使用不了的案例记录
【Azure 环境】Azure应用程序网关设置set_Cookie=key=value; SameSite=Strict; HTTPOnly，AzureAD登录使用cookie时使用不了的案例记录
52
0
0
|
4月前
|
数据处理
Python
【Python】已解决：SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFram
【Python】已解决：SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFram
519
1
1
|
4月前
content‘ is declared but its value is never read.富文本编辑器中这里必须的script中添加setup，引入到set当中时，带title的富文本写法
content‘ is declared but its value is never read.富文本编辑器中这里必须的script中添加setup，引入到set当中时，带title的富文本写法
55
0
0
|
5月前
|
缓存
NoSQL
关系型数据库
Redis第二课，1.set key value(设置对应的key和value)2.get key(得到value值)Redis全局命令（支持很多的数据结构)3.keys(用来查询当前
Redis第二课，1.set key value(设置对应的key和value)2.get key(得到value值)Redis全局命令（支持很多的数据结构)3.keys(用来查询当前
66
0
0
|
JavaScript
API
【Vue】Cannot set reactive property on undefined,null,or primitive value:undefined
【Vue】Cannot set reactive property on undefined,null,or primitive value:undefined
286
0
0
|
Python
成功解决pandas\core\indexing.py:179: SettingWithCopyWarning: A value is trying to be set on a copy of a
成功解决pandas\core\indexing.py:179: SettingWithCopyWarning: A value is trying to be set on a copy of a
625
0
0
|
消息中间件
Kafka
Cannot set the value of read-only property ‘additionalSourceDirs‘ for task ‘:jacocoRootReport‘ of
这个问题是gradle的build版本问题，我是在build kafka的老版本时报的错，这个问题我查了一遍网上的内容，发现很多博客忽略了IDEA settings关于gradle的build的一个配置。
488
0
0
debian samba出错：set_variable_helper(yes ): value is not boolean!
debian samba出错：set_variable_helper(yes ): value is not boolean!
187
0
0
热门文章
最新文章
1
PHP 魔术方法__set() __get() 方法
2
Set Perennial reservation on RDM LUNs in a Cluster
3
特殊权限位set_uid set_gid stick_bit 软链接硬链接
4
使用es6的set和map实现数组去重复
5
oc-16-set,get方法
6
主外键关联删除(on delete set null和on delete cascade)
7
『MongoDB』MongoDB高可用部署架构——复制集篇（Replica Set）
8
Set uid, gid,sticky bit的三个权限的详细说明
9
Error: Failed to set Event Logging
10
Parameter \' \': No size set for variable length data type: String
1
C++：map&set 对红黑树的封装
35
2
Map与Set的经典OJ题
45
3
Map与Set
44
4
C++：STL - set & map
49
5
问题：Android requires .class compatibility set to 5.
29
6
Redis数据类型 Hash Set Zset Bitmap HyperLogLog GEO
60
7
探索 Elasticsearch 8.X Terms Set 检索的应用与原理
94
8
【C++入门到精通】哈希 (STL) _ unordered_map _ unordered_set [ C++入门 ]
78
9
If you are using the git profile, you need to set a Git URI in your configuration. If you are using
145
10
failed to set system property error code: 0x18
282