【Oracle】alert.log 出现 Resize Operation Completed For File# (Doc ID 1982901.1)-CSDN博客

本文链接：https://blog.csdn.net/weixin_43346403/article/details/136552836

本文分析了Oracle数据库中alert.log中的文件扩展操作记录，尤其是在12.1.0.2版本之后，这些记录可用于诊断系统繁忙时的文件扩展情况。同时，提供了通过altersystem命令控制此类日志输出的方法。

摘要由CSDN通过智能技术生成

1.alert.log日志内容如下

XQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 252928K, new size 253952K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 253952K, new size 254976K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 254976K, new size 256000K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 256000K, new size 257024K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 257024K, new size 258048K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 258048K, new size 259072K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 259072K, new size 260096K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 260096K, new size 261120K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 261120K, new size 262144K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 262144K, new size 263168K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 263168K, new size 264192K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 264192K, new size 265216K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 265216K, new size 266240K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 266240K, new size 267264K
2024-03-07T18:22:20.265933+08:00
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 267264K, new size 268288K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 268288K, new size 269312K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 269312K, new size 270336K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 270336K, new size 271360K
FXQPDB(3):Resize operation completed for file# 203, fname /chac/app/oracle/oradata/FXQ/FXQPDB/temp01.dbf, old size 271360K, new size 272384K

2.原因分析

Oracle 12.1.0.2 版本及以后,出现该信息,可以用于DML的诊断,例如系统繁忙时可以明显看到文件的扩展情况。

3.通过隐含参数控制

--(Its default value is FALSE)
--禁用这类日志输出。
alter system set "_disable_file_resize_logging"=TRUE ;