SQL Tracing by default

[SMS636]

Quick questions.
How can i turn on SQL Tracing by default for newly connected session.

New session is running a command with-in a second once getting connected.

After the connection if i turn the tracing on it will be upto no avail as i cannot capture the issue.

Can someone help, how to enabled SQL TRACING by default for new specific connection from a machine let say T1 using uname scott.

Regards

 

[LKBrwnDBA]

You could create a 'DATABASE EVENT' trigger, kind like:

Create Trigger Set_Trace_On_T1
After LOGON On Database
Begin
  If SYS_CONTEXT('USERENV', 'SESSION_USER') = 'SCOTT' And
     SYS_CONTEXT('USERENV', 'TERMINAL')     = 'T1'   Then
    Execute Immediate 'ALTER SESSION SET SQL_TRACE = TRUE';
  End If;
End;

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SMS636]

Thanks, I guess this will do it.