Re: persistent connections vs. login/logout white papers anyone?
Hi Robert, When I signed on at cybersurf the webserver (apache/perl/DBI) was handling 500 - 900 clients at any one time and the listener process took the most CPU as defined by top. The database server was pinned and everything was failing. By adding mod-perl to the mix (for caching database connections only, all the code was still running as a normal cgi) the listener dropped to usual CPU levels and the machine went to about a 30% CPU utilization. The one caveat is ensure that the webserver has a is fairly aggressive about shutting down idle connections or the database server will swap out the server side process causing shorter but still annoying delays. Also use dedicated servers as the MTS has problems dealing with long winded connections. HTH Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: persistent connections vs. login/logout white papers anyone?
Robert, I am just writing a paper on that. It is called Application Efficiency and there some interesting results on this. IIt has great impact on the amount of CPU used and response time. Anjo. "Freeman, Robert" wrote: > Looking for any white papers on the above topic with > business cases, testing results, etcAnyone know of > any...? > > RF > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: persistent connections vs. login/logout white papers anyone?
Robert - Don Bales in his recent book "Java Programming with Oracle JDBC" (O'Reilly) describes 4 strategies for Java servlet database connections: 1. Per-transaction connection. Each method opens and closes the connection. Most CGI programs use this and it is the least efficient. 2. Dedicated connection. The servlet uses one connection that remains open during the servlet's entire lifetime and is shared by all users of the servlet. 3. Session connection. Store the connection in an HTTP session object, from which it can be retrieved and used by the other method calls invoked in the same user session. 4. Cached connection. Use a connection pool to minimize the total number of connections that are open at any one time. That is a very fast overview, Don has an entire chapter on this subject. Oracle has pinned its future on the success of Java. I think we DBAs are going to need to understand these issues much better in the future in order to communicate with our Java programmers. Bottom line is that I think that when application servers are involved, the issue becomes more complex than just persistent vs. login/logout. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, April 29, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Looking for any white papers on the above topic with business cases, testing results, etcAnyone know of any...? RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).