To: ora-apps-dba@xxxxxxxxxxxxx
From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
Sent by: ora-apps-dba-bounce@xxxxxxxxxxxxx
Date: 29-06-2006 20:45
Subject: Generate trace on a user processes on every login
Question:
I need to enable trace every time XYZ connected to the DB,Can anyone
help me on this.XYZ is a user.
I suppose there is some system profile which helps to perform the
above mentioned. Also please let me know where the trace file will be
generated by default.
Answer:
Set profile values for a user:
"Initialization SQL Statement - Custom"="
begin
sys.dbms_support.start_trace(true, true);
end;"
Just like that :),
Yury