oracle对nproc,nproc/nofile之于oracle的意义

最新推荐文章于 2024-05-15 08:26:05 发布

weixin_39802055

最新推荐文章于 2024-05-15 08:26:05 发布

阅读量702

点赞数

文章标签： oracle对nproc

近来常常收到开发抱怨的邮件，即通过JDBC经常连接不上若干测试数据库，对应的错误代码见文尾；

检查process数量，并没有查过最大连接值；

对应的数据库压力也不大，没有严重的等待事件，且所在server可以ping通；

最后才想起检查操作系统配置

[oracle@test ~]$ ulimit -a

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 268288

max locked memory (kbytes, -l) 32

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 10240

cpu time (seconds, -t) unlimited

max user processes (-u) 268288

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

查看/etc/security/limits.conf文件，里面没有关于oracle的配置信息，于是手工添加如下信息

oracle soft nofile 2047

oracle hard nofile 65536

oracle soft nproc 1024

oracle hard nproc 65536

退出保存

并不确定这种调整是否有效，但是连续好几次都神奇的解决了此类问题，有可能是巧合。

我的问题是，关于如下两个参数

- nofile - max number of open files

- nproc - max number of processes

怎样度量oracle在一个server上的打开文件的数量，以datafile为单位吗？

已经如何判定oracle可支配的所谓processes的数量，这个process指的是普通的oracle进程吗？

欢迎各位回复赐教！

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:204)

at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)

at com.yihaodian.central.util.SqlMapClientTemplateMonitor.queryForObject(SqlMapClientTemplateMonitor.java:387)

at com.yihaodian.central.dao.impl.ProvinceDAOImpl.getProvinceByID(ProvinceDAOImpl.java:130)

at sun.reflect.GeneratedMethodAccessor690.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy89.getProvinceByID(Unknown Source)

at com.yihaodian.central.service.impl.ProvinceServiceImpl.getProvinceByID(ProvinceServiceImpl.java:14)

at sun.reflect.GeneratedMethodAccessor689.invoke(Unknown Source)