Re: 10046 trace and alert log destination full
Date: Wed, 18 Mar 2009 11:39:32 +0200
To tell the truth, I did not think of login trigger and now I realized that I could create 2 jobs, one to activate and one to stop the trace.
That is why I am on the list, to learn and get help from all you good people.
Jared Still wrote:
> On Tue, Mar 17, 2009 at 12:45 AM, Yechiel Adar <adar666_at_inter.net.il
> <mailto:adar666_at_inter.net.il>> 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