Day: January 23, 2021

Monitor Temporary Tablespace Usage

Oracle database uses temporary tablespaces to improve the concurrency of multiple sort operations that do not fit in memory and can improve the efficiency of space management operations during sorts. Data created within this tablespace is transient and lasts only for the duration of the session/statment. It can store the following data: Intermediate sort resultsTemporary … Continue reading Monitor Temporary Tablespace Usage