[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.如果整个这部分信息的输出仅仅一个时间戳在开头就可以了。
--//像上面的输出看上去实在太乱了。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/267265/viewspace-2938357/ ,如需转载,请注明出处,否则将追究法律责任。