| Performance issue for distributed transaction (2PC) [message #483976] |
Fri, 26 November 2010 02:17 |
samg4ug
Messages: 33
Registered: July 2007
Location: India
|
Member |
|
|
Hi,
Getting the following for error message :
Fri Nov 26 12:32:06 2010
Error 2068 trapped in 2PC on transaction 72.38.169218. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from DBSID
ORA-01012: not logged on
Fri Nov 26 12:32:18 2010
Error 2068 trapped in 2PC on transaction 52.45.226946. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from DBSID
ORA-01012: not logged on
Fri Nov 26 12:33:39 2010
Error 2068 trapped in 2PC on transaction 75.34.156158. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from DBSID
ORA-01012: not logged on
Fri Nov 26 12:35:42 2010
Error 2068 trapped in 2PC on transaction 33.33.441336. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from DBSID
ORA-01012: not logged on
Fri Nov 26 12:37:37 2010
Error 2068 trapped in 2PC on transaction 61.26.187821. Cleaning up.
Error stack returned to user:
ORA-02068: following severe error from DBSID
ORA-01012: not logged on
Fri Nov 26 12:40:02 2010
This error is common for many databases we work with that have distributed transaction. But for last 2 days during this error the database hangs out and memory consumption goes high as 100%. Database performance degrades drastically. Even application connection is not possible until the issue is resolved by oracle automatically. Please suggest.
Regards,
Sam G
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
