To modify the maximum number of Oracle connections

1. Ways to modify the maximum number of connections for Oracle

http://my.oschina.net/shootercn/blog/11193

A, landing in SYSDBA status of PL/SQL or Worksheet

Sqlplus SYS as SYSDBA

B, query the current number of connections

Show parameter processes;

C, change the number of system connections

Alter system set processes=1000 Scope=spfile;

D. Create Pfile

Create Pfile from SPFile;

E. Restart the Oracle service or restart the Oracle server

Shutdown immediate; Startup

F. See if the number of connections is modified again.

Show parameter processes;

2. How to query Oracle cursor usage

SELECT * from v$open_cursor where user_name = ' traffic ';

3. How to query Oracle session

SELECT * from V$session;

Sql> Select COUNT (*) from v$session where status= ' ACTIVE '; COUNT (*)----------sql> Select COUNT (*) from v$session; COUNT (*)----------187 sql> show parameter processes; NAME TYPE VALUE---------------------------------------------------------aq_tm_processes integer 0 db_writer_ Processes integer 1 gcs_server_processes integer 0 job_queue_processes integer log_archive_max_processes integer 2 proc Esses integer sql>

Concurrency refers to active,i see

Sql> Select COUNT (*) from v$session; #连接数 sql> Select COUNT (*) from v$session where status= ' ACTIVE '; #并发连接数 sql> show parameter processes; #最大连接 sql> alter system SET processes = value scope = spfile; Restart database #修改连接

To modify the maximum number of Oracle connections