Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OS user and select-statements
Whilst the statement (I assume it is a long running problematical one) is
running join v$sqlarea to v$session.
-- Niall Litchfield Oracle DBA Audit Commission Uk "Sissel" <sissel_at_borgen.as> wrote in message news:c7d12b72.0111060627.75080e77_at_posting.google.com...Received on Tue Nov 06 2001 - 08:41:17 CST
> Hi.
> I'm looking for å way to see which OS user does which
> select-statements. I've tried TKPROF, but it didn't give me more than
> Oracle-user ( at least as far as I could figure it out ), and that's
> not enough.
> Maybe a trigger would help, but I don't know anything about making
> triggers.
>
> Thanks in advance.
![]() |
![]() |