On Mar 21, 8:39 pm, "gazzag" <gar..._at_jamms.org> wrote:
> On 21 Mar, 15:12, "Steve Robin" <ocma..._at_gmail.com> wrote:
>
>
>
>
>
> > On Mar 21, 7:18 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
> > > Steve Robin 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.
>
> > > Depends on the version.
>
> > > dbms_monitor (10g)
> > > dbms_support (since 8.0.6)
> > > --
> > > Daniel A. Morgan
> > > University of Washington
> > > damor..._at_x.washington.edu
> > > (replace x with u to respond)
> > > Puget Sound Oracle Users Groupwww.psoug.org
>
> > Thanks for reply. But if there any other way to trace the sessions of
> > one osuser because I just have os username and database username.
> > Yes, I can see the sid from v$session, but I cann't because this user
> > connected from an front end application which open and close connect
> > of many times, with same username. If I use it I have to do it again
> > and again, which is not possible.- Hide quoted text -
>
> > - Show quoted text -
>
> Again, you might want to google this group for "logon trigger".
>
> Also,http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8...,
> for example.
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
thanks.
but how would I come to which session is under sql trace and which is
not. I want to stop it after a particular activity.
Received on Thu Mar 22 2007 - 00:10:33 CDT
