欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

oracle 数据库 processes、sessions 的设置

程序员文章站 2022-06-24 23:08:45
os: centos 7.4db: oracle 11.2.0.4版本# cat /etc/centos-releaseCentOS Linux release 7.4.1708 (Core) # su - oracleLast login: Mon Jul 13 14:42:54 CST 2020 on pts/0$ $ $ sqlplus / as sysdba;SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 13 14:5...

os: centos 7.4
db: oracle 11.2.0.4

版本

# cat /etc/centos-release
CentOS Linux release 7.4.1708 (Core) 

# su - oracle
Last login: Mon Jul 13 14:42:54 CST 2020 on pts/0
$ 
$ 
$ sqlplus / as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 13 14:50:33 2020

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> set lines 200;
set pages 200;

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE	11.2.0.4.0	Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

processes、sessions

当前的值

SQL> show parameter processes;
processes			     integer			      1000

SQL> show parameter sessions; 
sessions			     integer			      1528

SQL> alter system set processes=600 scope=spfile;

SQL> startup force;

SQL> show parameter processes;
processes			     integer			      600

SQL> show parameter sessions;
sessions			     integer			      928

sessions 值随着 sessions自动调整

sessions= processes * 1.5 + 28

下面单独设置下 sessions

SQL> alter system set sessions = 1000 scope=spfile;

SQL> startup force;

SQL> show parameter processes;
processes			     integer			      600

SQL> show parameter sessions;
sessions			     integer			      1000

可以看到 sessions单独设置1000后,显示为1000

所以日常运维中只需要设置 processes 参数即可。

本文地址:https://blog.csdn.net/ctypyb2002/article/details/107317003