Re: Monitoring alert log

Hi Nenad,

We use V$DIAG_ALERT_EXT in Zabbix. Previously we used x$dbgalertext, then we used some tricks like `with pre as (select /*+ materialize */` when we started using V$DIAG_ALERT_EXT to avoid different bugs in it.

On Wed, Dec 16, 2020 at 7:18 PM Noveljic Nenad <nenad.noveljic_at_vontobel.com> wrote:

> This is the question for those who monitor alert log with their own
> script. (We don't like OEM.)
>
>
>
> How do you monitor it: by querying V$DIAG_ALERT_EXT or parsing the adrci
> output?
>
> Do you see any clear advantages or pitfalls with one or the other?
>
>
>
> We wrote a script based on adrci 10 years ago, which has worked well.
> Then, we instantly eliminated the V$DIAG_ALERT_EXT approach because older
> database versions where throwing ORA-00600. Now, as we have to rewrite the
> script, we would like to evaluate both options again. By the way, the
> reason for rewriting is the transition from Perl_at_Solaris to Python_at_Linux.
>
> Thanks,
>
>
>
> Nenad
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l