SLTechnology News&Howtos › Database ›

Oracle maximum process causes data not to be connected

Shulou Source: shulou.com Published: 2022-06-01 17:42:43 09月27日 Update

View the maximum number of processes in ORACLE:

SQL > select count (*) from v$session # connections

SQL > Select count (*) from v$session where status='ACTIVE' # concurrent connections

SQL > show parameter processes # maximum connection

SQL > alter system set processes = value scope = spfile; restart database # modify connection

Unix 1 user session corresponds to one operating system process

And windows is embodied in threads.

Modify the maximum number of ORACLE processes:

Using sys, log in with sysdba privileges:

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=1000 scope = spfile

The system has 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

Got it!