[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,
  from sys.v_$locked_object vlo,
       sys.all_objects ao
where vlo.object_id = ao.object_id

Location: Toledo - PR

Anderson Nuernberg

Return to SQL

Who is online

Users browsing this forum: No registered users and 8 guests