Xref: alice comp.databases.oracle.server:39567
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newspeer.monmouth.com!worldfeed.news.gte.net!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!darkstar
From: hsiao@saturn.sdsu.edu (Yang-Cheng Hsiao)
Newsgroups: comp.databases.oracle.server
Subject: Default Timeout on Unavailable Resource?
Date: Tue, 02 Feb 99 17:15:35 GMT
X-ELN-Insert-Date: Tue Feb  2 09:05:28 1999
X-Newsreader: News Xpress 2.0 Beta #0
Organization: SDSU
X-Posted-Path-Was: darkstar
Lines: 12
X-ELN-Date: 2 Feb 1999 17:03:06 GMT
Message-ID: <797b4a$bs$1@oak.prod.itd.earthlink.net>

Hi:

I am wondering if there is a default timeout in Oracle on unavailable 
resource? If yes, is the timeout period configurable and how?

If we have to let two tasks update the same tables, how do we prevent one of 
the task from waiting on the table forever if this table has been updated by 
another task but not yet committed?

I am looking forward to your advice. Please email me. Thanks!!

 -Yang-Cheng