[Hint] Lock objects

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Thu, 01 Dec 2005 2:07 pm

There's a simple query that returns objects in lock on the bench.

Code: Select all
select vlo.session_id,
       vlo.oracle_username,
       vlo.os_user_name,
       ao.object_name,
       ao.object_type
  from sys.v_$locked_object vlo,
       sys.all_objects ao
where vlo.object_id = ao.object_id


:-o
anderson
Location: Toledo - PR

Anderson Nuernberg
---


Return to SQL

Who is online

Users browsing this forum: No registered users and 4 guests