Re: Blocker did not identified

Niall,
The environment is not a RAC.
Regards
Eriovaldo

2017-12-30 8:04 GMT-02:00 Niall Litchfield <niall.litchfield_at_gmail.com>:

> 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