ORA-27075: SSTMOFRC constant too large
Cause: internal error
Action: check for trace file and contact Oracle Support
ORA-27075: SSTMOFRC 代表 Single Session Transaction Multi-Objects Free Reclamation Criteria,因为输入的constant参数值过大,导致超出允许的最大值,所以报了该错误。
ORA-27075: SSTMOFRC constant too large
Cause: An attempt was made to set the binary SSTMOFRC constant to a value which is too large.
Action: Use a legal SSTMOFRC constant.
使用ALTER SYSTEM设置SSTMOFRC参数的值大于系统许可的最大值时可能会出现该错误。
1.使用show parameter sstm,确认SSTMOFRC的最大值;
2.使用ALTER SYSTEM指令重新设置参数值,使其符合最大值的要求;
3.如果还是报ORA-27075,重新检查参数值是否已经正确,如果是,则再次尝试重启database server。