ST locks

How can you determine if you have ST locks?

Code:

---


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

---

or

Code:

---


        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]