Re: trace sql without session_id and serial#

Giganews Newsgroups
Subject: Re: trace sql without session_id and serial#
Posted by:  Laurenz Albe (invite@spam.to.invalid)
Date: 26 Jul 2007

Steve Robin <ocmam…@gmail.com> wrote:
> My current database so many users are connected. SQL trace is off. I
> need to trace a developer session. I just have osname and username.
> Session is not connected right now. As soon as he connects some sql
> fired from that session. I know how trace it after he connects I can
> see session info from v$session but without knowing session id and
> serial#, how can I trace with osuser and username only.
>
> I cann't restart database, because so many people are working on it.

You could turn on tracing for this session in a login trigger.

Yours,
Laurenz Albe

Replies

None

In response to

trace sql without session_id and serial# posted by Steve Robin on Thu, 26 Jul 2007