Re: Blocker did not identified

Is this a RAC database? You'll need to look also at the instance and blocking_status columns in v$session to rely on the blocking_session column in v$session.
https://docs.oracle.com/database/121/REFRN/GUID-28E2DC75-E157-4C0A-94AB-117C205789B9.htm#REFRN30223 IIRC EM12c also is not RAC aware in its blocking sessions page.

On Sat, Dec 30, 2017 at 3:07 AM, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:

> ​​​Hello,
>
> I got an issue related to lock.
> Now the daabase was re-started and the issue is solved.
> But during investigation I did not get sucess to identify who were locking
> a table.
>
> A table is used like this:
>
> SELECT ID FROM TABLE_BLA
> where id = :1
> for upate;
>
> The query did not return the result and looking for lock using this query :
>
> select s.sid, s.blocking_session, do.object_name,
> row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#,
> dbms_rowid.rowid_create ( 1, ROW_WAIT_OBJ#, ROW_WAIT_FILE#,
> ROW_WAIT_BLOCK#, ROW_WAIT_ROW# )
> from v$session s, dba_objects do
> where s.ROW_WAIT_OBJ# = do.OBJECT_ID
>
> I saw the row_wait_obj#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK# and ROW_WAIT_ROW#
> values.
>
> In this situation how can I find the blocker?
> or
> I used a lot of queries that show blocker and locked but without sucess to
> see the blocker.
>
> Regards
> Eriovaldo
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l