Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Help:How do you trace in this application?

Re: Help:How do you trace in this application?

From: joel garry <>
Date: Tue, 18 Dec 2007 11:44:06 -0800 (PST)
Message-ID: <>

On Dec 17, 1:10 pm, Robert Klemme <> wrote:
> On 17.12.2007 21:44, wrote:
> > By one user, I meant no matter who loged into the application from the
> > web interface, from database end, I only see one user name, if I
> > select username from v$session, I got several app_user, with different
> > sid, from the same machine, which is the application server machine,
> > and same program, which wex.exe, and the same username, which is
> > app_user.
> > How could I trace it for a particular user, if they all login with the
> > same credential?
> In the worst case you simply have to trace all sessions of this user,
> make your "special" user execute the commands you are interested in and
> switch off tracing for all again. Then you only need to find the SQL in
> the trace files from this exercise. Granted you'll likely collect much
> more than you need but if you keep the time window small that might be
> feasible. All in all I haven't found a good way to collect properly
> scoped data in such a scenario. And the situation is even worse when
> there is a connection pool for DB connections...
> Kind regards
> robert

Note that you can use traceanalyser and other things, see metalink notes 279132.1 296559.1 224270.1 62294.1 1058210.6 etc.

The login trigger could play games with setting context to something unique to help winnow trace files.

Perhaps you can scope by identifying the session with some special user inquiry, then only turn on tracing for that session.

I guess it depends how cooperative your users are!

Pound on the vendor to have the app load up some program/terminal information.


-- is bogus.
"Real Men don't make backups. They upload it via ftp and let the world
mirror it." - Linus Torvalds
Received on Tue Dec 18 2007 - 13:44:06 CST

Original text of this message