Re: Autocommit after 1000 transactions?

Chuck Hamilton (chuckh_at_ix.netcom.com) wrote:
: smullins_at_hilco.com (Sean Mullins) wrote:
 

: >I am having problems with my rollback segments filling up
: >continuously. Is there a way to have Oracle automatically commit
: >after a certain number of transactions have been executed?
 

: >-Sean
 

: Only by using PL/SQL and managing the commits yourself.

I don't know if the following is true for Oracle v.7 - it applies to v.6:

You may issue as many commit statements as you want inside a pl/sql programme. But the transaction(s) is/are only committed at exit from the programme.

Instead you could write a small PRO*C programme or use dynamic SQL to split your transaction(s) into on segments of the total affected rows.

: --
: Chuck Hamilton
: chuckh_at_ix.netcom.com
 

: Incoming fire has the right of way!

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+      Christian Mondrup                                                      +
+      UNI-C Aarhus, Danish Computing Centre for Research and Education.      +
+      Olof Palmes Alle 38, DK 8200 Aarhus N.                                 +
+                                                                             +
+      Phone:   +45 86 78 44 44                                               +
+      Telefax: +45 86 78 44 55                                               +
+      E-Mail:  Christian.Mondrup_at_uni-c.dk                                    +
+                                                                             +
+      Opinions expressed are mine and do not reflect those of my employer.   +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++