cost of distributed_transactions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: cost of distributed_transactions

  1. #1
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    We are having problems with distributed transactions, receiving a message that there are too many distributed transactions resulting in a failure.

    One idea is to single thread the distributed transactions. They are driven by one process. This could be done in the Perl scripts that control them.

    Another idea is to increase the distributed_transactions initialization parameter. But I don't know the impact of doing this in terms of memory consumption or other resource consumption.

    Does anyone know the "cost" or impact of increasing this parameter?

    TIA
    David Knight
    OCP DBA 8i, 9i, 10g

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What is it set for now? I think it is safe to increase it. The only restriction is that the value of distributed_transactions cannot exceed the value of transactions.

  3. #3
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    But does it consume more memory? We are short of memory now.
    David Knight
    OCP DBA 8i, 9i, 10g

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