OraFAQ Forum: SQL & PL/SQL » SET Autocommit XXXX

Home » SQL & PL/SQL » SQL & PL/SQL » SET Autocommit XXXX (oracle 11g Release 2, Linux)

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

SET Autocommit XXXX [message #626212]

Wed, 22 October 2014 14:36

azeem87
Messages: 116
Registered: September 2005
Location: dallas

Senior Member

Hi,

i agree that we are not in favour or recommend having a set autocommit on to maintain data consistency / rollback..
just a simple question on this.

SET Autocommit 50000
will it issue 1 commit after every 50000 rows or will commit after each and every DML 50000 times ?

Thanks and appreciate a reply on this.

Report message to a moderator

Re: SET Autocommit XXXX [message #626213 is a reply to message #626212]

Wed, 22 October 2014 14:40

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

First SET AUTOCOMMIT is a SQL*Plus command NOT a SQL one.
The link I provided mentions (for SET AUTOCOMMIT n):

Quote:

n commits pending changes to the database after Oracle Database executes n successful SQL INSERT, UPDATE, or DELETE commands, or PL/SQL blocks.

Report message to a moderator

Re: SET Autocommit XXXX [message #626214 is a reply to message #626213]

Wed, 22 October 2014 14:50

azeem87
Messages: 116
Registered: September 2005
Location: dallas

Senior Member

Thanks Michel

Report message to a moderator

Previous Topic:	FractionalAgents
Next Topic:	Insert Hangs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 18:40:30 CDT 2024