Re: Initialization parameter transactions_per_rollback_segment, can you set this?

  • From: sol beach <sol.beach@xxxxxxxxx>
  • To: ArnoldS@xxxxxxxx
  • Date: Tue, 16 Aug 2005 07:58:46 -0700

On 8/16/05, Arnold, Sandra <ArnoldS@xxxxxxxx> wrote:
[...snip...]
>   
> 
> I am getting snapshot too old errors for a transaction that is committing
> after each record is inserted or updated.

Do NOT commit after each record.
COMMIT once at the end
--
//www.freelists.org/webpage/oracle-l

Other related posts: