Re: table accesing

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."

HTH -g Received on Wed Dec 17 2008 - 06:29:44 CST