暂无图片
咨询关于oracle进程数问题
我来答
分享
Uncopyrightable
2021-09-23
咨询关于oracle进程数问题
暂无图片 5M

oracle按照cpu购买授权,之前有人就推荐按照cpu核心数*10配置进程数,这种说法有什么依据嘛?

实际工作中很多项目的进程数远远大于cpu核心数*10,是否合理利用CPU资源?

进程数是每个应用创建连接算是占用一个还是会话连接算占用一个?还是创建一个用户进程算是一个进程数?

进程数、会话数,连接数之前有什么关系?

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
章芋文

你说的进程数是process参数吗?cpu_count*10来配肯定是不够的。具体还是要根据应用本身负载情况来,比如有的应用100个会话都是不干活的,有的应用5个会话非常繁忙。合理利用CPU资源,还是需要进行压测来满足应用的并发请求。

关于进程、会话、连接之间没有特定的关系,可以是一一对应,也可以是一对多,可以参考askTom:

A connection is a physical circuit between you and the database. A connection might be one of many types – most popular begin DEDICATED server and SHARED server. Zero, one or more sessions may be established over a given connection to the database as show above with sqlplus. A process will be used by a session to execute statements. Sometimes there is a one to one relationship between CONNECTION->SESSION->PROCESS (eg: a normal dedicated server connection). Sometimes there is a one to many from connection to sessions (eg: like autotrace, one connection, two sessions, one process). A process does not have to be dedicated to a specific connection or session however, for example when using shared server (MTS), your SESSION will grab a process from a pool of processes in order to execute a statement. When the call is over, that process is released back to the pool of processes.

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:5671284058977

暂无图片 评论
暂无图片 有用 0
暂无图片
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏