distributed_lock_timeout

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: Thu, 03 May 2001 12:21:59 -0700
Message-ID: <F001.002F8F5C.20010503121838@fatcity.com>

Hello

 I need help on this.

 We have a Oracle 7.3.4 database and Oracle 8.1.6 database

 The application is as follows

 package in Oracle 8.1.6 calls package in Oracle 7.3.4  using Database link  

 Package in Oracle 7.3.4 does a lot of processing  but now
 sometimes Oracle 7.3.4 package gives distributed lock timeout error

 and sometimes Oracle 8.1.6 packages gives this error.

 This has made us wonder
 'what is happeneing'!

 Can someone help me with

1. understaning this phenomenon
2. in oracle 8.1.6 the parameter distributed_lock_timeout is obsolete and the users want to run this package is there someway of 'running' this
3. Is this type of processing ie calling package executing a lot of statements called package also executing a lot of statements and the final commit being back in the calling package the 'suggested' (recommended) way?

 isn't there a better way of doing this?  

 Thanks

---

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cyril Thankappan
  INET: cyril_thank_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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). Received on Thu May 03 2001 - 14:21:59 CDT