autocommit

[zainalj]

simple question,
If we put
SQL>set autocommit on

does it mean rollback segment won't be used?
does it commit just after insert/delete/update statement?

thanks



_____________________________________________
Why on earth OCP is to be proud.

[slimdave]

does it mean rollback segment won't be used?

No

does it commit just after insert/delete/update statement?

According to the documentation, yes. However DDL statements have an implicit commit. This includes TRUNCATE.

[zainalj]

thanks slimdave, meaning set autocommit on can be used for batch data loading where rollback segment/undo tbs will be used only for single transaction(cause it commit just after every single DML ). is that correct?

[slimdave]

I suppose so, but personally i never use it. I prefer issuing commits explicitly, as I think it aids supportability, and there's too many cases where i want multiple statements to commit or rollback together.

With External Tables available in 9i, I don't have a lot of use for SQL*Plus-based scripts -- I tend do do them in PL/SQL and schedule with DBMS_JOB.