OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Autocommit

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

Autocommit [message #57559]

Mon, 23 June 2003 06:45

Jörg Schenke
Messages: 2
Registered: June 2003

Junior Member

how can i set autocommit=off at the start of the server? we often have line-problems and the the autocommit at disconnect then commits an not completet transaction.

Report message to a moderator

Re: Autocommit [message #57567 is a reply to message #57559]

Mon, 23 June 2003 10:37

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

set autocommit off

is an sql*plus command.
so set this to your clients
$ORACLE_HOME/sqlplus/admin/glogin.sql

the file is read by every SQL*PLUS SESSION only.
and autocommit is set to that session only.

Report message to a moderator

Re: Autocommit [message #57597 is a reply to message #57567]

Wed, 25 June 2003 03:18

Jörg Schenke
Messages: 2
Registered: June 2003

Junior Member

i need it for the whole instance. can i switch it in the init.ora?

Report message to a moderator

Previous Topic:	fsck on disk with oracle
Next Topic:	Practical document about Oracle on Solaris?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:44:41 CDT 2024