SQL trace for connections coming in for a database service
Date: Fri, 17 Jul 2009 11:00:45 -0400
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 22.214.171.124 CRS & 126.96.36.199 ASM on Sun Solaris 10
any help is highly appreciated.