Oracle XE Tuning

Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased.

Database Sessions

Increase the number of sessions that the database can handle at one time.  This will allow for more users to access the database.

sqlplus /nolog
SQL> show parameters sessions
SQL> alter system set sessions=250 scope=spfile;

restart the database.

 

Database Processes

Increase the number of database processes that can be running at one time.  This will allow for more users to connect to the database.

sqlplus /nolog
SQL> show parameters processes
SQL> alter system set processes=200 scope=spfile;

restart the database.

 

2 thoughts on “Oracle XE Tuning”

  1. i want to connect to eclipse id with oracle database …i got many more times of ping failed problem please help to me step by step orocedure……… ERROR:java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>