What is a Temporary Segment ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
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.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / bijender singh
Temporary segements are created during the sorting
operation in the temporary tablespace and released after
the execution.
Is This Answer Correct ? | 1 Yes | 0 No |
What is the minimum client footprint required to connect c# to an oracle database?
Explain oracle 12c new features for developers?
Is rowid unique in oracle?
what is the output of select * from emp where null=null & select * from emp where 1=1
How do I know if oracle client is installed on windows?
What is use of oracle?
How you open and close a cursor variable.Why it is required?
Can we create more than one index on particular column?
What is snapshot is too old? Give and example for better understand.
How do I learn what codesets are available in oracle?
How to retrieve the count of updated rows?
how to retrieve daily sal from emp table in oracle 10g