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 |
How to use "while" statements in oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What is different bet native dynamic sql and Dbms_Sql?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
What is the usage of save points in oracle database?
What is bulk collect in oracle?
Why we use bulk collect in oracle?
How to resolve the ORA-39133 error in Oracle?
What is a deadlock in SQL? How can you prevent it?
query to find the maximum no persons with same age(age colomn) from emp table
How to check the oracle tns settings?
Can we save images in a database and if yes, how?