Re: 10046 trace and alert log destination full
From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 17 Mar 2009 15:46:31 -0700
Message-ID: <bf46380903171546o18b07c95k3064afd80ed9d9ff_at_mail.gmail.com>
On Tue, Mar 17, 2009 at 12:45 AM, Yechiel Adar <adar666_at_inter.net.il> wrote:
Date: Tue, 17 Mar 2009 15:46:31 -0700
Message-ID: <bf46380903171546o18b07c95k3064afd80ed9d9ff_at_mail.gmail.com>
On Tue, Mar 17, 2009 at 12:45 AM, Yechiel Adar <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 Tue Mar 17 2009 - 17:46:31 CDT