Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simultaneous INSERTs - one of them "hangs"

Simultaneous INSERTs - one of them "hangs"

From: Francis Small <fthes_at_sr.hp.com>
Date: 1997/11/25
Message-ID: <65d5ua$q2p@canyon.sr.hp.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US