we are using oracle apex 5.0 on glassfish 4 with oracle 12c on windows server 2012.
we have student exams and 100 students need to be connected to apex and issue queries from sql commands interface from apex.
we are using ords 3.0 and deployed on glassfish server.
during the exam, all of the sudden the apex disconnected with 500 internal server error.
we have to restart ords and glassfish server in order to enable the students to login.
tomorrow is another paper. kindly suggest for us how to fine tune the ords or glassfish so that i can bare the load.
below is the default.xml file from ords.
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<comment>Saved on Thu Sep 22 14:23:12 GST 2016</comment>
<entry key="cache.caching">false</entry>
<entry key="cache.directory">/tmp/apex/cache</entry>
<entry key="cache.duration">days</entry>
<entry key="cache.expiration">7</entry>
<entry key="cache.maxEntries">500</entry>
<entry key="cache.monitorInterval">60</entry>
<entry key="cache.procedureNameList"/>
<entry key="cache.type">lru</entry>
<entry key="db.hostname">10.153.4.198</entry>
<entry key="db.port">1521</entry>
<entry key="db.servicename">orcl1.hct.org</entry>
<entry key="debug.debugger">false</entry>
<entry key="debug.printDebugToScreen">false</entry>
<entry key="error.keepErrorMessages">true</entry>
<entry key="error.maxEntries">50</entry>
<entry key="jdbc.DriverType">thin</entry>
<entry key="jdbc.InactivityTimeout">3600</entry>
<entry key="jdbc.InitialLimit">500</entry>
<entry key="jdbc.MaxConnectionReuseCount">50000</entry>
<entry key="jdbc.MaxLimit">5000</entry>
<entry key="jdbc.MaxStatementsLimit">100</entry>
<entry key="jdbc.MinLimit">3000</entry>
<entry key="jdbc.statementTimeout">1500</entry>
<entry key="log.logging">false</entry>
<entry key="log.maxEntries">50</entry>
<entry key="misc.compress"/>
<entry key="misc.defaultPage">apex</entry>
<entry key="security.crypto.enc.password">B6xN3G9T5s_XMIT7QBxNWQ..</entry>
<entry key="security.crypto.mac.password">7YrxJ8tv3qeL1v7ejMj0Yg..</entry>
<entry key="security.disableDefaultExclusionList">false</entry>
<entry key="security.maxEntries">2000</entry>
</properties>