Can a select block other queries?
hi experts.
I have this Blocking list but, I don't know why a select can block other sessions.
=====================================================
Block / Is blocked SID INST_ID OBJECT TIME(secs) ROWID CLIENT_IDENTIFIER
------------------------- --------- ------- ------------------------------ ---------- ------------
LTSADMIN 39 1 UNKNOWN 688
LTSADMIN 34 1 UNKNOWN 0
LTSADMIN 30 1 UNKNOWN 4
PL/SQL procedure successfully completed.
SID USERNAME COMMAND LOCKWAIT STATUS OSUSER
---------- ------------------------------ ---------- ---------------- -------- ---------------------
SQL_TEXT
----------------------------------------------------------------------------------------------------
34 LTSADMIN 0 070000006CB32980 ACTIVE oracle
BEGIN dbms_snapshot.refresh('LINECARD_S','F'); END;
SQL> /
Enter value for usrsid: 39
SID USERNAME COMMAND LOCKWAIT STATUS OSUSER
---------- ------------------------------ ---------- ---------------- -------- ---------------------
SQL_TEXT
----------------------------------------------------------------------------------------------------
39 LTSADMIN 3 ACTIVE oracle
SELECT /*+ remote_mapped(AAIS.WORLD) */ CURRENT$."LC_TELNUM",CURRENT$."LC_TWNCD",CURRENT$."LC_SWITCH