Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: OS user and select-statements

Re: OS user and select-statements

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 6 Nov 2001 14:41:17 -0000
Message-ID: <3be7f68e$0$236$ed9e5944@reading.news.pipex.net>


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

> 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.
Received on Tue Nov 06 2001 - 08:41:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US