Managing Alert Log Size in Oracle AI Database 26ai

Starting with Oracle AI Database 26ai (Release Update 23.9), it is possible to control the maximum size of the alert log using the ALERT_LOG_MAX_SIZE parameter. The default value for this parameter is 1000 MB, which means the XML alert log can grow up to a maximum of 20 segments, each 50 MB in size. In my test, I configured the alert log maximum size to 100 MB: SQL> ALTER SYSTEM SET alert_log_max_size = 100M; System altered. ***This parameter is modifiable using ALTER SYSTEM, but it is not modifiable at the PDB level. To increase the size of the alert log and force file generation, I executed the following PL/SQL block to continuously write messages into the alert log: begin for i in 1 .. 1000000 loop begin sys.dbms_system.ksdwrt(2, 'Vahid Yousefzadeh'); end; end loop; end; / After running this block, there are several XML files in the alert directory and each file size is approximately 50MB. [root@OEL9-DB2 alert]# ls -lh -rw-r----- 1 oracle oinstall 51M Feb 23 11:57 log_20.xml -rw-r--