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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 程式的limit 限制的修改MIT
- Nginx limit模組限制併發數NginxMIT
- 利用資源限制效能診斷resource limitMIT
- 簡單介紹使用p-limit 限制併發數原始碼解析MIT原始碼
- linux----ulimit 限制LinuxMIT
- MySQL LIMIT 如何改寫成Oracle limitMySqlMITOracle
- 【LINUX】linux相關資源限制Linux
- Linux Limit相關內容設定大全(值得收藏)LinuxMIT
- 【TUNE_ORACLE】PGA_AGGREGATE_LIMIT詳解(一)PGA_AGGREGATE_TARGET的限制OracleMIT
- limit優化MIT優化
- RESOURCE_LIMITMIT
- limit active sessionsMITSession
- 極限limitMIT
- Linux伺服器---ftp限制ipLinux伺服器FTP
- Linux伺服器---squid限制Linux伺服器UI
- Linux執行緒(程式)數限制Linux執行緒
- [zhuan]linux限制IP訪問sshLinux
- 使用資料庫引數 PGA_AGGREGATE_LIMIT 限制程式大小 (文件 ID 1602891資料庫MIT
- set_time_limitMIT
- Mysql LIMIT的用法MySqlMIT
- v$resource_limitMIT
- day limit in terms of paymentMIT
- suse linux 10_su - oracle報ulimit錯誤-cannot modify limit:LinuxOracleMIT
- Linux伺服器---ftp限制頻寬Linux伺服器FTP
- Linux 執行緒(程式)數限制分析Linux執行緒
- Linux對外連線埠數限制Linux
- Linux CentOS SSH埠限制及變更LinuxCentOS
- linux 下select的1024限制Linux
- DMSQL LIMIT限定條件SQLMIT
- MySQL中limit的用法MySqlMIT
- oracle實現"limit"功能OracleMIT
- AIX中的limit值AIMIT
- 關於linux 資源限制 limits.confLinuxMIT
- mysql 使用技巧 分頁limitMySqlMIT
- Laravel 中 offset,limit 的使用LaravelMIT
- SQL優化之limit 1SQL優化MIT
- SQL之limit子句的使用SQLMIT
- sql中limit使用方法SQLMIT