Re: autocommit ON but no commits visible in v$sqlarea

hansdegit_at_hotmail.com (Hans de Git) writes:

> 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.
>

What about if you then log out of the sqlplus session - do the records appear then? I seem to remember seeing something which indicated in auto commit mode, the commit happens when you exit the session for sqlplus. Not sure about this, so try it and see.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!