ora-02097 ora-00093

问题

排查

数据库版本：19c

oerr ora 02097
02097, 00000, "parameter cannot be modified because specified value is invalid"
// *Cause: Though the initialization parameter is modifiable, the modified
//	   value is not acceptable to the parameter.
// *Action: Check the DBA guide for range of acceptable values for this
//	    parameter.

oerr ora 00093
00093, 00000, "%s must be between %s and %s"
// *Cause: The parameter value is not in a valid range.
// *Action: Modify the parameter value to be within the specified range.

问题：PGA_AGGREGATE_LIMIT的范围和什么有关系呢？？？

答案：processes参数

检查数据库processes值为128000

• pga_aggregate_limit 参数的测试