ORA-00057: maximum number of temporary table locks exceeded
Cause: The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.
.’
‘.
错误代码:ORA-00057
官方英文说明:”maximum number of temporary table locks exceeded”
中文说明:临时表锁的最大数量已经超过
常见情况:
解决步骤:
注意:如果释放或终止会话不能解决此问题,则可能需要更改数据库锁策略,以缩短事务锁定时间。
. ‘