RE: SQL trace for connections coming in for a database service

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "dd.yakkali@xxxxxxxxx" <dd.yakkali@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 17 Jul 2009 17:15:26 +0200


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 => 


Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82

-----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 RAC db with CRS & ASM on Sun Solaris 10

any help is highly appreciated.



Other related posts: