[20230306]oracle 19c alert日志日期格式设计不好的一个地方.txt

来源:这里教程网 时间:2026-03-03 18:28:51 作者:

[20230306]oracle 19c alert日志日期格式设计不好的一个地方.txt --//今天查看alert日志发现,alert日志看使用hugepage部分显示非常不合理.例子如下: 2022-07-06T18:25:53.254482+08:00 ************************************************************ Instance SGA_TARGET = 26752 MB and SGA_MAX_SIZE = 26702 MB ************************************************************ 2022-07-06T18:25:53.254827+08:00 ****************************************************  Sys-V shared memory will be used for creating SGA  **************************************************** 2022-07-06T18:25:53.299296+08:00 ********************************************************************** 2022-07-06T18:25:53.299390+08:00 Dump of system resources acquired for SHARED GLOBAL AREA (SGA) 2022-07-06T18:25:53.299545+08:00  Per process system memlock (soft) limit = UNLIMITED 2022-07-06T18:25:53.299639+08:00  Expected per process system memlock (soft) limit to lock  instance MAX SHARED GLOBAL AREA (SGA) into memory: 26G 2022-07-06T18:25:53.299889+08:00  Available system pagesizes:   4K, 2048K 2022-07-06T18:25:53.300094+08:00  Supported system pagesize(s): 2022-07-06T18:25:53.300180+08:00   PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s) 2022-07-06T18:25:53.300291+08:00         4K       Configured              10         5287274        NONE 2022-07-06T18:25:53.300542+08:00      2048K             3063           13377            3050        NONE 2022-07-06T18:25:53.300635+08:00 RECOMMENDATION: 2022-07-06T18:25:53.300713+08:00  1. For optimal performance, configure system with expected number  of pages for every supported system pagesize prior to the next  instance restart operation. 2022-07-06T18:25:53.306100+08:00 ********************************************************************** --//时间和信息混杂在一起很难查看,取消时间信息如下: 2022-07-06T18:25:53.254482+08:00 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ************************************************************ Instance SGA_TARGET = 26752 MB and SGA_MAX_SIZE = 26702 MB ************************************************************ ****************************************************  Sys-V shared memory will be used for creating SGA  **************************************************** ********************************************************************** Dump of system resources acquired for SHARED GLOBAL AREA (SGA)  Per process system memlock (soft) limit = UNLIMITED  Expected per process system memlock (soft) limit to lock  instance MAX SHARED GLOBAL AREA (SGA) into memory: 26G  Available system pagesizes:   4K, 2048K  Supported system pagesize(s):   PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)         4K       Configured              10         5287274        NONE      2048K             3063           13377            3050        NONE RECOMMENDATION:  1. For optimal performance, configure system with expected number  of pages for every supported system pagesize prior to the next  instance restart operation. ********************************************************************** --//实际上配置需要13377.如果整个这部分信息的输出仅仅一个时间戳在开头就可以了。 --//像上面的输出看上去实在太乱了。

相关推荐