RE: 4031 - errors

From: Duret, Kathy <kduret_at_starkinvestments.com>
Date: Mon, 7 Jun 2004 15:40:41 -0500
Message-ID: <07BA8175B092D611B1DE00B0D049A31501B0B8A4@exchange.ad.starkinvestments.com>

I found it on metalink by searching for dispose, I am not a .net programmer. We ran into an issue with cursors and this helped us originally with that issue (See the programmers notes are below). I noticed that our .net code was very slow to release resources. When the programmers added the dispose to some of our other .net code it help release resources back faster. We are using connection pooling with .net it seems very slow to release resources. There is also another note on Metalink where microsoft keeps the connections open (infinity) and there was some parameter to set to time out connections, note: 226260.1. I sent this to the programmers but they haven't checked or tested it yet or don't care.

Good luck.... Kathy

programmer Notes:
recently ran into an issue where I would run-out of database cursors causing an exception (Out of cursors).
This only occurred when a large amount of DB commands where issued very quickly.
Seems the garbage collection is unable to keep-up with the speed in which the program was running.

Also note: may or may not be an issue depending on DB configuration on cursor settings. Also this Issue has only been seen in Oracle, I have not seen this in Sql Server or other databases, though it probably exists. I have the same code running on Sql Server with-out any problems, but they have different load/settings characteristics.

Here is how I resolved the issue:

Call Dispose (forcing quicker disposal) on all DB request specific objects, when finished such as:

DB command objects:
OleDbCommand
SqlCommand

Data adapter objects:
OleDbDataAdapter
SqlDbDataAdapter

-----Original Message-----

From: Fedock, John (KAM.RHQ) [mailto:John.Fedock_at_us.kline.com] Sent: Monday, June 07, 2004 3:22 PM
To: oracle-l_at_freelists.org
Cc: kduret_at_starkinvestments.com
Subject: RE: 4031 - errors

Kathy,

Can you comment on #2 listed below (the dispose parameter). Where is it set at?

Thanks

John

-----Original Message-----

From: Duret, Kathy [mailto:kduret_at_starkinvestments.com] Sent: Wednesday, June 02, 2004 5:04 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: 4031 - errors

OK - here are some things that contributed to my problems and woes:

we set cursor_space_for_time = false - had been set to true for some prepared statements we were running this also gave us a bonus where it fixed leaks from update across db_links and heterogeneous services (not my idea ok, I lost the fight reminder to self to get bigger boxing gloves)
.net - set the dispose parameter..... release alot of resources, especially with cursors, has to do with the garbage collection there is also another parameter to adjust so connections for connection pooling don't hang on forever Apparently microsoft sets it to infinity...haven't played with it yet.
The other choke, gasp, dba had alot of dbms_outputs in procedure, functions except that he moved into production instead of commenting them out. one procedure that called another function which called another function, had more than 20 of these things. And yes same person who is updating across the links.....
I still have to look into the shared_pool_reserve and letting go there. I didn't want to change too many things at once... Didn't want to cause other problems.

I have some other issues to look into but this seems to have helped 80% of my problems. The other 20% well, let's just say I am encouraging him to find another position.......

Thanks to everyone for the help.

Kathy

This transmission contains information solely for intended recipient and may be privileged, confidential and/or otherwise protect from disclosure. If you are not the intended recipient, please contact the sender and delete all copies of this transmission. This message and/or the materials contained herein are not an offer to sell, or a solicitation of an offer to buy, any securities or other instruments. The information has been obtained or derived from sources believed by us to be reliable, but we do not represent that it is accurate or complete. Any opinions or estimates contained in this information constitute our judgment as of this date and are subject to change without notice. Any information you share with us will be used in the operation of our business, and we do not request and do not want any material, nonpublic information. Absent an express prior written agreement, we are not agreeing to treat any information confidentially and will use any and all information and reserve the right to publish or disclose any information you share with us.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon Jun 07 2004 - 15:40:30 CDT