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

最新推荐文章于 2026-04-03 14:21:10 发布

原创最新推荐文章于 2026-04-03 14:21:10 发布 · 758 阅读

11 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#oracle #数据库

数据库运维-Oracle-常规故障专栏收录该内容

90 篇文章

订阅专栏

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

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 ;