一、oracle环境中总出现Resize operation completed

Resize operation completed for file# 201, old size 208896K, new size 209920K
Resize operation completed for file# 201, old size 209920K, new size 210944K
Resize operation completed for file# 201, old size 210944K, new size 211968K
Resize operation completed for file# 201, old size 211968K, new size 212992K
Resize operation completed for file# 201, old size 212992K, new size 214016K
Resize operation completed for file# 201, old size 214016K, new size 215040K

1-查看含resize的隐含参数

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 upper(a.ksppinm) LIKE upper('%&param%')
order by NAME;

可以发现_disable_file_resize_logging参数默认值为false,表示显示文件resize的提示,设置为true应该就可以解决该问题.

2-需要修改参数值：

alter system set "_disable_file_resize_logging"=TRUE;

重启数据库生效。