Re: Rollback - How to avoid..
From: DMITRIYEV ANDREY <op8qc_at_qcunix1.acc.qc.edu>
Date: 14 Nov 1998 22:53:15 GMT
Message-ID: <72l1kr$li2$1_at_news.cuny.edu>
Date: 14 Nov 1998 22:53:15 GMT
Message-ID: <72l1kr$li2$1_at_news.cuny.edu>
Nisar Tareen (ntareen_at_attcanada.net) wrote:
: Ajit Deshpande
: >Is there a way to disable rollback ? I seem to be wasting a lot of time
: >in writing
: >PL/SQL scripts to update huge tables because the rollback segments would
: >fill up.
: No way,
: Only in some cases you can avoid writing in redo log.
: Such as Create with unrecoverable, and SQLLoader direct option.
: But for update no way, only suggestion is commit after few records so
: the rollback segement dose not get filled.
: Secondly, Refresh rollback segement according to your site need, if lot of
: processes fail, refresh every 4 hours or so...
: But not in UPDATE.... Rollback segemnt are must.
what about SET AUTOCOMMIT ON ?
Andrey Dmitriev www.qc.edu/~op8qc AOL: NetComrade AIM: NetComradeReceived on Sat Nov 14 1998 - 23:53:15 CET