tag:blogger.com,1999:blog-12214002.post7397680888762156231..comments2024-03-09T06:56:57.099-05:00Comments on Let's Wreck This Together...with Oracle Application Express!: Oracle HTTP Server, Apache 2.0 and connection poolingJoel R. Kallmanhttp://www.blogger.com/profile/01915290758512999160noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-12214002.post-43266378112578429712009-06-13T18:48:15.248-04:002009-06-13T18:48:15.248-04:00Hi
very interesting.
I have a problem with APEX ...Hi<br /><br />very interesting.<br /><br />I have a problem with APEX and SSL, i need to configure APEX in order to access it via https, some articles say that i have to configure some files under $ORACLE_HOME/Apache but that path doesn't exist, and opmn.xml neither.<br /><br />I don't know if i have to install something else like OAS' components.<br /><br />Please give me an idea.<br /><br />Best Regards, Oscar Palacios.Unknownhttps://www.blogger.com/profile/12260082475648507153noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-64639019908103159002008-07-10T13:06:00.000-04:002008-07-10T13:06:00.000-04:00@Anonymous,It's all a function of your maximum, tr...@Anonymous,<BR/><BR/>It's all a function of your maximum, truly concurrent throughput. If there was a microsecond in time where your load-tester was actively requesting a page from 20 different clients, then I believe your results are to be expected.<BR/><BR/>JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-47535978381127654902008-07-04T11:19:00.000-04:002008-07-04T11:19:00.000-04:00Havard, It is available for Windows as well at:Win...Havard,<BR/><BR/> It is available for Windows as well at:<BR/><BR/><A HREF="http://www.oracle.com/technology/software/products/database/oracle11g/111060_win32soft.html" REL="nofollow">Windows Apache 2.0 OHS </A><BR/><BR/>Joel and all, thanks again for the great Apex info!<BR/><BR/>RobertAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-41786636236106102492008-07-04T10:48:00.000-04:002008-07-04T10:48:00.000-04:00Hello everybody,please could You tell me, whether ...Hello everybody,<BR/><BR/>please could You tell me, whether there is a possibility to switch off the connection pooling or not for small applications? My need are some settings stored in the db-session after calling a pl/sql procedure.<BR/><BR/>For my purposes it would be fine to have exactly one db-connection per active session (perhaps a reseted one after usage).<BR/><BR/>Is there a option?<BR/><BR/>Many thanks!<BR/><BR/>Filip KarstAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-44675348626362078342008-06-27T11:45:00.000-04:002008-06-27T11:45:00.000-04:00The mod_plsql does work with the worker mpm but a ...The mod_plsql does work with the worker mpm but a load test with 20 users and only 4 httpd worker processes still made 16-20 database connections when I would have only expected 4 connections (ie. 1 connection per httpd.worker process). So it looks like we are getting almost 1 connection per thread which is not very different from what we had before - did anyone notice this too?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-26460691531969282792008-02-28T11:54:00.000-05:002008-02-28T11:54:00.000-05:00Is the Oracle HTTP Server (OHS) bundled with Oracl...Is the Oracle HTTP Server (OHS) bundled with Oracle 11g currently available for Windows? I can only find a download link for the Linux version of OHS. What happened to the Windows version?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-42353951139790473552008-01-22T09:50:00.000-05:002008-01-22T09:50:00.000-05:00Havard,I'm no licensing expert. I am a developmen...Havard,<BR/><BR/>I'm no licensing expert. I am a development manager (or as Dimitri incorrectly classifies me, a product manager).<BR/><BR/>The Oracle HTTP Server that ships with Database 11g is included as part of the license for the Oracle database. If you're licensed for the Oracle database, then you're licensed for the Oracle HTTP Server that is bundled with the Database 11g distribution.<BR/><BR/>JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-29784624146095371532008-01-22T09:45:00.000-05:002008-01-22T09:45:00.000-05:00Hi Dietmar,Yes - it's ready for prime time. It's ...Hi Dietmar,<BR/><BR/>Yes - it's ready for prime time. It's the same mod_plsql that will be delivered with AS 11g. It was essentially delivered "early" with this version of Oracle HTTP Server with DB 11g.<BR/><BR/>I've encountered no performance or stability issues. I've been running it on our development server for months now.<BR/><BR/>I don't believe there were any new features added - it's the same basic functionality, but ported to work with Aapche 2.0. So POSTing to CLOBs or posting more than 32K bytes to a VARCHAR2 variable still remains.<BR/><BR/>You should be able to use this Oracle HTTP Server with any database version.<BR/><BR/>JoelJoel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-21808106477052259262008-01-22T05:53:00.000-05:002008-01-22T05:53:00.000-05:00Joel, Regarding the Oracle HTTP Server that ships ...Joel, <BR/><BR/>Regarding the Oracle HTTP Server that ships with Oracle Database 11g; what kind of license does one need to run it in production?<BR/><BR/>I gather that mod_plsql is an Oracle product, so Oracle HTTP Server is an interesting combination with Oracle XE (currently based on 10g).<BR/><BR/>HavardAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-57627443962820156212008-01-22T03:27:00.000-05:002008-01-22T03:27:00.000-05:00Dietmar,I've been doing a bit of performance/stres...Dietmar,<BR/><BR/>I've been doing a bit of performance/stress testing with it and I haven't faced any stability issues yet, although it's still pretty early to say (compared to how long I've been using the 1.3 Apache I mean).<BR/><BR/>I was *very* happy (and surprised!) too to see it listed on the page when I was checking out 11g, it's been a long time coming!<BR/><BR/>John.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12214002.post-31682245368114103352008-01-22T01:24:00.000-05:002008-01-22T01:24:00.000-05:00Hi Joel, this is very good news !!! We have faced ...Hi Joel, <BR/><BR/>this is very good news !!! We have faced some real problems spawning a new database session for each new httpd process ;). <BR/><BR/>Is it ready for prime time yet? Or are there any stability / performace issues? This module is brand new using the new architecture, right? Or didn't Oracle had to change the code, just switch the "process type"?<BR/><BR/>Also, have there been new features added, like using clobs instead of varchar2 (32K issue)? <BR/><BR/>We can use it with a plain 9.2.0.3, no need for 11g, right?<BR/><BR/>Greetinx,<BR/>~Dietmar.Anonymoushttps://www.blogger.com/profile/04283721022948206416noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-58522753186585324812008-01-21T20:38:00.000-05:002008-01-21T20:38:00.000-05:00Thanks Patrick. Maybe I'll continue to find the t...Thanks Patrick. Maybe I'll continue to find the time. BTW, I do blame you for Flavio being able to locate me.Joel R. Kallmanhttps://www.blogger.com/profile/01915290758512999160noreply@blogger.comtag:blogger.com,1999:blog-12214002.post-3448732702674311112008-01-21T18:33:00.000-05:002008-01-21T18:33:00.000-05:00Joel, very interesting article! Especially for peo...Joel, very interesting article! Especially for people running Apache/APEX on Unix.<BR/><BR/>BTW, congratulation to your "outing"! :-)<BR/><BR/>PatrickPatrick Wolfhttps://www.blogger.com/profile/16652802762749621200noreply@blogger.com