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?