Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)