SQL trace for connections coming in for a database service

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Fri, 17 Jul 2009 11:00:45 -0400
Message-ID: <1c8f76b90907170800paca08e9g7180e63557b54f22_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 17 2009 - 10:00:45 CDT

This message: [ Message body ]
Next message: D'Hooge Freek: "RE: SQL trace for connections coming in for a database service"
Previous message: John Dunn: "Oracle trigger to update mysql database"
Next in thread: D'Hooge Freek: "RE: SQL trace for connections coming in for a database service"
Reply: D'Hooge Freek: "RE: SQL trace for connections coming in for a database service"
Maybe reply: Allen, Brandon: "RE: SQL trace for connections coming in for a database service"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message