Oracle 9i and Undo vs Rollback Segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 9i and Undo vs Rollback Segment

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Oracle 9i and Undo vs Rollback Segment

    We are in the process of migrating frok Oracle8i to 9i. When I went for my training, our instructor mentioned to us that only use Undo management if you are using a datawarehouse environment. If you have OLTP then just use regular rollback. What do you guys think? We have a Siebel environment thats high in transaction processing. should i try undo or stick with RBS.
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    undo all the way unless you really need to fine-tune you system and you can only do so by using rollback segs.

    Search for und on askton, he has a good discussion of them there

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    4
    Hi,
    Since u r working on an OLTP database - I would recommend u to use the automatic behaviour of undo segments present in 9i onwards. As this releives u from making new undo segments as and when required since Oracle automatically takes care of this feature.
    Thanx

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Oracle 9i and Undo vs Rollback Segment

    Originally posted by jlakhani
    We are in the process of migrating frok Oracle8i to 9i. When I went for my training, our instructor mentioned to us that only use Undo management if you are using a datawarehouse environment. If you have OLTP then just use regular rollback. What do you guys think? We have a Siebel environment thats high in transaction processing. should i try undo or stick with RBS.
    So finally Siebel supports 9i :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Jan 2004
    Location
    Bangalore, India
    Posts
    66
    Go ahead.. use the automatic undo management feature in Oracle 9i.
    We have been using it successfully, and especially for OLTP, it's best to have Oracle handle the undo. All the more easier for the DBA....

Posting Permissions

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


Click Here to Expand Forum to Full Width