Oracle XE Tuning
December 4, 2008 · Posted in oracle
In order to use Oracle XE under normal load, database sessions and processes need to be increased. This could be some as follows:
SQL> show parameters sessions
SQL> alter system set sessions=250 scope=spfile;
SQL> show parameters processes
SQL> alter system set processes=200 scope=spfile;
In case you are unable to access apex website remotely, run the following command as sys
exec dbms_xdb.setListenerLocalAccess(false);
Comments
Leave a Reply
