Help with my SQL trace in 10g

From: joe bayer <joebayerii(nospam)_at_hotmail.com>
Date: Sat, 27 Oct 2007 00:38:31 GMT
Message-ID: <bMvUi.250$%r.83@trnddc01>

I am a developer/junior DBA, hope all the experts here can help me out.

We have an third party software on 10.2.0.3, Linux.

From time to time, we have to do a SQL trace. As all the connection is from application server, all the login are the same username, and from v$session, client_identifier is null.

How should I enable a tracing in this kind of system, do I have to enable 10046 from instance level, bounce database every time? Any easier way?

Thanks very much for your help Received on Fri Oct 26 2007 - 19:38:31 CDT