Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.