Sometimes, the EBS reports insufficient connections. Therefore, we try to improve processes and sessions. After EBS is installed, the default value of the init parameter processes is 200, and the default value of sessions is 400. here I increase the processes and sessions of DB to 500 and 1000.
Processes = 500 # Max. no. of users x 2
Sessions = 1000 #2 X processes
After modification, restart the database and the parameter will take effect.
Addbctl. sh stop
Addbctl. sh start
View parameter settings
Show parameter processes
Show parameter sessions
In the Oracle ebs db Init Parameters article (SEE), Oracle provides a reference setting for init parameter.
Description of Processes and sessions parameters and init. ora
#########
#
# Processes and sessions parameters
#
# A database process can be associated with one or more databases
# Sessions. For all technology stack components other than Oracle
# Forms, there is a one-to-one mapping between sessions and processes.
#
# For Forms processes, there will be one database session per
# Open form, with a minimum of two sessions per Forms user (one
# For the navigator form, and one for the active form ).
#
# The sessions parameter shocould be set to twice the value of
# Processes parameter.
#
#########
In addition, how can I query the number of connections and the maximum number of connections of current data?
- -- Current number of connections
- Select Count(*)FromV $ process;
- -- Set the maximum number of connections (default value: 200)
- SelectValueFromV $ parameterWhere Name='Processs';
- ------------------------------------------------
- -- View the current session usage
- SELECTCount(*)FROMV $ session;
- Or
- SELECTUsername, machine, program, status,COUNT(Machine)AS
- FROMV $ session
- GROUP BYUsername, machine, program, status
- ORDER BYMachine;
- -- View the maximum number of sessions in the system
- SelectValueFromV $ parameterWhere Name='Session';