many local sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: many local sessions

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Hi guys!
    I don't understand how to avoid that error. Could you help me please. Of course I can read 'Action' but I have no idea what to do exactly.
    Thank you

    -----------------------------
    ORA-02045 too many local sessions participating in global transaction
    Cause: There are too many sessions at this site to accommodate this transaction.
    Action: Use an existing database link so that another session need not be created at the remote site.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Make changes to these parameters in your init.ora file. BTW what is your oracle version? Always include the version of ORACLE AND THE OS

    MAX_TRANSACTION_BRANCHES = 32
    open_links = 100
    distributed_transactions= 100

    These changes require a bounce on the instance.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Sorry,
    Oracle 8.17, RedHat 6.2
    Thank you

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    As I can see this parameter MAX_TRANSACTION_BRANCHES initialization parameter has been made obsolete,
    so I have to use this one
    _MAX_TRANSACTION_BRANCHES = 32
    Thank you

  5. #5
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    MAX_TRANSACTION_BRANCHES = 32
    is obsolete if the oracle is 8.1.6 or higher
    sonofsita
    http://www.ordba.net

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