linux limit限制
檢視
ulimit -a
/etc/profile
~/.bash_profile
/etc/security/limit.conf
/etc/security/limit.d/20-nproc.conf
優先順序(網上說法):
1./etc/security/limit.d/20-nproc.conf
2./etc/security/limit.conf
3.~/.bash_profile
4./etc/profile
優先順序(我個人理解)(bash_profile裡的類似每次切換使用者臨時生效,所以高於持久化生效):
1.~/.bash_profile
2./etc/profile
3./etc/security/limit.d/20-nproc.conf
4./etc/security/limit.conf
1.常規
編輯/etc/security/limits.conf 新增如下內容:
vi /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
2.99 20檔案(優先順序高於上面的limits.conf)
Linux6:
/etc/security/limits.d/90-nproc.conf
Linux7:
/etc/security/limits.d/20-nproc.conf
3.oracle-database-preinstall-19c.conf檔案
一般19c有,位置也在 /etc/security/limits.d/下,用sqlplus startup起會用這個的限制
# oracle-database-preinstall-19c setting for nofile soft limit is 1024
oracle soft nofile 1024
# oracle-database-preinstall-19c setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-database-preinstall-19c setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle soft nproc 16384
# oracle-database-preinstall-19c setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-database-preinstall-19c setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-database-preinstall-19c setting for stack hard limit is 32768KB
oracle hard stack 32768
# oracle-database-preinstall-19c setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle hard memlock 474620572
# oracle-database-preinstall-19c setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle soft memlock 474620572
# oracle-database-preinstall-19c setting for data soft limit is 'unlimited'
oracle soft data unlimited
# oracle-database-preinstall-19c setting for data hard limit is 'unlimited'
oracle hard data unlimited
來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/69980685/viewspace-3001913/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 簡單介紹使用p-limit 限制併發數原始碼解析MIT原始碼
- 【TUNE_ORACLE】PGA_AGGREGATE_LIMIT詳解(一)PGA_AGGREGATE_TARGET的限制OracleMIT
- Linux伺服器---squid限制Linux伺服器UI
- Linux Limit相關內容設定大全(值得收藏)LinuxMIT
- Linux伺服器---ftp限制ipLinux伺服器FTP
- Linux伺服器---ftp限制頻寬Linux伺服器FTP
- 極限limitMIT
- set_time_limitMIT
- Mysql LIMIT的用法MySqlMIT
- MySQL中limit的用法MySqlMIT
- DMSQL LIMIT限定條件SQLMIT
- Linux中修改開啟檔案的數量限制Linux
- 白話 Linux 容器資源的隔離限制原理Linux
- Linux轉行學習有年齡限制嗎?Linux系統運維學習Linux運維
- 【TUNE_ORACLE】PGA_AGGREGATE_LIMIT詳解(二)PGA_AGGREGATE_LIMIT的作用OracleMIT
- SQL優化之limit 1SQL優化MIT
- Laravel 中 offset,limit 的使用LaravelMIT
- SQL之limit子句的使用SQLMIT
- mysql 使用技巧 分頁limitMySqlMIT
- sql中limit使用方法SQLMIT
- [20220223]Index ITL Limit.txtIndexMIT
- 如何在Linux中如何限制對su命令的訪問Linux
- 【TUNE_ORACLE】PGA_AGGREGATE_LIMIT詳解(三)PGA_AGGREGATE_LIMIT的大小設定OracleMIT
- mysql分頁-limit offset分頁MySqlMIT
- db2 hadr_spool_limitDB2MIT
- MySQL LIMIT 和 ORDER BY 最佳化MySqlMIT
- JavaScript Promise Time Limit Function All In OneJavaScriptPromiseMITFunction
- [20231027]Index ITL Limit 2.txtIndexMIT
- [20231027]Index ITL Limit 3.txtIndexMIT
- [20231031]Index ITL Limit 4.txtIndexMIT
- 聊聊flink Table的OrderBy及LimitMIT
- [20210315]acknowledge over PGA limit.txtMIT
- Linux apache怎麼限制併發連線和下載速度LinuxApache
- Linux: 如何分割檔案,不再被 4G 大小限制了Linux
- 使用Timekpr-nExt限制Linux中每個賬戶的使用Linux
- 定期刪除檔案,限制linux使用者登入時間Linux
- 詳解nginx的請求限制(連線限制和請求限制)Nginx
- Solaris 10’s Resource Management and Shell Limit(ulimit)MIT