Re: records query of one username with osuser

From: gazzag <gareth_at_jamms.org>
Date: 21 Mar 2007 03:16:12 -0700
Message-ID: <1174472171.996060.189910@b75g2000hsg.googlegroups.com>

On 21 Mar, 04:02, "Steve Robin" <ocma..._at_gmail.com> wrote:
> Is there any other way than dbms_system.SET_SQL_TRACE_IN_SESSION,
> to record all the work of one session. Connection is been estabished
> by an application. Now as soon as application connects, it started
> executing queries.
> To do dbms_system.SET_SQL_TRACE_IN_SESSION tracing, session should be
> up to know sid and serial# but I have "osuser name" and "username".
> Now can I record all the queries from that user on that osuser.

The following query will get the sid and serial# for you for a particular session:

SELECT sid, serial#
FROM v$session
WHERE username='<username>' AND osuser='<osuser>';

Also, you might want to google this group for "logon trigger".

HTH -g Received on Wed Mar 21 2007 - 05:16:12 CDT