kods.net » oracle,oracle home,oracle database » Adjustment oracle database connection pool connections

Adjustment oracle database connection pool connections

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
Digg Technorati StumbleUpon Mixx del.icio.us Reddit BlinkList Furl YahooMyWeb

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/

Leave a reply