DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2001
    Brisbane, Queensland, Australia

    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
    Bangalore, India
    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