oracle log user activity, from outside db machine?

hi there,

I need to log user activity of a large oracle 9i system under stress. Solaris based, database size is incredible. (sadly enough: the task is to log the full sql statements, with all data, of any user - its for debug purposes of some strange bugs in a distributed multiuser application) Thats why I expect it to happen, to enable audit or sql_trace would almost "kill" the performance. I have another large machine available which could do the logging - if only I knew: Is it possible to use something similar to sql_trace, but from outside the db-machine? Like a "man-in-the-middle" listener tool or something? Or could someone guide me to a calculation, how much performance down I'll have when enabling sql_trace on the full machine? Or maybe the "perfect" idea to do this logging and tracing, somewhere available? Thanks for any informations.

Bjoern Received on Sun Jul 11 2004 - 02:10:46 CDT