Re: 10046 trace and alert log destination full

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • 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. 

Adar Yechiel
Rechovot, Israel



Jared Still wrote:
On Tue, Mar 17, 2009 at 12:45 AM, Yechiel Adar <adar666@xxxxxxxxxxxx <mailto: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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2009