Hello,

Is there a particular thread or anywhere to look to get information about the current status of apex.oracle.com? I have been trying to use it to quickly learn and evaluate the features and capabilities of APEX. Right now my page requests are getting completely lost 30-40% of the time, I've seen unable to extend UNDO tablespace errors, it seems generally slow, etc. Has anyone else experienced this, or seen any remarks from Oracle concerning it? This is giving off a rather negative impression of the product and some explanation would be useful.

Thanks

I have noticed that "non-usual" performance lately, but this is something I have always expected as the number of online apex users is growing rapidly ! You can refer to this post " http://joelkallman.blogspot.com/2009/06/who-says-application-express-cant-scale.html
and I think that this guy " Joel Kallman" may be the best to asnwer your question.

Hope this help,

Sam Khalaf

Thanks Sam and Martin, that is very useful information.

I still think there is a problem with APEX, for two reasons:

1. Having some percentage of web requests hang indefinitely is not a correct error condition. There should be a better error handler for this situation. That is a web/application server problem.

2. A single user running bad code should not affect other users, especially in a system that is designed for multiple developers each with their own separate environment. The documentation highlights this as a benefit of APEX.

Anyway, those are issues for Oracle to look into. I appreciate the links and information.

-tim

>> Obviously if this were to continue, someone might have to create resource groups and assign how much resources can be consumed but that comes with a maintenance overhead which shouldn't be borne by a site of this nature.

Au contraire, mon frère - a system of this size and dynamic essentially requires Resource Manager. I have a Resource Manager plan in place, which I have blogged about. As I related to Martin, I couldn't understand why this long-running SQL in multiple sessions was left in my high-priority resource consumer group. I've never seen this issue before.

I had suspected that this was the cause of the problem, although, I'm still not 100% sure. Ever since our IT organization moved the Web server machines to different servers, users have complained about slow performance - and this is slow performance for static files served by the Web servers, it's not a database nor APEX issue. I believe it's a networking and/or load balancer issue, but without a reproducible case, it's hard for them to diagnose and solve. I just sent another message this evening (as other users complained of slow network performance again).

Joel "this guy" Kallman

Hi Tim,

1) It is front-ended by two servers, each running Oracle Application Server 10.1.2.x. This is all plugged into IT's grid, which helps them provision virtual hosts on demand. As well, all of the static resources are maintained on a big NetApp filter. For the most part, though, I'm really pretty fuzzy on the Web server details, but I know that there is minimal load generated by APEX.

2) I gave the specs of the database server in one of my comments here: http://joelkallman.blogspot.com/2008/02/who-uses-apexoraclecom.html. The server itself cost under $5K about 3 years ago. As my manager likes to say, it has an eBay value of approximately $1,000.

3) It's 11.1.0.6 Enterprise Edition, soon to have the 11.1.0.7 database patch set applied. It's not on a cluster.

4) We use the Database Resource Manager, which I discussed here http://joelkallman.blogspot.com/2009/08/oracle-database-resource-manager-and.html

I hope this helps.

Joel

Hi,

This performance is totally strange,
I was just 10min ago in company office where I work and using apex.oracle.com without any slowness. Never see that it is so fast.
Now in home, it is sloooooow.

Br, Jari

Hi Joel,

It may just be me, but one thing that I have noticed is that pages are generally better at loading in IE7 than FF3.5. Unfortunately, FireBug doesn't seem to help much here as most of the time taken seems to be before anything appears in the Net console. It may just be my FF settings, of course!

Andy

Karthikeyan,

Nobody reported any issues with apex.oracle.com today. I used it as well - I did not encounter any issues.

Joel