Database Tuning (MOSC)

MOSC Banner

A select causing "blocking locks"?

edited Sep 8, 2010 8:01AM in Database Tuning (MOSC) 11 commentsAnswered ✓
 I want to know whyt this select is blocking an update session?
From user1:

SELECT   NVL (supplement_type, 0)
  FROM   serv_req
 WHERE   document_number = '710539';

From user2:

UPDATE   "ASAP"."SERV_REQ"
   SET   "SERVICE_REQUEST_STATUS" = '901',
         "ORDER_COMPL_DT" = SYSDATE,
         "LAST_MODIFIED_USERID" = :b2,
         "LAST_MODIFIED_DATE" = SYSDATE
 WHERE   "DOCUMENT_NUMBER" = :b1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center