我也发现同样问题,我装了一个测试库,偶尔用时发现无法switch log file.经检查发现是db_recovery_file_dest_size达到了设定的值.
于是,我就用logmnr分析了一个archivelog,发现
SEG_OWNER SEG_NAME HITS
---------- -------------------------------------------------- -------
SYS WRI$_ADV_USAGE 1
SYS SYS_TEMP_0FD9D6600_DD619E 1
SYS SCHEDULER$_WINDOW_DETAILS 1
SYS WRI$_OPTSTAT_OPR 1
SYS SCHEDULER$_WINDOW 2
SYS SCHEDULER$_GLOBAL_ATTRIBUTE 2
SYS ORA_TEMP_1_DS_1291 3
SYS ORA_TEMP_1_DS_1288 3
SYS ORA_TEMP_1_DS_1289 3
SYS ORA_TEMP_1_DS_1286 3
SYS ORA_TEMP_1_DS_1290 3
SEG_OWNER SEG_NAME HITS
---------- -------------------------------------------------- -------
SYS ORA_TEMP_1_DS_1287 3
SYS WRI$_SEGADV_CNTRLTAB 3
SYS WRH$_OPTIMIZER_ENV 3
SYS ORA_TEMP_1_DS_1294 3
SYS ORA_TEMP_1_DS_1293 3
SYS ORA_TEMP_1_DS_1292 3
SYS WRH$_THREAD