Resize operation completed for file#

jiawang

问题：
alter日志出现大量的如下信息：
2020-05-15T10:16:28.393812+08:00
Resize operation completed for file# 47, old size 28405760K, new size 28508160K
Resize operation completed for file# 47, old size 28508160K, new size 28610560K
Resize operation completed for file# 47, old size 28610560K, new size 28712960K
Resize operation completed for file# 47, old size 28712960K, new size 28815360K


环境说明：
OS: CentOS Linux release 7.8
DB:Oracle 19.3.0.0.0

问题分析：
数据文件自动扩展，当数据文件不足，自动执行扩展时，告警日志会打印这些信息；



解决方案：
Resize Operation Completed For File# 201; FILE# Does Not Exist ( 文档 ID 2246369.1)
启用 _disable_file_resize_logging ；


查询：
select a.ksppinm name , b.ksppstvl value , a.ksppdesc description
  from x$ksppi a , x$ksppcv b
  where a.inst_id = USERENV ( 'Instance' )
   and b.inst_id = USERENV ( 'Instance' )
   and a.indx = b.indx
   and a.ksppinm = '_disable_file_resize_logging'
  order by 1 ;



启用：
SQL> alter system set "_disable_file_resize_logging"=TRUE ;