这篇博客记录了在2019年1月21日对Oracle实例进行的参数调整，主要涉及到`parallel_max_servers`参数从160调整到135，以匹配`processes`参数的值150。此外，还详细说明了大型页面的启用状态、大小及请求大小，并展示了NUMA节点上的内存分配情况，但似乎在实际分配和请求之间存在不匹配的问题，同时在日志中出现了错误代码`ORA-00600`。
Mon Jan 21 13:36:20 2019
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Mon Jan 21 13:36:20 2019
Starting ORACLE instance (normal)
Mon Jan 21 13:36:20 2019
Large page enabled : 1
Mon Jan 21 13:36:20 2019
Large page size : 2097152
Large page request size : 4194304
Mon Jan 21 13:36:20 2019
Optimized NUMA large page alloction size : 8388608
Mon Jan 21 13:36:21 2019
Total Numa LP allocations : 0000000042800000
Req. Numa LP allocations : 0000000040000000
Mon Jan 21 13:36:21 2019
Numa LP Alloc on node: 0 alloc:0000000040000000 req:0000000040000000
Mon Jan 21 13:36:21 2019
Numa LP Alloc on node: 1 alloc:0000000000000000 req:0000000000000000
Mon Jan 21 13:36:21 2019
Numa LP Alloc on node: 2 alloc:0000000000000000 req:0000000000000000
Mon Jan 21 13:36:21 2019
Numa LP Alloc on node: 3 alloc:0000000000000000 req:0000000000000000
Mon Jan 21 13:36:21 2019
Errors in file d:\oracle\product\10.2.0\admin\szhdb\udump\szhdb_ora_5236.trc:
ORA-00600: internal error code, arguments: [SKGMINVALID], [6], [0], [0], [0], [], [], []
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
