Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Reads Block Writes?
I know that a "select for update" will lock rows and block an update
statement, but is it possible for a simple select to block an update of
the same table? Using a "lockby" script, it appears to be the case that
a long running select is blocking an update, but I didn't think that
this would happen.
Thanks for any replies.
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Mon Jun 03 2002 - 07:33:02 CDT
![]() |
![]() |