Category: 26ai

26ai Alert Log Size

Mustafa, 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…