Resize Operation Completed For File# 201; FILE# Does Not Exist

Alert log will contain following entries

Resize Operation Completed For File# 201; FILE# Does Not Exist

This is tempfiles and its number is generated dynamically based on parameter db_files – default value 200. This occurs in DB version 12c only.

How ever these messages are for information only and we can disable them using below parameter.

alter system set “_disable_file_resize_logging”=TRUE ;

  • December 28, 2017 | 16 views
  • Comments