RE: 4031 - errors
- From: "Duret, Kathy" <kduret@xxxxxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Jun 2004 15:40:41 -0500
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@xxxxxxxxxxxx]
Sent: Monday, June 07, 2004 3:22 PM
To: oracle-l@xxxxxxxxxxxxx
Cc: kduret@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, June 02, 2004 5:04 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: 4031 - errors
OK - here are some things that contributed to my problems and woes:
1) 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)
2) .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.
3) 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.....
4) 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
