Re: Experiences setting OPEN_CURSORS for Java applications
Craig, Thanx for your tool. Right now,let us (developers) use it with Jboss and let u know if there is any issue. Thanx a lt for your support. Regards, Jp. 02-10-2003 21:41:15, Craig Munday [EMAIL PROTECTED] wrote: Jp, I've forwarded you a separate email with the tool included as an attached zip file. In answer to your questions: The JDK version is 1.4.1 and above. I do not expect any problems with JBOSS 3.2.1 and higher although I would be interested in hearing about any problems should you come across some. I've never used apache so I am not sure whether it will work or not. I am definitely interested in helping you to get it working though. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
Jp, I've forwarded you a separate email with the tool included as an attached zip file. In answer to your questions: The JDK version is 1.4.1 and above. I do not expect any problems with JBOSS 3.2.1 and higher although I would be interested in hearing about any problems should you come across some. I've never used apache so I am not sure whether it will work or not. I am definitely interested in helping you to get it working though. Cheers, Craig. At 04:21 AM 30/09/2003 -0800, you wrote: Craig, CMI can send you a copy if you are interested - CMyou will have to forward me your JDK version and details about any app CMserver that you are using. I would , sure , be very much interested in having a copy of that tool. developers here use diff. versions of JDK apache/tomcat/jboss ... is it JDK version/app. server specific ? can JDBC Expert for JDK 1.4.1_03/jboss 3.2.1 used for JDK 1.4.1_03/apache 2.0.4 ?? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: AW: Experiences setting OPEN_CURSORS for Java applications
Hi, I'm not sure about the Interceptor pattern. Log4j is a great package and I make use of it within JDBC Expert. I started using the new logging API in JDK 1.4 but found most developers were using Log4j so I changed. Log4j seems like a much more mature package anyway. I too think it would be a great tool to be used in the development cycle. Ideally I would like every developer to have it installed while they complete their development in the hope that a number of defects can be eliminated early. In reality though, I find that senior developers and data administrators see the most benefits. Particularly database administrators, probably because they are the ones that are called upon to resolve the errors (such as ORA-1000) when they occur. Let me know if you would like a copy, and I'll email it privately to you - its too big to send to the list. Regards, Craig Munday. At 06:49 AM 1/10/2003 -0800, Stefan Jahnke wrote: Hi Just wondering: How did you implement the transparancy aspect ? Interceptor pattern (as in CORBA) ? Your tool seems to be a very good thing to use during dev-cycle to log certain aspects you're interested in (maybe log4j might do the job ?). Stefan -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
AW: AW: Experiences setting OPEN_CURSORS for Java applications
Hi Craig The whole point of an interceptor is basically to add functionality to a certain type or protocol without changing the interface the client works with. In Java, this is usually accomplished by implementing an extra interface to add things like security or billing based on transactions etc. (I've seen this in CORBA first, hence the reference to it). The developer continues working with the same types she/he used to work with. It often comes along with the factory pattern, where a certain object is created and returned to the calling object. The calling object uses the interface of the type it wanted, not being aware of any additional things. I hope that was confusing enough ;) Right now, we just implemented some common PL/SQL packages to deal with logging and error handling etc., but I have to say, the idea to add an extra layer to the JDBC architecture is a great idea. Helps DBAs spotting problems real easy, as you said. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. Oktober 2003 15:20 An: Multiple recipients of list ORACLE-L Betreff: Re: AW: Experiences setting OPEN_CURSORS for Java applications Hi, I'm not sure about the Interceptor pattern. Log4j is a great package and I make use of it within JDBC Expert. I started using the new logging API in JDK 1.4 but found most developers were using Log4j so I changed. Log4j seems like a much more mature package anyway. I too think it would be a great tool to be used in the development cycle. Ideally I would like every developer to have it installed while they complete their development in the hope that a number of defects can be eliminated early. In reality though, I find that senior developers and data administrators see the most benefits. Particularly database administrators, probably because they are the ones that are called upon to resolve the errors (such as ORA-1000) when they occur. Let me know if you would like a copy, and I'll email it privately to you - its too big to send to the list. Regards, Craig Munday. At 06:49 AM 1/10/2003 -0800, Stefan Jahnke wrote: Hi Just wondering: How did you implement the transparancy aspect ? Interceptor pattern (as in CORBA) ? Your tool seems to be a very good thing to use during dev-cycle to log certain aspects you're interested in (maybe log4j might do the job ?). Stefan -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel
AW: Experiences setting OPEN_CURSORS for Java applications
Hi Just wondering: How did you implement the transparancy aspect ? Interceptor pattern (as in CORBA) ? Your tool seems to be a very good thing to use during dev-cycle to log certain aspects you're interested in (maybe log4j might do the job ?). Stefan -Ursprüngliche Nachricht- Von: Craig Munday [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 1. Oktober 2003 02:44 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences setting OPEN_CURSORS for Java applications Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
Hi there, I've supported a number of systems implemented in Java running on Oracle and on nearly all of the projects the developers have asked me to increase the number of open_cursors. In most of the cases I have found that the developers were not using the JDBC API efficiently. The main problem being that Statement and ResultSet objects where never explicitly closed. If the developer does not close these objects explicitly, the garbage collector in the Java Virtual Machine will eventually close them. However the problem is that sometimes the garbage collector does not do this soon enough and you exhaust the number of open cursors you have allocated. Even the most diligent developer's sometimes make subtle mistakes like reassigning ResultSet variables and hence losing the reference to the original ResultSet, as I found out in JBoss4.0 DR2. I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. JDBC Expert installs like any other JDBC driver and does not generally require modifications to your application. The tool analyses how your application is using the JDBC API and reports various types of problems (such as resource leaks). I can send you a copy if you are interested - you will have to forward me your JDK version and details about any app server that you are using. Regards, Craig Munday. At 08:34 AM 26/09/2003 -0800, you wrote: I would just like to know what are your experiences setting OPEN_CURSORS for Java applications / middle-tier application servers ? We're rolling out a bunch of applications on WebMethods, Tivoli Identity Manager, Plumtree, Documentum etc --- all non-Oracle clients accessing the database through JDBC connections. The WebMethods consultant wanted me to set OPEN_CURSORS to 500. Plumtree also requries OPEN_CURSORS to 250 or so. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
Craig, CMI can send you a copy if you are interested - CMyou will have to forward me your JDK version and details about any app CMserver that you are using. I would , sure , be very much interested in having a copy of that tool. developers here use diff. versions of JDK apache/tomcat/jboss ... is it JDK version/app. server specific ? can JDBC Expert for JDK 1.4.1_03/jboss 3.2.1 used for JDK 1.4.1_03/apache 2.0.4 ?? Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Experiences setting OPEN_CURSORS for Java applications
Thanks for the answer. Yep, it seems more like JDBC proxy with analyzing capabilities than a regular traffic analyzer which sits aside sniffs some packets. May I ask, how much time have you spent on writing such thing? I'm planning to write something similar, but on SQL*Net level... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 3:44 AM Tanel, I've implemented it as a JDBC driver that is installed as a layer between your application and the vendor driver that you are using (eg. Oracle, Postgress, SQL Server, etc.) [Java application] - Layer 1 [JDBC Expert] - Layer 2 [Oracle Thin Driver] - Layer 3 | network | [Oracle Server] - Layer 4 It does not parse Java source code and is not a code analyzer, however the tool will intercept all calls that an application makes on the JDBC API, analyze them and forward them onto the vendor driver. In this way the tool is transparent to the application and can be installed or removed without modification to the application code. I would not call it a traffic analyzer because to me that term implies that it sits on a network and analyzes network traffic much like an Intrusion Detection System might do. Regards, Craig Munday. At 04:11 AM 30/09/2003 -0800, you wrote: I've encountered this problem so often that I decided to write a tool (called JDBC Expert) that would help us DBAs (and developers) detect Statement and ResultSet leaks in Java applications. I've found this tool so useful and effective at finding resource leaks that I insist any in house developed or third party Java applications are tested with it before we release them. Just interested, how have you implemented it? Is it a code or traffic analyzer? Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Experiences setting OPEN_CURSORS for Java applications
I would just like to know what are your experiences setting OPEN_CURSORS for Java applications / middle-tier application servers ? We're rolling out a bunch of applications on WebMethods, Tivoli Identity Manager, Plumtree, Documentum etc --- all non-Oracle clients accessing the database through JDBC connections. The WebMethods consultant wanted me to set OPEN_CURSORS to 500. Plumtree also requries OPEN_CURSORS to 250 or so. Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).