Oracle Database 12c New Features

ORA-00057: maximum number of temporary table locks exceeded

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.