ST locks

[mhaller]

How can you determine if you have ST locks?

[sambavan]

     SELECT * FROM dba_locks
      WHERE lock_type IN ('ST');

or

         SELECT * FROM v$locked_object
         WHERE EXISTS ( SELECT session_id FROM dba_locks
                                                      WHERE    lock_type IN ('ST')
                                                           AND v$locked_object.session_id  = dba_locks.session_id);

Sam


[Edited by sambavan on 11-30-2001 at 02:44 PM]