ITPub博客

首页 > 数据库 > Oracle > [20230306]oracle 19c alert日志日期格式设计不好的一个地方.txt

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

原创 Oracle 作者:lfree 时间:2023-03-06 20:49:28 0 删除 编辑

[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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    4006
  • 访问量
    7970383