Concepts and Architecture Question:

What is a Temporary Segment in Oracle?

Tweet Share WhatsApp

Answer:

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.

Download Oracle Architecture and Concepts PDF Read All 82 Oracle Architecture and Concepts Questions
Previous QuestionNext Question
What is Row Chaining in Oracle?What is an Index in Oracle?