RDBMS 12.2.0.1
今天在查看alert log的时候,发现了大量的Resize operation completed for file# 201 ......,记得之前把表空间已经扩的很大了,应该不存在这个问题。检查了下表空间,表空间不存在问题。也不存在201这个文件 。查看tempfile 发现空间也很充足,才用了4M,和日志中的 old size,newsize根本不匹配。是哪里的问题呢。
2019-05-04T14:54:11.982743+08:00
Resize operation completed for file# 201, old size 32768K, new size 33792K
Resize operation completed for file# 201, old size 33792K, new size 34816K
Resize operation completed for file# 201, old size 34816K, new size 35840K
Resize operation completed for file# 201, old size 35840K, new size 36864K
Resize operation completed for file# 201, old size 36864K, new size 37888K
Resize operation completed for file# 201, old size 37888K, new size 38912K
Resize operation completed for file# 201, old size 38912K, new size 39936K
Resize operation completed for file# 201, old size 39936K, new size 40960K
Resize operation completed for file# 201, old size 40960K, new size 41984K
Resize operation completed for file# 201, old size 41984K, new size 43008K
Resize operation completed for file# 201, old size 43008K, new size 44032K
Resize operation completed for file# 201, old size 44032K, new size 45056K
2019-05-04T14:54:13.050151+08:00
Resize operation completed for file# 201, old size 45056K, new size 46080K
Resize operation completed for file# 201, old size 46080K, new size 47104K
Resize operation completed for file# 201, old size 47104K, new size 48128K
Resize operation completed for file# 201, old size 48128K, new size 49152K
Resize operation completed for file# 201, old size 49152K, new size 50176K
Resize operation completed for file# 201, old size 50176K, new size 51200K
Resize operation completed for file# 201, old size 51200K, new size 52224K
Resize operation completed for file# 201, old size 52224K, new size 53248K
Resize operation completed for file# 201, old size 53248K, new size 54272K
Resize operation completed for file# 201, old size 54272K, new size 55296K
Resize operation completed for file# 201, old size 55296K, new size 56320K
Resize operation completed for file# 201, old size 56320K, new size 57344K
Resize operation completed for file# 201, old size 57344K, new size 58368K
Resize operation completed for file# 201, old size 58368K, new size 59392K
Resize operation completed for file# 201, old size 59392K, new size 60416K
Resize operation completed for file# 201, old size 60416K, new size 61440K
Resize operation completed for file# 201, old size 61440K, new size 62464K
Resize operation completed for file# 201, old size 62464K, new size 63488K
Resize operation completed for file# 201, old size 63488K, new size 64512K
Resize operation completed for file# 201, old size 64512K, new size 65536K
Resize operation completed for file# 201, old size 65536K, new size 66560K
Resize operation completed for file# 201, old size 66560K, new size 67584K
Resize operation completed for file# 201, old size 67584K, new size 68608K
Resize operation completed for file# 201, old size 68608K, new size 69632K
Resize operation completed for file# 201, old size 69632K, new size 70656K
2019-05-04T14:54:14.056344+08:00
Resize operation completed for file# 201, old size 70656K, new size 71680K
Resize operation completed for file# 201, old size 71680K, new size 72704K
Resize operation completed for file# 201, old size 72704K, new size 73728K
Resize operation completed for file# 201, old size 73728K, new size 74752K
Resize operation completed for file# 201, old size 74752K, new size 75776K
Resize operation completed for file# 201, old size 75776K, new size 76800K
Resize operation completed for file# 201, old size 76800K, new size 77824K
Resize operation completed for file# 201, old size 77824K, new size 78848K
Resize operation completed for file# 201, old size 78848K, new size 79872K
Resize operation completed for file# 201, old size 79872K, new size 80896K
Resize operation completed for file# 201, old size 80896K, new size 81920K
Resize operation completed for file# 201, old size 81920K, new size 82944K
Resize operation completed for file# 201, old size 82944K, new size 83968K
Resize operation completed for file# 201, old size 83968K, new size 84992K
Resize operation completed for file# 201, old size 84992K, new size 86016K
Resize operation completed for file# 201, old size 86016K, new size 87040K
Resize operation completed for file# 201, old size 87040K, new size 88064K
Resize operation completed for file# 201, old size 88064K, new size 89088K
Resize operation completed for file# 201, old size 89088K, new size 90112K
Resize operation completed for file# 201, old size 90112K, new size 91136K
Resize operation completed for file# 201, old size 91136K, new size 92160K
2019-05-04T14:54:15.083241+08:00
Resize operation completed for file# 201, old size 92160K, new size 93184K
Resize operation completed for file# 201, old size 93184K, new size 94208K
Resize operation completed for file# 201, old size 94208K, new size 95232K
Resize operation completed for file# 201, old size 95232K, new size 96256K
Resize operation completed for file# 201, old size 96256K, new size 97280K
Resize operation completed for file# 201, old size 97280K, new size 98304K
Resize operation completed for file# 201, old size 98304K, new size 99328K
Resize operation completed for file# 201, old size 99328K, new size 100352K
Resize operation completed for file# 201, old size 100352K, new size 101376K
Resize operation completed for file# 201, old size 101376K, new size 102400K
Resize operation completed for file# 201, old size 102400K, new size 103424K
Resize operation completed for file# 201, old size 103424K, new size 104448K
Resize operation completed for file# 201, old size 104448K, new size 105472K
Resize operation completed for file# 201, old size 105472K, new size 106496K
Resize operation completed for file# 201, old size 106496K, new size 107520K
Resize operation completed for file# 201, old size 107520K, new size 108544K
Resize operation completed for file# 201, old size 108544K, new size 109568K
Resize operation completed for file# 201, old size 109568K, new size 110592K
Resize operation completed for file# 201, old size 110592K, new size 111616K
Resize operation completed for file# 201, old size 111616K, new size 112640K
Resize operation completed for file# 201, old size 112640K, new size 113664K
2019-05-04T14:54:16.085848+08:00
Resize operation completed for file# 201, old size 113664K, new size 114688K
Resize operation completed for file# 201, old size 114688K, new size 115712K
Resize operation completed for file# 201, old size 115712K, new size 116736K
Resize operation completed for file# 201, old size 116736K, new size 117760K
Resize operation completed for file# 201, old size 117760K, new size 118784K
Resize operation completed for file# 201, old size 118784K, new size 119808K
Resize operation completed for file# 201, old size 119808K, new size 120832K
Resize operation completed for file# 201, old size 120832K, new size 121856K
Resize operation completed for file# 201, old size 121856K, new size 122880K
Resize operation completed for file# 201, old size 122880K, new size 123904K
Resize operation completed for file# 201, old size 123904K, new size 124928K
Resize operation completed for file# 201, old size 124928K, new size 125952K
Resize operation completed for file# 201, old size 125952K, new size 126976K
查看了下MOS,发现有篇文章
Resize Operation Completed For File# 201; FILE# Does Not Exist (文档 ID 2246369.1)
里面提到,这是一个bug ,虽然这个bug在12.2.0.1中已经修复了(补丁包18603375 ),但是还是需要修改一个参数 。
关于为什么是201号文件,是这样说的 :
It's tempfiles and its number is generated dynamically based on parameter db_files - default value 200.
We have to subtract db_files value to get the file number in v$tempfile or db_files parameter value + tempfile# so in this case 201-200=1 is the tempfile#.
Apply patch 18603375 first, then set the below parameter along with the fix.
SQL> alter system set "_disable_file_resize_logging"=TRUE ; (Its default value is FALSE)
END
博主在查看alert log时,发现大量Resize operation completed for file# 201日志。检查发现表空间无问题,也不存在201文件,tempfile空间充足。查询MOS得知这是一个已修复的bug,但需修改参数。还解释了201号文件的由来。
2350

被折叠的 条评论
为什么被折叠?



