TEMPOBJ

Description

This is a rare wait type. It accumulates when users are trying to access global temporary while it is being dropped elsewhere. Minimal values are acceptable but should be investigated

Resolved by

Developers

Suggested solutions

  1. It is generally best coding practice not to use global temporary tables as their behaviour can be non-determinist. Consider converting to regular temporary tables or a staging table

Additional research

Temporary Tables: Local vs. Global

⇐ Back to index