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 load data from external tables to regular tables?
How to convert times to characters in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
What is MTTR advisor in Oracle?
What is a server parameter file in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the differences between primary key and unique key?
material view and view disadvantages?
How to view existing locks on the database?
What is the difference between a vector and an Array? (Java)
How to find the duplicate rows count from employees table in oracle?