Re: View users SQL

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 19 Mar 2001 16:28:33 -0000
Message-ID: <995c3k$408$1@soap.pipex.net>

you can join v$sqltext to v$session to get this sort of info. If you have OEM then I believe there is GUI tool for the purpose too. "tom" <tompr_at_hotmail.com> wrote in message news:t8pt6.14275$br1.150463_at_sodalite.nbnet.nb.ca...
> Hi
>
> We are getting some users hung up in the DB regularly.
>
> Is there a way i can see what SQL they were running ?
>
> thanks
> tompr
>
> tomprREMOVE_REMOVE_at_hotmail.com
>
Received on Mon Mar 19 2001 - 10:28:33 CST