Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2003
    Posts
    15

    Question Unanswered: sql*Plus disable rollback

    I have a rather large process and i want to disable the rollback segment so that, in theory, it runs faster. If something fails a rollback won't be necessary, just rerunning the stored procedure.

    Is there a way to turn off the rollback for a user or for the life of a procedure/function?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    NO, rollback cannot be disabled.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Oracle read-consistency models demands rollback segment. However, they are things you can do to actually improve rather large transactions (like making use of a large rollback segment, putting the objects in nolog mode, etc..).

  4. #4
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    You can minimise both undo and redo for some INSERTs using the APPEND hint and a nologging table (though make sure you either won't need that redo or you take a backup after the load). There is no equivalent for UPDATE or DELETE though. What does your process do?

  5. #5
    Join Date
    Apr 2003
    Posts
    15
    My process is basically comparing two tables (baseline and new file) and creating a new table based on the process results. Nothing too complex, but just a large chunk of data.

    I just implemented the 'nologging' and that seems to help. I'll try using the append and see if that helps any.

  6. #6
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    Keep this in mind:
    Code:
    Table Mode  Insert Mode   ArchiveLog mode     result
    ----------- ------------- ------------------- ----------
    LOGGING     APPEND        ARCHIVE LOG         redo generated
    NOLOGGING   APPEND        ARCHIVE LOG         no redo
    LOGGING     no append     ""                  redo generated
    NOLOGGING   no append     ""                  redo generated
    LOGGING     APPEND        noarchive log mode  no redo
    NOLOGGING   APPEND        noarchive log mode  no redo
    LOGGING     no append     noarchive log mode  redo generated
    NOLOGGING   no append     noarchive log mode  redo generated
    Find here the full article.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •