Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: autocommit ON but no commits visible in v$sqlarea
I'm actually trying to understand what exactly is happening in the OCI
application and in the database when a statement is executed in
autocommit mode.
Same thing using SQL+. If I first issue a 'set autocommit on' statement and then insert some_value into some_table, the response from sql+ is 'Commit completed'. However, the commit statement is not visible (that's why I called it a 'low level commit'). I'm not trying to accomplish anything, I just don't understand the autocommit mechanism.
Hans Received on Tue Jan 07 2003 - 07:59:56 CST