Oracle document is always a best source. http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/sqltrace.htm From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Orlando L Sent: Monday, January 14, 2008 10:21 PM To: oracle-l@xxxxxxxxxxxxx Subject: trcsess Hi, Is there any example or paper regarding the usage of trcsess to trace a process in a third party application in a multi tier evnironment. I read about the utility but I am not clear on how to find out all the information related to SQLs of one application process. The process we want to trace is started automatically after midnight, so setting trace automatically will be helpful. Orlando.