Q:

enabling sql trace for a binary executable

I have an executable that connects to Oracle and executes some sql.  I want to enable tracing for this executable.  Usually we put alter session sstatement to enable trace but the session is created inside the executable.  How to enable trace for this? 

A:

one option if you cannot change the executable / its calling SQL is to create a logon trigger that sets tracing on.  Then have the executable connect to the db and it should start tracing out.