Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.
Temp segment are areas that would be used to perform temporary operation whenever required e.g sorting ordering and distinct....etc. It can be released once txn is completed.
To execute any program in Computer it needs memory area(RAM) Oracle allocates some memeory for processing SQL statement. After execution this memory is released for future use. This one call Temporary work area.
temporary segments are basically used for sort operations in oracle
when the user tries to execute the query through order by clause. so system needs an space for an sort operation and system will use temporary segments for this query.
