重庆思庄Oracle、Redhat认证学习论坛

标题: Resize operation completed for file# [打印本页]

作者: jiawang 时间: 2020-5-15 10:36
标题: Resize operation completed for file#
问题：
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 ;