DEVFYI - Developer Resource - FYI

What is a temporary segment?

ORACLE Interview Questions and Answers (Part 4)

(Continued from previous question...)

712. 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.

(Continued on next question...)

Other Interview Questions