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.
Related posts
ORA-14452 attempt to create, alter or drop an index on temporary table already in use
ORA-00069 Cannot acquire lock — table locks disabled for %s
Oracle Database Internal Mechanism 