Re: Table Locked by Who

From: Arie Mars <arie_at_pca-online.nl>
Date: Thu, 19 Oct 2000 08:50:07 +0200
Message-ID: <8sm5ji$dfla7$1_at_reader3.wxs.nl>


That would be B.SQL_TEXT instead of B.SQLTEXT

Arie Mars

harshan eppurath <harshane_at_yahoo.com> schreef in berichtnieuws 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.
>
Received on Thu Oct 19 2000 - 08:50:07 CEST

Original text of this message