914856 wrote:I have a similar issue to yours though my environment is different. Apex on my laptop can take a considerable amount of time to render pages on A Windows 7 system running Oracle 11gR2, Apex 4.2 and the internal PL/SQL gateway. Pages can take up to a minute or two to render although at other times rather faster due to (I believe) a combination of the embedded PL/SQL gateway and corporate-mandated monitoring software.
Hi All, Oracle Apex slowness is big issue for me. Thanks in advance for your solution. Following are details of the problem. I am using Oracle 11g R2, in Red Hat Linux. Dual processor with 32 GB RAM,600 GB HDD. I upgraded default apex to Apex 4.1.1. I set the SHARED_SERVERS=10. But Apex builder as well as application is very slow. Some times it become faster again page submit and loading became slow. Lastly I upgraded to Apex 4.2 but still facing same slowness. Please help me in this regards.
maceyah wrote:Interesting idea - thanks
Anti-virus is a possible reason for poor Oracle perfromance on Windows. Make sure you exclude all your Oracle data files, archive logs etc from AV monitoring, else AV will scan them like crazy during normal database activity, resulting in awful DB response.
XE only use 1 microprocesser and 1 GB of RAM, but under my view of point you have overloaded your laptop. Because it not only working with those tools, also is working with the windows enviroments (Chrome only by itself need 1 GB when you open more than 1 tab). Best watch the task manager and control all the process.
The best in any case is separate server from all the others, run to Linux, CentOs is a good option and install all the servers. Linux have the advantage that only run what you want to run nothing more and so you can control what is running in your RAM.