autocommit behaviour

From: Nan <nandagopalj_at_hotmail.com>
Date: 14 Mar 2002 09:07:03 -0800
Message-ID: <8193246.0203140907.6267f247@posting.google.com>

Hello:

I am executing the following statement from sqlplus on Oracle V8

SET AUTOCOMMIT 15000;
delete from emp where join_dt < '20000101';

Would it be a true statement to say that the rollback segment grows only by 15000 rows, because of the autocommit being set to 15000 ?

I think that the autocommit is implemented by sqlplus in this case. It commits only after all rows (as per where clause) are deleted. So autocommit may not help to minimize the rollback segments from growing during a delete. Any info on this is appreciated.

Thanks,
Nan. Received on Thu Mar 14 2002 - 11:07:03 CST