Re: table accesing
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 18 Dec 2008 00:14:10 +1100
Message-ID: <giatq4$seu$1@news.motzarella.org>
>
> According to this, http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1003.htm#i1398731:
>
> "V$ACCESS displays information about locks that are currently imposed
> on library cache objects."
Date: Thu, 18 Dec 2008 00:14:10 +1100
Message-ID: <giatq4$seu$1@news.motzarella.org>
gazzag wrote,on my timestamp of 17/12/2008 11:29 PM:
> On 17 Dec, 12:30, Noons <wizofo..._at_yahoo.com.au> wrote:
>> mehraj hussain wrote,on my timestamp of 17/12/2008 7:37 PM: >> >>> hi, i have table called employees.. >>> many users are accescing this table at a time .. how can i find which >>> users is accesing that table presently... >> back in the old days, v$access had that info. >> Dunno if it's still usable
>
> According to this, http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1003.htm#i1398731:
>
> "V$ACCESS displays information about locks that are currently imposed
> on library cache objects."
Exactly. Check its definition. Use it to fish out which tables are in use. It shows the SID, owner, name and type of object, which is what the OP asked for. With the SID the session can be found, and then the user. Received on Wed Dec 17 2008 - 07:14:10 CST