Re: OS user and select-statements

Sissel wrote:
>
> 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.

I think you should look at v$session and match this to v$sqlarea and/or v$sqltext.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.