ORA-02049 Timeout: Distributed Transaction Waiting for Lock
Hi,
Please move to the correct forum
Hoping someone can assist on this but since we moved to a newer version of a Oracle 10g database (v10.2.04), one of my reports (which is actually an Oracle ApEx report calling a package procedure that generates dynamic pl/sql) at intermittent times hits the following error:
ORA-02049 Timeout: Distributed Transaction Waiting for Lock
The strange thing, this never used to occur in previous database version (v10.2.02) and now users seems to be getting this error message.
FYI, there are no database links in this database and the package procedure is not writing to any tables, it is purely a select/read process.
Within one of the columns being queried though, there are number of records that have email addresses that look like abc@def.com
Now could this possibly cause issues thinking that maybe it thinks it's a database link? Again, this data was the same in the previous version and never had any issues with regards to this error message.
Any help on this, would be much appreciated.
Thanks.
Tony.
Edited by: Tony F. on Aug 30, 2010 10:36 AM