本文发表在 rolia.net 枫下论坛Thread Status: Closed
From: Lawson Sharon 02-Nov-99 15:07
Subject: ORA-02045 Too many local sessions in global transaction
RDBMS Version:: 8.0.5
Operating System and Version:: mS windows nT 4.0 sp4
Error Number (if applicable):: ora-02045
Server Net Version:: sql net 2.3.4
Client Operating System and Version:: ms windows nt 4.0
Client Net Version:: net 80
ORA-02045 Too many local sessions in global transaction
I am getting a ora-02045 error . Too many sessions participating in global transaction error when
using dblinks ( I am using about 6 dblinks in one sql statement). Is there any parameter on the
server or client side which controls this parameter. please advice
Thanks
Sharath Adengada
s.adengada@worldnet.att.net
--------------------------------------------------------------------------------
From: Oracle, Rhoderick Butial 02-Nov-99 15:57
Subject: Re : ORA-02045 Too many local sessions in global transaction
Hello,
Error: ORA 2045
Text: too many local sessions participating in global transactions
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.
Set the related parameters in the init.ora (client):
MAX_TRANSACTION_BRANCHES= 32
open_links = 100
distributed_transactions= 100
Try this out and reply back with your progress.
Thank you,
Rod
Oracle Technical Support
--------------------------------------------------------------------------------
From: Lawson Sharon 02-Nov-99 17:35
Subject: Re : Re : ORA-02045 Too many local sessions in global transaction
Thanks!! It worked . Is there any load on the server by increasing the max_transaction_branches and the open_links.
--------------------------------------------------------------------------------
From: Oracle, Rhoderick Butial 04-Nov-99 14:53
Subject: Re : Re : Re : ORA-02045 Too many local sessions in global transaction
Hello,
Whenever you allow the number of concurrent transaction branches or open links, your available resources dwindles causing your system to be less efficient.
Thank you,
Rod
Oracle Technical Support
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.更多精彩文章及讨论,请光临枫下论坛 rolia.net
From: Lawson Sharon 02-Nov-99 15:07
Subject: ORA-02045 Too many local sessions in global transaction
RDBMS Version:: 8.0.5
Operating System and Version:: mS windows nT 4.0 sp4
Error Number (if applicable):: ora-02045
Server Net Version:: sql net 2.3.4
Client Operating System and Version:: ms windows nt 4.0
Client Net Version:: net 80
ORA-02045 Too many local sessions in global transaction
I am getting a ora-02045 error . Too many sessions participating in global transaction error when
using dblinks ( I am using about 6 dblinks in one sql statement). Is there any parameter on the
server or client side which controls this parameter. please advice
Thanks
Sharath Adengada
s.adengada@worldnet.att.net
--------------------------------------------------------------------------------
From: Oracle, Rhoderick Butial 02-Nov-99 15:57
Subject: Re : ORA-02045 Too many local sessions in global transaction
Hello,
Error: ORA 2045
Text: too many local sessions participating in global transactions
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.
Set the related parameters in the init.ora (client):
MAX_TRANSACTION_BRANCHES= 32
open_links = 100
distributed_transactions= 100
Try this out and reply back with your progress.
Thank you,
Rod
Oracle Technical Support
--------------------------------------------------------------------------------
From: Lawson Sharon 02-Nov-99 17:35
Subject: Re : Re : ORA-02045 Too many local sessions in global transaction
Thanks!! It worked . Is there any load on the server by increasing the max_transaction_branches and the open_links.
--------------------------------------------------------------------------------
From: Oracle, Rhoderick Butial 04-Nov-99 14:53
Subject: Re : Re : Re : ORA-02045 Too many local sessions in global transaction
Hello,
Whenever you allow the number of concurrent transaction branches or open links, your available resources dwindles causing your system to be less efficient.
Thank you,
Rod
Oracle Technical Support
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.更多精彩文章及讨论,请光临枫下论坛 rolia.net