trace oracle session with java application...
Hi All,
Can any one suggest me how to trace oracle session with Java application? I am using oracle 10g R2, and we are using java application.
A java application generally has a connection pool through with users are connected to a database,so when you try to trace a session the old way, using alter session set trace=true, every a time you will not only get actual trace of that user, for sometimes its true. In addition user/session might switch from one connection to a different connection i.e. your sesssion Id will not fixes for a considerable amount of time, your session is internally switch.
Can anyone suggest me the convienet method like setting some client_identifier or etc.
Thanks..