Hi, Vladimir
You can made a join between the table in question and v$session:
select a.*
from table_xx a, v$session s
where
dbms_rowid.ROWID_ROW_NUMBER(a.rowid)=s.ROW_WAIT_ROW#
and dbms_rowid.ROWID_BLOCK_NUMBER(a.rowid)=s.ROW_WAIT_BLOCK#
and dbms_rowid.ROWID_RELATIVE_FNO(a.rowid)=s.ROW_WAIT_FILE#
and s.sid=&sid
;
Mario.
Por favor, responda a [EMAIL PROTECTED]
Enviado por: [EMAIL PROTECTED]
Destinatarios: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
CC:
Asunto: Locked rows - finding out
Clasificaci�n:
Hello listers
By quering V$LOCK or V$LOCKED_OBJECT I may find which tables are locked.
How do I see rowids of rows that are locked? And how do I see into what
rollback segment is being used by transaction that placed locks on those
rows?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vladimir Barac - posao
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Http://www.telecom.com.ar
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario J Gonzalez
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
