Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Thread Time Out (ORA-2049)
KK via OracleMonster.com wrote:
> We are facing a Time Out issue that has been puzzling us for the last couple weeks now. Here is the situation -
>
> A process (X) reads a row from table A and if the row is found, inserts a row in another Table B. If the row is not found, the process throws an exception. In case of exception, the process (X) rolls back the transaction.
>
> Another process (Y) comes in immediately after the process (X) and reads the same row as process (X) and then inserts another row in the Table B. But, here is the puzzling thing. When the process (X) cannot read the row in table A and throws exception, the process (Y) times out while reading the row in table A.
> There is a a window of about 500 milliseconds after process (X) finishes where any process that comes in and tries to read the same row from table A, times out.
>
> We are using entity beans to access the database and Websphere's wsOptimisticUpdate to read/write to the tables. wsOptimisticUpdate is closely equivalent to a 'committed read'.
>
> We also checked the 'distributed_lock_timeout' parameter in Oracle and it is set to the default - 60 seconds.
>
> We have explored many options, but haven't been able to figure out what is going on. Any help would be really appreciated.
This sounds like an application designed by someone whose background is Java and that didn't bother to invest any time in learning what a database is or how Oracle works.
If I am wrong I will help you. If I am correct please hand this over to someone that knows something about Oracle and promise them that you won't work in the database again until you know something about it.
And get rid of the bloody beans.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond) ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =---Received on Fri Jan 07 2005 - 00:33:47 CST