1.

Explain About Temporary Segments?

Answer»

TEMPORARY Segments : When PROCESSING queries, ORACLE often requires temporary workspace for intermediate stages of SQL statement processing. Oracle AUTOMATICALLY allocates this DISK space called a temporary segment.Typically, Oracle requires a temporary segment as a work area for sorting. Oracle does not create a segment if the sorting operation can be done in memory or if Oracle finds some other way to perform the operation using indexes.

Temporary Segments : When processing queries, Oracle often requires temporary workspace for intermediate stages of SQL statement processing. Oracle automatically allocates this disk space called a temporary segment.Typically, Oracle requires a temporary segment as a work area for sorting. Oracle does not create a segment if the sorting operation can be done in memory or if Oracle finds some other way to perform the operation using indexes.


Discussion

No Comment Found

Related InterviewSolutions