Generate trace on a user processes on every login
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 29 Jun 2006 18:45:04 +0100
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
Other related posts:
