Adjustment oracle database connection pool connections

Posted on 2009-06-26 filed under: Oracle Database (RSS) 42 views   

First backup $ ORACLE_HOME \ dbs \ spfileSID.ora document

c:> set ORACLE_SID = xxx
c:> sqlplus / nolog
sql> connect / as sysdba

- View the current value of the parameter
sql> show parameter processes;
sql> show parameter sessions;
sql> show parameter sga_target;

- Amend the number of connections
sql> alter system set processes = 500 scope = spfile;
sql> alter system set processes = 555 scope = spfile; / / session = process * 1.1 +5
Modified database can be restarted

Tags: oracle, Oracle 10g - How to Connect to a Oracle Database in Delphi, oracle connection pool deadlock oracle, oracle home, oracle database, sid, target, sqlplus nolog, database connection, current value, scope, document c, connection pool, sessions

Permalink: http://www.kods.netwww.kods.net/adjustment-oracle-database-connection-pool-connections/