Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Simultaneous INSERTs - one of them "hangs"
If two users insert two records with the same primary key into the same table, the "first" transaction will be accepted immediately but the second will "hang" until the first transaction either commits or rolls back.
Is there any recourse for the second transaction to somehow detect that it is waiting for another transaction either before or during the fact? I'm hoping for something like the NOWAIT clause of a SELECT ... FOR UPDATE statement, or the ability to set a global timeout duration on your DML statements. Any help would be appreciated. Thanks.
Francis Small
-- . . . . . . . . . | 1 . . . . . . . . . 2 . . . . . . . . . 3 . . . . . . . . Giants Francis Small - M/S M3RA Bums Hewlett-Packard Company Rockies Microwave Instruments Div. Padres 1212 Valley House Dr. Rohnert Park CA, 94928 707 794 3305 fthes_at_sr.hp.com ***************** Final 1997 National League West Standings *****************Received on Tue Nov 25 1997 - 00:00:00 CST
![]() |
![]() |