admin管理员组文章数量:1576390
昨晚的问题,虚拟机内存从32G调整到80G,我调整了sga+pga=60G时重启告警,也没到内存的80%,如下
2023-04-19T17:24:46.358167+08:00
PGA_AGGREGATE_TARGET specified is high
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_23724.trc (incident=320169):
ORA-00700: soft internal error, arguments: [pga physmem limit], [16106127360], [13721879347], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_320169/orcl_ora_23724_i320169.trc
LICENSE_MAX_SESSION = 0
查看了support,参考文档 Getting ORA-00700 Message when Starting the Database (Doc ID 2610312.1)
调小了pga,再次重启不再报错,改天好好研究下
官网建议
For example, the following settings can be used to startup the instance:
PGA_AGGREGATE_TARGET = 25% of 85% total memory
PGA_AGGREGATE_LIMIT = 50% of 85% total memory
SGA_TARGET = 50% of 85% total memory
-OR-
PGA_AGGREGATE_TARGET = 33% of 85% total memory
PGA_AGGREGATE_LIMIT = 67% of 85% total memory
SGA_TARGET = 33% of 85% total memory
版权声明:本文标题:ORA-00700: soft internal error 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://m.elefans.com/dongtai/1727798222a1130514.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论