OraFAQ Forum: Client Tools » Commit after each DML

Home » Other » Client Tools » Commit after each DML

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Commit after each DML [message #281986]

Tue, 20 November 2007 04:52

veerendranayak
Messages: 5
Registered: November 2007
Location: Pune

Junior Member

Hi Friends,

I would like to commit in my oracle session automatically after each inserts.

I cannot use Autocommit feature in SQLPLUS as it will become editor specific.

Also Can we parametrized such that we can control the commit interval. For example after 10 or 100 inserts automatically commit the data

Thanx in advance

Report message to a moderator

Re: Commit after each DML [message #281991 is a reply to message #281986]

Tue, 20 November 2007 05:32

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Transaction (and so commit and rollback) is an application notion: only the application knows when to commit or not.
So this feature can only be configured in the application.

Almost each language allows to configure this.

I strongly discourage to use an autocommit.
I don't see any application for which a statement is a transaction.

Regards
Michel

Report message to a moderator

Re: Commit after each DML [message #286595 is a reply to message #281986]

Sat, 08 December 2007 14:13

mchadder
Messages: 224
Registered: May 2005
Location: UK

Senior Member

Michel: I can tell you an application for statement = transaction.... DB's where writers block readers.... Wink

Report message to a moderator

Re: Commit after each DML [message #286596 is a reply to message #281986]

Sat, 08 December 2007 14:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Michel: I can tell you an application for statement = transaction.... DB's where writers block readers....
What does your statement have to do about/with Oracle; where that does not occur?

Report message to a moderator

Re: Commit after each DML [message #286597 is a reply to message #286596]

Sat, 08 December 2007 14:19

mchadder
Messages: 224
Registered: May 2005
Location: UK

Senior Member

anacedent : I take it you didn't appreciate the irony of my statement, nor did you see the smiley after the comment... oh well..

Report message to a moderator

Re: Commit after each DML [message #286598 is a reply to message #286595]

Sat, 08 December 2007 14:20

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This OraFAQ = Oracle FAQ's, not Sybase or MS/SQL Server forum.
Writers do not block readers.
Readers do not block writers.

By the way, if you have a DB that forces you to break the application transaction notion, run away.

Regards
Michel

Report message to a moderator

Re: Commit after each DML [message #286599 is a reply to message #281986]

Sat, 08 December 2007 14:23

mchadder
Messages: 224
Registered: May 2005
Location: UK

Senior Member

Listen guys... the smiley should have given it away... I actually was trying to be funny (obviously, unsuccessfully). I am well aware (having been in Oracle for over 10 years) that writers do not block readers etc. etc.

Next time, looks like i'll have to spell out any sarcasm in larger text... Wink

Report message to a moderator

Previous Topic:	character sets
Next Topic:	Inserts Chinese Characters using INSERT INTO doesn't work

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 00:51:09 CST 2025