Hi, With dbms_monitor this is very simple to do. Following example will enable tracing with waits and bind information for all sessions connecting with a specific service_name: exec dbms_monitor.serv_mod_act_trace_enable(service_name => 'service_name', waits => TRUE, binds => true); to disable tracing: dbms_monitor.serv_mod_act_trace_disable(service_name => 'service_name'); regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dd yakkali Sent: vrijdag 17 juli 2009 17:01 To: oracle-l@xxxxxxxxxxxxx Subject: SQL trace for connections coming in for a database service Hello all, I have an application which connects to the database using the database service called "ssi". Is there any way to do a sql trace for any connections coming in with that service name. I do not want to turn on sql tracing on the whole database as there are so many applications running on it and finding the right trace file is tough. oracle 10.2.0.4 RAC db with 11.1.0.6 CRS & 11.1.0.6 ASM on Sun Solaris 10 any help is highly appreciated. Thanks Deen -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l