View and modify the maximum number of Oracle Processes

View the maximum number of processes in Oracle:
SQL> select count (*) from v $ session # Number of connections
SQL> Select count (*) from v $ session where status = 'active' # number of concurrent connections
SQL> show parameter processes # maximum connection
SQL> alter system set processes = value scope = spfile; restart the database # modify the connection

One session of a unix user corresponds to an operating system process.
Windows is embodied in the thread

------------------------------------------------------------------------------
Modify the maximum number of ORACLE processes:
Use sys to log on with sysdba permissions:

SQL> show parameter processes;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 1
Job_queue_processes integer 10
Log_archive_max_processes integer 1
Processes integer 150

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

The system has been changed.

SQL> show parameter processes;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 1
Job_queue_processes integer 10
Log_archive_max_processes integer 1
Processes integer 150

SQL> create pfile from spfile;

The file has been created.
 

Restart the database,
 
SQL> show parameter processes;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Aq_tm_processes integer 1
Db_writer_processes integer 1
Job_queue_processes integer 10
Log_archive_max_processes integer 1
Processes integer 300
 
Done!