[20230306]oracle 19c alert日誌日期格式設計不好的一個地方.txt

[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.如果整個這部分資訊的輸出僅僅一個時間戳在開頭就可以了。
--//像上面的輸出看上去實在太亂了。