Hi 914856 , again please change your username to something friendly.
I'm assuming you're on a 64 bit oracle 11g r2.
There could be any number of causes to your performance problems but I would do the following.
-Get your DBAs to trace some page loads to see if it's a database issue and what objects if any are causing the problem.
-Ensure that your logs are not too large. It's happened to me before, my access and error logs were over 200M and things started slowing down
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.
Turning caching on helped a little for loading speed.
Which listener are you using?
Edited by: riedelme on Jan 28, 2013 9:23 AM
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.
Checking the AV won't solve the overhead of our mandated security software though :(
Thanks for your reply. I am also using Laptop for development, next I upload the application into production server. My laptop has 4 GB RAM, win 7 32 bit OS, Oracle 11g XE database, APEX lastly updated to 4.2, Oracle BI Publisher 10g. APEX page loading and submit also slow in development environment as well as production server. Anti virus is inactive in my Laptop.
Following are information about apex for your information.
Product Build: 4.2.0.00.27
Schema Compatibility: 2012.01.01
Last DDL Time: 01/14/2013 04:04:32 PM
Host Schema: ANONYMOUS
Application Owner: APEX_040200
Workspace ID: 4876332611023979
Workspace Name: BEH
Current User: BDEYE
Language Preference: en
Current Time (on server): 02/04/2013 11:45:46 AM
SERVER_SOFTWARE Oracle Embedded PL/SQL Gateway/220.127.116.11.0
SERVER_NAME XDB HTTP Server
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.1; rv:18.0) Gecko/20100101 Firefox/18.0
CORE 18.104.22.168.0 Production
NLSRTL Version 22.214.171.124.0 - Production
Oracle Database 11g Express Edition Release 126.96.36.199.0 - Production
PL/SQL Release 188.8.131.52.0 - Production
TNS for 32-bit Windows: Version 184.108.40.206.0 - Production
DAD CHARACTERSET: UTF-8
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.