Automatic Undo Management
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Automatic Undo Management

  1. #1
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203

    Hey peps... ran across something today. I'm in the process of migrating Database 8.0.6 to Oracle 9.2 at the moment, and am implementing AUM, but I was alarmed by some tests I had performed, especially in a DSS enviorment and was wondering if others had similar experience.

    In 8.0.6 I had some procedures that ran with "SET TRANSACTION USE ROLLBACK...", and they ran pretty quickly, now I've migrating it, and commenting out the "SET TRANSACTION...", the process runs somewhat slower.

    Has anyone noticed BATCH processes running slower under AUM rather than MUM?

    Just curious..

    OCP 8i, 9i DBA
    Brisbane Australia

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Oracle has to calculate the amount of transaction and select the right RBS. This automation itself has some overhead (calculating the size of transaction and allotting the righ RBS). I allways believe in manual settings for planned batch operations. Automated settings are usefull for OLTP kind of environment.

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