On Tue, Mar 17, 2009 at 12:45 AM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote: > I plan on activating sys 10046 trace, to find a problem that occurs late at > night. > ... > You've probably already considered this, but thought I would ask anyway. If you know which account is having issues, can you just enable trace via logon trigger? The trigger could have some code to only work between certain times, and/or to only be activated a configurable number of times. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist