What is a Temporary Segment ?

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.

Interview Candidate
Sep 5th, 2004
4
2105

Concepts and Architecture

Answer

Showing Answers 1 - 4 of 4 Answers

agarwalk_2000
Profile Answers by agarwalk_2000 Questions by agarwalk_2000

Mar 18th, 2006

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.

venkat_rolta
Profile Answers by venkat_rolta

Mar 19th, 2006

are used by oracle during table and index creation and for sorting as well as for temporary storage required for other operations such as hash joins

manu

Apr 6th, 2006

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.

manish hoiyani

Sep 14th, 2006

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.