Re: 10046 trace and alert log destination full
Date: Wed, 18 Mar 2009 11:39:32 +0200
Message-id: <49C0C154.4030007_at_inter.net.il>
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.
Adar Yechiel
Rechovot, Israel
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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 18 2009 - 04:39:32 CDT