oracle 18c alert 日志提示Resize Operation Completed For File#

zuozhiji

于 2022-04-19 14:00:26 发布

阅读量810

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE 18c 文章标签： database

本文链接：https://blog.csdn.net/jolly10/article/details/124272101

ORACLE 18c 专栏收录该内容

9 篇文章

订阅专栏

Oracle数据库在处理大量DML操作时，可能会频繁触发文件扩展，导致alert日志中充斥大量类似消息。这些消息源于18603375号未公开bug的诊断增强，用于记录数据文件的自动扩展情况。为避免日志被淹没，引入了一个新的隐藏参数_disable_file_resize_logging，设置为TRUE即可阻止这些消息记录在alert日志中。此解决方案适用于12.1.0.2及以上版本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

File Extension Messages are seen in alert log.There was no explicit file resize DDL as well.

Resize operation completed for file# 45, old size 26M, new size 28M
Resize operation completed for file# 45, old size 28M, new size 30M
Resize operation completed for file# 45, old size 30M, new size 32M
Resize operation completed for file# 36, old size 24M, new size 26M

In a busy system with lots of DML (insert/update/delete),the alert log could be flooded with many such file extension messages.

CHANGES

CAUSE

These file extension messages were result of diagnostic enhancement through unpublished to record automatic datafile resize operations in the alert log with a message of the form:

"File NN has auto extended from x bytes to y bytes"

This can be useful when diagnosing problems which may be impacted by a file resize.

SOLUTION

In busy systems, the alert log could be completely flooded with file extension messages. A new Hidden parameter parameter "_disable_file_resize_logging" has been introduced through bug 18603375 to stop these messages getting logged into alert log.

(Unpublished) Bug 18603375 - EXCESSIVE FILE EXTENSION MESSAGE IN ALERT LOG

Set the below parameter along with the fix.

SQL> alter system set "_disable_file_resize_logging"=TRUE ; (Its default value is FALSE)

The bug fix 18603375 is included in 12.1.0.2 onwards.