Re: table accesing

On Dec 17, 5:24 pm, gazzag <gar..._at_jamms.org> wrote:
> On 17 Dec, 08:37, mehraj hussain <mhdmeh..._at_gmail.com> wrote:
>
> > 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...
>
> Not sure how, or why, you'd need to do this but I suspect the
> following views may help:
>
> V$SESSION
> V$SQL
> V$SQL_AREA
>
> HTH
>
> -g

i need to find a user who is accesing a temporarary table..

if iam droping that temporary table , iam getting the error.... Received on Thu Dec 18 2008 - 00:46:24 CST