Re: Table Locked by Who
From: harshan eppurath <harshane_at_yahoo.com>
Date: Wed, 18 Oct 2000 10:18:18 -0500
Message-ID: <39EDBF3A.4288EDFC_at_yahoo.com>
Date: Wed, 18 Oct 2000 10:18:18 -0500
Message-ID: <39EDBF3A.4288EDFC_at_yahoo.com>
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.