26ai Alert Log Size mustafakalayci, 2025-11-28 Hi, Oracle database writes alert logs into 2 different location with different file formats. To find diag alert location: select * from v$diag_info where name ='Diag Alert'; 1 select * from v$diag_info where name ='Diag Alert'; in this directory, you will find XML files for alert logs. Oracle always writes into log.xml file. Whenever it exceeds a certain threshold, log.xml file is renamed as log_2.xml. on… Continue Reading
V$DIAG_ALERT_EXT and equality conditions mustafakalayci, 2021-08-30 Hello, I don’t know if this is a bug but something small took my attention. Codes below are run on 19.8 and 19.12 versions. Lately, I was working on alert log messages and to do that I use V$DIAG_ALERT_EXT view which is a row by row representation of alert log… Continue Reading