ORA-40023: sufficient memory could not be allocated given the number of attributes ORACLE 报错 故障修复 远程处理

文档解释

ORA-40023: sufficient memory could not be allocated given the number of attributes

Cause: Unable to allocate sufficient memory to create a model capable of producing confidence bounds on predictions because there were too many attributes or there were high cardinality categorical attributes, or both, in the build data.

Action: Reduce the number of attributes, especially high cardinality categoricals, or enable ridge regression.

ORA-40023: sufficient memory could not be allocated given the number of attributes是Oracle数据库异常，表示无法根据属性数量分配足够内存。

官方解释

一般情况：ORA-40023 错误是由于内存不足的警告，它通常发生在做一些大操作或者执行复杂查询时，比如 SELECT COUNT(*) FROM XX 。

常见案例

select id, name, email, phone, address, create_user, create_time, update_user, update_times, deleted, deleted_time from orders;

一般处理方法及步骤

1、检查当前内存使用情况，如果发现内存不够用，则可以针对数据库及服务器基础设施采取一定的调整措施来增加内存；

2、如果内存充足，可以考虑修改Oracle数据库的参数，进一步增加内存分配，但必须慎重；

3、如果还是无法解决，建议把大量属性改为连接查询，或者根据具体情况做预先报表。