Thanks for your reply. We don't have a metalink account. Could you please send the note to me? My puzzle is that it seems the lock was acquired since all of records were inserted into the table. How did the error come from commit command?
Dave
From: "Arup Nanda" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: ORA-02049: timeout: distributed transaction waiting for lock Date: Tue, 21 Oct 2003 08:39:32 -0800
David,
Take a look at Note 19332.1, which explains the error and what to do next.
In short, the essence of the note is: The error comes if the time waited is
mor than the value of the distributed_lock_timeout parameter. Even if you do
a select from the remote database, it acquires a TX lock and that can wait.
Increase the value of the timeout or, just use an exception handler on the
commit statement to retry.
HTH.
Arup Nanda
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 11:49 AM
> Hi List,
>
> We have a job that copies data in a table on a remote database to a local
> database through a database link. Here are the steps in the job:
>
> 1. truncate the table of t1 on the local database
> 2. insert into t1 select * from [EMAIL PROTECTED]
> 3. commit
>
> There are only 847 records in the table. The job completes in 1 sec
> normally. However, last Sunday we got ORA-02049: timeout: distributed
> transaction waiting for lock during commit process. As my understanding,
> the error comes from a DML statement that requires locks on a remote
> database can be blocked if another transaction own locks on the requested
> data. I'm pretty sure that there were no any activities on the remote
> database since the application was not open. Also I can see from the log
> file (see below) that 847 records were inserted into the t1 table on the
> local database. The error was generated during the commit process. Does
> any one have any comments? Thanks for any input.
>
> Here is the job log file:
> 847 rows created.
>
> commit
> *
> ERROR at line 1:
> ORA-02049: timeout: distributed transaction waiting for lock
>
> We are in Oracle 8.1.7.4 and SunOS 5.8. We take the default value for
> DISTRIBUTED_LOCK_TIMEOUT .
>
> Dave
>
> _________________________________________________________________
> Get a FREE computer virus scan online from McAfee.
> http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: David Boyd
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_________________________________________________________________
Never get a busy signal because you are always connected with high-speed Internet access. Click here to comparison-shop providers. https://broadband.msn.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
