Re: Table Locked by Who

Do the following query

    select a.username,b.sqltext from v$session a, v$sqltext b

             where a.sql_hash_value = b.hash_value.

This query will return is who is accessing that table.

Hope this helps

Harshan

Rayfil Cheung wrote:

> Hi,
>
> How can I check a table is locked or used by others. Thank you.
  Received on Wed Oct 18 2000 - 10:18:18 CDT