Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback space

Re: rollback space

From: <manish.nevrekar_at_gmail.com>
Date: 2 Feb 2005 10:39:43 -0800
Message-ID: <1107369583.318529.264990@z14g2000cwz.googlegroups.com>

  1. Each row has 10 columns. Approximately 70 B each row.
  2. No lobs 3)No other transactions are running, this is a batch load, any other transaction if running at all is select.
  3. there are no on isert triggers on the table.

I beg to differ on commiting after every 'x' rows. I always prefer to commit once at the end of the transaction. Commiting often is definitely more work plus there is always the chance of the dreaded ORA-01555 "Snapshot too old" error.
In my ETL procedures every insert and update is time stamped and hence it can be identified.
Thanks
Manish Received on Wed Feb 02 2005 - 12:39:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US