Re: Help with ORA-01000 Error
From: StrangeCat_at_Work <strange_at_cat.com>
Date: Tue, 18 Jun 2013 09:37:53 +0200
Message-ID: <51c00e56$0$1366$4fafbaef_at_reader1.news.tin.it>
>Yes default for open cursors is typically too low and should be set to
>something reasonable ( 750 / 900 fairly common ). Often no big issue
>going somewhat higher than that.
Date: Tue, 18 Jun 2013 09:37:53 +0200
Message-ID: <51c00e56$0$1366$4fafbaef_at_reader1.news.tin.it>
>Yes default for open cursors is typically too low and should be set to
>something reasonable ( 750 / 900 fairly common ). Often no big issue
>going somewhat higher than that.
>If this is running in a script of some kind doing an "alter session
>set cursor_sharing=FORCE" ( or an after logon database trigger to do
>that for these scripts ) could be an acceptable workaround.
>Creating an external table and doing "1 insert command" processing
>against the external table is also worth looking at.
>Something may be wrong with connection management
Thanx for your answer, as already said to joel problem was not disposing OledbCommand objects that kept stacking up open cursors at server side...
Thanx also for providing interesting info on forcing cursor sharing (Oracle newbie here :) ).
Bye
ASC
Received on Tue Jun 18 2013 - 09:37:53 CEST